# Weebly Log into http cmccoy 3 ces weebly

Weebly Log into http: //cmccoy 3 ces. weebly. com/ Click: Excel

Excel Basic

Carolyn Mc. Coy Education Technology Teacher STC Lead

Welcome Sign In Sheets Location of restrooms, vending and teacher lounge Food and drink: Clean up after yourself.

JCPS PD Procedures will be followed Those arriving more than 15 minutes will not admitted. Pets, children and those not employed by JCPS will not be admitted. This is JCPS policy due to liability issues.

Resources HTTP: //WWW. GCFLEARNFREE. ORG/ HTTP: //JCPS. ME/CES

Introduction to Excel

What is a Spreadsheet?

What is a Spreadsheet A spreadsheet is a file made of rows and columns that help sort data, arrange data and calculate numerical data.

Excel Basics: Columns and Rows

What is a Spreadsheet used for? Although spreadsheets are typically used with anything containing numbers, the uses of a spreadsheet are almost endless. Below are some other popular uses of spreadsheets. http: //www. computerhope. com/jargon/s/spreadsh. htm

Finance Spreadsheets are ideal for financial data, such as your checking account information, budgets, transactions, billing, invoices, receipts, forecasts, and any payment system.

Forms Form templates can be created to handle inventory, evaluations, performance reviews, quizzes, time sheets, patient information, and surveys.

School and Grades Teachers can use spreadsheets to track students, calculate grades, and identify relevant data, such as high and low scores, missing tests, and students who are struggling.

Lists Managing a list in a spreadsheet is a great example of data that does not contain numbers, but still can be used in a spreadsheet. Great examples of spreadsheet lists include telephone, to-do, packing for a trip and grocery lists.

Sports Spreadsheets can keep track of your favorite player stats on the whole team. With the collected data, you can also find averages, high scores

You should be logged onto computer

Pinning Excel to the Taskbar

Open Excel START Menu

Review Templates Recent Items are listed below

Menus

Excel Basics: Columns and Rows

Entering Information: Headers go in the first row

Example of Headers https: //en. wikipedia. org/wiki/List_of_continents_by_population

Go to this site and download file http: //cmccoy 3 ces. weebly. com Click on EXCEL Click: Student Count. Click: Open (again) Page Opens: Enable Editing Leave webpage open

File: Save Enter your name into the save field. IE: Mc. Coy Count. Save to Desktop.

Moving from cell to cell Move Mouse and click Enter Key Arrow Keys

Column Width and Row Height

Formula A formula always begins with an equal sign. =

Where are the formula keys located on keyboard? + - / *

Enter numbers

Addition + =sum(range) =click+click

Using =click+ click

=sum()

Using Copy Right Control R

Using Drag Down to fill in

Fill down: Control D

Charts

What chart is the right one to use? http: //www. dummies. com/software/microsoftoffice/excel/10 -excel-chart-types-and-when-touse-them/

Chart Tools

Example of different type of bar graph using Chart Tools.

File: Save

Download file http: //cmccoy 3 ces. weebly. com/ Click: Budget Click: Open Click: Enable Editing Leave webpage open

File: Save Enter your name into the save field. IE: Mc. Coy Budget. Save to Desktop.

Add the numbers in Column B In A 10, enter: Total In B 10: enter: the formula for addition =click+click or =sum(drag)

§In cell E 1 enter Net income per week. §In cell F 1 enter the number 745 §$ §In cell F 2 enter: 4 §In cell E 3 enter: Net Income per Month §In cell F 3 enter the formula for multiplication =F 1*F 2 §Press enter

Dollar Sign Next slide

Dollar sign Type: $

Menu

Format Cells

Alignment of Text

Cell colors, cell borders and format font next slide

Cell colors, cell borders and format font

Multiplication * =click*click

Subtraction - =click-click

In E 5 enter: Amount Left Over

In cell F 5 enter: =F 3 -B 10. Press: Enter

Division / = click/click

In cell E 11 enter: Amount I have to save per week In cell F 11 enter: =B 10/F 2 Press enter.

Sizing all Columns

Sort

Getting Ready to Print: Page Layout

Margins and Orientation

Page Setup

SAVE your work File: Save Or use the Shortcut Menu

Print Preview File: Print Or Page Setup

File: Save

File: Print

Upload file http: //cmccoy 3 ces. weebly. com/ Click the button: Upload file Drag your two Excel practice sheets into the field.

The end. Please fill out the evaluation on PD central to earn Credit.

- Slides: 72