Advanced Formats and Layouts in Excel 2013

Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Expert level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification

Prerequisite
Please contact us for information about prerequisites.

Expected Duration
60 minutes

Description
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-427: Excel 2013 Expert Part One, and Exam 77-428: Excel 2013 Expert Part Two, which certifies individuals as Microsoft Office Specialist (MOS): Excel Expert 2013.

Objective

Custom Data Formats and Fill Series

  • 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

Custom Cell Styles, Forms, and Templates

  • apply custom styles in Excel 2013
  • add form fields to a workbook and create a template 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

Advanced Conditional Formatting

  • apply advanced conditional formatting in Excel 2013
  • apply advanced conditional formatting in Excel 2013
  • decide how to apply advanced conditional formatting and filtering in Excel 2013

Accessibility and Internationalization

  • check for accessibility issues in Excel 2013
  • decide how to provide accessibility in a workbook in Excel 2013

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.