Course curriculum

    1. Create a workbook in Excel

    2. Save your workbook to OneDrive in Excel

    3. Analyze and format in Excel

    4. Collaborate in Excel

    5. Set up your Excel mobile app

    1. Create a new workbook

    2. Insert or delete a worksheet

    3. Move or copy worksheets or worksheet data

    4. Print a worksheet or workbook

    5. Use Excel as your calculator

    6. Fill data automatically in worksheet cells

    7. Create a drop-down list

    1. Insert or delete rows and columns

    2. Select cell contents in Excel

    3. Freeze panes to lock rows and columns

    4. Hide or show rows or columns

    5. Filter for unique values or remove duplicate values

    6. Split text into different columns with the Convert Text to Columns Wizard

    7. Create a list of sequential dates

    1. Move or copy cells and cell contents

    2. Change the column width or row height in Excel

    3. Find or replace text and numbers on a worksheet

    4. Merge and unmerge cells

    5. Apply data validation to cells

    6. Import or export text (.txt or .csv) files

    1. Available number formats in Excel

    2. Conditional formatting

    3. Align or rotate text in a cell

    4. Change the format of a cell

    5. Copy cell formatting

    6. Add a watermark in Excel

    7. Display or hide zero values

    8. Create a custom number format

    1. Overview of formulas in Excel

    2. XLOOKUP function

    3. SUM function

    4. COUNTIF function

    5. IF function

    6. IFS

    7. SUMIF

    8. SUMIFS

    9. MATCH function

About this course

  • Free
  • 81 lessons
  • 0 hours of video content

Discover your potential, starting today

Enroll today