Microsoft Excel Spreadsheets is a vital resource in many businesses, professions, and organizations. Understanding how to effectively use the multitude of tools within this software will save time and impress your boss and coworkers. Students graduating high school with these skills exhibit job-ready capabilities. When you understand how to use Microsoft Excel, you will easily transfer those skills to other spreadsheet software.
For personal use, classroom use, or as a gift for someone in desperate need of Excel help, this Excel Guide is perfect!
This document is 20 pages long and broken down into 3 sections.
Excel 1: Screen Identification and Data Entry. Use this section to understand the different parts of what is viewed on screen and how to effectively and quickly add data to the spreadsheet.
*Adding and Using Worksheets
*Autocomplete, Autofill, and Autoformatting
*View Ribbon: page layout, show/hide, zoom, window
arrangement, zoom, freeze pains, split screen.
Excel 2: Formatting. Use this section to understand how to format your screen to fit your needs and the needs of your data.
*Cell Formats: text, numbers, alignment, text wrap, merge
*Worksheet Formats: themes, margins, size, orientation, print
area, print titles, print gridlines
*Headers/Footers: page number, date, file path, picture, adding
your own text
Excel 3: Analyzing Data. Use this section to view and use your data after it is entered.
*Sort / Filter
*Text to Columns: separating data from 1 column into 2 or more
*Remove Duplicate Data
*Data Validation: prevent invalid data from being entered into a
*Outline Data: group and subtotal your data
*Worksheet Protection: protect cells and worksheets from
*Find and Replace Data