Previous article Next article
Excel articles
Excel Macros for the Non-Programmer
Wed 22nd August 2007
Even people who are experts at using Microsoft Excel don't often venture into the area of macros. Those that do are often satisfied with simple recorded macros and never look at the code that makes them work. "I'm an accountant not a programmer," is the common feeling.
Don't limit your Excel training. Excel VBA (Visual Basic for Applications), the language of macros, is a programming language that many non-programmers have embraced and become quite skilled at. Take a look at some of the features of this simple yet powerful language.
English-like syntax
When most people think of programming, they imagine lines like "Stack object [semi]attribute x18 flag set? Const x0119:x14". You won't see a statement like that in macro training. Excel VBA uses simple commands that are easy to read even if you don't know anything about programming. Consider the following example:
For each Employee in EmployeeList
Employee.Salary = Employee.Salary + 500
Next Employee
It doesn't take a computer science degree to guess that these statements give each employee a
Author is a freelance copywriter. For more information on Training excel VBA, please visit https://www.stl-training.co.uk
Original article appears here:
https://www.stl-training.co.uk/article-214-training-excel-vba.html
Back to article list
Distribution notes
London's widest choice in
dates, venues, and prices
Public Schedule:
Buy now / Live dates
On-site / Closed company:
Get quote
Testimonials
Provide Performance Analyst Dominique Bradley Excel VBA Introduction
Excellent, very satisfied with trainer and course materials
Trader Media Group Limited Ruth Brock Excel Introduction
A very good basic introduction to Excel
FastNet Ltd Finance Director Chris Lamb Advanced Excel Dashboards
This course was spot on, a great follow up to the previous BI/Dashboards one I did a few weeks ago. Its definitely worth booking these close to one another and puttin thiings into practice back at work in the meantime to get the best of the courses.
Jens was great and this time was perfectly timed in terms of pace, however the final part I thought was too much copying what was being typed from his instructions so we weren't really learning as such, and we weren't looking at how the background of the design of the dashboard was done. I think what would be good would be an excersise using some base data for us to try and design our own dashboard or perhaps formulate a choice of 2-3 things - then have some time to do so, then all look at each others' work.
More testimonials |
Clients
· Main client list
Article list
What's this?
Server loaded in 0.54 secs.
PUBLICATION GUIDELINES