Searchlight Solutions

Understanding Microsoft Excel

Summary

Suitable for those looking to consolidate existing knowledge and enhance it with technical and useful functions and procedures within the Microsoft Excel platform.

Course Content

  • Existing Knowledge Refresh
  • Calculations and Percentages
  • Advanced Absolute Referencing
  • Conditional Formatting / Sparklines
  •  The IF Function Using Nested IFs
  • The SUMIF function for Analysis and Reconciliation
  • VLOOKUP in Detail for Range and Non-Range Lookups
  • External Cell Referencing and Linked Documents
  • Paste Special
  • Questions, Answers and Requests

Learning Objectives

  • Refresh and consolidate existing knowledge
  • Understand use of IFs, Nested IFs and SUMIF
  • Apply Conditional Formatting

 

Ready to book?

Simply complete the booking form with your details and a member of our team will be in touch with the next available dates. 

Any questions?  

If you’re not quite sure if this course is suitable or are looking for further information, call our team on 0117 244 7221.