Udemy – Excel Intermediate 2025-1

Apr 18, 2025 - 19:50

0 0

Excel Intermediate is a basic Excel skills course published by Udemy Online Academy. The course builds on basic Excel skills, focusing on advanced data manipulation, complex formulas, and advanced visualization techniques. Topics include nested functions, lookup formulas (VLOOKUP, HLOOKUP, and XLOOKUP), data validation, conditional formatting, and dynamic charts. Students also learn how to use pivot tables and pivot charts to analyze data, automate repetitive tasks with macros, and apply logical and statistical functions for better decision-making.

Designed for users who want to improve efficiency and confidently manage large data sets, this course will enhance Excel skills for professional and analytical work. This 3-hour course, updated regularly, will enable you to confidently perform complex data management tasks. With new content added regularly, you’ll be introduced to the evolving capabilities of Excel. This course bridges the gap between basic Excel use and advanced data analysis, making you a more efficient and capable Excel user.

What you will learn in Excel Intermediate:

Learn about references and 3D links and how to use them
A deeper look at sorting and filtering in different scenarios, as well as issues related to these
A comprehensive guide to Sparklines and tables and fixing incorrect/missing data
Import and organize your data to optimize space and performance
How and when to use conditional formatting and charts
And…

Course specifications

Publisher: Udemy
Instructors: Chris Menard
Language: English
Level: Intermediate
Number of Lessons: 42
Duration: 3 hours and 21 minutes

Course topics

Excel Intermediate Content

Excel Intermediate Prerequisites

Microsoft 365 license will be required to download and use Excel for Mac or Windows.

Udemy – Excel Intermediate 2025-1