MOS Excel Core E-Learning Contact Us For Dates  

Create Worksheets & Workbooks

• Create a workbook
• Import data from a delimited text file
• Add a worksheet to an existing workbook
• Copy and move a worksheet

• Change worksheet tab color
• Rename a worksheet
• Change worksheet order
• Modify page setup
• Insert and delete columns or rows
• Change workbook themes
• Adjust row height and column width
• Insert headers and footers

Navigate in Worksheets & Workbooks

• Search for data within a workbook
• Navigate to a named cell, range or workbook element
• Insert and remove hyperlinks

• Hide or unhide worksheets
• Hide or unhide columns and rows
• Customize the Quick Access toolbar
• Change workbook views
• Change window views
• Modify document properties
• Change magnification by using zoom tools
• Display formulas

Configure Worksheets & Workbooks for Distribution

• Set a print area
• Save workbooks in alternative file formats
• Print all or part of a workbook
• Set print scaling
• Display repeating row and column titles on multipage worksheets
• Inspect a workbook for hidden properties or personal information
• Inspect a workbook for accessibility issues
• Inspect a workbook for compatibility issues

• Replace data
• Cut, copy, or paste data
• Paste data by using special paste options
• Fill cells by using Auto Fill
• Insert and delete cells

Format Cells & Ranges

• Merge cells
• Modify cell alignment and indentation
• Format cells by using Format Painter
• Wrap text within cells
• Apply number formats
• Apply cell formats
• Apply cell styles

• Insert sparklines
• Outline data
• Insert subtotals
• Apply conditional formatting

Create & Manage Tables

• Create an Excel table from a cell range
• Convert a table to a cell range
• Add or remove table rows and columns

• Filter records
• Sort data by multiple columns
• Change sort order
• Remove duplicate records

Manage Table Styles & Options

• Apply styles to tables
• Configure table style options
• Insert total rows

• Insert references
• Perform calculations by using the SUM function
• Perform calculations by using MIN and MAX functions
• Perform calculations by using the COUNT function
• Perform calculations by using the AVERAGE function

Perform Conditional Operations by Using Functions

• Perform logical operations by using the IF function
• Perform logical operations by using the SUMIF function
• Perform logical operations by using the AVERAGEIF function
• Perform statistical operations by using the COUNTIF function

• Create a new chart
• Add additional data series
• Switch between rows and columns in source data
• Analyze data by using Quick Analysis

Format & Modify Text by Using Functions

• Format text by using RIGHT, LEFT, and MID functions
• Format text by using UPPER, LOWER, and PROPER functions
• Format text by using the CONCATENATE function

• Resize charts
• Add and modify chart elements
• Apply chart layouts and styles
• Move charts to a chart sheet

• Insert text boxes and shapes
• Insert images
• Modify object properties
• Add alternative text to objects for accessibility