What will i learn?
- Learn everything that you need to know about Microsoft Excel
Curriculum for this course
27 Lessons
07:02:29 Hours
Introduction to Microsoft Excel
5 Lessons
00:40:59 Hours
- Introduction to the Tabs 00:09:02
- Creating Workbook 00:11:39
- Quick Access Toolbar 00:08:06
- Sample Data
- Column, Cells, Rows & Range 00:12:12
Tabs in Microsoft Excel
12 Lessons
03:22:04 Hours
- Introduction to Home Tab 00:32:02
- Pivot Table 00:14:58
- Data for Pivot Table
- Introduction to Insert Tab 00:24:17
- Creating Charts 00:16:00
- Introduction to Draw & Layout Tabs 00:19:42
- Introduction to Review & View Tabs 00:23:56
- Contextual Menu & Mini Toolbar 00:05:09
- Status Bar 00:09:01
- Sample - Data Tab
- Introduction to Data Tab (1) 00:33:27
- Introduction to Data Tab (2) 00:23:32
Overview of Formulas in Microsoft Excel
4 Lessons
01:06:53 Hours
- Sample - Formulas
- Formulas and Functions (1) 00:28:59
- Formulas and Functions (2) 00:29:01
- PEMDAS in Formula 00:08:53
Microsoft Excel Dashboard
2 Lessons
00:29:28 Hours
- Creating Dashboard 00:29:28
- Sample Data
Tips and Tricks
4 Lessons
01:23:05 Hours
- Tips and Tricks (1) 00:11:22
- Tips and Tricks (2) 00:31:58
- Keyboard Shortcuts 00:39:45
- Keyboard Shorcuts
Requirements
- No special knowledge required
+ View more
Description
Microsoft Excel 2019 is being used for the lesson and recorded on a Windows machine, but compatible with Microsoft Word 2010, 2013, & 2016. The interface will be a bit different for MAC users.
+ View more
Other related courses
About the instructor
- 2 Reviews
- 3 Students
- 2 Courses
Student feedback
Reviews
-
Tue, 02-Aug-2022Amirah Kamarudin
Write a public review