To access the old site click here! X

  • Course
  • Vendor

This course provides beginner concepts required to produce basic spreadsheets. Participants will learn how to create, save, open and close files; enter data; as well as edit using insert, delete, move and copy functions...

  • Course Start Date: 2019-03-01
  • Time: 09:00:00 - 16:00:00
  • Duration: 1 Day(s)
  • Location: Edmonton
  • Delivery Methods(s): Instructor Led

Course Outline

Pre-Requisites

Basic computer concepts, skills and knowledge of Windows

Lessons

This course is designed for new users. The course provides beginner concepts required to produce basic spreadsheets. Participants will learn how to create, save, open and close files; enter data; as well as edit using insert, delete, move and copy functions. This course presents simple formula creation concepts including the use of built-in functions. Relative & absolute formulas will also be covered. On completion of this course students will be familiar with formatting features such as: row heights, column width, alignment, merge cells and number styles. Participants will also work with margins, headers and footers to enhance page layout in different views to prepare for printing.

Course Content
Excel Layout
Ribbon
Quick Access Toolbar
Backstage
Status Bar
Keyboard Commands
Contextual Menus and the Mini Toolbar
Help

Managing Workbooks
Types of Data
Creating a Blank Workbook
Opening an Existing Workbook
Saving Workbooks

Excel Data

Entering Data
Navigating in Excel
Selecting Cells
Ranges
AutoFill
AutoComplete

Excel Formulas

Creating Formulas – Operators and Built-In Functions
Relative, Absolute, and Mixed Reference
Sum, Average, Max, Min
Finding the “right” function - PMT

Editing in Excel
Edit Mode
Cut, Copy and Paste
Paste Special – linking
Undo and Redo
Using and Customizing AutoCorrect
Changing Column and Row Size
Inserting Cells, Rows and Columns
Deleting Cells, Rows, and Columns
Deleting Contents of a Cell
Find and Replace
Clear Formatting in a Cell
Comments
Go to Feature
Spell Checking

Formatting in Excel
Formatting Cells
Numbers
Font
Alignment – Merge and Center
Borders
Patterns and Colors
Format Painter

Printing in Excel

Margins
Orientations

Print Features
Page Layout View
Page Break Preview
Hide and Unhide Columns
Custom Views
Print Titles
Headers, Footers
Scale to Fit

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 195 reviews.

The course was excellent, the instructor Rachel was great.
No comment
No comment
Was a very informative course.
No comment
My payments were taken care of by last minute training with the University of Alberta. The teacher was good, the content was good.
I already completed a survey at the end of the course so not sure why I have to complete another survey on line? LOL
No comment
No comment
No comment
The information learned in this course will assist me in my current role. Enjoyed the class.
No comment
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.

No comment
More useful contents can be fit in and taught in this class definitely.
No comment
Worthwhile training that provided me with the skills needed to use Onenote.
No comment
No comment
I had a lot of knowledge on the course I took but I still learned a few new things which is really nice to come out of a course le ... Read more
x

I had a lot of knowledge on the course I took but I still learned a few new things which is really nice to come out of a course learning something. Thanks for the informative day. Doreen

Course Reviews

This course has an overall avarage rating of 4.13 out of 5 based on 3 reviews.

Previous

Jolie Van Den Bussche attended this course Aug 2018

Facilities

Course Content

Delivery Structure

Instructor Ability

Was a very informative course.

Celina Cathro attended this course Feb 2018

Facilities

Course Content

Delivery Structure

Instructor Ability

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

Danielle Kiltz attended this course Nov 2017

Facilities

Course Content

Delivery Structure

Instructor Ability

No comment
Next

More Courses from Technology Training Centre

TECHNOLOGY TRAINING CENTRE
2019-03-01
Edmonton
TECHNOLOGY TRAINING CENTRE
2019-03-19
Edmonton
TECHNOLOGY TRAINING CENTRE
2019-01-07
Edmonton
TECHNOLOGY TRAINING CENTRE
2019-03-21
Edmonton

More Courses in 'Microsoft Excel Training' Category

GLOBAL KNOWLEDGE
2019-06-17
Edmonton
GLOBAL KNOWLEDGE
2019-04-29
Edmonton
GLOBAL KNOWLEDGE
2019-03-01
Edmonton
TECHNOLOGY TRAINING CENTRE
2019-03-18
Edmonton