Toll Free
855 966 0789

MS Excel: Top 10 Functions and How to Use Them

MS Excel: Top 10 Functions and How to Use Them

    Duration: 60 Minutes

Faculty: Tom Fragale       Course ID: 1039        Level: All Level

Overview:

In the business world, or within your organization, you probably encounter large amounts of data. Whether the data is about your sales, customers, donations, orders, employees, vendors, expenses, or whatever, Excel has many built-in functions that help you deal with that data. It is very important that you know how to use Excel functions to get the most out of your data in a time efficient manner.

By learning how to use the most useful Excel functions 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 session if you use Microsoft Excel on a regular basis, and want to be more efficient and productive. If you handle large amounts of data in Excel, this webcast will help you tremendously. You can learn advanced Excel formulas for efficiently dealing with large datasets.

Areas Covered in the Session:

  • Relative formulas
  • Absolute formulas
  • IF
  • And
  • Or
  • Vlookup
  • Hlookup
  • Match/Index
  • Sumif
  • Countif
  • Averageif
  • Sumifs
  • Countifs
  • Networkdays
  • Q & A Session

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
Recording
$189.00

Access Recording for Life Time

DVD
$239.00

Training DVD will be shipped within 10 business days

USB
$269.00

Training USB will be shipped within 10 business days

Computer Professional
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.