EXCEL www.certiport.com
Excel Module 1 ppt [creating worksheet and simple chart]
Excel Module 2 ppt [formulas, functions, and formatting]
data tables, financial functions
Excel Module 4 ppt [financial functions, data tables, amortization]
date_time_practice_instruction file
logic_if statement/function_example-exercise
logic_reference_practice_instruction_sheet
Charts
Excel Module 3 ppt [charting, what-if-analysis]
script donations instruction file
multiple worksheets/modeling
Excel Module 5 ppt [working with multiple workbooks]
TABLES
Excel Module 6 ppt [creating, sorting, tables, and the IF and IFS count, sum, avg]
ch4_script_lawn
capstone_excel_4
MOS TEST REVIEW
For GMETRIX Training (and here is another link for information)
1. Open up the GMETRIX training application on your computer (Go to the START Menu, Click Programs, and then Click the GMETRIX application icon. If you are in a campus lab then it is already installed. It may or not be installed on the lab then you can download the application from this link www.gmetrix.net/download
NOTE THIS APPLICATION DOES NOT WORK ON A MAC
Once you get the application working you will need to first register with the GMETRIX application (that is run off your computer). If for some reason the application does not show all of the needed registration fields click on this link on the web to register http://www.gmetrix.net/Login.aspx . Once
PIVOT TABLES
pivot table
activity one
Excel Practice
OLD Exam Review