WHO'S IT FOR?

Pre-requisites

    • PC or Mac with the full version of Microsoft Excel (any version from 2007 onwards but most suited to PC version 2013/2016 or Office 365).

    • A basic knowledge of Excel's structure, layout and ribbons.

    • Not a requirement but a benefit to have at least a basic working knowledge of Excel commands and functionality.

Relevant audiences

    • Anyone who needs to make sense of large amounts of data.

    • Accountants, bookkeepers, marketing professionals, salespeople - anyone who wants to learn the tools, techniques and most useful formulas for analysing data.

Learning outcomes

    • Clean raw data in order to prepare it for a PivotTable.

    • Build a PivotTable from scratch and use it to perform deep analysis on your data, including creating visually appealing PivotCharts.

    • Utilise helpful lookup functions to lookup a value in one column and return the value in another.

    • Perform logical tests using IF Statements.

    • Create Conditional Formatting rules to highlight data based on specific criteria in order to quickly visualise data in a spreadsheet.

    • Build an interactive dashboard to display information in a visual way and make it easy to analyse for others using interactive tools.


ABOUT THE AUTHOR 

Deborah Ashby 1

Deborah Ashby

Deborah Ashby is an IT Trainer and has been in the IT Industry for 22 years during which time she has provided a wide range of training services to professionals of all levels. Deborah has worked across various sectors such as the travel, property investment and legal. Her expertise lies in all the main Microsoft applications and she's been running hands-on classroom training sessions, webinars, seminars and workshops for 10 years. She is able to take complex subjects and communicate them clearly and concisely and sometimes even 'make technology fun' for a wide range of mixed ability learners.

Deborah holds a MOS (Microsoft Office Specialist) Master Certification and five TAP (Trainer Assessment Program) Certifications. She is COLF Certified and a Member of the British Institute of Learning and Development.

 


REVIEWS 

"Learning and development had not been created as a continuous activity. Training was often one off interventions with the impact difficult to measure. Filtered has helped us change that in a short period of time. The cultural change it has driven in terms of reinforcing an expectation of continuous learning at all levels is the biggest achievement to me."  

KayBoycott.png

Kay Boycott | Chief Executive, Asthma UK 

Something powerful

Tell the reader more

The headline and subheader tell us what you're offering and the form header closes the deal. Over here you can explain why your offer is so great that it's worth filling out a form for.

Remember:

  • Bullets are great
  • For spelling out benefits and
  • Turning visitors into leads.

Something powerful

Tell the reader more

The headline and subheader tell us what you're offering and the form header closes the deal. Over here you can explain why your offer is so great that it's worth filling out a form for.

Remember:

  • Bullets are great
  • For spelling out benefits and
  • Turning visitors into leads.

Something powerful

Tell the reader more

The headline and subheader tell us what you're offering and the form header closes the deal. Over here you can explain why your offer is so great that it's worth filling out a form for.

Remember:

  • Bullets are great
  • For spelling out benefits and
  • Turning visitors into leads.
  • The user dashboard: shows key usage stats for the learner such as modules completed, time spent, scores.
  • The filter: series of profile, aspiration and knowledge-level questions to personalise your learning experience.
  • The course: a balanced mix of text, video, downloadable exercises and responsive imagery.
  • Management dashboard: managers can view a summary of staff engagement and review individual staff progress in a single place.
  • Certificates: there are two certificates. One is a log of all modules completed, the other a summary of test scores.

COURSE SYLLABUS

There is currently no public syllabus for this course.