• Call us: 1-800-992-6345 or 316-978-3118
  • Log in to My Records

Leveraging Excel to Support Business Decision Making - Center for Management Development

Search Courses

Print This

Leveraging Excel to Support Business Decision Making

Power up your Excel skills for effective business reporting.

Register button

This intermediate course will help you to organize and manage information in Excel so that you can analyze and visualize data for decision making.  This class will also expose you to free sources of data on the web.

 

Sue Abdinnour, Ph.D., has specifically designed this course to incorporate the structure and formulas in Excel, while building your expertise in sorting, filtering, formulating, analyzing, summarizing, charting and data presentation.

Dr. Sue Abdinnour in the classroom

This class works in Excel.  You must have a working knowledge of Excel.

The class is hands-on and example driven. Each participant will have a laptop loaded with sample data files.  Every objective covered matches with an example data set. Dr. Sue will guide you through each exercise resulting in a spreadsheet you can take back to work and use.

In today’s data-driven environment, where you get your data and how you analyze it determines your competitive edge in the marketplace.  It doesn’t matter what you measure – product usage, inventory turnover, customer retention, service timing, miss shipped orders, or employee rework – the importance of comprehensive data analysis will be critical to your organization. Leaders need an accurate representation of the current circumstances. Their decisions are driven with relevant, well presented data. Becoming Excel proficient will provide you with a skill set that will enable you to enhance your job performance and save you and your organization countless hours of unproductive work.

Excel has amazing capabilities that will give you what you need to take charge and visualize the endless data points you deal with. Then you can take control of your data with confidence and success.

The Excel environment

  • Understand the work area
  • Handle sheets
  • Create a table

 

Learn how to work with data

  • Free sources of data on the internet
  • Import data from a test or a Word file
  • Use queries to import data from the web
  • Sorting, filtering, and advanced filtering of data

Learn how to use formulas & functions

  • Copy formulas with relative, absolute, mixed values
  • Conditional and logical formulas – IF, AND, OR
  • COUNTIF, SUMIF, AVERAGEIF, MAXIF, MINIF formulas
  • VLOOKUP and HLOOKUP formulas

Understand how to visualize your data

  • Create charts
  • Work with pivot tables
  • Use power pivot

If you work with data in any form – collect it, use it, analyze it, report it – then this course will teach you how to efficiently use Excel for analysis and visualization. It is the perfect course to take prior to attending Dr. Sue’s Business Modeling class.

 

This course is designed for employees in any function of the company or organization (operations, supply chain, finance, marketing, IT, HR) and at any level (account representatives, specialists, account managers, supervisors, managers, directors, executives).

“Dr. Sue is a wonderful instructor.”

Summer Moore, Customer Service/Accounting, Bradbury Company, Moundridge, Kansas

Substitutions are free and must be done prior to the start of the class or certificate program.

Cancellations or rescheduling must be received in writing and full refunds will be given up to four business days prior to the start of class.

Any cancellation or reschedule submitted with three or less business days notice is subject to a $35 charge on 1 or 2 day classes and a $75 charge on certificate programs.  

No refunds after the first day of the class or certificate program.

Let’s explore the possibilities of having this program at your facility.  Paula.Seiwert@wichita.edu

Sign up for
Newsletter