Microsoft Excel Intermediate
This intermediate level Microsoft Excel course is perfect for those who want to advance their Excel skills. Learn how to use formulas, advanced functions, formatting, sorting, filtering, graphics, and workbook protection. The course offers personalized instruction based on your version of Excel, ensuring you receive the most up-to-date knowledge. Suitable for both students and professionals, the course provides practical exercises and real-world examples that you can apply to your everyday work.
per person
Level
Duration
Training Delivery Format
Face-to-face / Virtual Class
per person
Level
Duration
Training Delivery Format
Face-to-face (F2F) / Virtual Class
Class types
Public Class
Private Class
In-House Training
Bespoke
About this course
If you’re ready to take your Microsoft Excel skills to the next level, our intermediate level course is the perfect fit for you. With this course, you’ll learn how to use formulas and advanced functions to create complex workbooks, format tables, sort and filter data, add and format graphics, and protect and finalize a workbook. Our experienced instructors provide personalized instruction that is tailored to your version of Excel. This ensures that you’ll receive the most relevant and up-to-date knowledge and skills.
The intermediate course is suitable for anyone looking to enhance their Excel proficiency, including business professionals and students. You’ll receive hands-on training through practical exercises and real-world examples, which will enable you to apply your new knowledge and skills to your everyday work. Don’t miss out on this opportunity to become an Excel master. Enroll now and take your Excel skills to new heights.
Who should attend?
This Excel course is suitable for students who possess foundational knowledge and skills in the software and want to leverage advanced features to analyze and present data effectively.
Learning Outcome
Upon completing this course successfully,
- you’ll be able to harness the power of data calculations and presentation to make informed decisions that benefit your organization.
- You’ll learn to work with functions and lists, create advanced formulas, protect spreadsheets, and customize views.
Prerequisites
Prior to enrolling in this course, students should have completed an introductory Excel course or possess an equivalent level of proficiency in the software. This may include our Microsoft Excel Essentials course or similar coursework.
Course Content
Module 1: Creating Advanced Formulas
- Apply Range Names
- Use Specialized Functions
Module 2: Analyzing Data with Logical and Lookup Functions
- Use Text Functions
- Use Logical Functions
- Use Lookup Functions
- Use Data Functions
- Use Financial Functions
Module 3: Organizing Worksheet Data with Tables
- Create and Modify Tables
- Sort and Filter Data
- Subtotal and Database Functions in Calculate Data
Module 4: Visualization Data with Charts
- Create Charts
- Modify and Format Charts
- Create a Trendline
- Create Advanced Charts
Module 5: Analyzing Data with PivotTables, Slicers, and PivotCharts
- Topic A: Create a PivotTable
- Topic B: Filter Data Using Slicers
- Topic C: Analyze Data with PivotCharts
Module 6: Working with Graphical Objects
- Topic A: Insert and Modify Graphic Objects
- Topic B: Layer and Group Graphic Objects
- Topic C: Incorporate SmartArt
Module 7: Enhancing Workbooks
- Topic A: Customize Workbooks
- Topic B: Manage Themes
- Topic C: Protect Files
- Topic D: Preparing a Workbook for Multiple Audiences
Classroom Live Labs:
- Range Names
- Specialized Functions
- Lookup Functions
- Working with Tables
- Create and Customize Tables
- Virtualizing Data with Charts
- How to Create and Modify Charts
- Working with Trendlines
At this time, this course is available for private class and in-house training only. Please contact us for any inquiries.