• Course
  • Vendor

This course is designed for users with a good understanding of Excel fundamentals. The course will provide more advanced concepts required to consolidate and navigate data across multiple worksheets and workbooks...

  • Course Start Date: 2019-08-06
  • Time: 09:00:00 - 16:00:00
  • Duration: 1 Day(s)
  • Location: Edmonton
  • Delivery Methods(s): Instructor Led
$160.00
REGULAR PRICE $200.00 Save $40.00
August 6th
Click for more dates
2 discount seats left!
or make an offer
need-to-train-a-group-banner

Course Outline

Pre-Requisites

Excel Level 1 or equivalent experience

Lessons

This course is designed for users with a good understanding of Excel fundamentals. The course will provide more advanced concepts required to consolidate and navigate data across multiple worksheets and workbooks. Participants will work with built-in functions such as “if statements” “vlookup”, “pmt”, “dates”, “stats”. We will analyze and organize data using charts. some functions and security. Some advanced features include creating templates, styles, conditional formatting and protecting your data.

Course Content
Overview
Customizing the Ribbon
Customizing the Quick Access Toolbar
Using and Customizing AutoCorrect
Command Shortcut Keys
Workbook Templates

Using Multiple Workbooks and Worksheets
Setting up Multiple worksheets
Copying, Moving, Deleting Worksheets
Consolidating Data
Creating Links with Formulas
Hyperlinks
Name Ranges
Paste Special – linking
Tiling – sheets, workbooks, applications
Freeze Panes
Split
View Side by Side

Review Spreadsheets
Track Changes
Comments

Functions
Function Concepts
Stats: averagea, counta
Logical: if statements, vlookup
Financial: PMT
Math: Round up, Round down
Dates: today, date

Applying Advanced Formatting
Creating Table Styles
Working with Table Styles
Creating Cell Styles
Using Conditional Formatting
Creating and Managing Conditional Formatting Rules

Charts
Creating Charts
Changing Chart Data
Resizing and Moving a Chart
Change Chart Type
Working with Chart Labels
Working with Chart Backgrounds
Changing a Chart's Source Data
Modifying Chart Elements
Using Chart Templates

Worksheet Organization
Protect Sheet
Protect Workbook
Share Workbook
Allow Users to Edit Ranges
Worksheet Security
Inspect Document
Check Compatibility
Mark as Final
Encrypt with Password

Cancellation Policy

10 business days cancellation or full course fee will be charged

Training Location

TTC, B-11 Cameron Library
11320-89 Avenue, University of Alberta

Edmonton, Alberta
Canada   

About Technology Training Centre

x

Technology Training Centre is THE place for computer software training in Alberta.
This is where you come to learn how to get more from the computer or the mobile device in front of you.
Register for courses on Microsoft Office and the Adobe Creative Suite along with customized one on one or group training.
Come to the heart of the University of Alberta campus to learn from our instructors. These highly skilled professionals will also travel across the province to deliver exceptional training for you and your company.
We have your MS Office needs covered, including training on upgrading to a newer version of the software. We offer courses in Microsoft Word, Excel, PowerPoint, Access, SharePoint, Publisher, SQL, Visio, Project, Outlook, OneNote, and InfoPath.
Our graphic designers will train you in Adobe Photoshop, InDesign, Illustrator, Dreamweaver, Acrobat, Lightroom, and Visual Design. If you need training for your digital camera, we’ll provide that as well.

You will also receive:
•    6 months of email support on courses.
•    The option to retake courses within 6 months at no additional charge.
•    Training from instructors that use each of the software packages they teach and have the ability to go beyond what is covered in the outline.
 

Training Provider Rating

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

No comment

Reviewed Feb 2019

The course was excellent, the instructor Rachel was great.

Reviewed Nov 2018

No comment

Reviewed Nov 2018

No comment

Reviewed Sep 2018

Was a very informative course.

Reviewed Aug 2018

No comment

Reviewed Feb 2018

My payments were taken care of by last minute training with the University of Alberta. The teacher was good, the content was good.

Reviewed Feb 2018

I already completed a survey at the end of the course so not sure why I have to complete another survey on line? LOL

Reviewed Jan 2018

No comment

Reviewed Dec 2017

No comment

Reviewed Nov 2017

No comment

Reviewed Oct 2017

The information learned in this course will assist me in my current role. Enjoyed the class.

Reviewed Sep 2017

No comment

Reviewed Jun 2017

I would have preferred using the manual given to follow, so I could add my notes to each area as we worked through the course. Unf ... Read more
x

I would have preferred using the manual given to follow, so I could add my notes to each area as we worked through the course. Unfortunately all my notes are in the beginning of the book as we, only looked it once, when a student asked what page we were on.

Reviewed May 2017

No comment

Reviewed May 2017

More useful contents can be fit in and taught in this class definitely.

Reviewed Feb 2017

No comment

Reviewed Feb 2017

Worthwhile training that provided me with the skills needed to use Onenote.

Reviewed Nov 2016

No comment

Reviewed Jun 2016

No comment

Reviewed Jun 2016

Course Reviews

This course has an overall avarage rating of 4.40 out of 5 based on 2 reviews.

Previous

Naushaba Q attended this course Nov 2018

Course Content

Delivery Structure

Instructor Ability

The course was excellent, the instructor Rachel was great.

Patricia B attended this course Oct 2017

Course Content

Delivery Structure

Instructor Ability

No comment