Using Lookup Formulas with Excel Tables [Video]
Excel Tables, a newly introduced feature in Excel 2007 is a very powerful way to manage & work with tabular data. I really like tables feature and use it quite often. If you are new to tables, read up Introduction to Excel Tables.
In this short video tutorial I explain how to combine VLOOKUP, INDEX, MATCH formulas with Excel Tables.
Extract usernames from E-mail IDs [using LEFT and FIND formulas in Excel]
Today we will learn to use Excel’s LEFT and FIND formulas. But what fun it is to learn a new formula on a Tuesday? So, we will actually learn to use these formulas to solve the problem: “extract the username from an email ID” How is an email ID structured? Any email ID contains 2 […]
Conditionally Formatting Dates in Excel [Part 1 of 2]
This is first part of 2 part series on conditionally formatting dates in excel.
Conditional formatting is a very useful feature in Excel. You can use Conditional formatting to tell excel how to format cells that meet certain conditions. For eg. You can use conditional formatting to show all negative values in a range in red color. Today we will learn how to use conditional formatting to format dates.
Excel Conditional Formatting Basics
Do you know What is excel conditional formatting? Learn the basics, few examples and see how you can use it in day to day work in this installment of spreadcheats.