Free download excel 2007 dummiespdf

---

Editing Data To select text with the mouse, you can click the mouse in one of three ways, as shown in Figure Selecting data with the keyboard To select data with the keyboard, you need to use the following keys: To select text, you can either double- or triple-click it. Getting to Know Microsoft Office The cursor movement keys simply move the cursor.

Click the left mouse button. Office undoes all the multiple actions you selected. Adding icons The Quick Access toolbar is designed to put your most commonly used commands where you can always find them.

You may find it easier to place the cursor with the mouse and then hold down the Shift key while pressing a cursor movement key to select data more precisely than you can by dragging the mouse. Selecting multiple chunks of data with the mouse and keyboard For greater flexibility in selecting data, you can use both the mouse and the keyboard to select multiple chunks of data at the same time. To select two or more chunks of data, follow these steps: Select a picture or chunk of text using either the keyboard or the mouse.

The keyboard is slower but much simpler to use. Selecting data with the mouse The mouse provides two ways to select data. The first way involves pointing and dragging the mouse, as shown in Figure Point the mouse pointer at the beginning or end of the data you want to select.

This causes the dialog box to expand, as shown in the bottom dialog box in Figure Now you can click Computer, under Favorite Links, and then click a folder. Or, click the New Folder button; when the New Folder dialog box appears, type a name for your new folder and then click OK.

Click Blank such as Blank Document or Blank Workbook and then click the Create button. A blank file appears ready for you to start storing data in it.

Click a command icon on the pop-up toolbar. Deleting Data The simplest way to edit a file is to delete your existing data. If you just need to delete a single character, you can use one of two keys: Deletes the character immediately to the right of the cursor If you need to delete large chunks of text, follow these steps: Select the data you want to delete using either the keyboard or the mouse.

Saving files Saving a file stores all your data on a hard disk or other storage device such as a Compact Flash card. The first time you save a file, you need to specify three items: By default, Office stores all your files in the Documents folder.

Repeat this step as many times as necessary. Click the file you want to open and then click Open. Your chosen file appears ready for editing. Getting to Know Microsoft Office When you click the Open command under Microsoft Word, Excel, PowerPoint, and Access, an additional window appears to free download excel 2007 dummies.pdf right that contains a list of the last files you opened.

Then choose a command that changes your data, such as underlining text or deleting a picture. To select anything in Officeyou can use either the mouse or the keyboard. Generally, the mouse is faster but takes some time getting used to coordinating the motion free download excel 2007 dummies.pdf the mouse with the movement of the mouse pointer on the screen.

Slideshare uses cookies to improve functionality and performance, and to provide you with relevant advertising. If you continue browsing the site, you agree to the use of cookies on this website. See our User Agreement and Privacy Policy. See our Privacy Policy and User Agreement for details.

Published on Jan 28, Clipping is a handy way to collect and organize the most important slides from a presentation. You can keep your great finds in clipboards organized around topics. SlideShare Explore Search You. Microsoft office for dummies. Show related SlideShares at end.

The Save as Type list box displays a huge list of file formats, such as XML Data or Text. Most programs can accept files stored in the format, free download excel 2007 dummies.pdf many older programs cannot, so you may have to resort to saving a file in one of these other formats instead.

Using the Ribbon is a two-step process. First, you must click the tab that contains the command you want. Second, you click the actual command. Tabs act exactly like traditional pull-down menus. Whereas a pull-down menu simply displays a list of commands, tabs free download excel 2007 dummies.pdf a list of icons that represent different commands. Deciphering Ribbon icons The main idea behind organizing commands within tabs is to avoid overwhelming you with a barrage of different commands.

Editing can add, rearrange, or delete data, such as text, numbers, or pictures. Adding Data by Pointing When you enter data into a file, your data appears wherever the cursor appears on the screen. To move the cursor using the mouse, follow these steps: Move the mouse pointer where you want to move the cursor.

This icon highlights information that can save you time or make it easier for you to do something. Introduction This icon emphasizes information that can be helpful, although not crucial, when using Office This icon highlights something dangerous that you need to avoid before making a mistake that you might not be able to recover from again.

To move data, you can first cut it from your file, store it on the Clipboard, and then paste it into a new location in your file. Editing Data If you select data in Step 3, you can replace the selected data with the pasted data you selected in Steps 1 and 2.

To hide the Ribbon, follow these steps: Getting to Know Microsoft Office 1. Click Minimize the Ribbon. Office hides the Ribbon and only displays the tabs. To display the Ribbon again, repeat these two steps.

Microsoft is a trademark or registered trademark of Microsoft Corporation. All other trademarks are the property of their respective owners. NEITHER THE PUBLISHER NOR THE AUTHOR SHALL BE LIABLE FOR DAMAGES ARISING HEREFROM. For general information on our other products and services, please contact our Customer Care Department within the U.

The Shift key acts like the left mouse button and tells Office what to select. To select data, you have to follow these steps: Move the cursor to the beginning or end of the data you want to select. Hold down the Shift key. Free download excel 2007 dummies.pdf it pressed down. Move the cursor using any of the cursor movement keys, such as the up-arrow key or the End key. Release the Shift key.

Just hold down the Ctrl key, press the Z key, and release both keys at the same time. Mastering Office is going to be easier than you think. Part I Getting to Know Microsoft Office A In this part. But after you get over free download excel 2007 dummies.pdf initial impression or fear of Office, you can understand and even admire the elegant madness behind its massive bulk.

Second, you can click the downward-pointing arrow that appears to the right of the Undo icon to display a list of one or more of your previous actions, as shown in Figure The Undo icon displays a list of actions you can undo. Getting to Know Microsoft Office The most recent action you chose appears at the top of this list, the second most recent action appears second, and so on.

The Options window lets you select the icons you want to add to the Quick Access toolbar. Click in the Choose Commands From list box and choose a menu title, such as File or Page Layout.

Office creates a new file based on your chosen template. To retrieve these templates, you need to connect to the Internet and then follow these steps: Click the Office Button and then choose New.

Hold down the Ctrl key. Select another picture or chunk of test using either the keyboard or the mouse. Repeat Step 3 for each additional item you want to select. Editing Data with the Pop-up Toolbar As soon as you select data, Office displays a pop-up toolbar that displays the most commonly used commands displayed as icons.

Visibility Others can see my Clipboard.

Although most icons include a short text description, you can get additional help deciphering different icons through ScreenTips, which typically displays the following, as shown in Figure ScreenTips explain what each command does. To view the ScreenTip for a command, move the mouse pointer over a command and wait a few seconds for the ScreenTip appear.

Working with Word Word processing is the most popular use for Officeso this part of the book explains the basics to using Word. Not only does this part of the free download excel 2007 dummies.pdf explain how to create and save text, but it also covers different ways to alter text, such as using color, changing fonts, adding headers and footers, checking spelling and grammar, and printing your written masterpiece so it looks perfect.

There are two ways to use the Help system. One, you can browse through the various topics displayed until you find the answer you want. This can take time to search but can also show you related help that you might find useful.

How to Use This Book Although you can just flip through this book to find the features you need, consider reading Part I of this book to discover how the new menus and toolbar icons of Office work and how they differ from previous versions of 3 Conventions To get the most from this book, you need to understand the following conventions: First, you use the mouse pointer to select data text, numbers, e-mail messages, and so on to change. Second, you use the mouse pointer to tell Office which commands you want to use to change the data you selected.

A drop-down menu appears. Getting to Know Microsoft Office Figure The Save As dialog box lets you choose the name, file format, and a location to save your file. Optional To specify a drive and folder to save your file, click Browse Folders.

Additional thanks must also go to Chris free download excel 2007 dummies.pdf Zooman Clobber, Dante, Rick Gene, Wes Sample, Justin Davis, and Leo the man, the myth, the legend Fontaine just because they like seeing free download excel 2007 dummies.pdf names in print for no apparent reason.

That way when you figure out how to use one Office program, you can quickly learn and use any other Office program with a minimum of retraining and hassle, and you can then join the ranks of the many happy people already using Microsoft Office to get their work done. Word, Excel, PowerPoint, Access, and Outlook. Each of these core programs specializes in manipulating different data. Word manipulates words, sentences, and paragraphs; Excel manipulates numbers; PowerPoint manipulates text and pictures to create a slide show; Access manipulates data, such as inventories; and Outlook manipulates personal information, such as e-mail addresses and phone numbers.

Office provides three types of templates: Getting to Know Microsoft Office Using an Office template on your computer Installing Office automatically installs dozens of templates for Word, Excel, PowerPoint, and Access. To use one of these templates, follow these steps: Click the Office Button and choose New. A New window appears refer to Figure The New window displays all the installed templates on your computer. Click the template you want to use and then click the Create button.

The Redo command lets you reapply the last command you chose to undo. Each time you choose the Redo command, you reverse the effect of the last Undo command. For example, if you use the Undo command four times, you can choose the Redo command only up to four times. Sharing Data with Other Office Programs Cutting, copying, and pasting data may be handy within the same file, but Office also gives you the free download excel 2007 dummies.pdf to cut, copy, and paste data between different programs, such as copying a chart from Excel and pasting free download excel 2007 dummies.pdf into a PowerPoint presentation.

The Redo icon reverses the last Undo command you chose. For example, if you delete a paragraph, Office makes that paragraph disappear. Then if you immediately click the Undo icon, the paragraph magically reappears. If you immediately click the Redo icon, the Redo command reverses the Undo command and deletes the paragraph once more. The Undo icon is unique in that it offers two ways to use it. First, you can click the Undo icon to undo the last action you chose.

Free download excel 2007 dummies.pdf of the people who helped bring this book to market include the following: Acquisitions, Editorial, and Media Development Composition Associate Project Editor: Jean Rogers Acquisitions Editor: Bob Woerner Senior Copy Editor: Teresa Artman Technical Editor: Lee Musick Editorial Manager: Kevin Kirschner Media Development Specialists: Angela Denny, Kate Jenkins, Steven Kudirka, Kit Malone Project Coordinator: Kristie Rees Layout and Graphics: Jonelle Burns, Lavonne Cook, Denny Hager, Joyce Haughey, Barbara Moore, Barry Offringa, Free download excel 2007 dummies.pdf Ryan Proofreaders: David Faust, Techbooks Indexer: Techbooks Anniversary Logo Design: Richard Pacifico Media Development Coordinator: Laura Atkinson Media Project Supervisor: Laura Moss Media Development Manager: Laura VanWinkle Media Development Associate Producer: Richard Graves Editorial Assistant: Corder, Editorial Director Publishing for Consumer Dummies Diane Graves Steele, Vice President and Publisher Joyce Pepple, Acquisitions Director Composition Services Gerry Fahey, Vice President of Production Services Debbie Stailey, Director of Composition Services 7.

The cursor appears where you click the mouse pointer. Getting to Know Microsoft Office To move the cursor using the keyboard, you can use one of many cursor movement keys: To move the cursor faster, hold down the Ctrl key and then press the arrow free download excel 2007 dummies.pdf. If you hold down the Ctrl key, the up-arrow key moves the cursor up one paragraph, the down-arrow key moves the cursor down one paragraph, the left-arrow key moves the cursor left one word, and the free download excel 2007 dummies.pdf key moves the cursor right one word.

For technical support, please visit www. Wiley also publishes its books in a variety of electronic formats. Some content that appears in print may not be available in electronic books. Library of Congress Control Number: About the Author The author currently divides his time between writing computer books, writing articles for CPU Magazine, performing stand-up comedy, and writing and speaking on a weekly comedy radio show along with fellow comedians Rick Gene, Wes Sample, and Justin Davis.

Alternatively, to copy data, hold down the Ctrl key while holding down the left mouse button and dragging moving the mouse. The mouse pointer displays an arrow and a box with a plus sign while the cursor turns into a dotted vertical line. Move the dotted vertical line cursor where you want to place the data you selected in Step 1. Release the left mouse button. Your data appears in its new location. Pretend I never chose it.

Final thanks go to Cassandra my wifeJordan my sonand Bo, Scraps, Tasha, and Nuit our cats for making my life more interesting by the minute. These two are the best agents an author could hope for, so they deserve all the 15 percent of the book royalties that they get. Additional thanks go to technical editor Lee Musick for making sure that everything in this book is accurate. Thanks for reading this — and say a prayer for all the trees that sacrificed their free download excel 2007 dummies.pdf to allow authors such as myself the indulgence to print paragraphs such as this.

Creating a new file from a template Rather than create free download excel 2007 dummies.pdf blank file, you may find it easier to use a template instead. A template contains predefined formatting for creating different types of files easily, such as calendars, newsletters, sales reports, or a corporate slide show presentation.

To free download excel 2007 dummies.pdf an icon, follow these steps: Right-click an icon on the Quick Access toolbar. Click Remove from Quick Access Toolbar. Office removes your selected icon from the Quick Access toolbar. Moving the Quick Access toolbar The Quick Access toolbar can appear in one of two places: Click the Customize Quick Access Toolbar arrow.

Viewing and pasting items off the Office Clipboard After you use the Cut or Copy command at least once, your data gets stored on the Office Clipboard. You can then view the Office Clipboard and choose which data you want to paste from the Clipboard into your file. To view the Office Clipboard and paste items from it, follow these steps: Move the cursor to the spot where you want to paste an item from the Free download excel 2007 dummies.pdf Clipboard.

The show airs on He also spends much of his free download excel 2007 dummies.pdf trying to keep his various computers running properly using an odd mixture of Windows, Linux, and Mac OS X software.

Despite the fact that Microsoft Office contains more commands than any sane person could ever possibly free download excel 2007 dummies.pdf, it can be conquered. Perhaps the most important part of this book explains the completely redesigned user interface of Microsoft Office To guide you through the multitude of commands you may need to get your work done, Office provides several ways to get help, free download excel 2007 dummies.pdf of which hopefully will actually provide you with the answers you need.

Click the Close box of the Office Clipboard window to tuck free download excel 2007 dummies.pdf out of sight. If you click the Paste All button, you can paste every item on the Office Clipboard into your file.

Although each Office program specializes free download excel 2007 dummies.pdf storing and manipulating different types of data, they all work in similar ways. First, you have to enter data into an Office program by typing on the keyboard or loading data free download excel 2007 dummies.pdf an existing file.

To copy and paste data, follow these steps: To move data with the mouse, follow these steps: Move the mouse pointer over the highlighted data. Hold down the left mouse button and drag move the mouse. The mouse pointer displays an arrow and a box while the cursor turns into a dotted vertical line.

For these people, this book can serve as a guide through word processing Microsoft Wordnumber calculations Microsoft Excelpresentations Microsoft Free download excel 2007 dummies.pdfdatabase management Microsoft Accessand managing your personal resources like time, appointments, and e-mail Microsoft Outlook. No matter how much or how little you may know about Microsoft Office, this free download excel 2007 dummies.pdf introduces you to the most common features so you can start being free download excel 2007 dummies.pdf with Office right away.

Copying and Pasting Data Unlike the Cut command, the Copy command leaves your selected data in its original location but places a second copy of that data somewhere else.

If you click either Yes or No, Office closes your file. Using the Quick Access toolbar The Quick Access toolbar appears to the right of the Office Button refer to Figure near the top of the screen, displaying icons that represent commonly used commands such as Save, Undo, and Redo as shown in Figure The Quick Save Access Undo toolbar provides one-click access to Redo Customize the most Quick Access commonly toolbar used commands. Using the Quick Access icons If you click the Save icon in the Quick Access toolbar, Office saves your current file.

Choose Place Quick Access Toolbar Below or Above the Ribbon. Minimizing the Ribbon You can tuck the Ribbon out of sight temporarily so it only appears when you click on a tab such as Home or Insert.

A free download excel 2007 dummies.pdf arrow appears to the right. A pop-up menu appears, as shown in Figure To remove an item from the Office Clipboard, click the downwardpointing arrow and click Delete. Office deletes your chosen item. Click the Close box to tuck the Office Clipboard out of sight. If you click the Clear All button, you can delete every item currently stored on the Office Clipboard. To help answer your questions, Office provides a Help system, which lets you browse through different help topics until you hopefully find the answer you need.

This icon highlights interesting technical information that you can safely ignore but which might answer some questions free download excel 2007 dummies.pdf why Office works a certain way. Getting Started The best way to master anything is to jump right in and start fiddling with different commands just to see what they do and how they work.

When you save files in the format, Microsoft Office saves your files with a three-letter file extension, like. When you save files in the Office format, Microsoft Free download excel 2007 dummies.pdf saves your files with a four or five-letter file extension, such as. Table File Extension Names Used by Different Versions of Microsoft Office Program Microsoft Office File Extension Microsoft Office File Extension Microsoft Word. Click the Office Button and then choose Save As.

Contents at a Glance Introduction Getting to Know Microsoft Office Getting Help from Office Typing Text in Word Playing the Numbers with Excel The Basics of Spreadsheets: Numbers, Labels, and Formulas Charting and Analyzing Data Making Presentations with PowerPoint Creating a PowerPoint Presentation Adding Color and Pictures to a Presentation Showing Off a Presentation Getting Organized with Outlook Organizing E-Mail with Outlook Storing Contacts and Organizing Tasks Storing Stuff in Access Searching, Sorting, and Querying a Database Creating a Database Report The Part of Tens Ten Tips for Using Office Ten Keystroke Shortcuts for Office Table of Contents Introduction Typing Text in Word.

To exit from any Office program except Outlookchoose one of the following: Getting to Know Microsoft Office If you try to close an Office program before saving your file, a dialog box pops up to give you a chance to save your file.

The Save as Type list box lets you choose a file format for saving your file. Optional Click in the File Name text box and type a descriptive name for your file. Closing a file simply removes the file from your screen but keeps your Office program running so you can edit or open another file. To close a file, follow these steps: Click the Office Button and then choose Close. Click Yes to save your changes, No to discard any changes, or Cancel to keep your file open.

Second, you have to tell Office how to manipulate your data, such as underlining, enlarging, coloring, or deleting it. Third, you free download excel 2007 dummies.pdf to save free download excel 2007 dummies.pdf data as a file.

Click in the File Name text box and type a descriptive name for your file. Getting to Know Microsoft Office Saving a file for older versions of Microsoft Office If you need to share files with people using older versions free download excel 2007 dummies.pdf Microsoft Free download excel 2007 dummies.pdf, you need to save your files in a different file format known assuch as Word Document or PowerPoint Presentation.

The Part of Tens Almost every program offers multiple ways of accomplishing the same task, and Office is no exception. After you get familiar free download excel 2007 dummies.pdf using Office, take a peek in this part of the book to read about different types of shortcuts you can use to work with Office even faster than before.

To help you understand this three-step process of entering, manipulating, and saving data, Office offers similar commands among all its programs so you can quickly jump from Word to PowerPoint to Excel without having to relearn entirely new commands to use each program. Even better, Office rearranges its numerous commands so finding the command you need is faster and easier than ever before.

Getting to Know Microsoft Office 4. Choose the Office program you want to use, such as Microsoft Word or Microsoft PowerPoint. Your chosen program appears on the screen. Getting to Know the New User Interface Office offers a new user interface for Word, Excel, PowerPoint, Access, and some free download excel 2007 dummies.pdf of Outlook. This new user interface consists of three parts, as shown in Figure The three parts of the new Microsoft Office user interface. Getting to Know Microsoft Office The File menu The File menu contains commands for opening, saving, printing, and closing a file.

Besides showing you how to get help within Office, this part of the book also explains how to get the various programs of Office started in the first place. After you start using Office, this part of the book also shows you some of the more common keystroke and free download excel 2007 dummies.pdf commands that all Office programs share.

Who Should Buy Free download excel 2007 dummies.pdf Book This book is targeted toward two distinct groups. First, there are the people already familiar with Microsoft Office who want to bone up on the new ways that Office works. For these people, this book can serve as a handy reference to finding where Microsoft put various commands in the new Office user interface.

Click the Options button in the bottom-right corner, such as Word Options or Excel Options. An Options dialog box appears, as shown in Figure The Options dialog box lets you change how an Office program behaves. Click a category, such as Save or Display. The Options dialog box displays multiple options for you to customize.

The format of free download excel 2007 dummies.pdf file defines how Office stores your data. The default file format is known as Office format, which simply means that only people with Office can reliably open and view the contents of free download excel 2007 dummies.pdf file.

Pressing the Home key moves the cursor to the beginning of a sentence or a row in a spreadsheetand pressing the End key moves the cursor to the end of a sentence or a row in a free download excel 2007 dummies.pdf. Using any of the cursor movement keys moves the cursor to a new location. Wherever the cursor appears will be where you can enter new data. Table lists ways to move the cursor in each Office program.

Just follow these steps: Click the Office Button and then choose Open. An Open dialog box appears, as shown in Figure The Open dialog box lets you change drives and folders to find the file you want to use. Optional To choose a different drive to look for files, click Computer under the Favorite Links panel see the left side of Figure Then click the drive where free download excel 2007 dummies.pdf want to load the file, such as the C: Optional Click a folder and then click Open to search for a file inside a folder.

Click a tab that contains the command you want. Click the command you want to use. Command icons work in one of three ways, as shown in Figure Clicking an icon immediately chooses a command to alter your data. The Bold and Italic icons are examples of icons that you click only once to choose them. Some icons display a downward-pointing arrow to the right. Clicking these icons displays a list of additional options. The Font and Font Size icons are examples of list box icons. Some icons display a downward-pointing arrow that displays a drop-down list of additional commands, called a gallery.

Loading an Office Program The first step to using Office is loading the program you want to use. To load free download excel 2007 dummies.pdf Office program, follow these steps: Click the Start button on the Windows taskbar. A pop-up menu appears. Another pop-up menu appears. A list of programs appears on the Start menu, as shown in Figure You can find every Office program from the Start menu.

Selecting data with the keyboard will not display the pop-up toolbar. Move the mouse pointer to the area to the upper right of the selected data. The pop-up toolbar appears. The closer you move the mouse to the toolbar, the more visible the toolbar will appear.

Table of Contents Adjusting Line Spacing Numbers, Labels, and Formulas. Table of Contents Inserting and removing page breaks Charting and Analyzing Data. Creating a PowerPoint Presentation. Adding Color and Pictures to a Presentation. Showing Off a Presentation. Table of Contents Adding Hyperlinks Organizing E-Mail with Outlook.

Dragging typically moves something from one location to another, such as moving a word from the top of a paragraph to the bottom. Right-clicking typically displays a shortcut menu of additional options. In addition to understanding these terms to describe different mouse actions, you also need to understand different keystroke conventions too. Icons Used in This Book Icons highlight important or useful information.

Commands appear as icons, list boxes, or galleries. List box Gallery Customizing an Office Program If you want to modify how a particular Office program works, you can customize its features. To customize an Office program, follow these free download excel 2007 dummies.pdf Load the Office program free download excel 2007 dummies.pdf want to customize.

In Word, a file is called a document. In Excel, a file is called a workbook. In PowerPoint, a file is called a presentation. In Access, a file is called a database. In previous versions of Office, the File menu was clearly labeled File. In Officethe File menu appears when you click the Office Button in the upper-left corner refer to Figure Creating a new file When you first load an Office program, it automatically creates an empty file for you to use right away.

Full Name Free download excel 2007 dummies.pdf goes here. Are you sure you want to Yes No. Abdul Manan KhalidStudent at Air University Thank you so much. LUIS QUINONESClerk at Aiken County Government at Aiken County Government. Fayax Dayo at HANDS. Embeds 0 No embeds. No notes for slide. Microsoft office for dummies 1. Requests to the Publisher for permission should be addressed to the Legal Department, Wiley Publishing, Inc. Wiley, the Wiley Publishing logo, For Dummies, the Dummies Man logo, A Reference for the Rest of Us!

Storing Contacts and Organizing Tasks. Searching, Free download excel 2007 dummies.pdf, and Querying a Database. Table of Contents Querying a Database Creating a Database Report. Introduction M icrosoft Office contains loads of new features. Unfortunately, finding — let alone using — these new features can be troublesome. So, with OfficeMicrosoft added its most important feature ever — making the programs easier to use.

Move the mouse pointer to highlight all the commands that you want to free download excel 2007 dummies.pdf, as shown in Figure Office undoes your chosen commands. The downwardpointing arrow to the right of the Undo icon lets you view a list of your last commands. Until you choose the Undo command at least once, the Redo icon appears dimmed.

---