Microsoft Excel Intermediate Training in the North East

Microsoft Excel Level 2

This course will enable delegates to streamline repetitive tasks and display spreadsheet data in more visually effective ways. Delegates will use Excel to streamline and enhance spreadsheets with templates, charts, graphics, and formulas.

Our Training

Below are a list of Excel course outlines. To ensure you get exactly what you want out of your Microsoft Excel training in the North East, you can choose to have a course based directly on an Excel outline, or you can customise an Excel course outline to fit your organisation's specific requirements. Please click on the link to view the outline.

Excel Courses for 97, 2000, XP, 2003  Excel Level 1 (Introduction)  Excel Level 2 (Intermediate)  Excel Level 3 (Advanced)  Excel VBA  Excel Pivot Tables

Excel Courses for 2007  Excel Level 1 (Introduction)  Excel Level 2(Intermediate)  Excel Level 3 (Advanced)  Excel VBA  Excel Pivot Tables

Our public scheduled, tutor-led courses take place at our training venues in the Newcastle-Upon-Tyne and Washington. If these locations are not convenient, you can choose to have a private course at your site or at a convenient location in the North East and throughout the UK.

After attending the Microsoft Excel Level 2 course delegates will be able to:

• Test a value in a specific cell to see if it meets a certain condition, Display a warning in a cell if the data does not meet the required criteria.
• Filter a spreadsheet to show only the records that meet a specific criteria (i.e. All surnames beginning with A)
• Create a summary sheet that will calculate the total for a range of sheets, without duplicating the data(i.e. Maybe an expenses sheet that takes the monthly totals and displays them on a summary sheet)
• Display data in various graphical formats that can be easily understood by anyone not using Excel.