Sheet Smarts
Ultimate Course for Google Sheets
You would be more marketable for a job or promotion if you were more efficient in Google Sheets?
You waste time trying to figure things out in your spreadsheets and then spend hours on Google?
You are doing too many tasks manually in Google Sheets…there must be a better way to automate!
You would be more confident at work or school if you were a Google Sheets wiz?
You would rather spend less time fumbling with spreadsheets & more time doing what you love?
Securing your dream job offer
Landing that raise you've always wanted
Saving HOURS at work so you can spend more time doing what you love in life!
The Sheet Smarts package includes:
Total Value: $1,487
Your Price: $297
The course is designed to be one module per week over 12 weeks. However, if you are the “Netflix binge-watching” type (like myself) — feel free to go forth and conquer! You can go at your own pace as you will have lifetime access to all of the materials!
You can complete the course at your own pace and start whenever you'd like! You will have lifetime access to the videos and materials. Many people use it as an on-going resource (let's say you forget how to do a VLOOKUP function -- you can just hop into that mini lesson for a refresher)
You will have access to me directly via our discussion boards within the course and in our private Excelerator Lounge Facebook group. You can also email me at any time with questions too :)
Welcome + Download Course Files
Join The Excelerator Lounge Facebook Group!
Shortcut Guides 📚
101 - Google Sheets 101
102 - Sheets Basics
103 - Meet the Tool Bar! 🧰
104 - Data Entry
105 - Formula Entry
106 - Getting Funky with Functions 🕺🏼
107 - Sharing Sheets 👯♀️
108 - Printing Sheets & Saving as PDF
200 - Formatting 101 🎨
201 - All about Number Formats
202 - Working with Themes (the Presets of Sheets) 🤳🏼
203 - Workin' It in your Worksheet 😎
204 - The art of the Hyperlink 🖌
205 - Brrrrr! Let's Freeze Our Panes! ❄⛄
206 - Hiding Rows & Columns 🙈
207 - Grouping Rows & Columns
208 - Absolute vs Relative Referencing (VERY IMPORTANT!) 🚨
300 - Welcome to Advanced Formatting! 👋🏼
301 - Conditional Formatting for Blanks
302 - Conditional Formatting with Text
303 - Conditional Formatting with Dates 📅
304 - Conditional Formatting with Numbers
305 - Create a Color Scale 🌈
306 - Conditional Formatting Custom Formulas
307 - Interactive Cross-Out Checkboxes (Pro Tip!) ✅
308 - Alternating Colors Tool
309 - Drop Down Menus
400 - Let's Clean It Up! 🧼
401 - Delete Blank Rows
402 - Text to Columns Tool
403 - Split Function
404 - Remove Duplicates ❌
405 - Find & Replace
406 - Naming Cells / Ranges
407 - Spilling! 💦
408 - Rand Function
409 - Trimming Data ✂
501 - Case Functions
502 - Extraction Functions
503 - Location Functions 🌎
504 - Date & Time Functions 📆🕑
505 - Logical & Information Functions 🤔
506 - Statistical Functions 📈
507 - Combination Functions
508 - Transpose Functions 🔄
601 - Commonly Used Analysis Functions
602 - Feeling Iffy? 😵
603 - Sorting Techniques
604- Filtering Techniques
605 - Sort & Unique Functions
606 - Building Charts 📊
607 - Building Multi Series Charts 📉
608 - Chart Slicers
700 - Namaste Pivot Table Team! 🧘🏼♀️
701 - Preparing Your Data for Pivot Tables 🧹
702 - Pivot Table Basics 👩🏼🏫
703 - Filters vs. Slicers
704 - Positioning Pivots for Future Growth 📈
705 - Grouping
800 - Welcome to Lookup Land! 🔎
801 - VLOOKUP
802 - Limitation of a VLOOKUP 🙀
803 - Index & Match - The OG Love Match! 💘
804 - HLOOKUP
805 - Multiple Lookup Results with FILTER Function
806 - SORTN
900 - Advanced Functions Intro 💪🏼
901 - Array Formulas
902 - Indirect Function
903 - Sequence Function
904 - IFERROR / IFNA 🙅🏼♀️
905 - QUERY Function 101
906 - QUERY: Select
907 - QUERY: Where 🤷🏼♀️
908 - QUERY: Order by
909 - QUERY: Limit
910 - QUERY: Group By
911 - QUERY: Label 🏷
1000 - Reviewing & Troubleshooting 101 ✍🏼
1001 - Spell Check & Personal Dictionary ✔
1002 - Debunking Error Messages 😱
1003 - Comments & Notes 📝
1004 - Protecting Sheets 🔒
1005 - Version History 🧾
1100 - Customizations & Collaborations!
1101 - Creating Sheets Shortcuts 🩳✂
1102 - Using Sheets Offline 📶
1103 - Spreadsheet Language / Locale Settings 🌏
1104 - Importing Excel Workbooks
1105 - Working with Google Forms
1200 - Your Productivity Portal 📝
1201 - Sorting Data Within One Cell
1202 - Time Hacks ⏰
1203 - GOOGLEFINANCE Function 💵
1204 - IMPORTRANGE Function
1205 - GOOGLETRANSLATE Function 🗣
1206 - Emoji Fun (because why not 😇)
CONGRATS!!!!!!! 🎈🎉💃🏼🥳