Data analytics

Speaker: Bryan Smith, CPA, CITP, CISA

This webcast introduces you to the relevant Excel data analysis tools and focuses on what you can do with your data once it is in Microsoft Excel. You will learn how to use Power BI various techniques to cleanse your data by removing errors, validating and standardizing data.

Excel

Speaker: Jeff Lenning, CPA, CITP

This video covers one of the most significant enhancements rolled out with Excel 2007, the table feature. It also covers named references and the five most important shortcuts so that you can improve your personal productivity.

Excel

Speaker: Jeff Lenning, CPA, CITP

This video finishes the PivotTable discussion by examining various ways to present report values, discussing the subtly of properly sorting a recurring-use PivotTable, and covering numerous filtering options, including slicers.