In this third course of my Excel training series, You will delve deeper into some of the most powerful features Excel has to offer. When you have successfully completed the course you will be able to:

- Check for and prevent errors in Excel; 
- Create powerful automation in Excel; 
- Apply advanced formulas and conditional logic to help make informed business decisions;
- Confidently use tools that help forecast and model data. 

Once again, I will be with you every step of the way, guide you through each section with real-life examples and practice materials. Thank you again for choosing my course, let's get started.

faviconv2_1741919174832.png

Excel for business: Upper-Intermediate

W1_V1 DataValidation.rar

Introducing Data Validation

W1_V2 DropDownLists.rar

Creating Drop-down Lists

W1_V3 FormulasInDataValidation.rar

 Using Formulas in Data Validation

W1_V4 WorkingWithValidation.rar

Working with Data Validation

W1_V5 AdvancedConditionalFormatting.rar

Advanced Conditional Formatting

All about Data Validation

W2_V1 IF.rar

Logical Functions 2 - If

W2_V2 ANDandOR.rar

Logical Functions 2 - AND, OR

W2_V3 IFwithANDandOR.rar

Combining Logical Functions 1 - IF, AND, OR

W2_V4 NestedIF.rar

Combining Logical Functions 2 - Nested IFs

W2_V5 IFERROR.rar

 Handling Errors - IFERROR, IFNA

Logical functions

W3_V1 CHOOSE.rar

Introduction to Lookups- CHOOSE

W3_V2 VLOOKUP Range.rar

Approximate Matches- Range VLOOKUP

W3_V3 VLOOKUP Exact Match.rar

Exact Matches- Exact Match VLOOKUP

W3_V4 MATCH.rar

Finding a Position- MATCH

W3_V5 INDEX_MATCH.rar

Dynamic Lookups- INDEX, MATCH

Lookup functions

W4_V1 Errors.rar

Error Checking

W4_V2 CalculationOptions.rar

Error cheking and calculation Options

W4_V3 TracePrecedents.rar

Trace Precedents and Dependents

W4_V4 EvaluateFormula.rar

Evaluate Formula and Watch Window

Error checking and Formula Auditing

W5_V1 SUMPRODUCT.rar

Modelling Function- SUMPRODUCT

W5_V2 DataTables.rar

Data Tables

W5_V3 GoalSeek.rar

Goal Seek

W5_V4 ScenarioManager.rar

Scenario Manager 

Data Modelling and Estimations

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

Nội dung

Quản trị viên

Đánh giá nổi bật