Excel Intermediate
Excel Intermediate
This self-paced course consists of reading and/or listening to content and answering assessment questions.
By the end of this course, you should be able to successfully complete:
- Create paycheck calculator
- Scenario Manager
- Goal Seek
- One/ Two-way tables
- Named Ranges
- 6.Cash inflow/expenses calculations
- Real world style calculations of date, time, functions, and formulas
- COUNT, AVERAGE with an argument
- Standard deviation
- Confidence
- Correlation
- Forecast
- Understand number meaning
- Determine averages, max value, percentages from the pivot table
- Understand data being shown on the table
- Solver
- Constraints
- Maximizing variable within constraints
Successful completion of this course requires passing all the assessments at 80 percent. The assessments can be taken multiple times. Upon successful completion of this course, you can download a certificate of completion and access the pre-approved Activity ID from the Completed tab on the MY COURSES page.
This course will automatically be added to your user account within 5-10 minutes of placing your order. Access to HRrecert courses is granted for 24 months from the date of purchase. Internet access is required to view this course.
The HRrecert courses are copyrighted material and may not, in whole or in part, be printed, copied, shared, or reproduced by any means for any reason without prior written consent. Access to the HRrecert courses are for your individual use; your account is not to be shared with others. Any violation of these terms and conditions will result in immediate termination of your access to these materials, with no refund provided.
System Requirements