Learn many of Excel’s tools for analyzing and sharing your data.
Learn many of Excel’s tools for analyzing and sharing your data.
What you’ll learn
- Use Flash Fill, Text to Columns, and Group Mode to work with your data.
- Modify workbook views.
- Apply custom number formatting.
- Modify and format charts.
- Analyze data with Goal Seek and Data Tables.
- Share workbooks.
- Use nested, logical, and statistical functions.
Course Content
- Editing –> 8 lectures • 47min.
- Workbook Views –> 3 lectures • 17min.
- Formatting –> 5 lectures • 32min.
- Functions –> 3 lectures • 23min.
- Charts and Graphics –> 5 lectures • 26min.
- Tables and PivotTables –> 5 lectures • 25min.
- Sharing –> 5 lectures • 24min.
- Data Analysis –> 2 lectures • 11min.
Requirements
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. 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.
If you need to know more about forecasting, you’ll learn how to conduct a What-If analysis using Excel’s special features.
Topics covered include:
- Use Flash Fill, Text to Columns, and Group Mode to work with your data
- Using editing features such as Find and Replace, proofing options, and research tools to refine your workbook
- Modifying workbook views
- Applying conditional formatting to text, numbers, and dates
- Applying custom number formatting
- Using nested, logical, and statistical functions
- Modifying and formatting charts
- Adding sparklines, pictures, and SmartArt
- Modifying Tables, PivotTables, and web queries
- Sharing workbooks
- Using tools to enhance sharing such as hyperlinks, track changes, and comments
- Analyzing data with Goal Seek and Data Tables
Almost three and a half hours of high-quality HD content in the “Uniquely Engaging”TM Bigger Brains Teacher-Learner style!