Loading...
Login / Register

MOS Microsoft Office Excel 2016 Intermediate

Whether you need to crunch numbers for sales, inventory, information technology, human resources, or other organizational purposes and departments, the ability to get the right information to the right people at the righ... Show More
Course Prerequisites:
To ensure success, students should have completed Microsoft® Office Excel® 2016: Basic or have the equivalen... Show More
Request a Quote

Instructor-Led Training (ILT)

Attend training in a classroom environment at a campus near you. Instructor-led training is still the number one delivery method of choice because it allows you to interact and discuss the training material, either individually or in a group setting, and you gain access to expert knowledge from certified instructors. This form of guided learning is impactful and produces positive learning outcomes. Day, evening and Saturday classes are offered.

Exam
Included

Duration
1 Day

Test your skills

Complete our assessment and test your skill level!

Course Content

Lesson 1: Working with Functions

  • Topic A: Work with Ranges
  • Topic B: Use Specialized Functions
  • Topic C: Work with Logical Functions
  • Topic D: Work with Date & Time Functions
  • Topic E: Work with Text Functions
  • Lesson 2: Working With Lists

  • Topic A: Sort Data
  • Topic B: Filter Data
  • Topic C: Query Data with Database Functions
  • Topic D: Outline and Subtotal Data
  • Lesson 3: Analyzing Data

  • Topic A: Create and Modify Tables
  • Topic B: Apply Intermediate Conditional Formatting
  • Topic C: Apply Advanced Conditional Formatting
  • Lesson 4: Visualizing Data with Charts

  • Topic A: Create Charts
  • Topic B: Modify and Format Charts
  • Topic C: Use Advanced Chart Features
  • Lesson 5: Analyzing Data with PivotTables and Pivot Charts

  • Topic A: Create a PivotTable
  • Topic B: Analyze PivotTable Data
  • Topic C: Present Data with Pivot Charts
  • Topic D: Filter Data by Using Timelines and Slicers
  • CTU Training Solutions , Updated: September 19th, 2018

    Share with friends

    Request a Quote



    Your Name

    Your Surname

    Contact Number

    Your Email

    Company

    Which campus would you like to study at?

    Your job title

    Will your training be sponsored?

    Message

    The course information above is subject to change without notification due to market trends in the industry, legislation and/or programme version updates. Terms and Conditions

    Join the CTU community

    Join the CTU Community Portal and gain access to superior resources.

    Join for Free

    Thank you for printing this page.
    Logo
    0861 100 395
    [email protected]
    www.ctutraining.ac.za

    X

    Call me Back

    Leave your details and we'll contact you back!

    Your Name:

    Your Email:


    Contact Number:

    Choose a campus