Microsoft Excel 2016 Beginners Class

Microsoft Excel 2016 Beginners Courses in Cape Town

See our MS Office course schedule here

2KO offers this course in 3 levels

 

Beginner (below)                   Intermediate (click to see)                    Advanced  (click to see) 

 

Subject
Using Microsoft Excel to produce spreadsheets

Unit Standards
116937 Use a Graphical User Interface (GUI)-based spreadsheet application to create and edit spreadsheets (4 Credits) Level 2

Pre-requisites
Prior knowledge and skills to:
Mathematical literacy and communication skills at least at NQF Level 1.
Operate a personal computer system (ID 116932 - NQF Level 1).
Use generic functions in a Graphical User Interface (GUI)-environment (ID 117902 - NQF Level 1).

Level
Beginners


Duration
1 Day

 

Modules
 Spreadsheet Principles
What is a Spreadsheet?
Why use a spreadsheet application?
What are the names of some spreadsheet programmes?

 

Starting with Spreadsheets
Starting the programme
Understanding the Screen
Using the Mouse
Using the keyboard to move around the screen
Entering data on a spreadsheet
Editing data on a spreadsheet
Entering data using the automatic fill

Working with File commands
Saving a workbook
Closing a workbook
Opening an existing workbook
Starting a new blank workbook
Saving changes to a workbook
Saving a workbook with a Different Name
Saving an Excel file in a different file format
Deleting an Excel workbook file
Exit the spreadsheet programme

Formatting Spreadsheets
Selecting cells for changes
Formatting Columns
Formatting Rows
The Alignment command group
The Number command group
The Font command group
Setting Borders
Using Format Painter

 

Producing Spreadsheets with formulas
Entering Formulas
Filling Formulas
Using Functions
Checking your work

Editing Spreadsheets
Using the Cells command group
Using the Clipboard command group

More features
Check your spelling
Auto Correct
Find and replace
Getting Help


Printing a Spreadsheet
Previewing the spreadsheet
Page Layout
Printing a worksheet

 

2KO delivers cutting-edge IT products in the consulting and business services space, as well as offering top-rated training for various IT vendors. Our internationally recognised courses can be offered either as hands-on full time classes, or as online learning, enabling 2KO students the opportunity to study courses online world-wide, to ensure students have access to the best training possible.

 

Client Testimonials

  • Thank you so much for the opportunity to freely empower us with these basic courses with applicable working knowledge. Instructor has a good mastery of the subject matter. 2KO is doing a great job.

     

     

     

  • So far I’m finding the course quite convenient with my work schedule. I’m able to incorporate studying into my daily routine and feel confident the course will prepare me for the upcoming exam. The material has been laid out in an easy to study alone and understanding format, most importantly I appreciate the exam questions provided as well.

  • So far I’m finding the course quite convenient with my work schedule. I’m able to incorporate studying into my daily routine and feel confident the course will prepare me for the upcoming exam. The material has been laid out in an easy to study alone and understanding format, most importantly I appreciate the exam questions provided as well.