Chat with us, powered by LiveChat

For All Enquiries

1300 731 939

Microsoft Excel 2016 – Level 1

  • Course Code:

  • Course Duration:

    1 Day
  • Course Price:

  • Availability:

    Call/Email to register interest
  • Overview & ObjectivesOpen or Close

    This 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 2016. Particular emphasis is placed on developing accurate and well-designed spreadsheets employing sound design and documentation principles.

  • Skills GainedOpen or Close

    At the completion of this course you should 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
  • Course ModulesOpen or Close

    Getting to Know Excel 2016

    • Starting Excel From the Desktop
    • Understanding the Excel Start Screen
    • The Excel Workbook Screen
    • How Excel 2016 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 2016

    Creating a New 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

    Editing in a Workbook

    • Understanding Data Editing
    • Overwriting Cell Contents
    • Editing Longer Cells
    • Editing Formulas
    • Clearing Cells
    • Deleting Data
    • Using Undo and Redo

    Selecting ranges

    • Understanding Cells and Ranges
    • Selecting Contiguous Ranges
    • Selecting Non Contiguous Ranges
    • Selecting Larger Ranges
    • Selecting Rows
    • Selecting Columns

    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

    Filling Data

    • Understanding Filling
    • Filling a Series
    • Filling a Growth Series
    • Extracting With Flash Fill

    Moving Data

    • Understanding Moving in Excel
    • Moving Cells and Ranges
    • Moving by Dragging

    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
    • Creating More Complex Formulas
    • What if Formulas
    • Common Error Messages

    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
    • Horizontal Cell Alignment
    • Vertical Cell Alignment
    • Indenting Cells

    Number Formatting

    • 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

    Row and column formatting

    • Approximating Column Widths
    • Setting Precise Columns Widths
    • Setting the Default Column Width
    • Approximating Row Height
    • Setting Precise Row Heights

    Working with a worksheet

    • 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
    • Working With Multiple Worksheets
    • Worksheet Wisdom

    Sorting Data

    • Understanding lists
    • Performing an Alphabetical Sort
    • Performing a Numerical Sort
    • Sorting on More Than One Column

    Filtering Data

    • Understanding Filtering
    • Applying and Using a Filter
    • Clearing a Filter
    • Creating Compound Filters
    • Multiple Value Filters
    • Creating Custom Filters
    • Using Wildcards


    • 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
    • Using Tell Me
    • Accessing the Help Window
    • Navigating the Help Window
    • Using Google to Get Help
    • Printing a Help Topic
    • Other Sources of Assistance

    A guide to brilliant spreadsheets

    • Good Planning Is Essential
    • Organisation and Design
    • Writing Effective Formulas
    • Documented and Easy to Use
  • PrerequisitesOpen or Close

    This course assumes little or no knowledge of spreadsheets or Microsoft Excel 2016. 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.

Hav a question

Have a Question?

Give us a Call

Contact Us
Excel 2013 – Level 2
November 26, 2015 25% off
Thank You. We will contact you as soon as possible.
Featured Course: Excel Level 2
Learn to use excel with this intermediate level one day course from MIS Global Technologies and gain the following skills:
  • Reference functions
  • Use Database Tables
  • Data Validation tools
  • Use Hyperlinks
  • Protect workbooks
Thank You. We will contact you as soon as possible.
Excel Level 2
Featured Course: Office 365
This is a 5-day Instructor Led Training (ILT) course that targets the needs of IT professionals who take part in evaluating, planning, deploying, and operating Office 365 services. You will learn how to:
  • Implement and Manage Identities by Using DirSync
  • Manage Clients and End-User Devices
  • Provision SharePoint Online Site Collections
  • Configure Exchange Online and Lync Online for End Users
Thank You. We will contact you as soon as possible.
MIS Global Technologies
Phone: 1300 731 939
Suite 513, Level 5 Westfield Office Tower
159-175 Church Street Parramatta NSW 2150
Thank You. We will contact you as soon as possible.
We're happy to answer any questions you may have or provide you with any help you need when choosing the course that's right for you. Please leave a message in the form below and one of our friendly staff will get back to you as soon as possible
Thankyou! Your enquiry has been sent successfully. One of our friendly staff will get back to you soon. For anything urgent you can always call us on 1300 731 939
Featured Course: Excel Level 1
Learn to use excel with our one day course for beginners at MIS Global Technologies and learn about the following:
  • How to enter and edit data
  • How to Insert rows and columns
  • The BEDMAS rule
  • How to format dates
  • How to modify the header or footer
Reserve Your Place Today
Thank You. We will contact you as soon as possible.
Excel Level 2
Please leave a message and let us know which course you are interested in taking with us. One of our friendly staff will contact you as soon as they are available and will help you with your studies.
Thank you for your interest