Google Sheets Mastery
Learn The Sheets Skills Used By Fortune 500 Companies In 30 Days
Mastering Google Sheets will unlock a world of powerful data analysis, organization, and collaboration. Classical Finance's Google Sheets course is your gateway to transforming data into intelligent strategies and gaining a competitive edge.
PurchaseI was offered the chance to take this course at work. I use sheets everyday as part of my job but this course highlighted how much more there is to it. I've have started using a lot more functions and formulas, noticed that I can no get the breakd...
Read MoreI was offered the chance to take this course at work. I use sheets everyday as part of my job but this course highlighted how much more there is to it. I've have started using a lot more functions and formulas, noticed that I can no get the breakdowns I want much faster and present them in a better way.
Read LessThe course was in-depth, with lots of examples and the instructor engaging. The emphasis on real-world applications and gaining insights from large datasets enhanced my experience with the course. I now feel confident analysing and presenting find...
Read MoreThe course was in-depth, with lots of examples and the instructor engaging. The emphasis on real-world applications and gaining insights from large datasets enhanced my experience with the course. I now feel confident analysing and presenting findings. Highly recommended for anyone wanting to improve not only their sheets skills but also learn how to present data in an engaging way.
Read LessI was impressed by the course's structure, teaching, and practical approach. The instructor distills complex concepts into easily digestible lessons that make learning sheets fun.
I was impressed by the course's structure, teaching, and practical approach. The instructor distills complex concepts into easily digestible lessons that make learning sheets fun.
Read LessWelcome To The Course!
1.00 - Get Started With Google Sheets
1.01 - Creating A New Spreadsheet
1.02 - Using the Ribbon
1.03 - Inputting & Formatting Data
1.04 - How To Input & Use Formulae
1.05 - Absolute vs. Relative Cell References
1.06 - Collaboration & Access Control
1.07 - Downloading & Printing Sheets
1.08 - Importing Data
Test Your Knowledge #1
2.00 - Introduction To Formatting
2.01 - Merging Cells
2.02 - Formatting Numbers & Currencies
2.03 - Professional Tables
2.04 - Checkboxes & Drop Down Menus
2.05 - Find & Replace
2.06 - Trimming Data
2.07 - Freezing Rows & Columns
2.08 - Protect Sheets & Cells
2.09 - Hiding Rows & Columns
2.10 - Naming Cells & Ranges
Test Your Knowledge #2
3.00 - Creating Highlighting Conditions
3.01 - Formatting Styles
3.02 - Blank vs. Not Blank
3.03 - Text Based Conditional Formatting
3.04 - Working With Dates
3.05 - Highlighting Entire Rows
3.06 - Multiple Conditional Formatting Rules
Test Your Knowledge #3
4.00 - Data Preparation (A Necessary Evil)
4.01 - Date Formats
4.02 - Split Data Into Columns
4.03 - Remove Blank Rows
4.04 - Highlight & Remove Duplicates
4.05 - Convert Rows To Columns
Test Your Knowledge #4
5.00 - Introduction To Functions
5.01 - Mathematical Operators
5.02 - Logical Operators
5.03 - Date Functions
5.04 - Statistical Operators
5.05 - Random Number Generator
5.06 - Partial Extractions
Test Your Knowledge #5
The secret is: Be Useful
We use spreadsheets for everything. In many jobs, you won't go a day without looking at a one.
But spreadsheets are also complicated. Most people don’t know how to use them properly.
That’s what Google Sheets Mastery is designed to help with. It shows you everything you need to know to be really, really good at spreadsheets.
Put theory into practice with real-world examples and projects. Walk away with hands-on experience, ready to tackle challenges in your career or business. Upon successfully finishing the course, you will receive a certificate of completion for your resume.
Dive into a extensive curriculum that will show you how to build dynamic models, automate repetitive tasks, and create interactive dashboards that impress colleagues and clients alike.
Gain lifetime access to course materials and updates, ensuring you're always up-to-date with the latest Google Sheets features.