Microsoft Office Excel
2010 | 2007 | 2003
Basic | Intermediate | Advance
Microsoft Office Excel Basic
The course focuses on:
A basic overview of Excel and its funtions. The course shows you how to open, create and save new workbooks.; how to manipulate data and work with formulas. At the end of the course you will be able to print documents and adjust Excel settings
Who should attend this course?
This course is aimed at anyone who wishes to learn Microsoft Office Excel .
The following people will find this course helpful:
- Anyone who have not worked on Excel before
- Anyone who has worked a bit on Excel but is not familiar with all its functions
- Debtor and creditor clerks
- Data capturers
Duration: 1 Day
Outline:
Introduction to Excel
The Excel Window Components
What is a Spreadsheet?
Customize Quick Access Toolbar
Adjust the Zoom
Workbook Views
Move Around in Excel
Enter Data in Cells
Select Data in Cells
Save a Workbook
Open an Existing Workbook
Create a New Workbook
Help
Manipulating Cell Data
Move and Copy Data
Fill Cells with Series of Data
Insert and Delete Cells, Columns, and Rows
Find, Replace Cell Data
Spell Check a Worksheet
Formulas
Create Formulas
Use Excel Functions
Insert Function
Copy Formulas and Functions
Create an Absolute Reference
Formatting
Cell Data
Cell Ranges
Workbook Settings and Views
Insert and Delete Worksheets
Copy and Move Worksheets
Format Worksheet Tabs
Split a Worksheet
Freeze and Unfreeze Panes
Hide and Unhide Worksheets
Copy a Workbook
Printing
Page Setup
Insert and Remove Page Breaks
Set a Print Title
Set Print Ranges
Printing
Return to
soft skills course list | computer course list
To book for this course click here