Microsoft Excel Training with Hands-on

Course Description:

In today’s fast-paced, technical business environment, numbers are everything. Much of our success hinges on how well we can manage the data – statistics, planning, reporting – that we encounter on a daily basis. We learn how we are doing and discover our next course of action by studying numbers. An incredibly powerful tool for doing this is Microsoft Excel.

Microsoft Excel is the standard spreadsheet application for both the business world and personal use.

Course outline:

I – Navigating the Excel Program

1. Parts of the excel program/the screen and basic terminologies
2. Using Your Mouse and Keyboard
3. Using the Menu
4. Entering Values in Your Worksheet
5. Saving and Reopening Your File
6. Different Views
7. Print Preview

II – Formatting

1. Headers, Footers, and Page Numbers
2. Adjusting the Printing Setup
3. Adjusting Rows and Columns
4. Merging Cells
5. Boarders
6. Colors and Patterns / Fill / Fonts
7. Using the Format Painter
8. Formatting Cell Values

III – Managing Your Worksheet

1. Switching Between WorkSheets
2. Inserting and deleting A Worksheet
3. Renaming A WorkSheet
4. Protecting a WorkSheet
5. Hiding and Unhiding Worksheets
6. Splitting and Freezing A Window
7. Managing g Your Page Breaks

IV – Editing a Workbook

1. Entering Date Values
2. Replacing Cell contents
3. How to Cut, Copy, Paste Cells
4. Paste Special Option
5. Inserting Cells
6. Deleting Cells (rows and Columns)

V – Formulas

1. Understanding Basic Formula
2. Most Used Formulas
3. Troubleshooting Formulas

VI – Charts and Graphs

Please fill the information below should you wish to register to any of our public training schedules.