When it comes to Excel, appearances count. Get simple, powerful tips for making spreadsheet information more readable and understandable in Excel for Mac 2016. Dennis Taylor shows how to emphasize specific cells with fonts, borders, and color; adjust the positioning of cell contents; format numeric data quickly; use conditional formatting; and add style and readability to worksheets. You'll also learn how to add pictures to worksheets and discover power formatting techniques—such as shortcuts and a quick copy/paste technique—that take the drudgery out of formatting even the largest amounts of data. Instructor. Excel expert Dennis Taylor has 25+ years experience in spreadsheet authoring and training. Dennis Taylor has over 25 years of experience working with spreadsheet programs as an author, speaker, seminar leader, and facilitator.
![Time Time](/uploads/1/2/5/4/125463737/127604085.png)
Formats a number or a date/time value for display as a string of text. And how to display the name of a month. PowerApps supports a subset of the placeholders that Microsoft Excel does. See working with dates and times for more information. Formats the number with one decimal place. “1234.6” Text( 8.9, “#.000” ).
Since the mid-90s, he has been the author/presenter of numerous Excel video and online courses and has traveled throughout the US and Canada presenting over 300 seminars and classes. He has authored or co-authored multiple books on spreadsheet software and has presented over 500 Excel webinars to a diversity of audiences. Dennis has worked with hundreds of different corporations and governmental agencies as well as colleges and universities. He lives in Boulder, Colorado. By: Dennis Taylor course. 4h 22m 6s. 5,413 viewers.
Course Transcript - Dennis Hi, I'm Dennis Taylor, and welcome to Excel for Mac 2016, Advanced Formatting Techniques. When you're working with Excel, there's no question that appearances count. A dull lifeless display will not get the attention it deserves.
You need to know the scope of Excel's formatting features, and the quickest and best ways to get to them. In this course, I'll show you keystroke shortcuts to format numeric cells, how to use conditional formatting to apply formats dynamically, the most efficient ways to copy formats quickly, and numerous features that add flare and visual interest to your worksheets.
Excel gives you a ton of formatting tools that lets you eliminate any doubt about what your data means. And I'm looking forward to showing them to you during this course. Practice while you learn with exercise files.
Watch this course anytime, anywhere. Course Contents. Introduction Introduction. 1. Controlling Fonts, Borders, and Cell Color 1. Controlling Fonts, Borders, and Cell Color.
2. Alignment Tools 2. Alignment Tools. 3. Adjusting Numeric Formats Quickly 3. Adjusting Numeric Formats Quickly.
4. Accentuating Dynamic Data with Conditional Formatting 4. Accentuating Dynamic Data with Conditional Formatting. 5. Tables, Styles, and Themes 5.
Tables, Styles, and Themes. 6. Row, Column, and Sheet Adjustments 6. Row, Column, and Sheet Adjustments. 7.
Other Worksheet Formatting Tools 7. Other Worksheet Formatting Tools. 8. Displaying Data as an Outline 8. Displaying Data as an Outline.
9. Adding Pictures 9. Adding Pictures. 10. Specialized Power Formatting Techniques 10.
Specialized Power Formatting Techniques. Conclusion Conclusion.
![2016 2016](/uploads/1/2/5/4/125463737/366418453.png)
Why use number formats? Number formats don't just make your spreadsheet easier to read—they also make it easier to use. When you apply a number format, you're telling your spreadsheet exactly what types of values are stored in a cell. For example, the date format tells the spreadsheet that you're entering specific calendar dates. This allows the spreadsheet to better understand your data, which can help ensure that your data remains consistent and that your formulas are calculated correctly.
If you don't need to use a specific number format, the spreadsheet will usually apply the general number format by default. However, the general format may apply some small formatting changes to your data. Applying number formats Just like other types of formatting, such as changing the font color, you'll apply number formats by selecting cells and choosing the desired formatting option. There are two main ways to choose a number format:.
Go to the Home tab, click the Number Format drop-down menu in the Number group, and select the desired format. As you can see, the calculation in the spreadsheet on the left didn't work correctly. Without the percentage number format, our spreadsheet thinks we want to multiply $22.50 by 5, not 5%. And while the spreadsheet on the right still works without percentage formatting, the spreadsheet in the middle is easier to read. Date formats Whenever you're working with dates, you'll want to use a date format to tell the spreadsheet that you're referring to specific calendar dates, such as July 15, 2014. Date formats also allow you to work with a powerful set of date functions that use time and date information to calculate an answer.
Spreadsheets don't understand information the same way a person would. For instance, if you type October into a cell, the spreadsheet won't know you're entering a date so it will treat it like any other text. Instead, when you enter a date, you'll need to use a specific format your spreadsheet understands, such as month/day/year (or day/month/year depending on which country you're in). In the example below, we'll type for October 12, 2014. Our spreadsheet will then automatically apply the date number format for the cell. Number formatting tips Here are a few tips for getting the best results with number formatting:.
Apply number formatting to an entire column: If you're planning to use one column for a certain type of data, like dates or percentages, you may find it easiest to select the entire column by clicking the column letter and applying the desired number formatting. This way, any data you add to this column in the future will already have the correct number format. Note that the header row usually won't be affected by number formatting. If you want your data to appear exactly as entered, you'll need to use the text number format. This format is especially good for numbers you don't want to perform calculations with, such as phone numbers, zip codes, or numbers that begin with 0, like 02415. For best results, you may want to apply the text number format before entering data into these cells.
Increase and Decrease Decimal The Increase Decimal and Decrease Decimal commands allow you to control how many decimal places are displayed in a cell. These commands don't change the value of the cell; instead, they display the value to a set number of decimal places. The Increase/Decrease Decimal commands don't work with some number formats, like Date and Fraction.
In cell D2, type today's date and press Enter. Click cell D2 and verify that it is using a Date number format. Try changing it to a different date format (for example, Long Date). In cell D2, use the Format Cells dialog box to choose the 14-Mar-12 date format. Change the sales tax rate in cell D8 to the Percentage format. Apply the Currency format to all of column B. In cell D8, use the Increase Decimal or Decrease Decimal command to change the number of decimal places to one.
It should now display 7.5%. When you're finished, your spreadsheet should look like this.