Formulas, Automatic Calculation & Key Functions In Excel


Click For Bio
Duration
90 Mins
Level
Intermediate
Webinar ID
70286

When it comes to dynamically looking up and retrieving information from small or huge tables of data Lookup functions can elevate you to a new world of accuracy, productivity and time savings in Excel.

To work efficiently with lookup functions you must start with clear understanding, good habits, and application of correct structure and syntax.

This course effectively teaches lookup techniques and demonstrates practical examples, providing the perspective you need to understand the depth and scope of these functions.

Gaining this knowledge is a fundamental and highly marketable skill set in Excel and is vital in a wide range of professions and fields including accounting, financial analysis, government and business administration.

Understand the power of Excel and get the most out of your software investment.

Why Should You Attend

 » Understand the latest powerful and most relevant MS Office functions available
 » Work starter, faster and more effectively
 » Boost profit, efficiency, and productivity
 » Improve job satisfaction, team performance, and professionalism
 » Gain strong competitive advantage at peer and business level
 » Achieve more in less time with higher quality results
 » Strengthen your resume and justification for increased salary

Areas Covered

 » Creating named ranges
 » Understanding VLOOKUP
 » Examples of using VLOOKUP
 » Create a VLOOKUP table
 » Understand absolute references in VLOOKUP functions
 » VLOOKUP to find approximate match
 » VLOOKUP to find exact match
 » Link VLOOKUP to external data
 » Cleansing data for common VLOOKUP issues
 » Performing calculations with VLOOKUP
 » Use the Insert Function technique to create lookup functions
 » Using HLOOKUP
 » Formula Auditing with lookup functions

Who Will Benefit

Staff, managers, and executives who are required to confidently manage data and present business-critical information in a wide variety of private and public sector professions including:

» Accounting
» Banking
» Business Analysis
» Economics
» Finance
» Insurance
» Investment Advice
» Management
» Statistics
» Strategic planning

Roman.jpg

Ray Evans

Ray's professional and relaxed style reflects his thorough understanding of adult learning principles and is demonstrated through his diverse range of classroom, seminar, workshop and online delivery services and instructional materials.

With Microsoft Certifications in Excel and Word, he has mastered over 2500 topics to advanced level in Microsoft Excel, Access, Outlook, Project, PowerPoint, Word, Visio, and Publisher.

Ray has qualifications in Frontline Management, Accounting, Training, and Assessment and is certified in Six Sigma business improvement methodology.

Having trained over 30,000 students, business owners and executives since 1990 and authored a wide range of training and procedural documentation,
complex reports and engaging internet content, Ray has demonstrated strong ability in key communication styles and knowledge transfer.

TESTIMONIALS

"Thanks Ray, brilliant webinar!"
Lorella D'Angelo

"Wonderful presentation, extensive knowledge, caters for introductory through to advanced."
Sarah Hill

"The affordability, accessibility, easy learning techniques of these courses is second to none, and I've done QUITE A FEW courses over the years."
Helen Lindquist

"We have no hesitation in recommending Ray to any organisation requiring computer training at all levels."
Andy Kirss

"Fabulous...webinar! Thank you. Looking forward to your next session."
Elizabeth Walker-Manson

"I have no hesitation in recommending you to any organisation seeking professional and cost effective Microsoft software training and courseware."
Nick Spyrou

"Presentation was most interesting. You were very easy to follow & I learnt a lot of very helpful things. Many thanks! ... Just what I needed, & within my reach."
Mark Whitfield

"I found the presentations easy to follow and the delivery of information kept me interested & involved throughout the whole session. No boring intervals at all!"
Vicki Flavel

"I found these presentations to be a highly practical way to gain valuable knowledge in an easily managed and understandable format."
Bill Valencic

"Finally, an easy and cost-effective way to keep our staff at the cutting edge of the Microsoft Suite 24/7. I am yet to see a more powerful or effective means of providing top level software training."
Spiro Vithoulkas

"The hands-on exercises worked well. I wish I had learned Pivot Tables a long time ago!"
Anna Harvey

"Having the multiple PivotTable worksheets to refer to worked well. Great Presentation."
Wendy Ashman

  Recently Banking & Financial Services Webinars Upcoming Webinar

  Webinars By This Keynote Speaker

Live webinar

Ray Evans

Microsoft Trainer

Jun 12, 2024

Duration : 90 Min

01:00 PM ET / 10:00 AM PT

Webinar Id: 70640

Record webinar

Ray Evans

Microsoft Trainer

Duration : 90 Min

Webinar Id: 70192

Record webinar

Ray Evans

Microsoft Trainer

Duration : 90 Min

Webinar Id: 70193

Record webinar

Ray Evans

Microsoft Trainer

Duration : 90 Min

Webinar Id: 70214

Record webinar

Ray Evans

Microsoft Trainer

Duration : 90 Min

Webinar Id: 70215

Record webinar
Record webinar

Ray Evans

Microsoft Trainer

Duration : 60 Min

Webinar Id: 70246

Record webinar

Ray Evans

Microsoft Trainer

Duration : 90 Min

Webinar Id: 70274

Record webinar

Ray Evans

Microsoft Trainer

Duration : 90 Min

Webinar Id: 70275

Record webinar

Ray Evans

Microsoft Trainer

Duration : 90 Min

Webinar Id: 70276

Record webinar

Ray Evans

Microsoft Trainer

Duration : 90 Min

Webinar Id: 70278

Record webinar
Record webinar

Ray Evans

Microsoft Trainer

Duration : 90 Min

Webinar Id: 70280

Record webinar

Ray Evans

Microsoft Trainer

Duration : 90 Min

Webinar Id: 70281

Record webinar

Ray Evans

Microsoft Trainer

Duration : 90 Min

Webinar Id: 70282

Record webinar
Record webinar
Record webinar
Record webinar

Ray Evans

Microsoft Trainer

Duration : 90 Min

Webinar Id: 70286

Record webinar
Record webinar

Ray Evans

Microsoft Trainer

Duration : 90 Min

Webinar Id: 70288

Record webinar

Ray Evans

Microsoft Trainer

Duration : 90 Min

Webinar Id: 70289

Record webinar
Record webinar

Ray Evans

Microsoft Trainer

Duration : 90 Min

Webinar Id: 70292

Record webinar

Ray Evans

Microsoft Trainer

Duration : 60 Min

Webinar Id: 70293

Record webinar

Ray Evans

Microsoft Trainer

Duration : 60 Min

Webinar Id: 70294

Record webinar

Ray Evans

Microsoft Trainer

Duration : 60 Min

Webinar Id: 70296

Record webinar
Record webinar

Ray Evans

Microsoft Trainer

Duration : 90 Min

Webinar Id: 70538

Record webinar

Ray Evans

Microsoft Trainer

Duration : 90 Min

Webinar Id: 70539

Record webinar