Microsoft Excel Associate Certification Training

This course provides comprehensive training on managing worksheets and workbooks, manipulating data cells and ranges, managing tables and table data, performing operations using formulas and functions, and managing charts. Participants will learn to efficiently import, format, and analyze data in Excel, enabling better data-driven decision-making.

Course Objectives

• Understand how to import and navigate data within workbooks.

• Learn to format worksheets and customize views for better data presentation.

• Gain skills in manipulating data cells and ranges, and summarizing data visually.

• Master the creation and modification of tables, and how to filter and sort table data.

• Perform various operations using Excel formulas and functions.

• Develop the ability to create, modify, and format charts for data visualization.

Prerequisites

• Basic knowledge of Microsoft Excel.

• Familiarity with fundamental spreadsheet concepts and operations.

Target Audience

This training is highly recommended for data analysts, financial analysts, business professionals who use who use Excel for data management and reporting, and anyone looking to improve their Excel skills for personal or professional use.

Course Outline

Module 1: Managing Worksheets and Workbooks

Importing and Navigating Data

• Import data from .txt and .csv files.

• Search for data and navigate to named cells, ranges, or workbook elements.

Formatting and Customizing Views

• Modify page setup, row height, column width, headers, and footers.

• Customize Quick Access toolbar, display content in different views, and freeze rows and columns.

Module 2: Managing Data Cells and Ranges

Manipulating and Formatting Data

• Paste data using special paste options, fill cells, insert/delete multiple columns, rows, and cells.

• Merge/unmerge cells, modify alignment, orientation, indentation, and apply number formats and styles.

Defining and Summarizing Data

• Define named ranges and tables.

• Insert Sparklines, and apply/remove conditional formatting.

Module 3: Managing Tables and Table Data

Creating and Modifying Tables

• Create Excel tables from cell ranges and apply table styles.

• Add/remove table rows and columns, configure total rows.

Filtering and Sorting Data

• Filter records.

• Sort data by multiple columns.

Module 4: Performing Operations by Using Formulas and Functions

Inserting References and Calculating Data

• Insert relative, absolute, and mixed references; reference named ranges and tables in formulas.

• Perform calculations using AVERAGE(), MAX(), MIN(), SUM(), COUNT(), COUNTA(), COUNTBLANK(), and IF() functions.

Formatting and Modifying Text

• Format text using RIGHT(), LEFT(), MID(), UPPER(), LOWER(), LEN(), CONCAT(), and TEXTJOIN() functions.

Module 5: Managing Charts

Creating and Modifying Charts

• Create charts and chart sheets.

• Add data series, switch between rows and columns, and add/modify chart elements

Formatting Charts

• Apply chart layouts and styles.

• Add alternative text for accessibility.