Advanced Formulas & Functions in Excel: Solve Your Data Challenges

Duration: 90 Minutes
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.
Excel Formulas and Functions
Instructor: Tom Fragale
Product ID: 508345
This webinar is for someone who uses Microsoft Excel on a regular basis, and wants to be more efficient in using the program, or who wants to get more out of it.

Objectives of the Presentation
  • 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 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
  • 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
$249
Recorded Session for one participant
Get life time access with download option!
Book this course
Pay Now
  $329.00 Training CD
Free shipment within 4 Working Days of placing the order. Get life time access for unlimited participants.
  $379.00 Training USB Flash Drive
Free shipment within 4 Working Days of placing the order. Get life time access for unlimited participants.
For multiple location please contact our customer care team +1-510-857-5896.
How it works
Live Session - How it works
  • Login to onlinecompliancepanel with your registered username and password https://www.onlinecompliancepanel.com/login
  • The webinar joining link, username and password for joining the webinar will be updated on your OCP Account 24 hours prior to the webinar
  • Presentation handouts in Downloadable PDF format will be updated on your OCP Account 24 hours prior to the live session
  • Login to the audio conference on the scheduled date and time
  • Get answers to your queries through interactive Q&A sessions via chat at the end of the session
  • Download the Certificate of Attendance and Purchase Invoice from your OCP Account 24 hours after the completion of the session
  • Please let us know your thoughts and views at the end of the webinar, your valuable feedback will help us improve
Recorded Session - How it works
  • Login to onlinecompliancepanel with your registered username and password https://www.onlinecompliancepanel.com/login
  • Upon purchase of the recorded session a link will be updated on your OCP Account within 24 hours
  • Please click on the link to access the Recorded Session
  • Presentation handouts in downloadable PDF format will be updated on your OCP Account within 24 hours of the purchase of the product
  • Download the Certificate of Attendance and Purchase Invoice from your OCP Account after 48 hours of the product Purchase
  • Please share your valuable Feedback at the end of the session
Instructor Profile:
Tom Fragale is a computer professional with over 30 years experience. He has trained over 30,000 business people with online 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. His passion is training people and helping them get most out of their computers. He has written and published a book on Microsoft Access. He graduated in 1988 from LaSalle University in Philadelphia, PA with a BA in Computer Science.
View More