Learn how to create and apply a custom format for numbers, accounting, time and dates. Author Jen McBee demonstrates how to create a new number and date format, and will apply the custom format to existing data.
- When the built-in custom sale formats just won't do,…you'll want to create a custom format.…You can create custom formats for numbers.…I want to show you a sample set of syntax.…For numbers, you include the positive display.…Down below you'll see that positive numbers will be blue…with a comma separator for the thousands…and two decimal places.…If it's a negative number, it will be red.…Once again, with a comma separator and two decimal places.…
Zeros will show with two decimal places.…And the very last thing you'll enter is any text…that you want to show in the cell.…Notice that the text has double quotation marks…at the beginning and at the end.…And if you do include text, you'll need to include…the 'at' sign.…You can also create custom formats for times and for dates.…We're going to be working with the O three O one Custom Formats…Workbook so let's jump in and create some custom formats.…
We're looking at our internet orders for quarter one,…four, 2017.…Let's go ahead and start with our date column, column c.…
Author
Jennifer McBee
Released
5/4/2017Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc. In the managing workbooks chapter, learn how to work with templates, versions, and macros. In the formatting and layout chapter, see how to apply custom formats and styles. The advanced formula chapter covers additional functions including a nested IF. The charts and tables chapter shows how to create a new PivotChart. The course concludes with a sample exam you can use for practice.
- Using templates
- Managing versions
- Leveraging macros
- Linking to external data
- Protecting cells
- Hiding formulas
- Using advanced Fill Series options
- Creating form fields
- Using advanced functions: AND/OR, SUMIFS, AVERAGEIFS, and COUNTIFS
- Manipulating options in existing PivotCharts
Skill Level Advanced
Duration
Views
-
Introduction
-
Welcome57s
-
-
1. Microsoft Office Specialist (MOS) Expert Exam Overview
-
2. Manage and Share Workbooks
-
Create and modify templates4m 15s
-
Link to external data6m 51s
-
-
3. Apply Custom Formats and Layouts
-
Create form fields5m 1s
-
4. Create Advanced Formulas
-
Use a Nested IF function3m 54s
-
Use the AND/OR functions6m 21s
-
Use financial functions3m 24s
-
-
5. Create Advanced Charts and Tables
-
Create new PivotCharts3m 39s
-
Apply styles to PivotCharts4m 20s
-
-
6. Sample Exam
-
Conclusion
-
Next steps30s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Create and apply custom formats: Number, accounting, time, and date