Introduction to Microsoft Excel - MOS Certification Training - AM Classes
$229 – $329
Introduction to Microsoft Excel - MOS Certification Training - AM Classes

Introduction to Microsoft Excel - MOS Certification Training - AM Classes

Event Information

Share this event

Date and Time

Location

Location

PWC Training

2470 Windy Hill Road

Suite 253

Atlanta, GA 30067

View Map

Friends Who Are Going
Event description

Description

PWC Training allows for our students to bundle exam vouchers with their purchase becasue we are a Certiport testing center also. There is no need to bring or rent a computer because we are a full service testing and training center located just north of the city.

The core-level Microsoft Office Excel user should be able to navigate Microsoft Office Excel software at the feature and functional level. They should be familiar with and know how to use at least 80 percent of the features and capabilities of Microsoft Office Excel . The core-level user should be able to use Microsoft Office Excel to create and edit professional-looking spreadsheets for a variety of purposes and situations. Users would include people from a wide variety of job roles from almost all areas of professional, student, and personal life. For this level of certification, a student should take our Introduction to Excel.

Expert-level Microsoft Office Excel users are able to efficiently and confidently use Excel software at the feature and functionality levels. Expert users are proficient with advanced formulas, functions, and data analysis tools. Expert users can manipulate data for analysis, presentation, and collaboration. In addition, expert users can manipulate Excel options to customize their environment to meet varying needs and enhance their productivity. For this level of certification, a student should take our Introduction to Excel (if necessary) and Advanced Excel classes.


1. Create and Manage Workbooks and Worksheets
1.1 Create workbooks and worksheets
Creating new workbooks and worksheets
Reusing existing content
1.2 Navigate through worksheets and workbooks
Locating data and worksheet elements
Inserting hyperlinks
1.3 Format worksheets and workbooks
Modifying page setup
Inserting page elements
Changing workbook themes and colors
Modifying rows and columns
Configuring data validation
1.4 Customize options and views for worksheets and workbooks
Displaying different views of worksheets
Displaying multiple parts of a workbook
Hiding and displaying workbook content
Customizing the Quick Access Toolbar
Customizing the ribbon
Working with macros
Modifying workbook properties
1.5 Configure worksheets and workbooks to print or save
Printing workbook content
Saving workbooks
Objective review

2. Manage Cells and Ranges
2.1 Insert data in cells and ranges
Creating data
Reusing data
2.2 Format cells and ranges
Formatting cell structure
Formatting cell content
Applying number formats
Copying formatting
2.3 Order and group cells and ranges
Modeling data
Creating named ranges
Working with data groups and summaries
Objective review

3. Manage Tables
3.1 Create tables
3.2 Modify tables
3.3 Filter and sort tables
Objective review

4. Apply Formulas and Functions
4.1 Utilize cell ranges and references in formulas and functions
Referencing cells and cell ranges in formulas
Defining order of operations
4.2 Summarize data by using functions
4.3 Utilize conditional logic in functions
4.4 Format and modify text by using functions
Objective review

5. Create Charts and Objects
5.1 Create charts
5.2 Format charts
5.3 Insert and format objects
Adding pictures to sheets
Adding text boxes to sheets
Adding SmartArt graphics to sheets
Objective review

Share with friends

Date and Time

Location

PWC Training

2470 Windy Hill Road

Suite 253

Atlanta, GA 30067

View Map

Save This Event

Event Saved