Microsoft Office Excel 2007 – Level I
Contents
1. EXCEL 2007 GETTING STARTED TODAY S DESTINATION Quick Access Toolbar Customize it Office Button gt Click Excel Options BREAK DOWN OF TABS amp RIBBON Contains Information relating to Contains the following groups Clipboard Fonts Alignment Most used functions in Excel ea Home Most used functions in Excel Number Styles Cells Editing Inserting objects in Excel Tables Illustrations Charts Links Spreadsheets Text How the data is displayed on the Themes Page Setup Scale to Fit Page Layouts page Sheet Options Arrange Calculations that use formulas and Function Library Defined Names functions Formula Auditing Calculation Inputting importing and analyzing Get External Data Connections data Sort amp Filter Data Tools Outline Proofing the document and Proofing Comments Changes collaboration through tracking Switching how worksheets and workbooks are viewed on screen working with Macros Workbook Views Show Hide Zoom Window Macros Basic Functions e Create a new workbook Open a file Save a file Print preview a file Prepare a file Send a file Publish a file Close a file Exit Excel Getting help Workbooks e Creating a new blank workbook e Opening a workbook e Saving a workbook Francine Vasilomanolakis 2010 Instructional Technology Specialist 310 660 3593 x6452 fvasilomanolakis elcamino edu Worksheets e Insert a worksheet e Rename a worksheet e2. Moving or copying a worksheet e Deleting a worksheet e Headers Footers e Color coding a worksheet tab e Applying styles to cells e Format numbers e Quickly adding a row or column of numbers e Auto fill columns or rows with data e Inserting cells rows or columns e Delete cells rows or columns e Merging cells e Insert a picture e Insert a chart e Using Zoom slider Formulas e Creating a formula e Using the Sum button CONVERTING FILES Excel 2007 has the capability to convert older versions of Excel to the 2007 format 1 This is done by opening an existing Excel document made in an older version 97 2003 2 Once the document is open click the Office Button and select Convert a This will automatically allow you to incorporate new features of Excel 2007 into older Word d ments wi into older Word docu gt E P SAVING FILES Excel 2007 contains very powerful saving capabilities not seen in prior versions Click on the Office Button then select Save to save in the current format or Save As to select a format V Excel Document Saves to the Excel 2007 format You will not Save a copy of the document lose any special features in the saving process Older versions of Excel RA Excel Workbook i Hl Save the file as an Excel Workbook cannot open this file unless they have downloaded the Excel converter patch a ie ee eed and v Excel Macro Enabled Workbook Save the workbook in the XML ee ix Excel B
3. the Merge amp Center button The Merge amp Center drop down ta Merge Cells ea Unmerge Cells kad Merge amp Center Merge amp Center f Merge Across menu also has options to Merge Cells without centering or Merge Across along rows only If you would like to unmerge merged cells select the cells to be unmerged and then select Unmerge Cells from the drop down menu HOME TAB CELLS GROUP The Insert button allows you to insert a new Cell Row Column or Worksheet m m SN E sg sj Pi Click on the drop down button to select from the options Inset Delete Format a NU vY ay E AutoSum AF amp Fin The Delete button allows you to delete Cell Row Column or Worksheet Click on the drop down button to select from the options i p Sort amp amp Clear Filter The Format button contains many options to apply to the worksheet These Cell Size formatting options are organized into categories Cell Size Visibility Organize O Row Height Sheets and Protection EREMO NE G Column Width The Cell Size category allows you to change Row Height and Column Width for AutoFit Column Width ae P Default Width selected rows or columns by entering a specific amount Row height is aaa P Visibility measured in points and Column Width in number of characters displayed To Hide amp Unhide gt have the rows or columns adjust automatically according to their contents use Organ
4. ction adds up the numbers from a range of cells divides it by the P RT number of cells in the range and shows that value into the cell where the function was inserted The Min and Max functions are used when you have a list of numbers and want to know the Minimum or Maximum number in that list Many times the median of a list is calculated by finding the minimum and maximum numbers and dividing them together to get the median The Count Numbers function is used to count the amount of numbers in a list This is not a sum it just returns the amount of cells in which number data is recorded PRINT AREA SETUP The Print Area button located in the Page Layout tab 3a e k p as 4 B Ee BFS te within the Page Setup group IS very useful for printing Margins Orientation Size Print Breaks Background Print specific data from a worksheet First select the range of tain oo cells you wish to print using the GP white plus sign selector then under Print Area select Set Print Area If the area which you selected is incorrect just select the Clear Print Area option and select a new print area through the steps described above Margins Orientation and Size offer the same features as those used throughout the Office 2007 Suite PLACES TO GO FOR HELP a Microsoft Excel 2007 User Manual htto www calstatela edu its docs pdf excel2007p1 pdf Tutorials from Microsoft Excel 2007 Training Courses Classroom Multimedia Tutorial for Excel 2007
5. htto classroommultimedia com cat 4 Where to get help e upper right hand corner Page 5
6. inary Workbook based and macro enabled file format 7 am Save the workbook in a binary file format optimized for fast loading and saving v Excel Binary Workbook Save the workbook in a binary file Fig Exce 97 2003 workbook Save a copy of the workbook that is fully format optimized for fast loading and saving compatible with Excel 97 2003 v Excel 97 2003 Saving in older versions allows for others to view ae IW Page 2 your documents if they don t have Excel 2007 Note Some new features in Excel 2007 don t save well in the 97 2003 formats SmartArt graphics don t render to older versions of Excel without creating blurred pixilated graphics HOME TAB ALIGNMENT GROUP The Alignment group allows you to align the contents of cells in many useful ways S p Wrap Text Basic alignment options are Top Middle and Bottom Align and can SF SF BH Merge amp Center be combined with Left Center and Right Align options This means i ee there are nine different locations inside the cell where data can be aligned The orientation of the text can also be manipulated by selecting button This means that the text can be rotated to a specific degree plane Note This is best used with text and not numbered data Merge amp Center options are used mainly for titles to allow the title to span the length of a few cells To Merge amp Center multiple cells select the cells for merging and click
7. ing cells you can then clear or delete the desired aspect of those cells The Sort amp Filter feature is very useful for organizing and filtering selected data Once the data has been entered into cells there are various ways to sort that data For z n example select number data and you can sort from the smallest to the largest GoTo number or the largest to smallest select text data and you can sort from A Z or Z A 2an Note If your data is already used in a chart and you then sort it the chart will also Comments adjust to reflect the changes Conditional Formatting Constants Data Validation Click the Filter option to enable filtering of selected cells Once filtering is turned on PSE click the arrow in the column header to choose a filter for the column YO Selection Pane The Find amp Select button contains many ways to locate specific data and formatting throughout the worksheet In addition to typing in text to Find or find and Replace you can also locate Formulas Comments and instances of Conditional Formatting by using the options in the Find amp Select feature BASIC FUNCTIONS IN EXCEL Page 4 There are five basic functions in Excel They are AutoSum Average Min Max E AutoSum and Count Numbers E Sum Average The AutoSum function adds up the numbers from a range of cells and places the Count Numbers sum of the numbers in the cell where the function was inserted Max Min The Average fun
8. ize Sheets Rename Sheet Move or Copy Sheet Tab Color b Protection Ajj Protect Sheet Lock Cell oF Format Cells the AutoFit functions Default Width changes default column width of the entire worksheet The Visibility category allows you to Hide amp Unhide selected rows columns or sheets The Organize Sheets category allows you to Rename a Sheet Move or Copy a Sheet and change the Tab Color of the sheet The Protection category allows you to protect the data in your worksheet from changes By selecting Protect Sheet you can determine what data you what to protect specifically Format Cells is another way to access the Format Cells dialog box which we ve already seen AutoSum aT J HOME TAB EDITING GROUP Fin r lt _f Clear Filter Sele The Editing group contains the options for AutoSum Fill Clear Sort amp Filter and Find amp Select The AutoSum function will be covered below in the Formulas Tab section of the 5 AutoSum i n training but know that it is also available here on the Home Tab within the Editing Ei sun group Average Count Numbers The Fill function allows cells to be filled four directions down right up and left To Max use this option select the cell with the desired data as well as the cells to be filled in Min in the desired direction naika a The Clear drop down menu gives the options to Clear All Clear Formats Clear Contents and Clear Comments After select
Download Pdf Manuals
Related Search