New Google Spreadsheets - basics

The course is specifically designed for beginners who have digital skills but have never used a spreadsheet or have minimal knowledge of them. The course will provide effective, usable knowledge for people who need to use Google Spreadsheets on a daily basis, create simple spreadsheets, create worksheets, format and print them.

The course is also useful for those who have a basic knowledge of other spreadsheet programs, such as different versions of Microsoft Excel, but would like to learn about the capabilities of Google Spreadsheet and the differences between the programs

FIRST STEPS

• Create a workbook
• Open a workbook
• Using templates
• Saving to another file format
• Share to
• Version tracking, version history

GOOGLE SPREADSHEETS BASICS

• Data types
• Data entry
• Format copy
• Autocomplete on data entry
• Sequential search
• Navigation and selection

CELL/RANGE MANAGEMENT, FORMATTING

• Cell formats (character, alignment, border and pattern)
• Row and column alignment
• Moving and copying data
• Guided pasting
• Search and replace data

FILTER - FILTER VIEW

• Filter data range
• Using filters
• Using slicers

BASICS OF FORMULA WRITING AND FUNCTION USE

• Basic formula writing, operation symbols, order of operation execution
• Basics of function use
• Cell and range references
• Copying formulas, functions

WORKSHEET MANAGEMENT

• Inserting pages
• Renaming pages
• Sorting and sorting pages
• Deleting pages
• Hide, reveal pages
• Colour of tabs
• Copying pages

Basic computer skills and knowledge are required to successfully complete the course. If you lack this, we recommend you take our Effective Computer Use course.