Tutorialspoint

April Learning Carnival is here, Use code FEST10 for an extra 10% off

Excel for Business Professionals: Upper-Intermediate

person icon Long Nguyen

4

Excel for Business Professionals: Upper-Intermediate

You will learn Upper-Intermediate Excel skills and knowledge to solve more complicated Excel problems

updated on icon Updated on Apr, 2024

language icon Language - English

person icon Long Nguyen

category icon Office Productivity,Microsoft Excel

Lectures -23

Resources -41

Duration -1.5 hours

4

price-loader

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 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

What will you learn in this course:

  • 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.


Excel for Business Professionals: Upper-Intermediate

Curriculum

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

All about Data validation
5 Lectures
  • play icon Introducing data Validation 06:11 06:11
  • play icon Creating dropdown lists 05:45 05:45
  • play icon Using formulas in data validation 05:00 05:00
  • play icon Working with data validation 05:40 05:40
  • play icon Advanced conditional formatting 04:48 04:48
Conditional Logic
5 Lectures
Tutorialspoint
Automating Lookups
5 Lectures
Tutorialspoint
Formula Auditing and Protection
4 Lectures
Tutorialspoint
Data Modelling
4 Lectures
Tutorialspoint

Instructor Details

long nguyen

long nguyen

Hi there,

Thank you for choosing my courses, my name is Long Nguyen, I am a professional data analyst who has worked with Microsoft Excel and other tools for more than a decade.

My courses are carefully designed to help you take charge of Excel and improve your Excel skills.

Let's learn, practice, and improve together.

Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515