search
About this course

Module 1 - Students will learn to work with Excel's most common lookup functions VLOOKUP, HLOOKUP, INDEX, and MATCH. Students will learn to use VLOOKUP to compare two lists and combine INDEX and MATCH for more complex lookups. Intellezy Spotlight courses are designed to offer students instruction on focused areas of interest in lieu of the more comprehensive training available in our complete courses.

Module 2 - Students will learn to use Excel's powerful PivotTable and PivotChart features. Students will create PivotTables and PivotCharts using the wizard, work with the Fields pane, and format PivotTables. They will also learn how to organize data for the best results when using PivotTables.

Module 3 - Students will learn to use Excel's advanced IF statements. Students will summarize data with SUMIF, AVERAGEIF, and COUNTIF, created nested IF statements, and use the IFERROR function to handle errors.

schedule
1.5 hours on-demand video
emoji_events
Certificate of completion
bar_chart
Beginner level
error_outline
No prerequisites
check_circle
No preparation required
lock
1 year access

£44.59

verified 100% moneyback guarantee
If you cancel within 10 days and you’re not completely satisfied, we’ll give you all your money back. No questions asked.
Training 2 or more people?

Get your team access to 2,543 top CPD On Demand courses anytime, anywhere.

Browse course content
23 Video
|
schedule
1.5 hours
Guide
Section 1. Analyzing Data with Lookup Functions
lock
Introduction - Analyzing Data with Lookup Functions.mp4
51s
lock
Using VLookup.mp4
7m 40s
lock
Using HLookup.mp4
2m 23s
lock
Using VLOOKUP with TRUE.mp4
3m 45s
lock
Using HLOOKUP with TRUE.mp4
1m 39s
lock
Comparing Two Lists with VLOOKUP.mp4
2m 0s
lock
Comparing Two Lists with VLOOKUP and ISNA.mp4
4m 12s
lock
Using the Index Function.mp4
2m 37s
lock
Using the MATCH Function.mp4
2m 33s
lock
Combining INDEX and MATCH.mp4
4m 9s
Section 2. Understanding PivotTables and PivotCharts
lock
Introduction - Understanding PivotTables and PivotCharts.mp4
51s
lock
What is a Pivot Table.mp4
3m 58s
lock
Creating a Pivot Table.mp4
2m 57s
lock
Using the Pivot Tables Charts Wizard.mp4
2m 3s
lock
Working with the Pivot Table Fields Pane.mp4
6m 45s
lock
Basic Data Organization and Analysis with Pivot Table.mp4
3m 43s
lock
Formatting Pivot Tables.mp4
5m 32s
Section 3. Using Advanced IF Statements
lock
Introduction - Using Advanced IF Statements.mp4
51s
lock
Summarize Data with SUMIF.mp4
4m 28s
lock
Summarize Data with AVERAGIF.mp4
2m 36s
lock
Summarize Data with COUNTIF.mp4
1m 53s
lock
Creating a Nested IF Function.mp4
5m 25s
lock
Using the IFERROR Function.mp4
3m 24s
Learn from the best
Intellezy Trainers / INSTRUCTOR
Offering eLearning and Instructor-led Training at your fingertips!

Intellezy collaborates with organizations to help implement and adopt technology to its maximum potential. From our change management consulting to our learning and development services, Intellezy uses both culture and education to drive the ROI of any organization. Our online videos and quick reference guides are designed to educate and empower individuals, right when they need it. In today’s rapidly evolving workplace, it is imperative to make sure you have the skills and expertise required to succeed. Our library, recognized by top influencers such as eLearning Journal and The Craig Weiss Group, provides dynamic and task-focused videos right at your fingertips, right when you need them.