Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Challenge | Introduction to Excel
Excel Essentials
course content

Contenido del Curso

Excel Essentials

Excel Essentials

1. Introduction to Excel
IntroductionGetting Acquainted with ExcelExcel InterfaceEntering DataChallenge
2. Entering and Formatting Data
Formatting CellsFormatting TextFormatting NumbersChallenge
3. Basic Formulas and Functions
Introduction to Formulas and FunctionsUsing Cell ReferencesUnderstanding RangesCommon FunctionsApplication of INSERT FUNCTIONChallenge
4. Advanced Formulas and Functions
Displaying and Highlighting FormulasIF Logical Test and Relational OperatorsNested IF StatementsCompound Logical Tests with AND, ORUsing Auditing ToolsConditional FormattingChallenge
5. Data Management and Analysis
Sorting DataFiltering Data Using AutoFilterClearing and Reapplying FiltersRules and SearchCreating and Managing TablesTable Styles and Quick Formatting OptionsUsing Table ToolsChallenge
6. Visualizing Data with Charts and Graphs
Types of ChartsCreating a Basic ChartCustomizing Chart ElementsChanging Chart Styles and ColorsAdding and Removing Chart ElementsEditing Data in ChartsAdding Trendlines to ChartsChallenge
7. Working with Worksheets and Workbooks
Add, Delete, Rename, and Rearrange WorksheetsGrouping and Ungrouping WorksheetsUsing the Format PainterInserting and Deleting Columns, Rows, and CellsHiding and Unhiding Columns and RowsSaving WorkbooksOpening and Closing WorkbooksProtecting Workbooks with PasswordsUsing TemplatesChallengeSummary

Challenge

Quiz

It's time to assess your theoretical knowledge. Watch the video below and try to answer all the questions within the allotted time.

Note

If you need more time to think about your answer, feel free to pause the quiz timer.

Note

If you find you've missed some topics and answered incorrectly, consider revisiting the relevant section to review the material.

Completing the Workbook

Having completed the first section, it's now time to put your skills to the test. Your initial task is to complete all the exercises in the workbook provided earlier. If you can't find it or if it's been corrupted during your training, don't worry. You can download it again here:

Tarea

Please verify that you have already completed these steps. If not, go ahead and finish your workbook:

  • Click on the + sign to add a new worksheet. Right-click on the new worksheet to access the menu and then delete.
  • Move your cursor in-between columns F and G. Double-click to adjust the size of the column.
  • Click on B7. Type January directly into the cell. Press Enter.
  • Click on I7 and enter the date 01/12/2024.
  • Click on January in B7 & drag down to B18 to Autofill the months of the year.
  • Click on the date in I7 & drag down to I18 to Autofill the dates.
  • Highlight the cells from K7 to K18 & click on Flash Fill.
  • Highlight the cells from L7 to L18 & click on Flash Fill.

Tarea

Please verify that you have already completed these steps. If not, go ahead and finish your workbook:

  • Click on the + sign to add a new worksheet. Right-click on the new worksheet to access the menu and then delete.
  • Move your cursor in-between columns F and G. Double-click to adjust the size of the column.
  • Click on B7. Type January directly into the cell. Press Enter.
  • Click on I7 and enter the date 01/12/2024.
  • Click on January in B7 & drag down to B18 to Autofill the months of the year.
  • Click on the date in I7 & drag down to I18 to Autofill the dates.
  • Highlight the cells from K7 to K18 & click on Flash Fill.
  • Highlight the cells from L7 to L18 & click on Flash Fill.

Mark tasks as Completed

¿Todo estuvo claro?

Sección 1. Capítulo 5

Elige tu plan

Challenge

Quiz

It's time to assess your theoretical knowledge. Watch the video below and try to answer all the questions within the allotted time.

Note

If you need more time to think about your answer, feel free to pause the quiz timer.

Note

If you find you've missed some topics and answered incorrectly, consider revisiting the relevant section to review the material.

Completing the Workbook

Having completed the first section, it's now time to put your skills to the test. Your initial task is to complete all the exercises in the workbook provided earlier. If you can't find it or if it's been corrupted during your training, don't worry. You can download it again here:

Tarea

Please verify that you have already completed these steps. If not, go ahead and finish your workbook:

  • Click on the + sign to add a new worksheet. Right-click on the new worksheet to access the menu and then delete.
  • Move your cursor in-between columns F and G. Double-click to adjust the size of the column.
  • Click on B7. Type January directly into the cell. Press Enter.
  • Click on I7 and enter the date 01/12/2024.
  • Click on January in B7 & drag down to B18 to Autofill the months of the year.
  • Click on the date in I7 & drag down to I18 to Autofill the dates.
  • Highlight the cells from K7 to K18 & click on Flash Fill.
  • Highlight the cells from L7 to L18 & click on Flash Fill.

Tarea

Please verify that you have already completed these steps. If not, go ahead and finish your workbook:

  • Click on the + sign to add a new worksheet. Right-click on the new worksheet to access the menu and then delete.
  • Move your cursor in-between columns F and G. Double-click to adjust the size of the column.
  • Click on B7. Type January directly into the cell. Press Enter.
  • Click on I7 and enter the date 01/12/2024.
  • Click on January in B7 & drag down to B18 to Autofill the months of the year.
  • Click on the date in I7 & drag down to I18 to Autofill the dates.
  • Highlight the cells from K7 to K18 & click on Flash Fill.
  • Highlight the cells from L7 to L18 & click on Flash Fill.

Mark tasks as Completed

¿Todo estuvo claro?

Sección 1. Capítulo 5

Elige tu plan

Challenge

Quiz

It's time to assess your theoretical knowledge. Watch the video below and try to answer all the questions within the allotted time.

Note

If you need more time to think about your answer, feel free to pause the quiz timer.

Note

If you find you've missed some topics and answered incorrectly, consider revisiting the relevant section to review the material.

Completing the Workbook

Having completed the first section, it's now time to put your skills to the test. Your initial task is to complete all the exercises in the workbook provided earlier. If you can't find it or if it's been corrupted during your training, don't worry. You can download it again here:

Tarea

Please verify that you have already completed these steps. If not, go ahead and finish your workbook:

  • Click on the + sign to add a new worksheet. Right-click on the new worksheet to access the menu and then delete.
  • Move your cursor in-between columns F and G. Double-click to adjust the size of the column.
  • Click on B7. Type January directly into the cell. Press Enter.
  • Click on I7 and enter the date 01/12/2024.
  • Click on January in B7 & drag down to B18 to Autofill the months of the year.
  • Click on the date in I7 & drag down to I18 to Autofill the dates.
  • Highlight the cells from K7 to K18 & click on Flash Fill.
  • Highlight the cells from L7 to L18 & click on Flash Fill.

Tarea

Please verify that you have already completed these steps. If not, go ahead and finish your workbook:

  • Click on the + sign to add a new worksheet. Right-click on the new worksheet to access the menu and then delete.
  • Move your cursor in-between columns F and G. Double-click to adjust the size of the column.
  • Click on B7. Type January directly into the cell. Press Enter.
  • Click on I7 and enter the date 01/12/2024.
  • Click on January in B7 & drag down to B18 to Autofill the months of the year.
  • Click on the date in I7 & drag down to I18 to Autofill the dates.
  • Highlight the cells from K7 to K18 & click on Flash Fill.
  • Highlight the cells from L7 to L18 & click on Flash Fill.

¿Todo estuvo claro?

Quiz

It's time to assess your theoretical knowledge. Watch the video below and try to answer all the questions within the allotted time.

Note

If you need more time to think about your answer, feel free to pause the quiz timer.

Note

If you find you've missed some topics and answered incorrectly, consider revisiting the relevant section to review the material.

Completing the Workbook

Having completed the first section, it's now time to put your skills to the test. Your initial task is to complete all the exercises in the workbook provided earlier. If you can't find it or if it's been corrupted during your training, don't worry. You can download it again here:

Tarea

Please verify that you have already completed these steps. If not, go ahead and finish your workbook:

  • Click on the + sign to add a new worksheet. Right-click on the new worksheet to access the menu and then delete.
  • Move your cursor in-between columns F and G. Double-click to adjust the size of the column.
  • Click on B7. Type January directly into the cell. Press Enter.
  • Click on I7 and enter the date 01/12/2024.
  • Click on January in B7 & drag down to B18 to Autofill the months of the year.
  • Click on the date in I7 & drag down to I18 to Autofill the dates.
  • Highlight the cells from K7 to K18 & click on Flash Fill.
  • Highlight the cells from L7 to L18 & click on Flash Fill.

Sección 1. Capítulo 5
Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones
We're sorry to hear that something went wrong. What happened?
some-alt