EXCEL  www.certiport.com 

Excel Module 1 ppt [creating worksheet and simple chart]

 

sundown_services_client
 

dynamite 2020

session one


Excel Module 2 ppt [formulas, functions, and formatting]

ITMG Excel Session_Two

e02_script_wyoming

 

awesome 2020

ADD ON TO AWESOME 2020

in class function exercise

more financials


MODULE THREE

Excel Module 3 ppt [charting, what-if-analysis]

PPT charts

exp2010_ec03_script_donations

charts2010.xls

chart ME instructions

chart ME file

capstone_charts

in-class charts

logic_if statement/function_example-exercise


MODULE FOUR

Excel Module 4 ppt [financial functions, data tables, amortization]

what if analysis pdf

e06_script_homeloan

text_time_instruction


MODULE FIVE

Excel Module 5 ppt [working with multiple workbooks]

mod5-mult-worksheets-ICA.xlxs

Chap5_pe1_trust

 


TABLES

Excel Module 6 ppt [creating, sorting, tables, and the IF and IFS count, sum, avg]

PPT old tables c4

tables pdf

ch4_script_lawn

capstone_excel_4

ec_04_houses


MOS TEST REVIEW

 

excel_tips_and_tricks

logic-functions-practice


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

pivot_table.xls

pivot table activity2

e05p2azteca

pivot table activity3


 

 

ch1 fuel

ch 1croyal file

e01_script_sdclnt

excel mod1 file

e04c1houses

Excel Practice OLD Exam Review