Brief Introduction
Take Excel to the next level with advanced formulas, What-If Analysis tools, advanced PivotTables, Macros and much moreDescription
This course will teach students advanced concepts and formulas in Microsoft Excel 2016. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions such as HLOOKUP and VLOOOKP and MATCH and INDEX, 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, as well as how to import and export data to and from their workbooks.
This IAAP-certified counts for 2.25 recertification points for the CAP certification under the Technology and Information Distribution content area.
Email info@intellezy.com with proof of completion of the course to obtain your certificate.
Requirements
- Requirements
- Excel Introduction and Intermediate courses or equivalent experience.
Knowledge
- Use Advanced IF Statements
- Use Advanced Lookup Functions
- Use Complex Logical and Text Functions
- Auditing Formulas
- Working with What-If Analysis Tools
- Protecting Worksheet and Workbook
- Use Advanced PivotTables and PowerPivot Tools
- Automate with Macros
- Work with Form Controls
- Ensure Data Integrity
- Collaborate in Excel
- Import and Export Data to a Text File
30 Days of Python | Unlock your Python Potential
- 4.2
-
![]()
![]()
![]()
![]()
![]()
Python is simple enough for beginners, powerful enough for the pros. Use it for IOT, Web Scraping, Big Data, and more....
Microsoft PowerPoint - Advanced PowerPoint Training
- 4.4
-
![]()
![]()
![]()
![]()
![]()
PowerPoint Training That Actually Works. NEW and UPDATED for Microsoft 365 (PowerPoint 2019). “I LOVE your presentations and your course; you've saved me so much time over the past few months....
Microsoft Excel - Excel with The Ultimate Excel Course
- 4.7
-
![]()
![]()
![]()
![]()
![]()
Go from Excel Beginner to Excel Expert in 10 Hours - Using Microsoft Excel 2010, Excel 2013, Excel 2016, Excel 2019...
The Advanced Excel, Power Pivot & VBA Bundle 2019
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Learn Advanced Excel, Power Pivot, Power Query and VBA with this easy to follow video course **This course includes practice exercises and LIFETIME access**...
