In this course you'll learn how to: conditionally format data; work with Slicers; work with Power View; work with Inquire Add-In; use Tables; work with Records & Fields; use Excel as a database; create custom AutoFill lists; add comments; track changes..
- Course Start Date: Jun. 19
- Location: Ottawa
- Time: 9:00 am - 4:00 pm (Note on end times)
- Duration: 1 Day
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.
- Delivery Method(s):Instructor Led
- Seats Available: YES
- Category:Microsoft Excel Training
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.
- Course Outline
In this course you will learn how to: conditionally format data; work with Slicers; work with Power View; work with Inquire Add-In; use Tables; work with Records and Fields; use Excel as a database; create custom AutoFill lists; add comments; track changes; link, consolidate, and combine data.
- Module 1: Using Conditional Formatting
- Applying Conditional Formatting
- Applying Multiple Rule Sets
- Creating Custom Rule Sets
- Viewing and Managing Rules
- Clearing Custom Rules
- Module 2: Working with Slicers
- Inserting and Using a Slicer
- Renaming the Slicer
- Changing Slicer Settings
- Formatting a Slicer
- Clearing the Slicer
- Module 3: Using Power View, Part One
- Enabling Power View
- Creating a Power View
- Adding and Removing Fields
- Arranging Fields
- Filtering Data
- Sorting Data
- Module 4: Using Power View, Part Two
- Refreshing Data
- Choosing a Visualization
- Changing Tile Display
- Setting Display Options
- Module 5: Using the Inquire Add-In
- Installing Inquire
- Generating a Workbook Analysis Report
- Viewing Workbook and Worksheet Relationships
- Viewing Cell Relationships
- Comparing Two Workbooks
- Module 6: Working with Tables
- What is a Table?
- Creating Tables
- Resizing the Table
- Choosing a Table Style
- Clearing the Table
- Module 7: Working with Records and Fields
- What are Records and Fields?
- Adding Fields by Inserting Columns
- Adding Records by Inserting Rows
- Deleting Records or Fields
- Module 8: Using Excel as a Database
- Filtering with Wildcard Characters
- Validating Your Data
- Data Validation Using Lists
- Data Validation Using Formulas
- Using Database Functions
- Module 9: Using Custom AutoFill Lists
- Creating a Custom AutoFill List
- Using a Custom AutoFill List
- Modifying a Custom AutoFill List
- Deleting a Custom AutoFill List
- Module 10: Using Comments
- Inserting Comments
- Editing Comments
- Navigating Through Comments
- Deleting Comments
- Module 11: Tracking Changes
- Tracking Changes
- Reviewing Changes
- Setting Options for Tracking Changes
- Stopping Tracking Changes
- Module 12: Linking, Consolidating, and Combining Data
- Linking Workbooks
- Consolidating Workbooks
- Consolidating Worksheets
- Pivoting Consolidated Data
- Module 1: Using Conditional Formatting
- Prerequisites & Certificates
MO13EX201—Microsoft Excel 2013 Advanced Essentials or equivalent is mandatory
Certificate of completion
- Cancellation Policy
Eliquo Training and Development Inc. will make every attempt to be flexible in regards to class cancellations and rescheduling. In an attempt to make sure that everyone enjoys a consistent training experience, Eliquo offers the following cancellation policy:
Any student cancellation that occurs a minimum of six (6) business days prior to a scheduled class is eligible for a full class credit or a 100% refund on the cost of the class.
Due to scheduling logistics, if you cancel or re-schedule a registration within five (5) business days of the course date, payment is due in full at that time and will be held as a credit towards a re-scheduled date or a future course booking. Course credits are valid for 12 months from the date of the original class booking.
All cancellations and rescheduling must be in writing and sent either by email to email@example.com or by fax to 647.258.9319. Verbal communication of a cancellation will not meet our refund requirements.
In the event that a class is cancelled due to insufficient enrollment, your full registration fee will be refunded or you can reserve a seat in the next available class. You will be notified of a class cancellation at least five (5) business days in advance of the scheduled class.
Eliquo Training and Development Inc. reserves the right to postpone or cancel a class at any time, in which case the refund and rescheduling policy would apply. Eliquo Training and Development Inc. is not liable for any travel expenses incurred by the student, even in the event of a cancellation.
- Map & Reviews
[ View Provider's Profile ]
185 Somerset St West.
Canada K2P 0J2
ReviewsHere are some reviews of the training vendor.
This course has not yet been rated by one of our members.
If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.
Registration is fast, and will take approximately 3 minutes. There is no membership fee.
» You are also welcome to Make an Offer
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!
This course is also scheduled on the following dates:
Not interested in this Course?
Tell us why:
This page has been viewed 38 times.