Mastering Excel 365 - Intermediate (2025)
Mastering Excel 365 - Intermediate (2025)
Last updated 7/2025
Duration: 3h 23m | .MP4 1280x720 30 fps(r) | AAC, 44100 Hz, 2ch | 2.72 GB
Genre: eLearning | Language: English
Last updated 7/2025
Duration: 3h 23m | .MP4 1280x720 30 fps(r) | AAC, 44100 Hz, 2ch | 2.72 GB
Genre: eLearning | Language: English
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
- Use editing features such as Find and Replace, proofing options, and research tools to refine your workbook
- Modify workbook views
- Apply conditional formatting to text, numbers, and dates
- Apply custom number formatting
- Use nested, logical, and statistical functions
- Modify and format charts
- Add sparklines, pictures, and SmartArt
- Modify Tables, PivotTables, and web queries
- Share workbooks
- Use tools to enhance sharing such as hyperlinks and comments
- Analyze data with Goal Seek and Data Tables
Requirements
- Having basic Excel skills will support your progress throughout the course.
Description
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, 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:
Using 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 and comments
Analyzing data with Goal Seek and Data Tables
Enjoy award winning HD content in the “Uniquely Engaging”TM Bigger Brains Teacher-Learner style!
Who this course is for:
- If you're familiar with performing basic tasks in Excel and want to learn more, this course is for you.
More Info