-
Categories
Top Posts
- How to format dates that are over 1 year old to turn red in Excel using conditional formatting.
- How to Use Excel Traffic Lights with Conditional Formatting Dates
- How to Format Dates In Excel That Are Over One Year Old To Turn Red, Yellow If Eleven Months Ago, And Green If Between One and Ten Months Ago
- Access Input Mask Cheat Sheet
- Shrink to Fit Word Document on One Page
Category Archives: Budget
Formula Link Multiple Worksheets to within an Excel Summary Workbook
This post I’ll share with you how to create a summary worksheet that pulls data from within other Excel worksheets. Say you have multiple monthly worksheets that track expenses like my screenshot examples below. Ok, the main thing to pick up … Continue reading
QuickBooks Keyboard Shortcuts
Download my favorite QuickBooks keyboard shortcuts. QuickBooks Keyboard Shortcuts for the PDF copy. QuickBooks Keyboard Shortcuts for the Word copy. My favorite is “A” to make a report for all. I also like “T” for today.
Income and Expense Monthly Budget Excel Workbook
Download my Income and Expense Monthly Budget Workbook. I’ve made some changes to my monthly budget. This template now includes tracking income at a monthly level. Also the summary tab has a year to date running totals so you can see … Continue reading
Dave Ramsey reads my letter on air!
I am a big Dave Ramsey fan! I love his radio show and his EntreLeadership course. My wife and I have learned a ton from his Total Money Makeover and EntreLeadership books. EntreLeadership podcasts, need I say more! My older boys Ryan- 7 … Continue reading
The Top 10 Posts of 2012 on my 1 year Blog Anniversary
Well today marks 1 year since my very first post on this blog about Excel 2010 Sparklines. I thought I’d share with you the top 10 posts. Excel Budget Template Excel Keyboard Shortcuts Create a Parameter Query in Access 2010 … Continue reading
Create a Line Chart in Excel
Excel has a lot of of beautiful charts to display. Line charts are a great choice if you would like to display a time line with progress. In this post I will teach you how to create a simple line chart … Continue reading
Excel Budget Template
Excel is one of the best tools available for tracking spending. Download my Excel Budget Template and get started today. I have all the formulas ready to go. You can make modifications to the spreadsheet to suit your needs. My template … Continue reading
Savings Thermometer Worksheet
Here is a savings thermometer for a yearly savings plan. My wife created this document by using the shape commands in Word. I’m looking foward to our 2012 fiancial savings goals. Download the printable worksheet below: Savings Thermometer Printable