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.
Excel Intermediate course
Event type
Information Technology
Event bookings can only be created between
06/01/2020 - 20/02/2020
Description
Facilitator
Bite Size Lts
Course Documents
-
What are the benefits?
• This course explains about the count function, how to name cells and use them in calculations. • It covers how to track data with Conditional Formatting and how to sort, filter data and convert a range of data to a Table. • Charts and an understanding of how to print exactly what is needed are also included.
Topics covered include:
More functions• Counta, Count, Countblank and CountIF • IF Function Cell and Range Names • Creating named ranges • Using & Managing Named Ranges Lookups• VLOOKUP and HLOOKUP FunctionsWorking with Data • Conditional Formatting including with formulas • Sorting and Filtering Data Charting • Creating Charts • Chart Formatting Options • Sparklines Printing • Printing options • Setting up Print Areas
Who should attend?
This course is aimed at those who have a basic knowledge of MS Excel and know how to modify data and formulas. They should understand which order calculations are performed in and the difference between relative and absolute formulas.
The table below shows people who are attending this event, click the attendee name to view more details