If you found this tip helpful InvestinU offers a range of training supports for Microsoft 365 which can be found here.

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

bite-size learning

Manipulate Your Data Using Advanced Excel Techniques

Master advanced formulas and techniques in Excel and learn powerful features including advanced Conditional Formatting, building dynamic drop-down lists and using Filtering with Subtotals.

Learn to create dynamic VLOOKUP’s, and trapping errors using the IFERROR. Also learn to build a formula that can work as an alternative to the Lookup and not have the same restrictions, using Index and Match.

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.

   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