ๅฐŠๆ•ฌ็š„ ๅพฎไฟกๆฑ‡็Ž‡๏ผš1ๅ†† โ‰ˆ 0.046166 ๅ…ƒ ๆ”ฏไป˜ๅฎๆฑ‡็Ž‡๏ผš1ๅ†† โ‰ˆ 0.046257ๅ…ƒ [้€€ๅ‡บ็™ปๅฝ•]
SlideShare a Scribd company logo

Excel 2010.01 edited

โ€ขDownload as PPTX, PDFโ€ข
โ€ข
Iris Hershenson
Iris Hershenson

This document provides an overview of key Excel concepts and tasks for beginners, including: - What Excel is used for and the different types of sheets (worksheets and chart sheets) - How to plan a workbook by defining its goal, data requirements, formulas, and appearance - How to enter text, numbers, and formulas into cells - How to modify column and row sizes, insert new columns and rows, and select cell ranges - Common functions like SUM and how to enter them automatically - Different worksheet views for editing, layout, and printing - How to preview and print worksheets while viewing formulas

Education
1 of 20
Tutorial 1: Getting Started with Excel
What is Excel? New Perspectives on Microsoft Excel 2010 2 ,[object Object],[object Object]
Planning a Workbook Use a planning analysis sheet to define: Goal or purpose of workbook Type of data to collect Formulas needed to apply to data you collected and entered Appearance of workbook content New Perspectives on Microsoft Excel 2010 4
Entering Text and Numbers New Perspectives on Microsoft Excel 2010 5 ,[object Object]
To enter multiple lines of text within a cell
Create a line break with Alt + Enter,[object Object]
Working with Columns and Rows New Perspectives on Microsoft Excel 2010 7 ,[object Object]
Drag border to resize
Double-click border to auto-fit
Format the Cells group to specify
Inserting a column or rowExisting columns or rows shift to accommodate
Working with Columns and Rows Inserting a column or row Existing columns or rows shift to accommodate New Perspectives on Microsoft Excel 2010 8
Visual Overview New Perspectives on Microsoft Excel 2010 9
Worksheet Data New Perspectives on Microsoft Excel 2010 10
Working with Cells and Ranges Range reference indicates location and size of a cell range Adjacent (A1:G5) Nonadjacent (A1:A5;F1:G5) Selecting a range Work with all cells in the range as a group Moving and copying a range Drag and drop Cut and paste New Perspectives on Microsoft Excel 2010 11
Working with Formulas Formula An expression that returns a value Written using operators that combine different values, resulting in a single displayed value New Perspectives on Microsoft Excel 2010 12
Working with Formulas Order of precedence Set of predefined rules used to determine sequence in which operators are applied in a calculation New Perspectives on Microsoft Excel 2010 13
Working with Formulas Viewing a formula Select cell and review expression displayed in the formula bar Each cell reference is color coded in the formula and corresponding cell in the worksheet New Perspectives on Microsoft Excel 2010 14
Entering a Function New Perspectives on Microsoft Excel 2010 15 Function Named operation that returns a value Simplifies a formula, reducing a long formula into a compact statement; for example, to add values in the range A1:A10: Enter the long formula: =A1+A2+A3+A4+A5+A6+A7+A8+A9+A10 - or - Use the SUM function to accomplish the same thing: =SUM(A1:A10)
Entering Functions with AutoSum New Perspectives on Microsoft Excel 2010 16 ,[object Object]

Recommended

Tutorial 11: Connecting to External Data
Tutorial 11: Connecting to External DataTutorial 11: Connecting to External Data
Tutorial 11: Connecting to External Data
cios135
ย 
Tutorial 5: Excel Tables, PivotTables, and Pivot Charts
Tutorial 5: Excel Tables, PivotTables, and Pivot ChartsTutorial 5: Excel Tables, PivotTables, and Pivot Charts
Tutorial 5: Excel Tables, PivotTables, and Pivot Charts
cios135
ย 
Tutorial 2
Tutorial 2Tutorial 2
Tutorial 2
cios135
ย 
Tutorial 4 Charts and Graphs
Tutorial 4 Charts and GraphsTutorial 4 Charts and Graphs
Tutorial 4 Charts and Graphs
cios135
ย 
Tutorial 6: Multiple Worksheets and Workbooks
Tutorial 6: Multiple Worksheets and WorkbooksTutorial 6: Multiple Worksheets and Workbooks
Tutorial 6: Multiple Worksheets and Workbooks
cios135
ย 
Tutorial 7: Advanced Functions and Conitional Formating
Tutorial 7: Advanced Functions and Conitional FormatingTutorial 7: Advanced Functions and Conitional Formating
Tutorial 7: Advanced Functions and Conitional Formating
cios135
ย 
Tutorial 10: Performing What-IF Analyses
Tutorial 10: Performing What-IF AnalysesTutorial 10: Performing What-IF Analyses
Tutorial 10: Performing What-IF Analyses
cios135
ย 
Tutorial 8: Developing an Excel Application
Tutorial 8: Developing an Excel ApplicationTutorial 8: Developing an Excel Application
Tutorial 8: Developing an Excel Application
cios135
ย 

Recommended

Tutorial 11: Connecting to External Data
Tutorial 11: Connecting to External DataTutorial 11: Connecting to External Data
Tutorial 11: Connecting to External Data
cios135
ย 
Tutorial 5: Excel Tables, PivotTables, and Pivot Charts
Tutorial 5: Excel Tables, PivotTables, and Pivot ChartsTutorial 5: Excel Tables, PivotTables, and Pivot Charts
Tutorial 5: Excel Tables, PivotTables, and Pivot Charts
cios135
ย 
Tutorial 2
Tutorial 2Tutorial 2
Tutorial 2
cios135
ย 
Tutorial 4 Charts and Graphs
Tutorial 4 Charts and GraphsTutorial 4 Charts and Graphs
Tutorial 4 Charts and Graphs
cios135
ย 
Tutorial 6: Multiple Worksheets and Workbooks
Tutorial 6: Multiple Worksheets and WorkbooksTutorial 6: Multiple Worksheets and Workbooks
Tutorial 6: Multiple Worksheets and Workbooks
cios135
ย 
Tutorial 7: Advanced Functions and Conitional Formating
Tutorial 7: Advanced Functions and Conitional FormatingTutorial 7: Advanced Functions and Conitional Formating
Tutorial 7: Advanced Functions and Conitional Formating
cios135
ย 
Tutorial 10: Performing What-IF Analyses
Tutorial 10: Performing What-IF AnalysesTutorial 10: Performing What-IF Analyses
Tutorial 10: Performing What-IF Analyses
cios135
ย 
Tutorial 8: Developing an Excel Application
Tutorial 8: Developing an Excel ApplicationTutorial 8: Developing an Excel Application
Tutorial 8: Developing an Excel Application
cios135
ย 
Tutorial 3 Working with Formulas and Functions
Tutorial 3 Working with Formulas and FunctionsTutorial 3 Working with Formulas and Functions
Tutorial 3 Working with Formulas and Functions
cios135
ย 
MS Excel
MS ExcelMS Excel
MS Excel
Waqas Ghuman
ย 
Excel 2010 Unit B PPT
Excel 2010 Unit B PPTExcel 2010 Unit B PPT
Excel 2010 Unit B PPT
okmomwalking
ย 
Excel.t02
Excel.t02Excel.t02
Excel.t02
shabersham
ย 
Excel.t01
Excel.t01Excel.t01
Excel.t01
shabersham
ย 
Excel.t01
Excel.t01Excel.t01
Excel.t01
cherrybear2014
ย 
Excel.t04
Excel.t04Excel.t04
Excel.t04
shabersham
ย 
2016 ms excel_bm
2016 ms excel_bm2016 ms excel_bm
2016 ms excel_bm
Rajesh Math
ย 
Excel 2007 Unit J
Excel 2007 Unit JExcel 2007 Unit J
Excel 2007 Unit J
Raja Waseem Akhtar
ย 
Chapter.03
Chapter.03Chapter.03
Chapter.03
Program in Interdisciplinary Computing
ย 
Chapter.02
Chapter.02Chapter.02
Chapter.02
Program in Interdisciplinary Computing
ย 
Data Analytics Using MS Excel
Data Analytics Using MS ExcelData Analytics Using MS Excel
Data Analytics Using MS Excel
Rajesh Math
ย 
Quicktip excel
Quicktip excelQuicktip excel
Quicktip excel
Sachin Singh
ย 
Ms Excel 2007 & 2010 Workshop
Ms Excel 2007 & 2010 WorkshopMs Excel 2007 & 2010 Workshop
Ms Excel 2007 & 2010 Workshop
CA Aditya Singhal
ย 
Tutorial Excel
Tutorial ExcelTutorial Excel
Tutorial Excel
soleicita
ย 
Excel.t03
Excel.t03Excel.t03
Excel.t03
shabersham
ย 
Microsoft Excel
Microsoft ExcelMicrosoft Excel
Microsoft Excel
CarloPMarasigan
ย 
Advanced excel 2010 & 2013 updated Terrabiz
Advanced excel 2010 & 2013 updated TerrabizAdvanced excel 2010 & 2013 updated Terrabiz
Advanced excel 2010 & 2013 updated Terrabiz
Ahmed Yasir Khan
ย 
Excel Lesson 1: Excel Basics
Excel Lesson 1: Excel BasicsExcel Lesson 1: Excel Basics
Excel Lesson 1: Excel Basics
Novus Business and IT Training Program
ย 
Excel Crash Course
Excel Crash CourseExcel Crash Course
Excel Crash Course
Michael Olafusi
ย 
Microsoft excel 2010 useful formula & functions
Microsoft excel 2010 useful formula & functionsMicrosoft excel 2010 useful formula & functions
Microsoft excel 2010 useful formula & functions
NR Computer Learning Center
ย 
Excel2010 05-130206153751-phpapp01
Excel2010 05-130206153751-phpapp01Excel2010 05-130206153751-phpapp01
Excel2010 05-130206153751-phpapp01
Vishal Kumar
ย 

More Related Content

What's hot

Tutorial 3 Working with Formulas and Functions
Tutorial 3 Working with Formulas and FunctionsTutorial 3 Working with Formulas and Functions
Tutorial 3 Working with Formulas and Functions
cios135
ย 
MS Excel
MS ExcelMS Excel
MS Excel
Waqas Ghuman
ย 
Excel 2010 Unit B PPT
Excel 2010 Unit B PPTExcel 2010 Unit B PPT
Excel 2010 Unit B PPT
okmomwalking
ย 
Excel.t02
Excel.t02Excel.t02
Excel.t02
shabersham
ย 
Excel.t01
Excel.t01Excel.t01
Excel.t01
shabersham
ย 
Excel.t01
Excel.t01Excel.t01
Excel.t01
cherrybear2014
ย 
Excel.t04
Excel.t04Excel.t04
Excel.t04
shabersham
ย 
2016 ms excel_bm
2016 ms excel_bm2016 ms excel_bm
2016 ms excel_bm
Rajesh Math
ย 
Excel 2007 Unit J
Excel 2007 Unit JExcel 2007 Unit J
Excel 2007 Unit J
Raja Waseem Akhtar
ย 
Chapter.03
Chapter.03Chapter.03
Chapter.03
Program in Interdisciplinary Computing
ย 
Chapter.02
Chapter.02Chapter.02
Chapter.02
Program in Interdisciplinary Computing
ย 
Data Analytics Using MS Excel
Data Analytics Using MS ExcelData Analytics Using MS Excel
Data Analytics Using MS Excel
Rajesh Math
ย 
Quicktip excel
Quicktip excelQuicktip excel
Quicktip excel
Sachin Singh
ย 
Ms Excel 2007 & 2010 Workshop
Ms Excel 2007 & 2010 WorkshopMs Excel 2007 & 2010 Workshop
Ms Excel 2007 & 2010 Workshop
CA Aditya Singhal
ย 
Tutorial Excel
Tutorial ExcelTutorial Excel
Tutorial Excel
soleicita
ย 
Excel.t03
Excel.t03Excel.t03
Excel.t03
shabersham
ย 
Microsoft Excel
Microsoft ExcelMicrosoft Excel
Microsoft Excel
CarloPMarasigan
ย 
Advanced excel 2010 & 2013 updated Terrabiz
Advanced excel 2010 & 2013 updated TerrabizAdvanced excel 2010 & 2013 updated Terrabiz
Advanced excel 2010 & 2013 updated Terrabiz
Ahmed Yasir Khan
ย 
Excel Lesson 1: Excel Basics
Excel Lesson 1: Excel BasicsExcel Lesson 1: Excel Basics
Excel Lesson 1: Excel Basics
Novus Business and IT Training Program
ย 
Excel Crash Course
Excel Crash CourseExcel Crash Course
Excel Crash Course
Michael Olafusi
ย 

What's hot (20)

Tutorial 3 Working with Formulas and Functions
Tutorial 3 Working with Formulas and FunctionsTutorial 3 Working with Formulas and Functions
Tutorial 3 Working with Formulas and Functions
ย 
MS Excel
MS ExcelMS Excel
MS Excel
ย 
Excel 2010 Unit B PPT
Excel 2010 Unit B PPTExcel 2010 Unit B PPT
Excel 2010 Unit B PPT
ย 
Excel.t02
Excel.t02Excel.t02
Excel.t02
ย 
Excel.t01
Excel.t01Excel.t01
Excel.t01
ย 
Excel.t01
Excel.t01Excel.t01
Excel.t01
ย 
Excel.t04
Excel.t04Excel.t04
Excel.t04
ย 
2016 ms excel_bm
2016 ms excel_bm2016 ms excel_bm
2016 ms excel_bm
ย 
Excel 2007 Unit J
Excel 2007 Unit JExcel 2007 Unit J
Excel 2007 Unit J
ย 
Chapter.03
Chapter.03Chapter.03
Chapter.03
ย 
Chapter.02
Chapter.02Chapter.02
Chapter.02
ย 
Data Analytics Using MS Excel
Data Analytics Using MS ExcelData Analytics Using MS Excel
Data Analytics Using MS Excel
ย 
Quicktip excel
Quicktip excelQuicktip excel
Quicktip excel
ย 
Ms Excel 2007 & 2010 Workshop
Ms Excel 2007 & 2010 WorkshopMs Excel 2007 & 2010 Workshop
Ms Excel 2007 & 2010 Workshop
ย 
Tutorial Excel
Tutorial ExcelTutorial Excel
Tutorial Excel
ย 
Excel.t03
Excel.t03Excel.t03
Excel.t03
ย 
Microsoft Excel
Microsoft ExcelMicrosoft Excel
Microsoft Excel
ย 
Advanced excel 2010 & 2013 updated Terrabiz
Advanced excel 2010 & 2013 updated TerrabizAdvanced excel 2010 & 2013 updated Terrabiz
Advanced excel 2010 & 2013 updated Terrabiz
ย 
Excel Lesson 1: Excel Basics
Excel Lesson 1: Excel BasicsExcel Lesson 1: Excel Basics
Excel Lesson 1: Excel Basics
ย 
Excel Crash Course
Excel Crash CourseExcel Crash Course
Excel Crash Course
ย 

Viewers also liked

Microsoft excel 2010 useful formula & functions
Microsoft excel 2010 useful formula & functionsMicrosoft excel 2010 useful formula & functions
Microsoft excel 2010 useful formula & functions
NR Computer Learning Center
ย 
Excel2010 05-130206153751-phpapp01
Excel2010 05-130206153751-phpapp01Excel2010 05-130206153751-phpapp01
Excel2010 05-130206153751-phpapp01
Vishal Kumar
ย 
09 Fine-tuning Assignment Details
09 Fine-tuning Assignment Details09 Fine-tuning Assignment Details
09 Fine-tuning Assignment Details
Soe Naing Win
ย 
12 Tracking Progress on Tasks and Assignments
12 Tracking Progress on Tasks and Assignments12 Tracking Progress on Tasks and Assignments
12 Tracking Progress on Tasks and Assignments
Soe Naing Win
ย 
10 Fine-tuning Project Plan
10 Fine-tuning Project Plan10 Fine-tuning Project Plan
10 Fine-tuning Project Plan
Soe Naing Win
ย 
08 Fine-Tuning Resource Details
08 Fine-Tuning Resource Details08 Fine-Tuning Resource Details
08 Fine-Tuning Resource Details
Soe Naing Win
ย 
05 Formatting and Sharing Your Plan
05 Formatting and Sharing Your Plan 05 Formatting and Sharing Your Plan
05 Formatting and Sharing Your Plan
Soe Naing Win
ย 
03 Setting-up resources
03 Setting-up resources 03 Setting-up resources
03 Setting-up resources
Soe Naing Win
ย 
11 Organizing Project Details
11 Organizing Project Details11 Organizing Project Details
11 Organizing Project Details
Soe Naing Win
ย 
02 Creating A Task List
02 Creating A Task List02 Creating A Task List
02 Creating A Task List
Soe Naing Win
ย 
06 Tracking Progress on Tasks
06 Tracking Progress on Tasks06 Tracking Progress on Tasks
06 Tracking Progress on Tasks
Soe Naing Win
ย 
MS Excel Ch 2 PPT
MS Excel Ch 2 PPTMS Excel Ch 2 PPT
MS Excel Ch 2 PPT
prsmith72
ย 
Excel 2010
Excel 2010Excel 2010
Excel 2010
nhumar
ย 
Microsoft Excel 2010 - Fast Course v2
Microsoft Excel 2010 - Fast Course v2Microsoft Excel 2010 - Fast Course v2
Microsoft Excel 2010 - Fast Course v2
Thanasis Tsirogiannis, MSc, CCNA, MCSA
ย 
Microsoft Excel 2010
Microsoft Excel 2010Microsoft Excel 2010
Microsoft Excel 2010
francisco estrada ordoรฑez
ย 
A practical tutorial to excel
A practical tutorial to excelA practical tutorial to excel
A practical tutorial to excel
Munna India
ย 
Excel 2010 training presentation create your first spreadsheet (revised)
Excel 2010 training presentation create your first spreadsheet (revised)Excel 2010 training presentation create your first spreadsheet (revised)
Excel 2010 training presentation create your first spreadsheet (revised)
MFMinickiello
ย 
Management productivity tools1
Management productivity tools1Management productivity tools1
Management productivity tools1
Hari Krishnan
ย 
07 Fine-tuning Task Details
07 Fine-tuning Task Details07 Fine-tuning Task Details
07 Fine-tuning Task Details
Soe Naing Win
ย 
Excel Chapter 1
Excel Chapter 1Excel Chapter 1
Excel Chapter 1
mindysholder
ย 

Viewers also liked (20)

Microsoft excel 2010 useful formula & functions
Microsoft excel 2010 useful formula & functionsMicrosoft excel 2010 useful formula & functions
Microsoft excel 2010 useful formula & functions
ย 
Excel2010 05-130206153751-phpapp01
Excel2010 05-130206153751-phpapp01Excel2010 05-130206153751-phpapp01
Excel2010 05-130206153751-phpapp01
ย 
09 Fine-tuning Assignment Details
09 Fine-tuning Assignment Details09 Fine-tuning Assignment Details
09 Fine-tuning Assignment Details
ย 
12 Tracking Progress on Tasks and Assignments
12 Tracking Progress on Tasks and Assignments12 Tracking Progress on Tasks and Assignments
12 Tracking Progress on Tasks and Assignments
ย 
10 Fine-tuning Project Plan
10 Fine-tuning Project Plan10 Fine-tuning Project Plan
10 Fine-tuning Project Plan
ย 
08 Fine-Tuning Resource Details
08 Fine-Tuning Resource Details08 Fine-Tuning Resource Details
08 Fine-Tuning Resource Details
ย 
05 Formatting and Sharing Your Plan
05 Formatting and Sharing Your Plan 05 Formatting and Sharing Your Plan
05 Formatting and Sharing Your Plan
ย 
03 Setting-up resources
03 Setting-up resources 03 Setting-up resources
03 Setting-up resources
ย 
11 Organizing Project Details
11 Organizing Project Details11 Organizing Project Details
11 Organizing Project Details
ย 
02 Creating A Task List
02 Creating A Task List02 Creating A Task List
02 Creating A Task List
ย 
06 Tracking Progress on Tasks
06 Tracking Progress on Tasks06 Tracking Progress on Tasks
06 Tracking Progress on Tasks
ย 
MS Excel Ch 2 PPT
MS Excel Ch 2 PPTMS Excel Ch 2 PPT
MS Excel Ch 2 PPT
ย 
Excel 2010
Excel 2010Excel 2010
Excel 2010
ย 
Microsoft Excel 2010 - Fast Course v2
Microsoft Excel 2010 - Fast Course v2Microsoft Excel 2010 - Fast Course v2
Microsoft Excel 2010 - Fast Course v2
ย 
Microsoft Excel 2010
Microsoft Excel 2010Microsoft Excel 2010
Microsoft Excel 2010
ย 
A practical tutorial to excel
A practical tutorial to excelA practical tutorial to excel
A practical tutorial to excel
ย 
Excel 2010 training presentation create your first spreadsheet (revised)
Excel 2010 training presentation create your first spreadsheet (revised)Excel 2010 training presentation create your first spreadsheet (revised)
Excel 2010 training presentation create your first spreadsheet (revised)
ย 
Management productivity tools1
Management productivity tools1Management productivity tools1
Management productivity tools1
ย 
07 Fine-tuning Task Details
07 Fine-tuning Task Details07 Fine-tuning Task Details
07 Fine-tuning Task Details
ย 
Excel Chapter 1
Excel Chapter 1Excel Chapter 1
Excel Chapter 1
ย 

Similar to Excel 2010.01 edited

MS Excel Ch 1 PPT
MS Excel Ch 1 PPTMS Excel Ch 1 PPT
MS Excel Ch 1 PPT
prsmith72
ย 
Excel 2007 Unit A
Excel 2007 Unit AExcel 2007 Unit A
Excel 2007 Unit A
ALBAKRI MOHAMMAD
ย 
Excel for research
Excel for researchExcel for research
Excel for research
JamalBhai
ย 
CAP Excel Formulas & Functions July - Copy (4).pdf
CAP Excel Formulas & Functions July - Copy (4).pdfCAP Excel Formulas & Functions July - Copy (4).pdf
CAP Excel Formulas & Functions July - Copy (4).pdf
frp60658
ย 
Tech training workshop 3 final 090810
Tech training workshop 3 final 090810Tech training workshop 3 final 090810
Tech training workshop 3 final 090810
New York State Council on the Arts
ย 
Windows, MS office.pptx
Windows, MS office.pptxWindows, MS office.pptx
Windows, MS office.pptx
Neena Naidu
ย 
Chapter.05
Chapter.05Chapter.05
Chapter.05
klivsie
ย 
Chapter.05
Chapter.05Chapter.05
Chapter.05
jdswitzer
ย 
Windows, MS office.pptx
Windows, MS office.pptxWindows, MS office.pptx
Windows, MS office.pptx
Neena Naidu
ย 
Excel.pptx
Excel.pptxExcel.pptx
Excel.pptx
NargesAlizada1
ย 
Excel 2007 Unit B
Excel 2007 Unit BExcel 2007 Unit B
Excel 2007 Unit B
Raja Waseem Akhtar
ย 
G10 Unit 4.pptx
G10 Unit 4.pptxG10 Unit 4.pptx
G10 Unit 4.pptx
abdulwehab2
ย 
Lesson 27 - Excel Lesson 13.pptx
Lesson 27 - Excel Lesson 13.pptxLesson 27 - Excel Lesson 13.pptx
Lesson 27 - Excel Lesson 13.pptx
rubben7
ย 
Excel 2007 Unit B
Excel 2007 Unit BExcel 2007 Unit B
Excel 2007 Unit B
ALBAKRI MOHAMMAD
ย 
Chapter.01
Chapter.01Chapter.01
Chapter.01
Program in Interdisciplinary Computing
ย 
Microsoft Excel Training
Microsoft Excel TrainingMicrosoft Excel Training
Microsoft Excel Training
HudaRaghibKadhim
ย 
Ms excel 2016_function
Ms excel 2016_functionMs excel 2016_function
Ms excel 2016_function
Paktia University
ย 
Ms excell
Ms excellMs excell
Ms excell
usmankhaliq6
ย 
MS EXCEL
MS EXCELMS EXCEL
MS EXCEL
syed_umar
ย 
It presentation
It presentationIt presentation
It presentation
mithu mehr
ย 

Similar to Excel 2010.01 edited (20)

MS Excel Ch 1 PPT
MS Excel Ch 1 PPTMS Excel Ch 1 PPT
MS Excel Ch 1 PPT
ย 
Excel 2007 Unit A
Excel 2007 Unit AExcel 2007 Unit A
Excel 2007 Unit A
ย 
Excel for research
Excel for researchExcel for research
Excel for research
ย 
CAP Excel Formulas & Functions July - Copy (4).pdf
CAP Excel Formulas & Functions July - Copy (4).pdfCAP Excel Formulas & Functions July - Copy (4).pdf
CAP Excel Formulas & Functions July - Copy (4).pdf
ย 
Tech training workshop 3 final 090810
Tech training workshop 3 final 090810Tech training workshop 3 final 090810
Tech training workshop 3 final 090810
ย 
Windows, MS office.pptx
Windows, MS office.pptxWindows, MS office.pptx
Windows, MS office.pptx
ย 
Chapter.05
Chapter.05Chapter.05
Chapter.05
ย 
Chapter.05
Chapter.05Chapter.05
Chapter.05
ย 
Windows, MS office.pptx
Windows, MS office.pptxWindows, MS office.pptx
Windows, MS office.pptx
ย 
Excel.pptx
Excel.pptxExcel.pptx
Excel.pptx
ย 
Excel 2007 Unit B
Excel 2007 Unit BExcel 2007 Unit B
Excel 2007 Unit B
ย 
G10 Unit 4.pptx
G10 Unit 4.pptxG10 Unit 4.pptx
G10 Unit 4.pptx
ย 
Lesson 27 - Excel Lesson 13.pptx
Lesson 27 - Excel Lesson 13.pptxLesson 27 - Excel Lesson 13.pptx
Lesson 27 - Excel Lesson 13.pptx
ย 
Excel 2007 Unit B
Excel 2007 Unit BExcel 2007 Unit B
Excel 2007 Unit B
ย 
Chapter.01
Chapter.01Chapter.01
Chapter.01
ย 
Microsoft Excel Training
Microsoft Excel TrainingMicrosoft Excel Training
Microsoft Excel Training
ย 
Ms excel 2016_function
Ms excel 2016_functionMs excel 2016_function
Ms excel 2016_function
ย 
Ms excell
Ms excellMs excell
Ms excell
ย 
MS EXCEL
MS EXCELMS EXCEL
MS EXCEL
ย 
It presentation
It presentationIt presentation
It presentation
ย 

More from Iris Hershenson

Introduction to the Internet
Introduction to the InternetIntroduction to the Internet
Introduction to the Internet
Iris Hershenson
ย 
CIS101 team_projectguidelines_spring_12
CIS101 team_projectguidelines_spring_12CIS101 team_projectguidelines_spring_12
CIS101 team_projectguidelines_spring_12
Iris Hershenson
ย 
CIS101 team_projectguidelines_spring_11
CIS101 team_projectguidelines_spring_11CIS101 team_projectguidelines_spring_11
CIS101 team_projectguidelines_spring_11
Iris Hershenson
ย 
E portfolio guide how to upload and manage files
E portfolio guide how to upload and manage filesE portfolio guide how to upload and manage files
E portfolio guide how to upload and manage files
Iris Hershenson
ย 
E portfolio guide logging in and getting started
E portfolio guide logging in and getting startedE portfolio guide logging in and getting started
E portfolio guide logging in and getting started
Iris Hershenson
ย 
CIS101 course-schedule-spring-2012
CIS101 course-schedule-spring-2012CIS101 course-schedule-spring-2012
CIS101 course-schedule-spring-2012
Iris Hershenson
ย 
10 5-11 client game-plan for jane howland feedback
10 5-11 client game-plan for jane howland feedback10 5-11 client game-plan for jane howland feedback
10 5-11 client game-plan for jane howland feedback
Iris Hershenson
ย 
Discovering the internet
Discovering the internetDiscovering the internet
Discovering the internet
Iris Hershenson
ย 
Cis 101 team_projectguidelines_fall_11
Cis 101 team_projectguidelines_fall_11Cis 101 team_projectguidelines_fall_11
Cis 101 team_projectguidelines_fall_11
Iris Hershenson
ย 
CIS101 course-schedule-fall-2011
CIS101 course-schedule-fall-2011CIS101 course-schedule-fall-2011
CIS101 course-schedule-fall-2011
Iris Hershenson
ย 
Student instructions for logging into sam
Student instructions for logging into samStudent instructions for logging into sam
Student instructions for logging into sam
Iris Hershenson
ย 
Excel 2010.01 edited
Excel 2010.01 editedExcel 2010.01 edited
Excel 2010.01 edited
Iris Hershenson
ย 
Getting Started With Office_2010
Getting Started With Office_2010Getting Started With Office_2010
Getting Started With Office_2010
Iris Hershenson
ย 
Getting started office_2010
Getting started office_2010Getting started office_2010
Getting started office_2010
Iris Hershenson
ย 

More from Iris Hershenson (14)

Introduction to the Internet
Introduction to the InternetIntroduction to the Internet
Introduction to the Internet
ย 
CIS101 team_projectguidelines_spring_12
CIS101 team_projectguidelines_spring_12CIS101 team_projectguidelines_spring_12
CIS101 team_projectguidelines_spring_12
ย 
CIS101 team_projectguidelines_spring_11
CIS101 team_projectguidelines_spring_11CIS101 team_projectguidelines_spring_11
CIS101 team_projectguidelines_spring_11
ย 
E portfolio guide how to upload and manage files
E portfolio guide how to upload and manage filesE portfolio guide how to upload and manage files
E portfolio guide how to upload and manage files
ย 
E portfolio guide logging in and getting started
E portfolio guide logging in and getting startedE portfolio guide logging in and getting started
E portfolio guide logging in and getting started
ย 
CIS101 course-schedule-spring-2012
CIS101 course-schedule-spring-2012CIS101 course-schedule-spring-2012
CIS101 course-schedule-spring-2012
ย 
10 5-11 client game-plan for jane howland feedback
10 5-11 client game-plan for jane howland feedback10 5-11 client game-plan for jane howland feedback
10 5-11 client game-plan for jane howland feedback
ย 
Discovering the internet
Discovering the internetDiscovering the internet
Discovering the internet
ย 
Cis 101 team_projectguidelines_fall_11
Cis 101 team_projectguidelines_fall_11Cis 101 team_projectguidelines_fall_11
Cis 101 team_projectguidelines_fall_11
ย 
CIS101 course-schedule-fall-2011
CIS101 course-schedule-fall-2011CIS101 course-schedule-fall-2011
CIS101 course-schedule-fall-2011
ย 
Student instructions for logging into sam
Student instructions for logging into samStudent instructions for logging into sam
Student instructions for logging into sam
ย 
Excel 2010.01 edited
Excel 2010.01 editedExcel 2010.01 edited
Excel 2010.01 edited
ย 
Getting Started With Office_2010
Getting Started With Office_2010Getting Started With Office_2010
Getting Started With Office_2010
ย 
Getting started office_2010
Getting started office_2010Getting started office_2010
Getting started office_2010
ย 

Recently uploaded

pol sci Election and Representation Class 11 Notes.pdf
pol sci Election and Representation Class 11 Notes.pdfpol sci Election and Representation Class 11 Notes.pdf
pol sci Election and Representation Class 11 Notes.pdf
BiplabHalder13
ย 
78 Microsoft-Publisher - Sirin Sultana Bora.pptx
78 Microsoft-Publisher - Sirin Sultana Bora.pptx78 Microsoft-Publisher - Sirin Sultana Bora.pptx
78 Microsoft-Publisher - Sirin Sultana Bora.pptx
Kalna College
ย 
The basics of sentences session 8pptx.pptx
The basics of sentences session 8pptx.pptxThe basics of sentences session 8pptx.pptx
The basics of sentences session 8pptx.pptx
heathfieldcps1
ย 
Creation or Update of a Mandatory Field is Not Set in Odoo 17
Creation or Update of a Mandatory Field is Not Set in Odoo 17Creation or Update of a Mandatory Field is Not Set in Odoo 17
Creation or Update of a Mandatory Field is Not Set in Odoo 17
Celine George
ย 
Decolonizing Universal Design for Learning
Decolonizing Universal Design for LearningDecolonizing Universal Design for Learning
Decolonizing Universal Design for Learning
Frederic Fovet
ย 
Get Success with the Latest UiPath UIPATH-ADPV1 Exam Dumps (V11.02) 2024
Get Success with the Latest UiPath UIPATH-ADPV1 Exam Dumps (V11.02) 2024Get Success with the Latest UiPath UIPATH-ADPV1 Exam Dumps (V11.02) 2024
Get Success with the Latest UiPath UIPATH-ADPV1 Exam Dumps (V11.02) 2024
yarusun
ย 
220711130097 Tulip Samanta Concept of Information and Communication Technology
220711130097 Tulip Samanta Concept of Information and Communication Technology220711130097 Tulip Samanta Concept of Information and Communication Technology
220711130097 Tulip Samanta Concept of Information and Communication Technology
Kalna College
ย 
bryophytes.pptx bsc botany honours second semester
bryophytes.pptx bsc botany honours second semesterbryophytes.pptx bsc botany honours second semester
bryophytes.pptx bsc botany honours second semester
Sarojini38
ย 
220711130083 SUBHASHREE RAKSHIT Internet resources for social science
220711130083 SUBHASHREE RAKSHIT Internet resources for social science220711130083 SUBHASHREE RAKSHIT Internet resources for social science
220711130083 SUBHASHREE RAKSHIT Internet resources for social science
Kalna College
ย 
What are the new features in the Fleet Odoo 17
What are the new features in the Fleet Odoo 17What are the new features in the Fleet Odoo 17
What are the new features in the Fleet Odoo 17
Celine George
ย 
8+8+8 Rule Of Time Management For Better Productivity
8+8+8 Rule Of Time Management For Better Productivity8+8+8 Rule Of Time Management For Better Productivity
8+8+8 Rule Of Time Management For Better Productivity
RuchiRathor2
ย 
nutrition in plants chapter 1 class 7...
nutrition in plants chapter 1 class 7...nutrition in plants chapter 1 class 7...
nutrition in plants chapter 1 class 7...
chaudharyreet2244
ย 
220711130095 Tanu Pandey message currency, communication speed & control EPC ...
220711130095 Tanu Pandey message currency, communication speed & control EPC ...220711130095 Tanu Pandey message currency, communication speed & control EPC ...
220711130095 Tanu Pandey message currency, communication speed & control EPC ...
Kalna College
ย 
Information and Communication Technology in Education
Information and Communication Technology in EducationInformation and Communication Technology in Education
Information and Communication Technology in Education
MJDuyan
ย 
managing Behaviour in early childhood education.pptx
managing Behaviour in early childhood education.pptxmanaging Behaviour in early childhood education.pptx
managing Behaviour in early childhood education.pptx
nabaegha
ย 
Bแป˜ Bร€I TแบฌP TEST THEO UNIT - FORM 2025 - TIแบพNG ANH 12 GLOBAL SUCCESS - KรŒ 1 (B...
Bแป˜ Bร€I TแบฌP TEST THEO UNIT - FORM 2025 - TIแบพNG ANH 12 GLOBAL SUCCESS - KรŒ 1 (B...Bแป˜ Bร€I TแบฌP TEST THEO UNIT - FORM 2025 - TIแบพNG ANH 12 GLOBAL SUCCESS - KรŒ 1 (B...
Bแป˜ Bร€I TแบฌP TEST THEO UNIT - FORM 2025 - TIแบพNG ANH 12 GLOBAL SUCCESS - KรŒ 1 (B...
Nguyen Thanh Tu Collection
ย 
Opportunity scholarships and the schools that receive them
Opportunity scholarships and the schools that receive themOpportunity scholarships and the schools that receive them
Opportunity scholarships and the schools that receive them
EducationNC
ย 
Accounting for Restricted Grants When and How To Record Properly
Accounting for Restricted Grants When and How To Record ProperlyAccounting for Restricted Grants When and How To Record Properly
Accounting for Restricted Grants When and How To Record Properly
TechSoup
ย 
INTRODUCTION TO HOSPITALS & AND ITS ORGANIZATION
INTRODUCTION TO HOSPITALS & AND ITS ORGANIZATION INTRODUCTION TO HOSPITALS & AND ITS ORGANIZATION
INTRODUCTION TO HOSPITALS & AND ITS ORGANIZATION
ShwetaGawande8
ย 
The Rise of the Digital Telecommunication Marketplace.pptx
The Rise of the Digital Telecommunication Marketplace.pptxThe Rise of the Digital Telecommunication Marketplace.pptx
The Rise of the Digital Telecommunication Marketplace.pptx
PriyaKumari928991
ย 

Recently uploaded (20)

pol sci Election and Representation Class 11 Notes.pdf
pol sci Election and Representation Class 11 Notes.pdfpol sci Election and Representation Class 11 Notes.pdf
pol sci Election and Representation Class 11 Notes.pdf
ย 
78 Microsoft-Publisher - Sirin Sultana Bora.pptx
78 Microsoft-Publisher - Sirin Sultana Bora.pptx78 Microsoft-Publisher - Sirin Sultana Bora.pptx
78 Microsoft-Publisher - Sirin Sultana Bora.pptx
ย 
The basics of sentences session 8pptx.pptx
The basics of sentences session 8pptx.pptxThe basics of sentences session 8pptx.pptx
The basics of sentences session 8pptx.pptx
ย 
Creation or Update of a Mandatory Field is Not Set in Odoo 17
Creation or Update of a Mandatory Field is Not Set in Odoo 17Creation or Update of a Mandatory Field is Not Set in Odoo 17
Creation or Update of a Mandatory Field is Not Set in Odoo 17
ย 
Decolonizing Universal Design for Learning
Decolonizing Universal Design for LearningDecolonizing Universal Design for Learning
Decolonizing Universal Design for Learning
ย 
Get Success with the Latest UiPath UIPATH-ADPV1 Exam Dumps (V11.02) 2024
Get Success with the Latest UiPath UIPATH-ADPV1 Exam Dumps (V11.02) 2024Get Success with the Latest UiPath UIPATH-ADPV1 Exam Dumps (V11.02) 2024
Get Success with the Latest UiPath UIPATH-ADPV1 Exam Dumps (V11.02) 2024
ย 
220711130097 Tulip Samanta Concept of Information and Communication Technology
220711130097 Tulip Samanta Concept of Information and Communication Technology220711130097 Tulip Samanta Concept of Information and Communication Technology
220711130097 Tulip Samanta Concept of Information and Communication Technology
ย 
bryophytes.pptx bsc botany honours second semester
bryophytes.pptx bsc botany honours second semesterbryophytes.pptx bsc botany honours second semester
bryophytes.pptx bsc botany honours second semester
ย 
220711130083 SUBHASHREE RAKSHIT Internet resources for social science
220711130083 SUBHASHREE RAKSHIT Internet resources for social science220711130083 SUBHASHREE RAKSHIT Internet resources for social science
220711130083 SUBHASHREE RAKSHIT Internet resources for social science
ย 
What are the new features in the Fleet Odoo 17
What are the new features in the Fleet Odoo 17What are the new features in the Fleet Odoo 17
What are the new features in the Fleet Odoo 17
ย 
8+8+8 Rule Of Time Management For Better Productivity
8+8+8 Rule Of Time Management For Better Productivity8+8+8 Rule Of Time Management For Better Productivity
8+8+8 Rule Of Time Management For Better Productivity
ย 
nutrition in plants chapter 1 class 7...
nutrition in plants chapter 1 class 7...nutrition in plants chapter 1 class 7...
nutrition in plants chapter 1 class 7...
ย 
220711130095 Tanu Pandey message currency, communication speed & control EPC ...
220711130095 Tanu Pandey message currency, communication speed & control EPC ...220711130095 Tanu Pandey message currency, communication speed & control EPC ...
220711130095 Tanu Pandey message currency, communication speed & control EPC ...
ย 
Information and Communication Technology in Education
Information and Communication Technology in EducationInformation and Communication Technology in Education
Information and Communication Technology in Education
ย 
managing Behaviour in early childhood education.pptx
managing Behaviour in early childhood education.pptxmanaging Behaviour in early childhood education.pptx
managing Behaviour in early childhood education.pptx
ย 
Bแป˜ Bร€I TแบฌP TEST THEO UNIT - FORM 2025 - TIแบพNG ANH 12 GLOBAL SUCCESS - KรŒ 1 (B...
Bแป˜ Bร€I TแบฌP TEST THEO UNIT - FORM 2025 - TIแบพNG ANH 12 GLOBAL SUCCESS - KรŒ 1 (B...Bแป˜ Bร€I TแบฌP TEST THEO UNIT - FORM 2025 - TIแบพNG ANH 12 GLOBAL SUCCESS - KรŒ 1 (B...
Bแป˜ Bร€I TแบฌP TEST THEO UNIT - FORM 2025 - TIแบพNG ANH 12 GLOBAL SUCCESS - KรŒ 1 (B...
ย 
Opportunity scholarships and the schools that receive them
Opportunity scholarships and the schools that receive themOpportunity scholarships and the schools that receive them
Opportunity scholarships and the schools that receive them
ย 
Accounting for Restricted Grants When and How To Record Properly
Accounting for Restricted Grants When and How To Record ProperlyAccounting for Restricted Grants When and How To Record Properly
Accounting for Restricted Grants When and How To Record Properly
ย 
INTRODUCTION TO HOSPITALS & AND ITS ORGANIZATION
INTRODUCTION TO HOSPITALS & AND ITS ORGANIZATION INTRODUCTION TO HOSPITALS & AND ITS ORGANIZATION
INTRODUCTION TO HOSPITALS & AND ITS ORGANIZATION
ย 
The Rise of the Digital Telecommunication Marketplace.pptx
The Rise of the Digital Telecommunication Marketplace.pptxThe Rise of the Digital Telecommunication Marketplace.pptx
The Rise of the Digital Telecommunication Marketplace.pptx
ย 

Excel 2010.01 edited

  • 1. Tutorial 1: Getting Started with Excel
  • 2.
  • 3. Planning a Workbook Use a planning analysis sheet to define: Goal or purpose of workbook Type of data to collect Formulas needed to apply to data you collected and entered Appearance of workbook content New Perspectives on Microsoft Excel 2010 4
  • 4.
  • 5. To enter multiple lines of text within a cell
  • 6.
  • 7.
  • 10. Format the Cells group to specify
  • 11. Inserting a column or rowExisting columns or rows shift to accommodate
  • 12. Working with Columns and Rows Inserting a column or row Existing columns or rows shift to accommodate New Perspectives on Microsoft Excel 2010 8
  • 13. Visual Overview New Perspectives on Microsoft Excel 2010 9
  • 14. Worksheet Data New Perspectives on Microsoft Excel 2010 10
  • 15. Working with Cells and Ranges Range reference indicates location and size of a cell range Adjacent (A1:G5) Nonadjacent (A1:A5;F1:G5) Selecting a range Work with all cells in the range as a group Moving and copying a range Drag and drop Cut and paste New Perspectives on Microsoft Excel 2010 11
  • 16. Working with Formulas Formula An expression that returns a value Written using operators that combine different values, resulting in a single displayed value New Perspectives on Microsoft Excel 2010 12
  • 17. Working with Formulas Order of precedence Set of predefined rules used to determine sequence in which operators are applied in a calculation New Perspectives on Microsoft Excel 2010 13
  • 18. Working with Formulas Viewing a formula Select cell and review expression displayed in the formula bar Each cell reference is color coded in the formula and corresponding cell in the worksheet New Perspectives on Microsoft Excel 2010 14
  • 19. Entering a Function New Perspectives on Microsoft Excel 2010 15 Function Named operation that returns a value Simplifies a formula, reducing a long formula into a compact statement; for example, to add values in the range A1:A10: Enter the long formula: =A1+A2+A3+A4+A5+A6+A7+A8+A9+A10 - or - Use the SUM function to accomplish the same thing: =SUM(A1:A10)
  • 20.
  • 21. Sum of values in column or row (SUM)
  • 22. Average value in column or row (AVERAGE)
  • 23. Total count of numeric values in column or row (COUNT)
  • 24. Minimum value in column or row (MIN)
  • 25.
  • 28.
  • 29. Viewing and Printing Worksheet Formulas Switch to formula view Useful when you encounter unexpected results and want to examine underlying formulas or to discuss your formulas with a colleague New Perspectives on Microsoft Excel 2010 19
  • 30. Viewing and Printing Worksheet Formulas Scaling the printout of a worksheet forces contents to fit on a single page New Perspectives on Microsoft Excel 2010 20
  ็ฟป่ฏ‘๏ผš