Microsoft Excel Advanced

£255.00
Quantity:
Course Dates:

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.

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

IT Skills

Related Products

1