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 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 ]

    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
    need-to-train-a-group-banner

    This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

    This page has been viewed 4930 times.