Microsoft Office Specialist Excel Certification| Microsoft Excel Training | MOS Excel | Excel Certification

Authorized Training and Certification/Testing centre

MOS: Microsoft Office Excel Associate

Course Description

Syllabus work in Progress.................................

Course Curriculum: MOS: Microsoft Office Excel Associate

Prerequisites

(Click to find out more) +–

No Requirements

Course context

140 Lectures

00 : 00 : 00

+

Syllabus work in Progress

1 Lectures 00 : 00 : 00

Syllabus work in Progress

+

Introducing Excel..

20 Lectures 00 : 00 : 00

What is Excel?..

Understanding Basic Terminology

Mouse Symbols

Using the Quick Access Toolbar

Using the Ribbon

Identifying Screen Symbols

Entering Data in a Worksheet..

Types of Data

Entering Text

Entering Numbers

Entering Dates and Times

Moving Around the Worksheet

Working with Workbooks..

Saving Workbooks

Creating a New Workbook

Switching Between Workbooks

Opening a Workbook

Closing a Workbook

Working with the Compatibility Mode

Selecting Cells

+

Constructing Cell Data

21 Lectures 00 : 00 : 00

Editing Cells and Undoing Changes

Copying and Moving Data..

Cutting, Copying and Pasting Data

Using Paste Special

Copying and Moving Cells Using the Mouse

Inserting and Deleting Rows and Columns

Inserting Rows and Columns

Deleting Rows and Columns

Inserting and Deleting Cells

Adjusting the Columns and Rows

Changing the Column Widths

Adjusting the Row Height

Using AutoFit

Hiding/Unhiding Rows & Columns

Using AutoFill and Flash Fill

Managing Worksheets..

Renaming Worksheets

Inserting or Deleting Worksheets

Moving or Copying Worksheets

Hiding/Unhiding Worksheets

Adding Color to Worksheet Tabs

+

Using Formulas

17 Lectures 00 : 00 : 00

Using Formulas..

Creating and Editing Formulas

Cell References

Mathematical Operators

What-If Analysis

Referencing Other Worksheets

Using Math and Statistical Functions..

Using the SUM Function

Using Statistical Functions

Using the Subtotal Function

Using the IF Function

Using Conditional Summary Functions

Using Text Functions

Using Absolute and Relative Cell References

Using Absolute Cell References

Using Mixed Absolute and Relative Cell References

Displaying Formulas

+

Formatting the Worksheet

18 Lectures 00 : 00 : 00

Formatting a Cell..

Formatting Numbers and Decimal Digits

Changing Cell Alignment..

Cell Alignment and Indenting Wrapping Text

Merging Cells

Changing Fonts and Sizes

Applying Cell Borders

Applying Cell Borders

Using Colors and Patterns

Using the Format Painter

Clearing Cell Contents and Formatting

Themes..

Using Themes

Modifying Themes

Using Cell Styles

Conditional Formatting..

Using the Ribbon

Using the Rules Manager

+

Viewing and Printing Workbooks

13 Lectures 00 : 00 : 00

Changing Worksheet Views

Creating and Arranging Worksheet Windows

Splitting Panes

Freezing Panes

Changing the Zoom

Printing and Previewing the Workbook

Changing the Workbook Views

Customizing the Page Layout

Setting Page Breaks

Page Formatting

Adding a Header or Footer

Printing Titles and Ranges of Cells

Printing Selected Worksheets

+

Working with Charts and Graphics

18 Lectures 00 : 00 : 00

Creating a Basic Chart

Moving and Resizing Charts

Changing Chart Types

Working with Pie Charts

Modifying the Chart Design and Location..

Adding New Data

Using Sparklines

Printing Charts

Using the Quick Analysis Tool

Drawing Shapes..

Moving and Resizing Shapes

Formatting Shapes

Inserting Pictures

Using the Image Editor

Modifying Graphics Objects

Using the Format Shape Pane

Resizing, Reshaping, and Scaling Graphics Objects

Rotating Graphics Objects

+

Organizing Data

17 Lectures 00 : 00 : 00

Working with Named Ranges

Creating Named Ranges

Modifying and Deleting Named Ranges

Go To a Cell or Named Range

Using Tables ..

Creating a Table

Modifying Table Data

Formatting Table Data

Converting a Table to a Cell Range

Sorting Data

Sorting by Single -Level Data

Sorting by Multi -Level Data

Filtering Information

Removing Duplicate Rows

Outlining

Using Automatic Subtotals

Manually Grouping and Ungrouping Data

+

Using Data Tools

15 Lectures 00 : 00 : 00

Customizing Excel..

Customizing the Quick Access Toolbar

Finding and Replacing Data..

Finding Data

Replacing Data

Using Hyperlinks..

Inserting Hyperlinks

Modifying and Deleting Hyperlinks

Importing and Exporting Data..

Importing Data Files from External Text Files

Importing Data from External CSV File s

Exporting Excel Data as CSV

Accessing Workbook Properties

Using the Document Inspector

Using the Accessibility Checker Tool