Profit and Lose in Excel

Profit & Loss Statement – The life blood of your business.

Beginner 0(0 Ratings) 2 Students enrolled
Created by Ulearn Academy Last updated Thu, 02-Jul-2020 English
What will i learn?
  • Run Advanced Filters in VBA
  • Set a Dynamic Print Range
  • Use SUMIF formulas

Curriculum for this course
14 Lessons 15:56:13
10 Lessons 10:23:21 Hours
  • Learn How To Create A Dynamic Profit & Loss Statement From Scratch In Excel Today 01:03:19
  • How To Create A Dynamic General Journal & Accounts Register In Excel 01:27:45
  • Learn How To Create Compound Journal Entries In Excel Today [General Journal Pt. 2] 01:16:23
  • Learn How To Master Named Ranges In Excel In Just 35 Minutes [Full Course] 00:35:21
  • Learn How To Create This Amazing Excel Invoice While I Build It From Scratch [Full Training] 01:17:36
  • Learn How To Make This Dynamic Pop-Up Calculator In Excel Today [Free Download] 00:32:06
  • This 'Set It And Forget It' Excel Application Earns You An INCOME While You Sleep [Part 2] 00:34:29
  • How To Create A PayPal Payment Link In Excel 00:14:06
  • How To Create A Powerful Point Of Sale (POS) Application In Excel [Full Training & Free Download] 01:40:00
  • Learn How To Create This Automated Purchase Order Application In Excel While I Build It From Scratch 01:42:16
  • Learn How To Create This Excel Equipment Rental Application From Scratch [Free Download] 01:52:43
  • How To Create This Excel Expense Tracker With Mobile Receipt Upload From Scratch [Free Download] 01:16:14
  • Learn How To Create Your Own Monthly Budget Application In Excel From Scratch Today [1 Hour Course] 01:03:37
  • Learn How To Create This Amazing Vehicle & Fleet Expense Tracker In Excel Today [Part 1] 01:20:18
  • Basic Excel Knowledge
+ View more


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.

+ View more
Other related courses
Updated Thu, 02-Jul-2020
0 0 Free
Updated Thu, 02-Jul-2020
0 2 Free
Updated Thu, 02-Jul-2020
0 6 Free
Updated Thu, 02-Jul-2020
0 10 Free
About the instructor
  • 5 Reviews
  • 121 Students
  • 88 Courses
+ View more
Student feedback
Average rating
  • 0%
  • 0%
  • 0%
  • 0%
  • 0%
  • 15:56:13 On demand videos
  • 14 Lessons
  • Access on mobile and tv
  • Full lifetime access
  • Access on mobile and tv