Microsoft Excel Beginners Session

27th May 2023 @ 10:00

The Microsoft Excel Beginners session will be taking place on Saturday 27th May at 10-12pm, for AD Guild members. We will be joined by the tutor Clare Cato, and will be covering the following tasks.

Summary

1. Managing Workbooks/Worksheets

2. Formatting cells

3. Printing

4. Formulas: sum, count, average, time, date, left/right, vlookup, if, countif, now

5. Charts

6. Sorting Data

7. Find/replace

8. Paste special options

Preparations

1. Microsoft Excel which could be anything from Excel 2013 onwards or Office 365

2. 2 x screens (if available)

3. Zoom account

4. Access to the working document that will be used during the session (see below)

5. Please download the worksheet and open via Microsoft and Excel and not through Google Drive, as this automatically re-formats the spreadsheet

Working document

1. Please download the Beginners Working Document under the resources section of this event

How to Join?

Topic: Excel Lesson 1: Beginners Session

Time: May 27, 2023 10:00 London

Join Zoom Meeting https://us06web.zoom.us/j/89361555392pwd=dG16SmJyTnpMQXhNSGZlMkJOazhjZz09

Meeting ID: 893 6155 5392

Passcode: 538215

One tap mobile

+442039017895,,89361555392#,,,,*538215# United Kingdom

+442080806591,,89361555392#,,,,*538215# United Kingdom

Dial by your location

+44 203 901 7895 United Kingdom

+44 208 080 6591 United Kingdom

+44 208 080 6592 United Kingdom

+44 330 088 5830 United Kingdom

+44 131 460 1196 United Kingdom

+44 203 481 5237 United Kingdom

+44 203 481 5240 United Kingdom

Meeting ID: 893 6155 5392

Passcode: 538215

You must register your interest to this session in advance via admin@adguild.uk, as we are capped at 15-20 participants per session. This is to allow the tutor to engage adequately with the participants, and answer any questions along the way.

See you there!