Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel and Google Sheets Basics
Module 1 - Starter Kit for Excel and Google Sheets for Accountants and Businesses
Introduction (0:43)
Resources
Get CPD or CPE points for this course
Module 2 - Getting started
Introduction (1:00)
Getting started on G-Sheets and Excel (6:25)
Don't forget to save (0:53)
Pros of each (0:43)
G-Sheets and Excel basics (5:44)
Toolbar (1:28)
Rows and columns (5:11)
General features on G-Sheets and Excel (7:43)
Module summary (0:16)
Quiz
Module 3 - Formatting Data
Introduction (0:33)
Basic Formatting in G-Sheets and Excel (14:00)
Number Formatting in G-Sheets and Excel (10:35)
Find and Replace All (4:47)
Format painter in Excel and G-Sheets (2:22)
Conditional formatting (7:35)
Module Summary (0:16)
Quiz
Module 4 - Working with Data
Introduction (0:35)
Some useful shortcuts (5:18)
Auto-fill (3:48)
Freeze pane (4:10)
Filter and sort (8:06)
Text to column (4:35)
Concatenate (2:55)
Transpose and value paste (2:18)
Module Summary (0:18)
Quiz
Module 5 - Tools - Formulas
Introduction (0:30)
Basic maths with Excel and Google Sheets (6:31)
Formula basics (9:18)
Other useful formulas (7:54)
VLOOKUP (3:24)
Pivot table (8:21)
Module Summary (0:19)
Quiz
Module 6 - Tools - Analytics
Introduction (0:30)
Insert tables and visualizations in Excel (9:02)
Insert tables and visualizations in G-sheets (3:39)
Real world use cases (1:24)
Syft Analytics (5:36)
Module Summary (0:33)
Quiz
Module 7 - Course Summary
Resources
Conclusion (0:48)
Format painter in Excel and G-Sheets
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock