Spreadsheet
Microsoft Excel is North America’s most popular spreadsheet application. Use it to perform complex analyses of your data using Charts, Pivot Tables and Conditional Formatting. We offer several different levels of Microsoft Excel training! From novice to expert, we can help. We will happily combine portions of each level into a custom course to meet your needs.
See our Scheduled Excel courses here.
Microsoft Excel 2019 Courses:
Excel 2019 Level 1 Course Content (PDF File)
Excel 2019 Level 2 Course Content (PDF File)
Excel 2019 Level 3 Data Management Course Content (PDF File)
Excel 2019 Level 3 Spreadsheet Analysis Course Content (PDF File)
Excel 2019 VBA Macros Course Content (PDF File)
Microsoft Excel 2016 Courses
Excel 2016 Level 1 Course Content (PDF file)
Excel 2016 Level 2 Course Content (PDF file)
Excel 2016 Level 3 Data Management Course Content (PDF file)
Excel 2016 Level 3 Spreadsheet Analysis Course Content (PDF file)
Excel 2016 VBA Macros Course Content (PDF file)
Microsoft Excel Advanced Concepts
Introduction to Power Pivot, Power Query and DAX
Power Pivot is a data modeling technology that lets you create data models, establish relationships, and create calculations. With Power Pivot you can work with large data sets, build extensive relationships, and create complex (or simple) calculations (DAX), all in a high-performance environment, and all within the familiar experience of Excel. Power Query is a data connection technology that enables you to discover, connect, combine and refine data sources to meet your analysis needs. Features in Power Query are available in Excel and Power BI Desktop.
Introduction to Power Pivot, Power Query & DAX (PDF file)
Introduction to Microsoft Power BI
Power BI is a suite of business analytic tools that deliver insights throughout your organization. Connect to hundreds of data sources, simplify data prep, and drive ad hoc analysis. Produce beautiful reports, then publish them for your organization to consume on the web and across multiple devices. Everyone can create personalized dashboards with a unique, 360-degree view of their business. Scale across the enterprise, with governance and security built-in. (https://powerbi.microsoft.com/en-us/)