All articles with 'trackers' Tag
How-to create an elegant, fun & useful Excel Tracker – Step by Step Tutorial
Do you want to create a simple, elegant and useful tracker using Excel? You can make trackers with features like tables, data validation rules and conditional formatting. In this page, I will explain the process for creating an Excel tracker.Continue »
Designing a dashboard to track Employee vacations [case study]
HR managers & department heads always ask, “So what is the vacation pattern of our employees? What is our average absent rate?”
Today lets tackle that question and learn how to create a dashboard to monitor employee vacations.
What do HR Managers need? (end user needs)
There are 2 aspects tracking vacations.
1. Data entry for vacations taken by employees
2. Status dashboard to summarize vacation data
Growing a Money Mustache using Excel [for fun]
Mustache and Excel?!? Sounds as unlikely as 3D pie charts & Peltier. But I have a story to tell. So grab a cup of coffee and follow me.
Today, lets talk about how to construct a dynamic chart that can show us how much progress we have made against a financial goal (in this case, accumulating a big chunk of money). I call this growing mustache chart, inspired from the wonderful Mr. Money Mustache.Continue »
Christmas Gift Shopping List Template – Set budget, track your gifts using Excel
Last year, Steven shared a beautiful Christmas Gift List template with all of us. It is packed with lots of Excel goodness. Just a few days ago, he emailed me another copy of his file with some improvements. So if you are planning for Christmas shopping and want a handy tracker, you don’t want to miss this.Continue »
11 Excel Trackers & Templates to help you Rock 2011
We are just a few days away from 2011. New year always brings hope, cheer, joy and revitalizes us. So naturally many of us embark on journeys with new goals, resolutions, things to do.
Naturally, Excel can help us better manage the new year. In this post, I am featuring 11 templates so that you can have a rocking 2011.Continue »
7 Personal Expense Trackers using Excel – Download Today
Keeping track of your expenses is one of the fundamentals of living good life. So I asked you to prepare a personal expense tracker as part of our 10,000 RSS Subscriber Milestone contest. I have received 7 excellent entries in this contest, each capable of making expense tracking a breeze while providing good analytics of […]Continue »
FIFA Worldcup Excel Spreadsheets [Roundup]
Looking for FIFA World cup 2018 Tracker? Click here. Today FIFA World-cup 2010 is beginning. For the next 30 days or so, no matter where you go, you are bound to hear about soccer, world cup, teams, points, goals and what not. As a tribute to this beautiful and lovely sport, I want to showcase […]Continue »
Get Stock Quotes using Excel Macros [and a Crash Course in VBA]
Have you ever wanted to fetch live stock quotes from excel? In this post we will learn about how to get stock quotes for specified symbols using macros. We use Yahoo! Finance API to fetch the stock quotes and other information related to a company using excel macros. Along the way, we will also learn various interesting things about Excel VBA. Think of this post as a crash course in VBA.
This is a guest post by Daniel Ferry.Continue »
Christmas Gift List – Set your budget and track gifts using Excel
Steven, one of our readers from England sent me a Christmas gift tracker worksheet. I found it pretty cool, so made some minor changes to it and sharing it with you all so that you can have great time shopping for the holidays.
The workbook is full of lessons on conditional formatting, cell formatting, using formulas. Go ahead and download it today.Continue »