Course description
Most self-proclaimed Excel users actually use less than 10% of a spreadsheet’s analytical capability. Spreadsheets are tremendously powerful tools. With them, you can manipulate complex data to supply the information you need to make critical business decisions. This course will enhance your Excel skills by teaching you to use spreadsheets as a tool to model data and support your decision-making.
Introduction to Data Modeling using Excel is a certificate program and non-credit-bearing. There are no degree requirements for the program.
Do you work at this company and want to update this page?
Is there out-of-date information about your company or courses published here? Fill out this form to get in touch with us.
Who should attend?
If you're already familiar with spreadsheet fundamentals and wish to learn the most sought after skills in Excel, this program is for you. You'll learn tips, tricks and shortcuts, and tap into the power of Excel to enhance day-to-day productivity and decision-making.
Training content
This course will provide you with expanded knowledge of the capabilities and power of Excel to enhance day-to-day productivity and decision-making. Take your Excel skill to the next level.
Topics covered include:
- Formulas and functions (sum, average, count)
- Logical and reference functions (if, lookups, index and match)
- Text functions for data cleaning (trim, left, right, find)
- Conditional formatting
- Basic data modeling (pivot tables, what if analysis)
Course delivery details
You can complete this program at your own pace, anywhere and anytime, as long as you have a computer with access to the internet and a web browser. On the program start date, you'll receive access and must complete the program within 10 weeks.
The program consists of five modules that you must complete in sequence. Each module contains:
- Instructor-led videos and resources
- A practice assignment to reinforce the lesson
- A module quiz to ensure you understand the subject matter
You'll need to complete the practice assignment and module quiz with a score of 80% each to unlock the next module. The assignment and quizzes are meant to ensure you understand the content and can be retaken as many times as needed to achieve a passing score.
Costs
The cost of this program is $1,250
Certification / Credits
You will receive a certificate after completing this program
Contact this provider
UB School of Management | A Tradition of Excellence
Since 1923, the UB School of Management has built an impressive reputation as one of the best schools of business in the world. The comprehensive range of our academic portfolio, the expertise of our faculty and the worldwide success of our...