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…
This is unrelated to Excel, but a neat trick I discovered while moving a website to a new domain. Hope it will help some people out there! Copy the .htaccess file from the new site to the old website that redirects all clean urls to the index.php file. In this case I just used WordPress’…
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…
Shortcuts are big time savers for those who use the computer frequently. Below are a few that are guaranteed to save you time on a daily basis. Especially Alt+Tab – could even save you from getting into trouble at work in case you get distracted a lot. Windows Key + L The fast way of…
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…
Disclaimer: I am not a recruiter, and by no means is this a comprehensive guide for writing the perfect resume. But I have seen enough good or bad ones to point out what more than 80% of the applicants out there is screwing up on. Also, this article is geared towards entry level office /…
Google search can be very helpful for the most part when it comes to solving Excel problems. Typically 99% of Excel programs that you run is the same with the rest of the population out there. And fortunately, there are a lot of website that shows you how to solve Excel problems yourself, and forums…
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…