Duration 1 Day
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
- 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