Excel 2011 Advanced

This training course teaches you how to utilize advanced features and functions of Excel 2011, allowing you to customize your settings, create advanced charts, and perform complex analyses. To begin, you’ll learn to create custom templates and set custom formatting to your worksheets to save you time. Next, you’ll learn advanced charting techniques, and you’ll discover sophisticated methods of sorting and filtering data and creating a criteria range. You’ll review how to create outlines, both manually and automatically, and you’ll learn about linking your worksheets and consolidating those using formulas. By the end of the course, you’ll be able to analyze your data by creating scenarios and generating scenario reports and know how to check your spreadsheets for errors and protect your important data.
This course is approximately 2 hour in length and is part of our series on Excel 2011. It includes with engaging audio and helpful step-by-step instructions to help you improve your productivity and optimize your Excel experience.