Advanced Formulas & Functions in Excel: Solve Your Data Challenges
| Duration: 60 minutes | Speaker: Tom Fragale |
CREDITS:
Available On-Demand
PURCHASE OPTIONS
ABOUT THE EVENT
Learning how to use Excel efficiently is so critical in many of today’s office jobs. Many people know the basics of Excel. This webinar will show you how to use some of the advanced functions of Excel to really help get the most out of your data be more efficient, and get the information that you are looking for.
Areas Covered
- IF, including the nested IF, the AND, and the OR functions for more complicated If statements
- V-lookup
- H-lookup
- Sum if and Sum ifs
- Count if and Count ifs
- Average if and Average ifs
- Match and Index
- Today, Network days, and other date functions
- PMT and other financial functions
Why Should You Attend?
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 these 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.
If you handle large amounts of data in Excel, this webinar will help you tremendously.
Who Should Attend
- Business Owners
- CEO's / CFO's / CTO's
- Managers of all levels
- Team Leaders
- Supervisors
- Administrative Specialists
- Anybody with large amounts of data
- Accountants
- CPAs
- Controllers
- Financial Consultants
- IT Professionals
- Auditors
- Human Resource Personnel
- Bookkeepers
- Marketers
- Anybody who uses Microsoft Access/Excel on a regular basis, and wants to be more efficient and productive
Tom Fragale
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., and a Microsoft Certified Specialist in Access, Outlook, and PowerPoint. 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 insurance, 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.
Compliance Prime is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: https://www.nasbaregistry.org.
Credits: 1.0
Why You Should Subscribe?
Unlimited Live and On-Demand Courses
Watch all live or recorded webinars (up to 120 minutes long). Get instant access to a library of more than 500 high quality courses presented by best-in-class presenters.
CEUs: APA, CPE, SHRM and HRCI Credits
Fulfil your recertification requirements by earning CEUs from APA, CPE, SHRM and HRCI.
Free Access to Course Materials
Each program comes with Additional Course Materials, which you can download and read anytime.
Additional Discounts
Get flat 20% discount on Premium Product Category like, Long Hour Webinars.
Call Now At
888-527-3477
Email Us At
Subjects:
Microsoft Excel
Testimonials
What people are saying about us
Monica
Client
The knowledge that the presenter shared. Her enthusiasm was awesome!
Bebe
Client
After seeing a few different tutorials on the subject, this is the first one that included real-world "heads up" advice for getting the most out of the pivot table environment. The presenter was Extremely knowledgeable.
Elizabeth Jeffery
Client
The speaker was extremely knowledgeable. Speaker moved the program forward at a good pace. The time flew by.
Donald
Client
Loved the cartoons. Made it easy to understand.
Maria Glezos
Client
I thought it was well organized, comprehensive and the speaker was an effective communicator.
Steve
Client
Learning the importance of REAC due to I am a new Property Manager this is very helpful.
Get Unlimited Webinars, Starting $799 only!
- Unlimited Live and On-Demand Webinars (Up to 120 Minutes Long)
- Unlimited Course Materials
- CEUs: APA, CPE, SHRM and HRCI
- 20% Discount on Long Hour Webinars
- Certificate of Participation
Choose Membership
Similar Events
Apr 25th 2018 @ 10:45 AM ET
2018 Payroll Updates from Tax Reform
Apr 27th 2023 @ 01:00 PM ET
DOLs New Guidance: FMLA, FLSA and Remote Work Arrangements
May 20th 2021 @ 01:00 PM ET
1099-MISC 1099-NEC Compliance: How to Minimize Errors in 2021
Apr 05th 2018 @ 10:45 AM ET
Employee Handbook Updates for 2018: Policy Drafting and Enforcement Tips for Staying Out of Legal Trouble
Event Calendar
Our Accreditation Partner
PAYMENT
100% secure payments. All major credit and debit cards are accepted.
