1 / 11

Excel Tutorial 2 Notes

Excel Tutorial 2 Notes. Formatting a Workbook. Formatting. Formatting: process of changing a workbook’s appearance by defining fonts, styles, colors, and decorative features.

field
Download Presentation

Excel Tutorial 2 Notes

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Excel Tutorial 2 Notes Formatting a Workbook

  2. Formatting • Formatting: process of changing a workbook’s appearance by defining fonts, styles, colors, and decorative features. • Theme: collection of formatting that specifies the fonts, colors, and graphical effects used throughout the workbook. • Typeface: design used for the characters.

  3. Working with Color • Color can transform your spreadsheet into a powerful presentation that captures attention and adds visual emphasis to the points you want to emphasize. • Too much color can be just as bad as not enough.

  4. Formatting Numbers • General number format: displays numbers exactly how you enter them. • Home tab Numbers group: buttons for formatting the appearance of numbers. • Some ways numbers can be formatted: • Decimals • Thousand separators • Currency • Percentage

  5. Formatting Worksheet Cells • Generally, • Text should be left-aligned • Numbers should be right-aligned • Center column titles • Alignment options are found on the home tab.

  6. Merging Cells • Merge: combine text over several columns or rows. • Merge and Center button: located on the Home tab, Alignment group.

  7. Borders • When a worksheet is printed, by default the gridlines are not printed. They can be printed by changing that option in the ribbon. • You can add borders around the cells or around the spreadsheet. • Border: adding a line around the outside boundary lines of the cell or range of cells. • Borders can be added to the left, right, top, and bottom. • Borders button is located on the Home tab, Font group.

  8. Format Cells Dialog Box • Six tabs that each focus on a different set of formatting options: • Number • Alignment • Font • Border • Fill • Protection

  9. Table Styles • Table style: formats the entire table as a single unit.

  10. Conditional Formatting • Conditional formatting: applies formatting only when a cell’s value meets a specified condition. • Example, a conditional formatting can make negative numbers red and positive numbers black. • 4 Conditional formats • Data bars • Highlighting • Color scales • Icon sets

  11. Print Titles Print titles: information that prints on each page.

More Related