CourseForMe

Excel 2010 - Advanced

CompuWorks
CompuWorks

Detailed information

Type:Courses
Method:Online
Duration:4 Hour

Do you need further information?
Contact the person in charge , free and at no obligation, for information on how to register, enrollment limit, availability and more.

Request information

Course program

Table of Contents:


Introduction

Advanced Functions

Overview

Help with Functions

Logical Functions

Nested If Statements

Using "And" and "Or"

The COUNTIF Function

The SUMIF Function




More Excel Functions

Overview

Financial Functions

Text Functions

Lookup Functions




Conditional Formatting and Sparklines

Overview

Applying Conditional Formats

Managing Conditional Formats

Creating Sparklines

Modifying Styles




Managing Data

Overview

Data Validation

Working with Tables

Sorting a List

Filtering Data




Pivot Tables

Overview

What is a Pivot Table?

Create and "Pivot" the Data

Filtering Data

Sorting Data

Filtering with Slicers

Adding a Pivot Chart




Analyzing Data

Overview

Auditing and Error Checking

Using the Scenario Manager

Using Goal Seek




Importing and Exporting Data

Overview

Word/Excel Transfer

Importing Text Files

Excel/Access Transfer




Conclusion

Course location

CompuWorks

When it comes to finding the best training in New England and across the country, CompuWorks is the hands down leader.

For over 23 years CompuWorks has been creating some of the most successful award-winning training programs in the country.

Our goal is to provide our customers with the best training solution possible. This means we don’t use a cookie cutter approach but customize a learning plan that is designed to fit each organization’s unique business needs. Our ability to be innovative, adaptable and creative in handling challenges is the key to our success.

CompuWorks is proud to be both SOMWBA-certified as a woman-owned business and a Microsoft Gold Certified Partner with competencies in Learning Solutions & Information Worker Solutions.

Search similar to IT, ICT and Computing

Courses similar to IT, ICT and Computing

Sponsored links