IU Only

Excel: The Basics Asset List

Current folder path within the WCMS: /training/exlbs/files/pc
Title Code: exlbs
Title Description Page: https://ittraining.iu.edu/explore-topics/titles/exlbs
Expand Course URL: false

Expand the accordions to see the lists of assets and their properties.

Excel: The Basics: Pages: 13 total

Explore the Microsoft Excel interface.

Asset Path: /training/exlbs/files/pc/introducing-microsoft-excel
Asset Link: site://IU-UITS-ITTRAIN.content/training/exlbs/files/pc/introducing-microsoft-excel
Asset System Name: introducing-microsoft-excel
Asset Data Definition: Page - Content Blob
Last modified by: blnolen
Asset Indexable: true
Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
Linked From:

Learn how to identify text and numeric data.

Asset Path: /training/exlbs/files/pc/exploring-types-of-data
Asset Link: site://IU-UITS-ITTRAIN.content/training/exlbs/files/pc/exploring-types-of-data
Asset System Name: exploring-types-of-data
Asset Data Definition: Page - Content Blob
Last modified by: blnolen
Asset Indexable: true
Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
Linked From:

Learn about using formulas in Microsoft Excel, including syntax, operators, entering formulas, and copying and pasting formulas.

Asset Path: /training/exlbs/files/pc/introducing-formulas
Asset Link: site://IU-UITS-ITTRAIN.content/training/exlbs/files/pc/introducing-formulas
Asset System Name: introducing-formulas
Asset Data Definition: Page - Content Blob
Last modified by: jloakes
Asset Indexable: true
Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
Linked From:

Explore various ways to enter functions.

Asset Path: /training/exlbs/files/pc/introducing-functions
Asset Link: site://IU-UITS-ITTRAIN.content/training/exlbs/files/pc/introducing-functions
Asset System Name: introducing-functions
Asset Data Definition: Page - Content Blob
Last modified by: blnolen
Asset Indexable: true
Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
Linked From:

Explore absolute cell references.

Asset Path: /training/exlbs/files/pc/working-with-absolute-references
Asset Link: site://IU-UITS-ITTRAIN.content/training/exlbs/files/pc/working-with-absolute-references
Asset System Name: working-with-absolute-references
Asset Data Definition: Page - Content Blob
Last modified by: blnolen
Asset Indexable: true
Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
Linked From:

Learn how named ranges can be useful when working in Excel.

Asset Path: /training/exlbs/files/pc/utilizing-named-ranges
Asset Link: site://IU-UITS-ITTRAIN.content/training/exlbs/files/pc/utilizing-named-ranges
Asset System Name: utilizing-named-ranges
Asset Data Definition: Page - Content Blob
Last modified by: blnolen
Asset Indexable: true
Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
Linked From:

Learn about charts in Microsoft Excel and create a pie chart.

Asset Path: /training/exlbs/files/pc/introducing-charts
Asset Link: site://IU-UITS-ITTRAIN.content/training/exlbs/files/pc/introducing-charts
Asset System Name: introducing-charts
Asset Data Definition: Page - Content Blob
Last modified by: allaw
Asset Indexable: true
Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
Linked From:

Explore what happens with data in the worksheet is updated or edited.

Asset Path: /training/exlbs/files/pc/updating-data
Asset Link: site://IU-UITS-ITTRAIN.content/training/exlbs/files/pc/updating-data
Asset System Name: updating-data
Asset Data Definition: Page - Content Blob
Last modified by: allaw
Asset Indexable: true
Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
Linked From:

Learn how to add a new worksheet to the workbook and add data using the autofill feature.

Asset Path: /training/exlbs/files/pc/adding-a-worksheet
Asset Link: site://IU-UITS-ITTRAIN.content/training/exlbs/files/pc/adding-a-worksheet
Asset System Name: adding-a-worksheet
Asset Data Definition: Page - Content Blob
Last modified by: blnolen
Asset Indexable: true
Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
Linked From:

See how to insert blank columns and rows into a worksheet.

Asset Path: /training/exlbs/files/pc/inserting-columns-and-rows
Asset Link: site://IU-UITS-ITTRAIN.content/training/exlbs/files/pc/inserting-columns-and-rows
Asset System Name: inserting-columns-and-rows
Asset Data Definition: Page - Content Blob
Last modified by: blnolen
Asset Indexable: true
Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
Linked From:

See how to create an Excel table and how to use that table to sort and filter data.

Asset Path: /training/exlbs/files/pc/creating-excel-table
Asset Link: site://IU-UITS-ITTRAIN.content/training/exlbs/files/pc/creating-excel-table
Asset System Name: creating-excel-table
Asset Data Definition: Page - Content Blob
Last modified by: blnolen
Asset Indexable: true
Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
Linked From:
- index

Use the features of the Excel table to sort and filter the data.

Asset Path: /training/exlbs/files/pc/sorting-filtering-excel
Asset Link: site://IU-UITS-ITTRAIN.content/training/exlbs/files/pc/sorting-filtering-excel
Asset System Name: sorting-filtering-excel
Asset Data Definition: Page - Content Blob
Last modified by: blnolen
Asset Indexable: true
Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
Linked From:

Excel: The Basics: : 2 total

Excel: The Basics: Files: 0 total

Excel: The Basics Asset List

Current folder path within the WCMS: /training/exlbs/files/pc
Title Code: exlbs
Title Description Page: https://ittraining.iu.edu/explore-topics/titles/exlbs
Expand Course URL: false

Expand the accordions to see the lists of assets and their properties.

Excel: The Basics: Pages: 13 total

Explore the Microsoft Excel interface.

Asset Path: /training/exlbs/files/pc/introducing-microsoft-excel
Asset Link: site://IU-UITS-ITTRAIN.content/training/exlbs/files/pc/introducing-microsoft-excel
Asset System Name: introducing-microsoft-excel
Asset Data Definition: Page - Content Blob
Last modified by: blnolen
Asset Indexable: true
Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
Linked From:

Learn how to identify text and numeric data.

Asset Path: /training/exlbs/files/pc/exploring-types-of-data
Asset Link: site://IU-UITS-ITTRAIN.content/training/exlbs/files/pc/exploring-types-of-data
Asset System Name: exploring-types-of-data
Asset Data Definition: Page - Content Blob
Last modified by: blnolen
Asset Indexable: true
Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
Linked From:

Learn about using formulas in Microsoft Excel, including syntax, operators, entering formulas, and copying and pasting formulas.

Asset Path: /training/exlbs/files/pc/introducing-formulas
Asset Link: site://IU-UITS-ITTRAIN.content/training/exlbs/files/pc/introducing-formulas
Asset System Name: introducing-formulas
Asset Data Definition: Page - Content Blob
Last modified by: jloakes
Asset Indexable: true
Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
Linked From:

Explore various ways to enter functions.

Asset Path: /training/exlbs/files/pc/introducing-functions
Asset Link: site://IU-UITS-ITTRAIN.content/training/exlbs/files/pc/introducing-functions
Asset System Name: introducing-functions
Asset Data Definition: Page - Content Blob
Last modified by: blnolen
Asset Indexable: true
Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
Linked From:

Explore absolute cell references.

Asset Path: /training/exlbs/files/pc/working-with-absolute-references
Asset Link: site://IU-UITS-ITTRAIN.content/training/exlbs/files/pc/working-with-absolute-references
Asset System Name: working-with-absolute-references
Asset Data Definition: Page - Content Blob
Last modified by: blnolen
Asset Indexable: true
Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
Linked From:

Learn how named ranges can be useful when working in Excel.

Asset Path: /training/exlbs/files/pc/utilizing-named-ranges
Asset Link: site://IU-UITS-ITTRAIN.content/training/exlbs/files/pc/utilizing-named-ranges
Asset System Name: utilizing-named-ranges
Asset Data Definition: Page - Content Blob
Last modified by: blnolen
Asset Indexable: true
Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
Linked From:

Learn about charts in Microsoft Excel and create a pie chart.

Asset Path: /training/exlbs/files/pc/introducing-charts
Asset Link: site://IU-UITS-ITTRAIN.content/training/exlbs/files/pc/introducing-charts
Asset System Name: introducing-charts
Asset Data Definition: Page - Content Blob
Last modified by: allaw
Asset Indexable: true
Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
Linked From:

Explore what happens with data in the worksheet is updated or edited.

Asset Path: /training/exlbs/files/pc/updating-data
Asset Link: site://IU-UITS-ITTRAIN.content/training/exlbs/files/pc/updating-data
Asset System Name: updating-data
Asset Data Definition: Page - Content Blob
Last modified by: allaw
Asset Indexable: true
Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
Linked From:

Learn how to add a new worksheet to the workbook and add data using the autofill feature.

Asset Path: /training/exlbs/files/pc/adding-a-worksheet
Asset Link: site://IU-UITS-ITTRAIN.content/training/exlbs/files/pc/adding-a-worksheet
Asset System Name: adding-a-worksheet
Asset Data Definition: Page - Content Blob
Last modified by: blnolen
Asset Indexable: true
Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
Linked From:

See how to insert blank columns and rows into a worksheet.

Asset Path: /training/exlbs/files/pc/inserting-columns-and-rows
Asset Link: site://IU-UITS-ITTRAIN.content/training/exlbs/files/pc/inserting-columns-and-rows
Asset System Name: inserting-columns-and-rows
Asset Data Definition: Page - Content Blob
Last modified by: blnolen
Asset Indexable: true
Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
Linked From:

See how to create an Excel table and how to use that table to sort and filter data.

Asset Path: /training/exlbs/files/pc/creating-excel-table
Asset Link: site://IU-UITS-ITTRAIN.content/training/exlbs/files/pc/creating-excel-table
Asset System Name: creating-excel-table
Asset Data Definition: Page - Content Blob
Last modified by: blnolen
Asset Indexable: true
Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
Linked From:
- index

Use the features of the Excel table to sort and filter the data.

Asset Path: /training/exlbs/files/pc/sorting-filtering-excel
Asset Link: site://IU-UITS-ITTRAIN.content/training/exlbs/files/pc/sorting-filtering-excel
Asset System Name: sorting-filtering-excel
Asset Data Definition: Page - Content Blob
Last modified by: blnolen
Asset Indexable: true
Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
Linked From:

IU Only

Excel: The Basics Asset List

Excel: The Basics: Pages: 13 total

Introducing Microsoft Excel

Exploring types of data

Introducing formulas

Introducing functions

Working with absolute cell references

Utilizing a named range

Introducing charts

Updating worksheet data

Adding a worksheet

Inserting columns and rows

Creating an Excel table

Sorting and filtering data

Excel: The Basics: : 2 total

Excel: The Basics: Files: 0 total

Excel: The Basics Asset List

Excel: The Basics: Pages: 13 total

Introducing Microsoft Excel

Exploring types of data

Introducing formulas

Introducing functions

Working with absolute cell references

Utilizing a named range

Introducing charts

Updating worksheet data

Adding a worksheet

Inserting columns and rows

Creating an Excel table

Sorting and filtering data

Excel: The Basics: : 2 total

Excel: The Basics: Files: 0 total