facebook-pixel
$19.99
Certification

Industry recognized certification enables you to add this credential to your resume upon completion of all courses

Need Custom Training for Your Team?
Get Quote
Call Us

Toll Free (844) 397-3739

Inquire About This Course
Instructor
Intellezy Trainers, Instructor - Excel 365 Advanced

Intellezy Trainers

Improving individual or company performance begins with the right training resources. Keep your team’s Microsoft and Adobe skills fresh with our engaging, short-segment videos. Intellezy’s training is delivered by certified instructors and industry experts. Their friendly, engaging style breaks down complex ideas into bite-sized learning nuggets. And, because they never leave the screen, the learner’s attention is held longer. Start watching and find out how valuable 3 minutes can be.

Instructor: Intellezy Trainers

Gain advanced Excel knowledge to enhance your data analysis skills!

  • Understand advanced concepts and formulas and collaboration features of Excel 365.
  • You'll need to have a beginner or intermediate experience with Excel to be able to follow along.
  • Review advanced use of PivotTables and PowerPivot add-in, work with Macros, & use form controls.

Course Description

This course will teach students advanced concepts and formulas in Microsoft Excel 365. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions, and complex logical and text functions. Additionally, students will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in their worksheets and workbooks. Students will also learn about Excel's many collaboration features and import and export data to and from their workbooks. Pre-requisites: Excel 365 Introduction and Intermediate courses or equivalent experience.

What am I going to get from this course?

  • Understand advanced concepts and formulas and collaboration features of Excel 365. 
  • Learn functions such as SUMIF, AVERAGEIF, and COUNTIF. 
  • Explore advanced lookup functions, and complex logical and text functions. Experiment with auditing formulas and error checking. 
  • Use the What-If Analysis tools. 
  • Learn the options for worksheet and workbook protection.  
  • Review advanced use of PivotTables and PowerPivot add-in. 
  • Work with Macros and use form controls. 
  • Learn to ensure data integrity in worksheets and workbooks. 
  • Import and export data to and from workbooks.

Prerequisites and Target Audience

What will students need to know or do before starting this course?

Pre-requisites: Excel 365 Introduction and Intermediate courses or equivalent experience. 

Who should take this course? Who should not?

Those looking to expand their knowledge into Advanced Excel 365. 

Curriculum

350