Learn many of Excel’s advanced tools for analyzing and reporting on your data
Being able to use Microsoft Excel skillfully is crucial for all business professionals who use, analyze, and apply data. Excel is the most popular data analysis tool in the workplace, so increasing your understanding of its advanced features is both necessary and smart.
Excel expert Kathy Jones will show you how to make use of advanced features to summarize information, identify errors, apply conditional formatting, and find and assess information. She will also demonstrate how to best utilize available filtering and sorting techniques, including the new dynamic array functions. Learning to use these techniques will enable you to find information you need when analyzing either large or small data sets.
Since graphs greatly enhance your reports, you’ll learn how to add trendlines to charts to add a visual element to your forecasting and how to save time by creating custom templates that can be used repeatedly. You’ll also be able to create and modify important objects such as PivotTables, macros, and graphics.
Finally, if you’re looking to easily identify rankings or need to generate random numbers for inspections, this course will teach you how to use Excel to help you do it!
Topics covered include:
Over four hours of high-quality HD content in the “Uniquely Engaging”TM Bigger Brains Teacher-Learner style!
|4||Customizing the QAT||4:21|
|7||XLOOKUP, Part 1||6:32|
|8||XLOOKUP, Part 2||5:27|
|10||Multiple Criteria Functions||6:16|
|19||Data Validation Lists||8:52|
|20||Data Validation Messages and Invalid Data||5:54|
|26||Report Filter, Slicers, and Timelines||8:59|
|27||Run a Macro||6:44|
|32||Screenshots, Symbols, 3D Models||6:07|
|33||Format Graphics, Part 1||5:49|
|34||Format Graphics, Part 2||7:56|
|35||Manipulate Graphic Objects||5:38|
|38||Protecting Sheets and Workbooks||8:01|
|40||Protecting a Workbook File||8:23|
Fill out the information below to receive a download link for our latest course catalog.
Looking for eLearning content or other training solutions for your company? Let us know how we can help!