These materials introduce basic Excel skills such as entering various types of data, working with common formulas and functions, and creating a simple chart. We'll also cover formatting a worksheet and creating a data table.
Excel: The Basics
Learning Objectives
- Enter various types of data into a worksheet
- Work with formulas and functions
- Create and modify a pie chart
- Copy and paste data from another Excel workbook
- Format cells and ranges
- Create named ranges and use them in formulas
- Customize printouts
Prerequisite Skills
- Use a mouse
- Open and close windows
- Open and save files
- Switch between applications
For a more in-depth look at the content of Excel: The Basics, view the title contents below.
Enroll in the online course
Follow the appropriate enrollment method below, depending on your IU status.
IU faculty, staff, and students
Join using the self-enroll feature of Canvas (requires IU username and passphrase).
Non-IU learners
Join via IU Expand at a low cost (requires an IU Guest account, a free sign-up for anyone).
This course is part of two IT Training Certificate Series, each one awards a certificate
Title Contents
Expand the accordion folds to see a detailed description of the content.
For IU learners: If you're interested in the content for Excel: The Basics, but prefer not to enroll in the online course, you can access the course content below.
Explore the contents of Excel: The Basics:
Explore the Excel interface.
See the full content for Getting Started in Excel
(IU Login Required)Learn how to identify text and numeric data.
See the full content for Exploring Various Types of Data
(IU Login Required)Learn about using formulas in Excel, including syntax, operators, entering formulas, and copying and pasting formulas.
See the full content for Introducing Formulas
(IU Login Required)Explore various ways to enter functions, including the Insert Function command on Windows, the Formula Builder on MacOS, and the AutoSum function.
See the full content for Introducing Functions
(IU Login Required)See how to enter and edit data, change column widths, and add comments to cells.
See the full content for Modifying Cell Contents
(IU Login Required)Learn how to enter and AutoFill a formula and explore absolute cell references and named ranges.
See the full content for Working with Absolute Cell References and Named Ranges
(IU Login Required)Learn about charting in Excel and create a pie chart.
See the full content for Introducing Charts
(IU Login Required)Learn how to use the Accessibility Checker on Windows and MacOS, add alternative text to a chart, and update a chart.
See the full content for Checking the Workbook for Accessibility Issues
(IU Login Required)Explore how to create a new workbook from the beginning.
See the full content for Beginning a New Workbook
(IU Login Required)See how to insert and delete columns.
See the full content for Modifying the Worksheet Structure
(IU Login Required)Copy and paste data between Excel files.
See the full content for Copying and Pasting Data from Another File
(IU Login Required)Explore the benefits of using an Excel table.
See the full content for Creating an Excel Table
(IU Login Required)Work with table features such as the total row, fill options, and filters.
See the full content for Working with an Excel Table
(IU Login Required)Work with the Accessibility Checker.
See the full content for Challenge Exercise 1: Checking for Accessibility Issues
(IU Login Required)Explore various ways to format an Excel worksheet, including colors, fonts, sorting, and data types.
See the full content for Formatting the Worksheet
(IU Login Required)See how to check spelling, utilize the Page Setup dialog box, and preview the printed document.
See the full content for Preparing to Print a Worksheet
(IU Login Required)
Find related training with our partners
Pluralsight
Pluralsight is a provider of video-based online training with a focus on more technically oriented and design focused topics.
Skillsoft
Skillsoft is a leading e-learning provider with a wide range of educational services and in-depth coverage of IT and other skills.