Shaun McGrady

This is a hands-on course on business problem-solving. The tools used are a spreadsheet and database software. The objective of the first part of the course is to practice creating spreadsheet models. Applications are designed using built-in functions with special emphasis on financial functions. Charting concepts are introduced as presentation tools. Other skills include: working with Pivot tables, goal-seeking and what-if modeling. The second part of the course is an introduction to DBMS with emphasis on using and developing database applications for a business context. Topics include: Table design, Query design, Reports and Forms design. This course also includes the basics of Business Analytics.