Mô tả

Hello and welcome to my advanced Excel for 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 highly valuable 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 has to offer.

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, guide 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 advance your career.

Bạn sẽ học được gì

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.

Yêu cầu

  • Intermediate Excel skills and knowledge
  • Willing to learn and practise a lot
  • Excel 2016 or newer version installed
  • Internet connection

Nội dung khoá học

5 sections

All about Data validation

5 lectures
Introducing data Validation
06:11
Creating dropdown lists
05:45
Using formulas in data validation
05:00
Working with data validation
05:40
Advanced conditional formatting
04:48

Conditional Logic

5 lectures
Logical function 1 - IF
05:37
Logical function 2 - AND, OR
04:55
Combining Logical Functions 1 - IF, AND, OR
03:36
Combining Logical Functions 2- Nested IFs
04:32
Handling Errors- IFERROR, IFNA
04:53

Automating Lookups

5 lectures
Introduction to Lookups- CHOOSE
03:25
Approximate Matches- Range VLOOKUP
03:29
Exact Matches- Exact Match VLOOKUP
05:10
Finding a Position - MATCH function
05:08
Dynamic Lookups - INDEX, MATCH
06:40

Formula Auditing and Protection

4 lectures
Error Checking
07:11
Error checking and calculation Options
05:48
Trace Precedents and Dependents
04:12
Evaluate Formula, Watch Window
05:06

Data Modelling

4 lectures
Modelling Functions- SUMPRODUCT
04:00
Data Tables
05:06
Goal Seek
03:22
Scenario Manager
04:49

Đánh giá của học viên

Chưa có đánh giá
Course Rating
5
0%
4
0%
3
0%
2
0%
1
0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

image

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.