Microsoft Office Excel 2013: Part 3 (Expert)

This Microsoft Office Excel 2013: Part 3 (Expert) course will build on your basic knowledge of Excel by teaching you some of the more specialized capabilities in Excel 2013. The comprehensive course begins by looking at ways of streamlining your workflow by automating repetitive tasks using macros and applying conditional formatting. Next, you’ll learn how to audit your workbooks to ensure complete accuracy and avoid mistakes from human error. Excel 2013 offers powerful means of analyzing your data, and in this course you’ll learn how to perform complex statistical analyses using sparklines and scenarios. You’ll also learn how to work effectively with multiple workbooks at the same time, as well as how to import and export your Excel data.

This 2-hour course is broken down into 5 lessons. Each section features engaging narration with easy-to-understand instructions and includes summaries and short quizzes to ensure comprehension.