MS Excel 1

About Level 1

In This Course, Learn About:   

Calculations, Charts, Create workbooks, Enter and revise data, Excel Mobile Apps, Excel Online, Find and replace data, Formatting, Formulas, Graphics, Modify workbooks, Modify worksheets, Printing, Set up a workbook, Sparklines.

Power Player 1

  • Introduction to Excel
  • Creating and location documents
  • Editing Text & Formulas
  • Basic Formulas (Automating Calculations)
  • Editing Worksheets Structure
  • Formatting Data
  • Inserting Images
  • Charts & Graphs
  • Engaging Your Audience with Visual Presentation
  • Using Templates

MS Excel 2

About Level 2

In This Course, Learn About: Analyze alternative data sets, Collaborate with colleagues, Combine data from multiple sources, Manage worksheet data, Perform calculations on data, Reorder and summarize data.

Power Player 2

  • Using List
  • List Functions
  • Data Validations
  • Importing and Exporting Data
  • Pivot tables
  • Using PowerPivotTools
  • Working W/Large Sets of Data

MS Excel 3

About Level 3

In This Course, Learn About: Advanced tasks in Microsoft Excel 2016. Alternative Data Sets, Dynamic Worksheets with PivotTables, Automating Repetitive Tasks with Macros, Working with Other Microsoft Office Apps, Business Intelligence Analysis and Forecasts and Visualizations.

Power Player 3

  • Excel's Conditional Functions
  • Lookup Functions
  • Text Based Functions
  • Auditing Worksheets
  • Protecting Worksheets and Workbooks
  • Mastering Excel 'What If?" Tools
  • Automate Repetitive Tasks with Macros

MS Excel 4

About Level 4

In This Course, Learn About: This Excel VBA Programming course is designed to give experienced Microsoft Excel 2013/2016 users proficiency in creating procedures that run in response to specific events, working with control structures, developing user forms to accept or display data, validating the data entry in user forms, debugging and handling errors in code, and much more! tasks in Microsoft Excel 2016. Alternative Data Sets, Dynamic Worksheets with PivotTables, Automating Repetitive Tasks with Macros, Working with Other Microsoft Office Apps, Business Intelligence Analysis and Forecasts and Visualizations.This Excel VBA Programming course is designed to give experienced Microsoft Excel 2013/2016 users proficiency in creating procedures that run in response to specific events, working with control structures, developing user forms to accept or display data, validating the data entry in user forms, debugging and handling errors in code, and much more!

Power Player 3

  • Case 1 - Using Macro Recorder Tool
  • Case 2 - Beyond Basic Using VBA
  • Case 3 -  Preparing and Formatting Data With VBA
  • Case 4 - Using Visual Basics Applications to Excel Formulas
  • Case 5 - Bringing it Together: Creating a Weekly Report
  • Case 6 - Visual Basics Applications and User Forms