© Copyright Ezee Computer Training 2010 Made by Wen Studio PERFORMING CALCULATIONS Using Simple Formula • How to enter a formula using keyboard • How to enter a formula in the formula bar • How to use mathematical operators in excel • How to enter a cell or a range reference using mouse • How to use Autosum to calculate a total quickly • How to use relative references • How to use absolute references • Copying a single formula Using Simple Functions • How to enter a function directly • How to use paste function • How to enter now, date, and today functions Using Simple Database Functions • How to find the sum of specific records using paste function • How to find the average of specific records • How to find the maximum / minimum value of specific records • How to find the number of records Using AutoCalculate • How to use AutoCalculate to calculation without using formula  MANAGING WORKSHEETS Managing Worksheet Information • How to move information using cut and paste • How to move information using drag and drop • How to copy information using copy and paste • How to use the paste special command • How to copy information using drag and drop • How to insert a new row • How to insert multiple rows • How to delete rows • How to insert a new column • How to insert multiple columns • How to delete columns • How to insert a cell Working with Drawing Objects and a Hyperlink • How to insert an AutoShape • How to insert a WordArt • How to insert a Clipart • How to insert a diagram • How to insert a hyperlink FORMATTING WORKSHEETS Adjusting Column Width / Row Height • How to adjust column width using mouse • How to adjust column width using menu • How to adjust row height using mouse • How to adjust row height using menu • How to adjust automatically column width and row height • How to hide / unhide rows / columns • How to freeze a column / a row • How to split a worksheet in panes   Formatting Cells Using Toolbar • How to change font • How to change font size • How to bold • How to italic • How to underline • How to change font colour • How to align data in a cell • How to indent data in a cell • How to merge cells and centre data • How to change number to percentage • How to increase / decrease decimal points • How to copy format using format painter • How to format table using AutoFormat CREATING CHARTS Creating Chart Using Chart Wizard • How to use chart wizard • How to move chart • How to resize chart • How to change chart type • How to change chart source data • How to swap data series in legend with the X-axis • How to move existing chart to another worksheet Changing Chart Options  • How to change chart title, X axis and Y axis title • How to change gridlines • How to change legend options • How to change data labels • How to add data table • How to delete data series • How to add data series using mouse • How to delete chart PAGE SETUP AND PRINT Page Setup • How to insert and remove page break • How to set and clear print area • How to change page orientation • How to change scaling • How to change paper size • How to change page margin • How to align to centre of page • How to add header / footer Previewing and Printing • How to print preview • How to print active sheets • How to print selected cells • How to set and clear a print area • How to print gridlines • How to change the print quality • How to print chart • How to multiple copies • How to print columns and rows headings in multiple pages GETTING STARTED Creating an Excel Workbook  • What is a spreadsheet? • How to start Excel • How to create a new default Excel workbook • How to use page zooming Getting Familiar with the Excel Screen  • Indentifying parts of the Excel screen • How to use the menus • Working with the ribbon (2007) or toolbars (2003)  • How to use shortcut menu using right mouse click • How to use shortcut key • Using the scroll bars • The status bar • Using the zoom • How to search help • How to use content help Moving Around Your Cursor • How to activate a cell using the mouse • How to move to a cell using keyboard • How to move using go to command • How to move using name box • How to move within selected range • How to move to other sheets within a workbook Selecting Range in Workbook • How to select a single cell • How to select a range of cells • How to select non-adjacent cells • How to select a range of cells using shift key • How to select the entire column • How to select the entire row • How to select the entire worksheet • How to select non-adjacent ranges • How to select multiple worksheets Entering Data into Worksheet • How to enter text (label) into a cell • How to edit cell content • How to edit contents using formula bar • How to use spelling check • How to replace contents in a cell • How to delete contents in a cell • How to undo and redo • How to enter number as a value into a cell • How to enter number as a label into a cell • How to enter date into a cell Using AutoFill and AutoComplete • How to use AutoFill to enter text • How to use AutoFill options • How to use AutoFill to enter sequence numbers • How to customize AutoFill • How to enable AutoComplete • How to work with AutoCorrect • How to use pick list to enter data • How to enter data into a range of cells • How to fill a range of cells with the same data Opening, Saving and Closing Workbooks • How to save a workbook for the first time • How to save another copy using `save as' • How to save to another folder • How to save into a external hard drive, CD or USB drive. • How to save into a different file format • How to save a workbook as a web page • How to close the current workbook • How to open a workbook • How to exit Excel 519-473-1391 eMail