Enjoying the preview?
This is the free first lesson. Get full access — request a demo or sign in.
Microsoft Office 2021: Excel Advanced
Learn advanced skills and troubleshooting for Microsoft Excel.Preview the first lesson free — get full access to all 23 lessons.
Advanced Provider : Bob Akbar 9 chapters · 23 Lessons · 1h 44m in English
Course Description
In this MS Office 2021 Excel course, you will discover how to use advanced formulas and functions, automate functions to better handle your data for analysis, and create and rank values. We’ll also cover collaboration with colleagues, customizing menus, and advanced security features. You’ll learn about the power of manipulating data strings, which allow for calculations that aren’t normally possible.
Find out how a “What-If” analysis combines skills related to queries, filters, and pivots, using them to better understand how a data set will behave, given certain adjustments. We’ll then discuss how to rank and group your data to look for trends or correlations, helping you to find values you’re looking for by plugging in different variables and comparing the results. By the end of this course, you’ll know which values are most useful for understanding your data, allowing you to Excel to its full potential.
What You'll Learn
- Apply advanced functions to manipulate data, including text-string functions like Left, Mid, Right, Concatenate, and Index
- Automate and analyze data using Power Queries, Auto Filters, and Pivot Tables
- Predict how a data set will behave using What-If analysis tools such as Scenario Manager, Goal Seek, and Data Tables
- Rank and group data with the Rank Function, Rank Charts, and Percentiles to find trends and correlations
- Collaborate with colleagues through coauthoring, multiple users, sharing to notes, and exporting to other Microsoft Office software
- Secure data using advanced features such as limiting data values, scrambling data, hiding data, and encrypting content
Key Takeaways
- Advanced formulas and functions can be automated to better handle data for analysis and to create and rank values.
- Manipulating data strings allows for calculations that are not normally possible.
- A What-If analysis combines queries, filters, and pivots to understand how a data set will behave given certain adjustments.
- Ranking and grouping data helps reveal trends or correlations by plugging in different variables and comparing results.
- Excel supports collaboration through coauthoring, multiple users, and customizing menus, along with advanced security features.
Frequently Asked Questions
What will I learn in this advanced Excel course?
You will learn to use advanced formulas and functions, automate functions for data analysis, create and rank values, perform What-If analysis, collaborate with colleagues, customize menus, and use advanced security features.
What is the What-If analysis covered in this course?
The What-If analysis combines skills related to queries, filters, and pivots to better understand how a data set will behave given certain adjustments. It is covered through lessons on Scenario Manager, Goal Seek, and Data Tables.
Does this course cover collaboration and data security?
Yes. It covers collaboration with colleagues through coauthoring, multiple users, sharing to notes, and exporting to other Microsoft Office software, as well as advanced security features such as limiting data values, scrambling data, hiding data, and encrypting content.
What skills does this course build?
This course builds skills in Collaboration, Microsoft Excel, Data Analysis, and Excel Formulas.
How does the course help with ranking data?
The course explains the ranking function and how it works, and covers ranking and grouping data through lessons on the Rank Function, Rank Charts, and Percentiles to help find trends or correlations.
