Enjoying the preview?
This is the free first lesson. Get full access — request a demo or sign in.
Microsoft Excel 365 Advanced
Pivot Tables, Data Analysis and Data ManagementPreview the first lesson free — get full access to all 29 lessons.
Advanced Provider : Steve Paulick 8 chapters · 29 Lessons · 2h 52m in Arabic, German, English, Spanish, French, Portuguese, Thai, Chinese
Course Description
Continue to dive into the advance skills of Excel 365. This course will offer more detailed skills in pivot tables, data management and exchanging Excel data with other programs. After finishing this course you will be well versed in how to use Microsoft Excel 365 in any situation.
What You'll Learn
- Create, edit, and use macros to automate tasks in Excel 365
- Build and manipulate pivot tables, including grouping by date, time, and other factors
- Apply slicers and pivot charts to summarize and visualize data
- Use Goal Seek, Solver, Scenario Manager, and Data Tables for what-if analysis
- Manage data with tables by sorting, filtering, splitting columns, Flash Fill, and removing duplicates
- Exchange Excel data with other programs by embedding, linking, and importing objects
Key Takeaways
- This course covers advanced Excel 365 skills, building on prior Excel knowledge.
- It provides detailed instruction in pivot tables, data management, and exchanging Excel data with other programs.
- Learners practice creating and editing macros, outlining and subtotaling data, and using validation tools.
- The course includes data analysis tools such as Goal Seek, Solver, and Scenario Manager.
- On completion, learners will be well versed in using Microsoft Excel 365 in any situation.
Frequently Asked Questions
Who is this course for?
It is for learners who want to continue building advanced skills in Excel 365, offering more detailed skills in pivot tables, data management, and exchanging Excel data with other programs.
What topics does the course cover?
It covers creating, editing, and using macros, pivot tables and pivot charts, slicers, lists, outlining and subtotaling data, Goal Seek, Solver, Scenario Manager, data tables, sorting and filtering with tables, splitting data into columns, Flash Fill, removing duplicate records, validation tools, and embedding, linking, and importing objects to and from Excel.
What skills will I gain from this course?
You will gain skills in Microsoft Excel, Data Management, and Microsoft Office 365.
What will I be able to do after finishing the course?
After finishing this course you will be well versed in how to use Microsoft Excel 365 in any situation.
