Excel is still used as the predominant data analysis tool, yet 88% of all spreadsheets have errors. Many of Excel’s biggest drawbacks could be solved if every user were comfortable with the “Format as Table” feature, yet only 1% of Excel users know this feature. This lesson therefore opens the course. What is the proper way to set up an Excel optimised data input sheet? And how can we set it up so the formatting automatically changes as the table gets edited? The Pivot table revolutionised data analytics 20 years ago, Slicers and the AI enabled Flash fill are game changing enhancements.

The course will provide you with optimal ways to set up a table, efficient ways to analyse data, best practice formula set up tricks, using machine learning/AI within Excel to clean up data and speed up tricks.

• Date & Time: 19 February 2020 from 2:00 pm – 5:00pm
• Venue: BUV Ecopark Campus, Ecopark Township, Van Giang, Hung Yen
• Entrance fee:
  • Member: free of charge for 01/ company, extra: VND 500,000/ Person
  • Non – member: VND 1,000,000/ Person
• Register: registration is on the first come first serve basis. Please contact Ms. Tu Anh at anh.vu@bbgv.org or call 024 3633 0244.

About the trainer: 

After 5 years at Deloitte London, David moved to Cambodia in 2013 and started Xlconsulting. The firm has worked with over 100 organisations and provided MS Office training for 1500+ students in Excel, Power BI, presentation skills & email management.

David is an Excel content author for serval bodies including the UK accounting institute and Microsoft Creators YouTube channel, he has his own growing YouTube channel with how to videos in Excel, PowerPoint & PowerBI.