Microsoft Excel 1

Microsoft Excel 1

The trainer was excellent at explaining everything and made complicated things seem simple enough for me to put into practice. [CS Serco]    

Course Objectives By the end of this level you will be able to:

 

• Create a basic worksheet
• Modify a worksheet and its simple formulas
• Create and Edit simple formulas [Sum, Min, Max and Average]
• Format the data, cells and sheet
• Sort a list of data and answer more complex questions of that data
• Filter a list of data and answer more complex questions of that data
• Create and edit a simple vertical bar chart
• Print the contents of a workbook
  
    Content Getting Started with Excel - An Overview of Excel - Navigate in Excel - Select Data - Enter Data - Save a Workbook - Obtain Help  
  
   
• Modifying a Worksheet - Move and Copy Data Between Cells - Fill Cells with Series of Data - Edit Cell Data - Insert and Delete Cells, Columns, and Rows - Find, Replace, and Go - to Cell Data - Spell Check a Worksheet   Performing Calculations - Create Basic Formulas - Calculate with Functions Copy Formulas and Functions - Create an Absolute Reference  
  
   
• Formatting a Worksheet - Change Font Size and Type - Add Borders and Colour to Cells - Change Column Width and Row Height - Merge Cells - Apply Number Formats - Create a Custom Number Format - Align Cell Contents - Find and Replace Formats - Apply an AutoFormat - Apply Styles   
• Developing a Workbook - Format Worksheet Tabs - Reposition Worksheets in a Workbook - Insert and Delete Worksheets - Copy and Paste Worksheets Copy a Workbook   
• Printing Workbook Contents - Set a Print Title - Create a Header and a Footer - Set Page Margins - Change Page Orientation - Insert and Remove Page Breaks - Print a Range  
  
   
• Customizing Layout - Split a Worksheet - Arrange Worksheets - Freeze and Unfreeze Rows and Columns - Hide and Unhide Worksheets