Microsoft Excel Intermediate Session

28th May 2023 @ 10:00

The Microsoft Excel Intermediate session will be taking place on Sunday 28th 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. GoTo

2. Pivot Tables

3. Formulas: Range, Rank, SumIf, Round

4. Drop down lists

5. Conditional Formatting

6. Idea button

7. Sparklines

8. Text to Column

9. Analysis tool

10. Advanced charts

11. Advanced formulas

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 Intermediate Working Document under the resources section of this event

How to Join?

AD Guild UK is inviting you to a scheduled Zoom meeting.

Topic: Excel Lesson 2: Intermediate Session

Time: May 28, 2023 10:00 London

Join Zoom Meeting

https://us06web.zoom.us/j/82530153352?pwd=eXdLa2tGeXdLa2tGdFR5ZHg1Y3luTnBFK3VrQT09

Meeting ID: 825 3015 3352

Passcode: 052325

One tap mobile

+442080806591,,82530153352#,,,,*052325# United Kingdom

+442080806592,,82530153352#,,,,*052325# United Kingdom

Dial by your location

+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

+44 203 901 7895 United Kingdom

Meeting ID: 825 3015 3352

Passcode: 052325

Find your local number: /u/kd5iEEUBjV

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!