Upgrade to Excel 2007
1 Day Course

This course is designed for delegates that feel confident in Excel but needs to adjust to the new 2007 interface. At the end of the course the learner will feel confident in using 2007 and understand where they can look for help as well as having learned some extremely useful time saving techniques.  During the course the learner will practice their skills with skill reviews and exercises. An evidence of learning form will be completed during the course and verified by the trainer. This can be used to prove competency in the areas covered by the learner. A certificate of completion will also be issued.

• Getting Help in 2007
• Saving your Files
• Using the View Ribbon
• Printing your Workbook
• The New Interface
• The Quick Access Toolbar
• The Home Ribbon
• The Insert Ribbon
• The Page Layout Ribbon
• The Formulas Ribbon
• The Data Ribbon
• The Page Layout Ribbon
• Using Templates in 2007
• Using Formulas in Excel
• Customizing your Workbook
• Finishing your Workbook
• Working with Charts
• PivotTables
• Using Excel with other Programs and Files
• Excel and Office Servers
• Add-ins and the Trust Centre

Microsoft Excel Level 1
1 or 2 day course depending on experience and requirements.

This course is designed for anyone new to Excel as well as people who are using Excel but are struggling to understand or change existing spreadsheets. At the end of the course the learner will be able to produce professional spreadsheets, containing formulas and charts.  During the course the learner will practice their skills with skill reviews and exercises. An evidence of learning form will be completed during the course and verified by the trainer. This can be used to prove competency in the areas covered by the learner. A certificate of completion will also be issued.

• An introduction to Microsoft Excel
• Understanding the spreadsheet screen
• Exploring each of the Ribbons available
• Moving around worksheets
• Building a simple worksheet
• Adding new columns and rows to a spreadsheet
• Understanding and creating simple formula
• Printing and print preview
• Formatting a spreadsheet including: wrapping text and auto fit
• Adding, copying, displaying and renaming worksheets
• Understanding and working with workbooks
• Changing worksheet views and inserting page breaks
• Using the zoom control
• Creating a chart using the chart wizard
• Improving efficiency: Understand and amend existing charts
• An introduction to more complex formulas including vat calculations

Microsoft Excel Level Two
1 or 2 day course depending on experience and requirements.

This course is designed for delegates who already have a thorough understanding of the subjects covered in Level one. They should have a good understanding of formulas, charts and spreadsheet layout.  During the course the learner will practice their skills with skill reviews and exercises. An evidence of learning form will be completed during the course and verified by the trainer. This can be used to prove competency in the areas covered by the learner. A certificate of completion will also be issued.

• Filters and Advanced Filters
• Lookup and Match Functions
• VLookup and HLookup
• Custom Lists
• Absolute and Relative Cell References
• Sort, Find and Replace
• Workbook Protection
• Date and Time Functions
• The Concatenate Function
• Financial and What If? Functions
• Conditional Formatting
• PivotTables and Pivot Charts
• Scenarios
• Subtotals
• Macros
• What is Visual Basic?
• Formula Auditing and Validation
• Goal Seek
• Data Maps

« Back