Master the Basics of Google Sheets

Become familiar with Sheets as an app, learn tricks for formatting, organisation and a foundation of using functions.

Google Sheets is a powerful spreadsheet application and this session explores the fundamentals of using and making the most out of its features.

This is the first session in a learning path that continues with a further 8 sessions including Intermediate Level, Functions, Pivot Tables and more. This session will help build your fundamental knowledge of Google Sheets and ease your transition from other spreadsheet applications such as Excel.

This course consists of a live 60-minute session with an instructor and on-demand video content that you can watch both pre and post-enrolment.

‍

Badge earned on completion

Difficulty

Shareable Certificate

Key Takeaways

Workbooks – how to create and manage your workbooks including colour coding and sortation
Understanding the Toolbar – a deep dive into the tools contained within the toolbar to help you understand where everything is housed
Explore – learn how Machine Learning built into Google sheets can help you analyse your data
Working with Excel – See how Google Sheets can work with partners using Excel and how to share in Excel format
Format options – make your Sheet work for you with tips on how to Freeze and Move columns
Basic Functions – take a look at the basic functions built into Google Sheets