Search Results

We have found 74 items matching your search.
fallback-no-image-1516

Excel Vlookup

  • 531 user views 0 reviews

The Vlookup function in Excel looks for a value in the leftmost column of a table, and then returns a value in the same row from another column of the table. The tutorial clearly illustrates the Vlook

fallback-no-image-1515

Excel Pivot Tables

  • 605 user views 0 reviews

Pivot tables are very powerful when you need to extract the significance from a large, detailed data set. This tutorial teaches you how to use pivot tables in Excel.

fallback-no-image-1514

Excel chart

  • 505 user views 0 reviews

A simple Excel chart can say more than a sheet full of numbers. As you‘ll see, creating Excel charts is very easy. Learn more about Excel charts in this tutorial.

fallback-no-image-4257

Excel VBA Tutorial

  • 553 user views 0 reviews

A fully illustrated Excel VBA tutorial. Learn how to create your own macros in Excel VBA.

fallback-no-image-4349

Insert subtotals into a data list

  • 402 user views 0 reviews

Insert subtotals into a data list

fallback-no-image-4348

Group a range of cells

  • 439 user views 0 reviews

Group a range of cells

fallback-no-image-4347

Ungroup or split a range of cells

  • 367 user views 0 reviews

Ungroup or split a range of cells

fallback-no-image-4353

Find the value of a variable in a formula using Goal Seek

  • 321 user views 0 reviews

Find the value of a variable in a formula using Goal Seek

fallback-no-image-4356

Convert text to columns

  • 452 user views 0 reviews

Convert text to columns

fallback-no-image-4354

Consolidate data in multiple worksheets

  • 514 user views 0 reviews

Consolidate data in multiple worksheets

fallback-no-image-4355

Apply data validation to cells

  • 388 user views 0 reviews

Apply data validation to cells

no-image-4603

Calculating the 95 confidence intervals using Excel

  • 588 user views 0 reviews

Calculating the 95th percentile is a very useful statistical calculations. It is used in all kinds of scientific, economic or analysis situations. Doing this calculation is actually pretty easy in Exc