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, 2018

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

Mark Nilson posted events
yesterday
Roger Steven posted events
yesterday
Training Doyens posted events
yesterday
Adam Fleming posted a blog post

INFRARED SPECTROSCOPY Is Crucial to Your Business. Learn Why!

Near-Infrared Spectroscopy, NIR or NIRS, is considered a superior method assay to traditional ones, which are destructive and also reduce the number of doses for sale. It overcomes these drawbacks by being both rapid and nondestructive, which helps it respond to the pressures in the pharma industry for generating more and more data, which leads to more assays that bring these inevitable downsides.In being responsive to the physical and chemical environment of…See More
Thursday

Forum

Workplace safety for workers other than your own 1 Reply

Do your workplace/traffic safety plans include safety measures for workers who are not your own employees? Do they take into account the safety of those who will be - or could be - at your workplace,…Continue

Tags: emt, paramedics, emergency, occupational, health

Started by John Petropoulos Memorial Fund. Last reply by Jen McDade on Thursday.

What % of Dollars should be bugeted for All Safety Training for a "Heavy Equipment Road Construction" company with 100 employees? 1 Reply

I have been at a Highway and Road Construction company for six months. I am developing a (first) complete training program. I am the 1st full time safety hire for this company. I need to develop a…Continue

Started by JTurpening. Last reply by Jen McDade on Tuesday.

Technology and Safety 1 Reply

What are the most useful tools to have at your fingertips? -Toolbox Talks-JSA-JHA-Daily Reports, etc. What is falling through the cracks that could be an easy fix? Safety Managers, Coordinators and…Continue

Tags: safety

Started by Drew stone. Last reply by Jen McDade Feb 15.

Important of Warning sign 1 Reply

Warning sign is a type of traffic sign that guide a hazard ahead on the road. Having proper warning sign on the road provide a healthy environment.Continue

Tags: Signs, Workplace, Safety, Sign, Warning

Started by healthandsafetysigns. Last reply by Jen McDade Jan 14.

Workers paticipation in safety management 2 Replies

Workers paticipation in safety management is the aspect which is required to be implemented in the OHSAS 18001 2007 version. , I invite our experience community members to share their views on the…Continue

Tags: management, safety, in, paticipation, Workers

Started by SafetyRaja. Last reply by Tara safe Dec 27, 2018.

Badge

Loading…

© 2019   Created by Safety Community.   Powered by

Badges  |  Report an Issue  |  Terms of Service