Microsoft Excel Video Training – Advanced
Learn about the advanced features of Microsoft Excel, including working with databases, through a video tutorial suite.
Tutorial
Convert a picture into Data with Excel
0:25 Viewed 1142 times3D Maps
1:41 Viewed 857 timesCreate a combo chart
1:47 Viewed 845 timesIntroduction to Excel
0:59 Viewed 835 timesAutoFill
2:55 Viewed 831 timesThe nuts and bolts of VLOOKUP
3:05 Viewed 827 timesCOUNTIFS and SUMIFS
5:30 Viewed 721 timesAdvanced formulas and references
4:06 Viewed 717 timesMAXIFS & MINIFS
1:06 Viewed 708 timesCustomize charts
4:28 Viewed 699 timesHow to simultaneously edit and calculate formulas across multiple worksheets
3:07 Viewed 692 timesAssign a button to a macro
2:49 Viewed 689 timesThe SUM function
4:37 Viewed 668 timesAVERAGEIFS and IFERROR
4:45 Viewed 667 timesThe SUMIF function
5:27 Viewed 663 timesFunctions and formulas
3:24 Viewed 661 timesCopy a VLOOKUP formula
3:27 Viewed 652 timesOperator order
2:04 Viewed 650 timesManage drop-down lists
6:12 Viewed 644 timesUsing functions
5:12 Viewed 636 timesInk Equation
0:41 Viewed 632 timesSort details
4:46 Viewed 632 timesPassword protect workbooks and worksheets
2:27 Viewed 630 timesAdd numbers
2:54 Viewed 623 timesThree ways to add numbers in Excel Online
3:15 Viewed 618 timesDrop-down list settings
4:14 Viewed 617 timesPrint worksheets and workbooks
1:07 Viewed 614 timesFreeze panes in detail
3:30 Viewed 613 timesPrint headings, gridlines, formulas, and more
4:29 Viewed 613 timesWork with macros
4:40 Viewed 612 timesPassword protect workbooks and worksheets in detail
6:00 Viewed 608 timesIFS
1:05 Viewed 606 timesNew Chart types
1:52 Viewed 603 timesAdd formulas and references
2:52 Viewed 600 timesOne click Forecasting
1:01 Viewed 597 timesAutoFilter details
3:27 Viewed 597 timesShare documents
1:13 Viewed 595 timesFreeze or lock panes
1:06 Viewed 595 timesCopying formulas
3:00 Viewed 592 timesHow to simultaneously view multiple worksheets
3:25 Viewed 591 timesStart with "Ideas" in Excel
0:38 Viewed 588 timesTop tips for working in Excel Online
3:35 Viewed 587 timesManage conditional formatting
4:30 Viewed 584 timesVLOOKUP: How and when to use it
2:38 Viewed 583 timesMore complex formulas
4:17 Viewed 576 timesSave your macro
2:59 Viewed 576 timesImproved version history
0:51 Viewed 572 timesInsert headers and footers
2:02 Viewed 572 timesBasic math
2:28 Viewed 571 timesLook up values on a different worksheet
2:39 Viewed 571 timesCreate pie, bar, and line charts
3:13 Viewed 570 timesTranslate your Excel spreadsheets
1:16 Viewed 568 timesHow to link cells and calculate formulas across multiple worksheets
2:10 Viewed 562 timesUse formulas to apply conditional formatting
4:20 Viewed 561 timesSave and print an Excel workbook
1:53 Viewed 558 timesInput and error messages
2:52 Viewed 554 timesCreate a PivotTable and analyze your data
1:35 Viewed 553 timesHow to use 3-D reference or tridimensional formulas
3:01 Viewed 553 timesCopy a chart
2:59 Viewed 552 timesAVERAGEIF function
3:04 Viewed 551 timesAutoFill and Flash Fill
1:36 Viewed 550 timesMicrosoft Search
0:34 Viewed 549 timesFlash Fill
2:59 Viewed 546 timesUse conditional formatting
2:02 Viewed 542 timesMore print options
5:59 Viewed 542 timesInsert columns and rows
4:16 Viewed 540 timesSort, filter, summarize and calculate your PivoteTable data
3:49 Viewed 538 timesCell references
1:34 Viewed 534 timesA first look at Excel 2016
3:22 Viewed 529 timesTEXTJOIN
0:47 Viewed 529 timesHow to create a table
2:11 Viewed 526 timesTake conditional formatting to the next level
3:37 Viewed 523 timesStart using Excel
4:22 Viewed 523 timesPrint a worksheet on a specific number of pages
4:34 Viewed 523 timesWork simultaneously with others on a workbook
0:43 Viewed 522 timesWeighted average
2:06 Viewed 521 timesDrop-down lists
0:55 Viewed 517 timesAdvanced filter details
4:13 Viewed 516 timesIF with AND and OR
3:35 Viewed 511 timesSubtract time
3:58 Viewed 510 timesCombine data from multiple worksheets
2:50 Viewed 510 timesHeader and footer details
3:41 Viewed 508 timesA closer look at the ribbon
3:55 Viewed 507 timesCreate a PivotTable report manually
4:59 Viewed 507 timesSave, publish, and share
2:22 Viewed 506 timesAdvanced IF functions
3:22 Viewed 505 timesGet going fast
1:38 Viewed 504 timesSort and filter data
1:38 Viewed 503 timesCopy and remove conditional formatting
1:11 Viewed 488 timesCreate a chart
0:52 Viewed 486 timesCONCAT
0:51 Viewed 486 timesAverage a group of numbers
2:01 Viewed 485 timesUse slicers to filter data
1:25 Viewed 460 timesHow to track and monitor values with the Watch Window
2:42 Viewed 456 timesHow things are organized
1:58 Viewed 455 timesConditionally format text
2:12 Viewed 452 timesMap Chart in Excel
0:31 Viewed 451 timesFunnel Chart
0:33 Viewed 451 timesEdit a macro
3:29 Viewed 443 timesSWITCH
1:03 Viewed 443 timesPage numbers in depth
3:06 Viewed 442 timesConditionally format dates
2:38 Viewed 431 timesNested IF functions
3:30 Viewed 429 timesAccessibility in Excel
1:12 Viewed 312 timesCheck Accessibility in Excel
1:51 Viewed 306 timesAutomatic Data Entry in Excel
0:41 Viewed 180 timesIntroduction to Power Query
3:35 Viewed 158 timesIntroduction to Data Visualization
0:58 Viewed 155 timesPower Query overview
3:24 Viewed 149 timesScatter plot
2:27 Viewed 148 timesOverview of Financial Analysis Charts
3:20 Viewed 146 timesBubble chart
2:46 Viewed 144 timesOverview of set and subset graphs
3:47 Viewed 143 timesImport a series of files into a folder
2:58 Viewed 142 timesConvert a timestamp to date
2:41 Viewed 141 timesDelete columns
3:38 Viewed 140 timesRelationship charts between available properties
3:16 Viewed 139 timesCombo chart
2:18 Viewed 134 timesDynamically get today's date
3:34 Viewed 133 timesBoolean logic
3:11 Viewed 133 timesUnderstanding distribution charts for a series of values
8:31 Viewed 132 timesTips and best practices
8:51 Viewed 131 timesDisplay box and whisker diagrams
3:27 Viewed 130 timesCreate a Stock
4:37 Viewed 130 timesReplace values
0:53 Viewed 128 timesCreate a Treemap
3:40 Viewed 128 timesCalculate the number of days between two dates
3:16 Viewed 126 timesGroup by values
2:19 Viewed 123 timesConcatenate text
3:01 Viewed 123 timesRetrieve a set of values from a reference
4:20 Viewed 123 timesStacked Bar Chart
3:29 Viewed 123 timesAdd categories to a scatter plot
1:23 Viewed 123 timesCreate a Waterfall chart
2:26 Viewed 122 timesAdd filters
3:00 Viewed 121 timesDisplay a distribution histogram
2:20 Viewed 120 timesAdd a conditional column
4:52 Viewed 119 timesAreas
4:32 Viewed 119 timesMap
1:47 Viewed 119 timesChange the calculation type on a column
1:55 Viewed 118 timesUse Power Pivot in a PivotTable
2:14 Viewed 118 timesConvert a number of seconds to a time format
1:53 Viewed 118 timesImport options presentation
3:57 Viewed 117 timesSplit a column
3:15 Viewed 116 timesCreate measurement functions
7:52 Viewed 115 timesRemove duplicates
1:48 Viewed 114 timesCreate relationships between tables
6:44 Viewed 114 timesAutomatically add capital letters to text
1:52 Viewed 114 timesThe data analysis cycle
3:37 Viewed 114 timesYour first PivotTable
6:45 Viewed 113 timesThe main principles of data visualization
10:56 Viewed 113 timesRanking charts by importance
4:05 Viewed 113 timesCreate a Sunburst
3:19 Viewed 113 timesMerge two columns
3:27 Viewed 113 timesThe value references of a PivotTable
2:30 Viewed 112 timesImport data from an API
3:59 Viewed 112 timesSwitch values
1:51 Viewed 112 timesBar chart
3:12 Viewed 112 timesAdd a column off an example
2:06 Viewed 111 timesCreate a two-dimensional PivotTable
2:31 Viewed 110 timesAdd slicers
4:43 Viewed 110 timesCalculate the number of characters in a text
1:15 Viewed 110 timesHow to refresh your data after import
1:15 Viewed 109 timesSwitch uppercase, lowercase text
3:42 Viewed 108 timesConvert separate items to date format
1:16 Viewed 108 timesRetrieve unique items from a list
1:26 Viewed 108 timesUse table references
1:39 Viewed 108 timesChange chart type
1:29 Viewed 108 timesSparklines
2:44 Viewed 108 timesRetrieve part of a cell's text from the left or right
4:20 Viewed 107 timesManage multiple values
2:29 Viewed 107 timesThe VLOOKUP function
4:10 Viewed 107 timesLine options
5:07 Viewed 107 timesRadar
4:50 Viewed 107 timesApply multiple conditions on the number of values
2:23 Viewed 106 timesPower Pivot Overview and Installation
1:43 Viewed 106 timesIncrement a one-day date
3:46 Viewed 106 timesBasic conditions
2:45 Viewed 106 timesRefresh a PivotTable
1:58 Viewed 105 timesLogical operators
2:23 Viewed 105 timesRetrieve information from a date
1:34 Viewed 104 timesCalculate the number of values in a series
1:48 Viewed 103 timesCreate a PivotChart
3:29 Viewed 103 timesImport a table into the data model
1:12 Viewed 103 timesRemove unnecessary spaces from text
2:19 Viewed 103 timesConvert separate items to time
1:53 Viewed 103 timesRecreate the coordinates of a cell
3:37 Viewed 103 timesGet the week and weekday number of a date
1:59 Viewed 102 timesDouble conditions
3:50 Viewed 102 timesManage multiple sets of conditions
5:17 Viewed 102 timesCreate your first chart
4:12 Viewed 102 timesPie chart
2:30 Viewed 100 timesSort your data
2:09 Viewed 99 timesImport an Excel file
2:28 Viewed 99 timesRetrieve part of a text in a cell
4:56 Viewed 99 timesIntroduction to PivotTables
2:23 Viewed 98 timesDetermine minimums and maximums based on criteria
1:31 Viewed 97 timesHow to install Power Query
1:25 Viewed 97 timesThe HLOOKUP function
2:20 Viewed 97 timesKnowing the number of numeric values in a column
1:41 Viewed 95 timesFunnel
2:10 Viewed 95 timesCalculate an average based on criteria
2:12 Viewed 94 timesDuplicate a column
2:00 Viewed 94 timesRefer to a table by appying filters and sorts
2:49 Viewed 94 timesCustomize the items displayed on a chart
3:34 Viewed 94 timesCheck the accuracy of two cells
1:40 Viewed 93 timesDelete rows
2:06 Viewed 90 timesChange the order of columns
1:44 Viewed 89 timesReference to an invalid cell
2:31 Viewed 89 timesCreate a two-level entry PivotTable
1:57 Viewed 88 timesAdd segment on PivotCharts
2:06 Viewed 88 timesDetermine minimums and maximums
1:48 Viewed 88 timesAdd a chart to a dedicated sheet
1:30 Viewed 87 timesAvailable trend charts
2:11 Viewed 86 timesChange how values are displayed
2:08 Viewed 82 timesKnow the number of items corresponding to criteria
2:27 Viewed 82 timesFigure too long
1:17 Viewed 82 timesThe Watch Window
2:46 Viewed 82 timesDefinition of statistical metrics
6:32 Viewed 80 timesProblem in cell selection
1:24 Viewed 80 timesKnowing the number of items in a table
2:22 Viewed 79 timesCalculate the standard deviation
1:45 Viewed 79 timesIncompatible cell format
2:48 Viewed 79 timesFind the most present value in a series
0:46 Viewed 78 timesRetrieve the number of empty values in a series
1:46 Viewed 77 timesCalculate a median
1:30 Viewed 77 timesAdd filters on PivotCharts
1:12 Viewed 75 timesInteger number too large
1:42 Viewed 75 timesObtain the numeric coordinates of a cell
3:02 Viewed 73 timesIdentify the presence of an expression in text
2:12 Viewed 70 timesDividing a number by zero
2:19 Viewed 70 timesSearch cannot return a value
2:49 Viewed 67 timesAdd, restore, delete documents on OneDrive
2:02 Viewed 1203 timesSync OneDrive for Business to your computer (Windows 10 - 1709)
2:43 Viewed 1098 timesRecycle bin
0:46 Viewed 901 timesCreate folders to sort your emails
1:38 Viewed 890 timesPlanning meetings
1:57 Viewed 621 timesManaging your teams
1:50 Viewed 618 timesCreating a team and adding members
1:41 Viewed 614 timesInviting outside participants
1:22 Viewed 605 timesCustomising default options
3:28 Viewed 601 timesResponding to an invitation
1:25 Viewed 593 timesDownloading and installing
1:34 Viewed 590 timesCreate and use rules
2:35 Viewed 578 timesObserve your right to disconnect with Insight
2:03 Viewed 573 timesCreating the project tasks
5:18 Viewed 562 timesFill in your work schedules in Outlook
1:29 Viewed 557 timesManaging storage spaces in Teams
1:53 Viewed 551 timesAdding channels and tabs
1:29 Viewed 549 timesDiscovering the interface
4:51 Viewed 545 timesUsing and managing channels and tabs
1:38 Viewed 545 timesClutter
1:31 Viewed 543 timesSet disconnection time
0:31 Viewed 541 timesCreate a meeting within the calendar
1:36 Viewed 540 timesPin your documents to the top of your library list
0:23 Viewed 536 timesVisually highlight some files
0:55 Viewed 530 timesAchieving a first date proposal
4:21 Viewed 523 timesTemporarily turn off notifications
0:23 Viewed 521 timesManage Your Working Time in MyAnalytics
0:34 Viewed 518 timesPin your important files
0:34 Viewed 513 timesCreating a project
3:49 Viewed 511 timesCreate a contact group
1:12 Viewed 510 timesShift and its imbrication with Teams
1:03 Viewed 508 timesSave, publish, and share
2:22 Viewed 506 timesUse tasks in Outlook Web App
2:02 Viewed 505 timesSynchronizing a Library on Your Computer
1:48 Viewed 501 timesManage permissions
1:10 Viewed 499 timesUse flags for your emails
1:23 Viewed 498 timesCreate and assign categories
1:24 Viewed 497 timesProgressive Web Apps
3:11 Viewed 495 timesSave, publish, and share
2:24 Viewed 484 timesCreate a meeting in the group calendar
1:12 Viewed 465 timesCreating Workflows from Scratch
2:58 Viewed 465 timesJoining and managing a meeting
1:18 Viewed 464 timesPublish your Booking page
2:54 Viewed 460 timesIntro to Microsoft To Do Interface
2:41 Viewed 453 timesImmersive Reader
2:51 Viewed 445 timesManage Requests of Holidays and Leaves of Absences
0:58 Viewed 445 timesSchedule sending emails in Outlook
0:54 Viewed 443 timesWhat is Microsoft To Do?
0:45 Viewed 432 timesThe mobile App with Teams
0:48 Viewed 432 timesExtensions
1:31 Viewed 430 timesRemove a member from a group
0:29 Viewed 425 timesEnrich tasks content
5:48 Viewed 419 timesCreating compartments to organise tasks
6:45 Viewed 415 timesRank your custom lists into groups
0:51 Viewed 410 timesManage your availabilities
1:42 Viewed 408 timesCan you disconnect
1:15 Viewed 407 timesCustomising the interface
3:10 Viewed 404 timesCheck your day planning
0:30 Viewed 404 timesCreating Workflows from a Template
5:21 Viewed 401 timesDefining Alerts
2:16 Viewed 397 timesManage the most important tasks
1:38 Viewed 391 timesOrganize your daily tasks
1:56 Viewed 379 timesPlanner Tasks in To Do
1:52 Viewed 376 timesPlan your time away with Viva Insights for Outlook
1:35 Viewed 363 timesRank your custom lists into groups
0:56 Viewed 347 timesCreate a new task in To Do
2:21 Viewed 346 timesPlanner and transverse applications
4:43 Viewed 345 timesIntro to Microsoft To Do on Mobile
2:06 Viewed 342 timesAdvanced tasks
3:18 Viewed 321 timesManage the most important tasks
1:28 Viewed 321 timesOverall view of your licences and subscription
0:46 Viewed 315 timesOutlook tasks in To Do
2:51 Viewed 310 timesDisplaying the progress of your plan
4:17 Viewed 308 timesCreate and share to-do lists with others
2:34 Viewed 308 timesDeleting a task, a compartment or a plan
3:25 Viewed 307 timesThe Outlook tasks in To Do
2:47 Viewed 306 timesFill in your working hours
0:42 Viewed 303 timesAdd dates and deadlines to your tasks
1:17 Viewed 301 timesCreate and share lists with others
2:50 Viewed 299 timesAdd dates and deadlines to your tasks
1:12 Viewed 296 timesOrganize your daily tasks
2:19 Viewed 294 timesInstall Office on your smartphone
1:02 Viewed 292 timesCreate a new task in To Do
2:21 Viewed 289 timesSync OneDrive for Business to your computer (Windows 10 - 1903)
2:33 Viewed 283 timesPlanner Tasks in To Do
1:49 Viewed 279 timesSetting people as important in Viva Insights
0:51 Viewed 278 timesCan you disconnect ?
0:53 Viewed 275 timesRespect your quiet days in Microsoft Viva Insights
1:15 Viewed 273 timesCreate automatic reminders
4:10 Viewed 264 timesChange location where you sync libraries on your computer (Windows 10 - 1903)
2:23 Viewed 252 timesMeeting attendance list
2:40 Viewed 252 timesChange your habits with your activity analysis
1:09 Viewed 239 timesAutomate Teams notifications
3:32 Viewed 207 timesWork with documents in a synced library folder (Windows 10 - 1903)
2:17 Viewed 191 timesDelete columns
3:38 Viewed 140 timesAdd filters
3:00 Viewed 121 timesSplit a column
3:15 Viewed 116 timesRemove duplicates
1:48 Viewed 114 timesMerge two columns
3:27 Viewed 113 timesSort your data
2:09 Viewed 99 timesDuplicate a column
2:00 Viewed 94 timesSave Automatically an attachment
4:32 Viewed 91 timesDelete rows
2:06 Viewed 90 timesChange the order of columns
1:44 Viewed 89 timesAdd filters on PivotCharts
1:12 Viewed 75 timesUnderstanding the new interface
1:30 Viewed 73 timesQuickly find your files
2:07 Viewed 70 timesTake ownership of the taskbar
2:10 Viewed 63 timesAccessibility
1:30 Viewed 64 timesQuick assist
1:29 Viewed 64 timesMake screenshots easier
2:04 Viewed 66 timesSet up widgets
1:28 Viewed 75 timesMake your work environment attractive
1:44 Viewed 65 timesConfigure multiple virtual desktops
1:35 Viewed 77 timesWork on multiple windows
1:21 Viewed 66 timesQuickly find your files
2:07 Viewed 70 timesTake ownership of the taskbar
2:10 Viewed 63 timesUnderstanding the new interface
1:30 Viewed 73 timesViva Connections for your colleague
0:30 Viewed 120 timesDeploy your Viva Connections
2:22 Viewed 80 timesSet up your navigation
0:53 Viewed 69 timesDefine a parent site
1:04 Viewed 133 timesCreate a communication site
0:50 Viewed 122 timesViva Connections in Microsoft Teams
0:58 Viewed 86 timesWhat is Viva Connections?
0:50 Viewed 109 timesThis tutorial is part of the following courses