Course Content
Introduction to Microsoft Excel
0/5
Introduction to Excel
01:47
The Excel Interface
03:20
The Quick Access Toolbar
01:51
Navigating the Ribbon toolbar
06:14
The Excel Online Web Based Version
05:11
Working with MS Excel
0/12
Opening and Creating Workbooks
04:09
Using Excel templates
02:11
Adding data to your worksheet
03:42
Inserting rows and columns
01:32
Adding and renaming worksheets
01:55
Excel save options
05:29
Copying and moving data
10:39
Windows Clipboard History tool
04:30
Inserting objects graphs and charts
10:40
Password protecting your workbook
05:36
Search options
03:12
Using Addins
03:55
Functions, Formulas and Filters
0/6
Functions
04:00
The Formula bar
03:46
The Formula bar
03:46
Using formulas
09:04
Filtering your data
04:00
Sorting data
06:12
Formatting your workbook
0/10
Adding cell borders
05:34
Changing fonts and colors
04:23
Extra Credit Installing new fonts
03:09
Adding cell colors
01:57
Text alignment
07:16
Adjusting cell width and height
03:28
Styles and conditional formatting
05:53
Formatting cells for data types
03:26
Hiding rows and columns
01:38
Using the Freeze Panes feature
01:52
Page layout and printing
0/4
Page setup
04:44
Page breaks
04:29
Printing your workbook
05:38
Creating PDF files from your worksheets
04:34
Microsoft Excel Fundamentals: The Beginners Masterclass (Copy 1)
Previous
Next
0% Complete
Pengrad Learning

Learning often happens in classrooms
but it doesn’t have to.

Make online payment on this site or alternatively,

Account Name: Pengrad Education and Capacity Development Company Ltd.

Account Number: 0216010847

Bank Name: Union Bank

Pengradofficial@gmail.com
+234 703 1687 845