Custom & Conditional Formatting in Excel 2010 for Windows
Excel 2010 (Windows)
| Intermediate
- 7 videos | 27m 46s
- Earns a Badge
In addition to the formats built into Excel, you can also use custom formats. Discover how to create and use custom date, time, number, and formats, and work with conditional formatting in Excel.
WHAT YOU WILL LEARN
-
Customizing your number formats
Customizing your text formats
Customizing the date & time formats
Creating conditional custom formats -
Using the conditional formatting options
Using advanced conditional formatting
Applying color to the first new entry in a list
IN THIS COURSE
-
4m 40sExcel 2010 features multiple number formats. However, there may be occasions when you need to create your own formats. Whether your value is a fraction, a currency or a telephone number, Excel can help you to display it properly. FREE ACCESS
-
4m 2sIn Excel 2010, you can also create customized text formats. You can adjust the leading dots in your cell, add context words and punctuation, and even apply colors to your data. FREE ACCESS
-
3. Customizing the date & time formats in Excel 2010 for Windows3m 3sExcel 2010 offers a wide variety of different data and time formats. As well as applying preset formats to your data, you can also create your own customized formats. You can specify exactly which data components are displayed and even adjust the units of measurement. FREE ACCESS
-
4. Creating conditional custom formats in Excel 2010 for Windows4m 10sThe format that you want to apply to your data may depend on whether a particular value meets a condition. In Excel 2010, you can create conditional formats that are applied if certain criteria are met. You can choose different formats for positive and negative values, and even set conditional value ranges. It is also possible to configure different color conditions. FREE ACCESS
-
5. Using the conditional formatting options in Excel 2010 for Windows2m 51sIn Excel 2010, you can create special formatting styles that are applied to particular cell values if they correspond to specified criteria or conditions. You can, for example, make any value within a certain data range stand out by applying a color effect. As well as being able to apply multiple formatting styles at once, you can also create your own conditional formatting rules. FREE ACCESS
-
6. Using advanced conditional formatting in Excel 2010 for Windows3m 59sIn Excel 2010 you can create advanced conditional formatting tools to create specific rules for conditional formatting. See how to create, customize and manage your conditional rules. FREE ACCESS
-
7. Applying color to the first new entry in a list in Excel 2010 for Windows5m 2sThe data that you have inserted into your Excel 2010 spreadsheet can be organized. If you want to quickly see where a new group starts and the previous one finishes, you can create a conditional formatting rule that will automatically highlight the first value in a new group. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
