IU Only

Excel 2016: The Basics Asset List

Excel 2016: The Basics: Pages: 19 total

Explore the Excel interface.

Learn how to identify text and numeric data.

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

Explore various ways to enter functions, including the Insert Function command on Windows, the Formula Builder on MacOS, and the AutoSum function.

See how to enter and edit data, change column widths, and add comments to cells.

Learn how to enter and AutoFill a formula and explore absolute cell references and named ranges.

Learn about charting in Excel and create a pie chart.

Learn how to use the Accessibility Checker on Windows and MacOS, add alternative text to a chart, and update a chart.

Explore how to create a new workbook from the beginning.

See how to insert and delete columns.

Copy and paste data between Excel files.

Explore the benefits of using an Excel table.

Work with table features such as the total row, fill options, and filters.

Work with the Accessibility Checker.

Explore various ways to format an Excel worksheet, including colors, fonts, sorting, and data types.

See how to check spelling, utilize the Page Setup dialog box, and preview the printed document.

Excel 2016: The Basics: : 2 total

Excel 2016: The Basics: Files: 0 total

Excel 2016: The Basics Asset List

Excel 2016: The Basics: Pages: 19 total

Explore the Excel interface.

Learn how to identify text and numeric data.

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

Explore various ways to enter functions, including the Insert Function command on Windows, the Formula Builder on MacOS, and the AutoSum function.

See how to enter and edit data, change column widths, and add comments to cells.

Learn how to enter and AutoFill a formula and explore absolute cell references and named ranges.

Learn about charting in Excel and create a pie chart.

Learn how to use the Accessibility Checker on Windows and MacOS, add alternative text to a chart, and update a chart.

Explore how to create a new workbook from the beginning.

See how to insert and delete columns.

Copy and paste data between Excel files.

Explore the benefits of using an Excel table.

Work with table features such as the total row, fill options, and filters.

Work with the Accessibility Checker.

Explore various ways to format an Excel worksheet, including colors, fonts, sorting, and data types.

See how to check spelling, utilize the Page Setup dialog box, and preview the printed document.

Excel 2016: The Basics: : 2 total

Excel 2016: The Basics: Files: 0 total