Drill Down Profit & Loss: Review & Feature, Fix or Focus Request [Gold & Silver] (Patreon)

How To Create A Drill Down Profit & Loss Statement In Excel From Scratch [+ FREE DOWNLOAD]

🔥GET 250 OF MY BEST TEMPLATES HERE► https://bit.ly/250WKBK-Desc 📢GET YOUR FEATURE ADDED ON PATREON ► https://bit.ly/PatreonDesc 👉SELL YOUR OWN EXCEL-BASED SOFTWARE► http://bit.ly/MentorProgram_YTDesc 👨‍💼JOIN MY INCREDIBLE DASHBOARD MASTERCLASS HERE► http://bit.ly/Dashboard_YTDesc 📣LEARN VBA FROM THE GROUND UP ► https://bit.ly/VBACourse_Discount In this week’s training, I will show you how to create a single click Profit & Loss Statement In Excel With Drill Down Capability 📣30-HOUR VBA COURSE► https://bit.ly/VBACourse_Discount ⬇DOWNLOAD THIS WEEKS WORKBOOK FREE: 📩 USING YOUR EMAIL: http://bit.ly/DrillProfLoss_WkbkDl 💬 FACEBOOK MESSENGER: https://bit.ly/DrillProfLoss_FbDld EXCEL COURSES: ►DASHBOARD MASTERCLASS: http://bit.ly/Dashboard_YTDesc ►MENTORSHIP PROGRAM: http://bit.ly/MentorProgram_YTDesc ►BEGINNERS VBA COURSE: https://bit.ly/FreeVBACourse EXCEL PRODUCTS: ►The Ultimate Excel Resource Guide: http://bit.ly/UERG_YTDesc ►250 Excel Workbooks: https://bit.ly/250WKBK-Desc ►Convert Excel Into A Secure EXE File: http://bit.ly/SecureExcel ►Automate Your VBA Programming: https://bit.ly/AutoMacroAddIn ►Create Dashboards & Charts in Seconds: https://bit.ly/Pine-Bi ►Find the Best Excel Products & Courses Here: http://bit.ly/ExcelProducts Timestamps 0:00 Introduction 1:38 Overview of the Dashboard 3:10 Adding Titles, Dates, Buttons, Icons and Background 7:02 Formatting Profit & Loss From & To Dates 7:55 Formatting Text & Adding Colors 9:16 Adding up Reports and Transactions 10:52 Creating Advance Filter Criteria 12:00 Setting up the Total Income Results by the use of Name Manager 15:00 Setting up the Summary Total Table 17:51 VBA Code ProfitLoss_Refresh 26:26 Adding Codes for COGS Results Table 28:14 Duplicating codes for Expenses Results Table 30:31 VBA PL Row to Reflect Results into the Dashboard 34:38 Adding the Total Income Row Results 36:29 Adding the Total Income COGS Results 39:37 Adding the Gross Profit Results 41:39 Assigning Macro to Refresh Button 42:24 Adding Expenses Results into the Dashboard 46:19 Adding the Net Profit Results 47:20 Creating Conditional Formats to the Total Results, Gross Profit and Net Profit 50:06 Adding Lines for every Value using Conditional Format 51:15 Assigning Macro to Print Report Button 54:48 Setting up Worksheet Changes and Selection Change for Expansions 58:20 Enabling Application for Events and Screen Updating 59:10 Expanding Filters using Drill Down Criteria 01:02:10 Adding Drill Down to the Total Results 01:07:25 Bringing Data Over to the Dashboard 01:12:17 Copying Remaining Values 01:14:37 Adding E3 to the Range 01:15:03 Adding VBA Target.Value Code 01:15:31 Setting up Conditional Format for Alternate Column cells JOIN OUR COMMUNITY: ►Facebook Group: http://bit.ly/groupexcel ►Facebook Fan Page: https://bit.ly/EFF_FanPage Follow me on my Social Media Accounts: 🐦Twitter: https://twitter.com/Excel4Freelance 🌏Website: https://www.ExcelForFreelancers.com 🔗LinkedIn: https://www.linkedin.com/in/excelforfreelancers/ 👤Facebook: https://www.facebook.com/ExcelForFreelancers/ 📸 Instagram: https://www.instagram.com/excelforfreelancers/ 🎥Rumble: https://rumble.com/c/ExcelForFreelancers 👤Locals: https://locals.com/member/ExcelFreelancers ✉Telegram: https://t.me/ExcelForFreelancers 📲Gab: https://gab.com/ExcelForFreelancers About Us: I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money. I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep these training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams. Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here: 👉 https://www.youtube.com/c/ExcelForFreelancers/ New Training Video Uploaded every Tuesday! Thank you very much for your continued support, Randy Austin