Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Common Functions | Basic Formulas and Functions
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

Common Functions

Excel functions are the secret sauce that turns a simple spreadsheet into a powerful data analysis tool.

This chapter will introduce you to some of the most common and versatile functions: SUM, AVERAGE, MIN, MAX, and COUNT.

We'll also explore how to use the AutoSum feature, combine functions for complex calculations, and handle error checking in formulas.

Key Points

  • The SUM function add up a range of numbers, perfect for calculating totals;
  • The AVERAGE function finds the average value in a range, ignoring empty cells and text;
  • The MAX function identifies the largest number in a range;
  • The MIN function finds the smallest number in a range;
  • The COUNT function tallies the number of cells that contain numbers in a range;
  • AutoSum quickly adds up a range of cells and can also be used for AVERAGE, COUNT, MAX, and MIN;
  • You can combine functions to perform more complex calculations;
  • Excel has multiple Error Checking tools for you to utilise.

Tarea

  • Click on F15. Type in =SUM. Double-click SUM function in menu. Select F8 to F14. Press Enter.
  • Click on G15. Type in =SUM. Double-click SUM function in the menu. Select G8 to G14 individually. Press Enter.
  • Click on C31. Type =AVE. Double-click AVERAGE function in menu. Select C22 to C28. Press Enter.
  • Click on C32. Type =MAX. Double-click MAX function in menu. Select C22 to C28. Press Enter.
  • Click on C33. Type =MIN. Double-click MIN function in menu. Select C22 to C28. Press Enter.
  • Select C31, C32 and C33. Click and drag fill handle to column G.
  • Select D15. Type =COUNT. Double-click COUNT function in menu. Select D8 to D14. Press Enter.
  • Select F29. Click the AutoSum button (Σ) button. Press Enter.
  • Click on C34. Type =AVE. Double-click AVERAGE function in menu. Select C22 to C28 then type =MIN Double click MIN function and select C22 to C28. Press Enter.
  • Accept the Excel correction in the dialog box to add a closing bracket to the formula.

Tarea

  • Click on F15. Type in =SUM. Double-click SUM function in menu. Select F8 to F14. Press Enter.
  • Click on G15. Type in =SUM. Double-click SUM function in the menu. Select G8 to G14 individually. Press Enter.
  • Click on C31. Type =AVE. Double-click AVERAGE function in menu. Select C22 to C28. Press Enter.
  • Click on C32. Type =MAX. Double-click MAX function in menu. Select C22 to C28. Press Enter.
  • Click on C33. Type =MIN. Double-click MIN function in menu. Select C22 to C28. Press Enter.
  • Select C31, C32 and C33. Click and drag fill handle to column G.
  • Select D15. Type =COUNT. Double-click COUNT function in menu. Select D8 to D14. Press Enter.
  • Select F29. Click the AutoSum button (Σ) button. Press Enter.
  • Click on C34. Type =AVE. Double-click AVERAGE function in menu. Select C22 to C28 then type =MIN Double click MIN function and select C22 to C28. Press Enter.
  • Accept the Excel correction in the dialog box to add a closing bracket to the formula.

Mark tasks as Completed

¿Todo estuvo claro?

Sección 3. Capítulo 4

Elige tu plan

Common Functions

Excel functions are the secret sauce that turns a simple spreadsheet into a powerful data analysis tool.

This chapter will introduce you to some of the most common and versatile functions: SUM, AVERAGE, MIN, MAX, and COUNT.

We'll also explore how to use the AutoSum feature, combine functions for complex calculations, and handle error checking in formulas.

Key Points

  • The SUM function add up a range of numbers, perfect for calculating totals;
  • The AVERAGE function finds the average value in a range, ignoring empty cells and text;
  • The MAX function identifies the largest number in a range;
  • The MIN function finds the smallest number in a range;
  • The COUNT function tallies the number of cells that contain numbers in a range;
  • AutoSum quickly adds up a range of cells and can also be used for AVERAGE, COUNT, MAX, and MIN;
  • You can combine functions to perform more complex calculations;
  • Excel has multiple Error Checking tools for you to utilise.

Tarea

  • Click on F15. Type in =SUM. Double-click SUM function in menu. Select F8 to F14. Press Enter.
  • Click on G15. Type in =SUM. Double-click SUM function in the menu. Select G8 to G14 individually. Press Enter.
  • Click on C31. Type =AVE. Double-click AVERAGE function in menu. Select C22 to C28. Press Enter.
  • Click on C32. Type =MAX. Double-click MAX function in menu. Select C22 to C28. Press Enter.
  • Click on C33. Type =MIN. Double-click MIN function in menu. Select C22 to C28. Press Enter.
  • Select C31, C32 and C33. Click and drag fill handle to column G.
  • Select D15. Type =COUNT. Double-click COUNT function in menu. Select D8 to D14. Press Enter.
  • Select F29. Click the AutoSum button (Σ) button. Press Enter.
  • Click on C34. Type =AVE. Double-click AVERAGE function in menu. Select C22 to C28 then type =MIN Double click MIN function and select C22 to C28. Press Enter.
  • Accept the Excel correction in the dialog box to add a closing bracket to the formula.

Tarea

  • Click on F15. Type in =SUM. Double-click SUM function in menu. Select F8 to F14. Press Enter.
  • Click on G15. Type in =SUM. Double-click SUM function in the menu. Select G8 to G14 individually. Press Enter.
  • Click on C31. Type =AVE. Double-click AVERAGE function in menu. Select C22 to C28. Press Enter.
  • Click on C32. Type =MAX. Double-click MAX function in menu. Select C22 to C28. Press Enter.
  • Click on C33. Type =MIN. Double-click MIN function in menu. Select C22 to C28. Press Enter.
  • Select C31, C32 and C33. Click and drag fill handle to column G.
  • Select D15. Type =COUNT. Double-click COUNT function in menu. Select D8 to D14. Press Enter.
  • Select F29. Click the AutoSum button (Σ) button. Press Enter.
  • Click on C34. Type =AVE. Double-click AVERAGE function in menu. Select C22 to C28 then type =MIN Double click MIN function and select C22 to C28. Press Enter.
  • Accept the Excel correction in the dialog box to add a closing bracket to the formula.

Mark tasks as Completed

¿Todo estuvo claro?

Sección 3. Capítulo 4

Elige tu plan

Common Functions

Excel functions are the secret sauce that turns a simple spreadsheet into a powerful data analysis tool.

This chapter will introduce you to some of the most common and versatile functions: SUM, AVERAGE, MIN, MAX, and COUNT.

We'll also explore how to use the AutoSum feature, combine functions for complex calculations, and handle error checking in formulas.

Key Points

  • The SUM function add up a range of numbers, perfect for calculating totals;
  • The AVERAGE function finds the average value in a range, ignoring empty cells and text;
  • The MAX function identifies the largest number in a range;
  • The MIN function finds the smallest number in a range;
  • The COUNT function tallies the number of cells that contain numbers in a range;
  • AutoSum quickly adds up a range of cells and can also be used for AVERAGE, COUNT, MAX, and MIN;
  • You can combine functions to perform more complex calculations;
  • Excel has multiple Error Checking tools for you to utilise.

Tarea

  • Click on F15. Type in =SUM. Double-click SUM function in menu. Select F8 to F14. Press Enter.
  • Click on G15. Type in =SUM. Double-click SUM function in the menu. Select G8 to G14 individually. Press Enter.
  • Click on C31. Type =AVE. Double-click AVERAGE function in menu. Select C22 to C28. Press Enter.
  • Click on C32. Type =MAX. Double-click MAX function in menu. Select C22 to C28. Press Enter.
  • Click on C33. Type =MIN. Double-click MIN function in menu. Select C22 to C28. Press Enter.
  • Select C31, C32 and C33. Click and drag fill handle to column G.
  • Select D15. Type =COUNT. Double-click COUNT function in menu. Select D8 to D14. Press Enter.
  • Select F29. Click the AutoSum button (Σ) button. Press Enter.
  • Click on C34. Type =AVE. Double-click AVERAGE function in menu. Select C22 to C28 then type =MIN Double click MIN function and select C22 to C28. Press Enter.
  • Accept the Excel correction in the dialog box to add a closing bracket to the formula.

Tarea

  • Click on F15. Type in =SUM. Double-click SUM function in menu. Select F8 to F14. Press Enter.
  • Click on G15. Type in =SUM. Double-click SUM function in the menu. Select G8 to G14 individually. Press Enter.
  • Click on C31. Type =AVE. Double-click AVERAGE function in menu. Select C22 to C28. Press Enter.
  • Click on C32. Type =MAX. Double-click MAX function in menu. Select C22 to C28. Press Enter.
  • Click on C33. Type =MIN. Double-click MIN function in menu. Select C22 to C28. Press Enter.
  • Select C31, C32 and C33. Click and drag fill handle to column G.
  • Select D15. Type =COUNT. Double-click COUNT function in menu. Select D8 to D14. Press Enter.
  • Select F29. Click the AutoSum button (Σ) button. Press Enter.
  • Click on C34. Type =AVE. Double-click AVERAGE function in menu. Select C22 to C28 then type =MIN Double click MIN function and select C22 to C28. Press Enter.
  • Accept the Excel correction in the dialog box to add a closing bracket to the formula.

¿Todo estuvo claro?

Excel functions are the secret sauce that turns a simple spreadsheet into a powerful data analysis tool.

This chapter will introduce you to some of the most common and versatile functions: SUM, AVERAGE, MIN, MAX, and COUNT.

We'll also explore how to use the AutoSum feature, combine functions for complex calculations, and handle error checking in formulas.

Key Points

  • The SUM function add up a range of numbers, perfect for calculating totals;
  • The AVERAGE function finds the average value in a range, ignoring empty cells and text;
  • The MAX function identifies the largest number in a range;
  • The MIN function finds the smallest number in a range;
  • The COUNT function tallies the number of cells that contain numbers in a range;
  • AutoSum quickly adds up a range of cells and can also be used for AVERAGE, COUNT, MAX, and MIN;
  • You can combine functions to perform more complex calculations;
  • Excel has multiple Error Checking tools for you to utilise.

Tarea

  • Click on F15. Type in =SUM. Double-click SUM function in menu. Select F8 to F14. Press Enter.
  • Click on G15. Type in =SUM. Double-click SUM function in the menu. Select G8 to G14 individually. Press Enter.
  • Click on C31. Type =AVE. Double-click AVERAGE function in menu. Select C22 to C28. Press Enter.
  • Click on C32. Type =MAX. Double-click MAX function in menu. Select C22 to C28. Press Enter.
  • Click on C33. Type =MIN. Double-click MIN function in menu. Select C22 to C28. Press Enter.
  • Select C31, C32 and C33. Click and drag fill handle to column G.
  • Select D15. Type =COUNT. Double-click COUNT function in menu. Select D8 to D14. Press Enter.
  • Select F29. Click the AutoSum button (Σ) button. Press Enter.
  • Click on C34. Type =AVE. Double-click AVERAGE function in menu. Select C22 to C28 then type =MIN Double click MIN function and select C22 to C28. Press Enter.
  • Accept the Excel correction in the dialog box to add a closing bracket to the formula.

Sección 3. Capítulo 4
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