# of Lessons
Learn many of Excel’s tools for analyzing and sharing your data.
Microsoft Excel is the most popular data analysis tool in the workplace, so using it effectively is a crucial skill for any business professional. In this course you’ll learn great tools to modify your data and refine your workbook. Excel expert Kathy Jones will also show you how to nest functions and modify and format charts. You’ll even learn to enhance your visualizations by adding sparklines, pictures, and SmartArt. And if you need to work with others, you’ll learn some of the tools available when sharing your workbooks, including comments, hyperlinks, track changes, and share options.
And if you need to know more about forecasting, you’ll learn how to conduct What-If analysis using Excel’s special features.
Topics covered include:
Over three and a half hours of high-quality HD content in the “Uniquely Engaging”TM Bigger Brains Teacher-Learner style!
|3||Text to Columns||5:32|
|4||Find and Replace||9:08|
|5||Sort and Filter||6:09|
|6||Proofing and Researching Tools||7:22|
|9||Freeze and Split Windows||6:47|
|12||Custom Number Formats||9:33|
|13||Conditional Formatting for Text and Dates||4:40|
|14||Comparative Analysis with Conditional Formatting||5:02|
|15||Customizing Conditional Formatting||7:55|
|16||Functions in Conditional Formatting||4:59|
|27||Summarizing Data in Tables||4:36|
|31||Compare and Merge||4:01|
|33||Share a Workbook||4:21|
|36||Forecasting with Data Tables||5:44|
|37||Analyze Data Tool||2:27|
Related Course Recommendations: