Sign in
My Account
Event details and attendees are shown on this page. To edit or find bookings for this event use the links to the right.
Advanced Excel Course
Event type
IT skills training
Event bookings can only be created between
06/01/2020 - 20/02/2020
Seats in waiting list
0
Description
Facilitator
Bite Size Ltd
Course Documents
-
What are the benefits?
• This course explains how to re-use data in other places by linking and also covers how to convert data to a Table to give extra functionality. • Delegates will understand how to format numbers and how to do calculations with dates and times. • The course covers Pivots to enable delegates to summarise large amounts of data.
Topics covered include:
Working across multiple worksheets and workbooks• Linking across worksheets / workbooks• Working in Group mode Working with Tables• Creating Tables• Formatting Tables• Using Slicers with Tables Formatting Numbers Working with Dates and Times Pivot Tables and Charts• Creating a Pivot Table • Formatting a Pivot• Updating your Pivot (refresh and source)• Creating Pivot Charts
Who should attend?
This course is aimed at those who have a good knowledge of MS Excel and know how to create formulas such as sum, average, min, max, counta, countblank and countif. Delegates should also be able to work with named ranges, use lookups create charts and conditional formatting.
The table below shows people who are attending this event, click the attendee name to view more details