Microsoft Excel Course
Overview
This course is suitable for beginners. Excel is an incredibly powerful tool for getting meaning out of vast amounts of data. You put data in your cells and group them in rows and columns. That allows you to add up your data, sort and filter it, put it in tables, and build great-looking charts.
Objective:
Upon successful completion of this course, you will be able to put data in your cells and group them in rows and columns. That allows you to add up your data, sort and filter it, put it in tables, and build great-looking charts.
You will able to:
- Creating a worksheet.
- Editing data.
- Working with formula.
- Excel Chart.
Course content:
|
1 |
The Excel Window |
|
|
a) Starting Microsoft Excel b) Saving a New Workbook c) Exploring the Screen Layout d) Moving Around the Worksheet e) Moving Around the Workbook f) Exiting Microsoft Excel
|
|
2 |
Creating a Worksheet a) Entering Data b) Erasing Data c) Using the Undo and Redo Facility d) Moving Data e) Copying Data |
|
|
|
|
3 |
Editing Data |
|
|
a) Inserting and Deleting Rows and Columns b) Hiding and Un-Hiding Rows and Columns c) Apply Borders to Cells
|
|
4 |
Working with Formulas |
|
|
a) Using AutoSum b) Creating Formula c) Editing a Formula d) Copying a Formula e) Adding a Formula
|
|
5 |
Printing a Worksheet |
|
|
a) Print Preview b) Page setup c) Printing the document d) Setting Print Areas e) Setting Repeated Titles
|
|
6 |
Editing Worksheets |
|
|
a) Protecting Worksheets b) Naming Worksheets c) Split a Worksheet into Panes d) Deleting Worksheets e) Linking Worksheets f) Move or Copy Worksheets
|
|
7 |
Excel Charts |
|
|
a) Creating a Chart b) Formatting the Chart c) Printing Charts
|
|
|
|
