Home - Microsoft Office Training Courses - Microsoft Excel 2010 Essential
Our Essential Microsoft Excel 2010 Training Course combines our Introduction to Microsoft Excel 2010 course and our Intermediate Microsoft Excel 2010 course at a specially discounted price.
In our introduction to Microsoft Excel 2010 training course you will learn how to create basic worksheets by using Microsoft Excel 2010. This includes how to create a basic worksheet, perform calculations in an Excel worksheet, modify an Excel worksheet, modify the appearance of data within a worksheet, manage Excel workbooks and how to best print the contents of an Excel worksheet.
In our intermediate Microsoft Excel 2010 training course you will learn how to use advanced formulas and work with various tools to analyze data in spreadsheets. You will also organize table data, present data as charts, and enhance the look and appeal of workbooks by adding graphical objects. This course is ideal for those desiring to gain the advanced skill sets necessary for calculating data using functions and formulas, sorting and filtering data, using PivotTables and PivotCharts for analyzing data, and customizing workbooks. Also included are how to use advanced formulas, organize worksheet and table data using various techniques, create and modify charts, analyze data using PivotTables, Slicers, and PivotCharts, insert and modify graphic objects in a worksheet and how to customize and enhance workbooks and the Microsoft Excel environment itself.
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 2010
- Getting Started with Excel
- Performing Calculations in an Excel Worksheet
- Modifying a Worksheet
- Modifying the Appearance of a Worksheet
- Managing an Excel Workbook
- Printing Excel Workbooks
Click here for more information regarding the Microsoft Excel training course (2010 Introduction).
Day #2 - Intermediate Microsoft Excel 2010
- Calculating Data with Advanced Formulas
- Organizing Worksheet and Table Data
- Presenting Data Using Charts
- Analyzing Data Using PivotTables, Slicers, and PivotCharts
- Inserting Graphic Objects
- Customizing and Enhancing the Excel Environment
Click here for more information regarding the Microsoft Excel training course (2010 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.
