In this course we will be covering all the basics: what are columns, rows & cells, how to navigate a spreadsheet and how to use sheets. Learn how to format, sort and filter your data, and how to create eye-popping reports with styles. Learn (functions and formulas), and how to save time. Spice up your documents with graphical elements such as charts, shapes, and images. How to save documents in iCloud, sharing, and the new collaboration feature.
Week 1. Introduction and basics
Creating a presentation
Working with spreadsheets
Navigating the application and customisation
Week 2. Adding, styling, editing and organising tables.
Adding and editing tables
Adding text and objects
Working with different types of data
Entering formulas and functions
Week 3. Working with charts, text, images, shapes and media.
Creating and modifying charts
Adding editing and formatting text
Adding images, shapes and media
Positioning and styling objects
Week 4. Advanced features
Using writing and editing tools
Sharing and collaborating documents
Managing and organising documents
This is a lecture-based class with 10 minutes of live Q&A at the end.
By the end of this course, you will be able to quickly and easily create beautifully designed spreadsheets that you will be able to export and share as Microsoft Excel or pdf documents to either PC or Mac users. This software is really powerful and Mac easier to use than Microsoft Excel for your home or business so you can keep your finances organised.
This course is aimed at beginners for both home and business users and also professionals who want to switch to an easier option than Microsoft Excel. No prior training using the software will be needed as we will be starting from the basics through to the advanced features.