Excel 2016 Beginners Course

Microsoft Excel 2016 Fundamentals Training in Cape Town

2KO offers this course in 3 levels

 

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

 

2KO teaches students the fundamentals of Microsoft Excel 2016 in this one day Beginners Excel class. Our students will learn spreadsheet basics, beginning with the structure of Excel, and going on to work with data, and slowly building skills to generate your own Excel tables. Learn to use MS Excel to manipulate data and format it using powerful formulas and layout tools. 2KO Africa offers 1 day Excel 2016 courses for each level, operating out of our state-of-the-art training centre in central Cape Town, up the road from the V&A Waterfront

 

Subject Covers
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

 

No Contact Training

Get trained without coming to a class.

  • No travel Required

  • Study from work or home

  • Enjoy the best IT training, from the security and safety of your own environment

 

To find out more click the button below

 



Pre-requisites
Prior knowledge and skills:
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
 Save a workbook
Close a workbook
Open an existing workbook
Start a new blank workbook
Save changes to a workbook
Save a workbook with a Different Name
Save an Excel file in a different file format
Delete an Excel workbook file
Exit Excel correctly
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 Africa is a professional training company, delivering cutting edge programs in the IT space and in selected business applications. Our training is offered online, live online and also by instructor led classes. 2KO Africa's business courses are available world-wide, many of them leading to European Certification, 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.

  • I have received exceptional feedback from all 3 of my staff that attended training by you wish I am extremely happy with and glad I found a company where I can send them for this type of training.