Course Overview on Microsoft Excel: Intermediate
This course will expand learners' basic Excel 365 skills to include intermediate Excel skills to help them work with data at a professional level. Learners who have completed our Excel Fundamentals course that are looking to expand their skillset into using data analysis tools like tables and charts will find this course most rewarding.
Learners will gain essential Excel skills such as using logical functions, working with date and time functions and organising cell data using lists. The course also teaches learners to create, populate, edit and format fundamental data analysis tools like tables and charts, including PivotTables and PivotCharts.
Learners can take this course as a 1-day class led by an expert instructor, either online or in a classroom.
The material covered in this course assumes knowledge of the Excel basic skills learned in our Excel Fundamentals course. Learners who complete this course who wish to learn more advanced Microsoft Excel skills such as Lookup functions or Sparkline creation will want to sign up for our Advanced Excel Training Course. All three of these courses are available as a discounted bundle in our Excel Bootcamp. Professionals who want to gain Excel skills centered on data analysis and high-level usage of Excel Power-Query functions should sign-up for our Excel Data Analysis course.
What You Will Learn
- Gain essential intermediate Excel skills for organising, presenting and analysing data within an Excel Workbook.
- Learn to work with ranges and use intermediate functions and formulas such as IF statements and Date & Time functions.
- Learn to create tables to organise Data and format them for readability and maximise aesthetic quality. Learn about using PivotTables to easily organise and analyse data.
- Learn how to use Excel data to create charts to present and analyse that data. Learn about different chart types and when to use them, as well as how to label and format them. Learn about using PivotCharts to present sub-sections of data.
Delivery Methods
| Delivery Method | Duration | ||
|---|---|---|---|
| 1 Day | Get a Quote | ||
| 1 Day | Get a Quote |
Discounts Available
Save up to 10% by booking and paying 10 business days before the course.
Brochure:
Customer Testimonials
Cox
The course is extremely informative and well composed.
World Vision International
Trainer was chosen on my behalf, but personally I have found the interactive nature of the training very helpful, so no suggestions for improvement based on day 1
World Vision International
The leading Edge is an organisation that knows how to deliver stuff in an professional manner, by understanding the team in all levels
United Exports South Africa (Pty) Ltd
Learned so many new skills to boost my data analysis capabilities. I highly recommend this course to anyone looking to level up their Excel skills & knowledge.
Shaeffler South Africa (Pty) Ltd
i really learnt so much. Gained so much knowledge. It was worth the time. I really enjoyed the overall training kept me motivated & I just wanted to know more as we went along
BMW Group South Africa
Awesome training looking forward to using my knowledge at work
Audience
This Intermediate Excel course is for anyone who has a basic understanding of Excel and wants to expand their expertise into more advanced data organisation, analysis and presentation. People whose work requires them to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the web.
Pre-Requisites
Course Outline / Curriculum
Lesson 1: Working with Functions
- Work with Ranges
- Use Specialized Functions
- Work with Logical Functions
- Work with Date & Time Functions
- Work with Text Functions
Lesson 2: Working with Lists
- Sort Data
- Filter Data
- Query Data with Database Functions
- Outline and Subtotal Data
Lesson 3: Analyzing Data
- Create and Modify Tables
- Apply Intermediate Conditional Formatting
- Apply Advanced Conditional Formatting
Lesson 4: Visualizing Data with Charts
- Create Charts
- Modify and Format Charts
- Use Advanced Chart Features
Lesson 5: Using PivotTables and PivotCharts
- Create a PivotTable
- Analyze PivotTable Data
- Present Data with PivotCharts
- Filter Data by Using Timelines and Slicers
Schedule Dates and Booking
There are currently no scheduled dates.