Loading...
Excel 2016 Spotlight: Pivot Tables, Charts, & Data Analysis
Advance your skills on Lookup functions, PivotTables, PivotCharts, and Advanced IF Statementsschedule1.5h
4.2(33)
Intellezy Trainers
•
Offering eLearning and Instructor-led Training at your fingertips!
93 Courses
• 537 Reviews
Intellezy collaborates with organizations to help implement and adopt technology to its full potential. Our online videos include 250+ courses designed to educate and empower individuals
Our library,...
Edward McCrae
•
Intellezy Instructor
Ed specializes in Excel Workbook development, Access Database Design, and SharePoint site creation and administration. Ed has been in the technical training industry since 2006 and has taught Microsof...
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.
This course includes:
schedule1.5 hours on-demand video
signal_cellular_altBeginner level
task_altNo preparation required
calendar_todayPublished At Jul 30, 2022
workspace_premiumCertificate of completion
errorNo prerequisites
lock