Virtual Help
- Chat with library staff now
- Contact your library
Learning Online : Microsoft Excel
Microsoft Excel: sub-module 4 of 6 of learning online: computer skills category
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.
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 type face; to make text into a heading; to 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.
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.
You can use tools in the Home tab to change the font size, colour, or type face; to make text into a heading; to change where the text appears in a cell (top, middle bottom), and more.
The Sort tool in the Data tab allows you to organize your worksheet by how you sort one column.
The chart tools in the Insert tab allow you to create a chart from data in selected cells.
The Formulas tab contains a variety of formula tools that can help you perform calculations and other tasks to make use of your data.LinkedIn Learning Video Tutorials
Check out some of the online tutorials available on LinkedIn Learning - open in a new tab for essential training in Microsoft Excel. LinkedIn Learning is a paid resource. Check to see if you have access through your college or your public library.
Getting Started: Excel
Microsoft Excel Guides
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.
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.
Excel 2016
These guides are for Microsoft Excel 2016, and may not be applicable for other versions of Excel. For guides on other versions, see the tabs above.
Excel 2013
These guides are for Microsoft Excel 2013, and may not be applicable for other versions of Excel. For guides on other versions, see the tabs above.
Excel 2010
These guides are for Microsoft Excel 2010, and may not be applicable for other versions of Excel. For guides on other versions, see the tabs above.
Content Licensing Information and GCFLearnFree.org
Videos shared on this page fall outside of the Learning Portal's Creative Commons license.
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.
