Trusted Training Partners

Quick Look Course Summary:Beyond Advanced Excel 2010 Training Course Course
  • Next Public Course Date:

  • Length: 1 day(s)

  • Price (at your venue): 1 Person R 4,475.00 EX VAT 3 Person R 3,399.06 EX VAT 10 Person R 2,529.41 EX VAT

  • Certification Type:Accredited

  • Locations & Venues: Off-site or in-house. We train in all major city centres throughout South Africa.

Get Free & personalised
Training Advice

    Beyond Advanced Excel 2010 Training Course Course: Introduction

    This course is intended for advanced Excel users who wish to have an expert knowledge of Excel and it’s various advanced features and functions. This course has two follow on courses, Microsoft Excel Pivot Tables and Excel macros with VBA.

    Beyond Advanced Excel 2010 Training Course Course :Course Outline

    1. Manipulating Data Using Statistical and Lookup Functions.

    Forecast GDP Using Statistical Functions
    Evaluate Sales Data Using Statistical Functions
    Analyze Stock Data Using Statistical Functions
    Mine Data Using the Lookup and Reference Functions

    2. Analysing Data Using Data Analysis Tools

    Analyse Sales Data Using Descriptive Statistics
    Analyse Time Series Data Using Exponential Smoothing
    Analyse Data Using Regression
    Identify the Beta Value of a Security
    Analyze Sector Data Using Correlation and Covariance Matrices
    Optimize a Stock Portfolio Using Solver

    3. Working with Data Using Financial Functions

    Develop an Investment Schedule Using Financial Functions
    Make Investment Decisions Using Financial Functions

    4. Examining Data Using Math Functions

    Analyse Sales Data Using Math Functions
    Calculate Stock Returns Using Math Functions
    Aggregate GDP Data Using Math Functions

    5. Manipulating Data Using Text and Information Functions

    Manipulate Data Using Text Functions
    Validate Data Using Information Functions

    6. Working with Templates and Charts

    Create Advanced Templates
    Create Advanced Charts

    7. Managing Data in Workbooks

    Retrieve and Paste Data
    Clean Data in Workbooks

    Beyond Advanced Excel 2010 Training Course Course: Course Duration

    1 day/s

    Who should attend: Beyond Advanced Excel 2010 Training Course Course

    This course is intended for advanced users of Microsoft Excel.

    **Quote does not include Any Exam Fees (if applicable)

    IMPORTANT ACTION: Do Not Wait To Improve Your Skills.  

    Book Now By Completing Online Booking Form / Customised Proposal or Obtain Approval For Your Already Received Customised Proposal

    Realize incredible savings by sending more delegates

    Do you want to save costs by doing training at your premises?

    Save costs by providing own laptop

    Region *

    Please Contact Us Now - We Will Respond in 15 Minutes


      Accredited Courses

      Additional Courses

      Leadership & Management Courses

      Software & IT Courses

      Top Rated