Learn: in:
» back to Search Results

Course rating of 4 Vendor rating of 4


Attend full-day course to learn Microsoft Excel 2013/2010 versions. This is all what you need to know to start using MS Excel with confidence. Covering All basic to medium level functions. You will also earn 7 PMI PDUs.

  • Course Start Date: Dec. 16
  • Location: Mississauga (Map)
  • Time: 9:00 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
  • 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

Introduction:
Whether you're a  novice or an expert wanting to refresh your skill set with Microsoft Excel,

This course covers allthe basics you need to start entering your data and building organisedworkbooks.

You will learn How toenter and organise your data, Perform calculations with simple functions,

Work with multipleworksheets, Format the appearance of your data, and build charts andPivot Tables.

We will cover thepowerful functions like

 

Course Outline:
Basic Features:

  • Usingthe Formula bar
  • Usingthe Status bar
  • Enteringdata with Auto Fill
  • Workingwith dates and times
  • Addingcomments
  • Creatingsimple formulas: Totals and averages
  • Copyinga formula for adjacent cells
  • Workingwith relative, absolute, and mixed references
  • UsingSUM and AVERAGE
  • Medium Level Functions:

  • Formatting
  • Formattingnumbers and dates
  • Conditionalformatting
  • Adjusting Worksheet Layout and Data
  • Hidingand un-hiding rows and columns
  • Printing
  • Creating charts:

  • Creating Bar Graphs
  • Pie Chart
  • Trend Lines 
  • Spark line 

  • DatabaseFeatures:

  • Sortingdata
  • Insertingsubtotals in a sorted list
  • Usingfilters
  • Splittingdata into multiple columns
  • Removingduplicate records
  • PivotTables:

  • CreatingPivotTables
  • ManipulatingPivotTable data
  • Groupingby date and time
  • Groupingby other factors
  • Usingslicers to clarify and manipulate fields 
  •  UsingPivotCharts 

  • Prerequisites & Certificates
    Pre-Requisites

    You may bring your own laptop with MS Excel 2013 / 2010 version installed. We can also provide PC if required

    Certificates offered

    Course Completion Certificate 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
     
    The training was quite good. However, it was difficult for me to know what I would actually be using in my day to day work as I am a fairly new employee here. The instructor Allan, was great able to explain excel operations very well for a beginner like myself.
    Reviewed by 2017
    Instructor was very knowledgeable
    Reviewed by 2016
    I was the only person in the class so he tailored his presentation to my needs. One of the best courses I have attended. If I would have left after the first hour I would have considered the course a 100% success.
    Reviewed by 2016
    Instructor was very helpful and experienced.
    Reviewed by 2015
    This was a great course and I feel a lot more confidant now with my excel skills. The teacher was very knowledgeable and answered all of my questions.
    Reviewed by 2015
    16-December-2017 $384 Regular Price $480 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 13 times.