MS Excel Course For Data Analytics, Online Instructor-led.

Excel Formulas and Functions

You can work on Excel but sometimes marvel at the formulas, that your colleagues have created. Excel is easy. We will cover formulae in depth in this interesting course.

Course Outline

Session 1:

Popular Functions:

• Sum, Average, Count, Counta, Countblank, Maximum and minimum.

Create from Scratch:

• Program general arithmetics into Excel,
• using addition, subtraction, multiply, divide, brackets

Copy Formulae

• using absoulte $ or relative, down accross and both

Excel function wizard for statistical functions:

• If,
• Nested if,
• Sumif(s), Averageif(s), Countif(s)

Names, Ranges and Tables,

• To simplify cell-referencing
• Using Ranges as Tables
• Conditional Formatting

Working with Excel sheets and files,

• calculating using multiple sheets
• or files

Session 2:

SubTotals:

• Excel Subtotals,
• Group, Outline

Cross referencing data:

• Xlookup,
• Vlookup,
• Hlookup,
• Match,
• Index,
• Indirect

Excel Pivot Tables

• Create
• Modify
• Format
• Sort
• Group

Charts and Pivot Charts