𝗪𝗜𝗟𝗗𝗘𝗦𝗧 𝗗𝗜𝗦𝗖𝗢𝗨𝗡𝗧 𝗢𝗙 𝗧𝗛𝗘 𝗬𝗘𝗔𝗥 - 𝟲𝟱% 𝗦𝗔𝗩𝗜𝗡𝗚𝗦 𝗙𝗢𝗥 𝗕𝗟𝗔𝗖𝗞 𝗙𝗥𝗜𝗗𝗔𝗬 https://www.excelforfreelancers.com/BFSale2024_YTDesc


In this week’s training, I will show you how to create a single click Profit & Loss Statement In Excel With Drill Down Capability


𝗗𝗢𝗪𝗡𝗟𝗢𝗔𝗗 𝗧𝗛𝗜𝗦 𝗪𝗘𝗘𝗞'𝗦 𝗪𝗢𝗥𝗞𝗕𝗢𝗢𝗞 𝗧𝗘𝗠𝗣𝗟𝗔𝗧𝗘 𝗛𝗘𝗥𝗘:
USING YOUR EMAIL: http://bit.ly/DrillProfLoss_WkbkDl


GET AN UPDATED TRAINING AND TEMPLATE!

FIND THIS UPDATE ON PATREON HERE: https://www.patreon.com/posts/drill-down-loss-72485603


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 Profit Loss 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


#ProfitAndLoss #excelvba #DataDrillDown #ProfitandLossDashboard