02 Introduction to Microsoft Excel - What you will learn

03 Excel interface overview

04 Excel ribbon - How works and how to customize

05 How use and edit Quick access toolbar

06 Excel Workbooks - Create, Open and Save files

07 Working with Worksheets - Add, delete and change name

08 Automatic data with autofill - save time using this tool

09 Rows and columns - Add and delete

10 Hide & Unhide Rows Colums and Worksheets

11 Change row and column size

12 Wrap, shrink and merge text

13 Practical exercise using Font tools

14 Format painter tool - Another powerfull tool to save time

15 Format Numbers Tool - Date and Time Format

16 Identify and Remove Duplicates Values

17 Sort and Filter Tools

18 Cell references to link data - Relative, absolute and mixed

19 Excel Formulas - How to create a formula using math operators

20 Use Functions in Excel - Syntax used to create functions

21 Add Numbers with Sum Function

22 Average Function for cells ranges average calculation

23 How to use Statistical Functions Min and Max

24 Count and CountIf Functions

25 Exercise with Logical Functions IF, OR and AND for single and multiple

26 Conditional Addition with Sumif and Sumifs

27 Extract Data using Vlookup Reference Function

28 Hlookup Function to Extract Data

Exsersice