尊敬的 微信汇率:1円 ≈ 0.046166 元 支付宝汇率:1円 ≈ 0.046257元 [退出登录]
SlideShare a Scribd company logo
PIVOT TABLE PRO
LESSON: INTRODUCTION TO EXCEL®
LEVEL: BEGINNER
CONTENTS:
2 Do You Want to Learn Excel?
20 The Excel Program Window
33 The Excel Ribbon
52 Other Program Window Elements
PIVOT TABLE PRO
Find more at
WWW.PIVOTTABLE-PRO.COM
Do you want to learn Excel?
Good move.
Excel is the industry standard spreadsheet
application in government and business.
It’s widely used for home and personal use as well.
Excel helps you store, organize and manipulate data,
perform calculations & analysis,
present results with graphical & statistical tools,
and lots of other stuff too.
What does this mean?
Easily keep track of personal and business finances,
present data clearly and professionally,
save time on record keeping,
and improve productivity & efficiency at work.
Congratulations on taking the first step.
You’ve come to the right place!
Excel is a powerful application for advanced users.
But it’s also simple and intuitive for beginners.
Let’s start by introducing the Excel program window.
By the end of this presentation, you can:
 identify the major features of the Excel window
 understand how buttons are grouped in the Excel Ribbon
 recognise the purpose of each tab in the Excel Ribbon
This is the Excel 2013 Program Window.
SPREADSHEETTRAINER.COM
This is the Excel 2013 Program Window.
It has things in common with other windows. Let’s recap:
The Excel window is bounded by four edges:
With the mouse over the bottom edge, the cursor turns into white
vertical arrows:
Change the window height by clicking and dragging the mouse:
Do the same with the horizontal edge to change the width:
To change the width & height at once place the cursor over a
corner then click and drag:
Excel shows the name of the current file at the top of the window:
And the top-right corner has buttons to minimise…
… and to maximise …
… and to close the window.
Closing the window also closes our file – Excel asks if we want to
save all our great work first, so it doesn’t get lost.
From Excel 2007 onwards, the Ribbon replaced menus as Excel’s
way of showing commands.
The ribbon is made up of multiple Tabs.
The Home Tab includes common tasks for editing and formatting
data.
The Insert Tab is used to add elements such as tables,
illustrations, charts and filters.
The Page Layout Tab is used to layout a page for printing, and to
arrange worksheet elements.
The Formulas Tab is used to insert and check functions and
formulas.
The Data Tab contains buttons to import, sort, filter, manipulate
and analyse data.
The Review Tab is used to proof, protect and comment on
worksheets.
The View Tab is mostly used to change how the worksheet
appears on the screen.
[The Developer Tab is not displayed by default, but contains more
advanced features].
File is a special tab which leads to the Backstage Menu.
The Backstage Menu displays properties, performs file operations
(new/open/save etc.), and other options.
In each tab, the buttons are split into categories called Groups.
i.e. The ‘Home’ groups are: Clipboard, Font, Alignment, etc.
The buttons in each group are called Command Buttons.
Holding the mouse over a command button displays a Tool-Tip: a
pop-up showing more info and a keyboard shortcut for each task.
At the bottom-right corners of many groups are small buttons
called Dialog Box Launchers.
Dialog box launchers open up [1] Task Panes or [2] Dialog Boxes,
with more advanced options for each group.
1
2
If you like you can [1] hide (and then [2] unhide) the ribbon.
You can also hide/unhide the ribbon by double-clicking on any tab.
1
2
As you resize the window the ribbon shrinks and groups together.
Command buttons are then accessed with Drop-Down Menus:
The Quick Access Toolbar contains shortcuts for common tasks.
This can be customized as you wish– more on this in a later video.
The Name Box displays the address of the current cell selection.
The Formula Bar is where you can enter text, numbers, formulas or
functions to the selected cells.
The formula bar can be expanded to accommodate larger entries by
clicking and dragging the mouse:
At the bottom left, the Status Bar tells you the current status of
Excel.
Next to this is a button to record Macros (automated Excel
processes). We cover this in a later video.
At the bottom right, shortcuts let you change how the worksheet
looks on screen – page layout & zoom.
There are vertical and horizontal Scroll Bars which let you navigate
around the worksheet:
And of course – in the middle of it all – is the Worksheet Area!
This is where the magic happens, and is our next topic.
One more thing - when you right-click in the worksheet the Mini
Tool-bar appears, which includes useful shortcuts from the ribbon.
PivotExcel is an independent training program and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation.
Microsoft, Excel, and Windows are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries.
Excel visuals used with permission from Microsoft.
VISIT WWW.PIVOTTABLE-PRO.COM FOR
MORE, INCLUDING A FREE TRIAL!
See more at
PIVOT TABLE PRO
WWW.PIVOTTABLE-PRO.COM

More Related Content

What's hot

Excel for beginner
Excel for beginnerExcel for beginner
Excel for beginner
Shashank Jain
 
Microsoft word 2007
Microsoft word 2007Microsoft word 2007
Microsoft word 2007
John Monyjok
 
Basic Ms excel
Basic Ms excelBasic Ms excel
Basic Ms excel
maharzahid0
 
Ms excel
Ms excelMs excel
MS Word Intermediate Training
MS Word Intermediate TrainingMS Word Intermediate Training
MS Word Intermediate Training
Michael Sheyahshe
 
Ms word 2013
Ms word 2013Ms word 2013
Ms word 2013
mufassirin
 
Microsoft Excel Basics
Microsoft Excel BasicsMicrosoft Excel Basics
Microsoft Excel Basics
Compudon
 
MS EXCEL
MS EXCELMS EXCEL
MS EXCEL
syed_umar
 
Word Lecture 1
Word Lecture 1Word Lecture 1
Word Lecture 1
Christinliao
 
Training On Microsoft Excel
Training On Microsoft ExcelTraining On Microsoft Excel
Training On Microsoft Excel
TimesRide
 
Basic excel training
Basic excel trainingBasic excel training
Basic excel training
Ankur Chaturvedi
 
22 Excel Basics
22 Excel Basics22 Excel Basics
22 Excel Basics
Buffalo Seminary
 
Introduction to MS WORD
Introduction to MS WORDIntroduction to MS WORD
Introduction to MS WORD
Muhammad Irfan
 
Microsoft word tutorial
Microsoft word tutorialMicrosoft word tutorial
Microsoft word tutorial
Michael Hardy
 
Microsoft Powerpoint
Microsoft PowerpointMicrosoft Powerpoint
Microsoft Powerpoint
Jack Frost
 
MS Word Basics Training
MS Word Basics TrainingMS Word Basics Training
MS Word Basics Training
Michael Sheyahshe
 
Microsoft Excel Seminar
Microsoft Excel SeminarMicrosoft Excel Seminar
Microsoft Excel Seminar
Meridian Career Institute
 
Ms excel ppt presentation
Ms excel ppt presentationMs excel ppt presentation
Ms excel ppt presentation
vethics
 
PPT On Microsoft Excel 2007 Full Information.
PPT On Microsoft Excel 2007 Full Information.PPT On Microsoft Excel 2007 Full Information.
PPT On Microsoft Excel 2007 Full Information.
Umesh Kumar
 
Ms excel basic about Data, graph and pivot table
Ms excel basic about Data, graph and pivot table Ms excel basic about Data, graph and pivot table
Ms excel basic about Data, graph and pivot table
Alomgir Hossain
 

What's hot (20)

Excel for beginner
Excel for beginnerExcel for beginner
Excel for beginner
 
Microsoft word 2007
Microsoft word 2007Microsoft word 2007
Microsoft word 2007
 
Basic Ms excel
Basic Ms excelBasic Ms excel
Basic Ms excel
 
Ms excel
Ms excelMs excel
Ms excel
 
MS Word Intermediate Training
MS Word Intermediate TrainingMS Word Intermediate Training
MS Word Intermediate Training
 
Ms word 2013
Ms word 2013Ms word 2013
Ms word 2013
 
Microsoft Excel Basics
Microsoft Excel BasicsMicrosoft Excel Basics
Microsoft Excel Basics
 
MS EXCEL
MS EXCELMS EXCEL
MS EXCEL
 
Word Lecture 1
Word Lecture 1Word Lecture 1
Word Lecture 1
 
Training On Microsoft Excel
Training On Microsoft ExcelTraining On Microsoft Excel
Training On Microsoft Excel
 
Basic excel training
Basic excel trainingBasic excel training
Basic excel training
 
22 Excel Basics
22 Excel Basics22 Excel Basics
22 Excel Basics
 
Introduction to MS WORD
Introduction to MS WORDIntroduction to MS WORD
Introduction to MS WORD
 
Microsoft word tutorial
Microsoft word tutorialMicrosoft word tutorial
Microsoft word tutorial
 
Microsoft Powerpoint
Microsoft PowerpointMicrosoft Powerpoint
Microsoft Powerpoint
 
MS Word Basics Training
MS Word Basics TrainingMS Word Basics Training
MS Word Basics Training
 
Microsoft Excel Seminar
Microsoft Excel SeminarMicrosoft Excel Seminar
Microsoft Excel Seminar
 
Ms excel ppt presentation
Ms excel ppt presentationMs excel ppt presentation
Ms excel ppt presentation
 
PPT On Microsoft Excel 2007 Full Information.
PPT On Microsoft Excel 2007 Full Information.PPT On Microsoft Excel 2007 Full Information.
PPT On Microsoft Excel 2007 Full Information.
 
Ms excel basic about Data, graph and pivot table
Ms excel basic about Data, graph and pivot table Ms excel basic about Data, graph and pivot table
Ms excel basic about Data, graph and pivot table
 

Viewers also liked

Beginners Microsoft Office Word 2007 Lesson 1
Beginners Microsoft Office Word 2007 Lesson 1Beginners Microsoft Office Word 2007 Lesson 1
Beginners Microsoft Office Word 2007 Lesson 1
adultref
 
Word for Beginners
Word for BeginnersWord for Beginners
Word for Beginners
Katheryn Woodworth
 
Word quick-reference-2003
Word quick-reference-2003Word quick-reference-2003
Word quick-reference-2003
Lady_Informationado
 
Pivot table
Pivot tablePivot table
Pivot table
Vijay Perepa
 
Customize Word Environment
Customize Word EnvironmentCustomize Word Environment
Customize Word Environment
Cik Na Shohaili
 
1 ICT in Society
1 ICT in Society1 ICT in Society
1 ICT in Society
Cik Na Shohaili
 
Word quick-reference-2010
Word quick-reference-2010Word quick-reference-2010
Word quick-reference-2010
Lady_Informationado
 
Microsoft word ppt presentation
 Microsoft word  ppt presentation Microsoft word  ppt presentation
Microsoft word ppt presentation
vethics
 
Microsoft Word 2010 Beginning Class
Microsoft Word 2010 Beginning ClassMicrosoft Word 2010 Beginning Class
Microsoft Word 2010 Beginning Class
Lady_Informationado
 
AutoCorrect - Excel 2013 Tutorial
AutoCorrect - Excel 2013 TutorialAutoCorrect - Excel 2013 Tutorial
AutoCorrect - Excel 2013 Tutorial
SpreadsheetTrainer
 
Introduction to Microsoft Office
Introduction to Microsoft OfficeIntroduction to Microsoft Office
Introduction to Microsoft Office
Cik Na Shohaili
 
A presentation on ms office
A presentation on ms officeA presentation on ms office
A presentation on ms office
Vijayraj Daksh
 
MCQ test item analysis
MCQ test item analysisMCQ test item analysis
MCQ test item analysis
Soha Rashed
 
Microsoft word basics ppt
Microsoft word basics pptMicrosoft word basics ppt
Microsoft word basics ppt
jdbutler13
 
Microsoft word presentation
Microsoft word presentationMicrosoft word presentation
Microsoft word presentation
egirshovich
 
MS Excel Pivot Table Reports & Charts
MS Excel Pivot Table Reports & ChartsMS Excel Pivot Table Reports & Charts
MS Excel Pivot Table Reports & Charts
dnbakhan
 

Viewers also liked (17)

Beginners Microsoft Office Word 2007 Lesson 1
Beginners Microsoft Office Word 2007 Lesson 1Beginners Microsoft Office Word 2007 Lesson 1
Beginners Microsoft Office Word 2007 Lesson 1
 
Word for Beginners
Word for BeginnersWord for Beginners
Word for Beginners
 
Word quick-reference-2003
Word quick-reference-2003Word quick-reference-2003
Word quick-reference-2003
 
Pivot table
Pivot tablePivot table
Pivot table
 
Harga Diri
Harga DiriHarga Diri
Harga Diri
 
Customize Word Environment
Customize Word EnvironmentCustomize Word Environment
Customize Word Environment
 
1 ICT in Society
1 ICT in Society1 ICT in Society
1 ICT in Society
 
Word quick-reference-2010
Word quick-reference-2010Word quick-reference-2010
Word quick-reference-2010
 
Microsoft word ppt presentation
 Microsoft word  ppt presentation Microsoft word  ppt presentation
Microsoft word ppt presentation
 
Microsoft Word 2010 Beginning Class
Microsoft Word 2010 Beginning ClassMicrosoft Word 2010 Beginning Class
Microsoft Word 2010 Beginning Class
 
AutoCorrect - Excel 2013 Tutorial
AutoCorrect - Excel 2013 TutorialAutoCorrect - Excel 2013 Tutorial
AutoCorrect - Excel 2013 Tutorial
 
Introduction to Microsoft Office
Introduction to Microsoft OfficeIntroduction to Microsoft Office
Introduction to Microsoft Office
 
A presentation on ms office
A presentation on ms officeA presentation on ms office
A presentation on ms office
 
MCQ test item analysis
MCQ test item analysisMCQ test item analysis
MCQ test item analysis
 
Microsoft word basics ppt
Microsoft word basics pptMicrosoft word basics ppt
Microsoft word basics ppt
 
Microsoft word presentation
Microsoft word presentationMicrosoft word presentation
Microsoft word presentation
 
MS Excel Pivot Table Reports & Charts
MS Excel Pivot Table Reports & ChartsMS Excel Pivot Table Reports & Charts
MS Excel Pivot Table Reports & Charts
 

Similar to Introduction to Excel - Excel 2013 Tutorial

Introduction to spreadsheet
Introduction to spreadsheetIntroduction to spreadsheet
Introduction to spreadsheet
DrThenmozhiKarunanit
 
Microsoft excel 2007 programme for effective tertiary institution result grading
Microsoft excel 2007 programme for effective tertiary institution result gradingMicrosoft excel 2007 programme for effective tertiary institution result grading
Microsoft excel 2007 programme for effective tertiary institution result grading
Alexander Decker
 
Learn Advanced Excel Online
Learn Advanced Excel OnlineLearn Advanced Excel Online
Learn Advanced Excel Online
bigspire
 
Emmylet computer guide on excel
Emmylet computer guide on excelEmmylet computer guide on excel
Emmylet computer guide on excel
Ofun Emma
 
Basics excel 20102
Basics excel 20102Basics excel 20102
Basics excel 20102
cherrybear2014
 
publisher microsoft
publisher microsoft publisher microsoft
publisher microsoft
Chidimma James
 
Access
AccessAccess
spreadsheet
spreadsheetspreadsheet
spreadsheet
ReubenUmukoro
 
Excel 2007
Excel 2007Excel 2007
Excel 2007
Usha Makvana
 
PIS Excel Lesson 1.pptx
PIS Excel Lesson 1.pptxPIS Excel Lesson 1.pptx
PIS Excel Lesson 1.pptx
rubben7
 
Using Spreadsheets.pptx
Using Spreadsheets.pptxUsing Spreadsheets.pptx
Using Spreadsheets.pptx
RohanSingh425729
 
Advexcellp
AdvexcellpAdvexcellp
Element of an electronic speadsheet ms excel
Element of an electronic speadsheet   ms excelElement of an electronic speadsheet   ms excel
Element of an electronic speadsheet ms excel
eVidhya
 
Teaching Excel
Teaching ExcelTeaching Excel
Teaching Excel
sam ran
 
Presentation _ Unit no. 2_ Lesson No. 2_ Grade 3.pptx
Presentation _ Unit no. 2_ Lesson No. 2_ Grade 3.pptxPresentation _ Unit no. 2_ Lesson No. 2_ Grade 3.pptx
Presentation _ Unit no. 2_ Lesson No. 2_ Grade 3.pptx
johannesremotigue2
 
Presentation-Ms Excel.pptx
Presentation-Ms Excel.pptxPresentation-Ms Excel.pptx
Introduction microsoft excel 2007
Introduction microsoft excel 2007Introduction microsoft excel 2007
Introduction microsoft excel 2007
Celia Bandelier
 
Advanced Excel Demo
Advanced Excel DemoAdvanced Excel Demo
Advanced Excel Demo
Pecific University
 
ms excel for mba first sem students of dr hs gour university sagar(m.p)
ms excel for mba first sem students of dr hs gour university sagar(m.p)ms excel for mba first sem students of dr hs gour university sagar(m.p)
ms excel for mba first sem students of dr hs gour university sagar(m.p)
gaurav jain
 
Af101882555 en us-xl_14_excel 2010 migration guide
Af101882555 en us-xl_14_excel 2010 migration guideAf101882555 en us-xl_14_excel 2010 migration guide
Af101882555 en us-xl_14_excel 2010 migration guide
Syaiful Anwar
 

Similar to Introduction to Excel - Excel 2013 Tutorial (20)

Introduction to spreadsheet
Introduction to spreadsheetIntroduction to spreadsheet
Introduction to spreadsheet
 
Microsoft excel 2007 programme for effective tertiary institution result grading
Microsoft excel 2007 programme for effective tertiary institution result gradingMicrosoft excel 2007 programme for effective tertiary institution result grading
Microsoft excel 2007 programme for effective tertiary institution result grading
 
Learn Advanced Excel Online
Learn Advanced Excel OnlineLearn Advanced Excel Online
Learn Advanced Excel Online
 
Emmylet computer guide on excel
Emmylet computer guide on excelEmmylet computer guide on excel
Emmylet computer guide on excel
 
Basics excel 20102
Basics excel 20102Basics excel 20102
Basics excel 20102
 
publisher microsoft
publisher microsoft publisher microsoft
publisher microsoft
 
Access
AccessAccess
Access
 
spreadsheet
spreadsheetspreadsheet
spreadsheet
 
Excel 2007
Excel 2007Excel 2007
Excel 2007
 
PIS Excel Lesson 1.pptx
PIS Excel Lesson 1.pptxPIS Excel Lesson 1.pptx
PIS Excel Lesson 1.pptx
 
Using Spreadsheets.pptx
Using Spreadsheets.pptxUsing Spreadsheets.pptx
Using Spreadsheets.pptx
 
Advexcellp
AdvexcellpAdvexcellp
Advexcellp
 
Element of an electronic speadsheet ms excel
Element of an electronic speadsheet   ms excelElement of an electronic speadsheet   ms excel
Element of an electronic speadsheet ms excel
 
Teaching Excel
Teaching ExcelTeaching Excel
Teaching Excel
 
Presentation _ Unit no. 2_ Lesson No. 2_ Grade 3.pptx
Presentation _ Unit no. 2_ Lesson No. 2_ Grade 3.pptxPresentation _ Unit no. 2_ Lesson No. 2_ Grade 3.pptx
Presentation _ Unit no. 2_ Lesson No. 2_ Grade 3.pptx
 
Presentation-Ms Excel.pptx
Presentation-Ms Excel.pptxPresentation-Ms Excel.pptx
Presentation-Ms Excel.pptx
 
Introduction microsoft excel 2007
Introduction microsoft excel 2007Introduction microsoft excel 2007
Introduction microsoft excel 2007
 
Advanced Excel Demo
Advanced Excel DemoAdvanced Excel Demo
Advanced Excel Demo
 
ms excel for mba first sem students of dr hs gour university sagar(m.p)
ms excel for mba first sem students of dr hs gour university sagar(m.p)ms excel for mba first sem students of dr hs gour university sagar(m.p)
ms excel for mba first sem students of dr hs gour university sagar(m.p)
 
Af101882555 en us-xl_14_excel 2010 migration guide
Af101882555 en us-xl_14_excel 2010 migration guideAf101882555 en us-xl_14_excel 2010 migration guide
Af101882555 en us-xl_14_excel 2010 migration guide
 

Recently uploaded

5 Whys Analysis Toolkit: Uncovering Root Causes with Precision
5 Whys Analysis Toolkit: Uncovering Root Causes with Precision5 Whys Analysis Toolkit: Uncovering Root Causes with Precision
5 Whys Analysis Toolkit: Uncovering Root Causes with Precision
Operational Excellence Consulting
 
Kalyan Chart Satta Matka Dpboss Kalyan Matka Results
Kalyan Chart Satta Matka Dpboss Kalyan Matka ResultsKalyan Chart Satta Matka Dpboss Kalyan Matka Results
Kalyan Chart Satta Matka Dpboss Kalyan Matka Results
Satta Matka Dpboss Kalyan Matka Results
 
➒➌➎➏➑➐➋➑➐➐ Indian Matka Dpboss Matka Guessing Kalyan panel Chart
➒➌➎➏➑➐➋➑➐➐ Indian Matka Dpboss Matka Guessing Kalyan panel Chart➒➌➎➏➑➐➋➑➐➐ Indian Matka Dpboss Matka Guessing Kalyan panel Chart
➒➌➎➏➑➐➋➑➐➐ Indian Matka Dpboss Matka Guessing Kalyan panel Chart
➒➌➎➏➑➐➋➑➐➐Dpboss Matka Guessing Satta Matka Kalyan Chart Indian Matka
 
RFHIC , IMS2024, Washington D.C. tradeshow
RFHIC , IMS2024, Washington D.C.  tradeshowRFHIC , IMS2024, Washington D.C.  tradeshow
RFHIC , IMS2024, Washington D.C. tradeshow
SeungyeonRyu2
 
➒➌➎➏➑➐➋➑➐➐ Satta Matta Matka Dpboss Matka Guessing Kalyan panel Chart
➒➌➎➏➑➐➋➑➐➐ Satta Matta Matka Dpboss Matka Guessing Kalyan panel Chart➒➌➎➏➑➐➋➑➐➐ Satta Matta Matka Dpboss Matka Guessing Kalyan panel Chart
➒➌➎➏➑➐➋➑➐➐ Satta Matta Matka Dpboss Matka Guessing Kalyan panel Chart
➒➌➎➏➑➐➋➑➐➐Dpboss Matka Guessing Satta Matka Kalyan Chart Indian Matka
 
NewBase 20 June 2024 Energy News issue - 1731 by Khaled Al Awadi_compressed.pdf
NewBase 20 June 2024  Energy News issue - 1731 by Khaled Al Awadi_compressed.pdfNewBase 20 June 2024  Energy News issue - 1731 by Khaled Al Awadi_compressed.pdf
NewBase 20 June 2024 Energy News issue - 1731 by Khaled Al Awadi_compressed.pdf
Khaled Al Awadi
 
Satta Matka Dpboss Matka Guessing Indian Matka Kalyan Matka.pdf
Satta Matka Dpboss Matka Guessing Indian Matka Kalyan Matka.pdfSatta Matka Dpboss Matka Guessing Indian Matka Kalyan Matka.pdf
Satta Matka Dpboss Matka Guessing Indian Matka Kalyan Matka.pdf
KALYAN HEAD OFFICE
 
Satta Matka Dpboss Kalyan Matka Results Kalyan Chart
Satta Matka Dpboss Kalyan Matka Results Kalyan ChartSatta Matka Dpboss Kalyan Matka Results Kalyan Chart
Satta Matka Dpboss Kalyan Matka Results Kalyan Chart
DP Boss Satta Matka Kalyan Matka
 
➒➌➎➏➑➐➋➑➐➐ Satta Matka Dpboss Matka Guessing Indian Matka
➒➌➎➏➑➐➋➑➐➐ Satta Matka Dpboss Matka Guessing Indian Matka➒➌➎➏➑➐➋➑➐➐ Satta Matka Dpboss Matka Guessing Indian Matka
➒➌➎➏➑➐➋➑➐➐ Satta Matka Dpboss Matka Guessing Indian Matka
➒➌➎➏➑➐➋➑➐➐Dpboss Matka Guessing Satta Matka Kalyan Chart Indian Matka
 
Satta matka guessing Kalyan fxxjodi panna
Satta matka guessing Kalyan fxxjodi pannaSatta matka guessing Kalyan fxxjodi panna
Satta matka guessing Kalyan fxxjodi panna
➑➌➋➑➒➎➑➑➊➍
 
Call Girls Chandigarh👉9024918724👉Agency 💞Profile Escorts in Chandigarh Availa...
Call Girls Chandigarh👉9024918724👉Agency 💞Profile Escorts in Chandigarh Availa...Call Girls Chandigarh👉9024918724👉Agency 💞Profile Escorts in Chandigarh Availa...
Call Girls Chandigarh👉9024918724👉Agency 💞Profile Escorts in Chandigarh Availa...
nitachopra
 
Progress Report - Qualcomm AI Workshop - AI available - everywhereAI summit 1...
Progress Report - Qualcomm AI Workshop - AI available - everywhereAI summit 1...Progress Report - Qualcomm AI Workshop - AI available - everywhereAI summit 1...
Progress Report - Qualcomm AI Workshop - AI available - everywhereAI summit 1...
Holger Mueller
 
Call Girls Dehradun (india) ☎️ +91-74260 Dehradun Call Girl
Call Girls Dehradun (india) ☎️ +91-74260 Dehradun Call GirlCall Girls Dehradun (india) ☎️ +91-74260 Dehradun Call Girl
Call Girls Dehradun (india) ☎️ +91-74260 Dehradun Call Girl
Happy Singh
 
The Key Summaries of Forum Gas 2024.pptx
The Key Summaries of Forum Gas 2024.pptxThe Key Summaries of Forum Gas 2024.pptx
The Key Summaries of Forum Gas 2024.pptx
Sampe Purba
 
一比一原版(UCSC毕业证)加州大学圣克鲁兹分校毕业证如何办理
一比一原版(UCSC毕业证)加州大学圣克鲁兹分校毕业证如何办理一比一原版(UCSC毕业证)加州大学圣克鲁兹分校毕业证如何办理
一比一原版(UCSC毕业证)加州大学圣克鲁兹分校毕业证如何办理
taqyea
 
➒➌➎➏➑➐➋➑➐➐ Satta Matka Dpboss Matka Guessing Indian Matka
➒➌➎➏➑➐➋➑➐➐ Satta Matka Dpboss Matka Guessing Indian Matka➒➌➎➏➑➐➋➑➐➐ Satta Matka Dpboss Matka Guessing Indian Matka
➒➌➎➏➑➐➋➑➐➐ Satta Matka Dpboss Matka Guessing Indian Matka
➒➌➎➏➑➐➋➑➐➐Dpboss Matka Guessing Satta Matka Kalyan Chart Indian Matka
 
Kanban Coaching Exchange with Dave White - Sample SDR Report
Kanban Coaching Exchange with Dave White - Sample SDR ReportKanban Coaching Exchange with Dave White - Sample SDR Report
Kanban Coaching Exchange with Dave White - Sample SDR Report
Helen Meek
 
Kirill Klip GEM Royalty TNR Gold Presentation
Kirill Klip GEM Royalty TNR Gold PresentationKirill Klip GEM Royalty TNR Gold Presentation
Kirill Klip GEM Royalty TNR Gold Presentation
Kirill Klip
 
Satta Matka Kalyan Matka Satta Matka Guessing
Satta Matka Kalyan Matka Satta Matka GuessingSatta Matka Kalyan Matka Satta Matka Guessing
Satta Matka Kalyan Matka Satta Matka Guessing
DP Boss Satta Matka Kalyan Matka
 
DefenceTech Meetup #1 - Lisbon, Portugal
DefenceTech Meetup #1 - Lisbon, PortugalDefenceTech Meetup #1 - Lisbon, Portugal
DefenceTech Meetup #1 - Lisbon, Portugal
Andre Marquet
 

Recently uploaded (20)

5 Whys Analysis Toolkit: Uncovering Root Causes with Precision
5 Whys Analysis Toolkit: Uncovering Root Causes with Precision5 Whys Analysis Toolkit: Uncovering Root Causes with Precision
5 Whys Analysis Toolkit: Uncovering Root Causes with Precision
 
Kalyan Chart Satta Matka Dpboss Kalyan Matka Results
Kalyan Chart Satta Matka Dpboss Kalyan Matka ResultsKalyan Chart Satta Matka Dpboss Kalyan Matka Results
Kalyan Chart Satta Matka Dpboss Kalyan Matka Results
 
➒➌➎➏➑➐➋➑➐➐ Indian Matka Dpboss Matka Guessing Kalyan panel Chart
➒➌➎➏➑➐➋➑➐➐ Indian Matka Dpboss Matka Guessing Kalyan panel Chart➒➌➎➏➑➐➋➑➐➐ Indian Matka Dpboss Matka Guessing Kalyan panel Chart
➒➌➎➏➑➐➋➑➐➐ Indian Matka Dpboss Matka Guessing Kalyan panel Chart
 
RFHIC , IMS2024, Washington D.C. tradeshow
RFHIC , IMS2024, Washington D.C.  tradeshowRFHIC , IMS2024, Washington D.C.  tradeshow
RFHIC , IMS2024, Washington D.C. tradeshow
 
➒➌➎➏➑➐➋➑➐➐ Satta Matta Matka Dpboss Matka Guessing Kalyan panel Chart
➒➌➎➏➑➐➋➑➐➐ Satta Matta Matka Dpboss Matka Guessing Kalyan panel Chart➒➌➎➏➑➐➋➑➐➐ Satta Matta Matka Dpboss Matka Guessing Kalyan panel Chart
➒➌➎➏➑➐➋➑➐➐ Satta Matta Matka Dpboss Matka Guessing Kalyan panel Chart
 
NewBase 20 June 2024 Energy News issue - 1731 by Khaled Al Awadi_compressed.pdf
NewBase 20 June 2024  Energy News issue - 1731 by Khaled Al Awadi_compressed.pdfNewBase 20 June 2024  Energy News issue - 1731 by Khaled Al Awadi_compressed.pdf
NewBase 20 June 2024 Energy News issue - 1731 by Khaled Al Awadi_compressed.pdf
 
Satta Matka Dpboss Matka Guessing Indian Matka Kalyan Matka.pdf
Satta Matka Dpboss Matka Guessing Indian Matka Kalyan Matka.pdfSatta Matka Dpboss Matka Guessing Indian Matka Kalyan Matka.pdf
Satta Matka Dpboss Matka Guessing Indian Matka Kalyan Matka.pdf
 
Satta Matka Dpboss Kalyan Matka Results Kalyan Chart
Satta Matka Dpboss Kalyan Matka Results Kalyan ChartSatta Matka Dpboss Kalyan Matka Results Kalyan Chart
Satta Matka Dpboss Kalyan Matka Results Kalyan Chart
 
➒➌➎➏➑➐➋➑➐➐ Satta Matka Dpboss Matka Guessing Indian Matka
➒➌➎➏➑➐➋➑➐➐ Satta Matka Dpboss Matka Guessing Indian Matka➒➌➎➏➑➐➋➑➐➐ Satta Matka Dpboss Matka Guessing Indian Matka
➒➌➎➏➑➐➋➑➐➐ Satta Matka Dpboss Matka Guessing Indian Matka
 
Satta matka guessing Kalyan fxxjodi panna
Satta matka guessing Kalyan fxxjodi pannaSatta matka guessing Kalyan fxxjodi panna
Satta matka guessing Kalyan fxxjodi panna
 
Call Girls Chandigarh👉9024918724👉Agency 💞Profile Escorts in Chandigarh Availa...
Call Girls Chandigarh👉9024918724👉Agency 💞Profile Escorts in Chandigarh Availa...Call Girls Chandigarh👉9024918724👉Agency 💞Profile Escorts in Chandigarh Availa...
Call Girls Chandigarh👉9024918724👉Agency 💞Profile Escorts in Chandigarh Availa...
 
Progress Report - Qualcomm AI Workshop - AI available - everywhereAI summit 1...
Progress Report - Qualcomm AI Workshop - AI available - everywhereAI summit 1...Progress Report - Qualcomm AI Workshop - AI available - everywhereAI summit 1...
Progress Report - Qualcomm AI Workshop - AI available - everywhereAI summit 1...
 
Call Girls Dehradun (india) ☎️ +91-74260 Dehradun Call Girl
Call Girls Dehradun (india) ☎️ +91-74260 Dehradun Call GirlCall Girls Dehradun (india) ☎️ +91-74260 Dehradun Call Girl
Call Girls Dehradun (india) ☎️ +91-74260 Dehradun Call Girl
 
The Key Summaries of Forum Gas 2024.pptx
The Key Summaries of Forum Gas 2024.pptxThe Key Summaries of Forum Gas 2024.pptx
The Key Summaries of Forum Gas 2024.pptx
 
一比一原版(UCSC毕业证)加州大学圣克鲁兹分校毕业证如何办理
一比一原版(UCSC毕业证)加州大学圣克鲁兹分校毕业证如何办理一比一原版(UCSC毕业证)加州大学圣克鲁兹分校毕业证如何办理
一比一原版(UCSC毕业证)加州大学圣克鲁兹分校毕业证如何办理
 
➒➌➎➏➑➐➋➑➐➐ Satta Matka Dpboss Matka Guessing Indian Matka
➒➌➎➏➑➐➋➑➐➐ Satta Matka Dpboss Matka Guessing Indian Matka➒➌➎➏➑➐➋➑➐➐ Satta Matka Dpboss Matka Guessing Indian Matka
➒➌➎➏➑➐➋➑➐➐ Satta Matka Dpboss Matka Guessing Indian Matka
 
Kanban Coaching Exchange with Dave White - Sample SDR Report
Kanban Coaching Exchange with Dave White - Sample SDR ReportKanban Coaching Exchange with Dave White - Sample SDR Report
Kanban Coaching Exchange with Dave White - Sample SDR Report
 
Kirill Klip GEM Royalty TNR Gold Presentation
Kirill Klip GEM Royalty TNR Gold PresentationKirill Klip GEM Royalty TNR Gold Presentation
Kirill Klip GEM Royalty TNR Gold Presentation
 
Satta Matka Kalyan Matka Satta Matka Guessing
Satta Matka Kalyan Matka Satta Matka GuessingSatta Matka Kalyan Matka Satta Matka Guessing
Satta Matka Kalyan Matka Satta Matka Guessing
 
DefenceTech Meetup #1 - Lisbon, Portugal
DefenceTech Meetup #1 - Lisbon, PortugalDefenceTech Meetup #1 - Lisbon, Portugal
DefenceTech Meetup #1 - Lisbon, Portugal
 

Introduction to Excel - Excel 2013 Tutorial

  • 1. PIVOT TABLE PRO LESSON: INTRODUCTION TO EXCEL® LEVEL: BEGINNER CONTENTS: 2 Do You Want to Learn Excel? 20 The Excel Program Window 33 The Excel Ribbon 52 Other Program Window Elements PIVOT TABLE PRO Find more at WWW.PIVOTTABLE-PRO.COM
  • 2. Do you want to learn Excel?
  • 4. Excel is the industry standard spreadsheet application in government and business.
  • 5. It’s widely used for home and personal use as well.
  • 6. Excel helps you store, organize and manipulate data,
  • 8. present results with graphical & statistical tools,
  • 9. and lots of other stuff too.
  • 10. What does this mean?
  • 11. Easily keep track of personal and business finances,
  • 12. present data clearly and professionally,
  • 13. save time on record keeping,
  • 14. and improve productivity & efficiency at work.
  • 15. Congratulations on taking the first step.
  • 16. You’ve come to the right place!
  • 17. Excel is a powerful application for advanced users.
  • 18. But it’s also simple and intuitive for beginners.
  • 19. Let’s start by introducing the Excel program window.
  • 20. By the end of this presentation, you can:  identify the major features of the Excel window  understand how buttons are grouped in the Excel Ribbon  recognise the purpose of each tab in the Excel Ribbon
  • 21. This is the Excel 2013 Program Window. SPREADSHEETTRAINER.COM This is the Excel 2013 Program Window.
  • 22. It has things in common with other windows. Let’s recap:
  • 23. The Excel window is bounded by four edges:
  • 24. With the mouse over the bottom edge, the cursor turns into white vertical arrows:
  • 25. Change the window height by clicking and dragging the mouse:
  • 26. Do the same with the horizontal edge to change the width:
  • 27. To change the width & height at once place the cursor over a corner then click and drag:
  • 28. Excel shows the name of the current file at the top of the window:
  • 29. And the top-right corner has buttons to minimise…
  • 30. … and to maximise …
  • 31. … and to close the window.
  • 32. Closing the window also closes our file – Excel asks if we want to save all our great work first, so it doesn’t get lost.
  • 33. From Excel 2007 onwards, the Ribbon replaced menus as Excel’s way of showing commands.
  • 34. The ribbon is made up of multiple Tabs.
  • 35. The Home Tab includes common tasks for editing and formatting data.
  • 36. The Insert Tab is used to add elements such as tables, illustrations, charts and filters.
  • 37. The Page Layout Tab is used to layout a page for printing, and to arrange worksheet elements.
  • 38. The Formulas Tab is used to insert and check functions and formulas.
  • 39. The Data Tab contains buttons to import, sort, filter, manipulate and analyse data.
  • 40. The Review Tab is used to proof, protect and comment on worksheets.
  • 41. The View Tab is mostly used to change how the worksheet appears on the screen.
  • 42. [The Developer Tab is not displayed by default, but contains more advanced features].
  • 43. File is a special tab which leads to the Backstage Menu.
  • 44. The Backstage Menu displays properties, performs file operations (new/open/save etc.), and other options.
  • 45. In each tab, the buttons are split into categories called Groups. i.e. The ‘Home’ groups are: Clipboard, Font, Alignment, etc.
  • 46. The buttons in each group are called Command Buttons.
  • 47. Holding the mouse over a command button displays a Tool-Tip: a pop-up showing more info and a keyboard shortcut for each task.
  • 48. At the bottom-right corners of many groups are small buttons called Dialog Box Launchers.
  • 49. Dialog box launchers open up [1] Task Panes or [2] Dialog Boxes, with more advanced options for each group. 1 2
  • 50. If you like you can [1] hide (and then [2] unhide) the ribbon. You can also hide/unhide the ribbon by double-clicking on any tab. 1 2
  • 51. As you resize the window the ribbon shrinks and groups together. Command buttons are then accessed with Drop-Down Menus:
  • 52. The Quick Access Toolbar contains shortcuts for common tasks. This can be customized as you wish– more on this in a later video.
  • 53. The Name Box displays the address of the current cell selection.
  • 54. The Formula Bar is where you can enter text, numbers, formulas or functions to the selected cells.
  • 55. The formula bar can be expanded to accommodate larger entries by clicking and dragging the mouse:
  • 56. At the bottom left, the Status Bar tells you the current status of Excel.
  • 57. Next to this is a button to record Macros (automated Excel processes). We cover this in a later video.
  • 58. At the bottom right, shortcuts let you change how the worksheet looks on screen – page layout & zoom.
  • 59. There are vertical and horizontal Scroll Bars which let you navigate around the worksheet:
  • 60. And of course – in the middle of it all – is the Worksheet Area! This is where the magic happens, and is our next topic.
  • 61. One more thing - when you right-click in the worksheet the Mini Tool-bar appears, which includes useful shortcuts from the ribbon.
  • 62. PivotExcel is an independent training program and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. Microsoft, Excel, and Windows are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. Excel visuals used with permission from Microsoft. VISIT WWW.PIVOTTABLE-PRO.COM FOR MORE, INCLUDING A FREE TRIAL! See more at PIVOT TABLE PRO WWW.PIVOTTABLE-PRO.COM
  翻译: