I have been trying to adapt as many Excel keyboard shortcuts as I can (not just for productivity, but for ergonomic reasons). Today we will learn how to quickly insert a new Row or Column using Keyboard Shortcuts in Excel.
Category: Excel Tips
How to extract initials from names in Excel?
Here I introduce few tricks to quickly extract initials from the name list in Excel, like TCS for Tata Consultancy Service and JFK for John F Kennedy. Check in here to learn how to do it.
How to Convert a Date to Calendar Quarter?
An easy formula that returns the quarter for a given date. There’s no built-in function in Excel that can do this. Check in here to learn how to do it quickly.
How to Set Up Excel Default Formatting?
Three tips that will help you to reset Excel’s default formatting. Set them once, and never again
How to get the Last Numeric Value in a Column?
Returning the final value in a column is particularly useful for spreadsheets that involve running balances, where you want to reference the final balance regardless of whether it is the smallest or largest value in the column.
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):