Complete Guide to Excel 365: Using Formatting, Styles, & Themes
Excel Office 365 | Intermediate
- 11 videos | 1h 17m 43s
- Includes Assessment
- Earns a Badge
Conditional formatting is a significant and powerful feature in Excel. In this course, you'll begin by using some of the more straightforward types of conditional formattings, such as those based on specific values or ranking. You'll then use the more visually appealing types of conditional formatting, such as data bars, icon sets, and color scales, before advancing to more complex custom formatting rules using worksheet functions and a cell's row and column information. Additionally, you'll distinguish the purpose of notes versus comments and how to work with them both. Finally, you'll learn to use built-in styles and themes, create custom styles and themes and export them for use in other Office 365 products, such as PowerPoint, to apply a uniform look-and-feel to all your spreadsheets and presentations.
WHAT YOU WILL LEARN
discover the key concepts covered in this coursecopy-paste formulas with relative cell references, use the Insert Function menu to see built-in worksheet functions, arguments, and results, and use the AutoFill options to control how copy-pasted data is handleduse keyboard shortcuts to insert line breaks and the date and time into a cell, set default fill behavior when copy-pasting dates and times, customize AutoCorrect options to control workbook proofing, extend built-in AutoCorrect rules to expand acronyms automatically, and work with fractions and percentagesuse Excel's Comments feature to have threaded conversations, insert, show, hide, and delete notes and comments, and prevent metadata loss when converting notes to commentsrecognize the #SPILL! error and data tables features, such as named columns, calculated columns, and headers, use data tables to filter, sort, and remove duplicate data, and convert to and from traditional Excel rangesuse the Conditional Formatting menu item to highlight cells based on rules, use relational operators (greater than, less than, between) and text and date filters, and visualize data properties by highlighting duplicates, top-N, bottom-N, above-average, and below-average values
use data bars, color scales, and icon sets to create visually appealing, conditionally formatted spreadsheets, and depict directional data using arrows, shapes, ratings, and OK-Warning-Error indicatorscreate new formatting rules and vary both conditions governed by the rule as well as precise formatting aspects, highlight outliers that lie a certain number of standard deviations from the mean, highlight unique and duplicate values, use the Find & Select menu item to locate all cells governed by conditional formatting rules, and clear conditional formatting rulesuse formulas to determine which cells will be governed by a conditional formatting rule, the logical OR function to construct a boolean predicate to highlight weekends in a range of dates, and the ROW() function to alter highlighting based on cell locationuse built-in cell styles and workbook themes, create new styles and themes, and export a theme for use in different MS-Office productssummarize the key concepts covered in this course
IN THIS COURSE
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.
YOU MIGHT ALSO LIKE
Course Managing macros in Excel 365
PEOPLE WHO VIEWED THIS ALSO VIEWED THESE
Course Getting started in Excel 365