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
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
- Usingthe Formula bar
- Usingthe Status bar
- Enteringdata with Auto Fill
- Workingwith dates and times
- Creatingsimple formulas: Totals and averages
- Copyinga formula for adjacent cells
- Workingwith relative, absolute, and mixed references
- UsingSUM and AVERAGE
Medium Level Functions:
- Formattingnumbers and dates
- Adjusting Worksheet Layout and Data
- Hidingand un-hiding rows and columns
- Creating Bar Graphs
- Pie Chart
- Trend Lines
- Spark line
- Insertingsubtotals in a sorted list
- Splittingdata into multiple columns
- Removingduplicate records
- ManipulatingPivotTable data
- Groupingby date and time
- Groupingby other factors
- Usingslicers to clarify and manipulate fields
- Prerequisites & Certificates
You may bring your own laptop with MS Excel 2013 / 2010 version installed. We can also provide PC if required
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
[ View Provider's Profile ]
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 5655 times.