Trusted Training Partners

Quick Look Course Summary:Ms Office Excel Advanced 2010 Satur 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

    Ms Office Excel Advanced 2010 Satur Training Course Course: Introduction

    This is the Advanced Saturday course in Excel, it is intended for intermediate Excel users who wish to gain an expert level of knowledge about Excel. We will discuss advanced functions and features, including pivot tables. This is a practical course and all materials needed by participants will be provided.

    Ms Office Excel Advanced 2010 Satur Training Course Course :Course Outline

    1. Analysing Alternative Data Sets
    Scenario Manager and Scenario Summary
    Goal Seek
    Solver
    Analysing Data by using statistics
    Creating custom views

    2. Advanced Functions
    If Statements
    Other functions
    Nested If Statement
    SumIf, CountIf, AverageIf
    Round function
    PMT Function
    Showing and or Hiding Formulas

    3. Creating Dynamic Worksheets by Using Pivot Tables
    Working with Pivot Tables
    Adding Fields to Pivot Tables
    Filter, Show and Hide Pivot Table data
    Using Slicers to filter data
    Rearranging Pivot Tables
    Moving fields
    Collapsing and Expanding Fields
    Refreshing Data
    Editing Pivot Table
    Show Value As
    Get Pivot Data function
    Adding Subtotals and Grand Totals
    Formatting field settings
    Applying a Pivot Table Style
    Creating a new custom Pivot table Style
    Creating Pivot Tables from external data import

    4. Creating Charts and Graphics
    Customising the appearance of charts
    Trend lines
    Sparklines
    Pivot Charts
    Smart Art
    Insert Shapes and Mathematical Equations

    5. Automation of Repetitive Tasks Using Macros
    Enabling and Examining Macros
    Creating Macros
    Editing Macros
    Add Macros button to Quick Access Toolbar
    Run a macro when a workbook is opened

    6. Working with Other Microsoft Office Programs
    Linking and or Embedding other office files
    Hyper linking
    Pasting charts into other documents

    Ms Office Excel Advanced 2010 Satur Training Course Course: Course Duration

    1 day/s

    Who should attend: Ms Office Excel Advanced 2010 Satur 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