Microsoft Excel Advanced
£295.00 Plus VAT
Everyone understands how important spreadsheets are but being able to automate processes within them can save a business time and money. Learning how to develop and use macros supports this process.
Who Should Attend
Those who wish to use Excels advanced formulas and functions to manipulate their spreadsheets, create their own customised functions to perform calculations, specific or unique to a task and gain greater control of the Excel environment by learning the Excel programming language
Create dynamic lists and charts
Understand Array formulas
Manipulate text using text functions
Record repetitive series of keystrokes and commands
Create customise functions to perform calculations
Understand the basics of the Excel programming language
Automate spreadsheets and make them interactive for other users
Text Manipulation Functions
Dynamic Named Ranges
Macro Playback Shortcuts
The Visual Basic Editor
Troubleshooting Macro Code
Interacting with the User
How to Book
If you are interested in booking this course, then please select your desired date and then select book now to complete the booking.
We will then contact you to confirm availability and any additional required details.