Google Sheets Intermediate Course in Cape Town
2KO offers this G Sheets course at 3 levels
Increasing Efficiency through Google Sheets
Prior knowledge and skills:
Mathematical literacy and communication skills at least at NQF level 2.
ID 117902: Use generic functions in a Graphical User Interface (GUI)-environment, NQF level 1.
ID 116937 Use a Graphical User Interface (GUI)-based spreadsheet application to create and edit spreadsheets, NQF level 2.
Computer Literacy at NQF Level 2.
Prepare and produce a spreadsheet
Planning and designing the Worksheet
Customise the view and preferences
Minimising the Ribbon
Customising the Quick Access Toolbar
Changing the size of the screen display
Splitting the screen
Change the default file location
Setting document properties
Create a spreadsheet using a template Create a template from an existing spreadsheet
Work with Multiple Worksheets
Insert and Delete Sheets
Copy and Move Sheets
Using the Clipboard Group Using Paste Special
Apply formulas to worksheets
Relative or Absolute Cell Addressing Link Formulas between worksheets
Interpret and Correct Formula Error
Apply built-in functions
What is a built-in function
Creating Formulas Using Functions
Date and Time Functions
Math and Trig Functions
Apply formatting to a spreadsheet
Formatting Rows and Columns
Format as Table
Print a Spreadsheet
Previewing the spreadsheet
Using the Page Break Preview Page Layout
Printing a worksheet
Working with Data
Evaluate a Spreadsheet
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.
Are you interested in the Advanced Course? Click here