Three tips that will help you to reset Excel’s default formatting. Set them once, and never again
Articles Tagged: Excel Tips
How to Calculate Age in Excel Accurately?
Some or the other time, we would want to calculate the Age in Excel, and more often people get frustrated as they show up a little different results than expected with A day more or less and either it shows the months completed or the current running month.
Today I will show few popular Excel Formulas in practice which will calculate the Age between given Start Date and End Date in Excel and learn how accurate they are. And also we will learn those Super Hero Formulas that gives us the accurate results!
How to Reduce Size of Excel Files? – Top 10 Tips
Did you ever wonder why your Excel File is so huge while it actually has very little information?
When you receive an excel file it was in KBs but when you make changes and save, file size surprisingly increased to MBs!! Fortunately there are several ways to overcome this problem, this article will help you learn the Top Ten Awesome Tips & Tricks to Reduce Excel File Size to a great extent without losing the actual content.
How to use SUMIFS with multiple criteria in same column in Excel
SUMIFS() lets you sum values by multiple conditions in multiple columns. But how about applying multiple conditions on single column? For example If you write a formula like =SUMIFS(F:F,B:B,”A”,B:B,”C”) despite the ‘Column B’ having ‘A’ and ‘C’ in it you will get ‘0’ as result. Confused? Do not worry this article will help you learn the trick to over come the SUMIFS limitations.
How to VLOOKUP with Multiple Criteria in Multiple Column
VLOOKUP is definetly a great tool to get the data from tables, however it has limitations: it can only work with one criteria for matching information. What If you need to refer two or more conditions to match a specific piece of data, VLOOKUP will only get the first match in the data. Fortunately Excel has functions called INDEX and MATCH that works same as VLOOKUP but with multiple criteria. Here’s a quick tutorial to help you learn how…
Round to the Nearest Multiple Other Than 10
If you want to round a price to nearest nickel (multiple of 0.05), or a length to the nearest inch (multiple of 1/12), or a number of minutes to the nearest second (multiple of 1/60), you can use the following formula (where mult is the multiple to round to):
Compare Percentage Result Between Excel Formula [Average] And [Averageif Exclude “0”]
Do you know the result of percentage not the same if there is “0” figure in the Range of Average Formula. Therefore, how do you solve this problem? To obviously visible what the difference of using Average Formula between the range of figure “Including 0” and “Exclude 0”.
Count only Text Entries in any Excel Range
Problem in Hand: We want to count only the text entries in the list under consideration. Meaning we want to ignore all possible entries under sun in an excel cell except “Text”. Image below will help you understand problem visually.
How to handle #N/A error values to make charts look more presentable
Learn to handle #N/A error values to make charts look more presentable
Apply shading to alternate rows using Conditional Formatting
It is often easier to read lists of data if alternate rows are shaded. This article shows you how to use conditional formatting to shade alternate rows.