50 Best Cities for Finding a Job [Incell Dashboard using Excel]
We all know that incell charts are a very cool way to explore and visualize data. Personally I like them so much that I have written several tutorials on it here. Today we will see how a Job dashboard on “50 best cities for finding a job” originally prepared by Indeed job search engine can be recreated in Excel using In-cell charts. The final outcome is something like this.
Excel Time Sheets and Resource Management [Project Management using Excel – Part 4 of 6]
Timesheets are like TPS reports of any project. Team members think of them as an annoying activity. For managers, timesheets are a vital component to understand how team is working and where the effort is going. By using Microsoft Excel capabilities you can create a truly remarkable timesheet tracking tool.
In this installment of project management using excel series, we will learn 3 things about timesheets and resource management using Excel
1. How to setup a simple timesheet template in excel?
2. How to make a more robust timesheet tracker tool in Excel?
3. How to use the timesheet data to make a resource loading chart?
Build a Retirement Calculator using Excel (learn how to use Goal Seek as a bonus)
In this installment of spreadcheats, we will learn how to use goal seek feature of excel. We will build a retirement savings calculator using excel. We will learn to use Excel’s FV() formula to estimate the corpus that can be accumulated by saving fixed amount every month.
Use burn down Charts in your project management reports [bonus post]
A burn down chart is a good way to understand the progress of a project. It is like a run chart that describes work left to do versus time. In this tutorial we will learn how to make a burn down chart using excel. This is a bonus installment to the project management using excel series.
Formula 1 Style Sorting of Times (Durations) in Excel
The other day I was watching Formula 1 on TV. I think it is the ideal game to follow for a lazy dude like me. It is on every other weekend. It takes .32 seconds to understand the game and 3.2 seconds to know the points and scoring mechanism. But I am not here to convince you to follow the game. While looking at score boards, it struck me,
“how about writing excel formulas for sorting a list of durations (or numbers) in the formula 1 order?”
Make an Impressive Product Catalog [spreadsheets for small business]
It is the customer on the phone again, she wants to know what products we have.
How cool would it be if we can send her a spreadsheet with all the products neatly listed in a table and she can use filters to find what she likes. Alas, we end up sending a biggish PDF brochure that is both difficult to make and maintain.
Well, not any more.
Today we will learn a very useful and fun trick in Excel. We will create a product catalog using Excel that you can send to your clients or boss (and impress them).
Project Management: Show Milestones in a Timeline [Part 3 of 6]
Learn how to create a timeline chart in excel to display the progress of your project. Timelines are a good way to communicate about the project status to new team members and stake holders. Also, download the excel timeline chart template and make your own timeline charts.