MS Excel 2013: Getting Started with Excel

To download a PDF version of this course overview click here

This Excel course is perfect for any beginner. It covers the basics of using Excel 2013, including creating workbooks and adding data. It also covers editing data, working with formulas, printing and charting.

This course is primarily designed for people who need to know how to use Microsoft Excel 2013. It is designed for beginner users who have little or no understanding, knowledge of, or experience in using Microsoft Excel.

Learning outcomes

At the completion of this course participants will be able to:

  • navigate your way around Microsoft Excel 2013
  • create a new workbook
  • open and navigate within workbooks and worksheets
  • understand and work with ranges in a worksheet
  • understand, create and work with formulas and functions used to perform calculations
  • copy and paste data in Excel
  • understand and use formula cell referencing to create more complex for mulas
  • use font formatting techniques to greatly enhance the look of a worksheet
  • align the contents of cells in a number of ways
  • format rows and columns in a worksheet
  • understand and use the number formatting features in Excel
  • print your workbook data
  • create effective charts in Microsoft Excel

The training room and facilities

When training on-site at your premises, we require only that each participant has access to their own computer or laptop, with Microsoft Excel 2013 installed.

Internet and networking facilities are not required. A data projector is required, and if your training room or board room is not equipped with one, we’re able to provide one at no extra cost.

Other questions

Contact us on 1300 730 922, or email us at enquiries@exceldimensions.com.au

Getting To Know Microsoft Excel 2013

  • Starting Excel From The Desktop
  • Understanding The Excel Start Screen
  • The Excel Workbook Screen
  • How Excel 2013 Works
  • Using The Ribbon
  • Showing And Collapsing The Ribbon
  • Understanding The Backstage View
  • Accessing The Backstage View
  • Using Shortcut 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 2013

Your First Workbook

  • Understanding Workbooks
  • Using The Blank Workbook Template
  • Typing Text
  • Typing Numbers
  • Typing Dates
  • Typing Formulas
  • Easy Formulas
  • Saving A New Workbook On Your
  • Computer
  • Checking The Spelling
  • Making Basic Changes
  • Safely Closing A Workbook

Working With Workbooks

  • Opening An Existing Workbook
  • Navigating A Workbook
  • Navigating Using The Keyboard
  • Using Go To
  • Recent Files And Folders
  • Understanding Data Editing
  • Overwriting Cell Contents
  • Editing Longer Cells
  • Editing Formulas
  • Clearing Cells
  • Deleting Data
  • Using Undo And Redo

Cells And Ranges

  • Understanding Cells And Ranges
  • Selecting Contiguous Ranges
  • Selecting Non-Contiguous Ranges
  • Selecting Larger Ranges
  • Selecting Rows
  • Selecting Columns
  • 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
  • Understanding Filling
  • Filling A Series
  • Filling A Growth Series
  • Extracting With Flash Fill
  • Understanding Moving In Excel
  • Moving Cells And Ranges

Formulas And Functions

  • Understanding Formulas
  • Creating Formulas That Add
  • Creating Formulas That Subtract
  • Formulas That Multiply And Divide
  • Understanding Functions
  • Using The SUM Function
  • Summing Non-Contiguous Ranges
  • Calculating An Average
  • Finding A Maximum Value
  • Finding A Minimum Value
  • Creating More Complex Formulas
  • What If Formulas
  • Absolute Versus Relative Referencing
  • Relative Formulas
  • Problems With Relative Formulas
  • Creating Absolute References
  • Creating Mixed References
  • Common Error Messages

Worksheet Appearance

  • 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
  • Understanding Cell Alignment
  • Horizontal Cell Alignment
  • Vertical Cell Alignment
  • Indenting Cells
  • Understanding Number Formatting
  • Applying General Formatting
  • Formatting For Money
  • Formatting Percentages
  • Formatting As Fractions
  • Formatting As Dates
  • Using The Thousands Separator
  • Increasing And Decreasing Decimals

Worksheet Layout

  • Approximating Column Widths
  • Setting Precise Columns Widths
  • Setting The Default Column Width
  • Approximating Row Height
  • Setting Precise Row Heights
  • Understanding Worksheets
  • Changing The Worksheet View
  • Worksheet Zooming
  • Viewing The Formula Bar
  • Viewing Worksheet Gridlines
  • Inserting Cells Into A Worksheet
  • Deleting Cells From A Worksheet
  • Inserting Columns Into A Worksheet
  • Inserting Rows Into A Worksheet
  • Deleting Rows And Columns
  • More Than One Worksheet
  • Worksheet Wisdom

Sorting and Filtering Data

  • Understanding Lists
  • Performing An Alphabetical Sort
  • Performing A Numerical Sort
  • Sorting On More Than One Column
  • Understanding Filtering
  • Applying And Using A Filter
  • Clearing A Filter
  • Creating Compound Filters
  • Multiple Value Filters
  • Creating Custom Filters
  • Using Wildcards

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 Right Chart
  • Using A Recommended Chart
  • Creating A New Chart From Scratch
  • Working With An Embedded Chart
  • Resizing A Chart
  • Repositioning 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
  • Deleting A Chart

Getting Help

  • Understanding How Help Works
  • Accessing The Help Window
  • Navigating The Help Window
  • Using The Office Website For Help
  • Using Google To Get Help
  • Printing A Help Topic
  • Other Sources Of Assistance

A Guide to Brilliant Spreadsheets

  • Nothing Beats Good Planning
  • Organisation And Design
  • Spot On Formulas
  • Documented And Easy To Use
  • The Appropriateness Of
  • Spreadsheets

Need more information?

Contact us:

1300 730 922
www.exceldimensions.com.au
enquiries@exceldimensions.com.au