Learn: in:
» back to Search Results

Course rating of 5 Vendor rating of 5


This course builds upon the foundational knowledge presented in the Microsoft Excel 2016 Level 1 course & will help start you down the road to creating advanced workbooks & worksheets that can help deepen your understanding of organizational intelligence

  • Course Start Date: Sep. 26
  • Location: Winnipeg (Map)
  • Time: 8:30 am - 4:00 pm (Note on end times)
  • Please Note: End Times are approximate and depend
    on the number or students and pace of the class.
    It is important to allow for the class to run a little bit longer,
    or finish a little sooner, than expected.
  • Duration: 1 Day
  • Delivery Method(s):Instructor Led
  • Mentored training is a revolutionary training method
    that provides you with the quality training that
    you have come to expect, and combines it with
    flexible learning and a self paced environment.
    For more information click here.
  • Seats Available: YES
  • Category:Microsoft Excel Training

 
Course Outline
This course builds upon the foundational knowledge presented in the Microsoft Excel 2016 Level 1 course and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization that is able to compete at a high level.

Course Objectives: Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions.
You will:
• Work with functions.
• Work with lists.
• Analyze data.
• Visualize data with charts.
• Use PivotTables and PivotCharts.

Target Student: This course is designed for students who already have foundational knowledge and skills in Excel 2016 and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data.

Prerequisites: To ensure success, students should have completed Microsoft Excel 2016 Level 1 or have the equivalent knowledge and experience.

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: Using PivotTables and PivotCharts
Topic A: Create a PivotTable
Topic B: Analyze PivotTable Data
Topic C: Present Data with PivotCharts
Topic D: Filter Data by Using Timelines and Slicers


Prerequisites & Certificates
Pre-Requisites

To ensure success, students should have completed Microsoft Excel 2016 Level 1 or have the equivalent knowledge and experience.

Certificates offered

Certificate of completion


Cancellation Policy
Cancellation Policy & Satisfaction Guarantee
You may cancel or reschedule your registration without penalty up to 5 business days before your class date.

F.A.Q's...
Training Details
ASAP Training Ltd. is located at 950 - 167 Lombard Avenue, in Exchange District. A training manual is provided. We encourage all students to bring in a USB stick for student files as we no longer hand out course files on a CD.

Finding Us
ASAP Training Ltd. is located in the picturesque downtown Exchange District at 950-167 Lombard Avenue, in the Grain Exchange Building, you can access the building from Rorie Street and Lombard Avenue.

Class Times and Other Details
ASAP Training Ltd. classes begin promptly at 8:30 am and end around 4:00 pm. Our doors open at 8:00 am. Coffee and tea are provided for students. We have a kitchen with a microwave and refrigerator available for student use if they wish to bring their own lunch. Lunch break is one hour from approximately 11:30 to 12:30. A telephone and sitting area are available for student use. Our office is a non-smoking facility and is wheelchair accessible.

Restaurants
There are many restaurants available within walking distance of the school.

Parking
For your convenience, we have also provided a map of the available Parking Lots in proximity to the Grain Exchange Building, indoor and outdoor parking.
http://www.grainexchangebuilding.com/leasing/parking.html
Map & Reviews
ASAP Training.ca
[ View Provider's Profile ]

ASAP - New Location
950 167 Lombard Avenue
Winnipeg, MB
Canada   R3B 0V3


Reviews
 
Clint was great! Course content was exactly what I needed.
Reviewed by 2018
We are not on the 2016 Excel so there are a few things that do not apply to me. Also with my particular job excel is not a main component so there was some stuff I know I will not be using. However, I found the training to be very good and should I require to use some of the info I learned in the session I will be able to refer back to the booklet and with confidence I feel I will be able to figure it out.
Reviewed by 2018
N/A
Reviewed by 2018
Thank you Clint!
Reviewed by 2018
Clint is an excellent facilitator and was great to listen to, and was very engaging. He has an abundance of knowledge that was easily shared. Hope he facilitates the next course I take
Reviewed by 2018
26-September-2018 $255 Register for this course

Registration is fast, and will take approximately 3 minutes. There is no membership fee.
» You are also welcome to Make an Offer Make An Offer Help

Not enough budget for this course? Maybe you just love to make deals!
In either case, our Make an Offer feature gives you the opportunity to name
your own price. Try it out, you might get lucky, just keep in mind it can
take up to 1 full business day to get a response!

Not interested in this Course?

Tell us why:

This page has been viewed 6 times.