Microsoft Excel

MS Excel

At Motiv8 Development we know that one size doesn’t fit all. Our I.T. training can be tailored to meet your specific requirements. Courses can be ‘pick and mixed’ to suit your individual needs and we also cater for most of the versions of software currently in use.

Training can be delivered at your site or venue near to you and we can train individuals or groups up to five people. We keep group sizes small so we can provide the individual support participants require to maximise the outputs and benefits of the training. If required, we can even supply the PC's for the training.

Outlines of the different levels of training offered are detailed below. However, contact us to discuss your specific needs.

 


 

Level 1 - Duration: 1/2 day

This ½ day session is aimed at new users of Excel.

 

Pre-requisites

It is assumed that the delegate will have a knowledge of the Windows environment. They may have but do not require some knowledge of Excel.

 

Topics Covered

  • Simple formulas
  • Basic functions
  • Copying / duplicating formulas
  • Using AutoFormat 
  • Sorting lists
  • Filtering data
  • Creating subtotal lists
  • Keyboard shortcuts

 


 

Level 2 - Duration: 1/2 day

This ½ day session is aimed at existing users of Excel who would like to enhance their knowledge and find short cuts or better ways of working, getting more use from formulas to help analyse data.

 

Pre-requisites

It is assumed that delegates will have a knowledge of the Windows environment and some knowledge of Microsoft Excel

 

Topics Covered

  • Scrolling screen headings
  • Printing your workbook
  • Headers and footers
  • Working with percentages 
  • Absolute and relative references
  • Naming cells and ranges
  • Basic graphs
  • Counting functions
  • Basic analysis of large tables



 

Level 3 - Duration: 1/2 day

This ½ day session is aimed at existing users of Excel who would like to extend their knowledge of the formulas available to them in Excel so that they can begin to work with data tables, summary sheets and graphs.

 

Pre-requisites

It is assumed that delegates will have a knowledge of the Windows environment and a basic grounding in Excel with some understanding of formulas.

 

Topics Covered

  • Working with IF functions
  • Using VLOOKUP and HLOOKUP to access data from large tables
  • Creating drop down lists
  • Colour coding with conditional formatting
  • Summarising data tables (subtotals)
  • Creating charts and graphs
  • Adding trend lines to charts
  • Protecting worksheets form accidental data entry

 


 

Level 4 - Duration: 1/2 day

This ½ day session is aimed at existing users of Excel who would like to extend their knowledge with the features available to them when working with large amounts of data and multiple worksheets or books.

 

Pre-requisites

It is assumed that delegates will have a knowledge of the Windows environment and some understanding of formulas.

 

Topics Covered

  • Analysing large amounts of data
  • Pivot Tables
  • Creating Scenarios
  • Creating scenario reports 
  • Using data forms
  • Linking workbooks
  • Editing multiple worksheets

 


 

Level 5 - Duration: 1/2 day

This ½ day session is aimed at advanced users of Excel who would like to extend their knowledge of the features available to them when working with large amounts of data, possibly from other sources such as Access databases or working with spreadsheets that are used or populated by others.

 

Pre-requisites

It is assumed that delegates have a knowledge of the Windows environment and a good understanding of Microsoft Excel.

 

Topics Covered

  • Setting data validation
  • Cell properties
  • Tracking changes to workbooks
  • Creating warning messages for wrong data entry 
  • Importing data from Access
  • Importing from Text or CSV files
  • Querying data from other sources
  • Text editing formula (for splitting names and addresses etc.)

 


 

Level 6 - Duration: 1/2 day

This ½ day session is aimed at existing users of Excel who would like to automate tasks such as standard formatting of reports and importing data from other sources by using macros. This introduction to macros looks at recording and editing macros.

 

Pre-requisites

It is assumed that the delegate will have a knowledge of the Windows environment and of Microsoft Excel.

 

Topics Covered

  • Recording a macro
  • Where to store macros
  • Using the VBA editor
  • Getting to grips with the code 
  • Creating a form
  • Form buttons
  • Assigning macros to buttons