Excel Basic
Excel Basic
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:
- Formatting skills
- Inserting new rows and columns
- Filling columns (color)
- Marking headers
- Bolding/ Italicizing/ Underlining cell contents
- Merge and Center
- Resizing cells
- Cell Alignment
- Hiding Columns
- Borders
- Print Area
- Wrap Text
- Sorting/ filtering table contents
- Formulas
- Operations
- Creating reusable formulas
- Copying formulas down
- Functions
- SUM
- COUNT
- AVERAGE
- MIN
- MAX
- Financial Functions
- Boolean
- AND
- OR
- NOT
- IF
- Value if true/if false
- Lookup
- VLOOKUPx
- HLOOKUP
- Conditional
- COUNTIF
- SUMIF
- AVERAGEIF
- Date
- TODAY/ NOW
- WEEKDAY
- WEEKNUM
- YEAR
- Operations with dates
- Text
- LEN
- SEARCH
- LEFT/RIGHT/MID
- CONCAT
- Time
- HOUR/MINUTE/SECOND
- Charting
- Constructing different chart types (Column, stacked column, pie, line
- Trendlines
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