Excel - More complex formulas Tutorial

AVERAGEIFS and IFERROR

• 4:45
• Viewed 2647 times

Convert a picture into Data with Excel

• 0:25
• Viewed 2419 times

3D Maps

• 1:41
• Viewed 1967 times

Manage conditional formatting

• 4:30
• Viewed 1950 times

Create a combo chart

• 1:47
• Viewed 1841 times

Introduction to Excel

• Viewed 1737 times

The SUMIF function

• 5:27
• Viewed 1735 times

The nuts and bolts of VLOOKUP

• 3:05
• Viewed 1714 times

The SUM function

• 4:37
• Viewed 1653 times

How to simultaneously edit and calculate formulas across multiple worksheets

• 3:07
• Viewed 1631 times

Customize charts

• 4:28
• Viewed 1625 times

Functions and formulas

• 3:24
• Viewed 1619 times

AutoFill

• 2:55
• Viewed 1601 times

Advanced formulas and references

• 4:06
• Viewed 1591 times

COUNTIFS and SUMIFS

• 5:30
• Viewed 1590 times

Using functions

• 5:12
• Viewed 1583 times

New Chart types

• 1:52
• Viewed 1577 times

Drop-down list settings

• 4:14
• Viewed 1573 times

Top tips for working in Excel Online

• 3:35
• Viewed 1562 times

Assign a button to a macro

• 2:49
• Viewed 1532 times

Manage drop-down lists

• 6:12
• Viewed 1525 times

Print headings, gridlines, formulas, and more

• 4:29
• Viewed 1523 times

AutoFilter details

• 3:27
• Viewed 1514 times

Operator order

• 2:04
• Viewed 1507 times

Password protect workbooks and worksheets in detail

• 6:00
• Viewed 1503 times

Start using Excel

• 4:22
• Viewed 1501 times

Print a worksheet on a specific number of pages

• 4:34
• Viewed 1498 times

Sort details

• 4:46
• Viewed 1495 times

Basic math

• 2:28
• Viewed 1489 times

Three ways to add numbers in Excel Online

• 3:15
• Viewed 1487 times

Freeze panes in detail

• 3:30
• Viewed 1484 times

How to use 3-D reference or tridimensional formulas

• 3:01
• Viewed 1474 times

Look up values on a different worksheet

• 2:39
• Viewed 1470 times

More print options

• 5:59
• Viewed 1470 times

One click Forecasting

• 1:01
• Viewed 1460 times

How to track and monitor values with the Watch Window

• 2:42
• Viewed 1457 times

Password protect workbooks and worksheets

• 2:27
• Viewed 1453 times

Add numbers

• 2:54
• Viewed 1446 times

Create pie, bar, and line charts

• 3:13
• Viewed 1441 times

Print worksheets and workbooks

• 1:07
• Viewed 1441 times

Improved version history

• 0:51
• Viewed 1434 times

Create a PivotTable report manually

• 4:59
• Viewed 1427 times

Sort, filter, summarize and calculate your PivoteTable data

• 3:49
• Viewed 1425 times

Work with macros

• 4:40
• Viewed 1423 times

Use formulas to apply conditional formatting

• 4:20
• Viewed 1415 times

MAXIFS & MINIFS

• 1:06
• Viewed 1411 times

Ink Equation

• 0:41
• Viewed 1404 times

Insert columns and rows

• 4:16
• Viewed 1400 times

Insert headers and footers

• 2:02
• Viewed 1399 times

Copy a VLOOKUP formula

• 3:27
• Viewed 1397 times

Input and error messages

• 2:52
• Viewed 1396 times

AutoFill and Flash Fill

• 1:36
• Viewed 1395 times

A first look at Excel 2016

• 3:22
• Viewed 1388 times

Advanced filter details

• 4:13
• Viewed 1385 times

VLOOKUP: How and when to use it

• 2:38
• Viewed 1383 times

How to link cells and calculate formulas across multiple worksheets

• 2:10
• Viewed 1378 times

A closer look at the ribbon

• 3:55
• Viewed 1375 times

Save and print an Excel workbook

• 1:53
• Viewed 1374 times

IF with AND and OR

• 3:35
• Viewed 1372 times

Copying formulas

• 3:00
• Viewed 1367 times

Add formulas and references

• 2:52
• Viewed 1363 times

Header and footer details

• 3:41
• Viewed 1362 times

IFS

• 1:05
• Viewed 1361 times

Subtract time

• 3:58
• Viewed 1360 times

Use conditional formatting

• 2:02
• Viewed 1360 times

Start with "Ideas" in Excel

• 0:38
• Viewed 1355 times

AVERAGEIF function

• 3:04
• Viewed 1351 times

Freeze or lock panes

• 1:06
• Viewed 1350 times

Combine data from multiple worksheets

• 2:50
• Viewed 1348 times

Create a PivotTable and analyze your data

• 1:35
• Viewed 1336 times

Share documents

• 1:13
• Viewed 1327 times

Weighted average

• 2:06
• Viewed 1322 times

Copy a chart

• 2:59
• Viewed 1322 times

Cell references

• 1:34
• Viewed 1313 times

Get going fast

• 1:38
• Viewed 1313 times

Save your macro

• 2:59
• Viewed 1312 times

Average a group of numbers

• 2:01
• Viewed 1292 times

Copy and remove conditional formatting

• 1:11
• Viewed 1287 times

Drop-down lists

• 0:55
• Viewed 1281 times

Take conditional formatting to the next level

• 3:37
• Viewed 1274 times

How to create a table

• 2:11
• Viewed 1255 times

TEXTJOIN

• 0:47
• Viewed 1255 times

Conditionally format text

• 2:12
• Viewed 1250 times

Save, publish, and share

• 2:22
• Viewed 1237 times

CONCAT

• 0:51
• Viewed 1237 times

Conditionally format dates

• 2:38
• Viewed 1235 times

Advanced IF functions

• 3:22
• Viewed 1235 times

Sort and filter data

• 1:38
• Viewed 1234 times

Edit a macro

• 3:29
• Viewed 1231 times

How things are organized

• 1:58
• Viewed 1226 times

Translate your Excel spreadsheets

• Viewed 1217 times

Use slicers to filter data

• 1:25
• Viewed 1213 times

Flash Fill

• 2:59
• Viewed 1211 times

SWITCH

• 1:03
• Viewed 1194 times

Create a chart

• 0:52
• Viewed 1186 times

Microsoft Search

• 0:34
• Viewed 1182 times

Work simultaneously with others on a workbook

• 0:43
• Viewed 1160 times

Nested IF functions

• 3:30
• Viewed 1151 times

Page numbers in depth

• 3:06
• Viewed 1128 times

Map Chart in Excel

• 0:31
• Viewed 1127 times

Funnel Chart

• 0:33
• Viewed 1087 times

Check Accessibility in Excel

• Viewed 925 times

Accessibility in Excel

• Viewed 919 times

Change chart type

• Viewed 778 times

Do things quickly with Tell Me

• 1:07
• Viewed 646 times

XLOOKUP (Basic metrics)

• Viewed 630 times

Text before & after Function

• Viewed 620 times

XLOOKUP (Advanced metrics)

• Viewed 598 times

Insert an image in a cell with image function

• Viewed 598 times

Create dynamic drop down lists

• Viewed 540 times

Chat with your co-editors in real-time

• 0:28
• Viewed 527 times

Use slicers, timelines and PivotCharts to analyze your pivotetable data

• 3:38
• Viewed 400 times

Creating a forecast sheet with Excel

• 0:43
• Viewed 372 times

AVERAGEIFS and IFERROR

• 4:45
• Viewed 2647 times

Change font size, line spacing, and indentation

• 5:09
• Viewed 2438 times

Convert a picture into Data with Excel

• 0:25
• Viewed 2419 times

Add, restore, delete documents on OneDrive

• 2:02
• Viewed 2360 times

Trigger text to play over a video

• 2:58
• Viewed 2290 times

Adding a Column to a List or Library

• 2:56
• Viewed 2289 times

Align flow chart shapes and add connectors

• 4:48
• Viewed 2269 times

Sync OneDrive for Business to your computer (Windows 10 - 1709)

• 2:43
• Viewed 2168 times

Recycle bin

• 0:46
• Viewed 2053 times

3D Maps

• 1:41
• Viewed 1967 times

Remove a watermark

• 2:20
• Viewed 1951 times

Manage conditional formatting

• 4:30
• Viewed 1950 times

Change list formatting on the slide master

• 5:22
• Viewed 1890 times

Work with documents in a synced library folder (Windows 10 - 1709)

• 1:27
• Viewed 1879 times

Create a combo chart

• 1:47
• Viewed 1841 times

The SUMIF function

• 5:27
• Viewed 1735 times

Edit headers and footers on the slide master

• 4:56
• Viewed 1724 times

Add sound effects to an animation

• 4:29
• Viewed 1716 times

The nuts and bolts of VLOOKUP

• 3:05
• Viewed 1714 times

Customize the slide master

• 4:38
• Viewed 1662 times

The SUM function

• 4:37
• Viewed 1653 times

How to simultaneously edit and calculate formulas across multiple worksheets

• 3:07
• Viewed 1631 times

Work with a motion path

• 2:50
• Viewed 1629 times

Customize charts

• 4:28
• Viewed 1625 times

Functions and formulas

• 3:24
• Viewed 1619 times

Create a new slide master and layouts

• 5:13
• Viewed 1597 times

Advanced formulas and references

• 4:06
• Viewed 1591 times

COUNTIFS and SUMIFS

• 5:30
• Viewed 1590 times

Using functions

• 5:12
• Viewed 1583 times

Apply and change a theme

• 5:13
• Viewed 1578 times

New Chart types

• 1:52
• Viewed 1577 times

Customize colors and save the theme

• 4:45
• Viewed 1574 times

Drop-down list settings

• 4:14
• Viewed 1573 times

Creating Your Application with PowerApps

• 4:13
• Viewed 1539 times

Assign a button to a macro

• 2:49
• Viewed 1532 times

Animate pictures, shapes, text, and other objects

• 4:02
• Viewed 1526 times

Manage drop-down lists

• 6:12
• Viewed 1525 times

Create slide content and save the template

• 4:50
• Viewed 1525 times

Print headings, gridlines, formulas, and more

• 4:29
• Viewed 1523 times

AutoFilter details

• 3:27
• Viewed 1514 times

Operator order

• 2:04
• Viewed 1507 times

Password protect workbooks and worksheets in detail

• 6:00
• Viewed 1503 times

Start using Excel

• 4:22
• Viewed 1501 times

Print a worksheet on a specific number of pages

• 4:34
• Viewed 1498 times

Sort details

• 4:46
• Viewed 1495 times

Add a picture watermark

• 4:36
• Viewed 1491 times

Basic math

• 2:28
• Viewed 1489 times

Three ways to add numbers in Excel Online

• 3:15
• Viewed 1487 times

Freeze panes in detail

• 3:30
• Viewed 1484 times

How to use 3-D reference or tridimensional formulas

• 3:01
• Viewed 1474 times

Change the theme background

• 5:38
• Viewed 1472 times

Picture backgrounds: Two methods

• 4:58
• Viewed 1472 times

Look up values on a different worksheet

• 2:39
• Viewed 1470 times

More print options

• 5:59
• Viewed 1470 times

Animate text

• 4:14
• Viewed 1470 times

Create a flow chart

• 3:27
• Viewed 1466 times

One click Forecasting

• 1:01
• Viewed 1460 times

Create a sequence with line paths

• 6:42
• Viewed 1458 times

How to track and monitor values with the Watch Window

• 2:42
• Viewed 1457 times

Password protect workbooks and worksheets

• 2:27
• Viewed 1453 times

Backgrounds in PowerPoint: First Steps

• 3:20
• Viewed 1453 times

Add numbers

• 2:54
• Viewed 1446 times

Print slides, notes, or handouts

• 2:48
• Viewed 1446 times

Work with handout masters

• 4:34
• Viewed 1446 times

Create pie, bar, and line charts

• 3:13
• Viewed 1441 times

Print worksheets and workbooks

• 1:07
• Viewed 1441 times

Improved version history

• 0:51
• Viewed 1434 times

Build an org chart using the text pane

• 4:00
• Viewed 1433 times

Finalize and review a presentation

• 2:02
• Viewed 1429 times

Work with macros

• 4:40
• Viewed 1423 times

Animate charts and SmartArt

• 3:36
• Viewed 1420 times

Use formulas to apply conditional formatting

• 4:20
• Viewed 1415 times

Use slide masters to customize a presentation

• 3:07
• Viewed 1410 times

Screen recording

• 0:49
• Viewed 1409 times

Prepare a basic handout

• 4:30
• Viewed 1407 times

Ink Equation

• 0:41
• Viewed 1404 times

Insert columns and rows

• 4:16
• Viewed 1400 times

Insert headers and footers

• 2:02
• Viewed 1399 times

Copy a VLOOKUP formula

• 3:27
• Viewed 1397 times

Add a sound effect to a transition

• 3:45
• Viewed 1397 times

Input and error messages

• 2:52
• Viewed 1396 times

AutoFill and Flash Fill

• 1:36
• Viewed 1395 times

Animate pictures and shapes

• 4:17
• Viewed 1394 times

Customize the design and layouts

• 5:06
• Viewed 1394 times

Combine a path with other effects

• 4:49
• Viewed 1391 times

Advanced filter details

• 4:13
• Viewed 1385 times

VLOOKUP: How and when to use it

• 2:38
• Viewed 1383 times

Customize master layouts

• 4:57
• Viewed 1378 times

How to link cells and calculate formulas across multiple worksheets

• 2:10
• Viewed 1378 times

IF with AND and OR

• 3:35
• Viewed 1372 times

Create a template from a presentation

• 3:09
• Viewed 1371 times

Build an org chart using SmartArt Tools

• 5:09
• Viewed 1370 times

Copying formulas

• 3:00
• Viewed 1367 times

Add formulas and references

• 2:52
• Viewed 1363 times

Header and footer details

• 3:41
• Viewed 1362 times

Subtract time

• 3:58
• Viewed 1360 times

Use conditional formatting

• 2:02
• Viewed 1360 times

Print handouts

• 4:32
• Viewed 1359 times

AVERAGEIF function

• 3:04
• Viewed 1351 times

Freeze or lock panes

• 1:06
• Viewed 1350 times

Combine data from multiple worksheets

• 2:50
• Viewed 1348 times

Create an org chart

• 3:09
• Viewed 1347 times

90 seconds about PowerPoint Slide Masters

• 1:17
• Viewed 1345 times

Apply paths to layered pictures

• 5:28
• Viewed 1345 times

Add headers and footers to slides

• 3:52
• Viewed 1342 times

Create custom animations with motion paths

• 3:39
• Viewed 1339 times

Editing of Items

• 2:37
• Viewed 1338 times

Trigger an animation effect

• 2:29
• Viewed 1336 times

Removing backgrounds in PowerPoint

• 2:45
• Viewed 1328 times

Weighted average

• 2:06
• Viewed 1322 times

Copy a chart

• 2:59
• Viewed 1322 times

Using and co-editing files

• 1:40
• Viewed 1319 times

Managing Different Versions of a Document

• 2:23
• Viewed 1317 times

Cell references

• 1:34
• Viewed 1313 times

Save your macro

• 2:59
• Viewed 1312 times

Create a new calendar

• Viewed 1301 times

Average a group of numbers

• 2:01
• Viewed 1292 times

Copy and remove conditional formatting

• 1:11
• Viewed 1287 times

Print Notes Pages as handouts

• 3:15
• Viewed 1286 times

Making a Document Read Only

• 2:24
• Viewed 1282 times

Drop-down lists

• 0:55
• Viewed 1281 times

Take conditional formatting to the next level

• 3:37
• Viewed 1274 times

Ink Equation

• 0:40
• Viewed 1272 times

Start using PowerPoint

• 2:06
• Viewed 1259 times

Using Files in a Synchronized Library

• 1:58
• Viewed 1255 times

How to create a table

• 2:11
• Viewed 1255 times

Add staff members

• Viewed 1255 times

Conditionally format text

• 2:12
• Viewed 1250 times

Manage Your Working Time in MyAnalytics

• 0:34
• Viewed 1247 times

Insert items in a presentation

• 2:38
• Viewed 1243 times

Connecting with Other Office 365 Tools

• 2:31
• Viewed 1243 times

Edit headers and footers for handouts

• 2:43
• Viewed 1240 times

Conditionally format dates

• 2:38
• Viewed 1235 times

Advanced IF functions

• 3:22
• Viewed 1235 times

Sort and filter data

• 1:38
• Viewed 1234 times

Edit a macro

• 3:29
• Viewed 1231 times

Design motion paths

• 2:30
• Viewed 1229 times

Adding Items to Libraries

• 2:15
• Viewed 1223 times

Editing Items in a List

• 1:34
• Viewed 1220 times

Adding Items to a List

• 1:34
• Viewed 1214 times

Use slicers to filter data

• 1:25
• Viewed 1213 times

New chart types

• 0:39
• Viewed 1199 times

Trigger a video

• 4:06
• Viewed 1199 times

Turn your Excel tables into real lists!

• Viewed 1195 times

Create dynamic visual title using the Selected Value function

• Viewed 1186 times

Moving and Copying Content

• 2:13
• Viewed 1168 times

Nested IF functions

• 3:30
• Viewed 1151 times

Add headers and footers to a presentation

• 2:50
• Viewed 1135 times

Create slicers

• Viewed 1133 times

Prepare and run your presentation

• 1:28
• Viewed 1127 times

Add bullets to text

• 2:24
• Viewed 1119 times

Create a Schedule and Organise it with the Help of Groups

• Viewed 1104 times

Complete and Share a Schedule

• Viewed 1101 times

How Clock In Works

• Viewed 1088 times

Create a site off a template

• Viewed 1085 times

Add a service

• Viewed 1079 times

Integrate Bookings into TEAMS

• Viewed 1075 times

Create custom fields

• Viewed 1074 times

Make a reservation [Staff]

• Viewed 1058 times

Create and organise a group

• Viewed 1041 times

Make a reservation [Customer]

• Viewed 1038 times

Import, create, edit and share documents

• Viewed 1020 times

How to Copy a Schedule

• Viewed 1017 times

Conditional formatting

• Viewed 1015 times

Work with documents in a synced library folder (Windows 10 - 1903)

• 2:17
• Viewed 1007 times

Present Live

• Viewed 943 times

Create quick measures

• Viewed 925 times

Add a Visio diagram

• Viewed 908 times

Use the drill down filter

• Viewed 902 times

Access other apps aroud Office 365

• Viewed 888 times

Manage our recent documents

• Viewed 887 times

Calculate function

• Viewed 868 times

Use template to prepare your Agile SCRUM meeting

• Viewed 861 times

Install Office on 5 devices

• Viewed 847 times

Convert handwritten texts or drawings with Powerpoint

• 0:33
• Viewed 833 times

What are measures?

• Viewed 827 times

Turn on the drill down feature

• Viewed 795 times

Make better tables

• Viewed 787 times

Add knowledge to SharePoint content

• Viewed 782 times

Change chart type

• Viewed 778 times

Manage interactions

• Viewed 766 times

Create topic card manually

• Viewed 754 times

Add an alert to a visual

• Viewed 749 times

Manage relations between data sources

• Viewed 746 times

Organise notes

• Viewed 738 times

Research in your notes

• Viewed 721 times

Insert online videos

• Viewed 700 times

Add an Excel spreadsheet

• Viewed 666 times

Save, share and share everything

• Viewed 664 times

Imbrication OneNote / Outlook

• Viewed 656 times

Add items

• Viewed 654 times

Add files

• Viewed 653 times

Send your notes by email

• Viewed 653 times

See who's collaborating

• Viewed 644 times

Password protect your notes

• Viewed 644 times

Draw, sketch or handwrite notes

• Viewed 643 times

Use page templates

• Viewed 642 times

Sync and sharing

• Viewed 640 times

Imbrication OneNote / Teams

• Viewed 637 times

Create a Microsoft Forms form directly in OneDrive

• Viewed 634 times

Create a video from the web app

• Viewed 634 times

Text before & after Function

• Viewed 620 times

Measure how people feel about something with the Likert scale in Microsoft Forms

• Viewed 611 times

Create your first form or quiz in Microsoft Forms

• Viewed 606 times

Save time by creating your form with quick import

• Viewed 600 times

Insert an image in a cell with image function

• Viewed 598 times

Use "Text" fields to create a contact form

• Viewed 597 times

Create a new shared booking page

• Viewed 586 times

Find out your coworkers’ preferences by creating a “Ranking” question in Microsoft Forms

• Viewed 585 times

Multiple choice questions in Microsoft Forms

• Viewed 584 times

Let responders submit files in Microsoft Forms

• Viewed 580 times

Create a video from the mobile app

• Viewed 578 times

Easily measure user experience with Net Promoter Score in Microsoft Forms

• Viewed 576 times

How to add branching logic in Microsoft Forms

• Viewed 573 times

Create an automated workflow for Microsoft Forms with Power Automate

• Viewed 571 times

Send a single form in multiple languages

• Viewed 570 times

Upload an existing video from your device

• Viewed 565 times

Add a "Date" field to your form or quiz in Microsoft Forms

• Viewed 560 times

Get a rating in Microsoft Forms

• Viewed 559 times

Record a live PowerPoint presentation

• Viewed 554 times

Make a reservation Employee]

• Viewed 548 times

Use formatting toolbar and styles to format forms and quizzes

• Viewed 545 times

Meeting recordings in Microsoft Teams

• Viewed 545 times

Create dynamic drop down lists

• Viewed 540 times

Make a reservation [Customer]

• Viewed 535 times

Add staff

• Viewed 523 times

Creating and managing a group

• Viewed 516 times

Create custom fields

• Viewed 504 times

Save a PowerPoint presentation

• Viewed 502 times

Add or edit a thumbnail

• Viewed 501 times

Creating or editing office documents in Engage

• Viewed 499 times

Add a service

• Viewed 459 times

Creating and managing campaigns

• Viewed 442 times

Engaging and animating a group

• Viewed 438 times