How to transpose a values in a row to column using formulas… [Quick tip]
Published on May 14, 2013 in Excel Howtos
Then out of blue he said, he has a problem with his spreadsheet. In this own words,
When entering data for credit cards, I use one column per card. But in my report view, I want to show credit card details in rows. How do I do this?Something like above…. Today, lets learn how to do this using Excel formulas.
Continue »
How to remove all cells containing John (or anything else) [Quick tip]
Published on Mar 15, 2013 in Excel Howtos
If I have to delete all rows with “John” in it. Do you know how to do it?Well, it looks like they really hate John. But it is none of my business.
So lets go ahead and understand a dead-simple way to get rid of all cells with John or whoever else you fancy.
Continue »
Work with several Excel files everyday? – Save them as a workspace [Quick tip]
Published on Mar 4, 2013 in Learn Excel
Use Save workspace feature to save your workbook collection & layout.
Continue »
Continue »
Continue »
Highlight Quarters, Weekends in pivot reports using styles [quick tip]
Published on Nov 8, 2012 in Excel Howtos, Pivot Tables & Charts
When reporting summaries by month, it would be better to highlight 3 months at a time (Jan, Feb, Mar in one color, Apr, May, Jun in another color) than showing all in one color. Today, lets learn how to do this in easiest possible way.
Continue »
Even faster ways to Extract file name from path [quick tip]
Published on Oct 24, 2012 in Excel Howtos, VBA Macros
1. Using find replace
2. Using text to columns
3. Using UDFs
Continue »
Check Cells for Equality – Follow Up [Quick Tip]
Published on Oct 16, 2012 in Huis, Posts by Hui, Quick Tip
The Excel = Function
Today we quickly review what it can do for us.
Continue »
We can use either conditional formatting or table formats to quickly add zebra lines to our data.
But what if you want a little more?
What if you want to highlight, lets say 3 rows in one color and 3 in another and repeat this …
Continue »
I am a complete beginner in excel, how can I keep the zeros when I am working with decimals and remove them when are not required.
This is where we can use General formatting. Read on to learn how General formatting works and what to do in extreme cases.
Continue »
A single Gold medal is worth more than any number of Silver medals. Like wise, a single Silver medal is worth more than any number of Bronze medals.So, when you look at the ranking of countries, you see countries with single Gold medal higher up than countries with lots of Silver and Bronze medals (but no Gold).
Continue »
So why leave all those empty rows & columns hanging in your reports?
Would it not look cool if your reports showed only few rows & columns as needed, like this:
Continue »
Check if a list has duplicate numbers [Quick tip]
Published on Jun 28, 2012 in Excel Howtos, Learn Excel
Today, lets learn a simpler formula to check if a list has duplicate numbers.
Assuming you have some numbers in a range B4:B10 as shown below, we can use MODE + COUNTIF formulas to check if there are any duplicate values in a list.
Continue »
Here is a quick tip that I learned while conducting training classes
in Australia. If you have several dates in a range and you want to find
out what the latest date is, just use MAX, like: =MAX(A1:A10) would give
you the latest date. A Question…, Assuming you have some dates (not
necessarily sorted) in [...]
Continue »
Continue »
Sort Pivot Tables the way you want [Quick tip]
Published on May 31, 2012 in Excel Howtos, Pivot Tables & Charts
“If only I could show this report of monthly sales such that our best months are on top!”
Well, there is a way to do it without sacrificing 2 goats or pleasing the office Excel god. Just use custom sorting options in Pivot tables.
Continue
No comments:
Post a Comment