Exceed expectations Instructional exercise 2 Arranging an Exercise manual.


99 views
Uploaded on:
Category: Fashion / Beauty
Description
Exceed expectations Instructional exercise 2 Arranging an Exercise manual Goals Design content, numbers, and dates Change text style hues and fill hues Consolidation a reach into a solitary cell Apply an inherent cell style Select an alternate subject Targets Apply an implicit table style
Transcripts
Slide 1

Exceed expectations Tutorial 2 Formatting a Workbook

Slide 2

Objectives Format content, numbers, and dates Change textual style hues and fill hues Merge an extent into a solitary cell Apply an inherent cell style Select an alternate topic New Perspectives on Microsoft Office Excel 2007

Slide 3

Objectives Apply an implicit table style Add contingent arrangements to tables with highlight guidelines and information bars Hide worksheet columns Insert print titles, set print zones, and supplement page breaks Enter headers and footers New Perspectives on Microsoft Office Excel 2007

Slide 4

Formatting Workbooks Formatting is the procedure of defining so as to change a workbook’s appearance the text styles, styles, hues, and enhancing components A subject is an accumulation of organizing that indicates the text styles, hues, and graphical impacts utilized all through the exercise manual As you work, Live Preview demonstrates the impacts of arranging choices on the workbook’s appearance before you apply them New Perspectives on Microsoft Office Excel 2007

Slide 5

Formatting Text The presence of content is controlled by its typeface , which is the particular configuration utilized for the characters Font Serif text styles Sans serif text styles Theme text style Non-topic textual style Font Style Font Size Measured in focuses New Perspectives on Microsoft Office Excel 2007

Slide 6

Working with Color Theme hues are the 12 hues that fit in with the workbook’s topic Standard and custom hues Apply a selecting so as to shade a cell or scope of cells, tapping the Font Color or Fill Color catch bolt, and after that selecting a suitable shading New Perspectives on Microsoft Office Excel 2007

Slide 7

Formatting Text Selections The Mini toolbar shows up when you select content and contains catches for usually utilized content organizations New Perspectives on Microsoft Office Excel 2007

Slide 8

Setting a Background Image You can utilize a photo or picture as the foundation for every one of the cells in a worksheet Click the Page Layout tab on the Ribbon Click the Background catch Locate the foundation, and afterward tap the Insert catch New Perspectives on Microsoft Office Excel 2007

Slide 9

Formatting Data By default, qualities show up in the General number configuration , which, generally, shows numbers precisely as you enter them The Number gathering on the Home tab has catches for designing the presence of numbers Comma style catch Decrease Decimal catch Percent Style catch Increase Decimal catch Accounting Number Format catch New Perspectives on Microsoft Office Excel 2007

Slide 10

Formatting Data New Perspectives on Microsoft Office Excel 2007

Slide 11

Formatting Dates and Times Although dates and times in Excel show up as content, they are really numbers that measure the interim between the predefined date and time and January 1, 1900 at 12:00 a.m. New Perspectives on Microsoft Office Excel 2007

Slide 12

Aligning Cell Content notwithstanding left and right arrangements, you can change the vertical and even arrangements of cell substance to make a worksheet more intelligible Alignment catches are situated on the Home tab New Perspectives on Microsoft Office Excel 2007

Slide 13

Indenting Cell Content You expand the space by about one character every time you tap the Increase Indent catch in the Alignment bunch on the Home tab New Perspectives on Microsoft Office Excel 2007

Slide 14

Merging Cells One approach to adjust content more than a few sections or lines is to consolidate , or join, a few cells into one cell New Perspectives on Microsoft Office Excel 2007

Slide 15

Rotating Cell Content To spare space or to give visual enthusiasm to a worksheet, you can pivot the cell substance so they show up at any edge or introduction Select the extent In the Alignment gathering, tap the Orientation catch and pick a legitimate revolution New Perspectives on Microsoft Office Excel 2007

Slide 16

Rotating Cell Content New Perspectives on Microsoft Office Excel 2007

Slide 17

Adding Cell Borders You can add fringes to one side, top, right, or base of a phone or reach, around a whole cell, or around the outside edges of a reach utilizing the Border catch bolt New Perspectives on Microsoft Office Excel 2007

Slide 18

Working with the Format Cells Dialog Box The Format Cells dialog box has six tabs, every concentrating on an alternate arrangement of organizing choices New Perspectives on Microsoft Office Excel 2007

Slide 19

Copying Formats with the Format Painter The Format Painter duplicates the designing starting with one cell or range then onto the next cell or extent, without copying any of the information Select the extent containing the organization you wish to duplicate Click the Format Painter catch on the Home tab Click the phone to which you need to apply the configuration New Perspectives on Microsoft Office Excel 2007

Slide 20

Copying Formats with the Paste Options Button New Perspectives on Microsoft Office Excel 2007

Slide 21

Copying Formats with Paste Special New Perspectives on Microsoft Office Excel 2007

Slide 22

Applying Styles A style is an accumulation of arranging Select the phone or extent to which you need to apply a style In the Styles bunch on the Home tab, tap the Cell Styles catch Point to every style in the Cell Styles exhibition to see a Live Preview of that style on the chose cell or reach Click the style you need to apply to the chose cell or range New Perspectives on Microsoft Office Excel 2007

Slide 23

Applying Styles New Perspectives on Microsoft Office Excel 2007

Slide 24

Working with Themes The presence of these text styles, hues, and cell styles relies on upon the workbook’s current subject New Perspectives on Microsoft Office Excel 2007

Slide 25

Applying a Table Style to an Existing Table You can regard a scope of information as a particular article in a worksheet known as an Excel table Select the reach to which you need to apply the table style In the Styles bunch on the Home tab, tap the Format as Table catch Click a table style in the Table Style display New Perspectives on Microsoft Office Excel 2007

Slide 26

Applying a Table Style to an Existing Table New Perspectives on Microsoft Office Excel 2007

Slide 27

Selecting Table Style Options After you apply a table style, you can pick which table components you need included in the style New Perspectives on Microsoft Office Excel 2007

Slide 28

Introducing Conditional Formats A restrictive arrangement applies organizing just when a cell’s worth meets a predefined condition Select the reach or extents to which you need to include information bars. In the Styles bunch on the Home tab, tap the Conditional Formatting catch, point to Data Bars, and afterward click an information bar shading or Select the reach in which you need to highlight cells that match a predetermined tenet In the Styles gathering, tap the Conditional Formatting catch, point to Highlight Cells Rules or Top/Bottom Rules, and after that tap the proper standard Select the suitable alternatives in the dialog box, and afterward tap the OK catch New Perspectives on Microsoft Office Excel 2007

Slide 29

Adding Data Bars An information bar is an even bar added to the foundation of a phone to give a visual marker of the cell’s worth Select the cell(s) In the Styles bunch on the Home tab, tap the Conditional Formatting catch, point to Data Bars , and after that tap the DataBar choice you wish to apply New Perspectives on Microsoft Office Excel 2007

Slide 30

Adding Data Bars New Perspectives on Microsoft Office Excel 2007

Slide 31

Hiding Worksheet Data Hiding lines, segments, and worksheets is a great approach to disguise superfluous or diverting data In the Cells bunch on the Home tab, tap the Format catch, point to Hide & Unhide , and afterward click your coveted choice New Perspectives on Microsoft Office Excel 2007

Slide 32

Changing the Page Orientation to Landscape Click the Page Layout tab on the Ribbon In the Page Setup gathering, tap the Orientation catch, and afterward snap Landscape New Perspectives on Microsoft Office Excel 2007

Slide 33

Defining the Print Area By default, all parts of the dynamic worksheet containing content, recipes, or qualities are printed You can choose the phones you need to print, and after that characterize them as a print zone Select the extent, in the Page Setup bunch on the Page Layout tab, tap the Print Area catch, and afterward snap Set Print Area New Perspectives on Microsoft Office Excel 2007

Slide 34

Inserting Page Breaks Excel prints as much as fits on a page and afterward embeds a page break to keep printing the remaining worksheet content on the following page Manual page breaks indicate precisely where the page breaks happen New Perspectives on Microsoft Office Excel 2007

Slide 35

Setting and Removing Page Breaks To set a page break: Select the first cell underneath the line where you need to embed a page soften Up the Page Setup bunch on the Page Layout tab, tap the Breaks catch, and afterward snap Insert Page Break To evacuate a page break: Select any phone beneath or to one side of the page soften you need to uproot Up the Page Setup bunch on the Page Layout tab, tap the Breaks catch, and afterward snap Remove Page Break (or snap Reset All Page Breaks to expel all the page breaks from the worksheet) New Perspectives on Microsoft Office Excel 2007

Slide 36

Setting and Removing Page Breaks New Perspectives on Microsoft Office Excel 2007

Slide 37

Adding Print Titles You can rehash data, for example, the organization name, by determining which lines or sections in the worksheet go about as print titles , data that prints on every page In the Page Setup bunch on the Page Layout tab, tap the Print Titles catch Click the Rows to rehash at top box, move your pointer over the worksheet, and after that select the extent Click the OK catch New Perspectives on Microsoft Office Excel 2007

Slide 38

Adding Print Titles New Perspectives on Mic

Recommended
View more...