Microsoft® Excel VBA Level I: Macros
Virtual LiveMicrosoft® Excel VBA: Macros 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 […]
Microsoft® Excel VBA Level 2: Variables and Constants
Virtual LiveMicrosoft® Excel VBA: Variables and Constants will delve deeper into the core components of the Visual Basic language. The internal framework of code structure will be discussed, including objects, properties, […]
Administrative Microsoft® Excel
Virtual LiveAdministrative Microsoft® Excel will demonstrate to the power user how to edit spreadsheets for both individual and group use. Featured topics included validating data, applying various levels of protection, sharing […]
Microsoft® Excel Advanced Formulas: Logical Functions
Virtual LiveMicrosoft® Excel Advanced Formulas: Logical Functions course will demonstrate how to use conditional formulas namely in the Logical category. In addition, aggregate functions with testing conditions will be featured. This […]
Microsoft® Excel Tips & Tricks
Virtual LiveMicrosoft® Excel Tips & Tricks will demonstrate to the user how to use effective techniques for viewing large worksheet data, hiding data, using paste special and Go To, and using […]
Microsoft® Power BI: Part 2
Virtual LiveMicrosoft® Power BI: 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 […]
Microsoft® Excel Data Lists and Tables
Virtual LiveMicrosoft® Excel Data Lists and Tables will expose the user to the use of data lists and tables where both simple and complex sorting is involved. They will also work […]
Microsoft® Excel PivotTables
Virtual LiveMicrosoft® Excel PivotTables will demonstrate to the Excel user how to create and use list and table data to create analytical Pivot Tables. This will include an exploration of both […]
Microsoft® Excel Advanced Formulas: Lookup Functions
Virtual LiveMicrosoft® Excel Advanced Formulas: Lookup Functions will demonstrate to the user how to use formulas that extend across multiple worksheets as well as exploring the deeper function category Lookup and […]
Extreme Microsoft® Excel: Functions and Features for the Power User
Virtual LiveExtreme Microsoft® Excel: Functions and Features for the Power User is designed for individuals with a high level of aptitude in using Excel functions and formulas. The function categories range […]
Microsoft® Excel Pivot Tables
Virtual LiveMicrosoft® Excel PivotTables will demonstrate to the Excel user how to create and use list and table data to create analytical Pivot Tables. This will include an exploration of both […]
Microsoft® Excel Basic Formulas
Virtual LiveThe Basic Formulas class will acquaint the user with an overview of Excel formulas where cell addresses are featured for effective formula copying. Relative vs. absolute referencing is discussed and demonstrated as […]