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, manipulting 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.

 

Target Student: This course is aimed at those wishing to gain a greater understanding of Microsoft Excel and improve confidence in its simple features.

 

Microsoft Excel Versions: Please let us know if you want your training on version 2003, 2007 or 2010. There are significant differences between versions so its important that we know at the time of booking.

 

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

 

 

Get Started with Excel - An Overview of Excel - Navigate in Excel - Select Data - Enter Data - Save a Workbook - 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 goto cell data

 

Perform Calculations - Create simple formulas - Copy formulas - Create a Relative Reference - Create an absolute Reference - Use quick and easy calculation techniques

 

Sort data - Sort options - Single column sort - Multi column sort - Questions - Things you shouldnt do 

 

Filter data - Simple filter - Custom filter - Filter by text , date, currency, number, colour - Questions

 

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

 

Edit 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

 

Shortcuts - Lots of relevant useful shortcuts

Course Includes: Lunch/refreshments, training manuals, Excel downloads, certificate, post course support.

 

Related Courses:
Microsoft Excel level 1 - Microsoft Excel level 2 - Microsoft Excel level 3
Microsoft Excel VBA level 1 - Microsoft Excel VBA level 2

 

Microsoft Excel Southampton