The following sessions can be delivered as a half-day, one-day, or two-day seminars. The content can be totally customized based on your requirements and/or budget.

Microsoft Excel: The Basics

  • Introduction of the Excel screen
  • Data entry time saving techniques
  • Keyboard shortcuts
  • No more Cut & Paste; how to add, copy and move, data in a worksheet.
  • Formulas and Functions; what's the difference?
  • The five popular functions in Excel.
  • Jazzing up your data; formatting, styles and more.
  • Sort, Hide, Filter and Subtotal your data.
  • Inserting graphics; pictures, logos, shapes and SmartArt.

Microsoft Excel: Advanced Skills

  • An in-depth look at PivotTables, PivotCharts, Slicers and more.
  • PivotTables and the Data Model.
  • Consolidating data and building relationships to create PivotTables.
  • An in-depth look at nested functions; IF(VLOOKUP), IF(AND), IF(OR), SUM(IF), SUM(PRODUCT), INDEX(MATCH) and many many more.




Microsoft Excel: Power Query

  • Microsoft Excel's new tool





Microsoft Excel: Intermediate

  • Exploring the File tab
  • The Sum function
  • Absolute and Relative cell referencing
  • Conditional Formatting
  • Working with Data Ranges versus Tables
  • An introduction to functions: date, time, text
  • The many uses of the IF and VLOOKUP functions
  • The Advanced Filter
  • Data Validation
  • An introduction to PivotTables and PivotCharts

Microsoft Excel: PivotTables and beyond.

  • What is a PivotTable
  • Preparing the data
  • Creating a simple PivotTable
  • Design and Analyze the PivotTable
  • Calculating formulas in a PivotTable
  • Creating PivotCharts