An introduction to Microsoft Excel - Key functionalities

Who is this Webinar for?

This engaging and informative webinar is designed for individuals eager to develop their understanding of Microsoft Excel and its practical applications in a business context. Whether you are a newcomer to Excel or want to refresh your skills, this session will provide valuable insights. You will learn various essential techniques, from applying conditional formatting to crafting complex formulas, all aimed at helping you streamline essential business activities like data reporting and spotting potential trends within your operations.

Overview

Join us for an exciting opportunity to delve into the powerful functionalities of Excel and discover how it can enhance your data gathering and reporting capabilities. Our esteemed partner, Diego Morales Vela, will lead the session expertly. With his extensive knowledge and experience, Diego will guide you through a range of essential topics, including:

1. Conditional formatting:

Learn how to make your data visually striking by highlighting specific values, such as the Top 10% or Below Average. Diego will introduce you to various formatting techniques, including Data Bars, Icon Sets, and Colour Scales. He will also show you how to create User-Defined Rules for tailored data presentations. You will also explore strategies for ensuring Data Quality Assurance.

1. Pivot Tables:

Discover the power of Pivot Tables to summarise and analyse extensive data sets easily. You'll learn to create dynamic reports that can provide invaluable insights into your business metrics.

1. Excel Tips:

Elevate your Excel skills with essential tips for everyday use. Learn how to clean your data by Removing Duplicates, quickly organise your information with text-to-columns, and effectively manage data with Groupings.a. Remove Duplicates

1. Absolute Vs Relative References (ARR):

Gain a clear understanding of the differences between Absolute and Relative References, significantly enhancing your formula-writing skills and overall data management.

1. Formulas / Expressions in Excel:

Dive into the world of Excel formulas. Diego will break down the fundamental Syntax and introduce you to essential functions, including VLOOKUP(), SUMIF(), SUMIFS(), and IF(), equipping you with the tools to perform complex calculations with confidence.

We highly recommend installing Microsoft Excel on a computer to maximise your learning experience during this interactive webinar.

Your Host

Diego Morales Vela, a highly experienced expert in Microsoft Excel, will facilitate this webinar. With over 20 years of practical experience in the field and three years dedicated to training others, Diego is well-equipped to provide insightful guidance and answer your questions throughout the session.

Please note: The webinar may be recorded, however, having your Camera and microphone on is optional.

Data Collecting:

Information collected here will be processed by Wenta and shared with our programme partners such as Hertfordshire LEP, Watford Borough Council, Stevenage Borough Council and Ministry of Housing, Communities and Local Government for programme data reporting purposes only. Data that is collected here will be used to provide further business advice and support information to you. Please visit Wenta’s Privacy Policy for more information.

If you do not wish for your data to be used for marketing purposes such as the Wenta Mailing List, please ensure you do not select the relevant box for the Mailing List ‘opt-in’.

Data Sharing:

We have data sharing arrangements in place with programme and contract partners such as Hertfordshire LEP, Watford Borough Council, Stevenage Borough Council and Ministry of Housing, Communities and Local Government, who we work with to provide certain services to you. Under data sharing arrangements, certain personal information is shared for a specific purpose. The local authority or organisation receiving the information must only use that information to carry out that specific purpose, and keep your data safe and secure. Please visit Wenta’s Privacy Policy for more information.