Book now
Excel isn't just for arranging data – it gives users the tools to interrogate data to find valuable new insights. So it's little surprise that Excel power users can earn more money and qualify for more jobs than those with a lesser command of the application. But advanced Excel skills don't just look good on a CV – as this course demonstrates, they empower users with real-world skills for work, home and study.
For this interactive one-day course, expert Excel tutor Abbott Katz has designed a capsule masterclass that unlocks some of the software's most important functions. During the course, you'll learn how Excel's formulas and functions open up new ways to organise and interpret data. You'll also learn how to use pivot tables, enabling you to analyse figures to spot and quantify trends.
This course is for you if...
- You currently use Excel for work or study and want to improve your performance, or find elegant solutions to current problems
- You work with data and want to make better use of it
- You want to learn valuable new skills to improve your CV
PLEASE NOTE: Attendees should bring along their own PC laptop and charger, with Excel installed (this must be the 2007 version, or later), and be comfortable with Excel's basic functions.
Course description
This one-day masterclass explains Excel's advanced functions in easy-to-follow language. Attendees will take part in practical workshops on their own laptop computers. Topics covered include:
Session 1. Formula and function writing
- Beyond SUM: IF, VLOOKUP and INDEX
- Character building: formulas and text data
- Mixing and matching: nesting functions in formulas
- An introduction to array formulas
Session 2. Pivot tables
- What they do, and why you'll want to use them
- Constructing the table: the three got-to-knows
- Resetting and refreshing the table: moving fields around, introducing new ones, dumping unwanted ones
- Grouping the numbers
- Filtering data with the Slicer
Tutor profile
Abbott Katz has introduced Excel to thousands of learners, both in the classroom and via his two books on the application – Beginning Microsoft Excel and ExcelMade Simple – and blog, Spreadsheet Journalism. He has previously taught Excel at City Lit, the London College for Media and Journalism and the National Council for the Training of Journalists, among others.
Book now
Details
Date: Tuesday 31 March 2015
Times: 10am-4pm. Check-in begins 30 minutes before the start time.
Location: The Guardian, Kings Place, 90 York Way, London N1 9GU
Price: £249 (all prices include VAT, booking fee, lunch and refreshments)
Event capacity: 18
To contact us, click here. Terms and conditions can be found here.
Returns policy
Tickets may be refunded if you contact us at least 14 days before the course start date. Please see our terms and conditions for more information on our refund policy.
