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.
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…
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.
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 –…
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…
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…
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.
Vue IT Training, Suite 117 Dragon Coworking, 7-8 New Road Avenue, Chatham, Kent, ME4 6BB
© 2021 VUE I.T. Training. All rights reserved.
Website by Dzines Digital
No products in the cart.