Online Safety Community

3-Hour Excel Automation Boot Camp: Top Ten Excel Functions, Lookup Functions (VLOOKUP, HLOOKUP, MATCH, INDEX), Basics of Excel Macros with an Introduction to VBA

Event Details

3-Hour Excel Automation Boot Camp: Top Ten Excel Functions, Lookup Functions (VLOOKUP, HLOOKUP, MATCH, INDEX), Basics of Excel Macros with an Introduction to VBA

Time: June 24, 2020 from 1pm to 4pm
Location: Webinar
Street: Webinar
City/Town: Aurora
Website or Map: https://bit.ly/2ZD0q5K
Phone: +1-720-996-1616
Event Type: online
Organized By: Training Doyens
Latest Activity: May 29

Export to Outlook or iCal (.ics)

Event Description

OVERVIEW

Excel functions can greatly enhance your ability to perform tasks in day to day activities in Excel. While there are hundreds of functions available, there are 10 functions that all Excel users should know. Whether you are an office worker, or a small business owner using Excel to keep track of your finances or just the casual user, these Excel functions can be very important time savers and enhance your ability to create better performing spreadsheets!

WHY SHOULD YOU ATTEND

As an intermediate to advanced level user of Excel, not only do you want to take your knowledge and skills to the next level, you want to produce meaningful, impactful and insightful reports in the shortest time possible. These features of the application will help you to do just that.

AREAS COVERED

  • Learn many statistical functions including SUM, AVERAGE, MAX, MIN and COUNT
    • Use IF and its counterparts COUNTIF, SUMIF, and AVERAGEIF
    • Calculate dates using TODAY, NOW 
    • Learn many functions to manipulate text once imported including LEFT, RIGHT, LEN, TRIM and CONCATENATE
    • Learn the arguments in the VLOOKUP function
    • Understand the importance of absolute references within many lookup functions

LEARNING OBJECTIVES

This Microsoft Excel training session covers THREE intermediate to advanced features of Excel that provide automation within the application.

Formulas are equations that can perform calculations, return information, manipulate the contents of other cells, test conditions, and more. Explore what are considered the top 10 functions.

WHO WILL BENEFIT

  • Business Owners
    • CEO's / CFO's / CTO's
    • Managers
    • Accountants
    • CPA's
    • Financial Consultants
    • IT Professionals
    • Auditors
    • Human Resource Personnel
    • Bookkeepers
    • Marketers
    • Anybody with large amounts of Data
    • Anybody who uses Microsoft Excel on a regular basis, and wants to be more efficient and productive

To Register (or) for more details please click on this below link:

https://bit.ly/2ZD0q5K

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 3-Hour Excel Automation Boot Camp: Top Ten Excel Functions, Lookup Functions (VLOOKUP, HLOOKUP, MATCH, INDEX), Basics of Excel Macros with an Introduction to VBA to add comments!

Join Online Safety Community

Attending (1)

Take our poll!

Take our poll!

Latest Activity

Forum

When will the Nike LeBron 17 EP Courage to Release?

Nike LeBron 17 EP Courage makes use of a black knit upper with swirling red accents distinguishing the durable heat-molded…Continue

Started by lucy blair 18 minutes ago.

Original herbal Botcho cream and Yodi pills for hips and bums enlargement +27789489516 for sale in Johannesburg

I am a specialist in enlarging of hips bums butts and breasts, I have Hips…Continue

Started by Doctor Zack 4 hours ago.

Women beauty products, Breast hips and bums enlargement skin lightening products for sale in Johannesburg

+27789489516 FOR NEW YODI PILLS, BOTCHO CREAMS, BEXX CREAM FOR BREASTS,…Continue

Started by Doctor Zack 4 hours ago.

Original Botcho cream and Yodi pills +27789489516 for Sale in Johannesburg

Natural herbal remedies to enlarge and make good shape of hips and bums…Continue

Started by Doctor Zack 4 hours ago.

OST zu PST Konverter

Als ich im Internet suchte, fand ich diesen Beitrag und dachte auch über meinen Beitrag nach. OST to PST Converter ist ein professionelles Tool, das eine sichere und zuverlässige Lösung für die…Continue

Started by jannysmith 5 hours ago.

Badge

Loading…

© 2020   Created by Safety Community.   Powered by

Badges  |  Report an Issue  |  Terms of Service