>
0 items - $0.00

Your shopping cart is empty

Why not add some items in our Shop
Call Us at +27 21 786 1224

ADVANCED EXCEL TRAINING COURSE: On-site Services offered at Cape Town, University Estate, Woodstock, Northern Suburbs, Bellville, Brackenfell, Brooklyn, Durbanville, Goodwood, Panorama, Parow, Somerset West, Hout Bay, Southern Suburbs, Bergvliet, Claremont, Constantia, Kenilworth, Newlands, Observatory, Pinelands, Plumstead, Rondebosch, Tokai, Wynberg, South Peninsula, Fish Hoek, Kommetjie, Muizenberg, Gordon’s Bay, Somerset West, Strand, West Coast, Edgemead, Tableview, Paarl, Worcester, Langebaan, Western Cape, Bloemfontein, East London, Durban. Enquire about your location if not listed here.

 

Advanced Excel Training Course

(Non credit bearing computer skill course)

The Microsoft Excel Training Course – Advanced Skills will help a learner to learn that advanced formats and shortcuts in Excel. The learner will be taught how to streamline workflow, collaborate on documents, audit worksheets, analyse data, work with multiple workbooks and how to import and export data.

 

Learner Objectives

  • Enhance productivity and effieciency by streamlining the workflow
  • Collaborate with other workbook users
  • Audit worksheets
  • Analyse data
  • Work with multiple workbooks
  • Import and export data
  • Integrate Excel data with the web

Duration

  • The programme duration is 8 hours and tuition is face-to-face.  The course is presented full-time during the day from 8:30 to 12:30.

Admission Requirements

  • English, read & write                                .
  • No specified previous learning
  • Positive Attitude

Learner Material

  • Course material will be provided

Learners will be issued a Certificate of Completion

 

Pricing:

Note that when I offer the monthly workshop which were not booked by a single person or company at a venue determined by me, the maximum fee of R2,300 applies.

Registration: 50% Deposit

Workshop Fees: 
We offer training ONLY to a minimum of 6 learners 
6 or more learnersR2,200
People older than 55 years provided there are at least 10 learners.  One day can be split in 2 and be offered over 2 months but all learners will then still commit to both days.R2,200

Please note, to justify our cost, for services delivered outside of Cape Town, a minimum of 6 candidates are required for training. 

 

EXCEL ADVANCED TRAINING CONTENTS

  1. Advanced functions and formulas
    • Logical functions
    • Conditional functions
    • Financial functions
    • Text functions
    • Date and time functions
    • Array formulas
    • Calculation options
  2. Lookups and data tables
    • Using lookup functions
    • Creating data tables
  3. Advanced data management
    • Validating cell entries
    • Advanced filtering
  4. Advanced charting
    • Chart formatting options
    • Combination charts
    • Graphical objects
  5. PivotTables and PivotCharts
    • Working with PivotTables
    • Modifying PivotTable data
    • Formatting PivotTables
    • Using PivotCharts
    • PowerPivot
  6. Exporting and importing data
    • Exporting and importing text files
  7. Analytical tools
    • Goal Seek
    • Scenarios
    • Instant data analysis
    • Unit summary: Analytical tools
    • Macros and Visual Basic
    • Running and recording a macro
    • Working with VBA code
  8. Accessibility and language features
    • Accessibility considerations
    • Internationalization

 

More areas where services are offered De Waterkant, Foreshore, Gardens, Higgovale, Tamboerskloof, Vredehoek, Kensington, Monte Vista, Atlantic Seaboard, Bantry Bay, Camps Bay, Clifton, Fresnaye, Green Point, Llandudno, Mouille Point, Sea Point, Three Anchor Bay, Bishopscourt, Diep River, Harfield Village, Steenberg, Capri Village, Clovelly, Glencairn, Kalk Bay, Lakeside, Marina da Gama, Noordhoek, Scarborough, Simon’s Town, St James, Sunnydale, Sun Valley, Helderberg, Firgrove, Bloubergstrand, Bothasig, Melkbosstrand, Milnerton, West Beach, Parklands, and Grahamstown, Oudtshoorn.

 

Tag: Microsoft Excel Advanced Training, Advanced Excel Training Course, Microsoft Excel Training, Intermediate Excel Training Course, Computer, Basic Excel Training, Excel Training Courses, Excel Course, Computer Training Courses, Excel Courses, Microsoft Project Training, Computer Courses For Beginners, Pc Training, Online Computer Courses