introduction to excel powerpoint presentation

• My presentations

Auth with social network:

Download presentation

We think you have liked this presentation. If you wish to download it, please recommend it to your friends in any social system. Share buttons are a little bit lower. Thank you!

Presentation is loading. Please wait.

Excel Tutorial 1 Getting Started with Excel

Published by Blaze Torell Modified over 9 years ago

Similar presentations

Presentation on theme: "Excel Tutorial 1 Getting Started with Excel"— Presentation transcript:

TUTORIAL 1 Getting Started with Excel

® Microsoft Office 2010 Excel Tutorial 1: Getting Started with Excel.

Lesson 12 Getting Started with Excel Essentials

XP New Perspectives on Microsoft Office Excel 2003 Tutorial 1 1 Microsoft Office Excel 2003 Tutorial 1 – Using Excel To Manage Data.

Understanding Microsoft Excel

Objectives 1.Identify the functions of a spreadsheet 2.Identify how spreadsheets can be used. 3.Explain the difference in columns and rows. 4.Locate specific.

XP Microsoft Excel Lecture -5- By lec. (Eng.) Hind Basil University of technology Department of Materials Engineering.

Using Microsoft Office Excel 2007

Using Complex Formulas, Functions, and Tables. Objectives Navigate a workbookNavigate a workbook Enter labels and valuesEnter labels and values Change.

EXCEL Spreadsheet Basics

Chapter 13 Creating a Workbook.

MICROSOFT OFFICE 2013 EXCEL 1. 2 File Tab 1 Title Bar 5. Group 7 Name Box 6 Active Cell 8 Formula Bar 4 Ribbon 9 Column 10. Row 11 Sheet Tabs 12 View.

Tutorial 5: Working with Excel Tables, PivotTables, and PivotCharts

XP 1 ﴀ New Perspectives on Microsoft Office 2003, Premium Edition Excel Tutorial 1 Microsoft Office Excel 2003 Tutorial 1 – Using Excel To Manage Data.

Unit G: Using Complex Formulas, Functions, and Tables Microsoft Office Illustrated Fundamentals.

XP New Perspectives on Microsoft Office Excel 2003 Tutorial 1 1 Microsoft Office Excel 2003.

About project

© 2024 SlidePlayer.com Inc. All rights reserved.

Excel video training

Other training

LinkedIn Learning Excel training

Excel templates

Office templates

Need more help?

Want more options.

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Microsoft 365 subscription benefits

Microsoft 365 training

Microsoft security

Accessibility center

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Ask the Microsoft Community

Microsoft Tech Community

Windows Insiders

Microsoft 365 Insiders

Find solutions to common problems or get help from a support agent.

Online support

Was this information helpful?

Thank you for your feedback.

Introduction to Excel

Dec 02, 2014

4.1k likes | 7.15k Views

Introduction to Excel. Applications of Spreadsheets. What is an Electronic Worksheet good for?. An Excel Chart Sheet. Loading and Exiting Excel. Highlighting an option in the Microsoft Office program group. Loading and Exiting Excel Microsoft Office Excel 2003 application window.

Share Presentation

• entering text
• cell pointer
• cell pointer dragging
• entering formulas entering formulas

Presentation Transcript

Introduction to Excel Applications of Spreadsheets CT 202

What is an Electronic Worksheet good for?

An Excel Chart Sheet

Loading and Exiting Excel • Highlighting an option in the Microsoft Office program group

Loading and Exiting ExcelMicrosoft Office Excel 2003 application window

Windows icons Menu bar Name box Formula bar Ask a Question box Standard and Formatting toolbars sharing one row Work Area Task Pane Status bar Components of Excel’s application window

Cell pointer Column Frame Area Mouse pointer Vertical scroll box Row Frame Area Worksheet Window Icons Worksheet cell Horizontal scroll box Active sheet tab Inactive sheet tab Tab Split box Tab Scrolling arrows Sizing corner Components of Excel’s worksheet window

Displaying a Right-click Menu for a Cell

Displaying Menus, Toolbars, & the Task PaneCustomize dialog box: Options tab Customize toolbars Customize Menu bar

Displaying Menus, Toolbars & Task PaneStandard Toolbar and Formatting Toolbar

Displaying Menus, Toolbars & Task PaneCustomizing the application window Standardtoolbar Task pane Formattingtoolbar

Creating Your First Worksheet • You create a worksheet by entering text labels, numbers, dates, and formulas into the individual cells. To begin entering data, • move the cell pointer to the desired cell in the worksheet • type the information that you want to appear in the cell • complete the entry by pressing Enter or by moving the cell pointer to another cell.

Moving the Cell PointerDragging the vertical scroll box Keep dragging the vertical scroll box (right) up until Row 24 is visible (as shown at the left).

Entering Text and Numbers • Excel accepts two broad types of cell entries: • Constants do not change unless you edit them. • Text values (aka labels) • Numeric values (numbers) • Date and time values • Formulas produce a calculated result, usually based on a reference to one or more cells in the worksheet. • The results of a formula change if you change the contents of a cell referenced in the formula.

Entering TextTyping text into the Formula bar Your entry appears in the Formula bar as you type. The cursor or insertion point shows where the next character typed will appear.

Entering TextOptions dialog box: Edit tab Select these options to change the behavior of the cell pointer after pressing the Enter key.

Entering TextEntering text into a worksheet

Entering DatesEntering date values into a worksheet

Entering NumbersEntering numbers into a worksheet

Entering a Formula • If you start an entry into a cell with an equal sign (=), Excel identifies it as a formula rather than data. • A formula consists of: • arithmetic operators • Include +, -, *, and / for addition, subtraction, multiplication and division. • references to cells

Entering FormulasTyping a formula expression into the Formula bar The Expression is built in the Formula Bar. Notice that the blue-highlighted cell address”C3” in the formula expression corresponds with the cell outline immediately above.

Entering FormulasEntering formulas into a worksheet

Entering FormulasCompleting the worksheet

Entering a Formula • The order of the elements in a formula determines the final result of the calculation. • Excel evaluates a formula from left to right according to the order of operator precedence. • Multiplication and division take place before addition and subtraction.

Editing a Cell's ContentsDisplaying a new workbook

Editing a Cell's ContentsCreating an inventory worksheet Ensure that you type the dollar sign when entering values in the price column

Editing a Cell's ContentsPerforming in-cell editing The formula bar is activated for editing as denoted by the appearance of Enter and Cancel buttons The insertion point flashes in the cell when Excel is ready for editing

Editing a Cell's ContentsEditing an entry in the formula bar Drag the I –beam mouse pointer from left to right over the letter “M”.

Selecting and Erasing Cell ContentsSelecting a group of cells to erase The Name box shows that the active cell is A9, displayed with a white background in the highlighted selection

Selecting and Erasing Cell ContentsSelecting cells using the mouse The active cell in this selection is D5, the first selected cell. The Name box shows that four rows (4R) and one column (1C) are currently selected in the worksheet. After clicking cell D5, keep the mouse button depressed and drag the mouse pointer down to cell D8. Once the desired cells are highlighted, you may release the mouse button.

Using Undo and RedoSelecting cell A5

Using Undo and RedoDisplaying reversible commands There are two actions listed on the drop-down menu that can be “undone” in the worksheet.

Getting Help • Excel provides a number of onscreen Help options • Office Assistant (F1 key) • Answers specific questions • Contents • Scroll through topics and related subtopics • Index • Searches on a key word • What’s This? Pointer (Shift + F1) • Displays a description of any feature on the screen.

Managing Files Be sure to save your work • Protects against unexpected occurrences that can disrupt your work and/or destroy your file • For important documents, consider saving your file every fifteen minutes • Use a file name that is short, easy to remember, and concisely describes the contents

Beginning a New WorkbookDisplaying solutions in the templates dialog box When you choose the “Complete Install” option during setup, Excel 2003 provides the General and Spreadsheet Solutions tabs for organizing your workbook templates .

Beginning a New WorkbookNew workbook based on the Sales Invoice template The Sales Invoice template contains a single worksheet tab named “Invoice.”

Lists the files that you have most recently worked with The currently selected folder is displayed in the Save in drop-down list box. Excel’s default working folder for storing files The “Advantage” folder is the default folder for storing the student data files . Each folder item represents either a local folder or a shortcut to a remote storage . Lists common desktop shortcuts Provides access to the resources on your computer Enter the workbook’s file name in this drop-down text box Selecta workbook file type from this drop-down list box Lists files and folders stored on your intranet or Internet web server Saving and ClosingSave As dialog box

Saving a Workbook • Important to save your work frequently. • Excel automatically stores the file in the default Excel file format (and adds the .xls extension to the filename). • Save a file by selecting in the menu bar: • File, Save • File, Save As

Closing a File and Exiting Excel • Choose • File, Close • The current workbook closes after Excel asks if you want to save your work (if you haven’t already.) • File, Exit • Excel closes after asking if you want to save your work.

Saving and ClosingNavigating the storage areas using the save-in drop-down list box Along with the resources shown in the My Computer list area, the Save in drop-down list box provides access to other storage areas, such as “My Network Places” and FTP locations.

Saving and ClosingThe Program Files folder of the author’s hard drive (C:)

Opening an Existing Workbook • After you create and save a workbook, you can reopen the workbook and resume working with its data. • To open a file quickly from the Open dialog box, double-click the file’s icon in the list of files. • If you double-click the filename, you might end up in Rename mode.

Opening - Existing WorkbookViewing the student data files for Microsoft Office Excel 2003 tutorial

Opening -Existing WorkbookOpening the EX0143 workbook

Creating a Workbook FolderCreating a new folder in the Save As dialog box

• More by User

Introduction to Microsoft Excel 2010

Introduction to Microsoft Excel 2010. While Waiting (Do Now) . Launch Microsoft Excel Create a Blank Document Name and Save Document to Desktop. Standard Addressed.

11.98k views • 40 slides

Introduction to Microsoft Excel

Objectives. Define the terms used in the lesson.Identify the parts of the worksheet.Move the highlight in the worksheet.Select cells and enter data in the worksheet.Edit cells.Find and replace data.Zoom in and out in a worksheet.Save a worksheet.Print a worksheet.. What Is Excel?. Excel is a

960 views • 25 slides

Introduction to Excel . Yitzchak Rosenthal. Worksheet Basics. Worksheets. Excel’s main screen is called a “ worksheet ”. Each worksheet is comprised of many boxes, called “ cells ”. Organize Information.

2.17k views • 164 slides

Excel: Introduction

Excel: Introduction. Microsoft Office 2003. What is Excel? . Electronic spread sheet program. What can Excel do for you?. Ability to enter data quickly and accurately Recalculate data easily Perform what-if analysis Format information Create Charts Share Information Use Templates.

327 views • 13 slides

Excel: Introduction. Microsoft Office 200 7 . XLS X. TEMPLATES. Click on the OFFICE button NEW A list of templates appear (pre-created workbooks that can be reused and include formulas and formatting ) .

401 views • 21 slides

Introduction to Excel VBA

Introduction to Excel VBA. UNC Charlotte CPE/PDH Series December 17, 2009. Lesson 1 Objectives. Record a Macro Modules Examine the VBE window Project Explorer, Object Browser, Properties Sub Procedures Write a Sub procedure Examine statement code Define objects properties Edit code.

623 views • 42 slides

Introduction to Excel 2007

Introduction to Excel 2007. January 29, 2008. In Psych 209, we will use Excel to:. Store and organize data, Analyze data, and Represent data graphically (e.g., in bar graphs, histograms, and scatterplots). Excel Basics.

478 views • 25 slides

Introduction to Excel. Te Wananga o Aotearoa Student Support – Te Puna Manaaki Advisor: Dora Roimata Langsbury TWOA ki Te Waipounamu. Tutorial steps. Welcome to this edCanvas tutorial.

230 views • 3 slides

Introduction To 2010 Excel

Introduction To 2010 Excel. Super-size Tool Bar: Ribbon Basic Tasks on Home Tab Math and Formula Statistical Functions (examples) Create A Chart Play with Insert & Layout Create A Histogram Curve Fitting & Regression Line Tips for Excel Applications. Supersize Toolbar: Ribbon.

326 views • 14 slides

Introduction to Excel. Please use speaker notes for additional information!. =AVERAGE(B6:B11) AVERAGE is a function that will take an average of range of cells indicate. In this example B6: B11 means B6 through B11. =ROUND( AVERAGE(B6:B11) ,0)

335 views • 17 slides

Introduction to Excel 2013

Introduction to Excel 2013. What new features exist in Excel 2013?. Like all of the applications within Office 2013, Excel introduces several new features for the end user. 1. Quick Analysis tool. Instant Data Analysis Incorporates “Live Preview” “Recommended Charts”

707 views • 6 slides

Introduction to Excel 2010

Introduction to Excel 2010. Written by: Andie Philo. What is Excel?. Microsoft Excel is an electronic spreadsheet program that runs on a personal computer. As with a paper spreadsheet, you can use Excel to organize your data into rows and columns and to perform mathematical calculations.

1.41k views • 8 slides

Introduction to Microsoft Excel. Spreadsheet Programs. Spreadsheets. What’s a spreadsheet? Spreadsheets are computer programs designed to organize data and show relationships between various pieces of data.

379 views • 5 slides

Introduction to Excel. How to Git R’ Done.. Jessi Rose. What you will Learn. Definitions Parts of Excel Basic Use of Excel Short Cuts for Excel Formatting Spreadsheets Go through a project Examples and Links. Fonts Columns . Rows Graphs. Merge Sort. Pivot Tables Graphs.

823 views • 26 slides

Introduction to Excel 2010. CTC S ummer Workshop June 13, 2012 9:00a.m. - 4:00p.m. Instructor Janet Cannon. Agenda. Start at 9:00a.m. Introductions Discussion – what you know/want to know Breaks ≈ 10:30 & 2:30 Lunch from 12:00-1:00 Learn basic vocab and navigation.

628 views • 42 slides

University of Chicago Graduate School of Business. Introduction to Computer Based Models Bus-36102-81 Mr. Schrage Spring 2003. Introduction to Excel VBA. What is the Visual Basic Add-in for Excel?

359 views • 12 slides

Introduction to Excel 2002

Introduction to Excel 2002. Introduction to Excel 2002. This lesson will cover: What is Excel 2002? Spreadsheet Basics Starting Excel Understanding the Excel Window Shortcut Menus and Tool bars On-Line Help Exiting Excel. These topics are from Chapter 1 of the text...

918 views • 47 slides

Introduction to Excel. ICL and MSO. Excel Basics. Excel is a spreadsheet application and looks similar to a table An Excel document is called a Workbook A new Workbook contains a default number of 3 Worksheets A Worksheet is where you work Worksheets can be divided using page breaks

281 views • 9 slides

Introduction to Excel 2007. Written by: Andie Philo. What is Excel?. Microsoft Excel is an electronic spreadsheet program. It can help you record, analyze, and present quantitative information. It allows you to enter both text and numbers.  It is also helpful in computing formulas.  .

364 views • 8 slides

Excel introduction

We offer courses to all (students, graduates, working professionals, housewives, retired people, etc.). Facilitating participants to express themselves with confidence in all walks of life.

153 views • 8 slides

Introduction Excel

Introduction Excel. Spreadsheets. What is Excel?. Objectives . Identify the parts of the Excel Screen Identify the functions of a spreadsheet Identify how spreadsheets can be used Explain the difference in columns and rows Locate specific cell references

487 views • 28 slides

Introduction Excel. Spreadsheets 101. What is Excel?. Objectives . Identify the parts of the Excel Screen Identify the functions of a spreadsheet Identify how spreadsheets can be used Explain the difference in columns and rows Locate specific cell references

317 views • 17 slides

Excel Tutorial: How To Insert Excel In Ppt Office 365

Introduction.

Integrating Excel data into PowerPoint presentations can be a game-changer when it comes to creating impactful and informative slideshows. In Office 365 , this powerful feature allows users to seamlessly insert and display Excel spreadsheets directly into their PowerPoint presentations, providing a dynamic way to visualize and communicate complex data to an audience. In this tutorial, we will explore the importance of inserting Excel into PowerPoint in Office 365 , as well as the benefits of integrating Excel data into your presentations.

Key Takeaways

• Integrating Excel data into PowerPoint in Office 365 is a powerful way to visualize and communicate complex data to an audience.
• The process of inserting Excel into PowerPoint can enhance the visual appeal of the presentation and provide interactive and dynamic data for the audience.
• Updating linked Excel data in PowerPoint can streamline the process of keeping data accurate and up-to-date for future presentations.
• When using Excel in PowerPoint presentations, it is important to ensure that the data is clear, easy to read, and supports key points in the presentation.
• Experimenting with different ways of incorporating Excel data into presentations can lead to more impactful and informative slideshows.

Step-by-Step Guide on How to Insert Excel into PowerPoint in Office 365

Adding Excel data into a PowerPoint presentation can enhance the visual appeal and provide in-depth information to the audience. Follow these simple steps to seamlessly insert an Excel spreadsheet into your PowerPoint presentation in Office 365.

A. Opening PowerPoint and selecting the slide for the Excel data

• Open PowerPoint: Launch the PowerPoint application and open the presentation where you want to insert the Excel data.
• Select Slide: Navigate to the specific slide where you want to insert the Excel spreadsheet.

B. Clicking on the "Insert" tab and choosing "Object" from the dropdown menu

• Insert Tab: Click on the "Insert" tab located in the PowerPoint ribbon at the top of the screen.
• Object: From the options in the "Insert" tab, select "Object" from the "Text" group dropdown menu.

C. Selecting "Create from file" and browsing for the Excel file

• Create from File: In the "Insert Object" dialog box, choose the "Create from File" option.
• Browse: Click on the "Browse" button to navigate to the location where your Excel file is saved on your computer.
• Select File: Once you have located the Excel file, click "Insert" to add it to the PowerPoint slide.

D. Adjusting the display options and linking the data if necessary

• Display Options: Choose the display options that best suit your presentation, such as displaying the entire spreadsheet or just a specific section.
• Linking Data: If you want to maintain a link between the Excel file and the PowerPoint presentation, select the "Link" option in the "Insert Object" dialog box.

Following these steps will allow you to seamlessly integrate Excel data into your PowerPoint presentation, providing a comprehensive overview of the information without switching between different programs.

Tips for Formatting Excel Data in PowerPoint

When inserting Excel data into a PowerPoint presentation, it's important to ensure that the data is clear and easy to read for the audience. Here are some tips for formatting Excel data in PowerPoint:

Ensuring the data is clear and easy to read for the audience

• Use a large enough font: Make sure the text in your Excel data is large enough to be easily read from a distance.
• Use appropriate colors: Use colors that provide good contrast and make the data easier to read.
• Organize the data logically: Arrange the data in a way that makes sense and is easy to follow for the audience.

Using charts or graphs to visually represent the Excel data

• Choose the right type of chart: Consider the type of data you have and choose a chart or graph that effectively represents that data.
• Use clear and descriptive labels: Ensure that any labels or titles on your charts or graphs are easy to understand and accurately represent the data.
• Keep it simple: Avoid cluttering your presentation with too many charts or graphs. Choose the most important data to represent visually.

Consistency in font styles and colors for a professional look

• Use a consistent font: Stick to one or two font styles throughout your presentation for a cohesive look.
• Use a consistent color scheme: Choose a color scheme that complements your overall presentation and stick to it for a professional look.
• Avoid using too many different styles: Keep your presentation clean and professional by avoiding an excessive use of different font styles and colors.

How to Update Excel Data in PowerPoint

Updating linked Excel data in PowerPoint can be a crucial part of maintaining accurate and up-to-date information in your presentations. Here’s a step-by-step guide on how to update Excel data in PowerPoint and some tips on how to ensure the data stays accurate.

Demonstrating the process of updating the linked Excel data in PowerPoint

1. Open your PowerPoint presentation and navigate to the slide containing the linked Excel data.

2. Right-click on the Excel chart or table and select "Edit Data" from the dropdown menu.

3. This will open the linked Excel spreadsheet. Make the necessary changes to the data and then save the Excel file.

4. Return to the PowerPoint presentation. You may be prompted to update the linked data. Click "Update" to ensure the changes are reflected in the presentation.

Providing tips for keeping the data accurate and up-to-date

Tip 1: Regularly review and update the linked Excel data to ensure accuracy.

Tip 2: Use named ranges in Excel to make it easier to update the data in PowerPoint without disrupting the layout.

Tip 3: Consider using Office 365’s co-authoring feature to collaborate on the Excel data with others in real-time.

Avoiding common pitfalls when updating linked Excel data

• Pitfall 1: Forgetting to update the linked data before a presentation, resulting in outdated information being displayed.
• Pitfall 2: Making changes directly in the PowerPoint slide instead of updating the linked Excel data, which can lead to discrepancies.
• Pitfall 3: Not keeping track of the changes made to the Excel data, leading to confusion and errors in the presentation.

Benefits of Inserting Excel into PowerPoint in Office 365

When it comes to creating a compelling and informative presentation, the ability to seamlessly integrate Excel spreadsheets into PowerPoint can be a game-changer. Here are the key benefits of incorporating Excel into your PowerPoint presentations:

Enhancing the visual appeal of the presentation

By inserting Excel charts and graphs into your PowerPoint slides, you can add visual interest and effectively illustrate your data in a clear and concise manner. This can help to capture the attention of your audience and make your presentation more engaging.

Providing the audience with interactive and dynamic data

With the ability to embed live Excel spreadsheets in your PowerPoint presentation, you can offer your audience the opportunity to interact with the data in real-time. This can help to enhance their understanding of the information and make your presentation more memorable.

Streamlining the process of updating data for future presentations

By linking Excel spreadsheets to your PowerPoint slides, you can easily update the data in your presentation as it changes over time. This can save you valuable time and effort when preparing for future presentations, as you won't have to manually update each individual slide.

Best Practices for Using Excel in PowerPoint Presentations

When it comes to creating impactful and compelling PowerPoint presentations, the integration of Excel data can add depth and credibility to your message. However, it's important to follow best practices to ensure that the Excel data seamlessly enhances your presentation. Here are some key best practices to keep in mind:

Identify the key message of your presentation:

Focus on visual representation:, keep it concise:, relevance is key:, provide context:, explain the data:, test the presentation flow:, time your data presentations:, seek feedback:.

Recap: Integrating Excel into PowerPoint in Office 365 is a powerful way to enhance your presentations with dynamic and interactive data visualizations. By seamlessly incorporating Excel spreadsheets, charts, and graphs, you can effectively communicate complex information to your audience.

Encouragement: As you continue to explore the functionalities of Office 365, I encourage you to experiment with different ways of incorporating Excel data into your presentations. Whether it's through linked or embedded data, or by utilizing the various design and formatting options available, the possibilities are endless for creating impactful and informative slides.

Immediate Download

MAC & PC Compatible

Free Email Support

Related aticles

The Benefits of Excel Dashboards for Data Analysts

Unlock the Power of Real-Time Data Visualization with Excel Dashboards

Unlocking the Potential of Excel's Data Dashboard

Unleashing the Benefits of a Dashboard with Maximum Impact in Excel

Exploring Data Easily and Securely: Essential Features for Excel Dashboards

Unlock the Benefits of Real-Time Dashboard Updates in Excel

Unleashing the Power of Excel Dashboards

Understanding the Benefits and Challenges of Excel Dashboard Design and Development

Leverage Your Data with Excel Dashboards

Crafting the Perfect Dashboard for Excel

An Introduction to Excel Dashboards

How to Create an Effective Excel Dashboard

• Choosing a selection results in a full page refresh.

How-To Geek

How to link or embed an excel worksheet in a powerpoint presentation.

Your changes have been saved

Email is sent

Email has already been sent

Please verify your email address.

You’ve reached your account maximum for followed topics.

Quick Links

What's the difference between linking and embedding, how to link or embed an excel worksheet in microsoft powerpoint.

Sometimes, you want to include the data on an Excel spreadsheet in a Microsoft PowerPoint presentation. There are a couple of ways to do this, depending on whether or not you want to maintain a connection with the source Excel sheet. Let's take a look.

You actually have three options for including a spreadsheet in a PowerPoint presentation. The first is by simply copying that data from the spreadsheet, and then pasting it into the target document. This works okay, but all it really does is convert the data to a simple table in PowerPoint. You can use PowerPoint's basic table formatting tools on it, but you can't use any of Excel's features after the conversion.

While that can be useful sometimes, your other two options---linking and embedding---are much more powerful, and are what we're going to show you how to do in this article. Both are pretty similar, in that you end up inserting an actual Excel spreadsheet in your target presentation. It will look like an Excel sheet, and you can use Excel's tools to manipulate it. The difference comes in how these two options treat their connection to that original Excel spreadsheet:

• If you link an Excel worksheet in a presentation, the target presentation and the original Excel sheet maintain a connection. If you update the Excel file, those updates get automatically reflected in the target presentation.
• If you embed an Excel worksheet in a presentation, that connection is broken. Updating the original Excel sheet does not automatically update the data in the target presentation.

There are advantages to both methods, of course. One advantage of linking a document (other than maintaining the connection) is that it keeps your PowerPoint presentation's file size down, because the data is mostly still stored in the Excel sheet and only displayed in PowerPoint. One disadvantage is that the original spreadsheet file needs to stay in the same location. If it doesn't, you'll have to link it again. And since it relies on the link to the original spreadsheet, it's not so useful if you need to distribute the presentation to people who don't have access to that location.

Embedding that data, on the other hand, increases the size of presentation, because all that Excel data is actually embedded into the PowerPoint file. There are some distinct advantages to embedding, though. For example, if you're distributing that presentation to people who might not have access to the original Excel sheet, or if the presentation needs to show that Excel sheet at a specific point in time (rather than getting updated), embedding (and breaking the connection to the original sheet) makes more sense.

So, with all that in mind, let's take a look at how to link and embed an Excel Sheet in Microsoft PowerPoint.

Linking or embedding an Excel worksheet into a PowerPoint presentation is actually pretty straightforward, and the process for doing either is almost identical. Start by opening both the Excel worksheet and the PowerPoint presentation you want to edit at the same time.

In Excel, select the cells you want to link or embed. If you would like to link or embed the entire worksheet, click on the box at the juncture of the rows and columns in the top left-hand corner to select the whole sheet.

Copy those cells by pressing CTRL+C in Windows or Command+C in macOS. You can also right-click any selected cell, and then choose the "Copy" option on the context menu.

Now, switch to your PowerPoint presentation and click to place the insertion point where you would like the linked or embedded material to go. On Home tab of the Ribbon, click the down arrow beneath the "Paste" button, and then choose the "Paste Special" command from the dropdown menu.

This opens the Paste Special window. And it's here where you'll find the only functional different in the processes of linking or embedding a file.

If you want to embed your spreadsheet, choose the "Paste" option over on the left. If you want to link your spreadsheet, choose the "Paste Link" option instead. Seriously, that's it. This process is otherwise identical.

Whichever option you choose, you'll next select the "Microsoft Excel Worksheet Object" in the box to the right, and then click the "OK" button.

And you'll see your Excel sheet (or the cells you selected) in your PowerPoint presentation.

If you linked the Excel data, you can't edit it directly in PowerPoint, but you can double-click anywhere on it to open the original spreadsheet file. And any updates you make to that original spreadsheet are then reflected in your PowerPoint presentation.

If you embedded the Excel data, you can edit it directly in PowerPoint. Double-click anywhere in the spreadsheet and you'll stay in the same PowerPoint window, but the PowerPoint Ribbon gets replaced by the Excel Ribbon and you can access all the Excel functionality. It's kind of cool.

And when you want to stop editing the spreadsheet and go back to your PowerPoint controls, just click anywhere outside the spreadsheet.

• Microsoft Office
• Microsoft Excel

• Preferences

Introduction to Excel - PowerPoint PPT Presentation

Introduction to Excel

A tool used to store, organize, and analyze information. based on rows, ... perform statistical analyses using the function wizard or add-on analysis packet ... – powerpoint ppt presentation.

• Psychology 209
• Autumn 2004
• A Tool used to Store, Organize, and Analyze Information
• Based on Rows, Columns and Cells
• Cells are the Intersection of Rows and Columns
• Labels and data are entered into the cells
• But it is also more than a spreadsheet
• perform statistical analyses using the function wizard or add-on analysis packet
• present graphical information using the Chart Wizard
• A workbook is like a document
• Worksheets make up the workbook and are like pages of the document
• Individual worksheets are represented by tabs at the bottom of the screen
• There are two ways enter information into a cell
• 1) Type directly into the cell
• Click on a cell, and type in the numbers or words, and press Enter
• 2) Into the formula bar
• Click on a cell, and then click in the
• formula bar. Now type in the data into
• the formula bar, and press Enter
• Clicking on a cell selects the cell
• If there is already data in the cell, it will be deleted when you type
• To go back and edit the original data, double click on the cell. A cursor will appear and you can then edit the cell
• To select a group of cells, click on the topmost or leftmost cell that you want to select and drag over the other cells that you want to include
• To select a row or column, click on the label of either the top of the column or the left of the row
• By using buttons on the toolbar, you can change the format of numbers.
• For example, to change your numbers to currency
• Select cells
• Push the dollar sign button on the toolbar
• represents currency, comma represents numbers and represents percents
• The toolbar can be used to change the look of the data in a cell
• Click on the cell, and then you can use all the commands you are familiar with from Word (such as Bold, Underline)
• You can also change the size or rows and columns by clicking on the right border of the column label or the bottom border of the row label and drag to resize, OR double click to have Excel automatically resize the row or column to fit your data
• All formulas begin with an and can be entered in a cell or in the formula bar
• Formulas can use normal mathematical operators to perform calculations (, -, , /, )
• Pressing enter after typing the formula will display the result
• Double clicking on the cell will allow you to edit the formula
• Remember that each cell is an intersection of a row and a column. Thus each cell has a unique label that is the combination of the row and column names in that order
• The top left cell in column A and Row 1 is called A1.
• These labels can be used in formulas to access the data in that cell
• You can refer to multiple cells by specifying the first and last cells of the group with a colon in between the cell labels (e.g. A1A5)
• A shortcut to get a cells label
• While typing a formula, click on the cell that you want to refer to and the label will appear in the formula
• You can also refer to multiple cells in this way by clicking on the first cell of the group and dragging to the last cell of the group
• If, while entering a formula, you want to move to another cell rather than reference that cell, you must either hit enter to finish the formula or escape to cancel
• Excel provides a lot of mathematical and statistical equations for your convenience
• There are two possible formats for the functions we will use today
• Function Name(beginning cell labelend cell label)
• Function Name(first cell label, second cell label, third cell label, etc)
• SUM(A1,A2,A3,A4,A5,A6,A7,A8,A9,A10)
• Clicking on will show you a list of all of the functions available (and give you more information about how to use them)
• To take data from one cell and copy into other cells
• Select the cell
• Click on the little square in the bottom-right corner of the cell
• Drag over the cells that you want to have the data copied into
• Formulas can also be copied from one cell to other cells.
• If the formula contains a label, then either the row or column part of the label will be incremented (column if you move right or left, row if you move up or down)
• If you do not want the formula to be incremented, type the label as columnrow (e.g. A1)
• Excel will calculate means, medians, modes, standard deviations, variances, and correlation coefficients for you.
• You may directly write the formulas for these statistics into the formula bar OR
• You may use the function wizard (fx in the toolbar).
• We recommend using the function wizard.
• Suppose you are
• interested in
• calculating the
• descriptive
• statistics for the
• following data
• Using the function wizard (fx in the toolbar) calculate the mean, median, mode, standard deviation, and variance.
• The corresponding formulas in Excel are
• AVERAGE (mean),
• STDEVP (population standard deviation),
• VARP (population variance)
• See the Word document Excel Histogram Handout for instructions on creating a histogram in Excel.
• This handout uses the Stress data that you have already entered into your spreadsheet

PowerShow.com is a leading presentation sharing website. It has millions of presentations already uploaded and available with 1,000s more being uploaded by its users every day. Whatever your area of interest, here you’ll be able to find and view presentations you’ll love and possibly download. And, best of all, it is completely free and easy to use.

You might even have a presentation you’d like to share with others. If so, just upload it to PowerShow.com. We’ll convert it to an HTML5 slideshow that includes all the media types you’ve already added: audio, video, music, pictures, animations and transition effects. Then you can share it with your target audience as well as PowerShow.com’s millions of monthly visitors. And, again, it’s all free.

About the Developers

PowerShow.com is brought to you by  CrystalGraphics , the award-winning developer and market-leading publisher of rich-media enhancement products for presentations. Our product offerings include millions of PowerPoint templates, diagrams, animated 3D characters and more.

Module 15: Integration

Introduction to using powerpoint with excel, what you’ll learn to do: use excel elements in powerpoint.

PowerPoint is the primary computer application used for business presentations. Knowing how to integrate a variety of charts, images, clip art, and so on is important to fill out a presentation and have it efficiently communicate to your desired audience. Elsewhere in this module, a Word document was modified and integrated with other computer applications. This section focuses on integration within PowerPoint.

PowerPoint integration skills will assist you to powerfully communicate whatever business information you are trying to get across. To accomplish this, let’s look at an example scenario in which PowerPoint integration is helpful.

Rowan Retail is planning to increase store sales in all three of its branches in the third quarter of this year. In order to coordinate the sales campaign, Cameron is creating the sales campaign presentation for the company’s next regional meeting. He has all the information he needs and is ready to create his sales presentation.

As Cameron will discover, each presentation can be a mix of both new and existing content. There are many ways to incorporate a variety of things into PowerPoint. Frequently creating and editing a presentation is a back-and-forth process. Presentations must not only be filled with appropriate information, but also must be visually dynamic for an audience.

Over time, your experience with PowerPoint will increase and you will discover other ways to integrate things into your presentations. They can be live, recorded, timed, and easily emailed to interested parties, so good PowerPoint skills are essential to business.

Contribute!

Improve this page Learn More

• Introduction to Using PowerPoint with Excel. Authored by : Sherri Pendleton. Provided by : Lumen Learning. License : CC BY: Attribution

Excel Tutorial

Excel formatting, excel data analysis, table pivot, excel functions, excel how to, excel examples, excel references, excel introduction, what is excel.

Excel is pronounced "Eks - sel"

It is a spreadsheet program developed by Microsoft. Excel organizes data in columns and rows and allows you to do mathematical functions. It runs on Windows, macOS, Android and iOS.

The first version was released in 1985 and has gone through several changes over the years. However, the main functionality mostly remains the same.

Excel is typically used for:

• Data management
• Data analysis
• Visuals and graphs
• Programming
• Financial modeling
• And much, much more!

Why Use Excel?

• It is the most popular spreadsheet program in the world
• It is easy to learn and to get started.
• The skill ceiling is high, which means that you can do more advanced things as you become better
• It can be used with both work and in everyday life, such as to create a family budget
• It has a huge community support
• It is continuously supported by Microsoft
• Templates and frameworks can be reused by yourself and others, lowering creation costs

Get Started

This tutorial will teach you the basics of Excel.

It is not necessary to have any prior experience with spreadsheet programs or programming.

COLOR PICKER

Contact Sales

If you want to use W3Schools services as an educational institution, team or enterprise, send us an e-mail: [email protected]

Report Error

If you want to report an error, or if you want to make a suggestion, send us an e-mail: [email protected]

Top Tutorials

Top references, top examples, get certified.