Weebly Log into http cmccoy 3 ces weebly
![Weebly Log into http: //cmccoy 3 ces. weebly. com/ Click: Excel Weebly Log into http: //cmccoy 3 ces. weebly. com/ Click: Excel](https://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-1.jpg)
Weebly Log into http: //cmccoy 3 ces. weebly. com/ Click: Excel
![](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-2.jpg)
![Excel Basic Excel Basic](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-3.jpg)
Excel Basic
![Carolyn Mc. Coy Education Technology Teacher STC Lead Carolyn Mc. Coy Education Technology Teacher STC Lead](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-4.jpg)
Carolyn Mc. Coy Education Technology Teacher STC Lead
![Welcome Sign In Sheets Location of restrooms, vending and teacher lounge Food and drink: Welcome Sign In Sheets Location of restrooms, vending and teacher lounge Food and drink:](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-5.jpg)
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 JCPS PD Procedures will be followed Those arriving more than 15 minutes will not](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-6.jpg)
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 Resources HTTP: //WWW. GCFLEARNFREE. ORG/ HTTP: //JCPS. ME/CES](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-7.jpg)
Resources HTTP: //WWW. GCFLEARNFREE. ORG/ HTTP: //JCPS. ME/CES
![Introduction to Excel Introduction to Excel](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-8.jpg)
Introduction to Excel
![What is a Spreadsheet? What is a Spreadsheet?](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-9.jpg)
What is a Spreadsheet?
![What is a Spreadsheet A spreadsheet is a file made of rows and columns What is a Spreadsheet A spreadsheet is a file made of rows and columns](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-10.jpg)
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 Excel Basics: Columns and Rows](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-11.jpg)
Excel Basics: Columns and Rows
![What is a Spreadsheet used for? Although spreadsheets are typically used with anything containing What is a Spreadsheet used for? Although spreadsheets are typically used with anything containing](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-12.jpg)
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, Finance Spreadsheets are ideal for financial data, such as your checking account information, budgets,](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-13.jpg)
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 Forms Form templates can be created to handle inventory, evaluations, performance reviews, quizzes, time](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-14.jpg)
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 School and Grades Teachers can use spreadsheets to track students, calculate grades, and identify](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-15.jpg)
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 Lists Managing a list in a spreadsheet is a great example of data that](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-16.jpg)
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. Sports Spreadsheets can keep track of your favorite player stats on the whole team.](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-17.jpg)
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 You should be logged onto computer](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-18.jpg)
You should be logged onto computer
![Pinning Excel to the Taskbar Pinning Excel to the Taskbar](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-19.jpg)
Pinning Excel to the Taskbar
![Open Excel START Menu Open Excel START Menu](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-20.jpg)
Open Excel START Menu
![Review Templates Recent Items are listed below Review Templates Recent Items are listed below](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-21.jpg)
Review Templates Recent Items are listed below
![Menus Menus](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-22.jpg)
Menus
![Excel Basics: Columns and Rows Excel Basics: Columns and Rows](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-23.jpg)
Excel Basics: Columns and Rows
![Entering Information: Headers go in the first row Entering Information: Headers go in the first row](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-24.jpg)
Entering Information: Headers go in the first row
![Example of Headers https: //en. wikipedia. org/wiki/List_of_continents_by_population Example of Headers https: //en. wikipedia. org/wiki/List_of_continents_by_population](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-25.jpg)
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 Go to this site and download file http: //cmccoy 3 ces. weebly. com Click](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-26.jpg)
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
![](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-27.jpg)
![File: Save Enter your name into the save field. IE: Mc. Coy Count. Save File: Save Enter your name into the save field. IE: Mc. Coy Count. Save](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-28.jpg)
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 Moving from cell to cell Move Mouse and click Enter Key Arrow Keys](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-29.jpg)
Moving from cell to cell Move Mouse and click Enter Key Arrow Keys
![Column Width and Row Height Column Width and Row Height](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-30.jpg)
Column Width and Row Height
![Formula A formula always begins with an equal sign. = Formula A formula always begins with an equal sign. =](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-31.jpg)
Formula A formula always begins with an equal sign. =
![Where are the formula keys located on keyboard? + - / * Where are the formula keys located on keyboard? + - / *](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-32.jpg)
Where are the formula keys located on keyboard? + - / *
![Enter numbers Enter numbers](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-33.jpg)
Enter numbers
![Addition + =sum(range) =click+click Addition + =sum(range) =click+click](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-34.jpg)
Addition + =sum(range) =click+click
![Using =click+ click Using =click+ click](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-35.jpg)
Using =click+ click
![=sum() =sum()](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-36.jpg)
=sum()
![Using Copy Right Control R Using Copy Right Control R](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-37.jpg)
Using Copy Right Control R
![Using Drag Down to fill in Using Drag Down to fill in](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-38.jpg)
Using Drag Down to fill in
![Fill down: Control D Fill down: Control D](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-39.jpg)
Fill down: Control D
![Charts Charts](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-40.jpg)
Charts
![What chart is the right one to use? http: //www. dummies. com/software/microsoftoffice/excel/10 -excel-chart-types-and-when-touse-them/ What chart is the right one to use? http: //www. dummies. com/software/microsoftoffice/excel/10 -excel-chart-types-and-when-touse-them/](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-41.jpg)
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 Chart Tools](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-42.jpg)
Chart Tools
![Example of different type of bar graph using Chart Tools. Example of different type of bar graph using Chart Tools.](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-43.jpg)
Example of different type of bar graph using Chart Tools.
![File: Save File: Save](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-44.jpg)
File: Save
![Download file http: //cmccoy 3 ces. weebly. com/ Click: Budget Click: Open Click: Enable Download file http: //cmccoy 3 ces. weebly. com/ Click: Budget Click: Open Click: Enable](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-45.jpg)
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 File: Save Enter your name into the save field. IE: Mc. Coy Budget. Save](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-46.jpg)
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: Add the numbers in Column B In A 10, enter: Total In B 10:](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-47.jpg)
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 §In cell E 1 enter Net income per week. §In cell F 1 enter](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-48.jpg)
§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 Next slide](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-49.jpg)
Dollar Sign Next slide
![Dollar sign Type: $ Dollar sign Type: $](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-50.jpg)
Dollar sign Type: $
![Menu Menu](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-51.jpg)
Menu
![Format Cells Format Cells](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-52.jpg)
Format Cells
![Alignment of Text Alignment of Text](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-53.jpg)
Alignment of Text
![Cell colors, cell borders and format font next slide Cell colors, cell borders and format font next slide](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-54.jpg)
Cell colors, cell borders and format font next slide
![Cell colors, cell borders and format font Cell colors, cell borders and format font](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-55.jpg)
Cell colors, cell borders and format font
![Multiplication * =click*click Multiplication * =click*click](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-56.jpg)
Multiplication * =click*click
![Subtraction - =click-click Subtraction - =click-click](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-57.jpg)
Subtraction - =click-click
![In E 5 enter: Amount Left Over In E 5 enter: Amount Left Over](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-58.jpg)
In E 5 enter: Amount Left Over
![In cell F 5 enter: =F 3 -B 10. Press: Enter In cell F 5 enter: =F 3 -B 10. Press: Enter](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-59.jpg)
In cell F 5 enter: =F 3 -B 10. Press: Enter
![Division / = click/click Division / = click/click](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-60.jpg)
Division / = click/click
![In cell E 11 enter: Amount I have to save per week In cell In cell E 11 enter: Amount I have to save per week In cell](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-61.jpg)
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 Sizing all Columns](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-62.jpg)
Sizing all Columns
![Sort Sort](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-63.jpg)
Sort
![Getting Ready to Print: Page Layout Getting Ready to Print: Page Layout](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-64.jpg)
Getting Ready to Print: Page Layout
![Margins and Orientation Margins and Orientation](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-65.jpg)
Margins and Orientation
![Page Setup Page Setup](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-66.jpg)
Page Setup
![SAVE your work File: Save Or use the Shortcut Menu SAVE your work File: Save Or use the Shortcut Menu](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-67.jpg)
SAVE your work File: Save Or use the Shortcut Menu
![Print Preview File: Print Or Page Setup Print Preview File: Print Or Page Setup](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-68.jpg)
Print Preview File: Print Or Page Setup
![File: Save File: Save](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-69.jpg)
File: Save
![File: Print File: Print](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-70.jpg)
File: Print
![Upload file http: //cmccoy 3 ces. weebly. com/ Click the button: Upload file Drag Upload file http: //cmccoy 3 ces. weebly. com/ Click the button: Upload file Drag](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-71.jpg)
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. The end. Please fill out the evaluation on PD central to earn Credit.](http://slidetodoc.com/presentation_image_h2/61081055fbdfee711dd95d0f96070c60/image-72.jpg)
The end. Please fill out the evaluation on PD central to earn Credit.
- Slides: 72