This educational blog is created to guide students to obtain the Comptuter A+ Technician Certification and the Internet and Computing Core Certification (IC3). Also, this blog shows some students' projects and the instruction how to complete the projects. If you have any questions please contact Pan Cheng at pchengeducation@hotmail.com

Saturday, May 23, 2009

Online Excel Tutorials

Go to http://spreadsheets.about.com/od/excel101/ss/080610basic2003.htm and complete the Basic Excel 2003 Spreadsheet Tutorial.

Go to http://spreadsheets.about.com/od/excelformulas/ss/formula_begin.htm and complete the Excel Formulas Step by Step Tutorial.


Go to http://spreadsheets.about.com/od/excelfunctions/ss/sum_autosum.htm and complete the Sum and AutoSum Step and Step Tutorial.


Go to http://spreadsheets.about.com/od/excelfunctions/ss/if_function_sbs.htm and complete the Excel IF Function Step by Step Tutorial.

Go to http://spreadsheets.about.com/od/excelcharts/ss/bar_graph_2.htm and complete the Excel 2003 Bar Graph Chart Tutorial.



Go to http://spreadsheets.about.com/od/excelcharts/ss/pictograph_2.htm and complete Create a Pictograph in Excel 2003




Question: How many kinds of chart are available in Excel?

Go to http://spreadsheets.about.com/od/datamanagementinexcel/ss/create_list_2.htm and complete the How to Create List in Excel.

Go to http://spreadsheets.about.com/od/excelfunctions/ss/vlookup.htm and complete the Using the Excel VLOOKUP Function.

Go to http://spreadsheets.about.com/od/excelfunctions/ss/hlookup.htm and complete the Using the Excel HLOOKUP Function.

Question: What is the difference between VLOOKUP and HLOOKUP?


(Extra credit / Optional / Very hard) Go to Excel Macro and complete the Introduction to using macro in Microsoft Excel.
Spread Firefox Affiliate Button