LARA MELLOR TRAINING & CONSULTANCY

Microsoft Excel: Functions Part 3

Do you sometimes wish there were functions to do things that you do regularly.  Microsoft Excel often adds new functions to the list, some of which automate tasks that would otherwise have been manual.

Using some of these new functions we can join information in multiple cells together, stack data simply, keep or remove specific rows or columns from the data and wrap the data into a certain number of rows and columns.

The ‘using functions part 3’ module of Lara Mellor Training and Consultancy’s Microsoft Excel training courses is designed to help you learn how to use a selection of these newer functions.

You will learn:

  • How to use the TEXTJOIN function
  • How to use the VSTACK and HSTACK functions
  • How to use the CHOOSEROWS and CHOOSECOLS functions
  • How to use the TAKE and DROP functions
  • How to use the EXPAND function
  • How to use WRAPROWS and WRAPCOLS functions
  • How to use the SWITCH function
  • How to use TEXTSPLIT, TEXTBFORE and TEXTAFTER functions

Remember, you can pick and choose your own modules to be sure your team gets the best out of the training and learn valuable skills that they will be able to use within your business straight away.

Ready to get started?

Get in touch today to book your Microsoft Excel training.

Remember, you can pick and choose your own modules to be sure your team gets the best out of the training and can learn valuable skills that they’ll be able to use within your business straight away.

INTERESTED IN MULTIPLE COURSES?

If you’re looking to book courses in Word, Excel, PowerPoint or other Microsoft programmes, please get in touch via our general training enquiry form here.