Microsoft Excel 7 – Advanced

You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.

Who should attend?
This course is for participants looking to gain the skills necessary to create macros, collaborate with others, audit and analyse worksheet data, incorporate multiple data sources, and import and export data. In addition, the course will benefit participant preparing for the Microsoft Certified Application exam in Microsoft® Office Excel® 2007.

Prior knowledge
All participants are recommended to have attended the Beginners and Intermediate courses or have equivalent knowledge: Microsoft Office Excel 2007 Beginners, Microsoft Office Excel 2007 Intermediate.

Duration: 2 evenings
Cost:
£250
Book now!

Workshop Contents

• Before You Start
• Text to Columns
• Remove Duplicates
• Data Validation
• Consolidate Data
• What-if Analysis – Data Tables
• What-if Analysis – Scenarios
• What-if Analysis – Goal Seek
• Subtotals and Grouping
• Text Functions
• Lookup Functions
• Maths and Trig Functions
• Database Functions
• Auditing and Error Tracing
• Excel Tables
• Linking Data
• Getting External Data
• Pivot Tables and Pivot Charts
• Protecting and Sharing Worksheets and Workbooks
• Workbook Properties and Inspection
• Encrypting and Finalising Workbooks
• Digital Signatures
• An Introduction to Macros