Excel is Microsoft's spreadsheet program, an ideal tool for tracking numerical information and performing data analysis. In this module, participants will learn how to enter and modify data, use common formulas and functions, and create a simple chart to visually represent data.
What You Should Already Know
You should have taken Windows: Basic Computing Skills or have the equivalent skills. Specifically, you should already know how to:
- use a mouse
- open and save files
- open and close windows
- switch between windows
What You Will Learn
This module will provide you with hands-on practice, including how to:
- 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
What You Will Need to Use These Materials
To complete this module successfully, you will need:
- Microsoft Excel 2016
- the exercise files, which will be located in the upper right corner of the page if they are required
If you have computer-related questions not answered in these materials, you may look for the answers in the UITS Knowledge Base.
Want to Learn More?
IT Training offers many training options for extending your skills beyond this workshop:
- Self-study training: You may access computer-based training from leading commercial vendors, obtain the materials for other IT Training workshops, or access IT Training's own tutorials on a range of topics.
- IT Training Tips weblog: Our award-winning blog has short tutorials and training posts on a broad range of topics and technologies that you may read and comment on. It's written by training and support providers from across the entire IU system.