Loading Shopping Cart Items...
Catalog
Instructor led
Added:
Objectives: This course is designed for intermediate users who are ready to move beyond basic spreadsheets to automate data cleanup, execute complex conditional logic, and synthesize organizational metrics into user-friendly dashboards. It is ideal for users comfortable with basic formulas who are ready to streamline their workflows, clean system extracts, and build interactive dashboards.
Who should attend All individuals
Learning Outcomes: Upon completion of this course, the learner will be able to:
Date Functions: Learners will confidently analyze and calculate complex, time-based data by applying dynamic Excel date functions to real-world organizational scenarios.
Conditional Functions: Learners will confidently evaluate and summarize complex datasets by applying logical and conditional Excel functions
Text Functions: Learners will practice using multiple text functions to cleanse and structure raw, unformatted system extracts.
What-If Analysis: Learners will solve complex problems by applying Excel's What-If Analysis tools to evaluate competing business strategies.
Power Query: Learners will confidently automate routine data cleanup by applying Power Query to everyday system exports.
This program has been submitted for 5 business credits hours toward PHR, SPHR and GPHR recertification through the HR Certification Institute (HRCI) as well as 5 recertification credit hours (PDC) toward SHRM-CP and SHRM-SCP through the Society of Human Resource Management (SHRM). The use of these seals is not an endorsement by HRCI or SHRM for the quality of the program. It means that this program has met the HRCI's and SHRM's criteria to be pre-approved for recertification credit
Who should attend All individuals
Learning Outcomes: Upon completion of this course, the learner will be able to:
Date Functions: Learners will confidently analyze and calculate complex, time-based data by applying dynamic Excel date functions to real-world organizational scenarios.
Conditional Functions: Learners will confidently evaluate and summarize complex datasets by applying logical and conditional Excel functions
Text Functions: Learners will practice using multiple text functions to cleanse and structure raw, unformatted system extracts.
What-If Analysis: Learners will solve complex problems by applying Excel's What-If Analysis tools to evaluate competing business strategies.
Power Query: Learners will confidently automate routine data cleanup by applying Power Query to everyday system exports.
This program has been submitted for 5 business credits hours toward PHR, SPHR and GPHR recertification through the HR Certification Institute (HRCI) as well as 5 recertification credit hours (PDC) toward SHRM-CP and SHRM-SCP through the Society of Human Resource Management (SHRM). The use of these seals is not an endorsement by HRCI or SHRM for the quality of the program. It means that this program has met the HRCI's and SHRM's criteria to be pre-approved for recertification credit
Credits awarded per Session. See individual Sessions for further details.
Credits awarded
Type
Name
Sub type
Value
$299.00
Already successfully completed: re-enrollment available!
Secure Transaction
Recently Added Items
About this item
Objectives: This course is designed for intermediate users who are ready to move beyond basic spreadsheets to automate data cleanup, execute complex conditional logic, and synthesize organizational metrics into user-friendly dashboards. It is ideal for users comfortable with basic formulas who are ready to streamline their workflows, clean system extracts, and build interactive dashboards.
Who should attend All individuals
Learning Outcomes: Upon completion of this course, the learner will be able to:
- Date Functions: Learners will confidently analyze and calculate complex, time-based data by applying dynamic Excel date functions to real-world organizational scenarios.
- Conditional Functions: Learners will confidently evaluate and summarize complex datasets by applying logical and conditional Excel functions
- Text Functions: Learners will practice using multiple text functions to cleanse and structure raw, unformatted system extracts.
- What-If Analysis: Learners will solve complex problems by applying Excel's What-If Analysis tools to evaluate competing business strategies.
- Power Query: Learners will confidently automate routine data cleanup by applying Power Query to everyday system exports.
.png)
This program has been submitted for 5 business credits hours toward PHR, SPHR and GPHR recertification through the HR Certification Institute (HRCI) as well as 5 recertification credit hours (PDC) toward SHRM-CP and SHRM-SCP through the Society of Human Resource Management (SHRM). The use of these seals is not an endorsement by HRCI or SHRM for the quality of the program. It means that this program has met the HRCI's and SHRM's criteria to be pre-approved for recertification credit
Ratings and reviews
Type:
Name:
Sub type:
Value: