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


See the original Mini-Accounting Training Here: https://youtu.be/itHilzsUHck
See the updated Customers Statement Training Here: https://youtu.be/_hJuE-VKu7A

In this week’s training, I will show you how to create this incredible multi-color 1 click Sales & Profit Dashboard in Excel with Free Accounting Application Template Workbook


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


GET AN UPDATED TRAINING AND TEMPLATE WITH THE FOLLOWING FEATURES:
• Current Year & Month Profit
• Increase & Decrease On The Percentage Based On The Previous Month Or Year

FIND THIS UPDATE ON PATREON HERE: https://www.patreon.com/posts/sales-profit-71861275


TIMESTAMPS:
0:00 Intro
0:27 Overview of the Sales & Profit Dashboard
6:55 Changing the Theme Color
11:38 Assigning Macro to Set the Theme Color
16:20 Assigning Macro to Refresh Data
17:21 Dashboard Overview
20:13 Creating Pivot Chart into the Pivot Table
21:02 Different Order Types
23:53 Creating Invoices by Month Table using Line Chart
28:18 Calculating Purchases by Month using Line Chart
29:18 Customizing Overdue Invoices using Rows
34:05 Creating Donut Chart from Status Order
39:10 Sorting Top Items Sold using Bar Chart
44:13 Navigating Expenses by Month using Bar Chart
46:00 Creating Estimates by Status using Funnel
47:27 Locating Expenses/Income by account using Pie Chart
49:51 Customizing Slicers


#ExcelVBA #SalesAndProfit #SalesDataAnalysis #pivottables