Course 1: Students will be able to: start Microsoft Excel, identify the components of the Excel interface, open an Excel workbook, use the Help window, and navigate worksheets; enter and edit text, values, and formulas; manipulate pictures; and save and update a workbook; move and copy data and formulas; use relative and absolute references; and insert and delete ranges, rows, and columns; use the SUM, AutoSum, AVERAGE, MIN, MAX, COUNT, and COUNTA functions to perform calculations; create and apply text and conditional formatting; customize cells, rows, and columns; format values and numbers; copy and apply cell and table styles and formatting, and sort data; check spelling, find and replace text and data, preview and print, and format page layout; create, format, modify, and customize chart types and styles; freeze panes and split a worksheet; manipulate content, hide and unhide, set print titles, page breaks, and headers on a worksheet; and manage multiple worksheets; use graphics as conditional formatting for data; and insert and modify SmartArt graphics and screenshots. Course 2: Students will be able to: link worksheets by using 3-D formulas; add a Watch window; create and manage links between workbooks; and create a workspace; apply special and custom number formats; control the display of zero values; use functions to format text; create, apply, and modify styles; apply and modify themes; merge and split cells; change the orientation of data in cells; transpose data; use Paste Special operations, and add a background color and a watermark; create an outline and consolidate data; create subtotals in a list; use multiple subtotal functions; and create custom views to save different sets of worksheet display and print settings; define and apply cell and range names; use names in formulas; and define and apply 3-D names; sort data by columns; filter data based on complex criteria and copy filtered results to another range; create, format, and name a table, and add rows and columns; and use structured references; save and publish a worksheet as a Web page; insert and edit hyperlinks; publish a worksheet; and send a worksheet as an e-mail attachment; format data points in charts; create combination charts and trendlines; insert sparklines; use chart templates; and add and modify drawing objects, shapes, and images; use auditing features; add comments to cells and workbooks; protect a worksheet or part of a worksheet; protect the workbook structure; share, merge, and track changes in a workbook; find and remove hidden and personal data in a workbook; and mark a workbook as final; change Excel's default application settings and customize the Ribbon; work with Excel templates; and create and manage templates; create a PivotTable for analyzing and comparing large amounts of data; modify the PivotTable view by using slicers to filter data and by rearranging fields; improve the appearance of a PivotTable by changing its field settings and applying a style; and create a PivotChart to graphically display data from a PivotTable. Course 3: Students will be able to: use the IF and SUMIF functions to calculate a value based on specified criteria; use a nested IF function to evaluate complex conditions; and use the ROUND function to round off numbers; use the PMT function to calculate periodic payments for a loan; use Date and Time function to calculate duration in years, months, and days or time; display, print, and hide formulas; create array formulas to perform multiple calculations on multiple sets of data at one time; and change calculation options and iteration limits; use the VLOOKUP and HLOOKUP functions to find values in worksheet data; use the MATCH function to find the relative position of a value in a range; use the INDEX function to find the value of a cell at a given position in a range; and use data tables to project values; use the Data Validation feature to validate data entered in cells; and use database functions to summarize data values that meet criteria you specify; export data from Excel to other formats, and import data from a text file into an Excel workbook; import XML data into a workbook, and export data from a workbook to an XML data file; and use Microsoft Query and the Web query feature to import data from external databases; Use the Goal Seek and Solver utilities to meet a target output for a formula by adjusting the values in the input cells; use the Analysis ToolPak to perform statistical analysis; and create scenarios to save various sets of input values that produce different results; Run a macro to perform tasks automatically; recorded macros; assign a macro to a command button and a button in the worksheet; use a button to run the macro; create an Auto-Open macro; edit a macro by editing VBA code; and create a custom function to perform calculations when built-in functions are not available.