Details
Who is it for?
Anyone who manages, updates or creates spreadsheets. It would be helpful if you understand relative, absolute and mixed references prior to attending.
What will I learn?
How to use number formatting to display your data correctly, from keeping leading zeros to why dates aren’t actually dates and a few functions for working with dates to help solve problems like how many days are in the current month or how many working days between dates.
How will it help me?
Understanding the different types of data, and the best way to display it, is key to providing information from data. Dates are often the basis for analysis and forecasting and you can build on this knowledge to create dynamic spreadsheets and dashboards.