1he1

Excel Level III

 

Power Moves

 

Suggested Prerequisites: Excel Levels I and II

Description: Welcome to Microsoft Excel Level III. This course is the third in a series of courses designed for individuals who will use Microsoft Excel as a tool to assist them in storing and analyzing numeric data. The topics in this course cover the critical skills necessary to perform advanced Excel features. The major topics covered in this course will include Advanced Functions, PivotTables, Worksheets, Consolidating Data, Analyzing Data, Protecting Data, Macros, and Import/Export Options.

Topics

 

Advanced Functions

  • Advanced IF Statements – Boolean Operators
  • Advanced IF Statements – Nested IF Statements
  • SumIF and More
  • The Auditing Tools
  • The IFERROR Statement

Using PivotTable Reports and Charts

  • Creating PivotTable Reports
  • Modifying PivotTable Reports
  • Creating a PivotCharts

Working with Multiple Worksheets

  • Linking Cells in Different Workbooks
  • Consolidating Data
  • Saving a Workspace

Analysis Tools

  • Using the Goal Seek Utility
  • Using the Scenario Manager

Introduction to Macros

  • Recording a Macro
  • Running a Macro
  • Turning a Macro into a Toolbar Button

Importing and Exporting Data

  • Export to Microsoft Word
  • Export a Text File to Any Software Environment
  • Export Data to a MS PowerPoint Presentation
  • Import a Word Table

Advanced Visual Enhancements

  • Conditional Formatting
  • Smart Art
Excel Level III
Tagged on:
Malcare WordPress Security