Custom & Conditional Formatting in Excel 2016 for Mac

Excel 2016 (Mac)    |    Intermediate
  • 6 videos | 25m 51s
  • Earns a Badge
Rating 4.7 of 6 users Rating 4.7 of 6 users (6)
In addition to the formats built into Excel, you can also use custom formats. Learn to create and use custom date, time, number, and text formats, and work with the conditional formatting tools in Excel.

WHAT YOU WILL LEARN

  • Customize date and time formats in excel 2016 for mac
    Create and customize number formats in excel 2016 for mac
    Use custom text formats in excel 2016 for mac
  • Create conditional custom formats in excel 2016 for mac
    Use conditional formatting tools in excel 2016 for mac
    Create and use advanced conditional formatting tools

IN THIS COURSE

  • 3m 53s
    Excel 2016 for Mac offers a wide variety of different date and time formats. As well as applying preset formats to your date, 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
  • 4m 38s
    Excel 2016 for Mac 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
  • Locked
    3.  Using custom text formats in Excel 2016 for Mac
    4m 44s
    In Excel 2016 for Mac, 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
  • Locked
    4.  Creating conditional custom formats in Excel 2016 for Mac
    4m 8s
    The format that you want to apply to your data may depend on whether a particular value meets a condition. In Excel 2016 for Mac, you can create conditional formats that will be automatically applied if certain criteria are met. You can choose different formats for positive and negative values, and even set conditional value ranges. FREE ACCESS
  • Locked
    5.  Using conditional formatting tools in Excel 2016 for Mac
    4m 21s
    In Excel 2016 for Mac, 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
  • Locked
    6.  Using advanced conditional formatting in Excel 2016 for Mac
    4m 7s
    In Excel 2016 for Mac, you can create advanced conditional formatting tools to create specific rules for conditional formatting. 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.

YOU MIGHT ALSO LIKE

Course Using fields, forms and macros in Word Microsoft 365 (2021)
Rating 4.5 of 25 users Rating 4.5 of 25 users (25)
Course Custom & Conditional Formatting in Excel 2019 for Windows
Rating 4.4 of 355 users Rating 4.4 of 355 users (355)
Course Formatting data in Google Sheets 2022
Rating 4.6 of 25 users Rating 4.6 of 25 users (25)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Performing data analysis and forecasting in Excel 365
Rating 4.5 of 319 users Rating 4.5 of 319 users (319)
Course Customizing text & number formats in Excel 365
Rating 4.5 of 310 users Rating 4.5 of 310 users (310)
Course Complete Guide to Excel 365: Pivot, PowerPivot, & Financial Modeling
Rating 4.5 of 353 users Rating 4.5 of 353 users (353)