Microsoft Excel 2016 – Level 3

Duration: 1 day

You will work with advanced functions and formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, students will learn about data validation, and will use advanced data filtering. Students will apply advanced chart formatting options, and create more complex charts. They will work with PivotTables and PivotCharts, export and import data, and query external databases. Students will learn about the analytical features of Excel, such as Goal Seek, and how to create scenarios.

  • Top
  • Wed 25 Sep
    1 day, 08:15 AM - 04:30 PM Nevis Bentley Beckles
    • $235.00 excl. Tax
  • Thu 26 Sep
    1 day, 09:00 AM - 04:30 PM AdvantageCaribbean Barbados
    • $235.00 excl. Tax
  • Wed 02 Oct
    1 day, 08:15 AM - 04:30 PM St. Kitts Bentley Beckles
    • $235.00 excl. Tax
  • Wed 02 Oct
    1 day, 09:00 AM - 04:30 PM Castries
    • $235.00 excl. Tax
    Event is fullJoin waiting list
  • Wed 09 Oct
    1 day, 09:00 AM - 04:30 PM Dominica Bentley Beckles
    • $235.00 excl. Tax
  • Wed 09 Oct
    1 day, 09:00 AM - 04:30 PM AdvantageCaribbean Barbados
    • $235.00 excl. Tax
  • Wed 16 Oct
    1 day, 09:00 AM - 04:30 PM St. John's Bentley Beckles
    • $235.00 excl. Tax
  • Wed 23 Oct
    1 day, 09:00 AM - 04:30 PM Grenada
    • $235.00 excl. Tax
  • Wed 23 Oct
    1 day, 09:00 AM - 04:30 PM Kingstown Bentley Beckles
    • $235.00 excl. Tax
  • Wed 30 Oct
    1 day, 09:00 AM - 04:30 PM Brades Bentley Beckles
    • $235.00 excl. Tax
  • Thu 31 Oct
    1 day, 09:00 AM - 04:30 PM AdvantageCaribbean Barbados
    • $235.00 excl. Tax
  • Fri 08 Nov
    1 day, 09:00 AM - 04:30 PM AdvantageCaribbean Barbados
    • $235.00 excl. Tax
  • Wed 20 Nov
    1 day, 09:00 AM - 04:30 PM Anguilla - The Valley Bentley Beckles
    • $235.00 excl. Tax
  • Fri 22 Nov
    1 day, 09:00 AM - 04:30 PM AdvantageCaribbean Barbados
    • $235.00 excl. Tax
  • Wed 22 Jan
    1 day, 09:00 AM - 04:30 PM St. John's
    • $235.00 excl. Tax
  • Wed 29 Jan
    1 day, 09:00 AM - 04:30 PM St. Kitts
    • $235.00 excl. Tax
  • Wed 05 Feb
    1 day, 09:00 AM - 04:30 PM Nevis
    • $235.00 excl. Tax
  • Wed 12 Feb
    1 day, 09:00 AM - 04:30 PM Anguilla - The Valley Bentley Beckles
    • $235.00 excl. Tax
None of these dates work for you? Suggest another date & time
Description

Upon successful completion of this course, students will be able to:

  • Use IF and IFERROR functions
  • Use VLOOKUP and HLOOKUP functions in concert with the MATCH and INDEX functions
  • Validate cell data and use advanced filtering tools to focus data
  • Create and format charts
  • Create Pivot Tables/Charts
  • Export/Import data to/from other MS Office® compatible formats
  • Use the Goal Seek utility

Prerequisites

Before attending this course, students must have:

  • Basic computer knowledge, such as keyboard and mouse skills.
  • Basic file-management skills.  The student should know how to navigate to folders and files on a computer running Windows 7.
  • Participants for this MUST have already completed levels 1 and 2, and or have adequate working knowledge of Excel including knowing how to quickly navigate worksheets/workbooks, create range names and filter data. This courses assumes that ALL participants have that grounded information in the use of      Microsoft Excel.

Target audience

This course is designed for persons who are able to create and modify worksheets and workbooks in Microsoft Excel 2016, but need to know how to create or modify documents using advanced tools and efficiency procedures. It also aims to assist persons preparing for the Microsoft Office Specialist exams for Microsoft Excel 2016.

Do NOT follow this link or you will be banned from the site!