Available Courses

  • Live, Instructor-Led Online Course for Individuals
  • Private Group Onsite or Live Online Course For Teams
  • Self-paced eLearning Course for Individuals

In this Microsoft Excel Introduction Training course, students will learn how to create worksheets in Microsoft Excel, how to use formulas and perform calculations, how to format cells and worksheets, how to setup worksheets for printing and how to export data from Excel to various other formats, including PDF. This course assumes no prior experience with Excel and is a great starting point for those who are new to the program or for those who…

In this Microsoft Excel Intermediate Training class, students will learn how to build on their Excel skills by using named ranges in Excel, inserting Excel Functions such as IF and SUMIF, using comparison operators such as AND, OR and NOT and using Date Functions such as DATE and NOW. In addition, students will see how to manipulate text using Text Functions like UPPER, LOWER and CONCATENATE. Students will also learn about using Lists in Excel…

In this Microsoft Excel Advanced training course, students will learn how to use features in Excel to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply complex formulas and functions. Students will see how to create Links and External References to Worksheets and Workbooks, use Lookup functions like VLOOKUP and HLOOKUP, and watch and evaluate formulas to find and fix logic errors. Students will also learn how to…

In this Microsoft Excel 2016 VBA Training course, students will learn to use VBA in Excel to create interactive worksheets and automate common worksheet tasks. Students will see how to generate VBA code from existing macros, gain an understanding of the different parts of the Visual Basic Editor, learn how code is organized in Projects, Modules and Procedures and become familiar using Objects, Properties and Methods in their code. In addition, this course teaches students…

Power Pivot is a powerful data exploration tool based on in-memory computing technologies that provides unmatched analytical performance to process billions of rows almost instantaneously. In this Microsoft Excel Power Pivot Training course, students will learn how to use Power Pivot to import and manipulate data, create Power Pivot reports, use DAX functions, create key performance indicators (KPI) and use slicers to enhance the visualization of data.