Excel Guide / Handout - Beginner to Advanced Users

Product Rating
Not yet rated
File Type
PDF (Acrobat) Document File
Be sure that you have an application to open this file type before downloading and/or purchasing.
1.17 MB   |   20 pages

PRODUCT DESCRIPTION

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.
*Add/Delete/Hide/Resize Rows/Columns/Cells
*Cell Formats: text, numbers, alignment, text wrap, merge
*Quick Formulas
*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
columns
*Remove Duplicate Data
*Data Validation: prevent invalid data from being entered into a
cell
*Outline Data: group and subtotal your data
*Worksheet Protection: protect cells and worksheets from
erroneous users
*Find and Replace Data
Total Pages
20
Answer Key
N/A
Teaching Duration
N/A

Average Ratings

N/A
Overall Quality:
N/A
Accuracy:
N/A
Practicality:
N/A
Thoroughness:
N/A
Creativity:
N/A
Clarity:
N/A
Total:
0 ratings
COMMENTS AND RATINGS:
Please log in to post a question.
PRODUCT QUESTIONS AND ANSWERS:
$7.00
Digital Download
ADD ONE TO CART
User Rating: 3.9/4.0
 (1 Followers)
$7.00
Digital Download
ADD ONE TO CART
Excel Guide / Handout - Beginner to Advanced Users
Excel Guide / Handout - Beginner to Advanced Users
Excel Guide / Handout - Beginner to Advanced Users
Excel Guide / Handout - Beginner to Advanced Users