Excel for Business Professionals: Upper-Intermediate
You will learn Upper-Intermediate Excel skills and knowledge to solve more complicated Excel problems
Office Productivity,Microsoft,Excel
Lectures -23
Resources -41
Duration -1.5 hours
Lifetime Access
Lifetime Access
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
Hello and welcome to my advanced Excel for the business course!
Excel is undoubtedly one of the most ubiquitous pieces of software used in workplaces across the world. Learning to confidently operate it means adding a precious asset to your employability portfolio. In this third and final course of my Excel for Business series, you will continue to learn and practice using some of the most powerful features Excel offers.
When you have successfully completed this course, you will be able to:
- Check for and prevent errors in spreadsheets.
- Create powerful automation in spreadsheets.
- Apply advanced formulas and conditional logic to help make informed business decisions.
- Create spreadsheets that help forecast and model data.
I will be with you every step of the way, guiding you through each section with real-life Excel problems and how to fix them.
So please sit back, relax, and let's take your skills to the next level.
Last but not least, if you enjoy this course, please take a moment to share this with your friends and colleagues so that we can improve together.
Thank you again for choosing my courses. I wish you all the best on your way to advancing your career.
Goals
- You will learn to check for and prevent errors in your spreadsheets.
- You will learn to create powerful automation in your spreadsheets.
- You will learn to apply advanced formulas and conditional logic to help you make informed business decisions
- Last but not least, you will learn to create spreadsheets that help forecast and model data.

Curriculum
Check out the detailed breakdown of what’s inside the course
All about Data validation
5 Lectures
-
Introducing data Validation 06:11 06:11
-
Creating dropdown lists 05:45 05:45
-
Using formulas in data validation 05:00 05:00
-
Working with data validation 05:40 05:40
-
Advanced conditional formatting 04:48 04:48
Conditional Logic
5 Lectures

Automating Lookups
5 Lectures

Formula Auditing and Protection
4 Lectures

Data Modelling
4 Lectures

Instructor Details

long nguyen
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!
Course Certificate
Use your certificate to make a career change or to advance in your current career.

Our students work
with the Best


































Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now