Learn 6 Ways To Make Money with Excel As A Beginner. Learn my secret to earning a Full-Time Income From ANYWHERE! https://go.juddalbring.com/the-secret🚩FIND Your Next Remote Job!https://go.juddalbring.com/flex-jobs (this is an affiliate link, see details below)🚩Join My New Facebook Group!https://go.juddalbring.com/grab-my-bonusesStart My 15-Day Online Business Challenge for Only $7 And Get Over $2k In BONUSES!Start Here ➜ ➜ ➜ https://www.juddalbring.com/bonus-optinFREE Online Side Hustle Ideas ➜ https://go.juddalbring.com/subscribe 🚀 🚀 🚀FREEBIES 🚀 🚀 🚀FREE Video Training: “How To Start A Profitable Online Business With Zero Exp”➜ https://go.juddalbring.com/free-videoFREE Affiliate Marketing Ebook ➜ https://www.juddalbring.com/free-ebookFREE ClickFunnels 14-Day Trial ➜ https://go.juddalbring.com/free-cf_____________🛠️My Tools And Resources ➜➜➜15 Day Online Business Challenge ➜ https://go.juddalbring.com/15-dayAffiliate Insiders Guide ➜ https://go.juddalbring.com/affiliate-dominationFREE ClickFunnels 14-Day Trial ➜ https://go.juddalbring.com/free-cf#makemoneywithexcel #excelworkfromhome #juddalbringDISCLAIMER: This is not a get rich quick program nor do we believe in overnight success. We believe in hard work, integrity and developing your skills if you want to earn more financially. As stipulated by law, we can not and do not make any guarantees about your ability to get results or earn any money with our courses, events, affiliate program or free video training. The average person who buys any “how-to” information gets little to no results. these references are real and documented but are used strictly for example purposes only. Your results will vary and depend on many factors, including but not limited to your background, experience, and work ethic. All business entails risk as well as massive and consistent effort and action. if you’re not willing to accept that, please DO NOT PURCHASE THIS TRAINING PROGRAM.
In the video, I will wall you through how to create, display, and show charts in Squarespace, using underlying data from Excel.
Free template download here: coming soonSupermetrics free trial (best way to import data into Gsheets): https://supermetrics.com/?idev_id=2372Video Chapters:0:00 Video Outline2:05 Solar & Roofing Business Example2:48 Features of Dashboard Walkthrough4:55 Action Item Example8:24 How to Start the Google Form9:09 How to Determine Google Forms Questions12:07 Step 1: How to Build the Google Form17:00 Connect Google Form to Google Sheet17:38 How to Share the Google Form with your Team18:53 Step 2: How to Add Formulas to Google Forms Data (Option #1: Project to Helper Tab)21:28 How to Add Formulas to Google Forms Data (Option #2: ARRAY Formula)24:01 How to Build the Dashboard STARTS HERE24:34 Step 3: Adding the Dashboard Dropdowns and Filters29:25 Step 4: Adding the Scorecards (QUERY Formula Start)38:47 Multiple Filters in QUERY Formula with “show all” trick52:11 “Global” Filter NEW TRICK instead of Formula Level Filters 1:00:12 Compare vs. Previous Period % (Week over week)1:16:00 CHART: Sales Funnel1:27:08 CHART: Sales Funnel Conversion1:34:17 CHART: Sales Person Leaderboard1:39:14 Creating the final tables1:43:33 “Wins and Losses” table1:44:35 Tricks available in my PREMIUM course 1:45:30 YOUR DONE! 🙂