Excel for Beginners

Wednesday, 15 December 2021 10:00 AM - 12:00 PM [WET]

Register Now

1. Select Seats

2. Review and Proceed

Registration

1 Ticket Partial Approval - Free

Sales end on 15/12/2021

Enter your discount code

  • Fee
  • Total amount

Wednesday, 15 December 2021 10:00 AM - 12:00 PM [WET]

Introduction

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.

 

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.

 

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

 

v  Calculate sums, averages, and totals

v  Counting cells

v  Insert, edit, and delete comments

v  Create borders

v  Wrap text

v  Merge cells

v  Paste, sort, and convert columns to rows

 

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

 

Programme

Introduction & Welcome

 

Introduction to Excel

 

·         Finding our way around Excel

·         Open, save, create a new sheet, tabs

·         Calculating: Add, Multiply, Subtract, Divide

·         How to:

o   Sort

o   Percentage

o   Running totals

o   Print

o   Paste Special

o   Merge

o   Filter

o   Average

 

Data formatting

 

·         Formatting numbers

·         Formatting dates

·         Conditional formatting

 

Cells and name ranges

 

·         Creating name ranges for data

·         Using name ranges for values calculations

·         Updating name ranges

·         Editing name ranges

 

Summary and Q&As

Close

 

Frankie Maclean