We've noticed this is not your region.
Redirect me to my region
What do you want to learn today?

Details

  1. Importing Text Files
    1. Dragging and dropping Text
    2. Importing and Linking a Text File
    3. Refreshing Linked Data
    4. Exporting Data
  2. Named Ranges
  3. Working with Large Documents
  4. Conditional Formatting
  5. Filtering Data
  6. Data Forms
  7. Sorting Data
  8. Subtotals
  9. Charts
    1. Elements of a Chart
    2. Formatting a Chart
  10. Objects
  11. Linking and Consolidating Worksheets
  12. Linking Workbooks
    1. Consolidate Data from Multiple Worksheets
    2. Consolidate by Categories
    3. Consolidate by Position
  13. Hide/ Unhide
    1. Columns
    2. Rows
    3. Worksheets
  14. Advanced Display Features
    1. Changing Cell Gridlines
    2. Displaying and Printing Formulas
    3. Adding Color to Worksheet Tabs
    4. Adding a Background to a Worksheet
  15. Macros
    1. Creating a Macro
    2. Running a Macro
    3. Creating a Macro to Identify Data
    4. Creating a Macro to Format Data
    5. Assigning a Macro to a Tool button
  16. Functions
    1. Date and Time Worksheet Functions
    2. Text Functions
    3. Mathematical Functions
    4. Statistical Functions
    5. Logical Functions
    6. Financial Functions
    7. Look Up and Reference Functions
  17. Using Goal Seek
  18. Scenarios
  19. PivotTables
    1. Adding Fields to a PivotTable
    2. Grouping Items on a PivotTable
    3. Hiding Items on a PivotTable
    4. Using Value Settings
    5. Creating a PivotChart
    6. Preparing a Pivot Report
  20. Protection
  21. Assessing your Knowledge

Branches:

Western-Cape

Creative Minds® -Bellville

Creative Minds® -Brackenfell

Creative Minds® -Constantia

Creative Minds® -Knysna

Creative Minds® -Parow (HQ)

Creative Minds® -Stellenbosch

Creative Minds® -Table View

Creative Minds® -Vredenburg

Creative Minds® -Worcester

 

Eastern Cape

Creative Minds® -East-London

Creative Minds® -Sterkspruit

 

Kwa-Zulu Natal

Creative Minds® -Newcastle

 

Limpopo

Creative Minds® -Groblersdal

Creative Minds® -Northam

Creative Minds® -Thabazimbi

 

Mpumalanga

Creative Minds® -Nelspruit

 

 Northern Cape

Creative Minds® -Kathu

Creative Minds® -Kuruman

Creative Minds®-Springbok

Creative Minds® -Steinkopf

Creative Minds® -Upington

Reviews
Be the first to write a review about this course.
Write a Review
We have more than 20 training Centres in South Africa. See: https://www.minds.co.za/training-centres-2/

Company Background:
Cyber-Minds (Pty) Ltd trading as Cyber Minds Training Institutes has been doing computer end-user, IT and business training for the past 22 years.

Our unique training method of dealing with students in a practical, uncomplicated, caring and confidence building way is ideally suited for the needs of all your candidates.

Cyber Minds Training Institutes use their own world-class training material, developed to the Unit Standards set by the SAQA. Our students find the training material easy to follow and they are continuously encouraged to improve their skills by the unique practical real-life exercises.

MICT Seta Accreditation No: available from HQ.
Cyber-Minds (PTY) Ltd Trading as Cyber Minds Training Institutes
Cyber-Minds HQ, 157 First Avenue, Glen Lilly, Parow, Cape Town, Cape Town, Western Cape, South Africa 7500
021 939 6344
Sending Message
Please wait...
× × Speedycourse.com uses cookies to deliver our services. By continuing to use the site, you are agreeing to our use of cookies, Privacy Policy, and our Terms & Conditions.