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; professionally format worksheets; 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; export and cleanse data sets; 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 365/Excel 2019.