MS Excel
Cyber Minds Bellville offer MS Excel for the beginner to more advanced classes. This courses will enable you to use this versatile program with confidence in the workplace.
MS Excel Course Offers:
Creative Minds® Excel – Level 1 (Unit Standard 116937)
Learn to create spreadsheets as well as using basic formulas like (plus, Minus, division and Multiplication) for easy and easy and repetitive calculations.
Course Requirements: Delegate must be able to operate a computer system as well as using generic functions, (i.e. Copy, paste, etc.)
Duration: (±) 10 hours
Getting to know Excel
- Entering and manipulating Data in a Spreadsheet
- Basic Formulas
- Editing and Formatting a spreadsheet
- Special Functions
- Printing a Spreadsheet
- Saving options
Creative Minds® Excel – Level 2 (Unit Standards 117924 & 119078)
Learn how to produce and use spreadsheets for business purpose. This course covers and introduces the learner to advanced formulas, charts, using outlines, what if scenarios, to name a few.
Course Requirements: Delegate must be able to operate a computer system as well as using generic functions, (i.e. Copy, paste, etc.)
Duration: (±) 15 hours
-
- Working with different worksheets
- Copying data between Spreadsheets
- More advanced formulas: Percentage, Average, etc
- Creating Basic Charts
- Advanced formatting of cells
- Printing options
- Sorting data
- Document templates and a lot more…
Creative Minds® Excel – Level 3 (Unit Standard 116943)
This course teaches you to import data into excel, names ranges, working with large documents, conditional formatting, Sub totals, Linking worksheets, Macros, Scenarios, PivotTables, Consolidation of worksheets, replication of worksheet and more.
Course Requirements: Delegate must be a confident user of Excel
Duration: (±) 18 hours
-
- Import Data
- Named Ranges
- Managing Large Documents
- Conditional Formatting
- Filtering & Sorting Data
- Sub total and Pivot Tables
- Charts & Objects
- Linking Worksheets
- Advanced Displays Features
- Macros, Advanced Functions
- Goal seek, scenarios
- Hide/Unhide and Protection of worksheets
CYBER-MINDS DASHBOARDS IN EXCEL COURSE
This course will introduce students to the exciting world of Dashboards. Students will learn how to create a basic Dashboard and by building on this skill, delve deeper into Dashboards by creating truly interactive ones. The possibilities are endless, and students will be able to reach new heights in presenting data to their colleagues and management teams. Dashboards are graphical representations of data. The main aim when using Dashboards is to simplify complex data so that when new data is added, it automatically updates the Dashboard elements.
Course Requirements: This course is designed for any student who has completed our Creative Minds® Excel Level 3 (Advanced) course or any confident Excel user who wants to discover more about creating Dashboards in Excel.
Duration: (±) 18 hours
Become Proficient in Excel Today with Our Full Excel Package!
If you are interested in mastering Excel you can register for our MS Excel Package and save even more. Contact us now for more information. You will learn how to use Microsoft Excel and operate the components of a MS Excel with confidence.
Duration: ± 67 hours
This is recommended for a total beginner who has little or no knowledge of MS Excel. Get a complete Introduction and become acquainted with all the features and advanced components that will put you on a next level in using MS Excel. This module teaches you the very basic, i.e. Building, Saving and Printing Spreadsheets, Using Excel Templates, Applying formulas and Functions, Charting, Consilidating Multiple Large Spreadsheets, Linking Worksheets, Pivots, Dashboards and Modeling Datasets, etc.
Course Requirements: No previous experience needed (If you register for our Level 1 Course)
Contact Us Now
Do you need more information? Just click here