• Please enter your name and surname above
  • Please enter your company name above
  • Section 1: Managing The Worksheet Environment

    This objective may include but is not limited to: printing only selected worksheets, printing an entire workbook, constructing headers and footers, and applying printing options (scale, print titles, page setup, print area, gridlines).
    This objective may include but is not limited to: Manipulate the Quick Access Toolbar, manipulate the ribbon tabs and groups, manipulate Excel default settings, import data to Excel, import data from Excel, demonstrate how to manipulate workbook properties, manipulate workbook files and folders. apply different name and file formats for different uses by using save and save as features.
  • Section 2: Creating Cell Data

    This objective may include but is not limited to: using paste special (formats, formulas, values, preview icons, transpose rows and columns, operations, comments, validation, paste as a link), and cutting, moving, and select cell data
    This objective may include but is not limited to: Copy data using AutoFill, fill series using AutoFill, copy or preserve cell format with AutoFill, select from drop-down list.
    This objective may include but is not limited to: Create a hyperlink in a cell, modify hyperlinks, modify hyperlinked-cell attributes, remove a hyperlink.
  • Section 3: Formatting Cells and Worksheets

    This objective may include but is not limited to: aligning cell content, applying a number format, wrapping text in a cell, and using Format Painter.
    This objective may include but is not limited to: using Merge & Center, Merge Across, Merge cells, and Unmerge Cells.
    This objective may include but is not limited to: Print row and column headings, print rows to repeat with titles, print columns to repeat with titles, configure titles to print only on odd or even pages, configure titles to skip the first worksheet page.
    This objective may include but is not limited to: Hide a column, unhide a column, hide a series of columns, hide a row, unhide a row, hide a series of rows.
    This objective may include but is not limited to: Configure page orientation, manage page scaling, configure page margins, change header and footer size.
    This objective may include but is not limited to: Apply cell styles, construct new cell styles.
  • Section 4: Managing Worksheets and Workbooks

    This objective may include but is not limited to: Insert worksheets, delete worksheets, copy, reposition, copy and move, rename, grouping, apply coloring to worksheet tabs, hiding worksheet tabs, unhiding worksheet tabs.
    This objective may include but is not limited to: splitting window views, arranging window views, and opening a new window with contents from the current worksheet.
    This objective may include but is not limited to: using Normal, Page Layout, and Page Break workbook views, and creating custom views.
  • Section 5: Applying Formulas and Functions

    This objective may include but is not limited to: Use basic operators, revise formulas.
    This objective may include but is not limited to: Order of evaluation, precedence using parentheses, precedence of operators for percent vs. exponentiation.
    This objective may include but is not limited to: Relative, absolute.
    This objective may include but is not limited to: Create a formula with values that match your conditions, edit defined conditions in a formula, use a series of conditional logic values in a formula.
    This objective may include but is not limited to: Define, edit and rename a named range.
    This objective may include but is not limited to: Enter a cell range definition in the formula bar, define a cell range using the mouse, define a cell range using a keyboard shortcut.
  • Section 6: Presenting Data Visually

    This objective may include but is not limited to: Clip Art, SmartArt, shapes, screenshots.
    This objective may include but is not limited to: making corrections to an image (sharpen or soften an image, changing brightness and contrast), using picture color tools, and changing artistic effects on an image.
    This objective may include but is not limited to: using Line, Column, and Win/Loss chart types, creating a Sparkline chart, customizing a Sparkline, formatting a Sparkline, and showing or hiding data markers.
  • Section 7: Sharing worksheet data with other users

    This objective may include but is not limited to: sending a worksheet via E-mail or Skydrive, changing the file type to a different version of Excel, and saving as PDF or XPS.
    This objective may include but is not limited to: inserting, viewing, editing, and deleting comments.
  • Section 8: Analyzing and Organizing Data

    This objective may include but is not limited to: Define, apply, remove, search, filter lists using AutoFilter.
    This objective may include but is not limited to: using sort options (values, font color, cell color).
    This objective may include but is not limited to: Apply conditional formatting to cells, use the Rule Manager to Apply Conditional Formats, use the IF Function and Apply Conditional Formatting, icon sets, data bars, clear rules.