Microsoft Excel
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.
Top Tips
✓ 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.
Additional Attributions
Much of the links and video content on this page come from GCFLearnFree.org. All GCFGlobal.org® content is available for free at edu.gcfglobal.org.
Getting Started with Microsoft Excel
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.
→ Inserting and Deleting Cells, Rows and Columns in Excel
→ Overview of formulas in Excel
Excel 2019
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.
→ Getting Started with Excel 2019
→ Formatting Cells in Excel 2019
→ Inserting and Deleting Cells, Rows and Columns in Excel 2019
→ Overview of formulas in Excel
→ Creating Formulas in Excel 2019
→ Creating Charts in Excel 2019
→ Changing the Layout or Style of a Chart in Excel 2019
→ Other Chart Options in Excel 2019
Attribution
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.