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.

Duration:
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

   In the Media

   Testimonials

  Training

   Bespoke Online Webinars

   Expert Advisory Sessions

   Microsoft 365 Support

   Customised Training

   One-to-one Consultancy

   Bite-Size Learning

   Design

   Document Design

   Template Design

   Redesigning Documents

   Forms Creation (Word or Adobe PDF)

   Design Solutions

   Company Branding

   Logo Design

   Web

   E-commerce Websites

   Brochure Websites

   SEO

   Social Media Management

   Content Creation (Blog)

    Development

   App Development

   Excel Automation

   Excel Dashboards / Reports

   Bespoke Database Systems

    Microsoft Packages

   Invest365 Microsoft Webinars

   Invest365 Microsoft Support

   Expert Advisory Sessions

   Invest365 Microsoft Ultimate