Quick Links to Popular Courses:

  Project Management

  Excel

  Microsoft Office 2007 upgrade

  Microsoft Project

  Time Management

  Word

More Courses...

Contact us - by email at:

info@djltraining.co.uk

Microsoft Excel

Microsoft Excel is a data manipulation package. You can hold large or small amounts of data in many different ways. It enables you to:

• Work with lists
• Produce charts/graphs
• Use calculations and functions

The different levels of training are listed below and the topics can be mixed and matched to suit your specific requirements.

Excel Fundamentals - Level 1 (1 day)

• Understand how to work with Excel
• Enter, edit and delete data
• Select data
• Format your spreadsheets
• Apply calculations to data
• Print your worksheet

Click here to view course outline

Excel Fundamentals - Level 2 (1 day)

• Understand and use range names
• Use Statistical functions
• Work with large spreadsheets and multiple workbooks
• Link data
• Utilise the database and filtering features
• Add and remove subtotals
• Create, format and modify charts/graphs

Click here to view course outline

Excel Advanced - Level 3 (1 day)

• Extend your knowledge of functions (using IF and VLookup)
• Protect your data
• Use the error checking features
• Create PivotTables
• Use the analysis features within Excel
• Import and export data

Excel Advanced - Level 4 (1 day)

• Create and use templates and styles
• Share your workbook
• Track any changes
• Automate your work with macros
• Use Data Tables
• Excel options
• Customise the menu and toolbars