Microsoft Excel 2007 for Advanced Users

Course content:

Microsoft Excel is the world’s leading commercial spreadsheet software application. It has several features including calculation, graphical display tools, pivot tables and a macro programming language called Visual Basic for Applications. Microsoft Excel is part of the Microsoft Office suite of software applications and has become the standard spreadsheet software application in the UK.

The first version of Microsoft Excel was released in 1987 and since then several new versions have been released. Aspyra Training currently offers the following versions for the PC:

• Microsoft Excel 2003
• Microsoft Excel 2007
• Microsoft Excel 2010
• Microsoft Excel 2013

Microsoft estimates that more than 500 million people worldwide use the Microsoft Office suite every day, this makes it an essential tool for those who want to excel in an increasingly technological society. Participants attending Aspyra Training's Microsoft Office training courses will all receive the following training benefits:

• Microsoft Certified Training Courseware
• Certificate of Attendance
• Professional and Qualified Trainers
• Small Class Sizes
• Excellent IT Infrastructure
• Post Course Support
• Buffet Lunch

Microsoft Excel for Advanced Users will give you the skills to use advanced features of Microsoft Office Excel 2007. It is designed for experienced computer user. The training will ensure you can analyse data whilst increasing their proficiency as an Microsoft Excel 2007 user. Creating customer functions and modifying the data to really take advantage of the full Microsoft Excel 2007 package.

Upon completion the delegate will be able to:

• Record Macros to automate tasks
• Create & modify toolbars to run Macros
• Create & use Custom Excel functions
• Use Auditing Tools to check for errors in formulas
• Combine functions in formulas & create Nested IFs
• Use Protection to prevent accidental changes to formulas
• Use formulas to link data in separate Worksheets & Workbooks
• Use analysis tools such as Goal Seek & PivotTables to analyse data
• Import & export Excel data with other programs