Excel for Business Professionals - Intermediate

4.5 ★★★★ ★

Excel for Business Professionals - Intermediate

Name: Excel for Business Professionals - Intermediate - Online Course
Rating: 4.5 (386 reviews)
Author: long nguyen

Intermediate Excel skills and knowledge for Business and Professionals

updated on icon Updated on Jun, 2025

language icon Language - English

person icon Long Nguyen

English [CC]

category icon Office Productivity,Microsoft,Excel

Lectures -28

Resources -54

Duration -2 hours

Lifetime Access

4.5 ★★★★ ★

Add to Cart Buy Now

Lifetime Access

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

Hello and welcome to the second course of my Excel For Business series. In this Excel for Business - Intermediate course, you will build on the strong foundations you already have (after taking my Excel Essentials For Business course). The course will expand your Excel knowledge to new horizons through practical business examples.

You will discover a whole range of skills and techniques that will become a standard component of your everyday use of Excel. In this course, you will build a solid layer of more advanced skills so you can manage large datasets and create meaningful reports. These fundamental techniques and tools will allow you to add a sophisticated layer of automation and efficiency to your everyday tasks in Excel.

I will be with you every step of the way. Work through each new challenge step by step, and in no time, you will surprise yourself with how far you have come. Working through all the challenges, which are very common in the business environment, will help you relate to the skills and techniques learned each week more easily. You can then apply them to any familiar and new contexts you may come across in your daily tasks.

Thanks again for choosing my course. Let's enjoy, and improve together.

Goals

You will learn Intermediate Excel skills and knowledge for Business and Professionals
You will learn how to link and work with data from multiple worksheets, workbooks with the same and different structures
In addition, you will learn how to manage, edit, and maintain datasets much more efficiently and productively
You will also learn how to use more formulas, do calculations and create different reports much more quickly.

Prerequisites

This course requires basic Excel skills and knowledge.
You need to be willing to learn and practice a lot

Excel for Business Professionals - Intermediate

Curriculum

Check out the detailed breakdown of what’s inside the course

Working with Multiple Worksheets & Workbooks

5 Lectures

Working with Multiple Worksheets 06:42 06:42
Using 3D formulas 05:16 05:16
Linking workbooks 06:54 06:54
Using Consolidate tool - consolidate by position 06:08 06:08
Using Consolidate tool - consolidate by reference 04:02 04:02

All about Named ranges

4 Lectures

Intermediate Excel functions

9 Lectures

All about tables

5 Lectures

All about Pivot tables

5 Lectures

Instructor Details

long nguyen

My name is Long Nguyen (Jadon), a seasoned Excel and English language expert with over 10 years of experience in both fields. With a passion for helping people reach their full potential, I have been sharing my knowledge through various mediums, including one-on-one coaching, workshops, and now Tutorialspoint.
I have a strong background in data analysis and management, having worked as a data analyst for several companies. With my in-depth knowledge of Excel, I have helped countless professionals and students streamline their work processes and make data-driven decisions with ease.
I am also an accomplished English teacher, having taught the language to students of all ages and skill levels. Their ability to break down complex grammar concepts and make them easy to understand has earned me a reputation as a patient and effective educator.
My courses on Tutorialspoint are designed to provide students with a comprehensive understanding of Excel and English. Through clear and engaging lectures, interactive exercises, and real-world examples, I make sure that students not only understand the theory but also how to apply it in practical situations.
Whether you're a beginner looking to get started with Excel or an advanced user looking to take your skills to the next level, my courses will provide you with the skills and confidence you need to succeed. And if you're looking to improve your English, my courses are the perfect way to boost your speaking, writing, and comprehension skills.
I am passionate about helping people reach their full potential and I can't wait to help you do the same. So if you're ready to take your Excel and English skills to the next level, enroll in my courses today!