In this video I show you how to take a simple ledger of transactions and create a Dynamic Profit and Loss Statement that updates as soon as you change the dates or click the refresh button.
In this training you will learn how to:
☑️ Run Advanced Filters in VBA
☑️ Use SUMIF formulas
☑️ Create Dynamic Named Ranges with OFFSET
☑️ Use Conditional Formatting to dynamic Row Totals
☑️ Set a Dynamic Print Range
☑️ ..and much, much more.
Would you like to learn how to create Drill Down and Drill Up Profit & Loss Statements?
You can do that and a TON more in our Advanced Excel Dashboard Reports Masterclass right here: http://bit.ly/AmazingDashboardCourse
Got Excel Question? Let us help you with that, Join thousands of the worlds best Excel Experts in Facebook’s fastest growing @Excel For Freelancers Group right here: http://bit.ly/groupexcel
Also JUST launching…Learn the same dashboard that launched my Excel freelancing career right here: http://bit.ly/AmazingDashboardCourse