Take the next step in having your data work for you.  This course will show you how you can easily import data into a spreadsheet using Power Query and use the new TEXT functions to help you with text layout in spreadsheets. You’ll also learn how to control what data is entered into the spreadsheet.
► Duration: 90 Minutes
► Delivery:  Training Room, Business South, (In Person)

This workshop is suitable for anyone who needs to import data from other sources and organise text entries in spreadsheets correctly. You’ll also learn techniques to ensure that only the correct data is being entered into your spreadsheets.

Learning Outcomes:

By the end of this session you will be able to:

1. Import Data from other sources using Power Query
2. Consolidate data from multiple worksheets
3. Use Text Functions to organise your text across cells
4. Control what values can be entered in cells with Data Validation
5. Create a dropdown list for data entry

Kevin has 25 years’ experience in delivering Microsoft Office training. He has worked with individuals, small and large businesses, local authorities and  government departments helping staff to improve their engagement with the software they use.

Excel is a powerful tool to record, analyse and manipulate data. With Simply Training.co Kevin has successfully shown his clients how to use this tool to more effectively manage their data and take back time by using the many timesaving features available in Excel.


Not-for-Profit organisations, clubs and charities that are eligible* will receive a 50% subsidy.
Subsidised workshops are due to the generous support of Otago Community Trust.
*Eligibility criteria: Not-for-Profit organisations, charities, and incorporated societies are to be a registered organisation with a NZBN #, Society # or Charities #.
Please provide us with the NFP name when you register. Terms and conditions apply.