Microsoft Excel

CloudLabs

Projects

Assignment

24x7 Support

Lifetime Access

.

Course Overview

Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.

At the end of the training, participants will be able to:

Pre-requisite

All attendees should have a basic knowledge of computer.

Duarion

4 days

Course Outline

  1. Excel and the Excel Environment
  2. Navigate and Select in Worksheets
  3. Create a Basic Workbook
  4. Open, Save and Close Workbooks
  5. Use Microsoft Help
  1. Cut, Copy and Paste Commands
  2. Flash Fill
  3. AutoFill Options
  4. Find and Replace
  5. Spelling
  6. Undo and Redo
  7. Insert and Delete Options
  8. Column Width and Row Height
  9. Hide and Unhide Options
  1. Create Relative Formulas
  2. AutoCalculate
  3. Insert Functions
  4. Use AutoSum
  5. Copy Formulas
  6. Create Absolute Formulas
  1. Font Group
  2. Add Borders and Fill Colours
  3. Cell Alignment
  4. Number Formatting
  5. Cell Styles and Galleries
  1. Manage Worksheets
  2. View Worksheets and Workbooks
  1. Print Pane
  2. Print Worksheets and Workbooks
  3. Page Setup
  4. Print Layout View

Reviews