Loading Events

Intermediate Microsoft Excel


  • This event has passed.

Course Details

This course is for anybody wanting to increase their knowledge in Microsoft Excel and looks at Microsoft 365 but also looks at previous versions, of 2016, 2013, 2010 or 2007, as it covers all the aspects and differences between the versions. It helps delegates improve their knowledge and skills to ensure that they are able to maximise the full use of MS Excel.

 

To ensure success, delegates should have completed our Basic Microsoft Excel course or are familiar with the topics in this course

Benefits to you

By the end of the course, participants will be able to:

  • Understand basic functions of Microsoft Excel

Course Contents

  • If statements
  • Conditional Formatting
  • Inserting Charts
  • The Insert Ribbon – Further Features
  • Linking Workbooks
  • Linking Excel with other applications
  • Creating Basic Macros
  • Data Validation
  • Custom Views
  • Working with large spreadsheets
  • Further Chart Effects
  • Hyperlinks
  • Text Box & Format Drawing Tools
  • Headers & Footers
  • Page Layout
  • Entering Basic Formulas
  • Hiding Cells & Data Protection
  • Relative Vs Absolute References

Who should attend?

Anybody wanting to learn intermediate Microsoft Excel functions

What's Included

Tuition

Course notes

Refreshments

Certificate of attendance