Learn how to create, edit and apply custom styles. Author Jen McBee demonstrates how to create a custom cell style, how to edit an existing cell tyles, and how to apply the styles to existing data.
- There are some great themes built into Excel 2013.…And these themes has colors, font sets, and effects…that can quickly be applied just by selecting a theme.…But did you know that you can…create your own custom themes?…In this video, I'll show you how to…create a custom color scheme.…As well as, a custom font set.…I'll also show you how you can…create and edit custom styles for your cells.…We're going to be using the 0303 Custom Styles Workbook.…So, let's go ahead and create some styles.…
Your themes are listed under your page layout tab,…over on the left-hand side.…And using the dropdown menu,…I can see all of the themes that are available to me.…During the exam, you may be asked…to apply a specific theme.…So, become familiar with all of the themes and the names.…So that you can find them easily.…For this demonstration,…we'll just use the Office theme.…Now, as I mentioned, each theme has colors, fonts,…and effects that are applied when you select a theme.…Let's go ahead and go to colors.…And you can see that the Office theme…
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 styles