Google Sheets Complete Course: Free Online Spreadsheet Excel
Instructor
KuKu
Reviews
What You'll Learn?
- Complete Google Sheet guide from starting to pro
- Solve real-life spreadsheet challenges with ease
- Learn hacks and hidden Google Sheets features that even the Experts don't know
- Create interactive & visually effective dashboards in Sheets
- Secrets to properly use tricky features like Conditional formatting
- Master Pivot tables, charts and sparklines to create impressive Google spreadsheets
- Analyze data sets with ease using complex functions & formulas
- Connect multiple Google Sheets together using a single formula
- Learn formulas that work in both Google sheets & Excel!
- Feel completely comfortable in a spreadsheet environment
- Absolute beginners who want a structured, engaging, fun and practical Google Sheets course.
- Business professionals looking to expand their skills.
- Students who want to make sure they have the right level of knowledge to succeed at their next job.
- Spreadsheet users who want to discover & showcase new tips and tricks at work.
- Willingness to learn. Let's do this!
- No prior spreadsheet knowledge is needed.
- 4.5 hours on-demand video
- 365 days access
- Access on mobile and TV
- Certificate of completion
Course Content
-
Google Sheets Complete Course: Free Online Spreadsheet Excel
-
-
BODMAS & Basic Functions
00:31:08 -
Advanced Maths Functions
00:24:14 -
Using Wild Card Functions
00:32:13 -
Logical Functions IF
00:13:36 -
IF Related Functions
-
IF Related Functions Task
-
Upper Lower Proper Function
-
Left Right Find Function
-
Left & Right more examples
-
Concatenate Function
-
Replace & Substitue Function
-
Split Function one Column
-
Filters Function in Google Sheets
-
Named Ranges & Links
-
Data Validation & Charts
-
Hlook & Vlook Function
-
Other Functions
-
19 PMT, PPMT, IPMT & PV
-
Sharing & Protection in Sheet
-