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

Profile Iconrahkeemjceon, Richard Govan, jessicabullseya and 12 more joined Online Safety Community
5 minutes ago
Thomas Shaw posted blog posts
38 minutes ago
ameliapeten posted blog posts
40 minutes ago
classicwow posted a blog post

100% Free runescape buy and sell on RS3gold.com as 2020 Summer Free Giveaway for you Jul.10

So many more women contributed to the annals of science runescape gold and technology, who were never appropriately rewarded for their efforts. Values are medians (interquartile ranges) unless stated otherwiseView this table:View popupView inlineA total of 464 patients (29%) experienced clinical progression of benign prostatic hyperplasia: 297 (36%) taking placebo, 167 (21%) taking dutasteride (P.General Assembly approved the de facto recognition of the…See More
48 minutes ago

Forum

eSoftTools 7z Password Recovery 1 Reply

Try eSoftTools free 7zip Password Recovery Software which is a specialized software that can easily remove and unlock 7z…Continue

Tags: software, recovery, password, 7z

Started by peterboyce. Last reply by jessicabullseya 1 hour ago.

EFFECTIVE POWERFUL LOVE SPELL TO FIX YOUR BROKEN RELATIONSHIP & GET YOUR EX-LOVER BACK FAST AND URGENT PRIEST ADE ancientspiritspellcast@gmail.com

Hello i'm so happy sharing this,I still can't thank you enough powerful Priest Ade,My husband left  for a younger lady because i was unable to give birth due to PCOS,I was so devastated i was lonely…Continue

Started by Sally Kehn 2 hours ago.

TESTIMONY: GENUINE LOVE SPELL CASTER BRING BACK MY EX-LOVER WATSAP+27820502562 DR NKOSI IN NORWAY, USA 23 Replies

DR NKOSI THE BEST AND GENUINE LOVE SPELL CASTER BRING BACK MY EX WIFE. Greetings readers out there, I’m 34 years old. My wife left me 3 months ago, and i love her so much, i have been looking for a…Continue

Tags: MARRIAGE, DIVORCE, SPELL, LOVE, REUNITE

Started by JORGE DAVIS. Last reply by Sally Kehn 2 hours ago.

DBX to PST Converter Software 1 Reply

DBX to PST Converter SoftwareContinue

Started by bradenbradley. Last reply by arwenbedegrayne 2 hours ago.

PDF Merge Tool 1 Reply

PDF Merge ToolContinue

Started by bradenbradley. Last reply by arwenbedegrayne 2 hours ago.

Badge

Loading…

© 2020   Created by Safety Community.   Powered by

Badges  |  Report an Issue  |  Terms of Service