MS Excel Advanced, Workshop, 1 Day

MS Excel is an important computer program that most people think is only for data capturing in rows and columns but there’s a lot of functions that come with excel that make it more superior that MS Word and all this will be introduced to learners as per outline below. The format of this Training above will be classroom training at the client’s premises.

The content to be covered during the Training will be as per below:

  • Create and Edit a Macro
  • Update Workbook Properties
  • Apply Conditional Formatting
  • Add Data Validation Criteria
  • Trace Cells
  • Create a Data List Outline
  • Create Sparklines
  • Create Scenarios
  • Perform a What-If Analysis
  • Perform a Statistical Analysis with the Analysis ToolPak
  • Create Interactive Data with Power View
  • Consolidate Data
  • TLink Cells in Different Workbooks
  • Merge Workbooks
  • Export Excel Data
  • Import a Delimited Text File
  • Integrate Excel Data with the Web
  • Create a Web Query

Download course outline here

Request A Quote

<<< Back to Course List

Testimonials

  • Happy with the training received and we would recommend their training due to the exceptional service received.

    Mamoraka Makhafola - L & D Facilitator

  • No hesitation in recommending Twasa Training as the feedback received from our employees / learners was that the service was exceptional.

    Lindy Methula - Assistant Director

  • Training provided by Twasa Training was well received and effective. Administration of training was professional.

    Violet Ngwenya - HR Practitioner

Bee-Level-1
TETA
CESA
seta1