Microsoft Excel Tutorial
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: / skillnator0
Excel Dashboard in 5 simple steps: • Create interactive excel dashboard in...
Pivot Tables Crash Course: • Pivot Tables Crash Course #pivottable...
Date Functions in Excel: • Master the date functions in excel. L...
#exceltipsandtricks #exceldashboard #pivottables #excelcharts #excelmacros #pivotchart #pivottable #excelcourse #exceltutorial #masterpivottable