English
EspaƱol

Excel Basic

Price: $179.00

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:

  1. Formatting skills
  2. Inserting new rows and columns
  3. Filling columns (color)
  4. Marking headers
  5. Bolding/ Italicizing/ Underlining cell contents
  6. Merge and Center
  7. Resizing cells
  8. Cell Alignment
  9. Hiding Columns
  10. Borders
  11. Print Area
  12. Wrap Text
  13. Sorting/ filtering table contents
  14. Formulas
  15. Operations
  16. Creating reusable formulas
  17. Copying formulas down
  18. Functions
  19. SUM
  20. COUNT
  21. AVERAGE
  22. MIN
  23. MAX
  24. Financial Functions
  25. Boolean
  26. AND
  27. OR
  28. NOT
  29. IF
  30. Value if true/if false
  31. Lookup
  32. VLOOKUPx
  33. HLOOKUP
  34. Conditional
  35. COUNTIF
  36. SUMIF
  37. AVERAGEIF
  38. Date
  39. TODAY/ NOW
  40. WEEKDAY
  41. WEEKNUM
  42. YEAR
  43. Operations with dates
  44. Text
  45. LEN
  46. SEARCH
  47. LEFT/RIGHT/MID
  48. CONCAT
  49. Time
  50. HOUR/MINUTE/SECOND
  51. Charting
  52. Constructing different chart types (Column, stacked column, pie, line
  53. 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

Excel Basic

We use cookies to analyze site usage, enhance site usability, and assist in our marketing efforts. By continuing to use this site, you agree to our Privacy and Security Policy, and Terms of Agreement.

I Accept