Individual support and training for your home and small business computing needs
The default cell doesn’t allow much room for typing text, does it? To extend a column’s width, move the mouse pointer over one of the small divider lines that separate the alphabetic headers at the top of the sheet. When the pointer changes to a double-headed arrow (as you can see in the picture above),…
Did you know that you can use Excel’s SUMIF feature to automatically generate a Cashflow spreadsheet? The screen below shows the one I use for monitoring my business income and expenditure across the year:- The 3 fields (Range, Criteria and Sum_range) enable Excel to constantly monitor them for any changes. This means that I change…
