webinar register page

Webinar banner
Excel Data Cleansing Formulas
Paid Live Webinar $25 (includes live event, pdf manual and Excel file plus the recording)
Save money with the Webinar Pass ($20 webinars when you pre-pay).

If you get the data right in Excel, then everything else becomes much easier. Pivot Tables can be created and formula-based reports become much more straightforward to create. Sometimes the data that comes into Excel is badly structured or has issues that stop you using Pivot Tables or formulas. This session will take you through a number of techniques that solve many of those problems and prepares the data ready for reporting.

The techniques can also be applied to other issues in Excel. The session will include:

- Format As Table
- filling blanks with zeroes
- populating missing entries
- removing leading and trailing spaces
- removing spaces with a formula
- fixing and converting dates
- converting values to numbers
- changing the structure from vertical to horizontal
- text to columns
- VLOOKUP
- Removing duplicates
- working with vertical data

Dec 18, 2019 10:00 AM in Perth

Webinar is over, you cannot register now. If you have any questions, please contact Webinar host: Neale Blackwood.