Enjoying the preview?
This is the free first lesson. Get full access — request a demo or sign in.
Microsoft 365: Excel Intermediate (2023)
Learn intermediate skills and common troubleshooting for Microsoft ExcelPreview the first lesson free — get full access to all 26 lessons.
Intermediate Provider : Bob Akbar 10 chapters · 26 Lessons · 3h 5m in Arabic, German, English, Spanish, French, Portuguese, Chinese
Course Description
To generate, manage, and display data efficiently, Excel 365 will provide the intermediate user the tools needed for professional and proficient data processing. Data entry efficiency and proper handling saves time. Presentations will stand out as the proper preparations are achieved in setting up and organizing the data. Intermediate users learn to properly reference their data to maximize both accuracy and efficiency.
This efficiency and proficiency are further enhanced by understanding where and when shortcuts, autofill, and built-in functions are best utilized. Dependent and independent cell references, also known as dynamic and static, are explained. Search tools save time and improve accuracy, especially when larger sets of data are generated. Chart and table formatting techniques will help you produce professional results to make the intermediate user stand out as proficient.
In this Microsoft 365 Excel Intermediate course, you will discover how to navigate, create files, input and organize data, and protect privacy. We’ll also discuss intermediate calculations and formulas. You will learn to be more efficient with shortcuts and provide better displays for your audience using charts and tables.
What You'll Learn
- Generate simple and complex workbooks, worksheets, and themes for efficient data processing
- Apply Excel customization, shortcuts, and autofill to speed up data entry and navigation
- Use proper data reference methods, including dependent (dynamic) and independent (static) cell references
- Organize and structure data with worksheets, range definitions, filtering, and data table structures
- Build and format charts and tables, including chart templates and table customization, for professional displays
- Work with formulas, functions, conditional formatting, data validation, and Pivot Tables (2023)
Key Takeaways
- Excel 365 gives intermediate users the tools to generate, manage, and display data efficiently for professional data processing.
- Efficient data entry and proper data handling save time, while proper preparation in setting up and organizing data makes presentations stand out.
- Proper data referencing maximizes both accuracy and efficiency, and the course explains dependent (dynamic) and independent (static) cell references.
- Shortcuts, autofill, and built-in functions improve efficiency when used in the right situations.
- Search tools and chart and table formatting techniques save time, improve accuracy on larger data sets, and produce professional results.
Frequently Asked Questions
Who is this course for?
It is designed for intermediate Excel users who want tools for professional and proficient data processing in Excel 365.
What will I learn to do in this course?
You will discover how to navigate, create files, input and organize data, protect privacy, work with intermediate calculations and formulas, use shortcuts, and create better displays with charts and tables.
Does the course cover cell references?
Yes. It covers proper data reference methods and explains dependent and independent cell references, also known as dynamic and static.
What 2023 features are included?
The lessons include Pivot Tables (2023) and the Power Automated Tab (2023).
What skills does this course build?
It builds skills in Microsoft Excel, Spreadsheets, Excel Formulas, and Microsoft Office 365.
