Microsoft Excel Level 2

Microsoft Excel Level 2

Course Summary

Summary: Further analysis of your Excel data.

• Recap on level 1. Let's make sure we understand the basics.
• Collecting data from other sheets, workbooks or across the world.
• Keyboard shortcuts to make your life easier.
• IF! One of the most powerful functions you can use - explained and tested.
• Finding a solution to "what if". Goal seek.
• Formatting.....conditionally.
• Sorting, filtering and finding - the easy way.
• Subtotals - simple and effective.
• Microsoft's theory of relativity. One cell changes many.
• Charts for the real world.
• Feel free to ask. We like questions and we do our best to answer them.
• Keeping your work safe.

Group: Microsoft

Contents

Prerequisites Experience of using Excel up to our Introduction level

Duration 1 day

Course Objectives

Further analysis of your Excel data.

Course Content

• Recap on level 1. Let's make sure we understand the basics.
• Collecting data from other sheets, workbooks or across the world.
• Keyboard shortcuts to make your life easier.
• IF! One of the most powerful functions you can use - explained and tested.
• Finding a solution to "what if". Goal seek.
• Formatting.....conditionally.
• Sorting, filtering and finding - the easy way.
• Subtotals - simple and effective.
• Microsoft's theory of relativity. One cell changes many.
• Charts for the real world.
• Feel free to ask. We like questions and we do our best to answer them.
• Keeping your work safe.

Prerequisites

Attendance on our Excel Introduction course is strongly recommended.

Course: Microsoft Excel Level 1

Suggested Next Steps

Course: Microsoft Excel Level 3

Scheduled Dates and Fees

Start Dates Fee Notes
Thursday 23 July 2009 £145 (ex VAT)