Project Description

One of the most widely used programmes in the world for visualising and analysing data is Microsoft Excel. Within a practice this software can be used to track hours, finances, and invoices, and for data analysis, to visualise data, and innumerable other tasks.

By attending, delegates will learn how to save precious hours from their daily tasks.want to learn more, this web workshop is for you.

Whether you are brand new to the world of Excel or have limited knowledge and want to learn more, this web workshop is for you.

The MS Excel beginners web workshop will give you a full overview of all of the most common features of Excel and how to use them.

  • Duration: 1.5 hours

  • Location: Online

Who should attend?

Those needing to hone their Excel skills

Objectives

By the end of the web workshop delegates will have a better understanding of Excel and be able to:

  • Understand formulas and functions, such as IF, COUNTIF, SUMIF, VLOOKUP, HLOOKUP, and AVERAGEIF
  • Convert, sort, filter, and manage lists
  • Pivot tables
  • Create graphs and charts, and how to modify them
  • Use hyperlinks

Guidance notes and will be provided to support this web workshop and certificates of attendance are awarded after the workshop.

Workshop Agenda

Below is an outline of the proposed agenda and sample timings. If you have any questions please get in touch.

11.00 Introduction & Welcome 
11.05 Lookup functions and advanced Formulas

  • Using Named Ranges in Formulas
  • Naming a Single Cell
  • Naming a Range of Cells
  • Naming Multiple Single Cells Quickly
  • Vlookup and hlookup
  • Approximate and exact match
  • Index and match functions
  • Hyperlinks
11.40 Working with Lists

  • Converting a List to a Table
  • Removing Duplicates from a List
  • Sorting Data in a List
  • Filtering Data in a List
  • Adding Subtotals to a List
  • Grouping and Ungrouping Data in a List
12.00 Tables and Charts

  • Pivot Tables
  • Pie Charts
  • Doughnut Charts
  • Line Charts
  • Column Charts
  • Bar Charts
12.20 Summary – Q & A
12.30 Close
View our workshops

The PMA delivers a range of Workshops

If you would like information about workshop dates or would like to develop a specific programme or host this workshop, please call 0330 111 6459 or email enquiries@practicemanagersuk.org

View our workshops

Join Over 25,000 PMA members today and benefit from our services

As a PMA member, you will benefit from regular news and updates on key issues and regulatory changes that affect GP practices. You will gain access to exclusive training and events that ensure you maintain currency of knowledge and skills. You will have the opportunity to meet and network with your peers from around the UK.

Join PMA