Office Specialist Beg Word Expert Word Beg Excel Expert Excel PowerPoint Outlook Access Vista  

Microsoft Excel 2007 Microsoft Office Specialist (MOS) and Microsoft Certified Application Specialist (MCAS) reference topics
Working with Cells and Series Autofill the Data Autofill the Labels Autofill the Labels Beginning Excel Beginning Excel Add Content Change the Variables in a Spreadsheet Creating a list in Excel Edit->Paste Special Enter data into cells Insert -> Rows   Using Charts and Graphics Add graphics to a spreadsheet Create a graph Resizing and formatting a graph	Working with Formulas and Functions AutoSum AutoSum a Row or Column Calculate profit Calculate revenue Calculate the retail price Calculate the Total Experiment with Relative Cell References Function Arguments: Average Function Arguments: IF Function Insert Function -> Average Insert Function -> IF Function Selecting a Range Troubleshooting Equations Using Absolute References   Worksheets and workbooks Link and consolidate data Calculate a Grand Total from Several Spreadsheets Create a drop down list: Reference data  Format -> Columns -> Hide Insert -> Columns Insert -> Rows Move or Copy a Spreadsheet  Create a drop down reference list	Formatting Worksheets Add Borders to cells Format -> Cells Format -> Cells -> Number Format -> Columns -> Autofit Format ->Cells ->Currency Format Borders and Shading Format cells for date and time Resize the columns   Auditing a Worksheet: Tools ->Formula  Auditing ->Show Formula  Auditing Toolbar Use the Auditing Toolbar to Trace Dependents   Page Setup and Printing: Preview and print worksheets and workbooks File -> Print Preview File ->Page Setup Format Header and Footers Print a spreadsheet from Microsoft Excel: Page Break Preview   Sort records to be merged Data -> Sort