Home - Microsoft Office Training Courses - Microsoft Excel 2007 Complete
Our Complete Microsoft Excel 2007 Training Course combines our Introduction to Microsoft Excel 2007 course, our Intermediate Microsoft Excel 2007 course, our Advanced Microsoft Excel 2007 course and our Expert 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.
In our advanced Microsoft Excel 2007 training course you will learn how to extend your knowledge into some of the more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications. This includes how to increase productivity and improve efficiency by streamlining your workflow, collaborate with others using workbooks, audit worksheets, analyze data, work with multiple workbooks, import and export data, use Excel with the web and how to structure workbooks with XML.
In our expert Microsoft Excel 2007 training course you will learn how to forecast data using 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 the advanced chart options and manage data in Excel workbooks. Microsoft Excel has many tools and functions that help you in analyzing varied data to make decisions having large scale implications on profitability, be it in the domain of sales, project management, credit, equities, futures, options, currency, and so on. In this course, you will use the advanced features of Microsoft Excel 2007 to attain a high degree of 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 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).
Day #3 - Advanced Microsoft Excel 2007
- Streamlining Workflow
- Collaborating with Others
- Auditing Worksheets
- Analyzing Data
- Working with Multiple Workbooks
- Importing and Exporting Data
- Using Excel with the Web
- Structuring Workbooks with XML
Click here for more information regarding the Microsoft Excel training course (2007 Advanced).
Day #4 - Expert Microsoft Excel 2007
- 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 (2007 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.
