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.
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