Apply Custom Styles and Templates Creating custom color formats EX 74 Creating and modifying cell styles EX D2-EX D4 Creating and modifying custom templates EX 376-EX 379 Creating form fields EX 450 Prepare a Workbook for Internationalization and Accessibility Displaying data in multiple international formats EX 768-EX 772 Modifying worksheets for use with accessibility EX 752 tools Utilizing international symbols EX 771 Managing multiple options for +Body and +Heading EX D26 fonts Create Advanced Formulas Apply Functions in Formulas Utilizing the IF function in conjunction with other EX 173, EX 467-EX 472, EX 477-EX 480 functions Utilizing AND/OR functions EX 470-EX 477 Utilizing nested functions EX 472, EX 477-EX 480, EX 484-EX 489 Utilizing SUMIFS, AVERAGEIFS, and COUNTIFS EX B13-EX B18 functions Look Up Data with Functions Utilizing the LOOKUP function EX 176-EX 179, EX 489-EX 500 Utilizing the VLOOKUP function EX 177-EX 179, EX 490-EX 497 Utilizing the HLOOKUP function EX 497-EX 500 Utilizing the TRANSPOSE function EX 517 Apply Advanced Date and Time Functions Utilizing the NOW and TODAY functions EX 166-EX 167 Using functions to serialize dates and times EX 22, EX 86 Create Scenarios Utilizing the Watch window EX 585-EX 586 Consolidating data EX 717 Enabling iterative calculations EX 767 Utilizing What-If analysis tools including Goal Seek EX 180-EX 181, EX 601-EX 603 Utilizing the Scenario Manager EX 618-EX 625 Using financial functions EX 192-EX 197 Create Advanced Charts and Tables Create Advanced Chart Elements Adding trendlines to charts EX 221 Creating dual axis charts EX 222-EX 223 Creating custom chart templates EX 376-EX 377 Viewing chart animations EX 210-EX 211
Apply Custom Styles and Templates Creating custom color formats EX 74 Creating and modifying cell styles EX D2-EX D4 Creating and modifying custom templates EX 376-EX 379 Creating form fields EX 450 Prepare a Workbook for Internationalization and Accessibility Displaying data in multiple international formats EX 768-EX 772 Modifying worksheets for use with accessibility tools EX 752 Utilizing international symbols EX 771 Managing multiple options for +Body and +Heading fonts EX D26 Create Advanced Formulas Apply Functions in Formulas Utilizing the IF function in conjunction with other functions EX 173, EX 467-EX 472, EX 477-EX 480 Utilizing AND/OR functions EX 470-EX 477 Utilizing nested functions EX 472, EX 477-EX 480, EX 484-EX 489 Utilizing SUMIFS, AVERAGEIFS, and COUNTIFS functions EX B13-EX B18 Look Up Data with Functions Utilizing the LOOKUP function EX 176-EX 179, EX 489-EX 500 Utilizing the VLOOKUP function EX 177-EX 179, EX 490-EX 497 Utilizing the HLOOKUP function EX 497-EX 500 Utilizing the TRANSPOSE function EX 517 Apply Advanced Date and Time Functions Utilizing the NOW and TODAY functions EX 166-EX 167 Using functions to serialize dates and times EX 22, EX 86 Create Scenarios Utilizing the Watch window EX 585-EX 586 Consolidating data EX 717 Enabling iterative calculations EX 767 Utilizing What-If analysis tools including Goal Seek EX 180-EX 181, EX 601-EX 603 Utilizing the Scenario Manager EX 618-EX 625 Using financial functions EX 192-EX 197 Create Advanced Charts and Tables Create Advanced Chart Elements Adding trendlines to charts EX 221 Creating dual axis charts EX 222-EX 223 Creating custom chart templates EX 376-EX 377 Viewing chart animations EX 210-EX 211
1305501128_492519.docx