Advanced Formulas & Functions in Excel: Solve Your Data Challenges

Tue Aug 20 2024 at 12:00 pm to 01:00 pm

Online | Online

GRC Training Online
Publisher/HostGRC Training Online
Advanced Formulas & Functions in Excel: Solve Your Data Challenges
Advertisement
Advanced Formulas & Functions in Excel: Solve Your Data Challenges
About this Event

Course Description:

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.


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.


Use Code - "FLAT10" and get a 10% discount.


Area Covered In The Webinar


  • 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


Who Will Benefit:


  • 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


Instructor Profile:

Tom Fragale is a computer professional with over 35 years of professional experience, and over 21 years of training 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, PowerBI, 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. He currently resides in Cherry Hill, New Jersey.

Register Now!

Use Code - "GET10" and get a 10% discount.


Refund and Cancellation Policy

At GRC Training Online, we strive to provide the best possible experience for our attendees. This Refund and Cancellation Policy outlines the guidelines for refunds, cancellations, and other related matters. By registering for our Live Webinars and On-Demand Recordings, you agree to adhere to the following terms:

1. Refunds for Live Webinars:

  • Attendees may cancel their registration up to two working days prior to the course start date to be eligible for a full refund.
  • If GRC Training Online cancels a Live Webinar, a full refund will be processed within two working days.

2. Non-Refundable Situations:

  • Refunds will not be given to participants who do not attend the webinar or cancel within 24 hours before the webinar start time.
  • On-Demand Recordings are non-refundable. However, participants may request access to alternative webinars in exchange.

3. Webinar Cancellation:

  • GRC Training Online reserves the right to cancel a Live Webinar due to insufficient enrolment or unavoidable circumstances.
  • Attendees will be notified at least 24 hours in advance if a webinar cancellation occurs, and a full refund will be provided.

4. Substitution Policy:

  • Substitutions of registered participants can be made at any time before the webinar starts. Please inform us of any substitution requests to ensure smooth registration.

5. Feedback and Concerns:

We value the feedback and opinions of our customers. If you have any concerns about the content or delivery of the webinar and are not satisfied with your experience, please contact us at [email protected] or by phone at +1-302-433-6276 Mention your feedback for a prompt resolution of the matter.

We appreciate your valuable input, as it helps us continuously improve our products and services to meet your expectations.

Note:

  • Refunds will be issued using the same payment method used for registration.
  • GRC Training Online reserves the right to modify this Refund and Cancellation Policy at any time without prior notice. Any changes will be effective immediately upon posting on our website.

For any questions or clarifications regarding this policy, please contact us at [email protected] or +1-302-433-6276.

Thank you for choosing GRC Training Online for your training needs. We look forward to providing you with valuable learning experiences.


Advertisement

Event Venue

Online

Tickets

USD 149.00 to USD 279.00

Sharing is Caring: