In today’s business world, understanding business analytics can give your organization a competitive advantage. This course uses MS Excel, the foundational data analysis tool, to cover advanced Excel formulas, concepts, and applications using larger and more professional worksheets, and focuses on the data modeling approach using Excel vs. the calculator approach. Topics include if-then modeling, built-in functions, charting, transferring data across applications, PivotTables, Spark Lines, Slicers, and Power Pivots.
Students must have Excel intermediate level skills, and need to know how to use formulas and functions in Excel.
Course Code: COMP G7513
Day/Time: Friday, 9am to 4pm
Instructor: Cecilia Walpole-Griffin