How to plus or minus exactly one month in Excel? The best way is to use a built in function in the analysis toolpack, edate. =edate([date], [months]) Date is the date you are calculating from. Months is how many months you want to add. If you want to go backwards, then months is a negative…
I made a simple calendar for any given month in Excel. It works straight out of the box, just copy the calendar and paste to the desired location. To edit the month being displayed, simply change the date in top left cell of the calendar No VBA required, the entire calendar is made from formulas Download…
In Excel 2003, when multiple cells are merged, it is hard to select each of the columns individually. Right clicking a selected row column will result in all the rows columns of the merged cell being selected. This typically causes a headache if you are trying to insert a column, hide a column, or change…
Most users are familiar with hiding rows or columns, but may not have ventured into grouping rows or columns. What is the Group Function and How to Activate it? The group function basically “ties a range (columns or rows, can’t be both) together, and allows you to collapse them (and expand them later), showing only the last…
Doing good work means accurate and on time. While most of the tips on this website is about doing things faster and smarter, this article is dedicated to how to catch mistakes in Exce: Sum check. Do the sum of the numbers on excel equal to sum of the tables you were entering? The check…
Those dealing with a large number of spreadsheets with 3rd party Excel API software is likely to deal with the duplicate name range nightmare. Occasionally when 1 worksheet is copied or moved to another workbook, more than 50 of these “duplicate name range” message pops up. Something like this: The easy workaround is just…
There is no built in function to reverse a list of data in Excel. But this can be done in a few simple steps: In an empty column, put in the number 1 for the first Drag 1 down to create a list of numbers in increasing order (press Cntrl and drag down) Turn on…
This article is not for beginners, but serves as a memory aid for conditional formatting driven by formulas. For the basic stuff, go to http://www.contextures.com/xlcondFormat01.html For some examples of using conditional formatting, go to Excel: Alternate Row Colors / Color Banding, Column Colors and Checker Patterns In the conditional format, the formula will work as long as it returns…
There are a lot of shortcuts in Excel, which makes mastering all of them a daunting task for any beginner. But it will be much easier to just focus on the one that is most often used. Below are select list of shortcuts that most are guaranteed to use frequently. Please send us a note or reply if…
This is a little different from the previous article (How to delete duplicate entries or rows in Excel?), where duplicates are deleted but 1 will remain in the list as a unique entry. This article shows you how to delete all entries that has duplicates, so there is none left. All you need to do…