bite-size learning – Cleaning Datat

Cleaning Data with Formulas in Excel

One of the important parts of working with Excel is your data. Get your data in a more workable format and everything becomes easier in Excel.

In this seminar you’ll learn to “clean up” your data by using such functions as; TRIM, PROPER, and CLEAN functions to remove extra spaces, non-printable characters, and fix the capitalization of words.

2 hrs

Like this? Wanna see more bite-size learning?

We have lots of different bite-size learning sessions on offer. To read more about them, click the button below.

If you found this article helpful InvestinU offers a range of training tools for Microsoft 365 and much more which can be found here.

You can check out our social media accounts: FacebookInstagram, or Linkedin pages for more updates and to get in touch today!

   About InvestinU

   Meet The Team

   In the Media



   Microsoft 365 Webinars

   Microsoft 365 Consultancy

   Customised Training

   Bite-Size Learning


   Document Design

   Template Design

   Redesigning Documents

   Forms Creation (Word or Adobe PDF)

   Design Solutions

   Company Branding

   Logo Design


   E-commerce Websites

   Brochure Websites


   Social Media Management

   Content Creation (Blog)


   App Development

   Excel Automation

   Excel Dashboards / Reports

   Bespoke Database Systems

    Microsoft Packages

   Microsoft 365 Webinars

  Microsoft 365 Consultancy

   In-person Consultancy

   Invest365 Microsoft Ultimate