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: www.instagram.com/skillnator0/
Excel Dashboard in 5 simple steps: • Create interactive excel dashboard in 5 si...
Pivot Tables Crash Course: • Pivot Tables Crash Course #pivottables #ex...
Date Functions in Excel: • Master the date functions in excel. Learn ...
#exceltipsandtricks #exceldashboard #pivottables #excelcharts #excelmacros #pivotchart #pivottable #excelcourse #exceltutorial #masterpivottable
コメント