Virtual Help icon Virtual Help

  • Chat with library staff now
  • Contact your library
Skip to main content
The Learning Portal - College Libraries Ontario

Digital Skills

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.

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.

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 with Excel

Microsoft Excel Guides

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.

GCFLearnFree.org