Events

The Path to PMP® Certification Free Webinar

Virtual Live

Take your project management skills to the next level with the PMP certification, a gold standard recognized for its emphasis on competent leadership and team direction. This credential not only solidifies your existing skills but also makes you a preferred choice for employers, providing a boost to your earnings. To guide you on this journey, […]

Free

The Path to PMP® Certification Free Webinar

Virtual Live

Take your project management skills to the next level with the PMP certification, a gold standard recognized for its emphasis on competent leadership and team direction. This credential not only solidifies your existing skills but also makes you a preferred choice for employers, providing a boost to your earnings. To guide you on this journey, […]

Free

Microsoft® Excel 2016 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 […]

$395.00

Microsoft® Excel VBA Level I: Macros

Virtual Live

Microsoft® 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 […]

$99.00
Recurring

Microsoft® Excel 2016: Data Analysis With PowerPivot

Virtual Live

Microsoft® Excel 2016: Data Analysis With PowerPivot involves the creation of advanced Pivot Tables in Microsoft Excel® using the add-in program, Power Pivot. Data analysis in Excel is limited to using data list or table sources constructed as flat-file databases. With Excel being a spreadsheet program and not a relational database, trying to connect to […]

$395.00

Microsoft® Power BI: Part 2

Virtual Live

Microsoft® 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 […]

$199.00

Administrative Microsoft® Excel

Virtual Live

IMPORTANT INFORMATION FOR CPAS ABOUT PARTICIPATION: As part of our sponsorship with NASBA, we have agreed to provide at least three (3) instances of engagement per CPE hour (50 minutes). These may come in the form of open-ended questions, hand-raising, polling, and other techniques. You MUST answer or respond to all three opportunities to engage […]

$99.00

Microsoft® Excel Advanced Formulas: Lookup Functions

Virtual Live

This more advanced Excel course 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 course […]

$99.00

Microsoft® Excel Basic Formulas

Virtual Live

The 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 well as exposure to general formula functions such as SUM, AVERAGE, MAX, MIN, and COUNT. The user will also be shown various Date functions such […]

$99.00

Microsoft® Excel Pivot Tables

Virtual Live

Microsoft® 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 […]

$99.00
Recurring

Extreme Microsoft® Excel: Functions and Features for the Power User

Virtual Live

Extreme 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 […]

$395.00