Microsoft Excel Training: Level 1

This beginner's Microsoft Excel training course aims to give the new spreadsheet user fundamental skills in creating and working with Excel.

    Interested in attending? Have a suggestion about running this event near you?
    Register your interest now

      Description

      This is a beginner’s Microsoft Excel training course and aims to give the new spreadsheet user a thorough grounding in the basics of creating and working with spreadsheets using Excel.

      Particular emphasis is placed on developing accurate and well-designed spreadsheets employing sound design and documentation principles.

      Prerequisites

      This course assumes little or no knowledge of spreadsheets or Microsoft Excel.

      However, it would be beneficial to have a general understanding of personal computers and the operating system environment, especially in regard to working with files and folders.

      Key Topics

      • Getting to know Microsoft Excel
      • Creating A New Workbook
      • Working With Workbooks
      • Selecting Ranges
      • Formulas And Functions
      • Copying Data
      • Formula Referencing
      • Font Formatting
      • Cell Alignment
      • Row And Column Formatting
      • Number Formatting
      • Printing
      • Creating Charts

      Learning Objectives

      When the participant completes this course they will be able to:

      • navigate your way around Microsoft Excel 2016
      • create and work with a new workbook
      • open and navigate within workbooks and worksheets
      • make changes to data in a workbook
      • understand and work with ranges in a worksheet
      • copy and paste data in Excel
      • use the fill operations available to fill a data series
      • move the contents of cells and ranges within and between workbooks
      • understand, create and work with formulas and functions
      • understand and use formula cell referencing
      • use font formatting techniques
      • align the contents of cells in a number of ways
      • understand and use the number formatting features in Excel
      • format rows and columns in a worksheet
      • work with elements that make up the structure of a worksheet
      • sort data in a list in a worksheet
      • filter data in a table
      • print your workbook data
      • create effective charts in Microsoft Excel
      • obtain help for Excel whenever you need it
      • understand points to consider to avoid problems in your worksheets

      Topic Outline

      Getting To Know Microsoft Excel

      • Starting Microsoft Excel
      • The Excel Screen
      • How Microsoft Excel Works
      • Using The Ribbon
      • Using Ribbon Key Tips
      • Minimising The Ribbon
      • Understanding The Backstage View
      • Accessing The Backstage View
      • Using Short Cut Menus
      • Understanding Dialog Boxes
      • Launching Dialog Boxes
      • Understanding The Quick Access Toolbar
      • Adding Commands To The QAT
      • Understanding The Status Bar
      • Exiting Safely From Excel
      • Creating A New Workbook

      Understanding Workbooks

      • Creating A New Workbook
      • Typing Text
      • Typing Numbers
      • Typing Dates
      • Typing Formulas
      • Saving A New Workbook
      • Easy Formulas
      • Checking The Spelling
      • Making Basic Changes
      • Printing A Worksheet
      • Safely Closing A Workbook
      • Working With Workbooks

      Opening An Existing Workbook

      • Navigating A Workbook
      • Navigating Using The Keyboard
      • Using Go To
      • Understanding Data Editing
      • Overwriting Cell Contents
      • Editing Longer Cells
      • Clearing Cells
      • Selecting Ranges

      Understanding Cells And Ranges

      • Selecting Contiguous Ranges
      • Selecting Non-Contiguous Ranges
      • Using Special Selection Techniques
      • Selecting Larger Ranges
      • Selecting Rows
      • Selecting Columns
      • Formulas And Functions

      Understanding Formulas

      • Creating Formulas That Add
      • Creating Formulas That Subtract
      • Formulas That Multiply And Divide
      • Understanding Functions
      • Using The SUM Function To Add
      • Summing Non-Contiguous Ranges
      • Calculating An Average
      • Finding A Maximum Value
      • Finding A Minimum Value
      • More Complex Formulas
      • What If Formulas
      • Copying Data

      Understanding Copying In Excel

      • Using Fill For Quick Copying
      • Copying From One Cell To Another
      • Copying From One Cell To A Range
      • Copying From One Range To Another
      • Copying Relative Formulas
      • Copying To A Non-Contiguous Range
      • Formula Referencing

      Absolute Versus Relative Referencing

      • Relative Formulas
      • Problems With Relative Formulas
      • Creating Absolute References
      • Creating Mixed References
      • Font Formatting

      Understanding Font Formatting

      • Working With Live Preview
      • Changing Fonts
      • Changing Font Size
      • Growing And Shrinking Fonts
      • Making Cells Bold
      • Italicising Text
      • Underlining Text
      • Changing Font Colours
      • Changing Background Colours
      • Using The Format Painter
      • Cell Alignment

      Understanding Cell Alignment

      • Aligning Right
      • Aligning To The Centre
      • Aligning Left
      • Rotating Text
      • Indenting Cells
      • Row And Column Formatting

      Approximating Column Widths

      • Setting Precise Columns Widths
      • Setting The Default Column Width
      • Approximating Row Height
      • Setting Precise Row Heights
      • Hiding Rows And Columns
      • Unhiding Rows And Columns
      • Number Formatting

      Understanding Number Formatting

      • Applying General Formatting
      • Formatting As Currency
      • Formatting Percentages
      • Formatting As Fractions
      • Formatting As Dates
      • Using The Thousands Separator
      • Printing

      Understanding Printing

      • Previewing Before You Print
      • Selecting A Printer
      • Printing A Range
      • Printing An Entire Workbook
      • Specifying The Number Of Copies
      • The Print Options
      • Creating Charts

      Understanding The Charting Process

      • Choosing The Chart Type
      • Creating A New Chart
      • Working With An Embedded Chart
      • Resizing A Chart
      • Dragging A Chart
      • Printing An Embedded Chart
      • Creating A Chart Sheet
      • Changing The Chart Type
      • Changing The Chart Layout
      • Changing The Chart Style
      • Printing A Chart Sheet
      • Embedding A Chart Into A Worksheet

      Concluding Remarks

      Target Audience

      This course is designed for users new to Microsoft Excel and spreadsheeting. It is a beginner’s course and aims to give the new spreadsheet user a thorough grounding in the basics of creating and working with spreadsheets using Microsoft Excel.