Excel - Take conditional formatting to the next level Tutorial

AVERAGEIFS and IFERROR

• 4:45
• Viewed 2667 times

Convert a picture into Data with Excel

• 0:25
• Viewed 2444 times

3D Maps

• 1:41
• Viewed 1998 times

Manage conditional formatting

• 4:30
• Viewed 1980 times

Create a combo chart

• 1:47
• Viewed 1856 times

The SUMIF function

• 5:27
• Viewed 1754 times

Introduction to Excel

• Viewed 1744 times

The nuts and bolts of VLOOKUP

• 3:05
• Viewed 1732 times

The SUM function

• 4:37
• Viewed 1672 times

How to simultaneously edit and calculate formulas across multiple worksheets

• 3:07
• Viewed 1645 times

Customize charts

• 4:28
• Viewed 1639 times

Functions and formulas

• 3:24
• Viewed 1631 times

AutoFill

• 2:55
• Viewed 1618 times

Advanced formulas and references

• 4:06
• Viewed 1610 times

COUNTIFS and SUMIFS

• 5:30
• Viewed 1605 times

Using functions

• 5:12
• Viewed 1603 times

New Chart types

• 1:52
• Viewed 1590 times

Top tips for working in Excel Online

• 3:35
• Viewed 1585 times

Drop-down list settings

• 4:14
• Viewed 1583 times

More complex formulas

• 4:17
• Viewed 1550 times

Assign a button to a macro

• 2:49
• Viewed 1547 times

Print headings, gridlines, formulas, and more

• 4:29
• Viewed 1544 times

Manage drop-down lists

• 6:12
• Viewed 1538 times

Start using Excel

• 4:22
• Viewed 1528 times

Print a worksheet on a specific number of pages

• 4:34
• Viewed 1522 times

Operator order

• 2:04
• Viewed 1521 times

AutoFilter details

• 3:27
• Viewed 1521 times

Password protect workbooks and worksheets in detail

• 6:00
• Viewed 1519 times

Three ways to add numbers in Excel Online

• 3:15
• Viewed 1507 times

Sort details

• 4:46
• Viewed 1507 times

Freeze panes in detail

• 3:30
• Viewed 1503 times

Basic math

• 2:28
• Viewed 1500 times

Look up values on a different worksheet

• 2:39
• Viewed 1489 times

More print options

• 5:59
• Viewed 1486 times

How to use 3-D reference or tridimensional formulas

• 3:01
• Viewed 1483 times

One click Forecasting

• 1:01
• Viewed 1475 times

How to track and monitor values with the Watch Window

• 2:42
• Viewed 1474 times

Password protect workbooks and worksheets

• 2:27
• Viewed 1470 times

Create pie, bar, and line charts

• 3:13
• Viewed 1464 times

Add numbers

• 2:54
• Viewed 1463 times

Improved version history

• 0:51
• Viewed 1455 times

Print worksheets and workbooks

• 1:07
• Viewed 1449 times

Create a PivotTable report manually

• 4:59
• Viewed 1448 times

Sort, filter, summarize and calculate your PivoteTable data

• 3:49
• Viewed 1441 times

Work with macros

• 4:40
• Viewed 1437 times

Use formulas to apply conditional formatting

• 4:20
• Viewed 1432 times

Ink Equation

• 0:41
• Viewed 1423 times

Copy a VLOOKUP formula

• 3:27
• Viewed 1423 times

MAXIFS & MINIFS

• 1:06
• Viewed 1419 times

Insert columns and rows

• 4:16
• Viewed 1412 times

AutoFill and Flash Fill

• 1:36
• Viewed 1410 times

Advanced filter details

• 4:13
• Viewed 1410 times

Insert headers and footers

• 2:02
• Viewed 1409 times

A first look at Excel 2016

• 3:22
• Viewed 1407 times

Input and error messages

• 2:52
• Viewed 1407 times

VLOOKUP: How and when to use it

• 2:38
• Viewed 1402 times

Save and print an Excel workbook

• 1:53
• Viewed 1402 times

A closer look at the ribbon

• 3:55
• Viewed 1388 times

How to link cells and calculate formulas across multiple worksheets

• 2:10
• Viewed 1386 times

Copying formulas

• 3:00
• Viewed 1384 times

IF with AND and OR

• 3:35
• Viewed 1384 times

Use conditional formatting

• 2:02
• Viewed 1380 times

Add formulas and references

• 2:52
• Viewed 1378 times

Header and footer details

• 3:41
• Viewed 1377 times

Subtract time

• 3:58
• Viewed 1372 times

IFS

• 1:05
• Viewed 1370 times

Freeze or lock panes

• 1:06
• Viewed 1367 times

Start with "Ideas" in Excel

• 0:38
• Viewed 1366 times

AVERAGEIF function

• 3:04
• Viewed 1365 times

Combine data from multiple worksheets

• 2:50
• Viewed 1357 times

Share documents

• 1:13
• Viewed 1352 times

Create a PivotTable and analyze your data

• 1:35
• Viewed 1350 times

Copy a chart

• 2:59
• Viewed 1340 times

Weighted average

• 2:06
• Viewed 1335 times

Save your macro

• 2:59
• Viewed 1334 times

Get going fast

• 1:38
• Viewed 1330 times

Cell references

• 1:34
• Viewed 1323 times

Average a group of numbers

• 2:01
• Viewed 1309 times

Copy and remove conditional formatting

• 1:11
• Viewed 1303 times

Drop-down lists

• 0:55
• Viewed 1301 times

How to create a table

• 2:11
• Viewed 1276 times

Conditionally format text

• 2:12
• Viewed 1269 times

TEXTJOIN

• 0:47
• Viewed 1267 times

Save, publish, and share

• 2:22
• Viewed 1260 times

CONCAT

• 0:51
• Viewed 1260 times

Conditionally format dates

• 2:38
• Viewed 1257 times

Advanced IF functions

• 3:22
• Viewed 1254 times

How things are organized

• 1:58
• Viewed 1249 times

Sort and filter data

• 1:38
• Viewed 1246 times

Edit a macro

• 3:29
• Viewed 1245 times

Use slicers to filter data

• 1:25
• Viewed 1225 times

Translate your Excel spreadsheets

• Viewed 1224 times

Flash Fill

• 2:59
• Viewed 1221 times

SWITCH

• 1:03
• Viewed 1208 times

Create a chart

• 0:52
• Viewed 1197 times

Microsoft Search

• 0:34
• Viewed 1192 times

Work simultaneously with others on a workbook

• 0:43
• Viewed 1181 times

Nested IF functions

• 3:30
• Viewed 1167 times

Page numbers in depth

• 3:06
• Viewed 1146 times

Map Chart in Excel

• 0:31
• Viewed 1142 times

Funnel Chart

• 0:33
• Viewed 1103 times

Check Accessibility in Excel

• Viewed 937 times

Accessibility in Excel

• Viewed 933 times

Change chart type

• Viewed 792 times

Do things quickly with Tell Me

• 1:07
• Viewed 661 times

XLOOKUP (Basic metrics)

• Viewed 645 times

Text before & after Function

• Viewed 636 times

XLOOKUP (Advanced metrics)

• Viewed 621 times

Insert an image in a cell with image function

• Viewed 608 times

Create dynamic drop down lists

• Viewed 556 times

Chat with your co-editors in real-time

• 0:28
• Viewed 545 times

Use slicers, timelines and PivotCharts to analyze your pivotetable data

• 3:38
• Viewed 422 times

Creating a forecast sheet with Excel

• 0:43
• Viewed 382 times

AVERAGEIFS and IFERROR

• 4:45
• Viewed 2667 times

Change font size, line spacing, and indentation

• 5:09
• Viewed 2450 times

Convert a picture into Data with Excel

• 0:25
• Viewed 2444 times

Add, restore, delete documents on OneDrive

• 2:02
• Viewed 2378 times

Adding a Column to a List or Library

• 2:56
• Viewed 2305 times

Trigger text to play over a video

• 2:58
• Viewed 2302 times

Align flow chart shapes and add connectors

• 4:48
• Viewed 2284 times

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

• 2:43
• Viewed 2183 times

Recycle bin

• 0:46
• Viewed 2065 times

3D Maps

• 1:41
• Viewed 1998 times

Manage conditional formatting

• 4:30
• Viewed 1980 times

Remove a watermark

• 2:20
• Viewed 1962 times

Change list formatting on the slide master

• 5:22
• Viewed 1907 times

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

• 1:27
• Viewed 1891 times

Create a combo chart

• 1:47
• Viewed 1856 times

The SUMIF function

• 5:27
• Viewed 1754 times

Edit headers and footers on the slide master

• 4:56
• Viewed 1743 times

Add sound effects to an animation

• 4:29
• Viewed 1738 times

The nuts and bolts of VLOOKUP

• 3:05
• Viewed 1732 times

Customize the slide master

• 4:38
• Viewed 1674 times

The SUM function

• 4:37
• Viewed 1672 times

How to simultaneously edit and calculate formulas across multiple worksheets

• 3:07
• Viewed 1645 times

Work with a motion path

• 2:50
• Viewed 1642 times

Customize charts

• 4:28
• Viewed 1639 times

Functions and formulas

• 3:24
• Viewed 1631 times

Create a new slide master and layouts

• 5:13
• Viewed 1615 times

Advanced formulas and references

• 4:06
• Viewed 1610 times

COUNTIFS and SUMIFS

• 5:30
• Viewed 1605 times

Using functions

• 5:12
• Viewed 1603 times

Apply and change a theme

• 5:13
• Viewed 1593 times

New Chart types

• 1:52
• Viewed 1590 times

Customize colors and save the theme

• 4:45
• Viewed 1587 times

Drop-down list settings

• 4:14
• Viewed 1583 times

Creating Your Application with PowerApps

• 4:13
• Viewed 1554 times

More complex formulas

• 4:17
• Viewed 1550 times

Assign a button to a macro

• 2:49
• Viewed 1547 times

Animate pictures, shapes, text, and other objects

• 4:02
• Viewed 1545 times

Print headings, gridlines, formulas, and more

• 4:29
• Viewed 1544 times

Create slide content and save the template

• 4:50
• Viewed 1539 times

Manage drop-down lists

• 6:12
• Viewed 1538 times

Start using Excel

• 4:22
• Viewed 1528 times

Print a worksheet on a specific number of pages

• 4:34
• Viewed 1522 times

Operator order

• 2:04
• Viewed 1521 times

AutoFilter details

• 3:27
• Viewed 1521 times

Password protect workbooks and worksheets in detail

• 6:00
• Viewed 1519 times

Add a picture watermark

• 4:36
• Viewed 1508 times

Three ways to add numbers in Excel Online

• 3:15
• Viewed 1507 times

Sort details

• 4:46
• Viewed 1507 times

Freeze panes in detail

• 3:30
• Viewed 1503 times

Basic math

• 2:28
• Viewed 1500 times

Picture backgrounds: Two methods

• 4:58
• Viewed 1490 times

Look up values on a different worksheet

• 2:39
• Viewed 1489 times

Animate text

• 4:14
• Viewed 1489 times

More print options

• 5:59
• Viewed 1486 times

How to use 3-D reference or tridimensional formulas

• 3:01
• Viewed 1483 times

Change the theme background

• 5:38
• Viewed 1481 times

Create a flow chart

• 3:27
• Viewed 1479 times

One click Forecasting

• 1:01
• Viewed 1475 times

Create a sequence with line paths

• 6:42
• Viewed 1475 times

How to track and monitor values with the Watch Window

• 2:42
• Viewed 1474 times

Password protect workbooks and worksheets

• 2:27
• Viewed 1470 times

Backgrounds in PowerPoint: First Steps

• 3:20
• Viewed 1470 times

Print slides, notes, or handouts

• 2:48
• Viewed 1465 times

Create pie, bar, and line charts

• 3:13
• Viewed 1464 times

Add numbers

• 2:54
• Viewed 1463 times

Work with handout masters

• 4:34
• Viewed 1462 times

Improved version history

• 0:51
• Viewed 1455 times

Print worksheets and workbooks

• 1:07
• Viewed 1449 times

Finalize and review a presentation

• 2:02
• Viewed 1449 times

Build an org chart using the text pane

• 4:00
• Viewed 1445 times

Work with macros

• 4:40
• Viewed 1437 times

Use formulas to apply conditional formatting

• 4:20
• Viewed 1432 times

Animate charts and SmartArt

• 3:36
• Viewed 1430 times

Use slide masters to customize a presentation

• 3:07
• Viewed 1427 times

Ink Equation

• 0:41
• Viewed 1423 times

Copy a VLOOKUP formula

• 3:27
• Viewed 1423 times

Prepare a basic handout

• 4:30
• Viewed 1423 times

Screen recording

• 0:49
• Viewed 1421 times

Customize the design and layouts

• 5:06
• Viewed 1421 times

Add a sound effect to a transition

• 3:45
• Viewed 1417 times

Combine a path with other effects

• 4:49
• Viewed 1414 times

Insert columns and rows

• 4:16
• Viewed 1412 times

AutoFill and Flash Fill

• 1:36
• Viewed 1410 times

Advanced filter details

• 4:13
• Viewed 1410 times

Insert headers and footers

• 2:02
• Viewed 1409 times

Input and error messages

• 2:52
• Viewed 1407 times

VLOOKUP: How and when to use it

• 2:38
• Viewed 1402 times

Animate pictures and shapes

• 4:17
• Viewed 1402 times

Customize master layouts

• 4:57
• Viewed 1398 times

Create a template from a presentation

• 3:09
• Viewed 1392 times

How to link cells and calculate formulas across multiple worksheets

• 2:10
• Viewed 1386 times

Copying formulas

• 3:00
• Viewed 1384 times

IF with AND and OR

• 3:35
• Viewed 1384 times

Build an org chart using SmartArt Tools

• 5:09
• Viewed 1381 times

Use conditional formatting

• 2:02
• Viewed 1380 times

Add formulas and references

• 2:52
• Viewed 1378 times

Header and footer details

• 3:41
• Viewed 1377 times

Subtract time

• 3:58
• Viewed 1372 times

Print handouts

• 4:32
• Viewed 1372 times

Freeze or lock panes

• 1:06
• Viewed 1367 times

AVERAGEIF function

• 3:04
• Viewed 1365 times

Create an org chart

• 3:09
• Viewed 1365 times

Editing of Items

• 2:37
• Viewed 1358 times

Combine data from multiple worksheets

• 2:50
• Viewed 1357 times

90 seconds about PowerPoint Slide Masters

• 1:17
• Viewed 1356 times

Apply paths to layered pictures

• 5:28
• Viewed 1354 times

Add headers and footers to slides

• 3:52
• Viewed 1352 times

Create custom animations with motion paths

• 3:39
• Viewed 1352 times

Trigger an animation effect

• 2:29
• Viewed 1350 times

Managing Different Versions of a Document

• 2:23
• Viewed 1342 times

Removing backgrounds in PowerPoint

• 2:45
• Viewed 1341 times

Copy a chart

• 2:59
• Viewed 1340 times

Using and co-editing files

• 1:40
• Viewed 1339 times

Weighted average

• 2:06
• Viewed 1335 times

Save your macro

• 2:59
• Viewed 1334 times

Cell references

• 1:34
• Viewed 1323 times

Create a new calendar

• Viewed 1312 times

Average a group of numbers

• 2:01
• Viewed 1309 times

Copy and remove conditional formatting

• 1:11
• Viewed 1303 times

Drop-down lists

• 0:55
• Viewed 1301 times

Making a Document Read Only

• 2:24
• Viewed 1299 times

Print Notes Pages as handouts

• 3:15
• Viewed 1295 times

Ink Equation

• 0:40
• Viewed 1291 times

How to create a table

• 2:11
• Viewed 1276 times

Using Files in a Synchronized Library

• 1:58
• Viewed 1275 times

Start using PowerPoint

• 2:06
• Viewed 1272 times

Conditionally format text

• 2:12
• Viewed 1269 times

Add staff members

• Viewed 1266 times

Connecting with Other Office 365 Tools

• 2:31
• Viewed 1263 times

Manage Your Working Time in MyAnalytics

• 0:34
• Viewed 1263 times

Edit headers and footers for handouts

• 2:43
• Viewed 1261 times

Insert items in a presentation

• 2:38
• Viewed 1258 times

Conditionally format dates

• 2:38
• Viewed 1257 times

Advanced IF functions

• 3:22
• Viewed 1254 times

Adding Items to Libraries

• 2:15
• Viewed 1248 times

Sort and filter data

• 1:38
• Viewed 1246 times

Edit a macro

• 3:29
• Viewed 1245 times

Design motion paths

• 2:30
• Viewed 1244 times

Editing Items in a List

• 1:34
• Viewed 1244 times

Adding Items to a List

• 1:34
• Viewed 1232 times

Use slicers to filter data

• 1:25
• Viewed 1225 times

New chart types

• 0:39
• Viewed 1211 times

Trigger a video

• 4:06
• Viewed 1209 times

Turn your Excel tables into real lists!

• Viewed 1205 times

Create dynamic visual title using the Selected Value function

• Viewed 1202 times

Moving and Copying Content

• 2:13
• Viewed 1185 times

Nested IF functions

• 3:30
• Viewed 1167 times

Create slicers

• Viewed 1157 times

Add headers and footers to a presentation

• 2:50
• Viewed 1153 times

Prepare and run your presentation

• 1:28
• Viewed 1147 times

Add bullets to text

• 2:24
• Viewed 1135 times

Create a Schedule and Organise it with the Help of Groups

• Viewed 1119 times

Create a site off a template

• Viewed 1113 times

Complete and Share a Schedule

• Viewed 1108 times

How Clock In Works

• Viewed 1096 times

Add a service

• Viewed 1095 times

Create custom fields

• Viewed 1089 times

Integrate Bookings into TEAMS

• Viewed 1087 times

Make a reservation [Staff]

• Viewed 1069 times

Create and organise a group

• Viewed 1056 times

Make a reservation [Customer]

• Viewed 1051 times

How to Copy a Schedule

• Viewed 1030 times

Conditional formatting

• Viewed 1025 times

Import, create, edit and share documents

• Viewed 1025 times

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

• 2:17
• Viewed 1023 times

Present Live

• Viewed 960 times

Create quick measures

• Viewed 936 times

Use the drill down filter

• Viewed 925 times

Add a Visio diagram

• Viewed 919 times

Access other apps aroud Office 365

• Viewed 899 times

Manage our recent documents

• Viewed 899 times

Calculate function

• Viewed 881 times

Use template to prepare your Agile SCRUM meeting

• Viewed 868 times

Install Office on 5 devices

• Viewed 852 times

Convert handwritten texts or drawings with Powerpoint

• 0:33
• Viewed 842 times

What are measures?

• Viewed 835 times

Turn on the drill down feature

• Viewed 816 times

Make better tables

• Viewed 800 times

Add knowledge to SharePoint content

• Viewed 795 times

Change chart type

• Viewed 792 times

Manage interactions

• Viewed 782 times

Add an alert to a visual

• Viewed 767 times

Create topic card manually

• Viewed 765 times

Manage relations between data sources

• Viewed 756 times

Organise notes

• Viewed 747 times

Research in your notes

• Viewed 732 times

Insert online videos

• Viewed 707 times

Save, share and share everything

• Viewed 685 times

Add an Excel spreadsheet

• Viewed 681 times

Add files

• Viewed 668 times

Send your notes by email

• Viewed 667 times

Imbrication OneNote / Outlook

• Viewed 664 times

Add items

• Viewed 661 times

Draw, sketch or handwrite notes

• Viewed 660 times

Password protect your notes

• Viewed 659 times

Use page templates

• Viewed 657 times

See who's collaborating

• Viewed 657 times

Create a video from the web app

• Viewed 654 times

Sync and sharing

• Viewed 653 times

Imbrication OneNote / Teams

• Viewed 651 times

Create a Microsoft Forms form directly in OneDrive

• Viewed 645 times

Text before & after Function

• Viewed 636 times

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

• Viewed 626 times

Save time by creating your form with quick import

• Viewed 620 times

Create your first form or quiz in Microsoft Forms

• Viewed 615 times

Insert an image in a cell with image function

• Viewed 608 times

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

• Viewed 600 times

Use "Text" fields to create a contact form

• Viewed 599 times

Create a new shared booking page

• Viewed 595 times

Multiple choice questions in Microsoft Forms

• Viewed 593 times

Create a video from the mobile app

• Viewed 591 times

Create an automated workflow for Microsoft Forms with Power Automate

• Viewed 586 times

Let responders submit files in Microsoft Forms

• Viewed 584 times

How to add branching logic in Microsoft Forms

• Viewed 581 times

Easily measure user experience with Net Promoter Score in Microsoft Forms

• Viewed 580 times

Get a rating in Microsoft Forms

• Viewed 576 times

Send a single form in multiple languages

• Viewed 574 times

Upload an existing video from your device

• Viewed 571 times

Record a live PowerPoint presentation

• Viewed 568 times

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

• Viewed 563 times

Use formatting toolbar and styles to format forms and quizzes

• Viewed 559 times

Make a reservation Employee]

• Viewed 559 times

Meeting recordings in Microsoft Teams

• Viewed 558 times

Create dynamic drop down lists

• Viewed 556 times

Make a reservation [Customer]

• Viewed 544 times

Creating and managing a group

• Viewed 539 times

Add staff

• Viewed 531 times

Add or edit a thumbnail

• Viewed 517 times

Creating or editing office documents in Engage

• Viewed 514 times

Create custom fields

• Viewed 507 times

Save a PowerPoint presentation

• Viewed 504 times

Add a service

• Viewed 463 times

Creating and managing campaigns

• Viewed 458 times

Engaging and animating a group

• Viewed 444 times