Online Safety Community

Microsoft Excel: Let’s Look Beyond the Lookup

Event Details

Microsoft Excel: Let’s Look Beyond the Lookup

Time: May 15, 2018 from 1pm to 2pm
Location: 26468 E Walker Dr, Aurora, Colorado 80016
Street: 26468 E Walker Dr, Aurora, Colorado 80016
City/Town: Aurora
Website or Map: https://goo.gl/GaiADn
Phone: 18883008494
Event Type: online
Organized By: Training Doyens
Latest Activity: Apr 24

Export to Outlook or iCal (.ics)

Event Description

OVERVIEW

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 explore many of the most 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. You can replace VLOOKUP entirely, sometimes with INDEX and MATCH, and other times with functions you wouldn’t assume, like MAX, SUMIFS, and LARGE. We’ll discuss a number of real-world scenarios where these tools shine.

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 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/2JJufr1

 

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

Mark Nilson posted events
2 hours ago
Training Doyens posted an event
Thumbnail

HR Practices in Terminating Employees at 26468 E Walker Dr, Aurora, Colorado 80016

June 12, 2018 from 1pm to 2pm
OVERVIEWEmployers must terminate employees from time to time in order to run their businesses effectively.In today’s litigious world, terminating employees is an emotional and legal minefield for managers and supervisors.Even subtle differences in preparing for and conducting terminations can impact greatly the level of legal risk, and whether an employer faces a claim that may cost six figures (or more) in potential liabilities and litigation costs.This webinar will give you knowledge on basic…See More
3 hours ago
Mark Nilson posted events
Friday
Training Doyens posted events
Friday

Forum

Python Condition Objects Tutorial in 2018 1 Reply

If you have knowledge of other programming languages, then you would know the importance of conditional statements. Conditional statements are required for taking decisions. Whenever we operate the…Continue

Tags: course, certification, training, languages, programming

Started by Elena Lauren. Last reply by Jim Chesters on Tuesday.

Power BI Visualization Types

Visualizations in Power BI displays the visual insights from a data. In power bi service a visual can be pinned from reports to create dashboards. Visuals are used in reports.List of visualizations…Continue

Tags: COURSE, TRAINING, BI, POWER

Started by Azharuddin May 15.

Automation Anywhere. How do I pick a value from dropdown 1 Reply

Automation Anywhere. How do I pick a value from dropdown. I tried 'set text' from a copied variable. Its very slow, and also doesnt…Continue

Tags: anywhere, automation

Started by emmablisa. Last reply by venkatesh Mar 29.

Agile overcome common software security challenges

Paradoxically, security is a negative goal. To secure something, you must understand how insecure it is. Start by trying to break it or by figuring out how other people might break it. The same is…Continue

Tags: agile, scrum, security

Started by nicolewells Mar 23.

Badge

Loading…

© 2018   Created by Safety Community.   Powered by

Badges  |  Report an Issue  |  Terms of Service