Home - Microsoft Office Training Courses - Microsoft Excel 2007 Essential
Our Essential Microsoft Excel 2007 Training Course combines our Introduction to Microsoft Excel 2007 course and our Intermediate Microsoft Excel 2007 course at a specially discounted price.
In our introduction to Microsoft Excel 2007 training course you will learn how to create and edit basic Microsoft Excel 2007 worksheets and workbooks and therefore gain the skills necessary to create, edit, format, and print basic Microsoft Excel 2007 worksheets. This includes how to explore the Microsoft Excel 2007 environment and create a basic worksheet, perform calculations, modify a worksheet, format a worksheet, print workbook contents and how to manage large workbooks.
In our intermediate Microsoft Excel 2007 training course you will learn how to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use Microsoft Excel 2007 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas as well as to apply visual elements and advanced formulas to a worksheet to display data in various formats. You will also learn how to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the web. This includes how to calculate with advanced formulas, organize worksheet and table data using various techniques, create and modify charts, analyze data using PivotTables and PivotCharts, insert graphic objects and how to customize and enhance workbooks and the Microsoft Excel environment.
Please note that the individual courses which comprise this course may be booked for separately - please see below for their individual course outlines.
Duration: 2 days.
Location: 21st Century New Media Ltd, Elstree Film Studios, Shenley Road, Borehamwood, Hertfordshire, WD6 1JG. [Click here for a map]
Times: 10.00am to 4.30pm. For security reasons, further details are only provided upon booking.
Equipment: Our fully featured training room includes six top-of-the-range iMac computers configured to work in both Macintosh (OSX) and PC (Windows) modes, ensuring you the maximum familiarity with your chosen operating system.
Accommodation: Details of local accomodation can be found here.
Further assistance: Our FAQ help page contains the answers to many popular questions. Alternatively please call 0844 844 2428 to arrange to speak to our training manager.
COURSE CONTENT
Day #1 - An introduction to Microsoft Excel 2007
- Creating a Basic Worksheet
- Performing Calculations
- Modifying a Worksheet
- Formatting a Worksheet
- Printing Workbook Contents
- Managing Large Workbooks
Click here for more information regarding the Microsoft Excel training course (2007 Introduction).
Day #2 - Intermediate Microsoft Excel 2007
- Calculating Data with Advanced Formulas
- Organizing Worksheet and Table Data
- Presenting Data Using Charts
- Analyzing Data Using PivotTables and PivotCharts
- Inserting Graphic Objects
- Customizing and Enhancing Workbooks and the Excel Environment
Click here for more information regarding the Microsoft Excel training course (2007 Intermediate).
5-15% discount if you book for more than one delegate!
Further discounts are available when booking multiple courses,
Please call our training secretary on 0844 844 2428.
Further discounts are available when booking multiple courses,
Please call our training secretary on 0844 844 2428.
