DJL Training

Business & IT Training Services

 
Home Courses Services Locations Contact
 
 

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

 

 

 

Home / View Courses
Contact us at info@djltraining.co.uk
01276 474982