Course Objective :
Microsoft Excel is one of the most commonly used products of Microsoft office. It is used for data entry, data analysis, data presentation, or calculation. The Excel spreadsheet lets you organize information into nice, neat rows and columns, then format, sort, analyze and do math on it. Useful for financial records, address books, to do lists, too many things to mention.
- Create basic worksheets using Microsoft Excel
- Perform calculations in an Excel worksheet.
- Modify an Excel worksheet.
- Modify the appearance of data within a worksheet.
- Manage Excel workbooks.
- Print the content of an Excel worksheet.
- Learn how to use handy new features
Target Audience :
This course is for individuals whose job responsibilities include creating, inputting and printing basic spreadsheets.
Pre – Requisites :
Basic Windows, keyboarding and mouse skills.
Course Outline :
Introduction of Microsoft Excel
- Navigate the Excel User Interface
- Use Excel Commands
- Enter Cell Data
- Use Excel Help
Microsoft Excel Workbook
- Starting Microsoft Excel
- Creating a Workbook
- Saving a Workbook
- The Status Bar
- Adding and Deleting Worksheets
- Copying and Moving Worksheets
- Changing the Order of Worksheets
- Splitting the Worksheet Window
- Closing a Workbook
The Ribbon and File Menu
- Tabs
- Groups
- Commands
The Quick Access Toolbar
- Adding Common Commands
- Adding Additional Commands with the Customize Dialog Box
- Adding Ribbon Commands or Groups
- Placement
Entering Data in Worksheets
- Entering Text
- Expand Data across Columns
- Adding and Deleting Cells
- Adding an Outline
- Adding a Hyperlink
- Add WordArt to a Worksheet
- Using AutoComplete
- Entering Numbers and Dates
- Using the Fill Handle
Performing Formulae & Calculations
- Create Worksheet Formulas
- Insert Functions
- Reuse Formulas
Modifying a Worksheet
- Insert, Delete, and Adjust Cells, Columns, and Rows
- Search for and Replace Data
- Use Proofing and Research Tools
Formatting a Worksheet
- Modify Fonts
- Add Borders and Colors to Worksheets
- Apply Number Formats
- Align Cell Contents
- Apply Styles and Themes
- Apply Basic Conditional Formatting
- Create and Use Templates
Printing Workbooks
- Preview and Print a Workbook
- Define the Page Layout
Managing Workbooks
- Manage Worksheets
- Manage Workbook and Worksheet Views
- Manage Workbook Properties