Events
Organizers
Venues
Add Event
Subscribe
Subscribe
Sign In
Hotels
Car Rental
Tours & Transport
Event Tickets
Excel Lookup Functions – 2 Part Web Series (Module 1) 2018
01 Oct 2018
Webinar
Home
Excel Lookup Functions – 2 Part Web Series (Module 1) 2018
Description
Topics
Learning why the INDEX and MATCH combination often is superior to VLOOKUP or HLOOKUP
Simplifying multiple-field look-ups with concatenation (combining fields together into a single cell)
Seeing what types of user actions can trigger #REF! errors
Learning about the IFNA function available in Excel 2ExcludeInclude3 and later
Employing the SUMIF function to add up values related to multiple instances of criteria that you specify
Using VLOOKUP to look up data from another workbook
Understanding the importance of absolute references within many lookup functions
Avoiding the complexity of nested IF statements with Excel’s CHOOSE function
Seeing how the HLOOKUP function enables you to perform horizontal matches
Troubleshooting other errors VLOOKUP can present, such as #REF!, #NAME!, and #VALUE!
Learning about the MAXIFS function available in certain versions of Excel 2ExcludeInclude6
Exploring why VLOOKUP sometimes returns #N/A instead of a desired result
Who should Attend
CPAs
CFOs
Investment Analysts
Controllers
Business Analysts
Financial Analysts
M&A Specialists (Mergers & Acquisitions)
Forecasting & Planning Teams
Strategic Planners
Risk Managers
Capital Expenditure Planners
Past Events
Excel Lookup Functions – 2 Part Web Series (Module 1) 2018 - 01 Oct 2018, Webinar
(78851)
Important
Please, check "Excel Lookup Functions – 2 Part Web Series (Module 1)" official website for possible changes, before making any traveling arrangements
Event Categories
Business:
Finance, Human Resources (HR)
Services:
Banking
Technology:
Software & Applications
Other Events with Similar Categories
Business Conferences
Technology Conferences
Services Conferences
Human Resources (HR) Conferences
Finance Conferences
Banking Conferences
Software & Applications Conferences
Business Ethics Conferences
Novel Technologies Conferences
Business Intelligence Conferences
Entrepreneurship Conferences
International Business Conferences
Science and Technology Conferences
Business Engineering Conferences
Employee Engagement Conferences
Career Conferences
Occupational Stress Conferences
Financial Conferences
Investment Conferences
Assets Conferences
Money Market Conferences
Accounting Conferences
Payment Conferences
Stock Market Conferences
Hedge Fund Conferences
Funds Conferences
Mergers Conferences
Mergers and Acquisitions Conferences
Pricing Conferences
Forex Conferences
Profitability Conferences
Billing Conferences
Revenue Conferences
Incentives Conferences
Banks Conferences
Mortgage Conferences
Loan Conferences
Software Conferences
Applications Conferences
Apps Conferences
Saas Conferences
Capital Markets Conferences
Employee Happiness Conferences
Financial Engineering Conferences
Formal Methods Conferences
Management Accounting Conferences
Personal Finance Conferences
Computer Applications Conferences
Corporate Finance Conferences
Employment and Disability Conferences
Experimental Finance Conferences
Financial Management Conferences
Economics and Finance Conferences
Microfinance Conferences
Financial Security Conferences
Human Capital Conferences
Labor Markets Conferences
Workforce Conferences
Staff Conferences
Teams Conferences
Employee Conferences
Careers Conferences
Hiring Conferences
Hire Conferences
Bank Conferences
Money Conferences
Accounts Conferences
Credit Conferences
Debit Conferences
Fund Conferences
Stock Conferences
Hedge Conferences
Monetary Conferences
Cash Conferences
Merger Conferences
Acquisition Conferences
Capital Conferences
Price Conferences
Profit Conferences
Atm Conferences
Account Conferences
Cashier Conferences
Check Conferences
Financial Services Conferences
Sap Conferences
Oracle Conferences
Fintech Conferences
Hr Conferences
Human Resources Conferences
Workforce Management Conferences
Personnel Conferences
Team Building Activities Conferences
Other Events with Similar Location or Organizer
Virtual (Online) Events
Events by Webinar Compliance
Featured Conferences & Exhibitions
AI World Congress 2024
Biotechnology for the Non-Biotechnologist
International Conference of Leadership Business and Managment (ICLBM)
International Conference on Trends and Innovations in Management, Engineering, Sciences and Humanities (ICTIMESH 2024)
International Crop Science Conference & Exhibition
74th New Orleans Academy of Ophthalmology (NOAO) Annual Symposium 2025
ConveyUX
INTED2025 - The 19th International Technology, Education and Development Conference
EnviroTech Athens 2025
35th Annual Art and Science of Health Promotion Conference
The Learning Ideas Conference 2025
Primary Care Hawaii Conference - Caring for the Active and Athletic Patient
Articles / News / Press releases
Anticorruption thematic in the fourth Nigerian republic and public finance management
The Hybrid Work Model
Business conference and trade shows as an efficient tool
Business Events in the USA
A Technology conference is a great way to expand your knowledge
Technology conferences - a useful tool
Search for Events
Search
Clear