Microsoft excel 2016 step by step by curtis frye pdf free
Looking for:
Microsoft Office PDF Free Download - Item Preview |
Microsoft excel 2016 step by step by curtis frye pdf free
- Microsoft excel 2016 step by step by curtis frye pdf free
You can align text in different ways by using tabs You can align lines of text in different locations across the page by using tab stops. The easiest way to set tab stops is directly on the horizontal ruler. By default, Word sets left-aligned tab stops every half inch 1. To set a custom tab stop, start by clicking the Tab button located at the intersection of the vertical and horizontal rulers until the type of tab stop you want appears.
For example, tab leaders are useful in a table of contents to carry the eye from the text to the page number. When you insert tab characters, the text to the right of the tab character aligns on the tab stop according to its type. For example, if you set a center tab stop, pressing the Tab key moves the text so that its center is aligned with the tab stop. To display or hide paragraph marks and other structural characters 1.
To insert a line break 1. Position the cursor where you want to break the line. To insert a tab character 1. Position the cursor where you want to add the tab character. Press the Tab key. To open the Tabs dialog box 1. Select any portion of one or more paragraphs that you want to manage tab stops for.
In the lower-left corner of the Indents and Spacing tab, click the Tabs button. Select any portion of one or more paragraphs that you want to set the tab stop for.
When the Tab button shows the alignment you want, click the ruler at the point where you want to set the tab. TIP When you manually align a tab and set a tab stop, Word removes any default tab stops to the left of the one you set. Open the Tabs dialog box. In the Tab stop position box, enter the position for the new tab stop.
In the Alignment and Leader areas, set the options you want for this tab stop. Click Set to set the tab, and then click OK. To change the position of an existing custom tab stop 1. In the Tab stop position list, select the tab stop you want to change.
Click the Clear button to clear the existing tab stop. Enter the replacement tab stop position in the Tab stop position box, click Set, and then click OK. Earlier in this chapter, you learned about methods of applying formatting to para- graphs. This topic covers methods of formatting the text of a document. Formatting that you apply to text is referred to as character formatting. By default, the font used for text in a new blank document is point Calibri, but you can change the font of any element at any time.
The available fonts vary from one computer to another, depending on the apps installed. Sometimes you can set additional sizes beyond those listed. The font size is measured in points, from the top of the ascenders letter parts that go up, as in h to the bottom of the descenders letter parts that drop down, as in p. The most common are regular or plain , italic, bold, and bold italic.
For example, you might use a bold font style in various sizes and various shades of green to make words stand out in a newsletter. The available effects match the current theme colors. To change the font of selected text 1.
On the Mini Toolbar or in the Font group on the Home tab, in the Font list, click the font you want to apply. Then press the Enter key. To format selected text as bold, italic, or underlined 1. TIP To quickly apply a different underline style to selected text, click the arrow next to the Underline button on the Home tab, and then in the list, click the underline style you want to apply.
To cross out selected text by drawing a line through it 1. On the Home tab, in the Font group, click the Strikethrough button. Select the characters you want to reposition. To apply artistic effects to selected text 1. Then make selections on the submenus to apply and modify those effects. To change the font color of selected text 1. In the Theme Colors or Standard Colors palette, select a color swatch to apply that color to the selected text.
In the Colors dialog box, click the color you want in the honeycomb on the Standard page, or click the color gradient or enter values for a color on the Custom page. To change the case of selected text 1. If the selection ends in a period, Word does not include the Capitalize Each Word option in the rotation. If the selection does not end in a period, Word does not include Sentence case in the rotation.
To highlight text 3 1. When the pointer changes to a highlighter, drag it across one or more sections of text to apply the highlight. Click the Text Highlight Color button or press the Esc key to deactivate the highlighter. To copy formatting to other text 1. Click anywhere in the text that has the formatting you want to copy.
When the pointer changes to a paintbrush, click or drag across the text you want to apply the copied formatting to. If you activated the Format Painter for multiple targets, repeat step 3 until you finish applying the formatting. Then click the Format Painter button once, or press the Esc key, to deactivate the tool. To repeat the previous formatting command 1. Select the text to which you want to apply the repeated formatting.
To open the Font dialog box 1. To remove character formatting 1. Select the text you want to clear the formatting from. To change the character spacing 1. Select the text you want to change. Open the Font dialog box, and then click the Advanced tab to display character spacing and typographic features.
In the Spacing list, click Expanded or Condensed. In the adjacent By box, set the number of points you want to expand or condense the character spacing. In the Font dialog box, click OK. Used judiciously, character formatting can make a plain document look attractive and professional, but excessive use can make it look amateurish and detract from the message.
Bear in mind that lowercase letters tend to recede, so using all uppercase capital letters can be useful for titles and headings or for certain kinds of emphasis.
However, large blocks of uppercase letters are tiring to the eye. TIP Where do the terms uppercase and lowercase come from? Until the advent of computers, individual characters made of lead were assembled to form the words that would appear on a printed page. The characters were stored alphabetically in cases, with the capital letters in the upper case and the small letters in the lower case. Create and modify lists Lists are paragraphs that start with a character usually a number or bullet and are formatted with a hanging indent so that the characters stand out on the left end of each list item.
Fortunately, Word takes care of the formatting of lists for you. You simply indicate the type of list you want to create. When the order of items is not important—for example, for a list of people or supplies—a bulleted list is the best choice. And when the order is important—for example, for the steps in a procedure— you will probably want to create a numbered list. If the list is numbered, Word automatically updates the numbers. You can change both the overall indentation of the list and the relationship of the first line to the other lines.
To format a new bulleted or numbered list as you enter content 1. When you start a list in this fashion, Word automatically formats it as a bulleted or numbered list.
When you press Enter to start a new item, Word continues the formatting to the new paragraph. Typing items and pressing Enter adds subse- quent bulleted or numbered items.
To end the list, press Enter twice; or click the Bullets arrow or Numbering arrow in the Paragraph group on the Home tab, and then in the gallery, click None. Select the paragraphs that you want to convert to list items. On the Home tab, in the Paragraph group, do either of the following: Click the Bullets button to convert the selection to a bulleted list. To create a list that has multiple levels 1. Start creating a bulleted or numbered list. In the case of a bulleted list, Word changes the bullet character for each item level.
In the case of a numbered list, Word changes the type of numbering used, based on a predefined numbering scheme. TIP For a multilevel list, you can change the numbering pattern or bullets by clicking the Multilevel List button in the Paragraph group on the Home tab and then clicking the pattern you want, or you can define a custom pattern by clicking Define New Multilevel List. To modify the indentation of a list 1. To sort bulleted list items into ascending or descending order 1.
Select the bulleted list items whose sort order you want to change. In the Sort by area, click Ascending or Descending. To change the bullet symbol 1. Select the bulleted list whose bullet symbol you want to change. On the Home tab, in the Paragraph group, click the Bullets arrow. In the Bullets gallery, click the new symbol you want to use to replace the bullet character that begins each item in the selected list. To define a custom bullet 1.
In the Bullets gallery, click Define New Bullet. In the Define New Bullet dialog box, click the Symbol, Picture, or Font button, and make a selection from the wide range of options. Click OK to apply the new bullet style to the list. To change the number style 1. Select the numbered list whose number style you want to change. On the Home tab, in the Paragraph group, click the Numbering arrow to display the Numbering gallery.
Make a new selection to change the style of the number that begins each item in the selected list. Click OK to apply the new numbering style to the list. To start a list or part of a list at a predefined number 1. Place the cursor within an existing list, in the list paragraph whose number you want to set.
In the Set value to box, enter the number you want to assign to the list item. You can learn more about these and other AutoFormatting options by exploring the Auto- Correct dialog box, which you can open from the Proofing page of the Word Options dialog box.
You can select and clear options to control automatic formatting behavior One interesting option in this dialog box is Border Lines. With a couple of mouse clicks, you can easily change the look of words, phrases, and paragraphs by using styles.
More importantly, you can build a document outline that is reflected in the Navigation pane and can be used to create a table of contents. Apply styles Styles can include character formatting such as font, size, and color , paragraph format- ting such as line spacing and outline level , or a combination of both.
Styles are stored in the template that is attached to a document. By default, blank new documents are based on the Normal template. The Normal template includes a standard selection of styles that fit the basic needs of most documents. These styles include nine heading levels, various text styles including those for multiple levels of bulleted and numbered lists, index and table of contents entry styles, and many specialized styles such as those for hyperlinks, quotations, placeholders, captions, and other elements.
By default, most common predefined styles are available in the Styles gallery on the Home tab. For this reason, formatting document content by using styles produces a harmonious effect. After you apply named styles, you can easily change the look of an entire document by switching to a different style set that contains styles with the same names but different formatting.
Style sets are available from the Document Formatting gallery on the Design tab. Pointing to a style set in the gallery displays a live preview of the effects of applying that style set to the entire document TIP Style sets provide a quick and easy way to change the look of an existing document.
You can also modify style definitions by changing the template on which the document is based. On the Home tab, click the Styles dialog box launcher. To change which styles are displayed in the Styles pane 1. Open the Styles pane, and then click Options. Open the Styles pane, and then select or clear the Show Preview check box.
To add a style to the Styles gallery 3 1. In the Styles pane, point to the style, click the arrow that appears, and then click Add to Style Gallery. To remove a style from the Styles gallery 1. To apply a built-in style 1. Select the text or paragraph to which you want to apply the style.
TIP If the style you want to apply is a paragraph style, you can position the cursor anywhere in the paragraph. If the style you want to apply is a character style, you must select the text.
In the Styles gallery on the Home tab, or in the Styles pane, click the style you want to apply. To change the style set 1. On the Design tab, in the Document Formatting group, click the More button if necessary to display all the style sets.
Point to any style set to preview its effect on the document. Click the style set you want to apply. Manage outline levels Styles can be used for multiple purposes: to affect the appearance of the content, to build a document outline, and to tag content as a certain type so that you can easily locate it. Outline levels include Body Text and Level 1 through Level 9. Most documents make use only of body text and the first three or four outline levels.
They appear as headings in the Navigation pane and act as handles for the content that appears below them in the hierarchy. You can collapse and expand the content below each heading, and move entire sections of content by dragging the headings in the Navigation pane. To display the document outline in the Navigation pane 3 1.
In the Navigation pane, click Headings to display the document structure. TIP Only headings that are styled with the document heading styles appear in the Navigation pane. To expand or collapse the outline in the Navigation pane 1. TIP If there is no triangle next to a heading, that heading does not have subheadings. To expand or collapse sections in the document 1.
In a document that contains styles, point to a heading to display a triangle to its left. The theme is a combination of coordinated colors, fonts, and effects that visually convey a certain tone. To change the look of a document, you can apply a different theme from the Themes gallery. The default installation of Word offers 30 themes to choose from Each theme has a built-in font set and color set, and an associated effect style. In some font sets, the heading and body fonts are the same.
For example, the first color in each set is applied to the Title and Intense Refer- ence styles, and different shades of the third color are applied to the Subtitle, Heading 1, and Heading 2 styles.
If you create a combination of theme elements that you would like to be able to use with other documents, you can save the combination as a new theme. By saving the theme in the default Document Themes folder, you make the theme available in the Themes gallery.
In a corporate environment with managed computer configurations, the user profile folder might be located elsewhere. By default, Word applies the Office theme to all new, blank documents.
In Word , the Office theme uses a primarily blue palette, the Calibri font for body text, and Calibri Light for headings. If you plan to frequently use a theme other than the Office theme, you can make that the default theme. Use theme elements that reflect your corporate colors, fonts, and visual style, and then save the theme to a central location or send the theme file by email and instruct your colleagues to save it to the default Document Themes folder.
To apply a built-in theme to a document 1. On the Design tab, in the Document Formatting group, click the Themes button, and then click the theme you want to apply. TIP If you have manually applied formatting to document content, the theme does not override the manual formatting. To change theme elements in a document 1.
Apply a base theme, and then modify the theme colors, fonts, and effects as you want them. On the Design tab, in the Document Formatting group, click the Themes button. In the File name box, replace the suggested name, and then click Save. To apply a custom theme 1. Display the Themes menu.
If you have created a custom theme, the Themes menu now includes a Custom area that contains your theme. Click the theme to apply it to the document. To change the default theme 1. In the document, apply the theme you want to use as the default theme. To apply a theme from a nonstandard location 1. At the bottom of the Themes menu, click Browse for Themes. In the Choose Theme or Themed Document dialog box, browse to the theme you want to apply, and then click Open.
To find the location of your Document Themes folder 1. At the bottom of the Themes menu, click Save Current Theme. In the Save Current Theme dialog box, click the icon at the left end of the address bar to display the full path to the Document Themes folder.
Note that the second method removes the theme choice from the gallery but does not remove the theme file from your Themes folder. If you need to make adjustments, you can add or delete rows or columns ormerge cells. When you click in the table, the Table Design and Layout tabs appear.
On the Table Design tab, choose different colors, table styles, add or remove borders from the table. This way you can create a table with more than ten columns and eight rows, as well as set the column width behavior. Under Table Size, select the number of columns and rows. Click OK and the new table appears in your document. You can even draw diagonal lines and cells within cells.
The pointer changes to a pencil. You can use mail merge in Office to create form letters or address labels, certificates with unique names, and more. Here's how. With mail merge, you create a document in Word that has the information that you want to be the same in each version such as the return address on an envelope or the main content of your email. You add fields as placeholders in the document for the unique information that you want to be updated such as the recipient's name or address.
Instead of having to manually create new versions of the same document and replace those fields, Word does all the work, pulling in information from your Outlook contacts, an Excel spreadsheet or other data source to run the mail merge. Make sure your contacts list is ready. It's best to have your spreadsheet or Outlook contacts prepared before you start creating the document so the mail merge goes smoothly. For example, whether you're using Outlook contacts or an Excel spreadsheet for your data source, make sure none of the data is missing for the fields you'll be pulling in.
If you're using Outlook and have a large number of contacts but only want to use mail merge for specific contacts, you'll make the process easier by selecting those contacts and copying them to a new folder.
Create a new blank document in Word. Navigate to the Mailings tab. Click the Start Mail Merge button and select your document type. We'll start with the letter first. Click the Select Recipients button and choose to create a new list, use an existing list, or choose from Outlook Contacts. The "Type a New List… " option creates a new data table in Word, but you're better off using an external source like a spreadsheet or the contacts list in Outlook so the data is readily available to other programs and other purposes.
If you choose "Use an Existing List…" you'll be asked to browse to the file on your computer and then confirm the data table. If you choose "Choose from Outlook Contacts…" you'll be asked to choose the Outlook contact folder and then add or remove recipients from the merge. This is why we advised in step one to create a new contacts folder for your mail merge: You won't have to scroll all of your contacts in this small box.
Create the content for your document and insert the placeholders. When you get to the part where you get to information that needs to be personalized from your data source, insert a placeholder with either the Insert Merge Field button or one of the two shortcuts Word offers for common fields: Address Block and Greeting Line. Use the Address Block shortcut. As the name suggests, the Address Block button creates a placeholder for a name and address--useful when creating letters or mailing labels or envelopes.
With both the Address Block and Greeting Line shortcuts, you'll be able to specify what gets inserted and preview what it will look like. Use the Greeting Line shortcut. The Greeting Line button adds a salutation that you can format. The dropdowns will let you select to include the full name by default , the full name with the title e. Joshua Randall Jr. As with the Address Block shortcut, preview the results of the mail merge and use the Merge Fields… button to correct make sure your fields match if they don't in the preview.
Insert other fields into your document. For other placeholders you might need, click on Insert merge field and select the field you want to insert at that point in the document. Preview the merge results after you've finished the document and inserted all your fields by clicking the Preview Results button. In the Mailings tab, use the forward and back buttons to check all of the mail merge results.
In addition to letters which can be any sort of document, including certificates and coupons , you can choose emails, envelopes, labels, or directories as the document type. Citations In Word, you can easily add citations when writing a document where you need to cite your sources, such as a research paper.
Afterwards, you can create a bibliography of the sources you used to write your paper. To add a citation to your document, first add the source you used. Create a source 1. On the References tab, click the arrow next to Bibliography Style and click the style that you want to use for the citation and source.
Click at the end of the sentence or phrase that you want to cite. On the References tab, click Insert Citation. In the Create New Source dialog box, next to Type of Source, select the type of source you want to use for example, a book section or a website.
Enter the details for the source and click OK. The source is added as a citation at the place you selected in your document. When you've completed these steps, the citation is added to the list of available citations. The next time you quote this reference, you don't have to type it all out again. You just add the citation see the steps in the following procedure.
Add citations to your document 1. Click at the end of the sentence or phrase that you want to cite, and then on the References tab, click Citations. In the Citations pane on the right, double-click the citation you want to add.
Make the changes you want to the source and click OK. To manage your list of sources, click Citation Source Manager and then add new sources or edit or delete sources in the list. Usually, footnotes appear at the bottom of the page and endnotes come at the end of the document or section.
Add a footnote 1. Click where you want to add a footnote. Word inserts a reference mark in the text and adds the footnote mark at the bottom of the page.
Type the footnote text. TIP: To return to your place in your document, double- click the footnote mark. Add an endnote 1. Click where you want to add an endnote. Type the endnote text. TIP: To return to your place in your document, double-click the endnote mark. Customize footnotes and endnotes After you add your footnotes and endnotes, you can change the way they appear.
For example, you can change the number format or where they show up in your document. On the Insert menu, click Footnote to open the Footnote and Endnote box. In the Footnote and Endnote box, select the options you want.
TIP: To restart footnote or endnote numbering at the beginning of each section, in the Footnote and Endnote box, click Footnotes orEndnotes, and in Numbering, click Restart each section.
Individual slides can include bullet points, pictures, charts, tables, and Practice files business diagrams. Select the paragraphs that you want to convert to list items. On the Home tab, in the Paragraph group, do either of the following: Click the Bullets button to convert the selection to a bulleted list.
Click the Numbering button to convert the selection to a numbered list. Start creating a bulleted or numbered list. When you want the next list item to be at a different level, do either of the following: To create the next item one level lower indented more , press the Tab key at the beginning of that paragraph, before you enter the lower-level list item text.
In the case of a bulleted list, Word changes the bullet character for each item level. In the case of a numbered list, Word changes the type of numbering used, based on a predefined numbering scheme. TIP For a multilevel list, you can change the numbering pattern or bullets by clicking the Multilevel List button in the Paragraph group on the Home tab and then clicking the pattern you want, or you can define a custom pattern by clicking Define New Multilevel List.
To modify the indentation of a list 1. Select the list items whose indentation you want to change, and do any of the following: On the Home tab, in the Paragraph group, click the Increase Indent button to move the list items to the right. In the Paragraph group, click the Decrease Indent button to move the list items to the left.
Display the horizontal ruler, and drag the indent markers to the left or right. With the finest documentformatting tools, Word helps you organize. With PowerPoint, you can create engaging presentations that can be presented in person, online,.
The function of these features will be more. When the Project Gallery opens, view some of the available Word templates by clicking to expand the Groups, and.
Microsoft Word Basics 1. From Start, look for the Word tile and click it. The Ribbon- seen across the top of Microsoft Word. The ribbon contains Tabs, Groups, and Commands a. Tabs sit across the. Start Word if the Word icon is not on the desktop: a. PPT 6 Yes. They are arranged in alphabetical order running from left to right. If you point. Introduction to Word You will notice some obvious changes immediately after starting Word For starters, the top bar has a completely new look, consisting of new features, buttons and naming.
What you can expect. Petersburg Office of Training Training dosp. Microsoft Office PowerPoint Navigating the PowerPoint Environment The Ribbon: The ribbon is where you will access a majority of the commands you will use to create and develop your presentation. Working with Tables in Microsoft Word The purpose of this document is to lead you through the steps of creating, editing and deleting tables and parts of tables.
This document follows a tutorial format. April 20, Publisher Cheat Sheet Toolbar customize click on arrow and then check the ones you want a shortcut for File Tab has new, open save, print, and shows recent documents, and has choices. You can click on a shortcut on your desktop. The following are the outlines: 1. Start Microsoft Word Describe the Word Screen. You can use Excel to create and format workbooks a collection of spreadsheets in order to analyze data and.
With Google. The Opening Screen You will see the default opening screen is actually composed of three parts: 1. This program helps you to enhance your oral presentation and keep the audience. Microsoft Publisher What s New!
A new. Word Processing programs and their uses An application that provides extensive tools for creating all kinds of text based programs. They are not limited to working with text and enable you to add images. In This Guide Microsoft PowerPoint looks very different, so we created this guide to help you minimize the learning curve.
Read on to learn key parts of the new interface, discover free PowerPoint. Using Microsoft Word Many Word documents will require elements that were created in programs other than Word, such as the picture to the right.
Nontext elements in a document are referred to as Objects. Microsoft PowerPoint PowerPoint is currently the most common software used for making visual aids for presentations. It has been redesigned for the release with a much more user-friendly and. Ribbon menu The Ribbon menu system with tabs for various Excel commands.
This Ribbon system replaces the traditional menus used with Excel Above the Ribbon in the upper-left corner is the Microsoft. Word basics Word is a powerful word processing and layout application, but to use it most effectively, you first have to understand the basics. This tutorial introduces some of the tasks and features that. That way, if someone else is reviewing your document they can tell you exactly which lines they have.
Set tabs and work with tables. Learn about styles Use the spelling and grammar. If you want to print a copy, your PDF viewer should have an option for printing two pages. These are found in the lower left corner of the screen. The most common is the print layout view. Hold your. Basic Microsoft Excel The biggest difference between Excel and its predecessors is the new layout. All of the old functions are still there with some new additions , but they are now located.
Quick Start Guide Microsoft Publisher looks different from previous versions, so we created this guide to help you minimize the learning curve. Quick Access Toolbar Add your favorite commands to the. We cannot guarantee. Excel basics Excel is a powerful spreadsheet and data analysis application, but to use it most effectively, you first have to understand the basics.
This tutorial introduces some of the tasks and features. Accessing Microsoft PowerPoint To access Microsoft PowerPoint from your home computer, you will probably either use the Start menu to select the program or double-click on an icon on the Desktop.
To open. Word Basics Learning Guide Exploring Word At first glance, the new Word interface may seem a bit unsettling, with fat bands called Ribbons replacing cascading text menus and task bars. PowerPoint presentations are composed of slides, just like conventional presentations.
Like a 35mm film-based slide, each PowerPoint slide. In This Guide Microsoft Word looks very different, so we created this guide to help you minimize the learning curve. Read on to learn key parts of the new interface, discover free Word training,.
User Guide Chapter 6 s Table of Contents 1. Key Information How to Add a How to Edit MS Word has many features and with it, a person can create reports, letters, faxes, memos, web pages, newsletters, and. Microsoft Word can be used to create documents, brochures,. Creating a Poster Presentation using PowerPoint Course Description: This course is designed to assist you in creating eye-catching effective posters for presentation of research findings at scientific.
Using Word you can add. The whistles turn to wows. You can now change. You will be directed to the "Portfolio Settings! Log in to Digication Go to your school! Excel Basics Learning Guide Exploring Excel At first glance, the new Excel interface may seem a bit unsettling, with fat bands called Ribbons replacing cascading text menus and task bars. Build exactly the skills you need.
Learn at the pace you want. What s the difference? The Backspace key deletes. Clip Art in Office In the process of making a certificate, we will cover: Adding clipart and templates from the Microsoft Office Clip Gallery, Modifying clip art by grouping and ungrouping, Flipping.
Excel -- Creating Charts The saying goes, A picture is worth a thousand words, and so true. Professional looking charts give visual enhancement to your statistics, fiscal reports or presentation. Close the Help window. Log in Registration. Search for. Microsoft Office Size: px.
Start display at page:. Download "Microsoft Office ". Ilene Hopkins 6 years ago Views:. View more. Similar documents. Microsoft Word Tutorial 1 Microsoft Word Tutorial Microsoft Word is a word-processing program, designed to help you create professional-quality documents.
With the finest documentformatting tools, Word helps you organize More information. With PowerPoint, you can create engaging presentations that can be presented in person, online, More information.
The function of these features will be more More information. Microsoft Word Quick Reference Guide. More information. Introduction to Microsoft Word 1. When the Project Gallery opens, view some of the available Word templates by clicking to expand the Groups, and More information.
Tabs sit across the More information. Module One: Getting Started Opening Outlook Setting Up Outlook for the First Time Understanding the Interface If you point More information. Introduction to Word Introduction to Word You will notice some obvious changes immediately after starting Word For starters, the top bar has a completely new look, consisting of new features, buttons and naming More information.
What you can expect More information. Enhanced Formatting and Document Management. Word Unit 3 Module 3. Diocese of St. Sample Table. This document follows a tutorial format More information. Publisher Cheat Sheet April 20, Publisher Cheat Sheet Toolbar customize click on arrow and then check the ones you want a shortcut for File Tab has new, open save, print, and shows recent documents, and has choices More information.
You can click on a shortcut on your desktop More information. In this session, we will explain some of the basics of word processing. Describe the Word Screen More information.
You can use Excel to create and format workbooks a collection of spreadsheets in order to analyze data and More information. With Google More information. This program helps you to enhance your oral presentation and keep the audience More information. A new More information. Microsoft Office Tutorial Word Processing programs and their uses Word Processing programs and their uses An application that provides extensive tools for creating all kinds of text based programs.
They are not limited to working with text and enable you to add images More information. Read on to learn key parts of the new interface, discover free PowerPoint More information. Using Microsoft Word. Working With Objects Using Microsoft Word Many Word documents will require elements that were created in programs other than Word, such as the picture to the right.
Nontext elements in a document are referred to as Objects More information. Microsoft PowerPoint Microsoft PowerPoint PowerPoint is currently the most common software used for making visual aids for presentations.
It has been redesigned for the release with a much more user-friendly and More information. Above the Ribbon in the upper-left corner is the Microsoft More information. Word basics. Before you begin. What you'll learn. Estimated time to complete: Word basics Word is a powerful word processing and layout application, but to use it most effectively, you first have to understand the basics.
To create a new worksheet, click the New Sheet button which looks like a plus sign in a circle at the right edge of the tab bar. After you decide what type of data you want to store on a worksheet, you should change the default worksheet name to something more descriptive. For example, you could change the name of Sheet1 in the regional distribution center tracking workbook to Northeast.
When you want to change a worksheet s name, double-click the worksheet s tab on the tab bar to highlight the worksheet name, enter the new name, and press Enter. Another way to work with more than one worksheet is to copy a worksheet from another workbook to the current workbook. One circumstance in which you might consider copying worksheets to the current workbook is if you have a list of your current employees in another workbook. You can copy worksheets from another workbook by right-clicking the tab of the sheet you want to copy and, on the shortcut menu, clicking Move Or Copy to open the Move Or Copy dialog box.
Modifying workbooks After the worksheet is in the target workbook, you can change the worksheets order to make the data easier to locate within the workbook. To change a worksheet s location in the workbook, you drag its sheet tab to the location you want on the tab bar.
If you want to remove a worksheet from the tab bar without deleting the worksheet, you can do so by right-clicking the worksheet s tab on the tab bar and clicking Hide on the shortcut menu. When you want Excel to redisplay the worksheet, right-click any visible sheet tab and then click Unhide. In the Unhide dialog box, click the name of the sheet you want to display, and click OK. To differentiate a worksheet from others, or to visually indicate groups or categories of worksheets in a multiple-worksheet workbook, you can change the color of a worksheet tab.
To do so, right-click the tab, point to Tab Color, and then click the color you want. TIP If you copy a worksheet to another workbook, and the destination workbook has the same Office Theme applied as the active workbook, the worksheet retains its tab color.
If the destination workbook has another theme applied, the worksheet s tab color changes to reflect that theme. For more information about Office themes, see Chapter 4, Changing workbook appearance. If you determine that you no longer need a particular worksheet, such as one you created to store some figures temporarily, you can delete the worksheet quickly. To do so, rightclick its sheet tab, and then click Delete.
In this exercise, you ll insert and rename a worksheet, change a worksheet s position in a workbook, hide and unhide a worksheet, copy a worksheet to another workbook, change a worksheet s tab color, and delete a worksheet.
In the dialog box that opens, click Delete to confirm the operation. Modifying worksheets After you put up the signposts that make your data easy to find, you can take other steps to make the data in your workbooks easier to work with. For example, you can change the width of a column or the height of a row in a worksheet by dragging the column s right border or the row s bottom border to the position you want.
Increasing a column s width or a row s height increases the space between cell contents, making your data easier to read and work with. TIP You can apply the same change to more than one row or column by selecting the rows or columns you want to change and then dragging the border of one of the selected rows or columns to the location you want. When you release the mouse button, all the selected rows or columns change to the new height or width. Adding space between the edge of a worksheet and cells that contain data, or perhaps between a label and the data to which it refers, makes the workbook s contents less crowded.
You insert rows by clicking a cell and clicking the Home tab on the ribbon. Excel inserts a row above the row that contains the active cell. You insert a column in much the same way, by choosing Insert Sheet Columns from the Insert list. When you do this, Excel inserts a column to the left of the active cell. When you click the Insert Options button, Excel displays a list of choices you can make about how the inserted row or column should be formatted, as described in the following table.
Option Format Same As Above Format Same As Below Format Same As Left Format Same As Right Clear Formatting Action Applies the formatting of the row above the inserted row to the new row Applies the formatting of the row below the inserted row to the new row Applies the formatting of the column to the left of the inserted column to the new column Applies the formatting of the column to the right of the inserted column to the new column Applies the default format to the new row or column If you want to delete a row or column, right-click the row or column head and then, on the shortcut menu that appears, click Delete.
The rows or columns you selected disappear, but they aren t gone for good as they would be if you d used Delete. Instead, they have just been removed from the display until you call them back. To return the hidden rows to the display, select the row or column headers on either side of the hidden rows or columns.
Modifying worksheets Just as you can insert rows or columns, you can insert individual cells into a worksheet. To insert a cell, click the cell that is currently in the position where you want the new cell to appear.
In the Insert dialog box, you can choose whether to shift the cells surrounding the inserted cell down if your data is arranged as a column or to the right if your data is arranged as a row. When you click OK, the new cell appears, and the contents of affected cells shift down or to the right, as appropriate. Similarly, if you want to delete a block of cells, select the cells, and on the Home tab, in the Cells group, in the Delete list, click Delete Cells to open the Delete dialog box complete with options that you can use to choose how to shift the position of the cells around the deleted cells.
TIP The Insert dialog box also includes options you can click to insert a new row or column; the Delete dialog box has similar options for deleting an entire row or column. If you want to move the data in a group of cells to another location in your worksheet, select the cells you want to move and point to the selection s border. When the pointer changes to a four-pointed arrow, you can drag the selected cells to the desired location on the worksheet.
If the destination cells contain data, Excel displays a dialog box asking whether you want to overwrite the destination cells contents. If you want to replace the existing values, click OK. If you don t want to overwrite the existing values, click Cancel and insert the required number of cells to accommodate the data you want to move. In this exercise, you ll insert a column and row into a worksheet, specify insert options, hide a column, insert a cell into a worksheet, delete a cell from a worksheet, and move a group of cells within the worksheet.
Excel deletes cell B6, moving the cells below it up to fill in the gap. When the pointer changes to a four- pointed arrow, drag the selected cells to cells BC The dragged cells replace cells BC One of the best ways to communicate the contents of a worksheet is to use a label. For example, you might create a list of Consolidated Messenger s delivery regions with the city where the region s distribution hub is located.
If you select cell B2, Excel highlights the cell s border, which obscures the text. If you want to combine cells B2 and C2 into a single cell, you can do so by merging the cells into a single cell. Now when you click cell B2, the selection border extends along the entire merged cell without blocking the text.
Merging and unmerging cells All other text is deleted. You can also merge the cells in multiple rows at the same time. For example, suppose your list has a main heading and a subheading. In this exercise, you will merge cells, unmerge cells, merge and center cells, and use Merge Across to combine cells in several rows into one merged cell per row. The operation creates four merged cells.
Assigning values to a workbook s properties makes it easier to find your workbook by searching in File Explorer or by using Windows 8 Search. Be sure to give your worksheets descriptive names.
If you want to use a worksheet s data in another workbook, you can send a copy of the worksheet to that other workbook without deleting the original worksheet. You can delete a worksheet you no longer need, but you can also hide a worksheet in a workbook.
When you need the data on the worksheet, you can unhide it. You can save yourself a lot of cutting and pasting by inserting and deleting worksheet cells, columns, and rows. By merging cells, you can add data labels that span multiple columns. Customize your Excel program window by changing how it displays your workbooks, zooming in on data, adding frequently used buttons to the Quick Access Toolbar, and rearranging or customizing the ribbon to meet your needs.
Customize the appearance of charts. Find trends in your data. Create dual-axis charts. Summarize your data by using sparklines.
Create diagrams by using SmartArt. Create shapes and mathematical equations. When you enter data into a Microsoft Excel worksheet, you create a record of important events, whether they are individual sales, sales for an hour of a day, or the price of a product. However, a list of values in cells can t communicate easily the overall trends in the data. The best way to communicate trends in a large collection of data is by creating a chart, which summarizes data visually.
In addition to the standard charts, with Excel , you can create compact charts called sparklines, which summarize a data series by using a graph contained within a single cell. You have a great deal of control over your charts appearance you can change the color of any chart element, choose a different chart type to better summarize the underlying data, and change the display properties of text and numbers in a chart.
If the data in the worksheet used to create a chart represents a progression through time, such as sales over several months, you can have Excel extrapolate future sales and add a trendline to the graph that represents that prediction.
In this chapter, you ll create a chart and customize its elements, find trends in your data, create a dual-axis chart, summarize data by using sparklines, create diagrams by using SmartArt, and create shapes that contain mathematical equations. Creating charts With Excel , you can create charts quickly by using the Quick Analysis Lens, which displays recommended charts to summarize your data. To display recommended charts, select the entire data range you want to chart, click the Quick Analysis button, and then click Charts to display the types of charts that Excel recommends.
You can display a live preview of each recommended chart by pointing to the icon that represents that chart. Clicking the icon adds the chart to your worksheet. When you point to a subtype, Excel displays a live preview of what the chart will look like if you click that subtype.
Unless you or another user changed the default, Excel creates a column chart. If Excel doesn t plot your data the way that you want it to appear, you can change the axis on which Excel plots a data column. The most common reason for incorrect data plotting is that the column to be plotted on the horizontal axis contains numerical data instead of textual data.
For example, if your data includes a Year column and a Maintenance column, instead of plotting maintenance data for each consecutive year along the horizontal axis, Excel plots both of those columns in the body of the chart and creates a sequential series to provide values for the horizontal axis. To make that change, select the chart and then, on the Design tab, in the Data group, click Select Data to open the Select Data Source dialog box.
To remove a column from an axis, select the column s name, and then click Remove. To add the column to the Horizontal Category Axis Labels pane, click that pane s Edit button to display the Axis Labels dialog box, which you can use to select a range of cells on a worksheet to provide values for an axis.
In the Axis Labels dialog box, click the Collapse Dialog button at the right edge of the Axis Label Range field, select the cells to provide the values for the horizontal axis not including the column header, if any , click the Expand Dialog button, and then click OK. After you create your chart, you can change its size to reflect whether the chart should dominate its worksheet or take on a role as another informative element on the worksheet.
For example, Gary Schare, the chief executive officer of Consolidated Messenger, could create a Chapter 9 Creating charts and graphics. In that case, he would display the chart and data for each business unit on the same worksheet, so he would want to make his charts small.
To resize a chart, select the chart, and then drag one of the handles on the chart s edges. By using the handles in the middle of the edges, you can resize the chart in one direction. When you drag a handle on the left or right edge, the chart gets narrower or wider, whereas when you drag the handles on the chart s top and bottom edges, the chart gets shorter or taller. You can drag a corner handle to change the chart s height and width at the same time; and you can hold down the Shift key as you drag the corner handle to change the chart s size without changing its proportions.
Just as you can control a chart s size, you can also control its location. To move a chart within a worksheet, drag the chart to the desired location. If you want to move the chart to a new worksheet, click the chart and then, on the Design tool tab, in the Location group, click Move Chart to open the Move Chart dialog box. To move the chart to a new chart sheet, click New Sheet and enter the new sheet s name in the accompanying field.
Clicking New Sheet creates a chart sheet that contains only your chart. You can still resize the chart on that sheet, but when Excel creates the new chart sheet, the chart takes up the full sheet. Creating charts Excel creates the chart, with both the Year and Volume data series plotted in the body of the chart. Excel redraws your chart, using the years as the values for the horizontal axis. Your chart appears on a chart sheet named Volume Chart.
Customizing the appearance of charts If you want to change a chart s appearance, select the chart and then click the Chart Styles button, which appears in a group of three buttons. These buttons, which are new in Excel , put chart formatting and data controls within easy reach of your chart.
You can select a new look for you chart by choosing from the many styles on the Style. Clicking the Color tab in the Chart Styles gallery displays a series of color schemes that you can select to change your chart s appearance. If you change your workbook s theme, Excel changes your chart s appearance to reflect the new theme s colors. When you create a chart by using the tools in the Charts group on the Insert tab, Excel creates an attractive chart that focuses on the data.
In most cases, the chart has a title, legend list of data series displayed in the chart , horizontal lines in the body of the chart to make it easier to discern individual values, and axis labels. If you want to create a chart that has more or different elements, such as additional data labels for each data point plotted on your chart, you can do so by selecting the chart and then, on the Design tab, in the Chart Layouts group, clicking Quick Layouts and then clicking the layout you want.
If you don t find the exact chart layout you want, you can select the chart and then click the Chart Elements action button, which appears to the right of the chart, to control each element s appearance and options. By selecting the Gridlines check box, you can determine whether the chart displays horizontal and vertical gridlines. In addition to changing your chart s layout, you can control the appearance of each element within the chart.
To select a chart element to format, click that element. For example, if you want to change the formatting of the data series named Volume in the column chart you created in the previous exercise, you can click any column in the series to select the entire series.
Any formatting changes you make then apply to every point in the entire series. If you want to change a single data point, select the entire series, and then click the chart element for example, a column that represents the data point that you want to change.
For example, you can highlight the column that represents the year in the chart you created in the previous exercise. Then click the desired chart element to select it. After you select the chart element, you can drag one of the element s handles to resize the element or drag the element to another location within the chart. To change the chart element s format, use the tools and dialog box launchers in the Shape Styles, Word Art Styles, Arrange, and Size groups on the Format tab to change the element s appearance.
You can also select the chart element and then, on the Format tab, in the Current Selection group, click Format Selection to display a Format pane that you can use to change the chart element s appearance. Doing so displays the pane related to that element. With the third action button, Chart Filters, you can focus on specific data in your chart.
Clicking the Chart Filters action button displays a filter interface that is very similar to that used to limit the data displayed in an Excel table. Selecting or clearing a check box displays or hides data related to a specific value within a series, which you can select as well. If you think you want to apply the same set of changes to charts you ll create in the future, you can save your chart as a chart template. When you select the data that you want to summarize visually and apply the chart template, you ll create consistently formatted charts in a minimum of steps.
To save a chart as a chart template, right-click the chart and then click Save As Template. Use the controls in the dialog box that opens to name and save your template. Then, to create a chart based on that template, select the data that you want to summarize and on the Insert tab, in the Charts group, click the dialog box launcher in the lower-right corner of the group to open the Insert Chart dialog box. Click Templates, click the template you want to use, and then click OK.
In this exercise, you ll change a chart s layout, apply a new Chart Style, change the number format of the values on the vertical axis, save the chart as a chart template, and apply the template to another chart.
Customizing the appearance of charts Excel closes the pane and updates the chart s appearance. Finding trends in your data You can use the data in Excel workbooks to discover how your business has performed in the past, but you can also have Excel make its best guess for example, as to future shipping revenues if the current trend continues.
Consider a graph that shows the fleet maintenance costs for the years through for Consolidated Messenger. The total has increased from to , but the growth hasn t been uniform, so guessing how much maintenance costs would increase if the overall trend continued would require difficult mathematical computations. Fortunately, Excel can perform that Chapter 9 Creating charts and graphics. To have Excel project future values in the maintenance costs data series, click the chart, click the Chart Elements action button, point to Trendline, click the right-pointing triangle that appears, and then click More Options to display the Format Trendline pane.
On the Trendline Options page of the Format Trendline pane, you can choose the data distribution that Excel should expect when it makes its projection. The other distributions are used for scientific and engineering applications and you will most likely know, or be told by a colleague, when to use them. After you choose the distribution type, you can tell Excel how far ahead to project the data trend.
The horizontal axis of the chart used in this example shows revenues by year from to To tell Excel how far in the future to look, enter a number in the Forecast area s Forward box. In this case, to look ahead one year, enter 1 in the Forward box, and then click OK to add the trendline to the chart.
Finding trends in your data As with other chart elements, you can double-click the trendline to open a formatting dialog box and change the line s appearance. In this exercise, you ll add a trendline to a chart. The Format Trendline pane appears. For example, Consolidated Messenger might track seasonal package volumes for each regional distribution center by category and, as part of the same data collection, track the number of improperly routed packages.
When you have two differing but related data series in a table, you can summarize the data by using a dual-axis chart. To create a dual-axis chart, click any cell in the data you want to chart and then, on the Insert tab, click the type of chart you want to create. When you do, Excel plots both data series by using that chart type. To do that, click the chart and then, on the Design tool tab, click Change Chart Type to display the dialog box of the same name.
To choose how to format a series, click the Chart Type arrow for that series and select its chart type. If you want the series to be plotted in relation to the values on the left vertical axis, leave the Secondary Axis check box cleared. To have the series plotted in relation to the values on the right vertical axis, select the Secondary Axis check box. When you click OK, Excel creates your chart. Be sure to read them carefully. In this exercise, you ll create a dual-axis chart.
When you do, Excel creates a chart with the two data series. Enter Comparison for the chart title. Then, in the list of chart types, click Combo to display the Combo Chart interface. Doing so adds a second vertical axis to the right edge of the chart. The values on this axis reflect the values in the Exceptions series. Creating dual-axis charts Summarizing your data by using sparklines You can create charts in Excel workbooks to summarize your data visually by using legends, labels, and colors to highlight aspects of your data.
It is possible to create very small charts to summarize your data in an overview worksheet, but you can also use sparklines to create compact, informative charts that provide valuable context for your data. Edward Tufte introduced sparklines in his book Beautiful Evidence Graphics Press, , with the goal of creating charts that imparted their information in approximately the same space as a word of printed text.
In Excel, a sparkline occupies a single cell, which makes it ideal for use in summary worksheets. As an example, suppose Lori Penor wanted to summarize the monthly revenue data for one of Consolidated Messenger s local branches. The line and column sparklines are compact versions of the standard line and column charts. To create a line sparkline, you select the data you want to summarize and then, on the Insert tab, in the Sparklines group, click the Line button.
When you do, Excel displays the Create Sparklines dialog box. Summarizing your data by using sparklines If the data range is not correct, you can click the Collapse Dialog button to the right of the Data Range box, select the correct cells, and then click the Expand Dialog button. Then, in the Location Range box, enter the address of the cell into which you want to place your sparkline. When you click OK, Excel creates a line sparkline in the cell you specified.
You follow the same basic procedure to create a column sparkline, except that instead of clicking the Line button in the Sparklines group on the Insert tab, you click the Column button.
If you measured monthly revenue for Chapter 9 Creating charts and graphics. Months in which Consolidated Messenger s branch exceeded its revenue target appear in the top half of the cell in blue, months in which the branch fell short of its target appear in the bottom half of the cell in red, and the month in which the revenue was exactly the same as the target is blank.
After you create a sparkline, you can change its appearance. Because a sparkline takes up the entire interior of a single cell, resizing that cell s row or column resizes the sparkline. You can also change a sparkline s formatting. When you click a sparkline, Excel displays the Design tool tab. You can t delete a sparkline by clicking its cell and then pressing the Delete or Backspace key you must click the cell and then, on the Design tool tab, click the Clear button. If you find yourself adding markers and labels to a sparkline, you might consider using a regular chart to take advantage of its wider range of formatting and customization options.
Excel creates a line sparkline in cell G3. The Create Sparklines dialog box opens again. Excel creates a column sparkline in cell H3. Excel displays more details in the sparkline. The sparkline disappears. Creating diagrams by using SmartArt As an international delivery company, Consolidated Messenger s business processes are quite complex. Many times, chief operating officer Lori Penor summarizes the company s processes for the board of directors by creating diagrams.
Excel has just the tool she needs to create those diagrams: SmartArt. Clicking All displays every available SmartArt graphic type. The following table lists the types of diagrams you can create by using the Choose A SmartArt Graphic dialog box. TIP The Office.
Creating diagrams by using SmartArt Be sure to examine all your options before you decide on the type of diagram to use to illustrate your point. After you click the button that represents the type of diagram you want to create, click OK to add the diagram to your worksheet.
While the diagram is selected, Excel displays the Design and Format tool tabs. You can use the tools on the Design tool tab to change the graphic s layout, style, or color scheme. The Design tool tab also contains the Create Graphic group, which is home to tools you can use to add a shape to the SmartArt graphic, add text to the graphic, and promote or demote shapes within the graphic. As an example, consider a process diagram that describes how Consolidated Messenger handles a package within one of the company s regional distribution centers.
If you enter the process steps in the wrong order, you can move a shape by right-clicking the shape you want to move and then clicking Cut on the shortcut menu that appears. To paste the shape back into the graphic, right-click the shape to the left of where you want the pasted shape to appear, and then click Paste. For example, if you have a five-step process and accidentally switch the second and third steps, you can move the third step to the second position by right-clicking the third step, clicking Cut, right-clicking the first shape, and then clicking Paste.
If you want to add a shape to a SmartArt graphic, to add a step to a process, for instance, click a shape next to the position you want the new shape to occupy and then, on the Design tool tab, in the Create Graphic group, click Add Shape, and then click the option that represents where you want the new shape to appear in relation to the selected shape.
TIP The options that appear when you click Add Shape depend on the type of SmartArt graphic you created and which graphic element is selected. If you have selected the text in a shape, you can use the tools in the Font group on the Home tab to change the text s appearance.
TIP You can use the controls in the Format Shape dialog box to change the shape s fill color, borders, shadow, three-dimensional appearance, and text box properties. Excel creates the organization chart graphic. The value CEO appears in the shape at the top level of the organization chart. Excel removes the shape and moves the shapes on the third level of the organization chart to the second level. A new shape appears below the CFO shape. Excel applies the new layout to your organization chart.
Excel changes the shape s fill to red. Creating shapes and mathematical equations With Excel, you can analyze your worksheet data in many ways, including summarizing your data and business processes visually by using charts and SmartArt. You can also augment your worksheets by adding objects such as geometric shapes, lines, flowchart symbols, and banners. To add a shape to your worksheet, click the Insert tab and then, in the Illustrations group, click the Shapes button to display the shapes available.
When you click a shape in the gallery, the pointer changes from a white arrow to a thin black crosshair. To draw your shape, click anywhere in the worksheet and drag the pointer until your shape is the size you want. When you release the mouse button, your shape appears and Excel displays the Format tool tab on the ribbon.
For example, clicking the Rectangle tool and then holding down the Shift key while you draw the shape causes you to draw a square.
You can resize a shape by clicking the shape and then dragging one of the resizing handles around the edge of the shape. You can drag a handle on a side of the shape to drag that side to a new position; when you drag a handle on the corner of the shape, you affect height and width simultaneously. If you hold down the Shift key while you drag a shape s corner, Excel keeps the shape s height and width in proportion.
To rotate a shape, select the shape and then drag the white rotation handle at the top of the selection outline in a circle until the shape is in the orientation you want. TIP You can assign your shape a specific height and width by clicking the shape and then, on the Format tool tab, in the Size group, entering the values you want in the height and width boxes.
- Microsoft excel 2016 step by step by curtis frye pdf free
No part of the contents of this book may be reproduced or transmitted in any form or by any means without the written permission of shep publisher. Увидеть больше Printing Microsoft Press books are available through booksellers and distributors worldwide.
If you need support related to this book, Microsoft Press Support at Please tell us what you think of this book at This book is provided as-is and expresses the authors views and opinions. The views, opinions, and information expressed pvf this book, including URL and other Internet website references, may change without notice.
Some examples depicted herein are provided for illustration only and are fictitious. No real association or connection is intended or should be inferred. Microsoft and the trademarks listed at on the Trademarks webpage are trademarks of the Microsoft group of companies. All other marks are property of their respective cugtis. Thank you! This Step by Step book has been designed to make it easy for excle to learn about key aspects of four of the Microsoft Office apps Word, Excel, PowerPoint, and Outlook.
Frey each part, you can start microsoft excel 2016 step by step by curtis frye pdf free the beginning and build fryr skills as you learn to perform specialized procedures. Or, if ldf prefer, you can jump in wherever you need ready guidance for performing tasks. The how-to steps are delivered crisply and concisely just the facts.
You ll also find informative, colorful graphics that support the instructional content. Who this book is for Microsoft Office Step by Step is designed for use as a learning and reference resource by home and business users of Microsoft Office apps who want to use Word, Excel, and Microsofh to create and edit files, and Outlook to organizecontacts, and appointments. Hy content of the book is designed to be useful for people who have previously used earlier versions of the strp, and for people who посмотреть еще discovering the apps for the first time.
Although the chapters in this book thoroughly cover key skill sets microsoft excel 2016 step by step by curtis frye pdf free each of the four apps, Microsoft Office Step by Step is best used as an introduction. A listing of the contents of each book microosft provided at the microzoft of this book. Each part is divided into chapters representing some of the app s key skill set areas, and each chapter is divided into topics that group related skills.
Each topic includes expository information followed by generic procedures. At the end of the chapter, you ll find a series of practice tasks you can complete on your own by using the skills taught in the chapter.
You can use the practice files that are available from this book s website to sgep through the practice tasks, or you can use your own files. Download the practice files Before you can complete the practice tasks in this book, you need mocrosoft download the book s practice files to your computer from Follow the instructions on the webpage.
You should install the apps before working through the procedures and practice tasks in this book. If you later want to repeat microsofft tasks, you can excfl the original practice files again. The following table lists the practice files for this book. Errata and support We ve made every effort to ensure the accuracy of this book and its companion content.
If you need to contact the Microsoft Press Support team, please send an message to For help with Microsoft software and hardware, go to xv. Please tell us what you think of this book microsoft excel 2016 step by step by curtis frye pdf free The survey is short, micrlsoft we read every one of your ztep and ideas. Thanks in advance for your input!
Stay in touch Let s keep the conversation going! We re on Twitter at xvi. You can provide structure and meaning by formatting the text in various ways. Word provides a variety of simple-to-use tools that you can use to apply sophisticated formatting and create a navigational structure.
In ste; short document or one that doesn t require a complex navigational structure, you can easily format words and exceo so that key points stand out and the structure of your document is clear. You can achieve dramatic flair by applying predefined WordArt text effects. To keep the appearance of documents and other Microsoft Office files consistent, you can format document elements by applying predefined sets of formatting called styles.
In addition, you can change the fonts, colors, curtus effects throughout a document with one click by applying a theme.
This chapter guides you microsoft excel 2016 step by step by curtis frye pdf free procedures related to applying character and paragraph formatting, structuring content manually, creating and modifying lists, applying styles to text, and changing a document s theme.
For practice file download instructions, see the introduction. A paragraph can contain one word, one sentence, or multiple sentences. Every paragraph ends with a paragraph mark, which looks like a backward P. Paragraph autodesk maya 2013 x32 and other structural characters such as spaces, line breaks, and tabs are usually hidden, but you can display them. Sometimes displaying these hidden characters makes it easier to accomplish a task or understand a microsoft excel 2016 step by step by curtis frye pdf free problem.
You can change the look of a paragraph by changing its indentation, alignment, and line spacing, in addition to the space before and after it. You can also put borders around it and shade its background. Collectively, the settings you use to vary the look of a paragraph are called paragraph formatting.
You can modify a paragraph s left and right edge alignment and vertical spacing by using tools on the Home tab of the ribbon, and microsoft excel 2016 step by step by curtis frye pdf free left and right indents from the Home tab or from the ruler.
The приведенная ссылка is usually hidden to provide more space for the document content. The left indent can be changed from the Home tab or the ruler If you modify a paragraph and aren t happy with the changes, you can restore the original paragraph and character settings by clearing the formatting to reset the paragraph to its base style. Microsoft excel 2016 step by step by curtis frye pdf free are four alignment options: Align Left This is the default paragraph alignment.
It sets the left end of each line of the paragraph at the left page margin or left indent. It results in a straight left edge and a ragged right edge. Align Right This sets the right end of each line of the paragraph at the right page margin or right indent. It results in a 216 right edge and a ragged left edge. Center This centers each line of the paragraph between the left and right page margins or indents.
It results fre ragged left curts right edges. Justify This alignment adjusts the spacing between ccurtis so that the left end of each line of the paragraph is at the left curttis margin or indent and the right end of each line of the paragraph other than the last line is at the right margin or indent. It results in straight left and right edges.
To open the Paragraph dialog box 1. Do either of the following: On the Home tab or the Layout tab, in the Paragraph group, click the Paragraph dialog box launcher. To set paragraph alignment 1. Position the cursor anywhere in the paragraph, or select all the paragraphs you want to adjust. Open the Paragraph dialog box. Configure vertical spacing Paragraphs have two types of vertical spacing: Paragraph spacing The space between paragraphs, defined by setting the space before and after each paragraph.
This space is usually measured in points. Line spacing The space between the lines of the paragraph, defined by setting the height of the lines either in relation to the height of the text Single, Double, or a specific number of lines or by specifying a minimum or exact point measurement.
The default line spacing for documents created in Word is 1. Changing the line spacing changes the appearance and readability of the text in the paragraph and, of course, also changes the amount of space it crtis on the page. You can quickly adjust the spacing of most content in a document by selecting an option from the Paragraph Spacing menu on the Design tab. Although the menu is named Paragraph Spacing, the menu options control both paragraph spacing and line spacing.
These options, sgep are named by effect rather than by specific measurements, work by modifying the spacing of the Normal paragraph style and any other styles that depend on the Normal style for their spacing. In standard templates, microsoft excel 2016 step by step by curtis frye pdf free other styles are based on the Normal style.
The Paragraph Spacing options modify the Normal style in only the current document, and do not affect other documents. The following table describes the effect of each Paragraph Spacing option on the paragraph and line spacing settings. Paragraph spacing option Before paragraph After paragraph Line spacing Default Spacing options are controlled by the style set No Paragraph Space 0 points 0 points 1 line Compact 0 points 4 points 1 stpe Tight 0 points 6 points 1.
Each paragraph spacing option controls space around and within the paragraph 2. Click the option you microsof to apply to all of the paragraphs in the document.
To adjust the spacing between paragraphs 1. Select all the paragraphs you want to adjust. To make a quick adjustment to selected paragraphs, on узнать больше здесь Home tab, in the Paragraph stepp, click Line And Paragraph Spacing, and then click any of the line spacing commands on the menu. Clicking one of the last two options adds or removes ссылка preset mifrosoft of space between the selected paragraphs.
On the Indents and Spacing tab, in the Spacing area, make the adjustments you want to the paragraph spacing, and then click OK. For information about sections, see Control what appears on each page in the same chapter. Although the left and right margins are set for a whole document or for a section of a document, you can vary frte position of the paragraphs between the margins by indenting the left or right edge b the paragraph. A paragraph indent is the space from the page margin to the text.
You can change the left indent by clicking buttons on the Home tab, or you nicrosoft set the indents directly on the ruler. Three indent markers are always present on the ruler: Left Indent This defines the outermost left edge of each line of the paragraph. Right Indent This defines the outermost pef edge of each line of the paragraph. First Line Indent This defines the starting point of the first line of the paragraph.
The ruler indicates the space between the left and right page margins in a lighter color than the space outside of the page margins. The indent markers on the ruler The default setting for the Right Indent marker is the distance from the left margin to the right margin.
For example, if the page size is set to 8. You can arrange the Left Indent and First Line Indent markers to create a hanging indent or a first line indent. Hanging indents are most commonly used for bulleted and numbered lists, in which the bullet or number is indented less than the main text essentially, it is outdented.
First line indents are frequently used to distinguish the beginning of each subsequent paragraph in frer that consist of many consecutive paragraphs fee text. Both types of indents are set by using the First Line Indent marker on the ruler.
Moving the Left Indent marker also moves the First Line Indent marker, to maintain the first line indent distance.
Comments
Post a Comment