Events

Microsoft® Excel: Data Lists and Tables with Pivot Tables

Virtual Live

This course will expose the user to the use of data lists and tables where both simple and complex sorting is involved. They will also work with a variety of filters and experience how to create subtotals on their data. In addition, the user will create table field formulas and use spreadsheet formulas that feature […]

Book Now $199.00

Microsoft® Excel Crash Course: Learn Excel in Two Days!

Virtual Live

This is a fast-paced course and is designed for those who have been using Excel (any version) at a basic level, as well as those who are self-taught and want to learn short cuts and tips, plus some of the more advanced features. Packed full of information, topics range from fundamentals (using shortcuts) through advanced […]

Book Now $399.00

Microsoft® Power BI for the Desktop User: Part 1

Virtual Live

Objective: Upon successful completion of this course the user will be able to navigate the Power BI interface, explore data diagrams, model and query data. Microsoft Power BI for the Desktop User:  Part I is course is designed for individuals with a high level of aptitude in using data collection and storage programs, namely Excel and […]

Book Now $199.00

Microsoft® Power BI for the Desktop User: Part 2

Virtual Live

Microsoft® Power BI for the Desktop User: Part 2 is designed to provide proficiency in modifying charts and graphs along with creating advanced formulas and functions. The Power BI program will involve the connection to external data sources, working with data relationships, creating calculations, and developing visualizations for analytical review. LESSON 1: ANALYZING DATA WITH […]

Book Now $199.00

Microsoft® Excel VBA Level I: Macros, Constants and Variables

Virtual Live

Microsoft® Excel VBA Level I: Macros, Constants and Variables is divided in two parts.  Part 1 will demonstrate to the user how to effectively coordinate macros along with exposing them to the basic foundations of Visual Basic programming. The macro recorder will be used to create the base code that will be edited using coherent […]

Book Now $199.00

Microsoft® Excel VBA Level 2: Branching, Looping & Custom Functions & Forms

Virtual Live

Microsoft® Excel VBA Level 2: Branching, Looping & Custom Functions & Forms will explore the programming capabilities of conditional branch constructs as well as repetitive looping structures. The builds will be cumulative, beginning with the core basics and expanding to include interactive message boxes to control program flow. In addition, basic error-trapping techniques will be […]

Microsoft® Excel Crash Course: Learn Excel in Two Days!

Virtual Live

This is a fast-paced course and is designed for those who have been using Excel (any version) at a basic level, as well as those who are self-taught and want to learn short cuts and tips, plus some of the more advanced features. Packed full of information, topics range from fundamentals (using shortcuts) through advanced […]

Book Now $399.00