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
- 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
- Use a mouse
- Open and close windows
- Open and save files
- Switch between applications
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).Enroll in Excel: The Basics (IU: No cost)
Join via IU Expand at a low cost (requires an IU Guest account, a free sign-up for anyone).Enroll in Excel: The Basics (Non-IU: $16.99)
This course is part of an IT Training Certificate Series, which awards a certificate on successful completion of a final online exam. Learn more about the Excel End-User Certificate Series.
Additional materials and files
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 download the PDF and exercise files below.
Note: The PDF and exercise files provided here formed a basis for the online course, but may vary from the online course.