Microsoft Excel Video Training – Intermediate
Through a logical progression of video tutorials, discover the intermediate features of Microsoft Excel: Create summaries, enhance the results, analyze with functions, ...
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 179 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 132 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 129 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 timesConvert a number of seconds to a time format
1:53 Viewed 118 timesImport options presentation
3:57 Viewed 117 timesUse Power Pivot in a PivotTable
2:14 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 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 timesCalculate the number of values in a series
1:48 Viewed 103 timesImport a table into the data model
1:12 Viewed 103 timesRemove unnecessary spaces from text
2:19 Viewed 103 timesRetrieve information from a date
1:34 Viewed 103 timesConvert separate items to time
1:53 Viewed 103 timesRecreate the coordinates of a cell
3:37 Viewed 103 timesCreate a PivotChart
3:29 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 timesGet the week and weekday number of a date
1:59 Viewed 101 timesPie chart
2:30 Viewed 100 timesSort your data
2:09 Viewed 99 timesRetrieve part of a text in a cell
4:56 Viewed 99 timesIntroduction to PivotTables
2:23 Viewed 98 timesImport an Excel file
2:28 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 timesFunnel
2:10 Viewed 95 timesKnowing the number of numeric values in a column
1:41 Viewed 94 timesCalculate an average based on criteria
2:12 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 timesDuplicate a column
2:00 Viewed 93 timesChange the format of a column
1:20 Viewed 93 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 87 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 timesCreating a Report
2:54 Viewed 593 timesCreating and configuring a Dashboard
2:50 Viewed 569 timesCreate a PivotTable and analyze your data
1:35 Viewed 553 timesRecovering your Data from different sources
3:26 Viewed 546 timesPreparing, cleaning and transforming your Data
4:42 Viewed 543 timesSort, filter, summarize and calculate your PivoteTable data
3:49 Viewed 538 timesPublishing your Report through the Power BI Service
2:59 Viewed 537 timesIntroduction to the Query Editor
2:33 Viewed 516 timesImproved version history
0:51 Viewed 511 timesCreate a PivotTable report manually
4:59 Viewed 507 timesCustomising your Visuals
2:58 Viewed 495 timesCreating your Datasets
2:26 Viewed 481 timesSharing and publishing your Dashboard
3:43 Viewed 472 timesCustomising your Report
3:12 Viewed 460 timesHow to track and monitor values with the Watch Window
2:42 Viewed 456 timesConsulting and using a Dashboard
3:08 Viewed 451 timesManipulating tiles in a Dashboard
3:26 Viewed 392 timesReceive an email summary of Viva Insights' recommendations
0:55 Viewed 223 timesManage life cycle of a topic
1:44 Viewed 210 timesKnowing the number of numeric values in a column
1:41 Viewed 94 timesCalculate an average based on criteria
2:12 Viewed 94 timesCheck the accuracy of two cells
1:40 Viewed 93 timesReference to an invalid cell
2:31 Viewed 89 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 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 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 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