Northstar Learning Guide


The resources on this page will introduce you to the basics of using, editing, and creating spreadsheets in Microsoft Excel 2010. Using your Northstar assessment results page, locate the skills you need to improve in the left-hand column of the table. Then, follow the links in the right-hand column to access the corresponding online learning resources. Ask a librarian or your tutor/instructor if you have questions or need help.

Module 7: Microsoft Excel


Northstar Standard:Learning Resource:
1. Open a workbook
  • Creating and Opening Workbooks
  • 2. Identify parts of Excel Screen: ribbon, formula bar, active cell, name box, column letter, row number
  • Getting Started with Excel
  • The Quick Access Toolbar
  • 3. Identify sheet tabs, create a new tab, and rearrange tabs
  • Worksheet Basics
  • 4. Name worksheets
  • Worksheet Basics
  • 5. Locate a cell
  • Cell Basics
  • 6. Create headings and freeze them
  • Worksheet Basics
  • 7. Adjust rows and columns
  • Modifying Columns, Rows and Cells
  • 8. Insert and delete rows and columns
  • Modifying Columns, Rows and Cells
  • 9. Drag and dropk
  • Cell Basics
  • 10. Enter data in a cell
  • Cell Basics
  • Formatting Cells
  • 11. Select a range
  • Cell Basics
  • 12. Sort data (least to greatest, alphabetically, etc.)
  • Sorting Data
  • 13. Use AutoSum (Sum, average, etc.)
  • Working with Basic Functions
  • 14. Write a formula in the formula bar (-, +, *, /)
  • Creating Simple Formulas
  • 15. Use Auto Fill
  • Cell Basics
  • 16. Copy and move cell entries
  • Cell Basics
  • 17. Choose page orientation
  • Printing
  • 18. Create a graph using data
  • Working with Charts
  • How to Create a Basic Chart in Excel
  • Create a Pie Chart
  • 19. Save and name workbook
  • Saving
  • 20. Select a print area and print
  • Printing
  • Five Tips for Printing Excel Spreadsheets
  • 21. Save and close workbook using the ribbon