Online Safety Community

Microsoft Excel: Let’s Look Beyond the Lookup

Event Details

Microsoft Excel: Let’s Look Beyond the Lookup

Time: August 7, 2018 from 1pm to 2pm
Location: Training Doyens 26468 E Walker Dr
Street: 26468 E Walker Dr, Aurora, Colorado 80016
City/Town: Aurora
Website or Map: https://bit.ly/2KQlmME
Phone: +1-720-996-1616
Event Type: online
Organized By: Training Doyens
Latest Activity: Jul 6

Export to Outlook or iCal (.ics)

Event Description

OVERVIEW

Microsoft Excel VLOOKUP retrieves one result to a match request, if that match can be found in the leftmost column of a large dataset. If the data is not laid out properly, or if the data is held as the wrong type, everything crumbles in the spreadsheet. Instead, you can expand your horizons with text, logical, lookup, and math functions – as well as new ways of referencing the data. This webinar will explorehow to use VLOOKUP in Excel and many other powerful, dynamic functions available in Excel.

All too often, we get our data from clients that don’t understand how to use Excel, or databases that weren’t set up with our goals in mind. We can spend far too long trying to make the data just right, instead of pulling out the right tool from the toolbox. Integrating IFERROR, ISERROR, and IFNA with VLOOKUP immediately makes it more forgiving, and using MATCH with it makes it more flexible. 

WHY SHOULD YOU ATTEND

Unlike many webinars, Neil’s sessions are 100% hands-on real-world examples of the skills he’s presenting. After this session, you’ll have a screenshot-laden step-by-step guide to performing the techniques we cover, as well as downloadable code for supplemental User Defined Functions. You’ll be able to apply these skills directly to your work with almost no adjustment, and with a very short learning curve.

AREAS COVERED

Making VLOOKUP work well in every scenario, even when it can’t handle the request:

  • VLOOKUP arguments
  • ISERROR, IFERROR, and IFNA integrations
  • MATCH integration with VLOOKUP

Replacing VLOOKUP with more flexible functions:

  • INDEX and MATCH replacement of VLOOKUP
  • Multiple-criteria lookup with SUMIFS
  • Ranked lookup with LARGE

Supplementing your lookups with alternative tools:

  • Wildcard characters for flexible lookups
  • CONCAT for multi-variable lookups
  • Integrating color into your lookups

LEARNING OBJECTIVES

Simple VLOOKUP is a powerful tool, but there are a thousand ways to tweak it to be more powerful – or to bypass it for more flexible, useful functions. Supplementing Microsoft Excel VLOOKUP with functions like IFERROR, MATCH, and CONCAT, or using tools like SUMIFS, LARGE, INDEX, MATCH, and SEARCH can build a suite of functionality you can apply to the kind of data you see in the real world. If you can’t guarantee that your data will be properly structured, VLOOKUP will give you errors and incorrect answers,more often than not.

WHO WILL BENEFIT

  • Business Analysts
  • Managers
  • Financial Professionals
  • Administrative Professionals
  • HR Professionals

 

For more detail please click on this below link:

https://bit.ly/2lYS57K

 

 

Email: support@trainingdoyens.com

Toll Free: +1-888-300-8494

Tel: +1-720-996-1616

Fax: +1-888-909-1882

 

 

 

Comment Wall

Comment

RSVP for Microsoft Excel: Let’s Look Beyond the Lookup to add comments!

Join Online Safety Community

Attending (1)

Take our poll!

Take our poll!

Latest Activity

HrishikeshRam posted blog posts
41 minutes ago
Training Doyens posted events
4 hours ago
Roger Steven posted a blog post

Social media policy for healthcare

Why has social media policy for healthcare now become a rather indispensable part of the official routine of most healthcare settings? Simple: The sheer prevalence of this medium. The social media such as Facebook, WhatsApp, LinkedIn, YouTube or Instagram offer unlimited opportunities for spreading information about a business or individual to vast sections of the populace. For healthcare settings, it is a tool of enormous use and value because the healthcare unit can propagate information in…See More
21 hours ago
Jen McDade joined Michael Tooma's group
Thumbnail

Safety Law

A group for those interested in occupational health and safety law and legal cases.
23 hours ago

Forum

Road Safety

What can be the best measures for Road Safety?Continue

Started by Jen McDade Sep 27.

safety equipments in breweries 4 Replies

safety equipments in breweries -- kindly provide detailsContinue

Started by ajit. Last reply by Jen McDade Sep 24.

Unusual Safety Tips 10 Replies

Please share some unusual but genuine safety precautions.My unusual safety tips - Don't drink sweet fruity juice while driving in the night as it contains sugar and sugar slows down your blood…Continue

Started by Arnold Brame. Last reply by Jen McDade Sep 24.

Safety products 9 Replies

While working or at some work stations, employees are exposed to threats or at times suffer severe injuries. The safety of the employee should be the foremost priority. Safety equipment aids help in…Continue

Tags: equipments, and, products

Started by Enna Henry. Last reply by Jen McDade Sep 24.

Talend Application Integration

APPLICATION INTEGRATION:Talend ESB and Application Integration delivers agile real-time integration of applications and data.Heterogeneous Application and Data IntegrationTalend’s open source ESB…Continue

Tags: york, new, certification, training, talend

Started by nicolewells Sep 21.

Badge

Loading…

© 2018   Created by Safety Community.   Powered by

Badges  |  Report an Issue  |  Terms of Service