Description
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.
Date: 2024-03-27 Start Time: End Time:
Learning Objectives
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
ASAP PACE ,IAAP ,Additional credit may be available upon request. Contact Lorman at 866-352-9540 for further information.
Tom Fragale-The PC Guy, Inc.