Auburn School District



Objective Domain: MOS Excel 20131.0 Create and Manage Worksheets and Workbooks1.1 Create Worksheets and Workbooks?This objective may include but is not limited to: creating new blank workbooks, creating new workbooks using templates, importing files, opening non-native files directly in Excel, adding worksheets to existing workbooks, copying and moving worksheets1.2 Navigate through Worksheets and Workbooks?This objective may include but is not limited to: searching for data within a workbook, inserting hyperlinks, changing worksheet order, using Go To, using Name Box1.3 Format Worksheets and Workbooks?This objective may include but is not limited to: changing worksheet tab color, modifying page setup, inserting and deleting columns and rows, changing workbook themes, adjusting row height and column width, inserting watermarks, inserting headers and footers, setting data validation1.4 Customize Options and Views for Worksheets and Workbooks?This objective may include but is not limited to: hiding worksheets, hiding columns and rows, customizing the Quick Access toolbar, customizing the Ribbon, managing macro security, changing workbook views, recording simple macros, adding values to workbook properties, using zoom, displaying formulas, freezing panes, assigning shortcut keys, splitting the window1.5 Configure Worksheets and Workbooks to Print or Save?This objective may include but is not limited to: setting a print area, saving workbooks in alternate file formats, printing individual worksheets, setting print scaling, repeating headers and footers, maintaining backward compatibility, configuring workbooks to print, saving files to remote locations2.0 Create Cells and Ranges2.1 Insert Data in Cells and Ranges?This objective may include but is not limited to: appending data to worksheets, finding and replacing data, copying and pasting data, using AutoFill tool, expanding data across columns, inserting and deleting cells2.2 Format Cells and Ranges?This objective may include but is not limited to: merging cells, modifying cell alignment and indentation, changing font and font styles, using Format Painter, wrapping text within cells, applying Number formats, applying highlighting, applying cell styles, changing text to WordArt2.3 Order and Group Cells and Ranges?This objective may include but is not limited to: applying conditional formatting, inserting sparklines, transposing columns and rows, creating named ranges, creating outlines, collapsing groups of data in outlines, inserting subtotals3.0 Create Tables3.1 Create a Table?This objective may include but is not limited to: moving between tables and ranges, adding and removing cells within tables, defining titles3.2 Modify a Table?This objective may include but is not limited to: applying styles to tables, banding rows and columns, inserting total rows, removing styles from tables3.3 Filter and Sort a Table?This objective may include but is not limited to: filtering records, sorting data on multiple columns, changing sort order, removing duplicates4.0 Apply Formulas and Functions4.1 Utilize Cell Ranges and References in Formulas and Functions?This objective may include but is not limited to: utilizing references (relative, mixed, absolute), defining order of operations, referencing cell ranges in formulas4.2 Summarize Data with Functions?This objective may include but is not limited to: utilizing the SUM function, utilizing the MIN and MAX functions, utilizing the COUNT function, utilizing the AVERAGE function4.3 Utilize Conditional Logic in Functions?This objective may include but is not limited to: utilizing the SUMIF function, utilizing the AVERAGEIF function, utilizing the COUNTIF function4.4 Format and Modify Text with Functions?This objective may include but is not limited to: utilizing the RIGHT, LEFT and MID functions, utilizing the TRIM function, utilizing the UPPER and LOWER functions, utilizing the CONCATENATE function5.0 Create Charts and Objects5.1 Insert and Format Building Blocks?This objective may include but is not limited to: creating charts and graphs, adding additional data series, switching between rows and columns in source data, using Quick Analysis5.2 Format a Chart?This objective may include but is not limited to: adding legends, resizing charts and graphs, modifying chart and graph parameters, applying chart layouts and styles, positioning charts and graphs5.3 Insert and Format an Object?This objective may include but is not limited to: inserting text boxes, inserting SmartArt, inserting images, adding borders to objects, adding styles and effects to objects, changing object colors, modifying object properties, positioning objectsObjective Domain: MOS PowerPoint 20131.0 Create and Manage Presentations1.1 Create a Presentation?This objective may include but is not limited to: creating blank presentations, creating presentations using templates, importing text files into presentations, importing Word document outlines into presentations1.2 Format a Presentation Using Slide Masters?This objective may include but is not limited to: applying a slide master, adding new layouts, modifying existing layouts, adding background images, controlling slide numbers, inserting headers and footers, modifying presentation themes1.3 Customize Presentation Options and Views?This objective may include but is not limited to: changing page setup options, changing to view in color/grayscale, using views to navigate through presentations, modifying presentation properties1.4 Configure Presentations to Print or Save?This objective may include but is not limited to: setting handout print options, printing selections from presentations, packaging presentations for CD, saving presentations as XML, printing presentations in grayscale, printing speaker notes, maintaining backward compatibility1.5 Configure and Present Slideshows?This objective may include but is not limited to: creating custom slideshows, configuring slideshow options, rehearsing timing, configuring resolution, using Presenter View, navigating within slideshows, annotating slideshows2.0 Insert and Format Shapes and Slides2.1 Insert and Format Slides?This objective may include but is not limited to: adding slides layouts, duplicating existing slides, hiding slides, deleting slides, modifying slide backgrounds, applying styles to slides2.2 Insert and Format Shapes?This objective may include but is not limited to: modifying shape backgrounds, applying borders to shapes, resizing shapes, inserting shapes, creating custom shapes, applying styles to shapes2.3 Order and Group Shapes and Slides?This objective may include but is not limited to: inserting section headers, modifying slide order, aligning and grouping shapes, displaying gridlines3.0 Create Slide Content3.1 Insert and Format Text?This objective may include but is not limited to: changing text to WordArt, creating multiple columns in a single shape, inserting hyperlinks, applying formatting and styles to text, creating bulleted and numbered listss3.2 Insert and Format Tables?This objective may include but is not limited to: creating new tables, modifying number of rows and columns, applying table styles, importing tables from external sources3.3 Insert and Format Charts?This objective may include but is not limited to: creating and modifying chart styles, inserting charts, modifying chart type, adding legends to charts, modifying chart parameters, importing charts from external sources3.4 Insert and Format SmartArt?This objective may include but is not limited to: adding shapes to SmartArt, changing color of SmartArt, moving text within SmartArt shapes, reversing direction, converting lists to SmartArt3.5 Insert and Format Images?This objective may include but is not limited to: resizing images, cropping images, applying effects, applying styles3.6 Insert and Format Media?This objective may include but is not limited to: adjusting media window size, trimming timing on media clips, setting start/stop times, setting media options, linking to external media4.0 Apply Transitions and Animations4.1 Apply Transitions between Slides?This objective may include but is not limited to: inserting transitions between slides, managing multiple transitions, modifying transition effect options4.2 Animate Slide Content?This objective may include but is not limited to: applying animations to shapes, applying animations to text strings, adding paths to animations, modifying animation options4.3 Set Timing for Transitions and Animations?This objective may include but is not limited to: modifying duration of effects, configuring start and finish options, reordering animations, using the Animation Pane5.0 Manage Multiple Presentations5.1 Merge Content from Multiple Presentations?This objective may include but is not limited to: merging multiple presentations, reusing slides from other presentations, viewing multiple presentations5.2 Review Changes?This objective may include but is not limited to: using the Reviewing Pane, comparing revisions, managing changes, managing comments5.3 Protect and Share Presentations?This objective may include but is not limited to: encrypting presentations with a password, proofing presentations, marking as final, compressing media, embedding fonts, restricting permissions, removing presentation metadata, checking for accessibility issues, checking for compatibility issuesObjective Domain: MOS Outlook 20131.0 Manage the Outlook Environment1.1 Customize Outlook Settings?This objective may include but is not limited to: including original messages with all reply messages, changing text formats for all outgoing messages, customizing the Navigation Pane, blocking specific addresses, configuring views, managing multiple accounts, setting Outlook options1.2 Automate Outlook?This objective may include but is not limited to: changing quoted text colors, creating and assigning signatures, using Quick Steps, creating and managing rules, creating auto- replies1.3 Print and Save Information in Outlook?This objective may include but is not limited to: printing messages, printing calendars, saving message attachments, previewing attachments, printing contacts, printing tasks, saving messages in alternate formats, creating data files1.4 Search in Outlook?This objective may include but is not limited to: creating new search folders, searching for messages, searching for tasks, searching for contacts, searching calendars, using advanced find, using Search by Location2.0 Manage Messages2.1 Create a Message?This objective may include but is not limited to: creating messages, forwarding messages, deleting messages, adding/removing message attachments, adding cc and bcc to messages, adding voting options to messages, replying to all, replying to sender only, prioritizing messages, marking as private, requesting delivery/read receipt, redirecting replies, delegating access2.2 Format a Message?This objective may include but is not limited to: formatting text, inserting hyperlinks, applying themes and styles, inserting images, adding a signature to specific messages, formatting signatures, creating and using Quick Parts2.3 Organize and Manage Messages?This objective may include but is not limited to: sorting messages, moving messages between folders, adding new local folders, applying categories, configuring junk e-mail settings, cleaning up messages, marking as read/unread, flagging messages, ignoring messages, sorting by conversation, setting attachment reminder options3.0 Manage Schedules3.1 Create and Manage Calendars?This objective may include but is not limited to: adjusting viewing details for calendars, modifying calendar time zones, deleting calendars, setting calendar work times, using multiple calendars, managing calendar groups, overlaying calendars, sharing calendars3.2 Create Appointments, Meetings and Events?This objective may include but is not limited to: creating calendar items, creating recurring calendar items, cancelling calendar items, creating calendar items from messages, setting calendar item times, categorizing calendar items, using the scheduling assistant, changing availability status, scheduling resources, utilizing Room Finder3.3 Organize and Manage Appointments, Meetings, and Events?This objective may include but is not limited to: setting calendar item importance, forwarding calendar items, configuring reminders, adding participants, responding to invitations, updating calendar items, sharing meeting notes3.4 Create and Manage Notes, Tasks, and Journals?This objective may include but is not limited to: creating and managing tasks, creating and managing notes, attaching notes to contacts, creating journal entries, updating task status4.0 Manage Contacts and Groups4.1 Create and Manage Contacts?This objective may include but is not limited to: creating new contacts, deleting contacts, importing contacts from external sources, editing contact information, attaching an image to contacts, adding tags to contacts, sharing contacts, managing multiple address books4.2 Create and Manage Groups?This objective may include but is not limited to: creating new contact groups, adding contacts to existing groups, adding notes to a group, updating contacts within groups, deleting groups, deleting group membersObjective Domain: MOS OneNote 20131.0 Manage the OneNote Environment1.1 Manage Page Layout?This objective may include, but is not limited to: combining and rearranging containers, collapsing and expanding paragraphs and lists, inserting background images, working with templates, setting Page layout options1.2 Configure OneNote Backstage?This objective may include, but is not limited to: configuring Notebook settings and properties, pinning notebooks to lists1.3 Create a OneNote Notebook?This objective may include, but is not limited to: creating new notebooks, creating notebooks on SkyDrive, creating notebooks on a network, creating local notebooks1.4 Personalize OneNote?This objective may include, but is not limited to: setting default fonts and sizes, changing display settings, managing Proofing and Language settings, setting Research and Translation options, setting Page format options, customizing workspaces, customizing the Ribbon, expanding/collapsing panels2.0 Share and Collaborate with Other Users2.1 Share OneNote Notebooks?This objective may include, but is not limited to: sharing notebooks on SkyDrive, sharing notebooks on SharePoint, sharing notebooks on a network, synchronizing shared notebooks across devices2.2 Share OneNote Content via E-mail?This objective may include, but is not limited to: sending notebooks via e-mail, configuring OneNote e-mail options, inviting others to view notebooks, sending pages via e-mail in shareable formats, sending to a Blog2.3 Collaborate with other users in OneNote?This objective may include, but is not limited to: marking coauthors edits as read, viewing recent edits, finding notes by author, hiding author initials, marking notes as read or unread3.0 Organize and Find Notes3.1 Organize Notebooks?This objective may include, but is not limited to: merging sections, creating new section groups, using color to group notebooks and sections, protecting with passwords, grouping and displaying sub-pages, using Quick Notes, adding new pages3.2 Search for Content in OneNote?This objective may include, but is not limited to: searching for content across notebooks, sections, and pages, displaying search results panes, searching indexed recordings3.3 Save and Manage OneNote History and Backups?This objective may include, but is not limited to: managing page versions, managing notebook recycle bins, managing backups, saving notebooks, saving current pages, saving pages as alternate file types, converting for backwards compatibility3.4 Configure Quick Filing?This objective may include, but is not limited to: sending e-mail messages, inserting notes from Outlook (messages, meetings, contacts, and tasks), inserting Web pages, inserting screenshots, printing to OneNote, inserting media, setting default locations3.5 Create and Manage Tags?This objective may include, but is not limited to: applying tags, creating new tags, modifying existing tags, creating Tag Summary pages, configuring tag options, finding tags4.0 Edit and Link Content in OneNote4.1 Apply Links and Linked Notes?This objective may include, but is not limited to: linking Quick Notes to pages, sections, notebooks, and wikilinks, creating new docked windows, linking Quick Notes to web browsers, linking Quick Notes to Microsoft Office applications, copying links4.2 Insert Files in OneNote?This objective may include, but is not limited to: inserting links to files, embedding files, embedding a spreadsheet or Visio document4.3 Edit Text in OneNote?This objective may include, but is not limited to: using the Format Painter, using styles, managing paste options, using format options, inserting tables4.4 Insert and Modify Visual Elements?This objective may include, but is not limited to: inserting images, inserting symbols, working with the drawing tools, managing the pen optionsObjective Domain: MOS Access 20131.0 Create and Manage a Database1.1 Create a New Database?This objective may include but is not limited to: creating new databases, creating databases using templates, saving databases in older formats, creating databases using wizards1.2 Manage Relationships and Keys?This objective may include but is not limited to: editing references between tables, creating and modifying relationships, setting primary key fields, enforcing referential integrity, setting foreign keys, viewing relationships1.3 Navigate through a Database?This objective may include but is not limited to: navigating to specific records, setting a form as the startup option, using navigation forms, setting navigation options, changing views1.4 Protect and Maintain a Database?This objective may include but is not limited to: compacting databases, repairing databases, backing up databases, splitting databases, encrypting databases with a password, merging databases, recovering data from a backups1.5 Print and Export a Database?This objective may include but is not limited to: printing reports, printing records, maintaining backward compatibility, saving databases as templates, saving databases to external locations, exporting to alternate formats2.0 Build Tables2.1 Create a Table?This objective may include but is not limited to: creating new tables, importing external data into tables, creating linked tables from external sources, importing tables from others database, creating tables from templates and application parts2.2 Format a Table?This objective may include but is not limited to: hiding fields in tables, changing data formats, adding total rows, adding table descriptions, renaming tables2.3 Manage Records?This objective may include but is not limited to: updating records, adding new records, deleting records, appending records from external data, finding and replacing data, sorting records, filtering records, grouping records2.4 Create and Modify Fields?This objective may include but is not limited to: adding fields to tables, adding a validation rules to fields, changing field captions, changing field sizes, changing field data types, configuring fields to auto-increment, setting default values, using input masks, deleting fields3.0 Create Queries3.1 Create a Query?This objective may include but is not limited to: running queries, creating crosstab queries, creating parameter queries, creating action queries, creating multi-table queries, saving queries, deleting queries3.2 Modify a Query?This objective may include but is not limited to: renaming queries, adding new fields, removing fields, hiding fields, sorting data within queries, formatting fields within queries3.3 Utilize Calculated Fields and Grouping within a Query?This objective may include but is not limited to: adding calculated fields, adding conditional logic, grouping and summarizing data, using comparison operators, using basic operators4.0 Create Forms4.1 Create a Form?This objective may include but is not limited to: creating new forms, creating forms with application parts, saving forms, deleting forms4.2 Set Form Controls?This objective may include but is not limited to: moving form controls, adding form controls, modifying data sources, removing form controls, setting form control properties, managing labels4.3 Format a Form?This objective may include but is not limited to: modifying Tab order in forms, formatting print layouts, sorting records, applying themes, changing margins, inserting backgrounds, auto-ordering forms, inserting headers and footers, inserting images, modifying existing forms5.0 Create Reports5.1 Create a Report?This objective may include but is not limited to: creating new reports, creating reports with application parts, deleting reports5.2 Set Report Controls?This objective may include but is not limited to: grouping data by fields, sorting data, adding sub-reports, modifying data sources, adding report controls, managing labels5.3 Format a Report?This objective may include but is not limited to: formatting reports into multiple columns, adding calculated fields, setting margins, adding backgrounds, changing report orientation, changing sort order, inserting headers and footers, inserting images, inserting page numbers, applying themes, modifying exiting reportsObjective Domain: MOS SharePoint 20131.0 Create and Format Content1.1 Navigate the SharePoint Hierarchy?This objective may include but is not limited to: using Quick Launch, using All Site Content, using breadcrumb trails, adding content to Quick Launch, using Content and Structure for navigation1.2 Manage Lists and Libraries?This objective may include but is not limited to: creating lists or libraries, editing properties for new items, enabling email notifications on lists or libraries, providing shortcuts to a mobile site URL, managing document templates, managing list views, creating alerts on lists or libraries, using ratings, adding columns, adding content validation, managing column properties1.3 Manage List Items?This objective may include but is not limited to: creating new list items, editing content, deleting list items or documents, versioning list items, publishing assets, managing existing workflows, uploading documents, creating and managing announcements, collaborating with Microsoft Office assets (calendars, spreadsheets, web apps)1.4 Manage Document Sets?This objective may include but is not limited to: adding documents to document sets, creating document sets, activating and deactivating document sets2.0 Manage SharePoint Sites2.1 Manage Pages?This objective may include but is not limited to: creating new site pages, using templates, editing and deleting existing site pages2.2 Perform Administrative Tasks on Sites and Workspaces?This objective may include but is not limited to: creating new sites or workspaces using templates, configuring site or workspace structures, configuring the Content Organizer, displaying a list of all user alerts, modifying Look and Feel, recovering assets (lists, libraries, documents, list items), using document and meeting workspaces, viewing site web analytics, viewing detailed reports2.3 Manage Web Parts on a Page?This objective may include but is not limited to: adding Web Parts, configuring Web Parts, hiding or removing Web Parts, exporting or importing Web Parts2.4 Manage Content Types?This objective may include but is not limited to: associating content types to lists, extending the columns of content types, creating custom content types2.5 Manage Users and Groups?This objective may include but is not limited to: creating groups, managing groups, managing user access, managing group permissions3.0 Participate in User Communities3.1 Configure My Site?This objective may include but is not limited to: adding keywords, adding colleagues, selecting themes, configuring the Colleague Tracker Web Part, configuring RSS feeds, configuring My Profile3.2 Collaborate through My Site?This objective may include but is not limited to: updating profile status, sharing pictures in My Site, managing personal documents, sharing documents in My Site, browsing the organization hierarchy, adding Web Parts to My Site3.3 Add Tags and Notes to Content?This objective may include but is not limited to: adding notes to the Note Board for lists or libraries, adding tags for lists or libraries, rating items, using tag clouds, reviewing tags on My Site4.0 Configure and Consume Site Search Results4.1 Perform Search Administration at the Site Level?This objective may include but is not limited to: configuring searchable columns, configuring list searches, configuring site search visibility4.2 View Search Results?This objective may include but is not limited to: browsing search results, using Best Bet results, using the Refinement Panel, using alerts and RSS feeds with search results, previewing documents4.3 Perform Advanced Searches?This objective may include but is not limited to: using Boolean operators in searches, using wild cards in searches, using property searches, using phonetic searches, using People Search, using advanced searchesObjective Domain: MOS Word 20131.0 Create and Manage Documents1.1 Create a Document?This objective may include but is not limited to: creating new blank documents, creating new documents using templates, opening non-native files directly in Word, opening a PDF in Word for editing1.2 Navigate through a Document?This objective may include but is not limited to: searching for text within document, inserting hyperlinks, creating bookmarks, using Go To1.3 Format a Document?This objective may include but is not limited to: modifying page setup, changing document themes, changing document style sets, inserting simple headers and footers, inserting watermarks, inserting page numbers1.4 Customize Options and Views for Documents?This objective may include but is not limited to: changing document views, using zoom, customizing the Quick Access toolbar, customizing the Ribbon, splitting the window, adding values to document properties, using Show/Hide, recording simple macros, assigning shortcut keys, managing macro security1.5 Configure Documents to Print or Save?This objective may include but is not limited to: configuring documents to print, saving documents in alternate file formats, printing document sections, saving files to remote locations, protecting documents with passwords, setting print scaling, maintaining backward compatibility2.0 Format Text, Paragraphs, and Sections2.1 Insert Text and Paragraphs?This objective may include but is not limited to: adding text to documents, finding and replacing text, copying and pasting text, inserting text via AutoCorrect, removing blank paragraphs, inserting built-in fields, inserting special characters (?, ?, ?)2.2 Navigate through a Document?This objective may include but is not limited to: changing font attributes, using Find and Replace to format text, using Format Painter, setting paragraph spacing, setting line spacing, clearing existing formatting, setting indentation, highlighting text selections, adding styles to text, changing text to WordArt, modifying existing style attributes2.3 Order and Group Text and Paragraphs?This objective may include but is not limited to: preventing paragraph orphans, inserting breaks to create sections, using multiple columns to organize content, using headings to organize content (outline), forcing page breaks3.0 Create Tables and Lists3.1 Create a Table?This objective may include but is not limited to: converting text to tables, converting tables to text, defining table dimensions, setting AutoFit options, using Quick Tables, using headings for table rows and columns3.2 Modify a Table?This objective may include but is not limited to: applying styles to tables, modifying fonts within tables, sorting table data, configuring cell margins, using formulas, modifying table dimensions, merging cells3.3 Create and Modify a List?This objective may include but is not limited to: adding numbering or bullets, creating custom bullets, modifying list indentation, modifying line spacing, increasing and decreasing list levels, modifying numbering4.0 Apply References4.1 Create Endnotes, Footnotes, and Citations?This objective may include but is not limited to: inserting endnotes, managing footnote locations, configuring endnote formats, modifying footnote numbering, inserting citation placeholders, inserting citations, inserting bibliography, changing citation styles4.2 Create Captions?This objective may include but is not limited to: adding captions, setting caption positions, changing caption formats, changing caption labels, excluding labels from captions5.0 Insert and Format Objects5.1 Insert and Format Building Blocks?This objective may include but is not limited to: inserting Quick Parts, inserting textboxes, utilizing Building Blocks Organizer, customizing building blocks5.2 Insert and Format Shapes and SmartArt?This objective may include but is not limited to: inserting simple shapes, inserting SmartArt, modifying SmartArt properties (color, size, shape), wrapping text around shapes, positioning shapes5.3 Insert and Format Images?This objective may include but is not limited to: inserting images, applying artistic effects, applying picture effects, modifying image properties (color, size, shape), adding Quick Styles to images, wrapping text around images, positioning imagesMOS Word Expert 2013 – Part 1MOS Word Expert 2013 – Part 2180975609600Objective Domain: MOS Excel Expert Part 11.0 Manage and Share WorkbooksManage Workbook ChangesThis objective may include but is not limited to: tracking changes, managing comments, identifying errors, troubleshooting with tracing, displaying all changes, retaining all changes2.0 Apply Custom Formats and Layouts2.2 Apply Advanced Conditional Formatting and FilteringThis objective may include but is not limited to: writing custom conditional formats, using functions to format cells, creating advanced filters, managing conditional formatting rules2.4 Prepare a Workbook for Internationalization and AccessibilityThis objective may include but is not limited to: modifying Tab order among workbook elements and objects, displaying data in multiple international formats, modifying worksheets for use with accessibility tools, utilizing international symbols, managing multiple options for +Body and +Heading fonts3.0 Create Advanced Formulas3.2 Look Up Data with FunctionsThis objective may include but is not limited to: utilizing the LOOKUP function, utilizing the VLOOKUP function, utilizing the HLOOKUP function, utilizing the TRANSPOSE function3.3 Apply Advanced Date and Time FunctionsThis objective may include but is not limited to: utilizing the NOW and TODAY functions, using functions to serialize dates and times4.0 Create Advanced Charts and TablesCreate Advanced Chart ElementsThis objective may include but is not limited to: adding trendlines to charts, creating dual axis charts, creating custom chart templates, viewing chart animations4.2 Create and Manage PivotTablesThis objective may include but is not limited to: creating new PivotTables, modifying field selections and options, creating a slicer, grouping records, utilizing calculated fields, formatting data, utilizing PowerPivot, managing relationshipsObjective Domain: MOS Excel Expert Part 21.0 Manage and Share Workbooks1.1 Manage Multiple WorkbooksThis objective may include but is not limited to: modifying existing templates, merging multiple workbooks, managing versions of a workbook, copying styles from template to template, copying macros from workbook to workbook, linking to external data1.2 Prepare a Workbook for ReviewThis objective may include but is not limited to: setting tracking options, limiting editors, opening workspaces, restricting editing, controlling recalculation, protecting worksheet structure, marking as final, removing workbook metadata, encrypting workbooks with a password2.0 Apply Custom Formats and Layouts2.1 Apply Custom Data FormatsThis objective may include but is not limited to: creating custom formats (Number, Time, Date), creating custom accounting formats, using advanced Fill Series options2.3 Apply Custom Styles and TemplatesThis objective may include but is not limited to: creating custom color formats, creating and modifying cell styles, creating and modifying custom templates, creating form fields3.0 Create Advanced Formulas3.1 Apply Functions in FormulasThis objective may include but is not limited to: utilizing the IF function in conjunction with other functions, utilizing AND/OR functions, utilizing nested functions, utilizing SUMIFS, AVERAGEIFS, and COUNTIFS functions3.4 Create ScenariosThis objective may include but is not limited to: utilizing the watch window, consolidating data, enabling iterative calculations, utilizing What If analysis tools including Goal Seek, utilizing the Scenario Manager, using financial functions4.0 Create Advanced Charts and Tables4.3 Create and Manage Pivot ChartsThis objective may include but is not limited to: creating new PivotCharts, manipulating options in existing PivotCharts, applying styles to PivotCharts. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download