Intermediate Excel: Formulas & Functions
9

Tuesday, 9 May

6:15 9:15 pm BST

GA London, The Relay Building

1st Floor, 114 Whitechapel High Street
London, E1 7PT
£55 GBP
Regular Ticket
£55 GBP
Total

Questions? Read our FAQs

Intermediate Excel: Formulas & Functions

Waseem Ali Photo


Co-founder & Director, Cloudstream Partners

9

Tuesday, 9 May

6:15 9:15 pm BST

GA London, The Relay Building

1st Floor, 114 Whitechapel High Street
London, E1 7PT
£55 GBP
Regular Ticket
£55 GBP
Total

Questions? Read our FAQs

About This Class

If you have the basics of Excel down, and you want to start taking your knowledge to the next level, then this workshop is for you. The Intermediate Excel: Formula and Functions workshop is designed for students who have mastered the material from the Excel at Excel workshop and are looking to build upon those skills. We'll start with a quick review of the basics before moving onto more advanced Excel tools including: specialised functions; how to combine functions to achieve more advanced tasks; and more advanced options in charts.

Students must bring a laptop with Excel pre-installed.

Takeaways

This workshop will cover:

  • A review of basic formula writing, including when to use Absolute & Relative references
  • Intermediate Formulas, such as VLookup, If, and Sumif
  • How to create and modify Pivot Tables to analyse large quantities of data
  • Improved chart functionality, including Trendlines and multi-axis charts

Prereqs & Preparation

  • Students must bring a laptop with Excel pre-installed (Office 2007, 2010, or 2013 on a PC recommended, Excel 2011 on a Mac acceptable). Highly recommended to bring a mouse too.

  • This workshop is for those who already know the basics of Excel and are looking to progress to the next level. If you don't have the basics down, then the introductory workshop Excel at Excel: Getting Down the Basics would be the necessary prerequisite.

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.