An introduction to Microsoft Excel - Key Functionalities: Webinar

Who is this Webinar for?

This webinar is ideal for anyone who would like to learn the basics of using Microsoft excel for your business.

From conditional formatting to formulas, there is a wide range of key skills to learn within Excel to allow you to utilise it for key business activities, such as data reporting and viewing potential trends within your business activity.

Overview

You will have the opportunity to learn the key functionalities of using excel and how it can be useful for data gathering & reporting. Hosted by our partner Diego Morales Vela, during this webinar Diego will cover various aspects of using excel, including the following:

• Conditional formatting:

a. Highlighting specific values such as Top 10 % / Below Average

b. Data Bars / Icon Sets / Color Scales

c. User Defined Rules

d. Data Quality Assurance

• Pivot Tables

• Excel Tips:

a. Remove Duplicates

b. Text to Column

c. Groupings

• Absolute Vs Relative References (ARR)

• Formulas / Expressions in Excel:

a. Syntax

b. VLOOKUP()

c. SUMIF()

d. SUMIFS()

e. IF()

It is advised that having a computer with excel will be beneficial during this webinar to allow you to maximise your learnings from the event.

Your Host

This webinar will be hosted by Diego Morales Vela, an expert on Microsoft Excel, having 20 years of experience as well as providing training for around three years.

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.