Learn: in:
» back to Search Results

Course rating of 4 Vendor rating of 4


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: Dec. 17
  • Location: Mississauga (Map)
  • Time: 9:30 am - 5:00 pm (Note on end times)
  • Please Note: End Times are approximate and depend
    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.
  • Duration: 1 Day
  • Delivery Method(s):Instructor Led, Instructor Assisted (Mentored), Virtual Instructor Led, Private One on One, Virtual Private One on One
  • Mentored training is a revolutionary training method
    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.
  • Discount Seats Available:2
  • Category:Microsoft Excel Training

 
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 changes

Detailed Course Outline:

1.     Introduction

a.     Welcome

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

5.    Formatting

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
Pre-Requisites

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

Certificates offered

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
Uloom Training
[ View Provider's Profile ]

Uloom Training
3050 Confederation Parkway, Unit 301C
Phone: 289-633-1975
Email: info@uloomtraining.com

Mississauga, Ontario
Canada   L5B 3Z6


Reviews
 
This course was very good as I was the only student and the instructor was a CPA (US) and I am a CA so all of my issues were understood by him. He was gracious and very competant which aways is a good set of skills to have. He was probably the best insructor I have had in any of the courses I have taken since university over 35 years ago. Thanks Mylo
Reviewed by 2015
17-December-2017 $432 Regular Price $540 Register for this course

Registration is fast, and will take approximately 3 minutes. There is no membership fee.
» You are also welcome to Make an Offer Make An Offer Help

Not enough budget for this course? Maybe you just love to make deals!
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!
need-to-train-a-group-banner

This course currently does not have any dates other than this one scheduled. Please call 1-877-313-8881 to enquire about future dates.

Not interested in this Course?

Tell us why:

This page has been viewed 29 times.