Chat with us, powered by LiveChat

For All Enquiries

1300 731 939

Excel 2013 – Level 2

  • Course Code:

  • Course Duration:

    1 Day
  • Course Price:

  • Availability:

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

    This course effectively builds the knowledge and skills necessary to work with more complex formulas used in business spreadsheets. It covers best practice methods and formulas used for working with data contained in lists and database tables and ways to bring rigour to data quality and security.


  • Skills GainedOpen or Close

    Upon completion of this course you will be able to:

    • HLOOKUP, INDEX and other
    • Reference functions
    • Use Database Tables
    • Use Formula Auditing and
    • Data Validation tools
    • Protect workbooks
    • Use Hyperlinks


  • Course ModulesOpen or Close
    • LOOKUP functions
    • Introduction to VLOOKUP and
    • The VLOOKUP functions
    • The HLOOKUP function
    • The INDEX function
    • The CHOOSE function
    • The MATCH function
    • Understanding Reference functions
    • The ROW and ROWS functions
    • The COLUMN and COLUMNS functions
    • The ADDRESS function
    • The INDIRECT function
    • The OFFSET function
    • Lookup and Reference functions
    • Using Excel as a database
    • Sorting data
    • Automatic Subtotals
    • Sorting a subtotalled list
    • Preparing a subtotalled list as a report
    • Removing subtotals
    • Filtering a list using AutoFilter
    • Filtering using custom criteria
    • Working with a filtered list
    • Sort, copy and print preview data from
    • a filtered list
    • Display the top ten Items in a list
    • Creating a table
    • Formatting a table
    • Adding a record to a table
    • Totaling data in a table
    • Using Database Tables
    • Formula Auditing
    • Data Validation
    • Using the Formula Auditing toolbar
    • Error checking options
    • Trace Error
    • Data Validation
    • Entering data in a validated cell
    • Setting up a validation rule
    • Creating input and error messages
    • Displaying error messages
    • Formula Auditing and Data
    • Validation
    • Worksheet protection
    • Unlocking cells
    • Allow users to edit ranges
    • Setting worksheet protection
    • Workbook protection
    • File protection
    • Protecting workbooks
    • Hyperlinks
    • Creating a Hyperlink to a file
    • Creating a Hyperlink to a named range
    • Navigating between Hyperlinks
    • Additional links
  • PrerequisitesOpen or Close

    Successful completion of an Excel Introduction course or equivalent knowledge and skills is required to participate in this course.

    This course is for experienced Excel users who either work with existing spreadsheets or create their own spreadsheet models and want to broaden their understanding of more complex formulas. Learners will gain skills to use look up formulas, tools for finding and preventing errors, tools for working with databases and long lists of data and methods for protecting data in workbooks.


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