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.
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.
| Introduction & Welcome |
Lookup functions and advanced Formulas
|
Working with Lists
|
Tables and Charts
|
| Summary – Q & A |
| Close |
