VLOOKUP(), MATCH() and INDEX() – explained in plain English
VLOOKUP may not make you tall, rich and famous, but learning it can certainly give you wings. It makes you to connect two different tabular lists and saves a ton of time. In my opinion understanding VLOOKUP, INDEX and MATCH worksheet formulas can transform you from normal excel user to a data processing beast. Today, […]
How to use Date & Time values in Excel – 10 + 3 tips
Excel date time features are very handy and knowing how to use Excel date values can help you save a ton of time in your day to day spreadsheet chores. Let us prepare for your date with the sheet using these 10 handy tips.
Before jumping on to the tips, it helps to know how excel represents the date and time.
Microsoft Excel stores dates as sequential numbers … January 1, 1900 is serial number 1, and 28 July, 2021 is serial number 44405 because it is 44,405 days after January 1, 1900. Excel stores times as decimal fractions because time is considered a portion of a day.
Read on to learn more.
Excel Basics: How to add drop down list to validate data
Validating your data as you type can prevent any surprises when you are doing analysis / follow-up on the data. Thankfully, excel has the right tools to do it. Excel drop down list can assist you in picking up a value from a valid list to enter in a cell. Here is a short how-to […]
Quickly Change Formulas Using Find / Replace
So you have built that excel report your boss wanted. And you were all eager to use the spreadsheet in your presentation. But in the last minute, your boss asked you to change average sales to total sales figures. You also want to grab an espresso before rushing to the meeting. Now what?
Participate in Microsoft BI DataMashUp Contest & You could win $3000 Prize
Hello Data Junkies & Chart Lovers, I have a fun announcement for you. If you like to analyze data and present results in charts, then you can win up to $3000 in prizes by participating in Microsoft’s BI DataMashUp Contest. The contest is on from September 8th and runs until 28th. How to Participate in […]
Excel School is Open for Admissions
Dear Readers & Friends, I am very happy to announce that Excel School online training program is now available for your consideration. Please read this short post to understand what you will get when you sign-up for this program and how you can join. What will you get when you join? Access to Private Member-only […]
A Brief History of Microsoft Excel – Timeline Visualization
Timeline charts are great for providing quick snapshots of historical events. And hardly a day goes by without some one making a cool visualization of a time line of this or that. Time lines are easy to read, present information in a logical manner and mostly fun.
So yesterday, I set out to mimic the iconic gadgets of all time in excel, just for fun. Then it strike me, why not make a visual time line of Microsoft Excel ? So I did that instead.