MS Excel can be used for planning our outdoor activities. Here is the template for Garden Planner: https://templates.office.com/en-us/garden-planner-tm00000057
File is separated to 4 useful parts Plant Inventory, Seed Starting Log, Task List and Garden Planning Grid.
Continue reading “Microsoft Garden Planner” »Generate random date in Excel is easy. Let’s see how to do that. Continue reading “Random date in Excel” »
SUM function always calculates with all cells in the range. Sometimes, it’s not desired behavior and we want to exclude hidden cells. Continue reading “How to exclude hidden rows from SUM” »
Setting the width of the table to one page is a common problem. You can do it without changing font size or changing the width of each column. As well as the width, can be adjusted the height. Let’s see how. Continue reading “How to resize the table to fit the page” »
Table is sometimes longer than one page. It is very useful to print names of columns or rows on every page. This example shows how to do that. Continue reading “How to print names of columns or rows on every page” »
I’m using Array Formulas to find the last filled or the last non empty cell ,it’s the same :). Important: Each formula must be confirmed by Ctrl+Shift+Enter (not just Enter). Continue reading “Value of the last filled cell in a column or in a row” »
Let’s have a list of dates or some kind of calendar. We want to highlight first Mondays or Tuesdays or Wednesdays etc. in each month. The example shows how to use conditional formatting to solve this task. Continue reading “How to highlight first Monday of the month in Excel table” »
This is one of the most problematic errors in Excel. There is no direct way how to fix it. I show you some of the frequent examples with #REF errors. The worst case is if you open the file and you see the # REF error in it. At first you may try to contact the file creator and ask him about the original formula. If you are the creator of the file, you have to decipher the composition of the original formula. I hope these examples will help you. Continue reading “Causes and solutions of #REF! errors in Excel” »
The table in this example shows dates and values. There is a missing dates. It causes a big blank space in the chart. Continue reading “Missing date in the chart” »
The first way is to write date right into the cell or to use the shortcuts:
Ctrl+; enters the current date.
Ctrl+: enters the current time.
This method ensures that the cell will always has the date which you have written into it. Continue reading “How to insert the current date or time” »
Copyright © All Rights Reserved · Green Hope Theme by Sivan & schiy · Proudly powered by WordPress
