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