This module will teach you how to use Microsoft Excel to organize, visualize, and calculate your data. The links on this page will open in a new tab/window.
✓ Use the ‘Tell me’ feature to find a tool. In Excel, you can type your desired task into the box that says, ‘Tell me what you want to do’. It will give you suggestions to help you find the right tool.
✓ Format your text using tools on the Ribbon. You can use tools in the Home tab to change the font size, colour, or typeface; make text into a heading; change where the text appears in a cell (top, middle bottom), and more.
✓ Reorganize your data using the sort tools. The Sort tool in the Data tab allows you to organize your worksheet by how you sort one column.
✓ Use Charts to visually display your data. The chart tools in the Insert tab allow you to create a chart from data in selected cells.
✓ Use Formulas to calculate, analyze, and work with your data. The Formulas tab contains a variety of formula tools that can help you perform calculations and other tasks to make use of your data.
Getting Started with Microsoft Word
Check out this video by GCFGlobal.org on Getting Started with Microsoft Excel from 2016.
Excel in Microsoft 365
These guides are for Excel in Microsoft 365 and may not be applicable for other versions of Excel. For guides on other versions, see the tabs above.
These guides are for Microsoft Excel 2019, and may not be applicable for other versions of Excel. For guides on other versions, see the tabs above.
Unless otherwise stated, the material in this guide is from the Learning Portal created by College Libraries Ontario. Content has been adapted for the NWP Learning Commons in May 2021. This work is licensed under a Creative Commons BY NC SA 4.0 International License.
All icons on these pages are from The Noun Project. See individual icons for creator attribution.