This one’s a real time saver. While writing tutorials, I used to do a screenshot, and paste image into an image editor to get all the column and row headings into an image. This requires a lot of work, such as moving and cropping the image. Now, I can just copy from Excel and paste…
Tables are often used to layout and summarize data. But have you been in a situation where the table got so big that it is not easy to read? The table is so big that it is hard to tell which rows and columns a certain cells belong. For example, in the table below, it…
THE guide for anyone who wants a “Excel database”. Excel and Access are two very different tools: Excel is a spreadsheet program, while Access is a database program. However, it is not uncommon to see Excel used as a “patchwork” or temporary solution instead of Access, simply because Excel is easier to use. If only…
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…
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…