You need to calculate a difference between two dates in excel. Guess what, Microsoft has a tutorial on how to calculate difference between dates in Excel. Woohoo! That’s gonna be easy you think. But wait. When following the instructions, Excel says, the DATEDIF function that you are trying to add, isn’t a function. Are you […]
Had an interesting error the other day. Excel reported that Margins do not fit page size when printing or saving as PDF. After the attempt to save or print, the message appeared about margins and then all the workbook was checked with dashed stripes and the normal A4 page now contained some 30-40 squares […]
Just spent 2 hours of my life on trying to figure out why Excel and Word wouldn’t start up, not even in safe mode (run -> Excel /safe). All the time I got a message saying that Office didn’t shut down correctly, do you want to start it in safe mode. Then a crash followed, […]
Need to fill blanks with zeroes in Excel? No worries, here is the simplest solution. 1. Select your area to be affected 2. Go to Find & Select -> Go To Special -> Blanks 3. Type in 0 and press Ctrl + Enter 4. See the magic happen!
This is a big nuisance with Microsoft Excel desktop version. I use Windows 7 and need to work with 3 separate Excel files simultaneously so I have them all open on my 2 screens. Excel by default opens them up ALL IN THE SAME WINDOW (wanna swear now, but keep reading). To open Excel files […]
Should you need to get random dates in Excel, here’s how to do it: Format the cells you are going to put the random dates in as “date”. To pick a random date, use the formulas RANDBETWEEN() or RAND() with specific parameters. The best way to generate dates is by subtracting random values from TODAY() […]