To access the old site click here! X

  • Course
  • Vendor

Microsoft Office Excel 2016 is the newest version of Microsoft's popular spreadsheet program. This explores the advanced features in Excel 2016. Students will cover how to automate worksheet functionality, audit worksheets, analyze data...

  • Course Start Date: 2019-02-13
  • Time: 09:00:00 - 16:00:00
  • Duration: 1 Day
  • Location: Ottawa
  • Delivery Methods(s): Instructor Led

Course Outline

Pre-Requisites

MO16EX201—Microsoft Excel 2016 - Part Two or equivalent is mandatory.

Lessons

Microsoft Office Excel 2016 is the newest version of Microsoft's popular spreadsheet program. This explores the advanced features in in Excel 2016. Students will cover how to automate worksheet functionality, audit worksheets, analyze data, work with multiple workbooks, export Excel data and import/export XML data.

Course Outline
  • Automating Worksheet Functionality
    • This lesson gives students the skills to dig into automating worksheet functionality. Along the way they will learn how to update worksheet properties, create and edit a macro, apply conditional formatting, and add data validation criteria to a workbook.
  • Auditing Worksheets
    • This lesson digs deeper into worksheets and students will learn here how to: trace cells, troubleshoot invalid data and formula errors, watch and evaluate formulas, and create a data list online.
  • Analyzing and Presenting Data
    • Now that your students are very well versed in worksheets, it's time to move into a deeper look at data with this lesson. Students will learn here how to: create Sparklines, create scenarios, perform a what-if analysis, perform statistical analysis with the Analysis ToolPak, and create interactive data with Power View.
  • Working with Multiple Workbooks
    • Often times, users of Excel will be juggling multiple workbooks at once and this lesson takes a look at that skill. This lesson will teach students how to: consolidate data, link cells in different workbooks, and merge workbooks.
  • Exporting Excel Data
    • Your students have their data and they want to export it, well they can learn about that here. This lesson covers how to: export Excel data, import an delimited text file, integrate Excel data with the web, and create a web query.
  • Importing and Exporting XML Data
    • This course wraps up here with this lesson showing your students how to import and export XML data.
 

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 registrations@lastminutetraining.ca 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.

Training Location

Eliquo Ottawa
185 Somerset St West. Suite 312

Ottawa, Ontario
Canada   

About Eliquo Training

x

Finding Adobe Flash training in Ottawa has never been more easy or affordable. Our Ottawa based training school is an authorized Adobe training school. Acrobat training right through to Flash training, if it's Abode training you need then we are the school for you. Training for designers... Unleash the power of your desktop-design and publishing applications. Whether you're a mock-up guru or a pixel novice, Eliquo's nationally renowned Adobe & design training courses can teach you to navigate menus, manipulate graphics, convert files and manage workflow with ease. And if you're managing a team of designers... Make sure your organization's message is heard. Eliquo's consulting and development services can help you assess your resources, analyze your needs and deliver persuasive communications to unlock your growth potential. Teaching Creative Excellence Eliquo Training and Development Inc. is dedicated to teaching the art--and science--of graphic and web design. Eliquo's team of technical specialists, certified instructors and creative professionals delivers a range of custom-developed courses on leading desktop-design and publishing applications. Characterized by creative excellence, flexible scheduling, customized curricula and one-on-one attention, our more than 75 offerings focus on the powerful features our clients can exploit immediately to improve design integrity and meet tight deadlines. Professional Qualifications Eliquo Training & Development Inc. is an Adobe Authorized Training Centre and an official training provider for Corel Corporation. All of Eliquo's instructors are Adobe Certified Experts and Adobe Certified Instructors.

Training Provider Rating

This vendor has an overall average rating of 4.38 out of 5 based on 102 reviews.

No comment
training was cancelled again for the 5 or 6th time. It is beyond words how a course is advertised and then not provided over and ... Read more
x

training was cancelled again for the 5 or 6th time. It is beyond words how a course is advertised and then not provided over and over and over. I took a prerequisite course so I could take this course and I am not happy.

No comment
ask participants when they would like breaks and lunches to accommodate all.
No comment
No comment
No comment
No comment
have virtual course availability for people on the West Coast, Pacific Time, as in does not start at 6am and lunch at 9am, very di ... Read more
x

have virtual course availability for people on the West Coast, Pacific Time, as in does not start at 6am and lunch at 9am, very disruptive

This was an excellent course. The only criticism I have is that the material was covered very quickly, and there were no handouts ... Read more
x

This was an excellent course. The only criticism I have is that the material was covered very quickly, and there were no handouts that would allow students to remember or recreate the steps that were used to complete the assignments. So, now that I am back home and trying to do some of the same things in Adobe After Effects that we did during the course, I have trouble remembering exactly what to do (e.g.: what icon to click, what drop-down menu to select). Step-by-step handouts would be very useful!

The only reason I gave the seminar schedule two stars was because I was participating remotely from the west coast so a start time ... Read more
x

The only reason I gave the seminar schedule two stars was because I was participating remotely from the west coast so a start time of 9am EST was difficult to manage. Otherwise, good course all-around.

I thought the instructor did a good job in keeping the class moving despite have most of us online. There were a few times the cla ... Read more
x

I thought the instructor did a good job in keeping the class moving despite have most of us online. There were a few times the class went on some tangents that were not relevant to all parties. We didn't use the files provided to us prior to the training. I feel that I would have felt more accomplished if I had put together a cohesive course as part of the session, rather than try this and play for a bit. I don't really have anything too concrete to go back and refer to as I begin to create using Storyline.

No comment
No comment
No comment
No comment
No comment
Course was great. Instructor did an excellent job.
No comment
All is well

Course Reviews

No Reviews Yet

More Courses from Eliquo Training

More Courses in 'Microsoft Excel Training' Category

COMPUEASE
2019-03-29
Ottawa
COMPUEASE
2019-05-17
Ottawa
GLOBAL KNOWLEDGE
2019-06-19
Ottawa