Excel FastTrack: Intermediate August 8, 2019

Move beyond the basics of Excel and increase your productivity and efficiency even more! This one-day, hands-on workshop will help you develop an Excel toolkit of techniques and everyday solutions to create robust spreadsheets that easily adapt to your needs. Topics include analyzing or ranking data, working with text, generating charts, using complex formulas, controlling data input, applying conditional formatting and creating pivot tables. Training will be based on Microsoft Excel 2016 on a PC.

PREREQUISITES: Excel FastTrack: Master the Basics or equivalent.

AoA thumbnail-digital
This course can be applied toward an Award of Achievement in Bookkeeping.

Excel FastTrack: Master the Basics August 8, 2019

Learn real-world Excel applications and features that will immediately boost your productivity and increase your efficiency! This one-day, hands-on workshop shows you how to turn raw data into meaningful results to be shared with your co-workers by using basic Excel features. Topics include entering and editing data, applying formulas to compute results and validate data, key functions and how to format data in data cells and worksheets. Training will be based on Microsoft Excel 2016 on a PC.

AoA thumbnail-digital
This course can be applied toward an Award of Achievement in Bookkeeping.

The Power of Knowing: Power BI Data Visualization and Analysis August 8, 2019

This course is ideal for business professionals who need to understand business-related data and extract usable insight from the numbers. By course end, you will be able to create, import, model, transform and visualize data through either standalone reports or information dashboards using Power BI desktop. You will also understand the steps for publishing reports to Microsoft’s powerbi.com cloud platform.