Purchase
Enter Price Code
Student
Instructor
IT Professional
Customer Support
Contact Us
TestOut Help Center
LMS Integration
Sign Up
CertMaster Login
Hands-on Technology Courseware
Courses
Course Catalog
Why TestOut
LabSim Learning Platform
TestOut Training
Lab Simulations
Customer Success
Certifications
Overview
Benefits
Pro Exams
Pro Exam Catalog
Pro Exam Resources
Wall of Fame
Who We Serve
K12 Education
Higher Education
Professionals
Resources
Product Guides
Job-Role Pathways
Educator Resources
Student Resources
TestOut Blog
Facebook Instructor Community
IT Career Interest Survey
Cybersecurity Scary Stories
How-To Guide for Passing ITF+
Unplugged Classroom Activities
Request Instructor Access
TestOut Pro Certified: Microsoft Excel Advanced
Certification Objectives
TestOut
TestOut Pro Certified: Microsoft Excel Advanced
Certification Objectives
Workbooks and Worksheets
Manage workbooks
Protect a workbook
Set Calculation Options
Add authoring languages and proofing
Set AutoSave and AutoRecover
Manage worksheets
Protect a worksheet
Lock or unlock ranges of a protected worksheet
Set Edit Ranges
Reference data in multiple worksheets
Formatting and Data
Use advanced formatting
Manage rules
Configure conditional formatting
Use Flash Fill
Use Fill Series
Configure custom date formats
Configure custom number and currency formats
Manage data
Use data validation
Remove duplicates
Sort data
Analyze and consolidate data
Configure subtotals
Functions, Formulas, and Macros
Use advanced functions
Use time functions: TODAY(), NOW(), WORKDAY(), WEEKDAY()
Use lookup functions: VLOOKUP(), HLOOKUP()
Use logical functions: IFS(), AND(), NOT(), OR()
Use financial functions: PMT(), NPER()
Use math functions: SUMIFS(), AVERAGEIFS()
Define advanced formulas
Use nested functions
Perform What-If Analysis using Goal Seek and Scenario Manager
Troubleshoot formulas
Use macros
Create and run macros
Set macro security settings
Charts and Tables
Manage Charts
Create and modify advanced charts
Create and modify PivotCharts
Manage Tables
Create and modify PivotTables
Uses slicers to filter data
Explore TestOut Pro Certifications
Benefits
Pro Exams
Resources