Create a simple macro in Excel 2007
You Might Also Like
-
Really Simple Bookkeeping Lesson 4: Agree the Bank -
Really Simple Bookkeeping Lesson 3: Money -
Really Simple Bookkeeping Lesson 2: Purchases List -
Really Simple Bookkeeping Lesson 1: Sales List -
Sage 50 / Instant: Checking the Closing VAT -
Sage 50 / Instant: Be a Detective - Find Mistakes -
Sage 50 / Instant: Export TB to Excel -
Sage 50 / Instant: Debtors and Creditors -
Sage 50 / Instant: Checking Opening Balances -
Compare two lists in Excel 2007 with @VLOOKUP
-
Compare two lists in Excel 2007 with @VLOOKUP -
Sage 50 / Instant: Checking Opening Balances -
Sage 50 / Instant: Debtors and Creditors -
Sage 50 / Instant: Export TB to Excel -
Sage 50 / Instant: Be a Detective - Find Mistakes -
Sage 50 / Instant: Checking the Closing VAT -
Really Simple Bookkeeping Lesson 1: Sales List -
Really Simple Bookkeeping Lesson 2: Purchases List -
Really Simple Bookkeeping Lesson 3: Money -
Really Simple Bookkeeping Lesson 4: Agree the Bank -
Really Simple Bookkeeping Lesson 1: Sales List -
Sage 50 / Instant: Year end date -
Sage 50 / Instant: Check VAT on Closing Debtors -
Sage 50 / Instant: Checking the Closing VAT -
Sage 50 / Instant: Nominal Activity for >1 Codes -
Sage 50 / Instant: Be a Detective - Find Mistakes -
Sage 50 / Instant: Export TB to Excel -
Sage 50 / Instant: Debtors and Creditors -
Sage 50 / Instant: Checking Opening Balances -
Compare two lists in Excel 2007 with @VLOOKUP
-
Compare two lists in Excel 2007 with @VLOOKUP -
Sage 50 / Instant: Checking Opening Balances -
Sage 50 / Instant: Debtors and Creditors -
Sage 50 / Instant: Export TB to Excel -
Sage 50 / Instant: Be a Detective - Find Mistakes -
Sage 50 / Instant: Nominal Activity for >1 Codes -
Sage 50 / Instant: Checking the Closing VAT -
Sage 50 / Instant: Check VAT on Closing Debtors -
Sage 50 / Instant: Year end date -
Really Simple Bookkeeping Lesson 1: Sales List
About this Lesson
- Type: Video Tutorial
- Length: 3:53
- Media: Video/mp4
- Posted: 05/07/2009
- Use: Watch Online & Download
- Download: MP4
- Size: 14 MB
This lesson is an entry in the Screencast 4 Cash Contest
Do you find yourself carrying out the same tasks again and again in Excel 2007?
You can easily make Excel do them for you automatically by recording a macro - and no, you don't need to know Visual Basic to do this.
Watch the video to find out how to record a simple macro.
About this Author
-
- Emily Coltman
- 15 lessons
- Joined:
05/07/2009
Hi, I'm a Chartered Accountant by profession and have now branched out into making screencasts.
My "Sage Tricks for Accountants" video series came about after having learnt these tricks the hard way as I struggled to turn a set of records on Sage into a set of balancing accounts.
And my "Really Simple Bookkeeping" video series was inspired by the number of really small businesses who just don't need to buy expensive desktop software to keep their books.
More..Recent Reviews
This lesson has not been reviewed.
Login to reviewRecent Comments
This lesson has not been reviewed.
Login to review
How does MindBites work?
CommunityMore
- Painting with Acrylics: Layering Te...
-
- I am taking a class from Polly right now, and this lesson is a great way for me to unde...
- Trigonometry: Trig Function Composi...
-
- great explanation of trig function composition and inverse trig functions.
- Flower painting 1-Water Color Pencils
-
- Excellent, easy to follow instruction.
- I want to learn how to build a slid...
-
- I want to learn how to build a slideboard
- compound subjects and predicates
-
- compound subjects and predicates
- I want to learn Trigonometry
-
- I want to learn Trigonometry
Embed this video on your site
Copy and paste the following snippet:
Link to this page
Copy and paste the following snippet:
