Preview MS Excel for Business Excellence - Top 12 Functions

Introduction

1. Automatic Subtotal

Aggregate Function

2. How To Lock Excel

Locking and Hiding Excel Formula

3. Auditing Function

Auditing Functions

4. Table Feature

Table Feature

5. Date Function

6. If Analysis Function

IF Analysis

7. If With An Or

If with AN OR Function

8. SumIf & CountIf

SUMIF & COUNTIF

9. Sumifs & Countifs

SUMIFS & COUNTIFS

10. VLookup & HLookup

VLOOKUP & HLOOKUP

11. XLookup

XLOOKUP

12. Pivot Table

Pivot Table Intro

Preview - MS Excel for Business Excellence - Top 12 Functions