Microsoft Excel Advanced

Course Duration is 1 Day

£295.00 Plus VAT

Delivery Method

Face To Face Delivery  Virtual Delivery One To One Coaching Closed Group Course Public Course

Business Benefit

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.

How to Book

If you are interested in booking this course, then please select an available date and then click book now to complete the booking. Can’t see a suitable date contact us on [email protected] and we can discuss specific date requirements.

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

Learning Outcomes – by the end of this course you will be able to…

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

Course Content

Templates
Text Manipulation Functions
Array Formulas
Dynamic Named Ranges
Automating Spreadsheets
Recording Macros
Macro Playback Shortcuts
The Visual Basic Editor
Troubleshooting Macro Code
Programming Fundamentals
Interacting with the User
Making Decisions
Custom Functions

Embedding

These follow up coaching sessions help support your colleagues to embed their learning during their skills transfer period.  Applying new skills and changing behaviour takes effort and practice.  After attending a training course many colleagues will find they need support through this transition.  EQV can provide that support with follow up coaching sessions to help embed the learning.

Embedding coaching sessions can be delivered in 90 minute and half day durations.  The facilitator will work with the group to capture feedback about challenges and how to overcome them ensuring success going forward.

Having a formal embedding coaching session will not only increase the success of the skills transfer period but helps create a platform of motivation, inclusivity and commitment within the group.