+353-1-416-8900REST OF WORLD
+44-20-3973-8888REST OF WORLD
1-917-300-0470EAST COAST U.S
1-800-526-8630U.S. (TOLL FREE)

Excel for Operations Management - Webinar (Recorded)

  • Webinar

  • 65 Minutes
  • March 2024
  • Lorman Business Center, Inc.
  • ID: 5941136

Gain insights into using Excel® to manage the daily operations of a business.

In the daily operations of running a business, we run into huge amounts of data that has to be deciphered and managed very quickly. You have to find certain data, and maybe get subtotals. You may have to display data that meets a certain criteria.

Learning Objectives

  • You will be able to define certain types of data with sort and filters.
  • You will be able to identify totals and subtotals for a list of data.
  • You will be able to explain how you got to a bottom line with goal seek and the solver.
  • You will be able to review huge amounts of data with sumif and countif and data table.

Agenda

Getting Subtotals and Subcounts
  • Using SUMIF and COUNTIF
  • Using Subtotals
  • Using Totals With Formatted Tables
Displaying the Info You Need
  • Sorts
  • Filters
  • Conditional Formatting
Getting to the Bottom Line
  • Using Goal Seek
  • Using Data Tables
  • Using the Solver

Speakers

  • Tom Fragale
  • Tom Fragale,
    Computer Trainer and Consultant ,
    Tom Fragale


    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.

Who Should Attend

This live webinar is designed for business owners and managers, supervisors, associates, administrative professionals, analysts, controllers, bookkeepers and accountants.