MS EXCEL

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.

Prerequisties

• All attendees should have a basic knowledge of computer.

Course Content

• Getting Started with Excel 2013
  • Excel and the Excel Environment
  • Navigate and Select in Worksheets
  • Create a Basic Workbook
  • Open, Save and Close Workbooks
  • Use Microsoft Help
• Modifying a Workbook
  • Cut, Copy and Paste Commands
  • Flash Fill
  • AutoFill Options
  • Find and Replace
  • Spelling
  • Undo and Redo
  • Insert and Delete Options
  • Column Width and Row Height
  • Hide and Unhide Options
• Using Formulas and Functions
  • Create Relative Formulas
  • AutoCalculate
  • Insert Functions
  • Use AutoSum
  • Copy Formulas
  • Create Absolute Formulas
• Formatting an Excel Worksheet
  • Font Group
  • Add Borders and Fill Colours
  • Cell Alignment
  • Number Formatting
  • Cell Styles and Galleries
• Managing Worksheets and Workbooks
  • Manage Worksheets
  • View Worksheets and Workbooks
• Printing Options
  • Print Pane
  • Print Worksheets and Workbooks
  • Page Setup
  • Print Layout View