course

Home / Courses / Microsoft Excel for Office 365 (Desktop or Online)(v1.1): Part 3

Course Objectives

Upon successful completion of this course, you will be able to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality. You will:

  • Work with multiple worksheets and workbooks. Share and protect workbooks. Automate workbook functionality. Use Lookup functions and formula auditing. Forecast data. Create sparklines and map data.

Agenda

  • Topic A: Use Links and External References
  • Topic B: Use 3-D References
  • Topic C: Consolidate Data

  • Topic A: Collaborate on a Workbook
  • Topic B: Protect Worksheets and Workbooks

  • Topic A: Apply Data Validation
  • Topic B: Search for Invalid Data and Formulas with Errors
  • Topic C: Work with Macros

  • Topic A: Use Lookup Functions
  • Topic B: Trace Cells
  • Topic C: Watch and Evaluate Formulas

  • Topic A: Determine Potential Outcomes Using Data Tables
  • Topic B: Determine Potential Outcomes Using Scenarios
  • Topic C: Use the Goal Seek Feature
  • Topic D: Forecast Data Trends

  • Topic A: Create Sparklines
  • Topic B: Map Data
Tags
Vendor: Logical Operations Applications Core Type: Core 1 Product Line: Microsoft Applications LoD Tier: 1
FREE

Interested in course?


Course Type: Instructor Led