This course is instructor guided hands-on workshop based on 2010/2013 versions of MS Excel. You will learn how Excel helps Accountants, IT professionals and those interested in using excel in a typical office environment for organising data and research.
- Course Start Date: Oct. 22
- Location: Mississauga
- Time: 9:30 am - 5: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, Instructor Assisted (Mentored), Virtual Instructor Led, Private One on One, Virtual Private One on One
- Discount Seats Available:2
- 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
High Level Course outline:
1. What is Excel and what is it usedfor?
2. Using the menus
3. Working with dates and times
4. Creating simple formulas
5. Formatting fonts, row andcolumn sizes, borders, and more
6. Inserting shapes, arrows, andother graphics
7. Adding and deleting rows andcolumns
8. Hiding un-hiding data, rows andcolumns
9. Moving, copying, and pasting
10. Sorting and filtering data
11. Printing your worksheet
12. Securing your workbooks
13. Tracking changesDetailed Course Outline:
b. Using the exercise files
2. Getting Started withExcel 2013
a. What is Excel used for?
b. Using the menu system
c. The Quick Access Toolbar
d. The structure of a worksheet or workbook
e. Using the Formula bar
f. Using the Status bar
g. Navigation and mouse pointers
h. Shortcut menus and the Mini toolbar
i. Using the built-in help
j. Creating new files
3. Entering Data
a. Exploring data entry and editing techniques
b. Entering data with AutoFill
c. Working with dates and times
d. Using Undo and Redo
e. Adding comments
f. Using Save or Save As
4. Creating Formulas andFunctions
a. Creating simple formulas:Totals and averages
b. Copying a formula foradjacent cells
c. Calculating year-to-dateprofits
d. Creating apercentage-increase formula
e. Working with relative,absolute, and mixed references
f. Using SUM and AVERAGE
g. Using other commonfunctions
a. Exploring font styles and effects
b. Adjusting row heights andcolumn widths
c. Working with alignmentand Wrap Text
d. Designing borders
e. Exploring numeric andspecial formatting
f. Formatting numbers anddates
g. Conditional formatting
h. Creating and using tables
i. Inserting shapes, arrows,and other visual features
6. Introduction to Charting
a. Creating charts
b. Exploring chart types
c. Formatting charts
d. Working with axes,labels, gridlines, and other chart elements
e. Creating in-cell chartswith sparklines
7. Adjusting Worksheet Views
a. Freezing and unfreezingpanes
b. Splitting screenshorizontally and vertically
c. Showing necessaryinformation with the Outlining feature
8. Multiple Worksheets and Workbooks
a. Displaying multipleworksheets and workbooks
b. Renaming, inserting, anddeleting sheets
c. Moving, copying, andgrouping sheets
d. Using formulas to linkworksheets and workbooks
- Prerequisites & Certificates
Familiarity with using a computer Please bring your laptop equipped Windows 7 or above, WiFi enabled Preferably pre-installed with MS Excel 2010/2013 If not then instructor will guide you to install a trial version If you do not have a laptop with above configuration, let us know in advance and we will make an appropriate arrangement
Course Completion Certificate; Training Material; 7 PMI PDUs for PMP certified students
- Cancellation Policy
Registered courses can be cancelled up to 3 business days before the course start date. Administrative charges equivalent to 10% of the course fee will apply.
- Map & Reviews
[ View Provider's Profile ]
3050 Confederation Parkway, Unit 301C
Canada L5B 3Z6
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 33 times.