Welcome to the e-Learning Microsoft Excel 2007 Advanced course powered by XYZ.co.uk. Classroom versions of this course are also available. If you would like us to host a e-Learning Microsoft Excel 2007 Advanced course at your premises, at a location, date and time of your choosing – then please complete this form.

e-Learning Microsoft Excel 2007 Advanced

At eLearning.co.uk all of our courses are delivered online. This gives you the opportunity to study at your own pace and within your own time. Online learning allows you to study in the evenings, weekends, or even the odd hour during the day! With each course you will have full tutor and technical support available via the telephone and by e-mail – so you are not on your own by any means. This e-Learning Microsoft Excel 2007 Advanced course will award you with the same certification as the classroom version of this course – usually for a cheaper cost and with the additional benefit of flexible study times!

Once you’ve decided to go ahead and enrol on this e-Learning Microsoft Excel 2007 Advanced course, you will receive an e-mail shortly after containing your user name and password, receipt of payment and full course joining instructions. Use this with the link/url provided in the e-mail and you can log into the online training system and begin learning right away. This e-Learning Microsoft Excel 2007 Advanced online learning course will use various interactive features and different types of media to enable you to stay engaged whilst learning. The course has been designed to be simple to follow and solely with the user in mind – so don’t worry about the technical side of things.

If you want to learn a little more about e-Learning in general, watch the video below. If you want to know more about your chosen course, please scroll down.

The Excel 2007 Advanced training teaches you how to apply filters, use formulas and analyse data.

You will be able to apply your knowledge to create complex business applications and analyses in Microsoft Excel. This interactive home study course is accessed online and is designed to enable you to fully master all advanced elements of Excel 2007.

About the course

Filtering and Sorting Data – Duration 2 Hour(s)

This course provides information on how to filter and sort your worksheets in Excel 2007. Remove duplicate records from an Excel worksheet Apply filters to an Excel worksheet Apply one-click, multiple-level, and custom sorts to your data

PivotTables, PivotCharts, and Graphs – Duration 2 Hour(s)

Create pivot tables Modify pivot tables Use pivot tables to quickly and easily Analyse complex data sets Apply pivot tables for common uses

Working with Functions – Duration 3 Hour(s)

Calculate results with math functions Use date and time functions Adjust text with functions Work with logic and information functions Use lookup functions to locate data Determine payments with financial functions Use statistical functions to determine relationships

Using Data Analysis Tools – Duration 1 Hour(s)

Use What-If analysis in Excel 2007 Create analyses with Scenario Manager Analyse data using Goal Seek Install Solver

Automating with VBA Macros – Duration 2 Hour(s)

Enable the Developer tab on the Ribbon Modify macro security settings Record and run macros Record a macro that uses an advanced filter Customize macros for everyday use Combine elements of written code with recorded code

Adding Connections and Importing Data – Duration 3 Hour(s)

This course provides detail about connecting worksheets and workbooks for automatic sharing and updating. It also provides detail about importing information from the Web, text files, XML data, Access documents, and other files from external data sources.

Course study options

Course Study Format
This course is delivered through online method. The course is available for you to complete at your convenience over a 12 month period.

IT Training Course Tutor Support
Home study courses include step by step online training and keyword search facilities.
Our Interactive online IT Training courses will take you step by step though your chosen eLearning courseware using show and ask training methods.

Study Hours
This is only an approximate figure and is dependent upon how much time you can dedicate to your studies and how well you grasp the learning concepts in the course material.

Technical Requirements

• Windows: Windows 98, 2000, XP, Vista, Windows 7 – Acrobat Reader 4.0 and above
  OR
  Macintosh: Mac OS X, Mac OS 9.2 – Acrobat Reader 4.0 and above
• An up to date internet browser such as Internet Explorer, Mozilla Firefox, or Safari.
• Internet connection (broadband recommended.)

Cost - Per Person

Make An Enquiry Or Book This Training Here