microsoft excel presentation pdf

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.

Introduction to Microsoft Excel

Published by Kelly Hodge Modified over 9 years ago

Presentation on theme: "Introduction to Microsoft Excel"— Presentation transcript:

Introduction to Excel This class is “HANDS-ON” you will need to open up an excel spreadsheet and do examples as you go along. Students will be able to.

Insert complete company name Creating an Excel Spreadsheet Using Excel 2000.

(MICROSOFT EXCEL). Is a spreadsheet application designed to take advantage of the windows graphical interface MICROSOFT EXCEL.

TUTORIAL 1 Getting Started with Excel

Excel Vocabulary.

MS EXCEL is a spreadsheet application Excel covers: Calculation Graphic tools Pivot tables Macro programming language called VBA EXCEL is a part of MS.

Lesson 12 Getting Started with Excel Essentials

Microsoft Excel Manual 1 By Pradeep velugoti Lakshman Tallam.

FORMULAS & FUNCTIONS EXCEL. Input A collection of information Data typed into the spreadsheet Output Worksheet Results.

Microsoft Office XP Microsoft Excel

Spreadsheets A spreadsheet package is a general purpose computer package that is designed to perform calculations. A spreadsheet is a table which is divided.

Microsoft Excel. Click on “Start,” then “Microsoft Office Excel.”

Introduction to Microsoft Excel 2010 Chapter Extension 3.

Pasewark & Pasewark 1 Excel Lesson 4 Entering Worksheet Formulas Microsoft Office 2007: Introductory.

GO! with Microsoft® Excel e

Exploring Microsoft Excel 2002 Chapter 1 Chapter 1 Introduction to Microsoft Excel: What is a Spreadsheet? By Robert T. Grauer Maryann Barber Exploring.

Microsoft Excel Computers Week 4.

3-dimensional formula A formula that refers to cells in other worksheets.

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

About project

Academia.edu no longer supports Internet Explorer.

To browse Academia.edu and the wider internet faster and more securely, please take a few seconds to upgrade your browser .

Enter the email address you signed up with and we'll email you a reset link.

We're Hiring!
Help Center

The Beginner’s Guide to Microsoft Excel

Save or convert to PDF or XPS in Office Desktop apps

You can use the Office programs to save or convert your files to PDFs so that you can share them or print them using commercial printers. And you won’t need any other software or add-ins.

Use PDF format when you want a file that:

Looks the same on most computers.

Has a smaller file size.

Complies with an industry format.

Examples include resumes, legal documents, newsletters, files that are intended to be read (not edited) and printed, and files that are intended for professional printing.

Important:

Many programs, including Microsoft Word, have the ability to open and edit PDF files. Simply sharing something as a PDF is not sufficient to guarantee the recipient can't edit the file.

When you convert your spreadsheet to a PDF, the internal links within the spreadsheet will get lost during the conversion so the links will need to be verified. External links to other sources however will be fine.

To see step-by-step instructions, select an Office program from the drop-down list.

Which Office program are you using?

Open the table or report you want to publish as a PDF.

On the External Data tab, in the Export group, select PDF or XPS .

In the File Name field, type or select a name for the document.

In the Save as type list, select PDF (*.pdf) .

If the document requires high print quality, select Standard (publishing online and printing) .

If file size is more important than print quality, select Minimum size (publishing online) .

Select Options to set the page to be printed, to choose whether markup should be printed, and to select output options. Select OK .

Select Publish .

Note: You can’t save Power View sheets as PDF files.

Select the File tab.

Select Save As . To see the Save As dialog box in Excel 2013 or Excel 2016, you have to choose a location and folder.

In the File Name box, enter a name for the file, if you haven't already.

If you want the file to open in the selected format after saving, select the Open file after publishing check box .

Select Options to set the page to be printed, to choose whether markup should be printed, and to select output options. For more information on the Options dialog box in Excel, see More about PDF options . Select OK when finished.

Select Save .

Select Export .

Under Export Current , select what part of the notebook you want to save as PDF.

Under Select Format , select PDF (*.pdf) , and then select Export .

In the Save As dialog box, in the File Name field, enter a name for the notebook.

Select Save As . To see the Save As dialog box in PowerPoint 2013 or PowerPoint 2016 , you have to choose a location and folder.

If you want the file to open in the selected format after saving, select the Open file after publishing check box.

If the file size is more important than print quality, select Minimum size (publishing online) .

Select Options to set the page to be printed, to choose whether markup should be printed, and to select output options. Select OK when finished.

On the File tab, choose Save As . To see the Save As dialog box in Project 2013 or Project 2016, you have to choose a location and folder.

In the Save as type list, select PDF Files (*.pdf) or XPS Files (*.xps) , and then choose Save .

In the Document Export Options dialog box, select a Publish Range , whether to Include Non-printing Information , and ISO 19500-1 compliance (PDF only).

Formatting tips

Project doesn’t support every PDF or XPS formatting feature, but you can still use some print options to change the look of the final doc.

Choose File > Print , and then change any of these options:

Orientation

In the Page Setup dialog box, you can change options on these tabs:

Select Save As . To see the Save As dialog box in Publisher 2013 or Publisher 2016, you have to choose a location and folder.

If you want to change how the document is optimized, select Change . (Select Options in Publisher 2013 or Publisher 2016.)

Make any changes you want to the picture resolution and non-printing information.

Select Print Options to make changes to the printing options for the document.

Select OK when finished.

Select Save As . To see the Save As dialog box in Visio 2013 or Visio 2016, you have to choose a location and folder.

If you want the file to open in the selected format after saving, select the Automatically view file after saving check box.

If the file was previously saved, select File > Save a Copy . If the file is unsaved, select File > Save As .

Select Browse to choose the location on your computer where you want to save the file.

In the drop-down list, select PDF .

Image showing selection of 'PDF (*.pdf) from dropdown menu

Select More Options > Options to customize your PDF.

To make a PDF file from only some of the pages in your document, choose an option under Page range .

To include tracked changes in the PDF, under Publish what , select Document showing markup . Otherwise, make sure Document is selected.

To create a set of bookmarks in the PDF file, select Create bookmarks using . Then, choose Headings or, if you added bookmarks to your document, Word Bookmarks .

If you want to include document properties in the PDF, make sure Document properties is selected.

To make the document easier for screen-reading software to read, select Document structure tags for accessibility .

ISO 19005-1 compliant (PDF/A) This option outputs the PDF document as version 1.7 PDF, which is an archiving standard. PDF/A helps to insure that a document will look the same when it’s opened later on a different computer.

Bitmap text when fonts may not be embedded If fonts can't be embedded into the document, the PDF uses bitmap images of the text so that the PDF looks the same as the original document. If this option isn’t selected and the file uses a font that can't be embedded, then the PDF reader might substitute another font.

Encrypt the document with a password To restrict access so only people with the password can open the PDF, select this option. When you select OK , Word opens the Encrypt PDF Document box, where you can type and re-enter a password.

Open and copy content from a PDF with Word

You can copy any content you want from a PDF by opening it in Word.

Go to File > Open and browse to the PDF file. Word opens the PDF content in a new file. You can copy any content you want from it, including images and diagrams.

To save your file as a PDF in Office for Mac, follow these easy steps:

Select File.

Choose Save As.

Select File Format at the bottom of the window.

Use the File Format tool in Word's Save As to select other formats, like PDF, to save to

Choose PDF from the list of available file formats.

Give your file a name, if it doesn't already have one, then select Export.

Note: When using Best for printing , the hyperlinks may not convert correctly. This is a known issue in Word for Mac.

When using Online Service , only font that Microsoft has the legal rights to can be used. If the documentation contains custom font, it will be substituted and may cause problems. This can be avoided by embedding the fonts into the document.

Learn more about embedding fonts by visiting:

Benefits of embedding custom fonts

Some of your fonts can't be saved with the presentation

You can use Word, PowerPoint, and OneNote for the Web to convert your doc into a PDF.

Select File > Print > Print (in PowerPoint you will select one of three formats).

In the dropdown menu under Printer , select Save as PDF and then select Save .

Then in the Explorer menu that opens you can name the PDF and choose where to save it and then select Save .

This will generate a basic PDF that preserves the layout and format of your original document.

If you need more control over the options for your PDF, such as adding bookmarks, use the desktop app to convert your doc to a PDF. Select Open in Desktop App in the toolbar of PowerPoint and OneNote to start using the desktop app, and in Word select the Editing dropdown first and then select Open in Desktop App .

Image of the Open in Desktop App command

If you don’t own the desktop app, you can try or buy Microsoft 365.

To export your Word document or Excel workbook to PDF format on iOS tap the File button at the top left, choose Export and then PDF .

Portable Document Format (PDF) preserves document formatting and enables file sharing. When the PDF format file is viewed online or printed, it retains the format that you intended. The PDF format is also useful for documents that will be reproduced using commercial printing methods. PDF is accepted as a valid format by many agencies and organizations, and viewers are available on a wider variety of platforms than XPS.

XML Paper Specification (XPS) is an electronic file format that preserves document formatting and enables file sharing. The XPS format ensures that when the file is viewed online or printed, it retains exactly the format that you intended, and that data in the file cannot be easily changed.

Important: Most modern web browsers can open and display a PDF file. If you have an older operating system, however, you may need a PDF reader installed on your device such as the Acrobat Reader , available from Adobe Systems .

Edit or make changes to a PDF file

Create accessible PDFs

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.

COMMENTS

PDF Microsoft Excel Step by Step (Office 2021 and Microsoft 365)
Who this book is for. Microsoft Excel Step by Step (Office 2021 and Microsoft 365) is designed for use as a learn-ing and reference resource by people who want to use Excel to manage data, perform calculations, create useful analyses and visualizations, generate forecasts, and discover insights into their operations.
Introduction to Microsoft Excel (Spreadsheet Software) PowerPoint
How Microsoft Excel (spreadsheet software) can enhance daily life. . Learning Objectives: To understand how Microsoft Excel (spreadsheet software) works. . Activity 3: Lesson. The parts of a worksheet that are numbered from top to bottom.
PDF Microsoft Excel 2019 Fundamentals Workshop
A. Launch Excel To launch Excel for the first time: 1. Click on the Start button. 2. Click on All Programs. 3. Select Microsoft Office from the menu options, and then click on Microsoft Excel 2019. Note• +: After Excel has been launched for the first time, the Excel icon will be located on the Quick Launch pane.
PDF Introduction to Excel
To get into Excel, simply double click on the Microsoft Excel icon if there is one on the computer desktop. Alternatively, click on the Start button in the bottom left corner of the screen, move the cursor to Programs to open up the programs menu, and then click on Microsoft Excel. Your computer should display the basic Excel screen shown in ...
PDF PDF GUIDE
in Excel. If you have a basic understanding of about a hundred key func-tions, you'll be far ahead of the average user. This document contains a brief overview of about 100 important Excel functions you should know, with links to detailed examples. It is based on a more complete list of Excel functions here. Excel Function List
PDF 5.2 Microsoft Excel
When you click the minimize button the program becomes a button on the Windows taskbar located at the bottom of the screen. You can restore the document to its original shape and size by either: Clicking on the button on the task bar one time to restore it to active mode, If you have multiple files from the same program open you will need to ...
PDF Excel 2016 Introduction
5 of 17 Microsoft Excel 2016: Introduction Autofill You can use the AutoFill tool to fill data into worksheet cells. You can also have Excel automatically continue a series of numbers, number and text combinations, dates, or time periods, based on a pattern that you establish.
(PDF) INTRODUCTION TO MICROSOFT EXCEL
The Presentation was given as the introductory part of a mentorship training on Data science, Initiated by me. ... INTTRODUCTION TO MICROSOFT EXCEL.pdf. ... the Microsoft Excel different functions ...
PDF Microsoft Excel 2013 Fundamentals Manual
Overview. This manual provides instructions with the fundamental spreadsheet features of Microsoft Excel 2013. Topics covered in this document will help you become more proficient with the Excel application. Specific focuses include building spreadsheets, worksheet fundamentals, working with basic formulas, and creating charts.
Introduction to Microsoft Excel
Download ppt "Introduction to Microsoft Excel". Spreadsheet: Electronic sheet of paper organized by columns & rows The advantage of an electronic spreadsheet is it allows you to easily change data and have all "related" calculations automatically update.. Excel is basically a software package that allows you to easily work with data in a ...
PDF Microsoft Excel 20 21 Basic
N. Double-click a workbook. Open a Workbook: Click the File tab and select Open or press Ctrl + O. Select a recent file or navigate to the location where the file is saved. Preview and Print a Workbook: Click the File tab and select Print. Undo: Click the Undo button on the Quick Access Toolbar.
PDF Ms-excel Lecture Notes
Click on Microsoft Start Button. Point the mouse on All Programs. k on Microsoft OfficeClick on Microsoft Excel 2007 The Microsoft Excel window appears and your screen looks similar. icrosoft Office ButtonIn the upper-left corner of the Excel 2007 window is the M. crosoft Office button. When you click the.
PDF EXCEL BASICS: MICROSOFT OFFICE 2010
To open the program, point to Excel's icon on the desktop with your mouse and double-click on it with the left mouse button. If you don't see the Excel icon on your desktop, you'll have to access the program from the Start Menu. Click on the button in the bottom left corner to pull up the Start Menu.
PDF Introduction to Microsoft Excel: Part 1
On the taskbar, click the Start button. In the Start menu, point to Programs (or All Programs). In the Programs menu, click the Microsoft Excel program icon. When you create a new workbook in Excel, you begin with three worksheets. You can add many more worksheets to a workbook if you need them (up to 255).
(PDF) The Beginner's Guide to Microsoft Excel
First, click the cell where you would like the total to display. Next, click the AutoSum button. Excel will automatically detect the numbers you want to add. They will be highlighted and you can see the formula which may appear something like this: =SUM (C2:C7) Note: The equal sign indicates a formula.
Excel video training
Learn Excel skills from beginner to advanced with video tutorials, templates, and tips from Microsoft Support.
PDF 5.1 Introduction to Microsoft Excel Lesson Plan
• 5.2 Introduction to Microsoft Excel Presentation • From Student Folder o 5.0.2 Microsoft Excel Screen Components Quiz o 5.0.3 Budget Activity In Class . Tell students that Introduction to Microsoft Excel is a two (2) to four (4) hour course designed to familiarize students with terminology, screen components and the most commonly used
Save or convert to PDF or XPS in Office Desktop apps
Select in the toolbar of PowerPoint and OneNote to start using the desktop app, and in Word select the Editing dropdown first and then select. To export your Word document or Excel workbook to PDF format on iOS tap the. Portable Document Format (PDF) preserves document formatting and enables file sharing.