Advanced Formats and Layouts in Excel 2013 New Horizons Lebanon
Price: TBA
  • Duration: 1 Hour

Course details

Excel 2013 provides many advanced features to customize formats and layouts. Data can be customized to any format and adding a customized fill series can not only save you time, but help ensure consistency and accuracy in your work. Customizing cells, adding forms, and creating templates all help tailor your workbooks to your individual needs. Conditional formatting can also format ranges according to specific criteria. Finally, Excel provides tools to help create workbooks that are accessible and consider international audiences. This course will help prepare learners for the Microsoft Certification Exam 77-421: Excel 2013 Expert which certifies individuals as Microsoft Office Specialist (MOS): Excel Expert 2013.

  • create a custom data format in Excel 2013
  • create a custom fill series in Excel 2013
  • decide how to create a custom data format and fill series in Excel 2013
  • apply custom styles in Excel 2013
  • add form fields to a workbook and create a template in Excel 2013
  • choose how to create a custom cell style and form control in Excel 2013
  • apply advanced conditional formatting in Excel 2013
  • decide how to apply advanced conditional formatting and filtering in Excel 2013
  • check for accessibility issues in Excel 2013
  • decide how to provide accessibility in a workbook 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