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 […]
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 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 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 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 […]
Microsoft® Excel Advanced Formulas: Lookup Functions
Virtual LiveThis 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 […]
Microsoft® Excel 2016 Crash Course: Learn Excel in Two Days!
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 […]
Administrative Microsoft® Excel
Virtual LiveIMPORTANT 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 […]
Microsoft® Excel 2016: Data Analysis With PowerPivot
Virtual LiveMicrosoft® 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 […]
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 2016 Crash Course: Learn Excel in Two Days!
Virtual LiveThis 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 […]
The Path to PMP® Certification Free Webinar
Virtual LiveTake 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, […]
The Path to PMP® Certification Free Webinar
Virtual LiveTake 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, […]