Microsoft office 2010 introductory shelly cashman pdf free download

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Shelly Cashman Microsoft Office Introductory Pdf Download Microsoft Office Introductory (Shelly Cashman Series) by Gary B. Shelly, Misty E Introduce your students to the new generation of Microsoft Office with the new generation of “Shelly Cashman Series” books! For the past three decades
 
 

年04月の記事 | My First JUGEM – Get everything you need

 
Shelly Cashman Microsoft Office Introductory Pdf Download Microsoft Office Introductory (Shelly Cashman Series) by Gary B. Shelly, Misty E Introduce your students to the new generation of Microsoft Office with the new generation of “Shelly Cashman Series” books! For the past three decades

 

Microsoft office 2010 introductory shelly cashman pdf free download

 
Microsoft Office Pro Plus incl Visio & Project is a powerful Office Suite with Free Download days trial version bit and bit for Windows XP Introduce your students to the new generation of Microsoft Office with the new generation of “Shelly Cashman Series” books! For the past three decades Visual Studio DVD for Introduction to Programming Using Visual Basic (Shelly Cashman) PDF Trial ebooks for programmers – Microsoft vb

 
 

Microsoft office 2010 introductory shelly cashman pdf free download. Microsoft Office 2003 : Introductory Concepts and Techniques, Second Edition

 
 

When taking a train, awaiting listing, and awaiting a person or other, you can review this online publication Microsoft Office Introductory Shelly Cashman Series , By Misty E. Vermaat as a buddy again. Do you believe that reading is a vital task? Discover your factors why adding is important. Vermaat is one component of satisfying activities that will make your life top quality a lot better. Vermaat you read, it is not just about how many publications you read, it’s regarding the habit.

Vermaat as her or his friend. It will regardless of if they spend cash as well as spend even more publications to complete reading, so does this book Microsoft Office Introductory Shelly Cashman Series , By Misty E. Vermaat is anticipated to be one of the very best vendor book that will make you really feel completely satisfied to acquire as well as read it for completed.

As known could typical, every publication will certainly have certain things that will make an individual interested so much. Even it originates from the author, kind, material, and even the author. Vermaat based upon the motif and also title that make them surprised in. Vermaat is very suggested for you because it has appealing title and theme to review.

Vermaat If that’s so, why don’t you take this book currently? Vermaat, so you could obtain the reason and messages from this publication.

Don’t bother to be confused where to obtain it. Vermaat all over. Vermaat will certainly relieve individuals to obtain the book. It will additionally save even more time to just look the title or author or author to obtain up until your publication Microsoft Office Introductory Shelly Cashman Series , By Misty E.

Vermaat is exposed. Then, you can visit the link download to check out that is offered by this web site. If you have a Mac, find another book or just figure it out on your own. So this book was for a tech class in college, and at first I saw how big it was and thought, “This is going to be a horrible quarter. It is broken up into chapters of MS word, excel, access, etc. It then proceeds to cover step by step how to work with each program.

If you have any interest in excel or access, this book will open all kinds of doors for you, and at its current price, it may be worth just having around the house to help you with those find formulas for excel, they cover the matter much better than your average Google search.

I’m currently using this text as we are in Week 8 of the spring semester. According to our instructor, the text should have included a CD containing Student Data Files, which would have simplified things to a great extent.

Instead, you have to browse the publisher’s website and “download your brains out” to access the Data File in question. Other than the “missing” CD, the text is very thorough as it navigates you through the Office Suite, exemplifying numerous ways to get your desired result.

Has everything you are looking for when dealing with all Microsoft Office 10 programs. There are a few issues with this book Kindle Version First, the page numbers don’t line up with the acutal book, so following along in class is tough.

There is no “page search” option to reference a page that may be called out in class, only a Table of contents that links to each chapter. This book makes references to every image in this book, in the tutorials, and some, if not most of them are blurry or pixelated when zoomed in on. I was unable to complete my homework due to the inability to clearly see the image that was given as an example.

I could speculate on what the content was, but there is little chance that my letter would have looked identical to the image included in this book. Do not buy the Kindle version of this book until the Author, Distributor, and Publisher create an updated Kindle version that includes high resolution images to go along with the tutorials. See all reviews. Top reviews from other countries. Clear and complete. I think learning goes together with practicing. This book is full of examples and all kind of exercises.

I recommend it. Report abuse. Books were exactly as advertised, in fact, in better condition than expected. It took approximately 2 weeks longer than the expected delivery time. May be due to the fact it was shipped to Canada from the US, but it would be good to adjust the delivery times to reflect this. Delivered on time and my book is almost new with a very reasonable prize. Book was in excellent condition, very happy with purchase. What other items do customers buy after viewing this item?

What is the purpose of the File tab? Can I create documents through the Backstage view in other Office programs? New gallery Create button New tab Yes. If the Office program has a New tab in the Backstage view, the New gallery displays various options for creating a new file. Figure 58 Copyright Cengage Learning, Inc. Save button 1 Click the title text placeholder shown in Figure 59 to select it.

You also may want to close a file when you are finished working with it so that you can begin a new file. The following steps close the current active Office file, that is, the Koala Exhibit Gala presentation, without quitting the active program PowerPoint in this case. Close command What if the Office program displays a dialog box about saving? Figure 61 Copyright Cengage Learning, Inc. You may have more changes to make such as adding more content or correcting errors.

The Backstage view allows you to access recent files easily. The following steps reopen the Koala Exhibit Gala file just closed. Yes, as long as the file name appears in the list of recent files in the Recent gallery. Exit command Figure 62 Other Ways 1. Click Start button, point to program name, click file name on submenu 2.

Thus, you should quit this Office program. The following steps quit PowerPoint. Inside the workbook are sheets, each of which is called a worksheet. In other words, a workbook is a collection of worksheets. Worksheets allow users to enter, calculate, manipulate, and analyze data such as numbers and text. The terms worksheet and spreadsheet are interchangeable. For example, once a user enters data into a worksheet, an Excel table can sort the data, search for specific data, and select data that satisfies defined criteria.

Excel Web support also provides access to real-time data, such as stock quotes, using Web queries. The following steps use Windows Explorer to create a blank Excel document.

Another way start an Office program is to open an existing file from Windows Explorer, which causes the program in which the file was created to start and then open the selected file. The following steps, which assume Windows 7 is running, use Windows Explorer to start the Excel Office program based on a typical installation. Yes, you can use any method of starting an Office program to start Excel.

The Formulas and Data tabs are specific to Excel. The Formulas tab allows you to work with Excel formulas, and the Data tab allows you to work with data processing features such as importing and sorting data. BTW The Worksheet The worksheet is organized into a rectangular grid containing vertical columns and horizontal rows. A column letter above the grid, also called the column heading, identifies each column. A row number on the left side of the grid, also called the row heading, identifies each row.

The intersection of each column and row is a cell. A cell is the basic unit of a worksheet into which you enter data.

Each worksheet in a workbook has 16, columns and 1,, rows for a total of 17,,, cells. Only a small fraction of the active worksheet appears on the screen at one time. A cell is referred to by its unique address, or cell reference, which is the coordinates of the intersection of a column and a row. To identify a cell, specify the column letter first, followed by the row number.

For example, cell reference E2 refers to the cell located at the intersection of column E and row 2 Figure One cell on the worksheet, designated the active cell, is the one into which you can enter data. The active cell in Figure 68 is A1. The active cell is identified in three ways. First, a heavy border surrounds the cell; second, the active cell reference shows immediately above column A in the Name box; and third, the column heading A and row heading 1 are highlighted so it is easy to see which cell is active Figure The horizontal and vertical lines on the worksheet itself are called gridlines.

Gridlines make it easier to see and identify each cell in the worksheet. If desired, you can turn the gridlines off so that they do not show on the worksheet, but it is recommended that you leave them on for now.

The mouse pointer in Figure 68 has the shape of a block plus sign. The mouse pointer appears as a block plus sign whenever it is located in a cell on the worksheet. Another common shape of the mouse pointer is the block arrow.

The mouse pointer turns into the block arrow when you move it outside the worksheet or when you drag cell contents between rows or columns. The other mouse pointer shapes are described when they appear on the screen. The Worksheet Size and Window The 16, columns and 1,, rows in Excel make for a huge worksheet that — if you could imagine — takes up the entire side of a building to display in its entirety.

Your computer screen, by comparison, is a small window that allows you to view only a minute area of the worksheet at one time. While you cannot see the entire worksheet, you can move the window over the worksheet to view any part of it.

BTW The Excel window consists of a variety of components to make your work more efficient and worksheets more professional. These include the document window, Ribbon, Mini toolbar and shortcut menus, Quick Access Toolbar, and the Backstage view.

Some of these components are common to other Microsoft Office programs; others are unique to Excel. Excel opens a new workbook with three worksheets. If necessary, you can add additional worksheets as long as your computer has enough memory to accommodate them. Each worksheet has a sheet name that appears on a sheet tab at the bottom of the workbook. For example, Sheet1 is the name of the active worksheet displayed in the Brain Busters workbook. If you click the sheet tab labeled Sheet2, Excel displays the Sheet2 worksheet.

Customizing the Ribbon In addition to customizing the Quick Access Toolbar, you can add items to and remove items from the Ribbon. To customize the Ribbon, click File on the Ribbon to open the Backstage view, click Options in the Backstage view, and then click Customize Ribbon in the left pane of the Options dialog box. More information about customizing the Ribbon is presented in a later chapter.

As you type, Excel displays the entry in the formula bar. You can make the formula bar larger by dragging the sizing handle at the bottom of the formula bar or clicking the expand button to the right of the formula bar. Excel also displays the active cell reference in the Name box on the left side of the formula bar. The easiest way to select a cell make it active is to use the mouse to move the block plus sign mouse pointer to the cell and then click.

An alternative method is to use the arrow keys that are located just to the right of the typewriter keys on the keyboard. An arrow key selects the cell adjacent to the active cell in the direction of the arrow on the key. In Excel, any set of characters containing a letter, hyphen as in a telephone number , or space is considered text. Text is used to place titles, such as worksheet titles, column titles, and row titles, on the worksheet.

The following steps enter the worksheet title in cell A1. Cancel box Why did the appearance of the formula bar change? Excel displays the title in the formula bar and in cell A1. When you begin typing a cell entry, Excel displays two additional boxes in the formula bar: the Cancel box and the Enter box. Clicking the Enter box completes an entry.

Clicking the Cancel box cancels an entry. To complete entry, click any cell other than active cell 2. You have made modifications to the file spreadsheet since you created it. Thus, you should save again. Similarly, you should continue saving files frequently so that you do not lose your changes since the time you last saved the file.

You can use the same file name, such as Brain Busters, to save the changes made to the document. The following step saves a file again. Office programs, including Excel, overwrite the document using the setting specified the first time you saved the document. Figure 73 Other Ways 1. For example, you might start a homework assignment with a data file and then save it with a final file name for submitting to your instructor, saving it to a location designated by your instructor.

The following steps save a file with a different file name. For specific instructions, perform the tasks in steps 4a through 4g. The following steps quit Excel. Access The term database describes a collection of data organized in a manner that allows access, retrieval, and use of that data.

Microsoft Access , usually referred to as simply Access, is a database management system. A database management system is software that allows you to use a computer to create a database; add, change, and delete data in the database; create queries that allow you to ask questions concerning the data in the database; and create forms and reports using the data in the database.

To Start a Program The following steps, which assume Windows 7 is running, start the Access program based on a typical installation. Do I have to start Access using these steps? You can use any previously discussed method of starting an Office program to start Access. In Figure 74, the Access window contains no open objects. Figure 75 shows a work area with multiple objects open.

Object tabs for the open objects appear at the top of the work area. You select an open object by clicking its tab. In the figure, the Suppliers Split Form is the selected object. To the left of the work area is the Navigation Pane, which contains a list of all the objects in the database.

You use this pane to open an object. You also can customize the way objects are displayed in the Navigation Pane. Because the Navigation Pane can take up space in the window, you may not have as much open space for working as you would with Word or Excel. Many of the formatting options are reserved for the tool tabs that appear when you are working with forms and reports. When working in Access, you will add data to an Access database. As you add data to a database, Access automatically saves your changes rather than waiting until you manually save the database or quit Access.

Recall that in Word and Excel, you entered the data first and then saved it. Because Access automatically saves the database as you add and change data, you do not have to always click the Save button.

In fact, the Save button in Access is used for saving the objects including tables, queries, forms, reports, and other database objects a database contains. You can use either the Blank Database option or a template to create a new database. If you already know the organization of your database, you would use the Blank Database option.

If not, you can use a template. Templates can guide you by suggesting some commonly used database organizations.

Do not press the ENTER key after typing the file name because you do not want to create the database at this time Figure Unlike other Office programs, you first must save a database before adding any data. For this reason, the Backstage view opens automatically when you start Access.

Access folder selected file name displayed in File name text box OK button Microsoft Access database formats change with some new versions of Microsoft Access. The most recent format is the Microsoft Access Databases format, which was released with Access Figure 77 Copyright Cengage Learning, Inc. The name of the database appears on the title bar. Datasheet View button is selected when you first install Access Windows 7 taskbar displays Access program button, indicating Access is running Figure 79 To Close an Office File Assume you need to close the Access database and return to it later.

The following step closes an Office file. If necessary, click the Enable Content button Figure Why is Access still on the screen? When you close a database, the program remains open. To Open an Existing Office File Assume you wish to continue working on an existing file, that is, a file you previously saved.

Earlier in this chapter, you learned how to open a recently used file through the Backstage view. The following steps open a database, specifically the Charmed Excursions database, from the USB flash drive. What if I did not save my file in a folder? If you did not save your file in a folder, the file you wish to open should be displayed in the Open dialog box before navigating to any folders.

Click File on the Ribbon, click Recent in Backstage view, double-click file 2. The following step quits Access. Other Office Programs In addition to the Office programs discussed thus far, three other programs are useful when collaborating and communicating with others: Outlook, Publisher, and OneNote. Outlook Outlook is a powerful communications and scheduling program that helps you communicate with others, keep track of contacts, and organize your calendar.

Personal information manager PIM programs such as Outlook provide a way for individuals and workgroups to organize, find, view, and share information easily. Outlook allows you to send and receive electronic mail e-mail and permits you to engage in real-time messaging with family, friends, or coworkers using instant messaging. Outlook also provides a means to organize contacts. Users can track e-mail messages, meetings, and notes related to a particular contact.

Contact information readily is available from the Outlook Calendar, Mail, Contacts, and Task components by accessing the Find a Contact feature. Electronic mail e-mail is the transmission of messages and files over a computer network.

E-mail has become an important means of exchanging information and files between business associates, classmates and instructors, friends, and family. Businesses find that using e-mail to send documents electronically saves both time and money. Parents with students away at college or relatives who live across the country find that communicating by e-mail is an inexpensive and easy way to stay in touch with their family members.

Exchanging e-mail messages is one of the more widely used features of the Internet. The Outlook Window Figure 82 shows an Outlook window, which is divided into six panes: the Favorites folder pane, Mail folder pane, and Navigation Pane on the left side of the window, the Inbox message pane to the left of center, the Reading Pane to the right of center, and the People Pane just below the Reading Pane. When an e-mail message is open in Outlook, it is displayed in a Message window Figure When you open a message, the Message window Ribbon displays the Message tab, which contains the more frequently used commands.

DTP software provides additional tools beyond those typically found in word processing programs, including design templates, graphic manipulation tools, color schemes or libraries, advanced layout and printing tools, and Web components. For large jobs, businesses use DTP software to design publications that are camera ready, which means the files are suitable for outside commercial printing. OFF 60 Office and Windows 7 Chapter Essential Concepts and Skills BTW Publisher is used by people who regularly produce high-quality color publications, such as newsletters, brochures, flyers, logos, signs, catalogs, cards, and business forms.

Saving publications as Web pages or complete Web sites is a powerful component of Publisher. All publications can be saved in a format that easily is viewed and manipulated using a browser. Publisher has many features designed to simplify production and make publications visually appealing.

Using Publisher, you easily can change the shape, size, and color of text and graphics. You can include many kinds of graphical objects, including mastheads, borders, tables, images, pictures, charts, and Web objects in publications, as well as integrate spreadsheets and databases.

Starting Publisher When you first start Publisher, the New templates gallery usually is displayed in the Backstage view. If it is not displayed, click File on the Ribbon, click Options in the Backstage view, click General Options dialog box , and then click Show the New template gallery when starting Publisher to select the check box in the General panel.

The Publisher Window On the right side of the Backstage view, Publisher displays the New template gallery, which includes a list of publication types. Publication types are typical publications used by desktop publishers. The more popular types are displayed in the center of the window. Each publication type is a link to display various templates and blank publications from which you may choose.

Once you select a publication type, the window changes to allow you to select a specific template Figure Some templates are installed with Publisher, and others are available online. Clicking a publication type causes template previews to be displayed in the center of the window. The templates are organized by purpose for example, Sales and then alphabetically by design type.

On the right, Publisher will display a larger preview of the selected template, along with some customization options if the template is installed or a download option if the template is online. In Figure 84, the installed Arrows template is selected so that the customize options appear. Microsoft Publisher window title bar preview of selected template Arrows template selected Customize area for selected template marketing templates Publisher program button displayed on taskbar Create button Figure 84 Copyright Cengage Learning, Inc.

When you click the Create button, Publisher creates the document and sets it up for you to edit. Figure 85 shows the Arrows document that Publisher creates when default options are selected. It enables you to create pages, which are organized in sections, just as in a physical notebook. In OneNote, you can type notes anywhere on a page and then easily move the notes around on the page.

You can create lists and outlines, use handwriting to enter notes, and create drawings. If you use a Tablet PC to add handwritten notes to a document, OneNote can convert the handwriting to text. It also can perform searches on the handwritten entries. Pictures and data from other programs easily are incorporated in your notes. In addition to typing and handwriting, you can take audio notes.

For example, you could record conversations during a meeting or lecture. As you record, you can take additional notes. When you play back the audio notes, you can synchronize the additional notes you took; that is, OneNote will show you during playback the exact points at which you added the notes. A variety of note flags, which are symbols that call your attention to notes on a page, enable you to flag notes as being important. You then can use the Note Flags summary to view the flagged notes, which can be sorted in a variety of ways.

OneNote includes tools to assist you with organizing a notebook and navigating its contents. It also includes a search facility, making it easy to find the specific notes in which you are interested.

For short notes that you always want to have available readily, Copyright Cengage Learning, Inc. Like a physical notebook, the OneNote notebook consists of notes that are placed on pages. The pages are grouped into sections, which can be further grouped into folders. No folders are shown in the notebook in the figure.

You can use the Search All Notebooks box to search for specific text in your notes. You can add pages to the notebook using the New Page button in the Page Tabs pane. If Page Tabs are displayed, then you can switch to a page by clicking its tab. Figure 86 shows the Top Uses page being displayed for the General notebook. Moving, Renaming, and Deleting Files Earlier in this chapter, you learned how to organize files in folders, which is part of a process known as file management.

The following sections cover additional file management topics including renaming, moving, and deleting files. To Rename a File In some circumstances, you may want to change the name of, or rename, a file or a folder. For example, you may want to distinguish a file in one folder or drive from a copy of a similar file, or you may decide to rename a file to better identify its contents. Always use caution when renaming files. Can I rename a file when it is open? No, a file must be closed to change the file name.

Figure 88 Other Ways 1. When you move a file, it no longer appears in the original folder. If the destination and the source folders are on the same disk drive, you can move a file by dragging it. If the folders are on different disk drives, then you will need to right-drag the file.

Right-click file, drag file to destination folder, click Move here 2. Right-click file to copy, click Cut on shortcut menu, right-click destination folder, click Paste on shortcut menu 3. Exercise extreme caution when deleting a file or files. When you delete a file from a hard disk, the deleted file is stored in the Recycle Bin where you can recover it until you empty the Recycle Bin.

If you delete a file from removable media, such as a USB flash drive, the file is deleted permanently. Can I use this same technique to delete a folder? Right-click the folder and then click Delete on the shortcut menu. When you delete a folder, all of the files and folders contained in the folder you are deleting, together with any files and folders on lower hierarchical levels, are deleted as well. Yes button Figure 91 Other Ways 1. To illustrate the use of Office Help, this section uses Word.

Help in other Office programs operates in a similar fashion. In Office , Help is presented in a window that has Web-browser-style navigation buttons. Each Office program has its own Help home page, which is the starting Help page that is displayed in the Help window. Figure 92 Other Ways 1. Press F1 Moving and Resizing Windows Up to this point, this chapter has used minimized and maximized windows.

At times, however, it is useful, or even necessary, to have more than one window open and visible on the screen at the same time. You can resize and move these open windows so that you can view different areas of and elements in the window.

In the case of the Help window, for example, it could be covering document text in the Word window that you need to see. To Move a Window by Dragging You can move any open window that is not maximized to another location on the desktop by dragging the title bar of the window.

The following step drags the Word Help window to the top left of the desktop. Word Help window moved drag bottom corner to resize Other Ways 1. Right-click title bar, click Move on shortcut menu, drag window Figure 93 To Resize a Window by Dragging Sometimes, information is not visible completely in a window. A method used to change the size of the window is to drag the window borders. The following step changes the size of the Word Help window by dragging its borders.

Can I drag other borders on the window to enlarge or shrink the window? Will Windows 7 remember the new size of the window after I close it? When you reopen the window, Windows 7 will display it at the same size it was when you closed it. You can search for help by using any of the three following methods from the Help window: 1. Click the links in the Help window 3. If All Word already is selected, click the Search button arrow again to close the Search menu.

Selecting All Word on the Search menu ensures that Word Help will search all possible sources for information about your search term. It will produce the most complete search results. Why do my search results differ? If you do not have an Internet connection, your results will reflect only the content of the Help files on your computer. When searching for help online, results also can change as material is added, deleted, and updated on the online Help Web pages maintained by Microsoft.

Why were my search results not very helpful? Home button Browse area Formatting link Figure 98 To Obtain Help Using the Help Links If your topic of interest is listed in the Browse area of the Help window, you can click the link to begin browsing the Help categories instead of entering search text.

You browse Help just as you would browse a Web site. If you know which category contains your Help information, you may wish to use these links. The following step finds the Formatting Help information using the category links from the Word Help home page. You can browse through the Table of Contents to display information about a particular topic or to familiarize yourself with an Office program.

The following steps access the Help information about themes by browsing through the Table of Contents. If necessary, click the Maximize button on the Help title bar to maximize the window Figure Skip to content Other 0. New to this Edition Expanded coverage of PowerPoint and Outlook to provide a thorough introduction to these applications and give exposure to the numerous enhancements made with Office Chapter topic redistribution offering concise chapters that ensure complete skill coverage and lead to more manageable chapters.

New pedagogical elements that enrich material creating an accessible and user-friendly approach allowing easy navigation through the skills in each chapter.

Additional Features of Microsoft Office Introductory A step-by-step, screen by screen approach allows you to successfully teach to all learning styles and ensure students retain information to be used in their personal and professional lives. Expanded coverage of PowerPoint and Outlook to provide a thorough introduction to these applications and give exposure to the numerous enhancements made with Office