Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

vba

ResolvedVersion 2003

Zahoor has attended:
Excel Intermediate course

VBA

How is VBA different to advance excel

RE: VBA

Hello Zahoor

Thank you for your question and welcome to the forum.

VBA is a coding language that can be used to create complex macros in Excel. Code is written in the Visual Basic Editor which looks different to the Excel interface. You can access the Visual Basic Editor by going to Tools - Macro and selecting Visual Basic Editor. The Excel VBA course teaches you how to write code using the VBE.

On the Excel Advanced course, training is carried out within the 'normal' Excel program that we are used to seeing when we open Excel.

Kind regards
Amanda

Excel tip:

Select Single Data Marker

To select a single data marker in a chart, ie line, bar or column;
After you have pressed Ctrl+Click (to select the entire chart) you can press the Up or Down arrows to select a data series, then press the Left or Right arrow to select a data point within that series.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.