Processing...

Home > Beyond Advanced Excel 2010

Learnfast Training Centres

One of SA’s largest short course providers. Our instructors are industry leaders in their field and courses are now presented in the following locations in Pretoria, Centurion, Sandton, Cape Town and Midrand

Read More

Contact Request


South Africa's largest short course provider

Beyond Advanced Excel 2010  

Overview

You will use the advanced features of Microsoft® Office Excel® 2010 to attain proficiency as an Excel  power user. 

Prerequisites

Excel 2010 knowledge, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data is required. You should also know how to write and edit simple formulas. To ensure the successful completion of Microsoft® Office Excel® 2010: Level 4, the following Element K courses or equivalent knowledge is recommended:  

  • Microsoft® Office Excel® 2010: Level 1
  • Microsoft® Office Excel® 2010: Level 2
  • Microsoft® Office Excel® 2010: Level 3 

Available Exams and Certifications

Certification:
MOS: Microsoft Office Excel 2010 Exam 77–882, MOS: Microsoft Office Excel Expert 2010 Exam 77–888

This course is one of a series of Element K courseware titles that addresses Microsoft Office Specialist (MOS) certification skill sets. The MOS and certification program is for individuals who use Microsoft's business desktop software and who seek recognition for their expertise with specific Microsoft products.

Course Outcomes

Upon successful completion of this course, students will be able to:  

  • Manipulate data using statistical and lookup functions.
  • Analyze data using the data analysis tools in Microsoft Excel 2010.  
  • Make investment decisions using the financial functions in Excel 2010.
  • Examine data using math functions in Excel 2010.
  • Manipulate data using text and information functions in Excel.
  • Create templates and work with Excel's advanced chart options.
  • Manage data in Excel workbooks. 

Price

R3050.00 per person Incl VAT

PLEASE NOTE: Learnfast serves a full lunch during break as well as coffee, tea and biscuits as part at no extra cost. We also cater for special meals.

Duration

1 Day (08:30 - 16:00)

Skill Level

  • Advanced

Our myWay Learning Methods

Our innovative "myWay” learning methodology is built around the students individual learning requirement, allowing each student to learn in a style that is most suitable for their skills set, knowledge and schedule.

Instructor-Led Classes

Reach your full potential through our “myWay Instructor-Led” classes combined with interactive lessons, supporting video content, practical assignments and in field experience. We deliver instructor led classes full time, part-time, weekends and onsite.

Read More

Mentored Learning

The "myWay Mentored Learning” was created in response for more flexible learning schedules and focused content. It allows each student to progress in a manner that is most suitable for their skills set, knowledge and schedule that a fixed, lecture based approach does not allow for. You will be mentored on a one to one basis by a subject matter expert with continues practical exposure and focus on problem areas, allowing you to progress at your own pace and deciding what content requires more or less time.

Read More

Distance Learning

Do a course at your own pace via our “myWay Distance Learning”. We have re-defined studying via online by combining self-study with supported interactive online video lectures, extra resources, questionnaires and much more, all supported via out Online Student Portal. You will get a course coach and lecturer assigned to you so that you never feel alone and have support whenever you need. Your coach will look after you and your study health, encouraging you to progress constantly.

Read More

Important Notes

  • Students are to be at the training venue by 08h00 in preparation for a 08h30 start time.
  • Learnfast retains the right to change this calendar without any notification.
  • Bookings are only confirmed upon receipt of the proof of payment or an official company purchase order for the full amount of the training.
  • For full day courses Learnfast will supply you with the relevant training material. A desktop computer to use for the training (where applicable), tea/coffee and a full lunch for full day InClass training hosted at Learnfast only. Catering is not included for OnSite training and laptop is available for hire at an additional cost if required.
  • Cancellation or rescheduling requests must be in writing and reach us via fax or email at least 5 (five) working days prior to the course commencement date. Full course fees may be retained for no shows or requests within 5 working days prior to commencement.
  • Although we go to great lengths to ensure that all training proceeds as scheduled, Learnfast reserves the right to cancel or postpone dates if we require to do so and undertake to inform clients in writing and telephonically of these changes.
  • Learnfast suggests clients wait until a week prior to course commencement that a course has been confirmed to go ahead as scheduled before booking flight and accommodation. Learnfast is NOT responsible for cost associated with cancellation of classes such as flight and accommodation for clients.

Lesson 1: Manipulating Data Using Statistical and Lookup Functions 

  • Topic 1A: Forecast GDP Using Statistical Functions  
  • Topic 1B: Evaluate Sales Data Using Statistical Functions  
  • Topic 1C: Analyze Stock Data Using Statistical Functions
  • Topic 1D: Mine Data Using the Lookup and Reference Functions  

Lesson 2: Analyzing Data Using Data Analysis Tools

  • Topic 2A: Analyze Sales Data Using Descriptive Statistics  
  • Topic 2B: Analyze Time Series Data Using Exponential Smoothing
  • Topic 2C: Analyze Data Using Regression  
  • Topic 2D: Identify the Beta Value of a Security  
  • Topic 2E: Analyze Sector Data Using Correlation and Covariance Matrices  
  • Topic 2F: Optimize a Stock Portfolio Using Solver  

Lesson 3: Working with Data Using Financial Functions

  • Topic 3A: Develop an Investment Schedule Using Financial Functions
  • Topic 3B: Make Investment Decisions Using Financial Functions  

Lesson 4: Examining Data Using Math Functions

  • Topic 4A: Analyze Sales Data Using Math Functions  
  • Topic 4B: Calculate Stock Returns Using Math Functions
  • Topic 4C: Aggregate GDP Data Using Math Functions  

Lesson 5: Manipulating Data Using Text and Information Functions

  • Topic 5A: Manipulate Data Using Text Functions  
  • Topic 5B: Validate Data Using Information Functions  

Lesson 6: Working with Templates and Charts

  • Topic 6A: Create Advanced Templates
  • Topic 6B: Create Advanced Charts  

Lesson 7: Managing Data in Workbooks

  • Topic 7A: Retrieve and Paste Data
  • Topic 7B: Clean Data in Workbooks 
Campus
Book Now
Type
End Date
Start Date

Cape Town, Pinelands
myWay Mentored Learning
31 Jan 2018
31 Jan 2018

Cape Town, Pinelands
myWay Mentored Learning
28 Feb 2018
28 Feb 2018

Cape Town, Pinelands
myWay Mentored Learning
05 Apr 2018
05 Apr 2018

Cape Town, Pinelands
myWay Mentored Learning
16 May 2018
16 May 2018

Cape Town, Pinelands
myWay Mentored Learning
13 Jun 2018
13 Jun 2018

Cape Town, Pinelands
myWay Mentored Learning
11 Jul 2018
11 Jul 2018

Cape Town, Pinelands
myWay Mentored Learning
08 Aug 2018
08 Aug 2018

Cape Town, Pinelands
myWay Mentored Learning
05 Sep 2018
05 Sep 2018

Cape Town, Pinelands
myWay Mentored Learning
10 Oct 2018
10 Oct 2018

Cape Town, Pinelands
myWay Mentored Learning
07 Nov 2018
07 Nov 2018

Campus
Book Now
Type
End Date
Start Date

Centurion, Pretoria
myWay Mentored Learning
24 Jan 2018
24 Jan 2018

Centurion, Pretoria
myWay Mentored Learning
21 Feb 2018
21 Feb 2018

Centurion, Pretoria
myWay Mentored Learning
28 Mar 2018
28 Mar 2018

Centurion, Pretoria
myWay Mentored Learning
25 Apr 2018
25 Apr 2018

Centurion, Pretoria
myWay Mentored Learning
23 May 2018
23 May 2018

Centurion, Pretoria
myWay Mentored Learning
20 Jun 2018
20 Jun 2018

Centurion, Pretoria
myWay Mentored Learning
18 Jul 2018
18 Jul 2018

Centurion, Pretoria
myWay Mentored Learning
15 Aug 2018
15 Aug 2018

Centurion, Pretoria
myWay Mentored Learning
12 Sep 2018
12 Sep 2018

Centurion, Pretoria
myWay Mentored Learning
17 Oct 2018
17 Oct 2018

Campus
Book Now
Type
End Date
Start Date

Midrand, Johannesburg
myWay Mentored Learning
07 Feb 2018
07 Feb 2018

Midrand, Johannesburg
myWay Mentored Learning
07 Mar 2018
07 Mar 2018

Midrand, Johannesburg
myWay Mentored Learning
11 Apr 2018
11 Apr 2018

Midrand, Johannesburg
myWay Mentored Learning
09 May 2018
09 May 2018

Midrand, Johannesburg
myWay Mentored Learning
06 Jun 2018
06 Jun 2018

Midrand, Johannesburg
myWay Mentored Learning
04 Jul 2018
04 Jul 2018

Midrand, Johannesburg
myWay Mentored Learning
01 Aug 2018
01 Aug 2018

Midrand, Johannesburg
myWay Mentored Learning
29 Aug 2018
29 Aug 2018

Midrand, Johannesburg
myWay Mentored Learning
03 Oct 2018
03 Oct 2018

Midrand, Johannesburg
myWay Mentored Learning
31 Oct 2018
31 Oct 2018


 In-Class    Onsite    Distance Learning