Understanding MS Excel - Intermediate

synergy-corporate-consulting-excel-course-inter

2 day intensive course

Understanding MS Excel - Intermediate

What is it about?

This programme will help you to unlock the full potential of one of the most powerful business tools at your disposal – helping you to stand out from your colleagues, improving the quality of your analysis and decisions and assisting in your own professional development.
MS Excel is a powerful business tool that should be used by every person in an organisation to store, analyse and present data in order to make better business and managerial decisions. Most people don’t even scratch the surface of the use of MS Excel. This course ensures you become more productive and self-reliant by mastering the world’s most popular productivity tool!
Our 3 modules will help grow your knowledge of the programme exponentially, introducing you to new ways of using the programme and teaching you the skills needed to organise, calculate, evaluate and find data quickly and efficiently. You will cover correct ways to set up and link spreadsheets and discover how to use “built” in specialist capabilities such as Macros, Data Analyses and Data Validation tools that we all know exist, but don’t really know how to effectively use.

Who is it for?

A 2 programme that is a must for all users.

synergy-corporate-consulting-excel-course-02

Content

TOOLS

  • Data rules and preparation
  • Data consolidation
  • Customising your Excel screen
  • Multiple Views
  • Working with Multiple Workbooks and worksheets
  • Conditional formatting
  • Sorting Data
  • Filtering
  • Subtotalling
  • Data Validation
  • Hyperlinks
  • Charts – Creating and effectively using
  • What if Analysis and forecasts
  • Macros
  • Formula
  • Formula Auditing
  • Basic absolute referencing
  • Functions
  • Sum Function
  • Max, Min and Average Function
  • Count Function
  • Database Functions
  • Text Functions
  • Data Tools

OBJECTIVES

  • Understanding layouts and data rules
  • Collection of data
  • Working smart within the screen
  • Understanding of how to utilise the MS Excel screen
  • Working across and within multiple Workbooks
  • Analytic tool for Excel
  • Effectively sort data
  • Alternate ways to search data
  • Creating subtotal summaries
  • Securing only data required
  • Linking between sheets, workbooks and more
  • Graphical representation of Data
  • Calculation alternatives
  • Automating your spreadsheets
  • Excel calculations
  • Error determination
  • Calculation rule
  • Excel instructions
  • Calculation Instruction
  • Calculation Instructions
  • Calculation Instruction
  • Additional functionality
  • Text Instructions
  • Additional tools to save time in Excel