Excel Bootcamp
22

Friday, 22 February

10 am – 5 pm GMT

GA London, The Relay Building

1st Floor, 114 Whitechapel High Street
London
£100 GBP
Regular Ticket
£100 GBP
Total

Questions? Read our FAQs

Excel Bootcamp

Waseem Ali Photo


Co-founder & Director, Cloudstream Partners

22

Friday, 22 February

10 am – 5 pm GMT

GA London, The Relay Building

1st Floor, 114 Whitechapel High Street
London
£100 GBP
Regular Ticket
£100 GBP
Total

Questions? Read our FAQs

About This Workshop

For most professionals, the ability to organise information is quickly becoming a fundamental part of the job description. Whether you already consider yourself an expert or are just getting started with spreadsheets, this hands-on workshop will allow you to take your skills to next level and become an Excel pro.

We’ll start with the absolute basics, and move on to lesser known shortcuts, functions, features that you will be able to immediately put to use on the job.


Part One: A Practical Introduction

After a basic introduction to Excel itself, we’ll be using a dataset to take you through a process of turning raw data into useful information, and introducing you to some tools and functions along the way. Specifically, we’ll walk you through:

  • Getting to know your data: Filters, Freeze Panes, Pivot Tables
  • Cleaning your data: Text Functions (LEFT, RIGHT, SEARCH)
  • Presenting your data: Formatting, Absolute/Relative References, SUMIF, Simple Charting


Part Two: Beyond the Basics

In this part we will move beyond the basics of spreadsheet creation. Topics will include data manipulation/troubleshooting and advanced functions to summarize and analyze data having multiple attributes.

  • Using some more advanced functions with your datasets
  • How to use / combine multiple spreadsheets
  • VLOOKUP + Conditional Formatting
  • How to build charts to effectively visually present information

Students must bring a laptop with Microsoft Excel pre-installed (Mac or PC).

Preparation

Students should have a general familiarity with Excel, including knowing how to navigate a spreadsheet, and how to copy & paste.

Please bring a laptop with Microsoft Office installed either on PC or Mac. Note that while there may be differences in how Microsoft show certain functions in their menus across the different versions, all functions referred to in the course should be available no matter which version you are using.

The instructor will be using a Mac, running Office for Mac 2011. Students will be emailed case study files prior to class that they should download to their laptop. This is an interactive class, and your participation and questions are encouraged.

About the Instructor

Waseem Ali Photo

Co-founder & Director,
Cloudstream Partners

Waseem is a statistician by background and from this, has a true passion of using data and statistics to support businesses’ in decision-making. His career to date includes analytics positions at the NHS, Capita and Virgin Care, where he was responsible for their entire analytics function, He also teaches the Data Analytics part-time course at GA as well as a range of workshops.

Refund Policy

We understand that, sometimes, plans change. If you can no longer make it to a class or workshop, please email us at least 7 days before the scheduled event date. No refunds will be given to cancellations made within a week of the class or workshop.

Coming up near you

Let’s Keep You Updated

Enter your email to start following

By providing us with your email, you agree to the terms of our Privacy Policy and Terms of Service.