Excel FastTrack: Master the Basics (March) December 11, 2017

Learn real-world Excel applications and features that will immediately boost your productivity, increase your efficiency and get your job done quicker! 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 2013, and be given on a PC.

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

Excel FastTrack: Intermediate (February) December 11, 2017

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 changing needs. Topics include analyzing or ranking data, working with text, creating charts, complex formulas, controlling data input, conditional formatting and pivot tables. Training will be based on Microsoft Excel 2013, and be given 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: Analyze Your Data December 11, 2017

The ability to analyze data is a powerful and increasingly sought after skill that helps you make better business decisions. This course covers the essentials of Excel’s built in tools that take collections of data and render it into meaningful charts, reports or summarized extracts. Discover the power of Excel pivots and slicers in action and how to effectively summarize data. Additionally, by incorporating Excel lookup formulas and tables, data can be aggregated and conditional formatting tools can be used to further visualize data.

PREREQUISITES: Excel Intermediate or strong working knowledge of Excel. If in doubt, please contact us.