Microsoft Excel 2021-2023 – For Absolute Beginners in 3-HOUR
About Course
Would you like to start your IT journey? Get new, and most importantly, actually useful knowledge? Then this course is just for you!
This course is designed for absolute beginners, those who want to start working with Microsoft Excel but have no previous experience. After completing this course, you will be a confident Excel user who will be prepared for situations that occur in real life.
In this course we will cover the following topics:
– Where to get Microsoft Excel?
– Launching Excel
– Main Screen
– Interface
– Backstage Area
– Quick Access Toolbar
– Keyboard Shortcuts
– Templates
– Workbooks and Worksheets
– Saving Workbooks
– Entering and Editing Data
– Navigation and Selection
– Formulas and Functions
– Sum Function
– Count Function
– Average Function
– Min and Max Functions
– Errors
– Absolute and Relative Referencing
– AutoSum and AutoFill
– Flash Fill
– Named Ranges
– Managing Named Ranges
– Using Named Ranges
– Applying Number Formats
– Applying Date and Time Formats
– Formatting Cells, Rows and Columns
– Format Painter
– Working with Rows and Columns
– Working with the Cells
– Alignment
– Theme
Each of these sections will be discussed with examples that allow you to better understand the topic we are discussing. This will give you a solid foundation for understanding Microsoft Excel and learning it further.
Course Content
Microsoft Excel 2021/2023
-
Introduction
02:46 -
Where to Get Microsoft Excel
02:54 -
Launching Excel
01:01 -
Main Screen
06:10 -
Interface
09:55 -
Backstage Area
09:56 -
Quick Access Toolbar
06:51 -
Keyboard Shortcuts
08:51 -
Templates
06:14 -
Workbooks and Worksheets
06:16 -
Saving Workbooks
05:53 -
Entering and Editing Data
08:10 -
Navigation and Selection
07:44 -
Formulas and Functions
05:23 -
Sum Function
06:20 -
Count Function
06:59 -
Working with Cells
05:07 -
Alignment
07:02 -
Autosum and Autofill
07:28 -
Min and Max Function
03:11 -
Theme
03:24 -
Absolute and Relative Referencing
04:20 -
Working with Rows and Columns
08:24 -
Managing Named Ranges
01:58 -
Errors
07:41 -
Using Named Ranges
06:02 -
Average Function
04:39 -
Format Painter
03:52 -
Named Ranges
06:04 -
Flash Fill
02:58