Excel Top 10 Functions and How to Use Them - Turn Your Business Data Into Insightful Information

    /Tom  /Fragalespeaker of Training Doyensinvite
    Speaker: Tom Fragale


    More Trainings by this Expert
    Duration: 60 Minutes
    Product Code: 51231
    Level: Beginner

CEU Approved

Training Doyens is recognized by SHRM to offer Professional Development Credits (PDCs) for SHRM-CP or SHRM-SCP. This program is valid for 1 PDC for the SHRM-CP or SHRM-SCP. For more information about certification or recertification, please visit shrmcertification.org.


Labor Day Sale! Use code LBRD20 and enjoy flat 20% off on your purchase.

OVERVIEW

In the business world, or within your organization, you probably experience large amounts of data. Maybe the data is about your sales, customers, donations, orders, employees, vendors, expenses, or whatever it may be.

Excel has many built-in functions that help you deal with that data. It is very important that you know how to use some of Microsoft Excel formulas and functions to get the most out of your data in a time efficient manner. This way, you can turn the data into meaningful information and then provide the answers that you need for yourself, your boss, your company or your organization.

WHY SHOULD YOU ATTEND

You should attend this advanced Excel training if you use Microsoft Excel on a regular basis, and want to be more efficient and productive.

AREAS COVERED

• Relative Formulas
• Absolute Formulas
• IF
• AND
• OR
• VLOOKUP
• HLOOKUP
• Match/Index
• SUMIF
• COUNTIF
• AVERAGEIF
• SUMIFS
• COUNTIFS
• NETWORKDAYS

LEARNING OBJECTIVES

If you handle large amounts of data in Excel and want to learn about the most useful Excel functions, this webinar will help you tremendously. You will learn how to use Excel functions to get useful insights from business data. 

WHO WILL BENEFIT

• Business owners
• CEO's / CFO's / CTO's
• Managers of all levels
• Anybody with large amounts of data
• Anybody who uses Microsoft Access/Excel on a regular basis, and wants to be more efficient and productive
• Accountants
• CPAs
• Controllers
• Financial Consultants
• IT Professionals
• Auditors
• Human Resource Personnel
• Bookkeepers
• Marketers
• Admins
• Secretaries
• Writers
• People who need to type documents

SPEAKER

Years of Experience: 30+ years

Areas of Expertise: Microsoft Office Suite

Tom Fragale is a computer professional with over 30 years of professional experience. He is a Microsoft Certified Trainer, a Microsoft Certified Office Master, and a Microsoft Certified Expert in Word and Excel. He has trained over 30,000 business people in on-line webinars, public seminars, and on-site training.

His clients include many Fortune 500 companies, government agencies, military bases, and companies large and small across many industries, including manufacturing, banking, pharmaceutical, education, retail, etc. He started his career as a database application programmer and has served as a consultant and project manager on many successful projects. His topics of expertise include: Access, Excel, Word, PowerPoint, Outlook, Crystal Reports, SQL Server, Visio, QuickBooks, and SharePoint, among others. His passion is training people and helping people get the most out of their computers, and he is a published author having written a book on Microsoft Access.

He graduated in 1988 from LaSalle University in Philadelphia, PA with a BA in Computer Science.

View all trainings by this speaker

Purchase Options

Recorded Session

Get Unlimited Access to the webinar link for Six Months. Login information will be shared 24 hours after the completion of Live Webinar

$199

Training DVD or USB Flash Drive

Free shipment within 96 Hours, from the date of webinar completion

$379

refer friend

Approved Enablers of your
Continuing Education Credits

shrmhrci
View all CEU Approved Webinars