Presenting Data using Conditional Formatting and Sparklines in Excel 2013 New Horizons Lebanon
Price: TBA
  • Duration: 1 Hour

Course details

Excel 2013 provides tools that enable you to efficiently present your data and that can also make your data easier to understand. Conditional formatting allows you to highlight trends and exceptions in cells or ranges of cells by presenting the identified data in a number of unique ways to make it stand out. Sparklines are small charts within a cell that provide a visual representation of data and can be used to show trends in an appealing manner. This course covers applying conditional formatting, creating custom rules, and creating basic and advanced sparklines. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.

  • apply conditional formatting to a worksheet in Excel 2013
  • decide how to apply conditional formatting to a worksheet in Excel 2013
  • create custom conditional formatting rules in Excel 2013
  • choose the best way to customize conditional formatting rules in Excel 2013
  • create a basic sparkline in Excel 2013
  • create an advanced sparkline in Excel 2013
  • decide how to create and edit sparklines in Excel 2013
Updated on 08 November, 2015

About New Horizons Lebanon

As changes in technology have accelerated, it’s become even more essential for people to master technology to be productive, invaluable employees who optimize, program and invent solutions—and even grow companies of their own. With over 300 centers in 60 countries, New Horizons is the world’s largest independent IT and Business training company. Over the past 35 years, New Horizons has delivered a full range of IT and business skills/Management training through innovative learning methods that have transformed businesses and helped over 35 million students reach their goals. New Horizons Lebanon branch was established in 1996.

See all New Horizons Lebanon courses
Courses you can instantly connect with... Do an online course on Microsoft Office starting now. See all courses

Is this the right course for you?

Rate this page

Didn't find what you were looking for ?

or