Tutorial
Drop-down list settings
4:14 Viewed 741 timesInput and error messages
2:52 Viewed 655 timesTake conditional formatting to the next level
3:37 Viewed 601 timesRanking charts by importance
4:05 Viewed 194 timesBar chart
3:12 Viewed 198 timesConditionally format text
2:12 Viewed 533 timesCreate a PivotTable and analyze your data
1:35 Viewed 618 timesCreate a PivotTable report manually
4:59 Viewed 635 timesConvert a picture into Data with Excel
0:25 Viewed 1355 timesCreate a combo chart
1:47 Viewed 1037 times3D Maps
1:41 Viewed 1026 timesThe nuts and bolts of VLOOKUP
3:05 Viewed 962 timesIntroduction to Excel
0:59 Viewed 916 timesAutoFill
2:55 Viewed 899 timesHow to simultaneously edit and calculate formulas across multiple worksheets
3:07 Viewed 840 timesAdvanced formulas and references
4:06 Viewed 826 timesCOUNTIFS and SUMIFS
5:30 Viewed 814 timesCustomize charts
4:28 Viewed 804 timesMAXIFS & MINIFS
1:06 Viewed 794 timesAssign a button to a macro
2:49 Viewed 787 timesThe SUMIF function
5:27 Viewed 779 timesFunctions and formulas
3:24 Viewed 776 timesOperator order
2:04 Viewed 768 timesThe SUM function
4:37 Viewed 752 timesAVERAGEIFS and IFERROR
4:45 Viewed 743 timesDrop-down list settings
4:14 Viewed 741 timesUsing functions
5:12 Viewed 740 timesThree ways to add numbers in Excel Online
3:15 Viewed 737 timesPrint worksheets and workbooks
1:07 Viewed 737 timesCopy a VLOOKUP formula
3:27 Viewed 734 timesTop tips for working in Excel Online
3:35 Viewed 732 timesWork with macros
4:40 Viewed 727 timesManage drop-down lists
6:12 Viewed 726 timesAdd numbers
2:54 Viewed 722 timesPassword protect workbooks and worksheets in detail
6:00 Viewed 722 timesInk Equation
0:41 Viewed 718 timesOne click Forecasting
1:01 Viewed 715 timesFreeze panes in detail
3:30 Viewed 713 timesPassword protect workbooks and worksheets
2:27 Viewed 706 timesImproved version history
0:51 Viewed 705 timesAutoFilter details
3:27 Viewed 704 timesIFS
1:05 Viewed 698 timesSort details
4:46 Viewed 696 timesAdd formulas and references
2:52 Viewed 693 timesMore complex formulas
4:17 Viewed 691 timesLook up values on a different worksheet
2:39 Viewed 689 timesVLOOKUP: How and when to use it
2:38 Viewed 687 timesBasic math
2:28 Viewed 684 timesFreeze or lock panes
1:06 Viewed 676 timesManage conditional formatting
4:30 Viewed 669 timesNew Chart types
1:52 Viewed 668 timesHow to simultaneously view multiple worksheets
3:25 Viewed 667 timesPrint headings, gridlines, formulas, and more
4:29 Viewed 665 timesSave your macro
2:59 Viewed 665 timesHow to use 3-D reference or tridimensional formulas
3:01 Viewed 664 timesUse formulas to apply conditional formatting
4:20 Viewed 663 timesAutoFill and Flash Fill
1:36 Viewed 659 timesInsert headers and footers
2:02 Viewed 658 timesMore print options
5:59 Viewed 658 timesCopying formulas
3:00 Viewed 657 timesInput and error messages
2:52 Viewed 655 timesUse conditional formatting
2:02 Viewed 653 timesShare documents
1:13 Viewed 652 timesStart with "Ideas" in Excel
0:38 Viewed 650 timesHow to link cells and calculate formulas across multiple worksheets
2:10 Viewed 648 timesTranslate your Excel spreadsheets
1:16 Viewed 648 timesCreate pie, bar, and line charts
3:13 Viewed 646 timesPrint a worksheet on a specific number of pages
4:34 Viewed 646 timesAVERAGEIF function
3:04 Viewed 641 timesCell references
1:34 Viewed 641 timesInsert columns and rows
4:16 Viewed 636 timesCreate a PivotTable report manually
4:59 Viewed 635 timesSort, filter, summarize and calculate your PivoteTable data
3:49 Viewed 633 timesCopy a chart
2:59 Viewed 630 timesIF with AND and OR
3:35 Viewed 629 timesSave and print an Excel workbook
1:53 Viewed 627 timesA first look at Excel 2016
3:22 Viewed 622 timesWeighted average
2:06 Viewed 621 timesCreate a PivotTable and analyze your data
1:35 Viewed 618 timesHeader and footer details
3:41 Viewed 616 timesStart using Excel
4:22 Viewed 611 timesFlash Fill
2:59 Viewed 607 timesAverage a group of numbers
2:01 Viewed 606 timesA closer look at the ribbon
3:55 Viewed 602 timesTake conditional formatting to the next level
3:37 Viewed 601 timesDrop-down lists
0:55 Viewed 600 timesCopy and remove conditional formatting
1:11 Viewed 599 timesSubtract time
3:58 Viewed 595 timesCombine data from multiple worksheets
2:50 Viewed 595 timesMicrosoft Search
0:34 Viewed 591 timesHow to create a table
2:11 Viewed 587 timesTEXTJOIN
0:47 Viewed 583 timesAdvanced IF functions
3:22 Viewed 581 timesWork simultaneously with others on a workbook
0:43 Viewed 577 timesSort and filter data
1:38 Viewed 576 timesAdvanced filter details
4:13 Viewed 567 timesGet going fast
1:38 Viewed 561 timesSave, publish, and share
2:22 Viewed 554 timesUse slicers to filter data
1:25 Viewed 554 timesHow to track and monitor values with the Watch Window
2:42 Viewed 542 timesEdit a macro
3:29 Viewed 541 timesConditionally format dates
2:38 Viewed 536 timesCONCAT
0:51 Viewed 536 timesConditionally format text
2:12 Viewed 533 timesHow things are organized
1:58 Viewed 517 timesMap Chart in Excel
0:31 Viewed 508 timesFunnel Chart
0:33 Viewed 503 timesSWITCH
1:03 Viewed 500 timesPage numbers in depth
3:06 Viewed 491 timesNested IF functions
3:30 Viewed 480 timesAccessibility in Excel
1:12 Viewed 369 timesCheck Accessibility in Excel
1:51 Viewed 355 timesAutomatic Data Entry in Excel
0:41 Viewed 256 timesConvert a timestamp to date
2:41 Viewed 250 timesIntroduction to Power Query
3:35 Viewed 249 timesBubble chart
2:46 Viewed 245 timesAdd filters
3:00 Viewed 238 timesScatter plot
2:27 Viewed 236 timesBoolean logic
3:11 Viewed 227 timesDynamically get today's date
3:34 Viewed 224 timesDisplay box and whisker diagrams
3:27 Viewed 221 timesCreate a Waterfall chart
2:26 Viewed 219 timesSwitch values
1:51 Viewed 218 timesThe data analysis cycle
3:37 Viewed 216 timesPower Query overview
3:24 Viewed 211 timesReplace values
0:53 Viewed 210 timesCreate measurement functions
7:52 Viewed 210 timesManage multiple sets of conditions
5:17 Viewed 210 timesUse Power Pivot in a PivotTable
2:14 Viewed 209 timesConvert a number of seconds to a time format
1:53 Viewed 209 timesAdd categories to a scatter plot
1:23 Viewed 209 timesDisplay a distribution histogram
2:20 Viewed 209 timesChange the calculation type on a column
1:55 Viewed 208 timesGroup by values
2:19 Viewed 208 timesRelationship charts between available properties
3:16 Viewed 208 timesDelete columns
3:38 Viewed 207 timesManage multiple values
2:29 Viewed 207 timesChange chart type
1:29 Viewed 205 timesApply multiple conditions on the number of values
2:23 Viewed 204 timesIntroduction to Data Visualization
0:58 Viewed 204 timesOverview of set and subset graphs
3:47 Viewed 204 timesAreas
4:32 Viewed 203 timesHow to refresh your data after import
1:15 Viewed 202 timesConvert separate items to date format
1:16 Viewed 202 timesCreate a Sunburst
3:19 Viewed 202 timesOverview of Financial Analysis Charts
3:20 Viewed 202 timesAutomatically add capital letters to text
1:52 Viewed 200 timesRemove unnecessary spaces from text
2:19 Viewed 200 timesAdd slicers
4:43 Viewed 199 timesCreate a PivotChart
3:29 Viewed 198 timesBasic conditions
2:45 Viewed 198 timesRetrieve unique items from a list
1:26 Viewed 198 timesBar chart
3:12 Viewed 198 timesThe value references of a PivotTable
2:30 Viewed 197 timesImport data from an API
3:59 Viewed 197 timesUse table references
1:39 Viewed 197 timesStacked Bar Chart
3:29 Viewed 197 timesCreate relationships between tables
6:44 Viewed 195 timesAdd a conditional column
4:52 Viewed 194 timesCustomize the items displayed on a chart
3:34 Viewed 194 timesRanking charts by importance
4:05 Viewed 194 timesCreate a Stock
4:37 Viewed 194 timesCreate a two-dimensional PivotTable
2:31 Viewed 193 timesRetrieve part of a cell's text from the left or right
4:20 Viewed 193 timesRecreate the coordinates of a cell
3:37 Viewed 193 timesTips and best practices
8:51 Viewed 193 timesCalculate the number of days between two dates
3:16 Viewed 192 timesUnderstanding distribution charts for a series of values
8:31 Viewed 192 timesCombo chart
2:18 Viewed 192 timesYour first PivotTable
6:45 Viewed 191 timesImport a series of files into a folder
2:58 Viewed 190 timesGet the week and weekday number of a date
1:59 Viewed 190 timesThe VLOOKUP function
4:10 Viewed 190 timesMap
1:47 Viewed 189 timesCreate a Treemap
3:40 Viewed 185 timesImport a table into the data model
1:12 Viewed 184 timesMerge two columns
3:27 Viewed 184 timesIntroduction to PivotTables
2:23 Viewed 183 timesSplit a column
3:15 Viewed 180 timesAdd segment on PivotCharts
2:06 Viewed 178 timesIncrement a one-day date
3:46 Viewed 178 timesConcatenate text
3:01 Viewed 177 timesLogical operators
2:23 Viewed 177 timesImport an Excel file
2:28 Viewed 176 timesRadar
4:50 Viewed 174 timesRetrieve a set of values from a reference
4:20 Viewed 173 timesDetermine minimums and maximums based on criteria
1:31 Viewed 171 timesRetrieve part of a text in a cell
4:56 Viewed 171 timesRefresh a PivotTable
1:58 Viewed 170 timesRemove duplicates
1:48 Viewed 169 timesAdd a column off an example
2:06 Viewed 169 timesImport options presentation
3:57 Viewed 168 timesLine options
5:07 Viewed 168 timesConvert separate items to time
1:53 Viewed 167 timesCalculate the number of characters in a text
1:15 Viewed 166 timesCreate your first chart
4:12 Viewed 165 timesFunnel
2:10 Viewed 165 timesThe HLOOKUP function
2:20 Viewed 164 timesRetrieve information from a date
1:34 Viewed 163 timesDouble conditions
3:50 Viewed 163 timesThe main principles of data visualization
10:56 Viewed 163 timesRefer to a table by appying filters and sorts
2:49 Viewed 162 timesSwitch uppercase, lowercase text
3:42 Viewed 160 timesSparklines
2:44 Viewed 160 timesPie chart
2:30 Viewed 158 timesCalculate the number of values in a series
1:48 Viewed 157 timesPower Pivot Overview and Installation
1:43 Viewed 156 timesDuplicate a column
2:00 Viewed 154 timesDetermine minimums and maximums
1:48 Viewed 153 timesAdd a chart to a dedicated sheet
1:30 Viewed 153 timesSort your data
2:09 Viewed 149 timesCreate a two-level entry PivotTable
1:57 Viewed 149 timesDefinition of statistical metrics
6:32 Viewed 147 timesHow to install Power Query
1:25 Viewed 144 timesAvailable trend charts
2:11 Viewed 139 timesChange the order of columns
1:44 Viewed 138 timesCalculate an average based on criteria
2:12 Viewed 137 timesCheck the accuracy of two cells
1:40 Viewed 137 timesKnowing the number of numeric values in a column
1:41 Viewed 136 timesDelete rows
2:06 Viewed 133 timesChange the format of a column
1:20 Viewed 132 timesReference to an invalid cell
2:31 Viewed 131 timesChange how values are displayed
2:08 Viewed 129 timesKnow the number of items corresponding to criteria
2:27 Viewed 129 timesIncompatible cell format
2:48 Viewed 129 timesFigure too long
1:17 Viewed 129 timesCalculate a median
1:30 Viewed 127 timesProblem in cell selection
1:24 Viewed 127 timesThe Watch Window
2:46 Viewed 124 timesKnowing the number of items in a table
2:22 Viewed 121 timesIdentify the presence of an expression in text
2:12 Viewed 120 timesFind the most present value in a series
0:46 Viewed 118 timesAdd filters on PivotCharts
1:12 Viewed 117 timesCalculate the standard deviation
1:45 Viewed 115 timesDividing a number by zero
2:19 Viewed 113 timesInteger number too large
1:42 Viewed 112 timesObtain the numeric coordinates of a cell
3:02 Viewed 111 timesRetrieve the number of empty values in a series
1:46 Viewed 109 timesSearch cannot return a value
2:49 Viewed 101 timesXLOOKUP (Basic metrics)
4:19 Viewed 48 timesText before & after Function
4:57 Viewed 47 timesXLOOKUP (Advanced metrics)
9:30 Viewed 36 timesInsert an image in a cell with image function
3:01 Viewed 32 timesCreate dynamic drop down lists
3:26 Viewed 21 timesCreate dynamic drop down lists
3:26 Viewed 21 timesInsert an image in a cell with image function
3:01 Viewed 32 timesAdding a shared channel in Teams
1:45 Viewed 24 timesText before & after Function
4:57 Viewed 47 timesXLOOKUP (Advanced metrics)
9:30 Viewed 36 timesXLOOKUP (Basic metrics)
4:19 Viewed 48 timesAccessibility
1:30 Viewed 115 timesQuick assist
1:29 Viewed 103 timesMake screenshots easier
2:04 Viewed 106 timesSet up widgets
1:28 Viewed 125 timesMake your work environment attractive
1:44 Viewed 108 timesConfigure multiple virtual desktops
1:35 Viewed 130 timesWork on multiple windows
1:21 Viewed 109 timesQuickly find your files
2:07 Viewed 137 timesTake ownership of the taskbar
2:10 Viewed 125 timesUnderstanding the new interface
1:30 Viewed 118 timesViva Connections for your colleague
0:30 Viewed 174 timesDeploy your Viva Connections
2:22 Viewed 135 timesSet up your navigation
0:53 Viewed 111 timesDefine a parent site
1:04 Viewed 189 timesCreate a communication site
0:50 Viewed 173 timesViva Connections in Microsoft Teams
0:58 Viewed 139 timesWhat is Viva Connections?
0:50 Viewed 192 timesThis tutorial is part of the following courses