Business Spreadsheet Applications
Create professional data-driven workbooks utilizing Microsoft Office Excel spreadsheet software. Using Microsoft Excel, work with formulas and a variety of time-saving functions; create charts and tables; utilize advanced functions and apply conditional formatting; work with multiple worksheets, workbooks, and templates; incorporate data validation; utilize worksheet protection; create macros; work with financial tools and functions; and perform what-if analysis with Scenario Manager, Data Tables, and Solver. Recommended prerequisite: Windows competency, including solid file management skills. This course will use Microsoft Office 2016 or Office 365.