Microsoft Excel 1

Introduction

You need to understand how to use the basic functions of Microsoft Excel. You may have used Microsoft Excel in your job or be new to Microsoft Excel, but have never been given any formal training in setting up a spreadsheet, manipulating its data and editing its content.

This course will cover the basics relating to spreadsheets with an aim to improve your confidence when working with them. It will also include shortcuts that will enable you to achieve tasks quickly and efficiently with minimum effort. At the end of the course you will have your training manual, access to a copy of the training file created during the course, additional Excel training files to download from our website and a course certificate.

Course Aims

• To create and edit basic Microsoft® Office Excel 2007 worksheets and workbooks.
• To improve your confidence when using Microsoft Excel at this level. 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
• Learn useful shortcuts Content Get Started with Excel

• An Overview of Excel - Navigate in Excel
• Select Data - Enter Data
• Save a Workbook
• Obtain Help Modify 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 Perform Calculations
• Create basic formulas
• Calculate with functions
• copy formulas and functions
• Create an absolute and relative Reference
• Quick and easy calculation techniques Sort data
• Sort options
• Single column sort
• Multi column sort
• Question sorted data
• Things you don’t do Filter data
• Simple filter - Custom filter
• Top ten filter
• Filter by text , date, currency, number, colour
• Answer questions of filtered data Format a Worksheet
• Edit 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 Develop a Workbook
• Format worksheet tabs
• Reposition worksheets in a workbook
• Insert and delete worksheets
• Copy and paste worksheets
• Copy a workbook Print Workbook Contents
• Set a print title
• Create a header and footer
• Set page margins
• Change page orientation
• Print large and small data sets including charts
• Customize Layout
• Split a worksheet
• Arrange worksheets
• Freeze and unfreeze rows and columns
• Hide and unhide worksheets
• Create a simple Chart
• Shortcuts to charts
• Edit charts
• Update chart data
• Delete charts
• Link charts

Course Includes Lunch/refreshments, training manuals, training file created during the course, additional training files to practice with, certificate, post course support. Useful Microsoft Excel Information and Links

Testimonials Comment: The trainer was excellent at explaining everything and made complicated things seem simple enough for me to put into practice. [CS Serco] Comment: A most enjoyable course. The trainer was very knowledgable and approachable. Great to have a small class size. [SS Neuralt] Excel 1

• 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