Course Outline - Microsoft Teams for End Users

    Microsoft Excel Introduction

    Course Duration: One Day

    Target Audience:

    Aimed at users who are new to Microsoft Excel and want to set up their own spreadsheets and manipulate existing ones.

    Course Objectives:

    To develop a good working knowledge of Excel to include features such as basic functions and formulae, sorting and filtering data, formatting, and printing spreadsheets.

    Course Outline:

    Basic Knowledge

    • Understanding Workbooks, Worksheets, Rows, Columns, Cells
    • The Ribbon
    • Selection techniques
    • Understanding the different Mouse shapes
    • Quick Access Toolbar
    • Customizing the Quick Access Toolbar
    • Customising the formula Bar
    • Quick Access Toolbar
    • Live Preview
    • Contextual tabs
    • Zoom Feature
    • Views explained
    • Shortcut keys
    • Saving, File types, File Compatibility
    • Tell me what you want to do – feature
    • Smart Lookup
    • Pinning Recent Files

    Entering, Selecting and Editing Data

    • Entering, Editing, and deleting information in cells (Text, Date, and numbers)
    • Entering Auto Lists
    • Using Fill handle to create simple lists
    • Creating custom lists
    • Deleting Rows, Columns and Cells
    • Inserting Rows, Columns and Cells
    • Inserting, Deleting, Moving, Copying and Renaming Sheets
    • Various Navigation Techniques using Scroll bar, Keyboards and Go To command
    • Using the Paste Preview

    Creating Formulae and Functions

    • Creating Formulae
    • Editing Existing Formulae
    • Mathematical Order
    • Copying Formulae
    • Understanding Relative Referencing
    • Understanding Absolute Referencing
    • Using the Auto sum Feature

    Frequently Used Functions

    • SUM, MIN, MAX, AVERAGE, COUNT, COUNTA
    • Using the Formulas Tab

    Formatting your Spreadsheet

    • Formatting Cells
    • Number Formatting
    • Date Formatting
    • Text Formatting
    • Cell Alignment and Orientation
    • Wrap text
    • Applying cell styles
    • Border drawing
    • Clearing Formats
    • Changing Column Widths
    • Changing Row Heights
    • Changing sheet Tab Colours
    • Using Format Painter

    Data Sort and Filter

    • Sorting Data
    • Auto Filter
    • Filtering using Timeline

    Charts / Graphs

    • Creating Simple Charts
    • Editing Charts
    • Formatting Charts
    • Using Recommended Charts

    Printing

    • Print Preview
    • Page Orientation
    • Adding Headers and Footers
    • Printing a Selection
    • Setting a Print Area
    • Scaling
    • Adjusting page breaks using Page Break Preview
    • Repeating columns and rows
    • Changing Margins
    • Centre on Page

    Discussion and Question Time

    View Schedule
    Contact Us