Microsoft Excel
Course details
Lectures
47
Assignments
7
Quizzes
8
Level
Beginner
- Description
- Curriculum
- Reviews
Excel Interface & Workbook Basics
-
1
Introduction to Microsoft Excel -
2Excel Interface Overview (Ribbon, Tabs, Quick Access Toolbar)
-
3Cells, Rows, Columns, and Cell Addresses
-
4Understanding Workbooks and Worksheets
-
5Entering Numbers, Text, Date, Time and AutoSum
-
6Creating, Opening, and Saving Workbooks
-
7File Formats, Using Help and Search Tools
-
8Section Quiz
-
9Section Assignment
Cells, Rows, Columns & Data Entry
Rows, Columns & Worksheets
Formatting Cells and Data
Formulas and Functions
-
32Introduction to Formulas
-
33Creating and Editing Formulas
-
34Mathematical Operators
-
35Relative and Absolute References
-
36Introduction to Functions
-
37Common Functions (SUM, AVERAGE, MIN, MAX)
-
38The COUNT & COUNTA &COUNTBLANK functions
-
39The Round function
-
40Using the IF Function
-
41Understanding Formula Errors
-
42Section Quiz
-
43Section Assignment
Charts and Data Visualization
Printing and Page Setup
-
51Modifying basic Excel options
-
52The Ribbon & AutoCorrect options
-
53Quip Access Toolbar
-
54Worksheet Page Setup
-
55Headers and footers
-
56Print Preview & Setting Print Area
-
57Zooming the view and Scaling
-
58Preparing Worksheets for Printing
-
59Printing options
-
60Section Quiz
-
61Section Assignment
Final Quiz
Please, login to leave a review
