Spreadsheet
Prerequisite: Duration(1 Day)
This course assumes a basic knowledge of the Microsoft Windows operating environment.
Learning Objectives
This course provides competency in creating workbooks, modifying worksheets, formatting worksheets and printing worksheets. This course also provides competency in creating and editing formulas, working with basic functions and the Function Wizard, applying text attributes and other formatting characteristics, creating workbooks from templates, using styles, adding worksheet backgrounds, applying AutoFormats, and finding and replacing data.
Assessment
Prerequisite: Duration(2 Day)
New User
Learning Objectives
Providing the same concepts as delivered in level one, focusing on the new user with little to no experience with computers
.
Prerequisite: Duration(1 Day)
This course requires an understanding of Excel Level 1 topics
Learning Objectives
This course provides competency in organizing and consolidating data from multiple worksheets, adjusting the screen display, working with advanced functions, using advanced formatting features, using advanced print options, filtering data, using comments, naming worksheet ranges and formulas, creating and modifying charts, protecting data, importing and exporting data, saving worksheets and workbooks as Web pages, and publishing worksheets and workbooks to the Web.
Assessment
Prerequisite: Duration(1 Day)
Excel Intermediate or equivalent experience
Learning Objectives
This course provides competency in validating data, creating and modifying list ranges, sorting database data, using database functions, using the Advanced Filter and Automatic Subtotal features, creating and modifying Pivot Tables and Pivot Charts, formatting and adjusting Pivot Tables, auditing worksheets, performing what-if analyses, and working with scenarios.
Assessment
|
C