Hi, welcome to our new crash course on Microsoft Excel. This course is for beginners and intermediates who want to advance their skills. We will cover the following:

– Navigation, Interface and Ribbon
– Statistical Functions
– Date Time Functions
– Text Functions
– Lookup functions
– Logical Functions.
– Pivot tables
– Charts
– Shapes
– Setting up a modern dashboard

Timestamps:

00:00 – Intro
01:15 – Interface
03:58 – Navigation techniques
03:58 – Navigation techniques
05:06 – Formatting tips and tricks
08:45 – Relative vs Absolute formula referencing
12:00 – Statistical Functions
20:33 – Date Time Functions
22:45 – Text Functions
25:03 – Lookup and reference functions
29:00 – Logical functions
33:22 – Pivot tables
38:00 – Charts in Excel
41:37 – Shapes in Excel
43:03 – Modern dashboard in excel

Instagram: https://www.instagram.com/skillnator0/
Excel Dashboard in 5 simple steps: https://youtu.be/eaSg0mu6nLM
Pivot Tables Crash Course: https://youtu.be/WlJpzth68os
Date Functions in Excel: https://youtu.be/LDWVNgRZZew

#exceltipsandtricks #exceldashboard #pivottables #excelcharts #excelmacros #pivotchart #pivottable #excelcourse #exceltutorial #masterpivottable