Microsoft Excel Introduction

Learn how to get the most out of Microsoft Excel & leverage this powerful tool. Achieve a good understanding of how Excel works/ thinks & progress from creating basic spreadsheets to advanced dashboards - store your data correctly, format it and then

• (i) Use formula/ functions
• (ii) Link sheets/ files, apply validation & conditional formatting
• (iii) Analyse using charts & pivot tables (iv) Create interactive dashboards with slicers & DAX

Topics Include:

• Create new spreadsheets & edit existing spreadsheets (insert/ delete rows & columns, update page setup, work with sheets)
• Learn how to setup your spreadsheet properly so that you can get most out of your data 
• Enter data correctly then format, filter & sort
• Understand when & how to use formula & functions + - * / % $ sum average count counta min max
• Create basic charts from your data