Power up your Excel skills for effective business reporting.
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.
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.