Microsoft Excel Advanced

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