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
Is my Excel file format too old?
This morning I was doing some work, and needed to open one of my Microsoft Excel files. I haven’t used it for a while, and opened it through a Folder on the Desktop. However, it wouldn’t let me open the file, saying I need to download an App. So I did some investigations, and it…
“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…
Is your Inbox groaning under the weight of unsorted mail?
If our Mailbox becomes too cluttered it can cloud our judgement, make us feel overwhelmed, and prevent us from focusing on the main task. If you are using Outlook, here are a couple of tips to help clear up unwanted mail. This should be done using the Outlook App on your desktop rather than the…
How long do you spend working in Excel a day?
This was a question posed on Linked in the other day. However, maybe the question should be how long do you spend working effectively in Excel each day? Could your time be used more efficiently by using the correct functions and shortcuts. Are you spending ages copying and pasting or re-entering data wondering if there is a…
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…
