Customize YOUR Excel Course

1 of 11

Awesome!

You're taking the first step toward a prosperous and secure career.

Help us understand who you are and what you want to learn in Excel. This will help us tailor an Excel course specifically for you.

This should take about 5 minutes, max.

Customize Now

Customize Later

2 of 11

What's your Excel Expertise?

This will help rank you against others in your profession.

Finance

Supply Chain

Accounting

Marketing

Other

For Careers Such As:

Corporate Finance, Financial Planner, Financial Advisor, Investment Banker, etc.

Inventory Management, Purchaser / Buyer, Expeditor, Supply Chain Analyst, Manufacturing Analyst, etc.

Accounts Payable, Accounts Receivable, Collections, Accounting Analyst, Accountant, Tax Professional, CPA, etc.

Business Analyst, Sales Analyst, Marketing Analyst, Data Analyst, etc.

Legal, Teaching, Sales Professional, Entrepreneurs, etc.

BACK

3 of 11

Excel Keyboard Shortcuts

Learn

Skip

Sure, clicking around Excel can get you from point A to point B, but will you make your bosses deadline? Learn all the timing saving keyboard shortcuts and Excel functions to boost efficiency.

BACK

4 of 11

Data & Formula Integrity

Learn

Skip

Data integrity is the most important part of creating a spreadsheet.

It's happened to everyone - You're in a meeting and someone questions your data. And, you realize the formula is wrong. Completely wrong. There goes both the spreadsheet and your creditability. Learn best practices to prevent these unintended events for occurring.

BACK

5 of 11

Formulas REDEFINED

Here's what we believe well paid guru's should know...

Text Functions

Learn

Skip

Text functions for YOUR job

Learn how to maximize functions such as Concatenate(), Find(), Left(), Right(), Mid(), Replace(), Search(), Substitute(), Text(), Trim(), etc.

Logical Functions

Learn

Skip

Logical functions for YOUR job

Learn how to maximize functions such as If(), IfError(), And(), Or(), Not(), etc.

Informational Functions

Learn

Skip

Informational functions for YOUR job

Learn how to maximize functions such as Cell(), IsBlank(), IsError(), IsNumber(), IsText(), etc.

Math Functions

Learn

Skip

Math functions for YOUR job

Learn how to maximize functions such as SumIf(), SumIfs(), SumProduct(), Subtotal(), CountA(), CountBlank(), etc.

Reference & Lookup Functions

Learn

Skip

Reference & Lookup functions for YOUR job

Learn how to maximize functions such as vLookup(), hLookup(), Match(), Index(), Offset(), Row(), Column(), Indirect(), etc.

Financial Functions

Learn

Skip

Financial functions for YOUR job

Learn how to maximize functions such as FV(), PV(), IRR(), MIRR(), NPER(), NPV(), PMT(), etc.

Date & Time Functions

Learn

Skip

Date & Time functions for YOUR job

Learn how to maximize functions such as Day(), Month(), Year(), DateValue(), TimeValue(), Today(), Now(), EOMonth(), etc.

Array Functions

Learn

Skip

Array functions for YOUR job

Learn how to maximize formula writing with powerful Array formulas.

BACK

6 of 11

Name Manager

Learn

Skip

Do you deal with a lot of referenced cells and complex formulas? Learn how Name Manager can save time reducing formula errors.

BACK

7 of 11

Conditional Formatting

Learn

Skip

Dynamically identify trends, duplicates, outliers and more with conditional formatting. Get the most out of this powerful Excel function.

BACK

8 of 11

Excel Tables

Learn

Skip

Everyone knows that Excel is best for making tables. But, many users don't realize the power of turning a 'normal' table into an Excel formatted table.

BACK

9 of 11

Charting

Learn

Skip

Data integrity is important, but the presentation of the data should also be just as important. Learn to create beautiful charts that will captivate all audiences.

BACK

10 of 11

PivotTables

Learn

Skip

These days are all about 'Big Data' and analyzing this data quickly. Here you will learn to summarize, format, and calculate data quickly and accurately. PivotTables WILL change the way you work. Big Data… Not a Big Deal anymore.

BACK

11 of 11

Tips & Tricks

Learn

Skip

I have always learned the most in Excel when I see someone else do something different. Sometimes it's best to watch someone else do something amazing, rather than thinking outside the box on your own. We're confident you'll have a few 'aha' moments. Guaranteed.

BACK

CUSTOMIZATION COMPLETE

First, verify your selections below. Then, Sign Up to save YOUR customized course.

Topic	Learn or Skip
Excel Keyboard Shortcuts
Data & Formula Integrity
Formulas - Text
Formulas - Logical
Formulas - Informational
Formulas - Math
Formulas - Reference & Lookup
Formulas - Financial
Formulas - Date & Time
Formulas - Arrays
Name Manager
Conditional Formating
Excel Tables
Charting
PivotTables
Tips & Tricks

From all of us at CRUTER.com, We appreciate your anticipated business!

BACK

Customize YOUR Excel Course

Awesome!

You're taking the first step toward a prosperous and secure career.

Help us understand who you are and what you want to learn in Excel. This will help us tailor an Excel course specifically for you.

This should take about 5 minutes, max.

Customize Now

Customize Later

What's your Excel Expertise?

This will help rank you against others in your profession.

Finance

Supply Chain

Accounting

Marketing

Other

For Careers Such As:

NEXT

Excel Keyboard Shortcuts

Learn

Skip

Sure, clicking around Excel can get you from point A to point B, but will you make your bosses deadline? Learn all the timing saving keyboard shortcuts and Excel functions to boost efficiency.

Data & Formula Integrity

Learn

Skip

Data integrity is the most important part of creating a spreadsheet.

It's happened to everyone - You're in a meeting and someone questions your data. And, you realize the formula is wrong. Completely wrong. There goes both the spreadsheet and your creditability. Learn best practices to prevent these unintended events for occurring.

Formulas REDEFINED

Here's what we believe well paid guru's should know...

Text Functions

Learn

Skip

Text functions for YOUR job

Learn how to maximize functions such as Concatenate(), Find(), Left(), Right(), Mid(), Replace(), Search(), Substitute(), Text(), Trim(), etc.

Logical Functions

Learn

Skip

Logical functions for YOUR job

Learn how to maximize functions such as If(), IfError(), And(), Or(), Not(), etc.

Informational Functions

Learn

Skip

Informational functions for YOUR job

Learn how to maximize functions such as Cell(), IsBlank(), IsError(), IsNumber(), IsText(), etc.

Math Functions

Learn

Skip

Math functions for YOUR job

Learn how to maximize functions such as SumIf(), SumIfs(), SumProduct(), Subtotal(), CountA(), CountBlank(), etc.

Reference & Lookup Functions

Learn

Skip

Reference & Lookup functions for YOUR job

Learn how to maximize functions such as vLookup(), hLookup(), Match(), Index(), Offset(), Row(), Column(), Indirect(), etc.

Financial Functions

Learn

Skip

Financial functions for YOUR job

Learn how to maximize functions such as FV(), PV(), IRR(), MIRR(), NPER(), NPV(), PMT(), etc.

Date & Time Functions

Learn

Skip

Date & Time functions for YOUR job

Learn how to maximize functions such as Day(), Month(), Year(), DateValue(), TimeValue(), Today(), Now(), EOMonth(), etc.

Array Functions

Learn

Skip

Array functions for YOUR job

Learn how to maximize formula writing with powerful Array formulas.

NEXT

Name Manager

Learn

Skip

Do you deal with a lot of referenced cells and complex formulas? Learn how Name Manager can save time reducing formula errors.

Conditional Formatting

Learn

Skip

Dynamically identify trends, duplicates, outliers and more with conditional formatting. Get the most out of this powerful Excel function.

Excel Tables

Learn

Skip

Everyone knows that Excel is best for making tables. But, many users don't realize the power of turning a 'normal' table into an Excel formatted table.