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

Simon Hopes posted a blog post

Speed governor is a technical invention

The popularity of Watt's improved steam engine was rapid, and by 1790 the old Newcomen steam engine was out of sight, and by 1790 there were about 500 steam engines operating in Britain. After less than 100 years or so, by 1868, there were as many as 75,000 steam engines in Britain alone. In 1805, the steam engine in the United States was equipped with cars as a driving force. In 1807, Robert Fulton (1765-1815) of the United States invented a steamship powered by a steam engine. In 1825 George…See More
3 hours ago
HrishikeshRam posted blog posts
3 hours ago
Russel Stuart posted a blog post

HR Documentation is a Vital Aspect of Organizations

HR documentation is of vital importance to organizations. Unless its nuances are mastered organizations can fall into embarrassing and damaging pitfalls.HR documentation is one of the most important aspects at the workplace. The habit of HR documentation is usually imbibed into HR professionals from early on in their careers. But what does HR document?HR documentation resonates with the spirit of the dictum, Verba volant, Scripta manent, meaning "what is written stands; what is uttered flies".…See More
yesterday
Laticia Gibson posted a blog post

Searching A Best Dental Clinic Is Important

Keeping a perfect oral health is crucial. Though, in keeping good teeth set, always it has been a must to research for the good General Dental office you can find in your nearby area. It has to be noted that searching the most suitable clinic can confirm you of good quality and pleasing services. Earlier than you make a selection, there are some important things you have to know.The Crucial Things to…See More
yesterday

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