This course teaches students how to utilize the tools in Excel to manage various business functions. This course is designed for users that already have a general working knowledge of Excel. First students will explore foundational data analysis tool, to build on the skills and concepts covered in introductory computer application courses. Formulas and functions are reviewed then more advanced topics are discussed including data if-then modeling, built-in functions, charts, transferring data across applications, and using the built-in tools such as PivotTables, Sparklines, Slicers, and PowerPivots. Discussions will center on managing customers, vendors, and employees, analyzing demographics, creating schedules, marketing calendars, creating budgets and planning and tracking loans. Other topics covered include how to supervise sales with Excel, prepare invoices, gauge your business status, configuring cash flow statements, resolving business ratios, and finalizing financial statements.
Pre-requisite: CIS 200