Mastering Excel 365: Intermediate

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 great tools available when sharing your workbooks, including comments, hyperlinks, and share options.

Topics covered are:

•  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
•  Apply conditional formatting to text, numbers, and dates
•  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

This course includes:

• Approximately 3 hours and 23 minutes of video lessons.
• Downloadable templates and resources to help you apply what you've learned.
• A quiz with multiple-choice questions to check your understanding.