Excel in Microsoft’s powerful and easy-to-use spreadsheet program -- Excel
Business professionals create and manipulate spreadsheets with MS Excel to solve business applications. Participants must have some familiarity with spreadsheet software, as this course quickly progresses to advanced features, including data validation, linked workbooks, pivot tables, lookup functions, solver, and scenario manager. This program prepares participants to sit for the applicable MOS Excel Certification testing. This course is eligible for 3 undergraduate credits (BITS211-Microsoft Excel) toward a bachelor's or graduate degree at Davenport.
After completing this course, you will be able to:
- Plan, create, and format an Excel spreadsheet to solve business applications
- Create formulas manually and with the formula function, and create and format a variety of charts and their components
- Apply special spreadsheet commands such as sorting, filtering, linking workbooks, pivot tables, and lookup functions
- Analyze spreadsheet data through solver, goal seek, data tables, and scenario manager and export and import data with varied sources