Excel formula to convert calendar format to table
Got some data in a calendar format and just wished you can get it in tabular format?
You can use Excel formulas or Power Query to do this. In this article, let’s review formula based approach with two excellent choices.
Project Plan – Gantt Chart with drill-down capability [Templates]
Create a gantt chart with ability to filter by levels. This drill-down gantt chart in Excel is useful for seeing activities by module or team. Read on for full instructions + downloadable template.
These Pivot Table tricks massively save your time
Pivot tables are powerful. Use these 6 tricks to save time when working with them. New to Pivot Tables? Check out this intro Are you new to Pivot Tables or just used them a few times? Then check out this excellent getting started with Pivot Tables guide. 1 – Double click to see details Ever […]
Top 10 Excel formulas for IT people
Are you in IT & use Excel often? This article explains top 10 formulas for IT professionals. Useful for project managers, IT analysts, Testing people and BAs.
We cover a 10 practical situations and explore various Excel formulas to solve them. Example workbook provides more details too.
Lookup last non blank value – Excel Challenge
I have a fun Excel lookup challenge for you. You have data as shown below and want to find the last non blank value for a given account number. For example, for acct number 2015, the answer would be Freedom. How would you solve this? Refer to this workbook for 3 possible answers. Just move […]
Excel TEXTJOIN Function – What is it, how to use it & 3 advanced examples
Use TEXTJOIN function to combine text values with optional delimiter. It is better than CONCATENATE because you can pass a range instead of individual cells and you can ignore empty cells too. Here is a sample use of TEXTJOIN Excel function.
Highlight due dates in Excel – Show items due, overdue and completed in different colors
Congratulations to you if your job does not involve dead lines. For the rest of us, deadlines are the sole motivation for working (barring free internet & the coffee machine in 2nd floor, of course). So today, lets talk about a very familiar problem.
How to highlight due dates in Excel?
The item can be an invoice, a to do activity, a project or anything. So how would you do it using Excel?