Home - Microsoft Office Training Courses - Microsoft Excel 2010 Complete
Our Complete Microsoft Excel 2010 Training Course combines our Introduction to Microsoft Excel 2010 course, our Intermediate Microsoft Excel 2010 course, our Advanced Microsoft Excel 2010 course and our Expert 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.
In our advanced Microsoft Excel 2010 training course you will learn how to automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, troubleshoot errors, collaborate on worksheets, and share Excel data with other applications. You will learn how to create macros, audit and analyze worksheet data, incorporate multiple data sources, and import and export data. This course also includes details of how to enhance productivity and efficiency by streamlining your workflow, how to collaborate with other workbook users, work with multiple workbooks, import and export data, integrate Excel data with the web and how to structure workbooks with XML.
Our expert Microsoft Excel 2010 training course is ideal for those interested in the domain of finance, statistics, project analysis, and market analysis including the fields of micro- and macro-economics. You will learn how to manipulate data using statistical and lookup functions, analyze data using the data analysis tools, make investment decisions using the financial functions, examine data using math functions, manipulate data using text and information functions, create templates and work with Excel's advanced chart options and how to manage data in Excel workbooks. At the conclusion of this course you will be well on your way to attaining proficiency as an Excel power user.
Please note that the individual courses which comprise this course may be booked for separately - please see below for their individual course outlines.
Duration: 4 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).
Day #3 - Advanced Microsoft Excel 2010
- Streamlining Workflow
- Collaborating with Other Users
- Auditing Worksheets
- Analyzing Data
- Working with Multiple Workbooks
- Importing and Exporting Data
- Integrating Excel Data with the Web
- Structuring Workbooks with XML
Click here for more information regarding the Microsoft Excel training course (2010 Advanced).
Day #4 - Expert Microsoft Excel 2010
- Manipulating Data Using Statistical and Lookup Functions
- Analyzing Data Using Data Analysis Tools
- Working with Data Using Financial Functions
- Examining Data Using Math Functions
- Manipulating Data Using Text and Information Functions
- Working with Templates and Charts
- Managing Data in Workbooks
Click here for more information regarding the Microsoft Excel training course (2010 Expert).
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.
