Microsoft Excel 2013 Introduction

1 Day Course
Code QAEX13INT

This course has been retired. Please view currently available User Microsoft Office Training Courses.

Modules

Collapse all

Module 1: Getting Started with Excel 2013 (5 topics)

  • Excel and the Excel Environment
  • Navigate and Select in Worksheets
  • Create a Basic Workbook
  • Open, Save and Close Workbooks
  • Use Microsoft Help

Module 2: Modifying a Workbook (9 topics)

  • 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

Module 3: Using Formulas and Functions (6 topics)

  • Create Relative Formulas
  • AutoCalculate
  • Insert Functions
  • Use AutoSum
  • Copy Formulas
  • Create Absolute Formulas

Module 4: Formatting an Excel Worksheet (5 topics)

  • Font Group
  • Add Borders and Fill Colours
  • Cell Alignment
  • Number Formatting
  • Cell Styles and Galleries

Module 5: Managing Worksheets and Workbooks (2 topics)

  • Manage Worksheets
  • View Worksheets and Workbooks

Module 6: Printing Options (4 topics)

  • Print Pane
  • Print Worksheets and Workbooks
  • Page Setup
  • Print Layout View

Prerequisites

Use a mouse Type and use a keyboard Navigate through Windows files and folders Work with windows - minimise, maximise, open and close

Course PDF

Print

Sections