Complete Guide to Excel 365: Using Formatting, Styles, & Themes

Excel    |    Intermediate
  • 11 videos | 1h 17m 43s
  • Includes Assessment
  • Earns a Badge
Rating 4.7 of 446 users Rating 4.7 of 446 users (446)
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 course
    Copy-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 handled
    Use 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 percentages  
    Use excel's comments feature to have threaded conversations, insert, show, hide, and delete notes and comments, and prevent metadata loss when converting notes to comments  
    Recognize 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 ranges
    Use 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 indicators  
    Create 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 rules  
    Use 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 location  
    Use built-in cell styles and workbook themes, create new styles and themes, and export a theme for use in different ms-office products
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 2m 20s
  • 11m 9s
    In this video, you will copy and 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 copied and pasted data is handled. FREE ACCESS
  • Locked
    3.  Configuring Copy-paste and AutoCorrect Options
    10m 3s
    In this video, find out how to use 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 percentages. FREE ACCESS
  • Locked
    4.  Contrasting Notes and Comments
    5m 42s
    In this video, you will use Excel's Comments feature to have threaded conversations, insert, show, hide, and delete notes and comments, and prevent metadata loss when converting notes to comments. FREE ACCESS
  • Locked
    5.  Using Excel Data Tables
    6m 48s
    After completing this video, you will be able to recognize the #SPILL! error and data tables features, such as named columns, calculated columns, and headers. You will also be able to use data tables to filter, sort, and remove duplicate data, and convert to and from traditional Excel ranges. FREE ACCESS
  • Locked
    6.  Using Conditional Formatting
    9m 26s
    In this video, you will learn how to use 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. FREE ACCESS
  • Locked
    7.  Inserting Data Bars, Color Scales, and Icon Sets
    7m 45s
    Learn how to 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 indicators. FREE ACCESS
  • Locked
    8.  Creating Custom Conditional Formatting Rules
    9m 15s
    In this video, you will learn how to create new formatting rules, vary both conditions governed by the rule and 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 rules. FREE ACCESS
  • Locked
    9.  Constructing Complex Custom Rules
    6m 10s
    In this video, learn how to use 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 location. FREE ACCESS
  • Locked
    10.  Using Styles and Themes
    7m 33s
    Learn how to use built-in cell styles and workbook themes, create new styles and themes, and export themes for use in different MS-Office products. FREE ACCESS
  • Locked
    11.  Course Summary
    1m 31s

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 Ten common tools in Excel 365
Rating 4.5 of 1331 users Rating 4.5 of 1331 users (1331)
Course Using visual elements in Excel 365
Rating 4.5 of 125 users Rating 4.5 of 125 users (125)
Course Getting started in Excel 365
Rating 4.4 of 6009 users Rating 4.4 of 6009 users (6009)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Formatting cells and ranges in Excel 365
Rating 4.6 of 1179 users Rating 4.6 of 1179 users (1179)
Course Complete Guide to Excel 365: Getting Started
Rating 4.6 of 1438 users Rating 4.6 of 1438 users (1438)
Course Complete Guide to Excel 365: Validating, Cleaning, & Performing Lookups on Data
Rating 4.6 of 538 users Rating 4.6 of 538 users (538)