Advanced Excel

Advanced Excel

About The Course

As a professional in your field, you already know the benefits of using Microsoft Excel. There is a way to make it an even more powerful tool in the management of your business. Our Advanced Microsoft Excel training will give you a more efficient vision of your operation as well as improve your bottom line.

Total: 32 Hours
Duration: 2 months 

Module 1: Using Formatting and Functions

  • Applying Formatting to Numbers
  • Creating Custom Number Formats
  • Applying Conditional Formats
  • Using Formulas in Conditional Formats
  • Absolute and Relative References  Naming a Range
  • Using a Named Range in a Formula
  • Using Lookup Functions
  • IF Functions 

Module 2: Using Templates and Workbooks

  • Applying a Template
  • Using a Template
  • Creating a New Template
  • Editing a Template
  • Linking Between Workbooks
  • Importing Data from Text Files
  • Importing Data from Other Applications
  • Importing an HTML Table
  • Publishing Data to the Web

Module 3: Working with Data

  • What is a List?
  • Validating Data Entries
  • Sorting Data
  • Subtotaling and Outlining Data
  • Extracting Data with Filters
  • Using Advanced Filters
  • Using Query
  • Querying the Web
  • Using XML to Share Data

Module 4: Analyzing Data

  • Using PivotTable Add info about Slicers
  • Managing PivotTable Reports
  • Creating PivotChart Reports
  • Using Charts and Trendlines
  • Working with Scenarios 

Module 5: Using Macros and Auditing Tools

  • What is a Macro? 
  • Recording a Macro 
  • Running a Macro 
  • Editing a Macro 
  • Auditing Workbooks 
  • Tracing Errors

Module 6: Sharing Workbooks

  • Creating a Shared Workbooks 
  • Consolidating Data 
  • Protecting Columns 
  • Protecting Worksheets 
  • Protecting Worksheet Content 
  • Protecting Cells 
  • Assigning a Password 
  • racking Changes 
  • Adding Comments 
  • Preparing a Workbook 

Course Instructor