Course curriculum

    1. Best Practices to Enhance Your Learning Experience

    2. Download Course Files

    1. Structure of the Workbook

    2. The Excel Ribbon

    3. Customizing the Excel Interface

    4. Section 2 Summary

    1. Data Entry & Editing Data

    2. Basic Excel Formulas

    3. Text-to-Speech Feature

    4. Dates & Times

    5. AutoFill Data

    6. Flash Fill

    7. Comments & Notes

    8. Go-To Hacks

    9. Data Validation

    10. Screen Tips

    11. Pictures, Shapes & Objects

    12. Section 3 Summary

    1. Navigation Shortcuts

    2. Copy, Move & Hide Worksheets

    3. Freeze Pane & Split Screen

    4. Hide, Unhide, Insert & Adjust Columns & Rows

    5. Copy & Paste Data

    6. Protect Worksheets & Ranges

    7. Section 4 Summary

    1. Order of Operations

    2. Most Common Formulas

    3. Formula Essentials

    4. Absolute & Relative References

    5. Named Ranges

    6. Referencing Other Workbooks & Worksheets

    7. Circular References

    8. Combine Values

    9. Section 5 Summary

    1. Function Vocabulary & Features

    2. COUNT, COUNTA & COUNTBLANK

    3. COUNTIF & COUNTIFS

    4. SUM & AVG

    5. SUMIFS & AVERAGEIFS

    6. ROUND

    7. Date Functions

    8. Time Functions

    9. Formula Errors

    10. Conditional Formulas

    11. VLOOKUP

    12. Section 6 Summary

About this course

  • $99.00
  • 94 lessons
  • 7 hours of video content

Discover your potential, starting today

Enroll today