Microsoft® Excel Charts
Virtual LiveMicrosoft® Excel Charts will demonstrate to the Excel user how to create effective charts off of spreadsheet data. A discussion of chart basics will be featured along with the creation of column charts, pie charts, three-dimensional charts, and a variety of chart formatting techniques. The user will also be exposed to more advanced charting such […]
Microsoft® Power BI: Part 1
Virtual LiveObjective: Upon successful completion of this course the user will be able to navigate the Power BI interface, explore data diagrams, model and query data. Description: This course is designed for individuals with a high level of aptitude in using data collection and storage programs, namely Excel and or Access. It is highly beneficial that the user […]
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 be used to create the base code that will be edited using coherent VB fundamentals. Objective: Upon completion of this course the user will be […]
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, and methods. The user will also be exposed to variable and constant declaration as well as the scope and lifetime of those variables. This course […]
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 workbooks for collaboration, and working with formula links. The user will also be exposed to various auditing and analysis tools including features such as Goal […]
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 course will also expose the user to mixed cell referencing as well as how to create array formulas. Objective: Upon completion of this course the […]
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 a variety of fills. This will also include how to effectively navigate through a spreadsheet using named ranges and hyperlinks, using styles, along with a […]
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 to external data sources, working with data relationships, creating calculations, and developing visualizations for analytical review. LESSON 1: ANALYZING DATA WITH VISUALIZATIONS CREATING VISUALIZATIONS Clustered […]
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 with a variety of filters and learn how to create subtotals on their data. In addition, the user will create table field formulas and use […]
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 one and two-dimensional Pivot Tables, feature data filtering and slicers, as well as creating Pivot Charts. The user will also be exposed to using external […]
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 Reference. These will include such lookup functions as HLOOKUP and VLOOKUP, where mixed-cell referencing is featured in formulas as well as using named ranges. This […]
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 from Math and Trig, Date and Time, Text, Lookup and Reference, Statistical, Financial, Logical, and Information. Power users will create several business profitability formulas and […]