Creating and Income and Expenses Spreadsheet – Part 2
This video creates the expenses part of the spreadsheet. It uses the format painter, formatting, and copy and paste as well as a subtraction formulae. For parts 1 & 3 see the links below.
Similar Posts
Using Sections in PowerPoint
Are you working with long PowerPoint Presentations? Use Sections to divide your presentation into manageable chunks. We all know that we should avoid have death by Powerpoint. And that we should have as few slides as possible. However, sometimes for corporate presentations, or reasons beyond your control you have a large number of slides in…
Sync your iPhone Camera Roll with One Drive
Do you use iPhone? Do you use One Drive? Do you want to get sync your One Drive with your camera role? Watch this short video and find out how. For more useful videos check out our online courses available.
Some tips for Excel – shortcuts!
We all love a shortcut! Here are a few in Excel to speed up your working! 1. CTRL A – select a range of data 2. CTRL SHIFT and END – Highlights from current cell to end of data. 3. ALT F5 – refresh the contents of a Pivot Table 4. To copy an entire sheet –…
Autofill in Excel 2013/2016
Now I have been a bit late getting to the party on this one! But having used it a couple of times, I have begun to see its potential. Imagine you have two text strings in Columns A and B, and want to join them together in Column C. In older versions of Excel, you…
“Pivot Tables don’t work for me!” Lets consider the raw data!
Many people complain that they can’t use Pivot Tables and struggle to make them work. One of the big issues is the raw data they are using. Have a look at some of the common problems, and see if you can spot them in your data! Blank Rows or columns – a blank row or column…
How to create a Pivot Table with a Slicer in 1 minute
In this one minute challenge, I change some data to a table, merge two columns, create a pivot table and a slicer in Microsoft Excel. For further help check out our other courses for Microsoft Office.
