361 views

[Tutorial 01 – ExcelVB Coding Tips & Tricks for Accountants: How to Enable Macros in different versions of MS Excel I.e 2003, 2007, 2010 and 2013!

[*Hint: See PDF tutorial attached to email sent to you announcing this blog post]

To get started using Excel Visual Basic you have to access the Visual Basic Editor (VBE) interface in your copy of Microsoft Excel.

The VBE and related tools are not visible by default – you need to know how to get them to display.

The steps described in the attached “ExcelVB Tutorial 01 for Accountants” PDF will guide you to do it for any version of MS Excel you have to work with, from 2003 up till the latest version.

Note that the steps for enabling macros in Excel 2003 apply to earlier versions.

Next week, in Tutorial 02, I will describe the steps involved in Creating a Macro to do a simple task like formating a cell or current selection using the Currency style and Accounting Format to improve the appearance of Excel reports you prepare.

Below: Two Real Life Examples That Confirm Excel-VB Coding Skill Will Make ANY Accountant Highly Valued In Paid or Self-Employment, Worldwide!

For those still not sure how useful Excel-VB coding skills can be to them on the jiob, and in boosting their careers to the next level, below are links to 2 different websites that offer concrete evidence of the value placed on possession of Excel-VB coding competence by an accountant.
1. First is this introductory course priced at approximately £1,000.0 GBP.

Title: AUTOMATING YOUR REPORTING WITH EXCEL VBA MACROS (AN INTRODUCTION) OVERVIEW

Preview: You could make Excel work harder, particularly repetitive reporting tasks. This course introduces Visual Basic for Applications (VBA) – the language used to write macros.  

Through the use of hands-on examples the course will illustrate the process of creating bespoke reports from large quantities of data (no previous programming experience required).
http://www.accaglobal.com/uk/en/discover/events/england/professional-courses/vba-reporting-macros-jul.html

2. Secondly, this article offers information about learning institutions that teach coding to accountants, as well as high profile international organizations like KPMG, that regularly scout for competent accountants with real world relevant coding skills.

Title: Sure, Accounting Students Should Learn How to Code (And a Lot of Other Things, Too)

Preview: While very few accounting programs require students to learn to code, some strongly encourage students to consider it. Brigham Young University’s School of Accountancy is creating several master’s-level classes on dealing with data in accounting.

These classes will focus not only on manipulating, analyzing, and reporting data, but on coding as well.
David Wood, Ph.D., an assistant professor who is one of the faculty members designing this coursework, said the classes will include learning some SQL and Visual Basic for Excel, and other programming concepts.

“Writing code is a tool, and if you have that tool, it provides you an opportunity to do things that others can’t,” he said. “Would coding benefit an accountant? There’s no question it can help.
http://goingconcern.com/post/sure-accounting-students-should-learn-how-code-and-lot-other-things-too

[IMPORTANT: This blog's contents are being updated following the transfer to www.tayosolagbade.com from my former domain - Spontaneousdevelopment.com. As a result, some parts of it may not work properly for now. Quick Tip: If a link contains "spontaneousdevelopment.com", simply change it to "tayosolagbade.com" - and it should work. This applies to article links as well as image links. Work continues to update the links(in over 500 articles). Tayo K. Solagbade.]

Practical Livestock Feed Formulation Handbook

Available as a PDF ebook, and also as a spiral bound print manual (from me). Click here for details.

You can also get it as an PDF ebook via my online store.

Screenshot of ebook in online store

$82.5 USD to buy it from my online store (PDF download)

N8,000.00 [Eight Thousand Naira] for persons who wish to send payment direct to my bank account.

Payment of N50,000.00 gets you the physical handbook and software on CD with videos etc, PLUS practical one-on-one, in person training with me at a feed mill in Lagos, Nigeria.

Click here to contact me about purchasing this product.

View Tayo Solagbade's video tutorials and demonstrations on Facebook Productivity Tips, Web Marketing, and for his Custom MS Excel-VB driven software applicationsJoin the SD Nuggets community on Facebook.comConnect with Tayo on Twitter.comConnect with Tayo on Google Plus

Your Gifts for Subscribing

When you signup, you'll receive:

Submit the form below to get a download link to the PDF version of my newly revised

Once you submit the form below, you will be taken directly to the downloads page, just as an auto-response message will be delivered to your inbox, with links to the promised gifts.

I look forward to meeting and/or working with you!


Signature image - Tayo K. Solagbade

Tayo K. Solagbade*
Performance Improvement Specialist & Multipreneur
*Best Practice Farm Business Support Specialist
& Founder of the MS Excel Heaven Visual Basic Automation Club & Competition(www.excelheaven.biz)

 

 

Excel-VB Driven Ration Formulator

Click to view larger screenshot

1. Click here to learn more about this app - watch demo videos etc

2. Click here to watch a 4 part video in which I demonstrate how to use this app to formulate rations using real life data sent to me by an Algerian PhD student.

Click here to contact me about purchasing this product.

EXCEL-VB DRIVEN POULTRY LAYER FARM MANAGER SOFTWARE

Click here to download a detailed PDF user guide and watch 15 screen shot user guide tutorials of the Monthly Poultry Farm Manager that I now offer Farm CEOs.

Click here to watch a screenshot demonstration of the Excel-VB Driven Poultry Farm Manager I built for a client farm business in Ekiti state, South West Nigeria.

Click here to contact me about purchasing this product.

Name:
Email:
 
Powered by Optin Form Adder

Leave a Comment Here's Your Chance to Be Heard!

You must be logged in to post a comment.

Facebook

Get the Facebook Likebox Slider Pro for WordPress