Microsoft Excel Intermediate Course – Virtual
Build on from the basics of Microsoft Excel by creating advanced workbooks and worksheets to organise, analyse and filter data using formulas, tables and slicers.
- All Courses
- Microsoft Office
- Microsoft Excel
- Microsoft Excel Intermediate Course – Virtual
Course Overview
This course builds upon the foundational knowledge presented in the Microsoft Excel Introduction course and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organisational intelligence. The ability to analyse massive amounts of data, extract actionable information from it, and present that information to decision makers can create a powerful competitive advantage.
You will learn how to create advanced formulas and organise your data into tables. You’ll discover the power of PivotTables and PivotCharts and how slicers can make data filtering as easy as clicking a few buttons.
This course is suitable for anybody wanting to learn any version between 2007 and latest 2021. Our courses cover all differences between the versions.
Price
Duration
1 Day
Training Options
Virtual
Microsoft Excel Intermediate Course Content:
Lesson 1: Working with Functions
- Topic A: Work with Ranges
- Topic B: Use Specialised Functions
- Topic C: Work with Logical Functions
- Topic D: Work with Date and Time Functions
- Topic E: Work with Text Functions
Lesson 2: Working with Lists
- Topic A: Sort Data
- Topic B: Filter Data
- Topic C: Query Data with Database Functions
- Topic D: Outline and Subtotal Data
Lesson 3: Analysing Data
- Topic A: Create and Modify Tables
- Topic B: Apply Intermediate Conditional Formatting
- Topic C: Apply Advanced Conditional Formatting
Lesson 4: Visualising Data with Charts
- Topic A: Create Charts
- Topic B: Modify and Format Charts
- Topic C: Use Advanced Chart Features
Lesson 5: Using PivotTables and PivotCharts
- Topic A: Create a PivotTable
- Topic B: Analyse PivotTable Data
- Topic C: Present Data with PivotCharts
- Topic D: Filter Data by Using Timelines and Slicers
Upon successful completion of this course, students will be able to:
- Work with functions
- Work with lists
- Analyse data
- Visualise data with charts
- Use PivotTables and PivotCharts
Instructor led, group-paced, virtual classroom-delivery learning model with structured hands-on activities.
- Professional Microsoft Certified Trainer
- CPD Accredited Classroom training in Small Groups for Max Focus
- Only Microsoft Approved Courseware and Exercise Files are used
- Free Assessment of Skills prior to booking
- Certificate of Completion & Complementary 12 Months Post Course Support
- 100% Money Back Guarantee & Price Match Guarantee
- Bespoke Courses & Group Discounts from £89 per person
This course is designed for students who already have foundational knowledge and skills in Excel and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyse and present data.
Before taking this course, students are recommended to take the following course, or have equivalent knowledge:
This course is one of a series of courses that addresses Microsoft Certified Application Specialist (Microsoft Business Certification) skill sets.
The Microsoft Certified Application Specialist program is for individuals who use Microsoft’s business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Microsoft Certified Application Specialist certification.
Choose Your Date & Location
Testimonials
Take Yourself Further With Infero
Top Microsoft Excel FAQs
- Start: 9:00am
- Break: 11:00am
- Lunch: 1:00pm
- Break: 3:00pm
- Finish: 5:00pm