Microsoft Office Word Step by Step eBook - Pearsoncmg - PDF Drive.
Looking for:
Learn microsoft office word 2007 step by step pdf free. Microsoft Office Word 2007 Step by Step eBook - Pearsoncmg |
- Learn microsoft office word 2007 step by step pdf free
Download free tutorials and courses on ms office - Documents PDF - Other titles you might like
Jump in wherever you need answers—brisk lessons and informative screenshots show you exactly what to do, step by step. Other Project users will want to grab this book as well. Quickly start new plans, build task lists, and assign resources View resource capacity and track progress Capture and fine-tune work and cost details Visualize schedules with Gantt charts and other views and reports Consolidate projects, and share resources across plans Manage modern Agile projects James Mills, Jr.
He has been working with computers for more than 30 years, has been using Microsoft Windows since version 1, and is widely viewed as an expert in explaining Windows and Windows technology. Paul has written more than 40 books that have sold nearly three million copies worldwide, including Microsoft Windows Vista Unleashed, available January Get beyond the basics with Excel charts Now you can take your Excel charting skills to the next level with help from this hands-on guide.
Excel Charts Made Easy shows you how to upgrade from simple pie and bar charts to rich data visualization using the full range of charts available in the latest version of the software. Discover how easy it is to create custom charts with compelling effects and to display data in more meaningful ways. Manually format chart components Show trends in your data with line charts Combine line and pie charts to create area charts Plot data using scatter charts and bubble charts Create and format stock charts Connect three data points with a surface chart Display the relationship between various data series using doughnut charts Compare data values with radar charts Use PivotTables and PivotCharts to work with dynamic data Incorporate Excel charts into Word documents and PowerPoint presentations.
How do you develop leadership skills or give a successful presentation? What difference can effective thinking and critical reading make to your performance?
How can you get and stay organized to meet deadlines? The first book of its kind to cover all the business skills that students need at university and at work, The Business Skills Handbook covers all the practical, cognitive, technical and development skills that students need to succeed, from organising life and work to developing good writing and teamwork skills.
Mapped to the learning outcomes of the CIPD Level 7 Advanced Developing Skills for Business Leadership module, and with a focus on experiential learning to get students assessing and developing their skills, The Business Skills Handbook is designed to help students manage themselves more effectively, make justifiable decisions and problem solve more effectively, lead and influence others, interpret financial information, manage financial resources, demonstrate IT proficiency and demonstrate competence in postgraduate study skills.
Online supporting resources include an instructor's manual, lecture slides and figures and tables from the book. Take a moment to consider how many things you want to learn to do.
Research suggests it takes 10, hours to develop a new skill. In this nonstop world when will you ever find that much time and energy? In The First 20 Hours, Josh Kaufman offers a systematic approach to rapid skill acquisition— how to learn any new skill as quickly as possible.
The more specific, the better. Deconstruct the skill: Most of the things we think of as skills are actually bundles of smaller subskills. Eliminate barriers to practice: Removing common distractions and unnecessary effort makes it much easier to sit down and focus on deliberate practice. Author Nancy Muir knows how to get PC beginners up to speed in a hurry, the fun and easy way.
No lengthy theory here; Just the Steps For Dummies books focus on the steps necessary to accomplish key tasks. Tasks are presented with numbered steps and plenty of illustrations that show you what you should be seeing on your screen. This blistering novel—from the bestselling, Pulitzer Prize—winning author of The Road—returns to the Texas-Mexico border, setting of the famed Border Trilogy.
The time is our own, when rustlers have given way to drug-runners and small towns have become free-fire zones. One day, a good old boy named Llewellyn Moss finds a pickup truck surrounded by a bodyguard of dead men.
A load of heroin and two million dollars in cash are still in the back. When Moss takes the money, he sets off a chain reaction of catastrophic violence that not even the law—in the person of aging, disillusioned Sheriff Bell—can contain.
No Country for Old Men is a triumph. Microsoft Office Accounting Express will help you improve the way you manage your finances by reducing the time spent accounting for eBay sales and PayPal receipts, taking the worry out of payroll filing with ADP Payroll, and improving your bottom line by using Equifax credit profiles.
She has been interviewed for articles on Microsoft Accounting in magazines such as Accounting Technology and Accounting Today. She is the owner of Empowering You! If you own a copy of Office , you deserve a copy of this book! Written in clear, plain English, readers will feel as though they are learning from real humans and not Microsoft clones. You should expect plenty of hands-on guidance and deep but accessible reference material.
For the first time in a decade, Microsoft has rolled out an all-new user interface. Step-by-Step, Full-Color Graphics! Start using Office right away--the QuickSteps way. Color screenshots and clear instructions make it easy to ramp up the latest release of Microsoft's powerful productivity suite. Follow along and quickly learn how to create Word documents; build Excel spreadsheets; manage Outlook email, contacts, and schedules; design PowerPoint presentations; and use Office Web Apps.
Get up to speed on Office in no time with help from this practical, fast-paced guide. Click on the Office button. Select Print from the Office menu. The following dialog box will be displayed: The current printer is displayed at the top of the box.
Click on the down arrow beside the selected printer to choose another one. You can save the print settings to a file so that you can print at a later time and specify whether multiple copies should be collated. You can also choose to enable the manual duplex option, which allows you to print double-sided by having Word prompt you to turn the paper over once the first side has been printed. This button allows you to even further specify how the document will be printed.
Once all printer options have been set, choose to have Word begin printing the document. Click on the close button in the upper right corner of the window to close the current document. If you only have one document open and you click on this icon, Word will close the entire program. Select Close from the Office menu. NOTE: If you have made changes to the file and have not saved those changes, Word will ask whether you want to save the changes before closing the file.
If, however, you are in the midst of working with one file and then decide to create another document, you will need to instruct Word as to what type of new document you want to create. You can create a blank document or base the new file on one of the built-in templates that come with Word. A template is used to determine the basic structure of the document and can contain predefined settings, such as fonts, page layouts, graphics, formatting, and macros.
Select New from the Office menu. The far left section contains a list of available template categories that you can base your new document on. The middle section lists the templates available within the category you selected from the left side of the window.
The far right section displays a preview of the currently selected template. To preview a template before actually selecting it, click on its name within the middle section of the window and then look to the right side of the window for a preview. Once you decide which template you would like to use, highlight its name and then choose.
The new document will be created - based on the template you have selected. Simply click on the document you want to switch to and that file will become the active window. Doe, I am writing on behalf of my company to thank you for the work your accounting firm did for us last month during our audit. Because of your experience in the matter along with detailed record-keeping on our part, we passed with flying colors. What could have been a stressful situation turned out to be quite simple.
Your firm is largely responsible for that outcome. Thank you again for your assistance. I hope that our companies can continue to do business in the future.
Select Open from the Office menu. The following dialog box will be displayed: Along the left side of the dialog box, Word displays the Navigation Pane. You could then select the folder containing your Word documents. Across the top of the window are the following buttons: Click on this button to access the Organize pull-down menu. From the resulting pull-down list, select the operation e. To change the display of the files, click on the down arrow beside this button.
Click on this button to create a new folder. If you click on the down arrow beside the button, you can choose from a list of options such as opening the file as read- only or in your Web browser.
TIP: To open more than one file at a time, select the first file by clicking on its name once to highlight it. Next, hold the C key down as you click on each additional file to be opened. Once all files have been selected, click on to actually open them. Each file will be placed in its own window. Z Moves one line up. Y Moves one line down. Q Moves one character to the left. R Moves one character to the right.
O Displays the previous screenful. N Displays the next screenful. To scroll through the document using the mouse, click on one of the arrows located on either the horizontal or vertical scroll bar.
If you drag the scroll box on the vertical scroll bar up or down, Word will display the current page number to the left of the box. When you see the desired page, release the mouse button and that page will be displayed.
If you are using a mouse with a scroll wheel, roll the rubber wheel located between the [LEFT] and [RIGHT] mouse buttons forward or back to quickly scroll through large documents. NOTE: If you are using the mouse to move through a document, remember that you must click on the new page before the cursor will move to the new location! The top one moves to the previous page while the bottom icon moves to the next page.
Click on this button located between the previous and next page icons to change the method by which the previous and next buttons will navigate through your document. For example, you can set them to move from one graphic picture to another rather than from page to page. Once you click on the Select Browse Object button, a pop- up box appears: Each icon within this box represents a type of object available within a Word document.
The object you select will be used to browse through the document. For example, if you select the table object, the previous and next buttons will go to the previous or next table within your document. The previous and next buttons change color to blue if you select anything other than page the last icon on the first line of the box as the object. You can see the description of each icon as your mouse hovers over an icon. If you click on the left side of the status line where the current page number and section are displayed located at the bottom of your screen , Word will ask what page to "Go To".
Works like a correctable backspace on a typewriter. Line Move the Insertion Bar to the left of a line until it changes to an arrow. Click once. Sentence Hold the F key down and click the mouse button anywhere on the sentence. Paragraph Move the Insertion Bar to the left of a line until it changes to a pointer arrow.
Triple-Clicking on a paragraph also selects it. Any Text Move the Insertion Bar to the beginning of the block you want to delete. Click and drag. Entire File Move the Insertion Bar to the left of a line until it changes to a pointer arrow.
Hold C down and click once. Triple-Clicking on the left side of the screen also selects the entire file. You can also use this button located within the Editing section of the Home Ribbon to select items.
The pull-down list includes options for selecting everything within the document, graphic objects, or text with similar formatting. Undo instructs the program to disregard the last action whether it was deleting, copying, or applying format changes.
It is important to understand, however, that certain actions such as printing and saving cannot be undone. Word has the capability of remembering not only the last action performed but the last several. Click on the Undo tool to undo the last action. If you click on the down arrow to the right of the tool , you can scroll through the last several actions.
Move your mouse down the list to highlight the number of actions to undo. They must be done in sequence! Click on this button to redo the last undo. The Redo button shown above changes from Redo to Repeat depending on what action was last performed. This is called formatting. Formatting the text means setting the font and size of the letters, and emphasizing words using such attributes as bold, underline or italics.
To format characters you can either use the keyboard or the Home Ribbon. Before typing, turn on the attribute and then begin entering text. When you want to turn the attribute off you press the same key. Click on this tool to turn bold on and off. Click on this button to turn italics on and off. Click on this tool to turn underline on or off. Click on the down arrow beside the tool to change the style and color.
When you select a block of text, Word displays a semitransparent toolbar called the Mini toolbar. The Mini toolbar helps you work with fonts, font styles, font sizing, alignment, text color, indent levels, and bullet features.
When you see the transparent toolbar appear, simply point to the attribute you want to set and select it with your mouse. To change fonts, you select the new font by its name. Notice how Word displays a sample of each font within the pull-down list so that you can see the font before actually selecting it. Begin typing your text. NOTE: Notice that Word displays the current theme fonts along with the last few selected fonts at the top of the list for easy access.
NOTE: To change existing text, be sure to select the text first and then choose the desired font. If text is selected, as you scroll through the list of available fonts, Word will display the selected text with the currently highlighted font — as a preview. NOTE: As was the case with attributes, to change existing text, be sure to select the text first and then choose the desired font size.
You can also use the following tools both of which are located within the Font section on the Home Ribbon to quickly increase or decrease the font size. Click on this tool to increase the current font size. Click on this tool to decrease the current font size. Select the new margin setting from the list provided.
If you need a margin setting that is not included in this pull-down list, click on Customize Margins…. Select the page orientation from the two diagrams provided. Select the paper size you would like to use. Word is capable of aligning paragraphs, as shown below: Word is automatically set for left alignment. To change the alignment, place your cursor anywhere on the paragraph and select one of the following tools located on the Home Ribbon : Left Aligned Centered Right Aligned Full Justification TIP: Typically the last line of a paragraph is shorter than the rest of the paragraph and may not be justified.
However, if the line is very short, there may be large gaps between words. If you have a shortcut on your desktop, double-click on the Microsoft Office Excel icon to run the application. Although the quickest way of running any MS Office application is obviously through the desktop, you can also access the Start menu which allows you to locate any program available on your system.
You will notice that the program window includes many of the standard elements common to other Office applications as well as a few items that are unique to Excel. The screen can be quite intimidating the first time you see it as there are so many items displayed. Along the top left corner of the screen is the Office Button which provides quick access for creating, opening, saving, printing, preparing, sending, publishing, and closing files.
This button provides the only true menu within Excel The name of current workbook followed by the application name is displayed in the middle of this line. A generic name is given to each new workbook you create Book1. The second line contains a new feature within Excel Each time you press A, Excel displays corresponding letters for the Ribbon items to help you to continue using keyboard shortcuts to select them. Along the right side of the screen is the scroll bar used to quickly move vertically within your workbook.
There is also a horizontal scroll bar that you can use to move left and right through your workbook. As mentioned, columns are lettered and rows are numbered. The first 26 columns are lettered A through Z. Excel then begins lettering the 27th column with AA and so on. In a single Excel worksheet there are 16, columns lettered A-XFD and 1,, rows numbered The highlighted borders around the document window indicate the columns and rows and are used to identify where on the worksheet you are located since you obviously cannot see an entire worksheet of this size on the screen at one time.
The worksheet itself is located to the right and beneath the borders. This is where you will actually be working and entering information.
The outlined cell the one with the dark borders within the worksheet is referred to as the active cell. Each cell may contain text, numbers or dates. You can enter up to 32, characters in each cell. Towards the bottom of the worksheet is a small Tab that identifies each sheet within the workbook file. If there are multiple sheets, you can use the tabs to easily identify what data is stored on each sheet. For example, the top sheet could be "Expenses" and the second sheet could be called "Income".
When you begin a new workbook, the tabs default to being labeled Sheet1, Sheet2, etc. Along the bottom of the screen is another bar called the Status Bar. This bar is used to display various information about the system and current workbook.
The left corner of this line lists the Mode Indicator which tells you what mode you are currently working in. Just below and to the left of the vertical scroll bar is the Zoom section. Excel displays the current percentage just to the left of this area. To make working with multiple workbooks less confusing, Excel has included a feature which automatically displays all opened workbooks along the taskbar.
Rather than having to access the Ribbon labeled View to switch between opened files windows , you can simply use your mouse to click on the name of the file you want to access directly on the taskbar. Once selected, that file becomes the active window. R Moves pointer right one column. Z Moves pointer up one row.
Y Moves pointer down one row. O Moves one full screen up. N Moves one full screen down. You must know the cell address. Click in this box and type in the cell address to go to. You must press E when done. You can also use the vertical down the right and the horizontal along the bottom scroll bars to move. Drag the box in the scroll bar to move more quickly.
The pointer does not move until you click in the cell to move to. Remember to look at the formula bar for the current cell address. If you are using a mouse with a scroll wheel, roll the rubber wheel located between the [LEFT] and [RIGHT] mouse buttons forward or back to quickly scroll through large worksheets. Excel lights up column and row headings as you move from cell to cell. This helps to distinguish the current cell address. This tool displays Page Layout view. This tool displays Page Break Preview.
In addition to the three views discussed above, you can create your own custom views discussed in the advanced manual. A small dialog box will open allowing you to choose from a list of saved views. You can clear the Office menu, tabs and current Ribbon from your screen so that you can see more of your worksheet.
To redisplay the screen items, press X. Click in the cell you want to store the data in and then simply begin typing the word s , number or formula. If you make a mistake and want to start over, press X. Notice as you type, the entry is displayed both in the cell and in the formula bar. A thin, blinking cursor appears to the right of the entry and moves as you type.
You cannot use the arrow keys at this time to make corrections! Pressing an arrow key at this point will enter what you have typed in the cell and then automatically move the pointer in the direction of the arrow key you pressed.
Two symbols also pop up to the left of the formula bar. The X is used like the X key to cancel. When entering text, words are automatically left aligned within the cell while numbers are placed to the right. While entering columns of numbers, the column heading may not align correctly with the values. If text is wider than the cell it is stored in, it will appear to "spill" into the adjacent cell s , providing they are empty. R Moves the cursor to the right one character. Q Moves the cursor to the left one character.
In those instances it would make sense to delete the contents of the selected cell s. A single cell may contain one or more of the following: Formats Includes fonts, bold, borders surrounding the cell s , as well as, number formats e. Contents The data stored within the cell numbers or text. Comments Can be attached to a cell to explain the reasoning behind its entry e. These comments are usually not printed. Choose what you want to clear from the pull-down list provided.
Click on this tool located towards the top left corner of your screen to undo the last action. Click on this tool located towards the top left corner of your screen to redo the last undo. While you may not require the entire worksheet, you may need to work on a Block of cells. A block includes any group of cells in a rectangular format, as shown in the illustration below. Every block of cells has a beginning and ending address. The beginning address is the address of the cell in the top-left corner of the block whereas the ending address is the cell in the lower-right.
Normally, in the English language we use a dash to indicate a block of numbers, as in pages Excel, however, requires that you use the colon between the beginning and ending addresses. Remember that the dash represents subtraction in spreadsheet programs.
For example, the block C3:E14 refers to cells C3 through E There are many commands e. The mouse changes to the thick cross when placed in the middle of a cell. Dragging the pointer when it is this shape simply highlights cells. If the mouse is in the shape of a diagonal arrow, you can move the contents of the currently selected cell or block of cells to another location within the worksheet. The mouse changes to a pointer only when the tip of the arrow points to one of the outer borders of the cell block.
Dragging the pointer when it is in this shape actually picks up the contents of the cell s and moves them to another location. If the mouse is in the shape of a thin cross-hair, you can fill a formula or other information into adjacent cells within the worksheet. The mouse pointer changes to a thin cross-hair only when the tip of the arrow is placed in the small square located in the bottom right-corner of a cell.
Dragging the pointer when it is in this shape fills data. The pointer's shape should be a thick cross-hair. Click and drag to highlight. To select an entire column or row, click on the letter of the column or the number of the row. Hold the S key down and press the arrows to select a block. The entire worksheet will be highlighted. Text will appear to "spill" over into adjacent cells as long as those cells are empty. If the adjacent cells are not empty, Excel will truncate the text.
When entering large numbers, however, Excel will display the number in scientific notation if the column is not wide enough to display the entire number. However, if you apply formatting such as dollar signs , Excel will automatically adjust the column to fit the largest entry so that the number remains visible. Make sure the mouse pointer is on the column margin line. The pointer changes to a cross-hair indicating you are on the margin line.
In the example above, column F is being stretched to the right. Notice the "cross-hair". When creating formulas, you may use actual values, cell addresses or a combination of the two. This also ensures that formulas beginning with a cell address are not mistaken for text. The formula itself is displayed in the formula bar located in the upper-left of the screen next to the cell address.
NOTE: In order to view a formula, you must select the cell in which it is stored. TIP: If you select a group of cells and look at the status bar at bottom of the screen , Excel will display the total sum of the selected cells.
However, Excel provides a mathematical function which is used primarily to add blocks of numbers. The last function you chose will be displayed on the button. If you simply click on the button that function will be selected.
To choose a different function, click on the down arrow to the right of the button and then select a new function from the list. Once the function has been selected Excel will display the Function Arguments box, as shown below: The box will display a description of the currently selected function and list the arguments required for the function.
The next required argument will be displayed in bold. This helps guide you through each step properly. Notice as you begin entering the arguments, the palette displays the current result.
When you are done, click on to actually enter the function and close the box. This is called the AutoSum feature. The second click is used to confirm the selection. If, by chance, Excel has selected the wrong group of cells, you can highlight the correct block before clicking on the tool a second time. The pointer should change to a thin cross-hair.
When the mouse is released, the formula will be "filled" in all cells. Filling also works for text and numbers without formulas, such as months shown in the example above. Excel's auto fill feature will fill a block of cells with either numbers or text depending on what is located in the first cell.
As you begin filling the destination cells with months, Excel will display the name of each month as it is being filled so that you know how far to fill. Your cart. This eBook includes the following formats, accessible from your Account page after purchase: EPUB The open industry format known for its reflowable content and usability on supported mobile devices. Downloads Follow the instructions to download this book's companion files or practice files.
Click the Download button below to start the download. If prompted, click Save. Locate the. Right-click the file, click Extract All, and then follow the instructions.
Errata We've made every effort to ensure the accuracy of this book and its companion content.
Comments
Post a Comment