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,
The PC Guy, Inc.- Computer professional with over 30 years of professional experience
- Microsoft® Certified Trainer, Microsoft® Certified Office Master, Microsoft® Certified Expert in Word® and Excel®, and a Microsoft® Certified Specialist in Access®, Outlook®, and PowerPoint®
- Trained over 30,000 business people in online webinars, public seminars, and onsite training
- Clients include many Fortune 500 companies, government agencies, military bases, and companies large and small across many industries, including insurance, manufacturing, banking, pharmaceutical, education, and retail
- Topics of expertise include Access®, Excel®, Word®, PowerPoint®, 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
- A published author, having written a book on Microsoft® Access®
- B.A. degree in computer science, LaSalle University
Who Should Attend
This live webinar is designed for business owners and managers, supervisors, associates, administrative professionals, analysts, controllers, bookkeepers and accountants.