What you will learn:
-
Navigate Excel and enter data across workbooks and worksheets
-
Format cells with number styles, dates, currencies and borders
-
Write formulas using relative and absolute cell references
-
Use essential functions: SUM, AVERAGE, IF, COUNT, VLOOKUP and more
-
Create charts and graphs to visualise your data clearly
-
Organise data with Tables, Sort and Filter tools
-
Summarise large datasets instantly using Pivot Tables and Slicers