Excel - Create a PivotTable and analyze your data Tutorial

Convert a picture into Data with Excel

• 0:25
• Viewed 1573 times

Create a combo chart

• 1:47
• Viewed 1157 times

3D Maps

• 1:41
• Viewed 1138 times

The nuts and bolts of VLOOKUP

• 3:05
• Viewed 1053 times

Introduction to Excel

• 0:59
• Viewed 1016 times

AutoFill

• 2:55
• Viewed 973 times

How to simultaneously edit and calculate formulas across multiple worksheets

• 3:07
• Viewed 931 times

Advanced formulas and references

• 4:06
• Viewed 897 times

COUNTIFS and SUMIFS

• 5:30
• Viewed 891 times

Customize charts

• 4:28
• Viewed 890 times

Operator order

• 2:04
• Viewed 870 times

The SUMIF function

• 5:27
• Viewed 867 times

Assign a button to a macro

• 2:49
• Viewed 859 times

Functions and formulas

• 3:24
• Viewed 855 times

Top tips for working in Excel Online

• 3:35
• Viewed 852 times

MAXIFS & MINIFS

• 1:06
• Viewed 845 times

The SUM function

• 4:37
• Viewed 828 times

Drop-down list settings

• 4:14
• Viewed 823 times

Print worksheets and workbooks

• 1:07
• Viewed 823 times

Work with macros

• 4:40
• Viewed 815 times

Three ways to add numbers in Excel Online

• 3:15
• Viewed 810 times

One click Forecasting

• 1:01
• Viewed 807 times

Using functions

• 5:12
• Viewed 804 times

Password protect workbooks and worksheets in detail

• 6:00
• Viewed 801 times

AVERAGEIFS and IFERROR

• 4:45
• Viewed 797 times

Ink Equation

• 0:41
• Viewed 794 times

Freeze panes in detail

• 3:30
• Viewed 792 times

Manage drop-down lists

• 6:12
• Viewed 791 times

Add numbers

• 2:54
• Viewed 788 times

Copy a VLOOKUP formula

• 3:27
• Viewed 788 times

Improved version history

• 0:51
• Viewed 787 times

AutoFilter details

• 3:27
• Viewed 786 times

More complex formulas

• 4:17
• Viewed 785 times

Sort details

• 4:46
• Viewed 782 times

Password protect workbooks and worksheets

• 2:27
• Viewed 778 times

VLOOKUP: How and when to use it

• 2:38
• Viewed 773 times

Basic math

• 2:28
• Viewed 768 times

Look up values on a different worksheet

• 2:39
• Viewed 768 times

Freeze or lock panes

• 1:06
• Viewed 755 times

More print options

• 5:59
• Viewed 753 times

IFS

• 1:05
• Viewed 750 times

Add formulas and references

• 2:52
• Viewed 747 times

Print a worksheet on a specific number of pages

• 4:34
• Viewed 746 times

New Chart types

• 1:52
• Viewed 742 times

Sort, filter, summarize and calculate your PivoteTable data

• 3:49
• Viewed 741 times

Insert headers and footers

• 2:02
• Viewed 740 times

How to simultaneously view multiple worksheets

• 3:25
• Viewed 739 times

Input and error messages

• 2:52
• Viewed 737 times

Manage conditional formatting

• 4:30
• Viewed 736 times

How to use 3-D reference or tridimensional formulas

• 3:01
• Viewed 736 times

Use formulas to apply conditional formatting

• 4:20
• Viewed 735 times

Use conditional formatting

• 2:02
• Viewed 732 times

Copying formulas

• 3:00
• Viewed 724 times

AutoFill and Flash Fill

• 1:36
• Viewed 724 times

Save your macro

• 2:59
• Viewed 724 times

Create pie, bar, and line charts

• 3:13
• Viewed 722 times

How to link cells and calculate formulas across multiple worksheets

• 2:10
• Viewed 722 times

AVERAGEIF function

• 3:04
• Viewed 715 times

Create a PivotTable report manually

• 4:59
• Viewed 715 times

Cell references

• 1:34
• Viewed 711 times

Print headings, gridlines, formulas, and more

• 4:29
• Viewed 710 times

Share documents

• 1:13
• Viewed 707 times

Start with "Ideas" in Excel

• 0:38
• Viewed 707 times

Translate your Excel spreadsheets

• 1:16
• Viewed 707 times

Copy a chart

• 2:59
• Viewed 699 times

IF with AND and OR

• 3:35
• Viewed 695 times

Header and footer details

• 3:41
• Viewed 695 times

Weighted average

• 2:06
• Viewed 694 times

Start using Excel

• 4:22
• Viewed 692 times

Average a group of numbers

• 2:01
• Viewed 684 times

A first look at Excel 2016

• 3:22
• Viewed 681 times

Save and print an Excel workbook

• 1:53
• Viewed 679 times

Insert columns and rows

• 4:16
• Viewed 676 times

Copy and remove conditional formatting

• 1:11
• Viewed 670 times

Subtract time

• 3:58
• Viewed 662 times

Take conditional formatting to the next level

• 3:37
• Viewed 661 times

Combine data from multiple worksheets

• 2:50
• Viewed 660 times

A closer look at the ribbon

• 3:55
• Viewed 656 times

How to create a table

• 2:11
• Viewed 656 times

Drop-down lists

• 0:55
• Viewed 652 times

Flash Fill

• 2:59
• Viewed 646 times

Advanced filter details

• 4:13
• Viewed 642 times

Use slicers to filter data

• 1:25
• Viewed 636 times

Advanced IF functions

• 3:22
• Viewed 633 times

Microsoft Search

• 0:34
• Viewed 632 times

TEXTJOIN

• 0:47
• Viewed 627 times

Sort and filter data

• 1:38
• Viewed 625 times

Work simultaneously with others on a workbook

• 0:43
• Viewed 624 times

Edit a macro

• 3:29
• Viewed 614 times

Get going fast

• 1:38
• Viewed 610 times

Create a chart

• 0:52
• Viewed 608 times

Conditionally format text

• 2:12
• Viewed 606 times

Save, publish, and share

• 2:22
• Viewed 598 times

Conditionally format dates

• 2:38
• Viewed 598 times

CONCAT

• 0:51
• Viewed 586 times

How to track and monitor values with the Watch Window

• 2:42
• Viewed 585 times

Funnel Chart

• 0:33
• Viewed 563 times

How things are organized

• 1:58
• Viewed 562 times

SWITCH

• 1:03
• Viewed 559 times

Map Chart in Excel

• 0:31
• Viewed 556 times

Nested IF functions

• 3:30
• Viewed 547 times

Page numbers in depth

• 3:06
• Viewed 541 times

Accessibility in Excel

• 1:12
• Viewed 408 times

Check Accessibility in Excel

• 1:51
• Viewed 403 times

Convert a timestamp to date

• 2:41
• Viewed 326 times

Automatic Data Entry in Excel

• 0:41
• Viewed 322 times

Introduction to Power Query

• 3:35
• Viewed 319 times

Bubble chart

• 2:46
• Viewed 313 times

Convert a number of seconds to a time format

• 1:53
• Viewed 308 times

Scatter plot

• 2:27
• Viewed 308 times

Boolean logic

• 3:11
• Viewed 306 times

Display box and whisker diagrams

• 3:27
• Viewed 302 times

Add filters

• 3:00
• Viewed 301 times

Switch values

• 1:51
• Viewed 296 times

Dynamically get today's date

• 3:34
• Viewed 285 times

Manage multiple values

• 2:29
• Viewed 285 times

The data analysis cycle

• 3:37
• Viewed 285 times

Manage multiple sets of conditions

• 5:17
• Viewed 281 times

Create measurement functions

• 7:52
• Viewed 280 times

Change the calculation type on a column

• 1:55
• Viewed 278 times

Use Power Pivot in a PivotTable

• 2:14
• Viewed 278 times

Customize the items displayed on a chart

• 3:34
• Viewed 277 times

Create a Waterfall chart

• 2:26
• Viewed 277 times

Group by values

• 2:19
• Viewed 276 times

Automatically add capital letters to text

• 1:52
• Viewed 273 times

Get the week and weekday number of a date

• 1:59
• Viewed 273 times

Areas

• 4:32
• Viewed 273 times

Display a distribution histogram

• 2:20
• Viewed 272 times

Delete columns

• 3:38
• Viewed 270 times

Convert separate items to date format

• 1:16
• Viewed 270 times

Create a Sunburst

• 3:19
• Viewed 268 times

Create relationships between tables

• 6:44
• Viewed 266 times

Retrieve unique items from a list

• 1:26
• Viewed 266 times

Bar chart

• 3:12
• Viewed 266 times

Apply multiple conditions on the number of values

• 2:23
• Viewed 265 times

Relationship charts between available properties

• 3:16
• Viewed 265 times

Add slicers

• 4:43
• Viewed 264 times

Import data from an API

• 3:59
• Viewed 264 times

Remove unnecessary spaces from text

• 2:19
• Viewed 264 times

Tips and best practices

• 8:51
• Viewed 264 times

Create a PivotChart

• 3:29
• Viewed 263 times

Create a two-dimensional PivotTable

• 2:31
• Viewed 262 times

The value references of a PivotTable

• 2:30
• Viewed 262 times

Recreate the coordinates of a cell

• 3:37
• Viewed 261 times

Power Query overview

• 3:24
• Viewed 260 times

Basic conditions

• 2:45
• Viewed 260 times

Use table references

• 1:39
• Viewed 259 times

Ranking charts by importance

• 4:05
• Viewed 259 times

Add categories to a scatter plot

• 1:23
• Viewed 259 times

Retrieve part of a cell's text from the left or right

• 4:20
• Viewed 258 times

Overview of Financial Analysis Charts

• 3:20
• Viewed 258 times

Stacked Bar Chart

• 3:29
• Viewed 257 times

How to refresh your data after import

• 1:15
• Viewed 255 times

Change chart type

• 1:29
• Viewed 253 times

Combo chart

• 2:18
• Viewed 253 times

Your first PivotTable

• 6:45
• Viewed 252 times

Replace values

• 0:53
• Viewed 252 times

The VLOOKUP function

• 4:10
• Viewed 250 times

Overview of set and subset graphs

• 3:47
• Viewed 250 times

Map

• 1:47
• Viewed 248 times

Add segment on PivotCharts

• 2:06
• Viewed 247 times

Sparklines

• 2:44
• Viewed 246 times

Import a table into the data model

• 1:12
• Viewed 245 times

Concatenate text

• 3:01
• Viewed 244 times

Introduction to Data Visualization

• 0:58
• Viewed 244 times

Introduction to PivotTables

• 2:23
• Viewed 241 times

Refresh a PivotTable

• 1:58
• Viewed 241 times

Understanding distribution charts for a series of values

• 8:31
• Viewed 241 times

Import a series of files into a folder

• 2:58
• Viewed 239 times

Add a conditional column

• 4:52
• Viewed 239 times

Increment a one-day date

• 3:46
• Viewed 239 times

Create a Stock

• 4:37
• Viewed 239 times

Create a Treemap

• 3:40
• Viewed 238 times

Logical operators

• 2:23
• Viewed 235 times

Radar

• 4:50
• Viewed 234 times

Retrieve a set of values from a reference

• 4:20
• Viewed 233 times

Calculate the number of days between two dates

• 3:16
• Viewed 231 times

Merge two columns

• 3:27
• Viewed 231 times

Import an Excel file

• 2:28
• Viewed 229 times

Add a column off an example

• 2:06
• Viewed 225 times

Create your first chart

• 4:12
• Viewed 225 times

The HLOOKUP function

• 2:20
• Viewed 221 times

Pie chart

• 2:30
• Viewed 221 times

Line options

• 5:07
• Viewed 221 times

Funnel

• 2:10
• Viewed 221 times

Split a column

• 3:15
• Viewed 220 times

Import options presentation

• 3:57
• Viewed 218 times

Retrieve part of a text in a cell

• 4:56
• Viewed 218 times

Determine minimums and maximums based on criteria

• 1:31
• Viewed 217 times

Refer to a table by appying filters and sorts

• 2:49
• Viewed 217 times

Determine minimums and maximums

• 1:48
• Viewed 215 times

Calculate the number of values in a series

• 1:48
• Viewed 214 times

The main principles of data visualization

• 10:56
• Viewed 214 times

Retrieve information from a date

• 1:34
• Viewed 213 times

Power Pivot Overview and Installation

• 1:43
• Viewed 211 times

Switch uppercase, lowercase text

• 3:42
• Viewed 211 times

Definition of statistical metrics

• 6:32
• Viewed 210 times

Double conditions

• 3:50
• Viewed 209 times

Duplicate a column

• 2:00
• Viewed 208 times

Add a chart to a dedicated sheet

• 1:30
• Viewed 207 times

Convert separate items to time

• 1:53
• Viewed 206 times

Create a two-level entry PivotTable

• 1:57
• Viewed 205 times

Remove duplicates

• 1:48
• Viewed 203 times

Calculate the number of characters in a text

• 1:15
• Viewed 197 times

How to install Power Query

• 1:25
• Viewed 189 times

Check the accuracy of two cells

• 1:40
• Viewed 188 times

Sort your data

• 2:09
• Viewed 186 times

Change the order of columns

• 1:44
• Viewed 183 times

Available trend charts

• 2:11
• Viewed 183 times

Knowing the number of numeric values in a column

• 1:41
• Viewed 181 times

Calculate an average based on criteria

• 2:12
• Viewed 176 times

Delete rows

• 2:06
• Viewed 174 times

Incompatible cell format

• 2:48
• Viewed 171 times

Reference to an invalid cell

• 2:31
• Viewed 171 times

Know the number of items corresponding to criteria

• 2:27
• Viewed 170 times

Change the format of a column

• 1:20
• Viewed 168 times

Change how values are displayed

• 2:08
• Viewed 167 times

Find the most present value in a series

• 0:46
• Viewed 167 times

Identify the presence of an expression in text

• 2:12
• Viewed 163 times

Problem in cell selection

• 1:24
• Viewed 163 times

The Watch Window

• 2:46
• Viewed 161 times

Dividing a number by zero

• 2:19
• Viewed 160 times

Figure too long

• 1:17
• Viewed 158 times

Knowing the number of items in a table

• 2:22
• Viewed 157 times

Calculate a median

• 1:30
• Viewed 157 times

Obtain the numeric coordinates of a cell

• 3:02
• Viewed 153 times

Add filters on PivotCharts

• 1:12
• Viewed 152 times

Calculate the standard deviation

• 1:45
• Viewed 152 times

Integer number too large

• 1:42
• Viewed 147 times

Retrieve the number of empty values in a series

• 1:46
• Viewed 146 times

Search cannot return a value

• 2:49
• Viewed 134 times

XLOOKUP (Basic metrics)

• 4:19
• Viewed 114 times

Text before & after Function

• 4:57
• Viewed 94 times

Insert an image in a cell with image function

• 3:01
• Viewed 94 times

XLOOKUP (Advanced metrics)

• 9:30
• Viewed 82 times

Create dynamic drop down lists

• 3:26
• Viewed 76 times

Sort, filter, summarize and calculate your PivoteTable data

• 3:49
• Viewed 741 times

Create a PivotTable report manually

• 4:59
• Viewed 715 times

Creating a Report

• 2:54
• Viewed 697 times

Creating and configuring a Dashboard

• 2:50
• Viewed 672 times

Preparing, cleaning and transforming your Data

• 4:42
• Viewed 655 times

Recovering your Data from different sources

• 3:26
• Viewed 641 times

Publishing your Report through the Power BI Service

• 2:59
• Viewed 638 times

Introduction to the Query Editor

• 2:33
• Viewed 630 times

Improved version history

• 0:51
• Viewed 619 times

Customising your Visuals

• 2:58
• Viewed 604 times

How to track and monitor values with the Watch Window

• 2:42
• Viewed 585 times

Creating your Datasets

• 2:26
• Viewed 581 times

Sharing and publishing your Dashboard

• 3:43
• Viewed 574 times

Consulting and using a Dashboard

• 3:08
• Viewed 558 times

Customising your Report

• 3:12
• Viewed 549 times

Manipulating tiles in a Dashboard

• 3:26
• Viewed 505 times

Receive an email summary of Viva Insights' recommendations

• 0:55
• Viewed 298 times

Manage life cycle of a topic

• 1:44
• Viewed 290 times

The data analysis cycle

• 3:37
• Viewed 285 times

Check the accuracy of two cells

• 1:40
• Viewed 188 times

Knowing the number of numeric values in a column

• 1:41
• Viewed 181 times

Calculate an average based on criteria

• 2:12
• Viewed 176 times

Incompatible cell format

• 2:48
• Viewed 171 times

Reference to an invalid cell

• 2:31
• Viewed 171 times

Know the number of items corresponding to criteria

• 2:27
• Viewed 170 times

Find the most present value in a series

• 0:46
• Viewed 167 times

Identify the presence of an expression in text

• 2:12
• Viewed 163 times

Problem in cell selection

• 1:24
• Viewed 163 times

The Watch Window

• 2:46
• Viewed 161 times

Dividing a number by zero

• 2:19
• Viewed 160 times

Figure too long

• 1:17
• Viewed 158 times

Knowing the number of items in a table

• 2:22
• Viewed 157 times

Calculate a median

• 1:30
• Viewed 157 times

Obtain the numeric coordinates of a cell

• 3:02
• Viewed 153 times

Calculate the standard deviation

• 1:45
• Viewed 152 times

Integer number too large

• 1:42
• Viewed 147 times

Retrieve the number of empty values in a series

• 1:46
• Viewed 146 times

Search cannot return a value

• 2:49
• Viewed 134 times

XLOOKUP (Basic metrics)

• 4:19
• Viewed 114 times

XLOOKUP (Advanced metrics)

• 9:30
• Viewed 82 times

Create dynamic drop down lists

• 3:26
• Viewed 76 times

Insert an image in a cell with image function

• 3:01
• Viewed 94 times

Adding a shared channel in Teams

• 1:45
• Viewed 77 times

Text before & after Function

• 4:57
• Viewed 94 times

XLOOKUP (Advanced metrics)

• 9:30
• Viewed 82 times

XLOOKUP (Basic metrics)

• 4:19
• Viewed 114 times

Accessibility

• 1:30
• Viewed 163 times

Quick assist

• 1:29
• Viewed 158 times

Make screenshots easier

• 2:04
• Viewed 149 times

Set up widgets

• 1:28
• Viewed 181 times

Make your work environment attractive

• 1:44
• Viewed 157 times

Configure multiple virtual desktops

• 1:35
• Viewed 176 times

Work on multiple windows

• 1:21
• Viewed 159 times

Quickly find your files

• 2:07
• Viewed 180 times

Take ownership of the taskbar

• 2:10
• Viewed 194 times

Understanding the new interface

• 1:30
• Viewed 167 times