In this Excel accounts tutorial you will see how to set up a spreadsheet to do simple accounts in Excel. So regardless of what profession you are in or if you want to add basic book keeping to your skills, in 15 minutes you will see the best way to set up an excel spreadsheet for book keeping.
After you've watched see how much you can remember by taking quiz below.
Exercise File Download - Should you want to follow along.
Want to know how to make your accounts look good in Excel? This tutorial will show you how to format an Excel spreadsheet. You will learn:
After you've watched the above tutorial see how much your remember.
This simple short accounts tutorial will show you how to calculate VAT in Excel. You will see the formula you need to use to work out the net from the Gross and the Gross from the net.
After you have Calculated the VAT in Excel you will need this accounts tutorial. Here you will learn how to take the Excel VAT formula from the last tutorial and apply it to a whole column. Download Exercise File
Step-by-Step written instructions along with completed template.
See how to summarise your data to find out how much money your business made last month. This tutorial will take you through applying filters in Excel in conjunction with the Subtotal function to easily find answers to questions such as:
This Pivot Tables for beginners tutorial will show you how to quickly create a Pivot Table that can be easily updated to display a summary of accounts. As a result you will quickly be able to see a summary of expenses in Excel.
Pivot Tables for beginners exercise file.
Excel accounts video tutorial teaching you how to calculate the financial year in Excel. Also, see a financial quarter formula. After, you will apply the results to a Pivot Table. Finally, you will use a Custom List to get the Pivot Table properly sorted.
If you want to use formulas in Pivot Tables you're going to have to get your head around Calculated Fields. This Excel Accounts video will show you to use Calculated Fields to find profit and the percentage of profit.
Want an Excel accounts tutorial that will show you how to use Conditional Formatting in Pivot Tables and make it work. First, you must understand a few things about how to use Conditional Formatting with Pivot Tables. This Excel training video will show you how.
Sign up to receive our monthly newsletter including special promotions, hints & tips, and the latest Computer Tutoring news!
We do not store your credit/debit card details. You have the right to access, amend, or request deletion of your personal data by contacting us at firstname.lastname@example.org.