Enjoying the preview?
This is the free first lesson. Get full access — request a demo or sign in.
Microsoft Office 2021: Excel Intermediate
Learn intermediate skills and common troubleshooting for Microsoft ExcelPreview the first lesson free — get full access to all 23 lessons.
Intermediate Provider : Bob Akbar 9 chapters · 23 Lessons · 1h 32m in Arabic, German, English, Spanish, French, Portuguese, Chinese
Course Description
By understanding the build functions of Excel, the intermediate user can automate, adjust, revise, and present data in an improved manner over the beginner-level user. This enables the intermediate user to understand securities, options, and common reasons why errors occur. This course also includes tips for presentations, from visual aid preparation to media expectations and printing outputs. Further included are tips to assist you in using Excel to achieve the best results in data security and protection.
When understanding how Excel functions with this new deeper understanding, then you can use this knowledge to generate better presentations and data analytics. This course explores how Excel sees, processes, sorts, and displays data. The examples in this course are selected to be presented in easy-to-understand steps, including the most common errors users encounter when using these functions. Upon completion of this course, you will be able to increase your productivity by better understanding how to store, analyze and output your data. You will further your understanding of common error issues, which will contribute to time savings, while printing options will provide environmentally friendly productivity.
What You'll Learn
- Combine multiple functions into a single formula
- Build formulas and use functions such as Mode, Median, Max, Min, and SumIf
- Assess graphs, charts, and their related options
- Recognize proper cell reference methodology and syntax, including references across sheets
- Identify securities and define data access for multiple users with password protection
- Prepare visual aids and configure print outputs such as print area, fit to page, and landscape versus portrait
Key Takeaways
- Intermediate Excel users can automate, adjust, revise, and present data more effectively than beginner-level users.
- Understanding how Excel sees, processes, sorts, and displays data enables better presentations and data analytics.
- The course covers common reasons errors occur, helping users save time by recognizing and addressing these issues.
- Print options and outputs are presented as a way to support environmentally friendly productivity.
- Examples are presented in easy-to-understand steps, including the most common errors users encounter with these functions.
Frequently Asked Questions
Who is this course for?
It is aimed at the intermediate Excel user who wants to move beyond beginner-level skills to automate, adjust, revise, and present data more effectively.
What topics does this course cover?
It covers formulas and functions (such as Mode, Median, Max, Min, and SumIf), display formats, conditional formatting, sorting and analyzing data, charts and graphs, inserting objects, spelling and thesaurus tools, search and replace, print setup (fit to page, print area, landscape versus portrait), cell references using sheets, and security and password protection.
What skills will I gain?
You will build skills in Microsoft Excel, Microsoft Office, spreadsheets, Excel formulas, Microsoft Office Accounting, and toward the Microsoft Office Specialist (MOS) - Excel certification.
How does this course help with data security?
It includes tips for using Excel to achieve the best results in data security and protection, covering security and password protection and defining data access for multiple users.
What will I be able to do after completing the course?
You will be able to increase your productivity by better understanding how to store, analyze, and output your data, and further your understanding of common error issues to save time.
