Course curriculum

    1. Ask Questions

    2. Course Exercise Files

    3. Certificate of Completion

    1. Launching Excel

    2. Microsoft Excel Startup Screen

    3. Introduction to the Excel Interface

    4. Customizing the Excel Quick Access Toolbar

    5. More on the Excel Interface

    6. Understanding the Structure of an Excel Workbook

    7. Saving an Excel Document

    8. Opening an Existing Excel Document

    9. Common Excel Shortcut Keys

    10. Quiz 1: Excel Fundamentals Quiz

    1. Entering Text to Create Spreadsheet Titles

    2. Working with Numeric Data in Excel

    3. Entering Date Values in Excel

    4. Working with Cell References

    5. Creating Basic Formulas in Excel

    6. Relative Versus Absolute Cell References in Formulas

    7. Understanding the Order of Operation (DOWNLOAD EXERCISE FILE)

    8. Quiz 2: Entering and Editing Text and Formulas Quiz

    1. The structure of an Excel Function

    2. Working with the SUM() Function

    3. Working with the MIN() and MAX() Functions

    4. Working with the AVERAGE() Function

    5. Working with the COUNT() Function

    6. Adjacent Cells Error in Excel Calculations

    7. Using the AutoSum Command

    8. Excel's AutoSum Shortcut Key

    9. Using the AutoFill Command to Copy Formulas

    10. Quiz 3: Basic Excel Functions Quiz

    1. Moving and Copying Data in an Excel Worksheet

    2. Inserting and Deleting Rows and Columns

    3. Changing the Width and Height of Cells

    4. Hiding and Unhiding Excel Rows and Columns

    5. Renaming an Excel Worksheet

    6. Deleting an Excel Worksheet

    7. Moving and Copying an Excel Worksheet

    8. Quiz 4: Modifying Worksheets Quiz

    1. Working with Font Formatting Commands

    2. Changing the Background Color of a Cell

    3. Adding Borders to Cells

    4. Formatting Data as Currency Values

    5. Formatting Percentages

    6. Using Excel's Format Painter

    7. Creating Styles to Format Data

    8. Merging and Centering Cells

    9. Using Conditional Formatting

    10. Quiz 5: Formatting Data Quiz

About this course

  • Free
  • 216 lessons
  • 17.5 hours of video content