Advanced Excel - Part 1

Advanced Excel 1 - Intro - What will you learn in this?

Introduction about advanced features.

Advanced Excel 2 - Menus, Sorting basics

Menus of Excel, Sorting basics

Advanced Excel 3 - Sorting different sections

Multiple sections in same sheet, sorting

Advanced Excel 4 - Numeric fields

Manage numeric data, basic formula

Advanced Excel 5 - Date fields and formula

Manage date fields and formula

Advanced Excel 6 - Copy Paste formula details

How to copy paste, drag formula details

Advanced Excel 7 - Currencies

using currency sign, multiple sheets

Advanced Excel 8 - Refer multiple sheets

Refer data from multiple sheets

Advanced Excel 9 - Conditional Format

Format data based on conditions

Advanced Excel 10 - Conditional Aggregation

Conditional Aggregation - sumif

Advanced Excel 11 - Count

Different ways of counting

Advanced Excel 12 - CountIF

Count with if conditions