title
How to Filter in Excel

description
In this step-by-step tutorial, learn how you can use filtering in Microsoft Excel. In this video, I walk through the following: 0:00 Introduction 0:53 Basic Filtering 11:23 Advanced Filtering 13:29 The new Filter Function - Learn the fundamentals of Excel in just 2 hours: https://kevinstratvert.thinkific.com You can find my sample data in the following spreadsheet: https://1drv.ms/x/s!AmxrofZZlZ-whJEowRdyrcexhOtHKA?e=WUQPtk Watch all my Excel tutorial videos here: https://www.youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY As full disclosure, I work at Microsoft as a full-time employee.

detail
{'title': 'How to Filter in Excel', 'heatmap': [{'end': 168.047, 'start': 154.918, 'weight': 0.743}, {'end': 188.975, 'start': 175.27, 'weight': 0.722}, {'end': 778.969, 'start': 748.365, 'weight': 0.75}, {'end': 923.837, 'start': 833.942, 'weight': 0.844}], 'summary': "Learn basic and advanced excel filtering techniques using a 'kevin's cookie company' dataset, mastering data filtering through methods like pivot tables and ribbon controls, and enabling targeted decision-making with number and date filters for microsoft 365 users.", 'chapters': [{'end': 111.284, 'segs': [{'end': 41.259, 'src': 'embed', 'start': 0.089, 'weight': 0, 'content': [{'end': 2.11, 'text': 'Hi everyone, my name is Kevin.', 'start': 0.089, 'duration': 2.021}, {'end': 7.394, 'text': 'Today I want to show you how you can filter in Microsoft Excel.', 'start': 2.231, 'duration': 5.163}, {'end': 13.899, 'text': "We're going to start off with the basics of filtering, then we're going to jump into more advanced filtering and then, for fun,", 'start': 7.714, 'duration': 6.185}, {'end': 20.823, 'text': "at the end we're going to finish off with a brand new function that's coming out called none other than the filter function.", 'start': 13.899, 'duration': 6.924}, {'end': 28.049, 'text': 'If you watch this entire video from end to end, you will be a master at filtering in Microsoft Excel.', 'start': 21.784, 'duration': 6.265}, {'end': 34.354, 'text': 'And as full disclosure, before we jump into this, my HR department requires me to say it, I work at Microsoft as a full-time employee.', 'start': 28.409, 'duration': 5.945}, {'end': 41.259, 'text': "And also today I'm using the latest and greatest version of Microsoft Excel that comes with Microsoft 365.", 'start': 34.674, 'duration': 6.585}], 'summary': 'Kevin demonstrates filtering in microsoft excel, covering basics and advanced techniques, concluding with a new filter function, aiming to make viewers masters at filtering in excel.', 'duration': 41.17, 'max_score': 0.089, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/BtiVbY7lhqw/pics/BtiVbY7lhqw89.jpg'}, {'end': 111.284, 'src': 'embed', 'start': 76.827, 'weight': 1, 'content': [{'end': 82.45, 'text': "I figured if I'm going to set up a fictional company, I might as well do it on something that I'm passionate about and I really love cookies.", 'start': 76.827, 'duration': 5.623}, {'end': 84.571, 'text': "So I figured that'd be a good way to go.", 'start': 82.75, 'duration': 1.821}, {'end': 90.253, 'text': 'Now, just to orient you to the data that we have here on the sheet, we have store numbers.', 'start': 85.071, 'duration': 5.182}, {'end': 93.034, 'text': 'So for my cookie company, we have 15 different locations.', 'start': 90.293, 'duration': 2.741}, {'end': 97.957, 'text': "They're located in a variety of different states and then they have a certain amount of revenue.", 'start': 93.074, 'duration': 4.883}, {'end': 101.458, 'text': 'They have certain expenses and then we could see the profit.', 'start': 97.997, 'duration': 3.461}, {'end': 103.779, 'text': 'So this is just the revenue minus the expenses.', 'start': 101.478, 'duration': 2.301}, {'end': 105.32, 'text': "That's how much the store made.", 'start': 103.839, 'duration': 1.481}, {'end': 110.224, 'text': 'And as you can see, some locations are profitable and some locations have lost money.', 'start': 105.64, 'duration': 4.584}, {'end': 111.284, 'text': "That's not a great thing.", 'start': 110.284, 'duration': 1}], 'summary': 'Fictional cookie company with 15 locations, some profitable, some lost money.', 'duration': 34.457, 'max_score': 76.827, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/BtiVbY7lhqw/pics/BtiVbY7lhqw76827.jpg'}], 'start': 0.089, 'title': 'Mastering filtering in excel', 'summary': "Covers basic and advanced filtering techniques in microsoft excel, along with a new function, using a sample data set from 'kevin's cookie company,' promising mastery in filtering.", 'chapters': [{'end': 111.284, 'start': 0.089, 'title': 'Filtering in microsoft excel', 'summary': "Covers the basics and advanced techniques of filtering in microsoft excel, along with a new function, promising mastery in filtering, using a sample data set from a fictional company, 'kevin's cookie company.'", 'duration': 111.195, 'highlights': ['The chapter covers the basics and advanced techniques of filtering in Microsoft Excel. The chapter provides a comprehensive overview of filtering techniques in Microsoft Excel.', "The fictional company, 'Kevin's Cookie Company,' has 15 different locations with varying revenue and expenses. The data includes 15 store locations with diverse financial performance.", 'Some store locations are profitable while others have incurred losses. The data reveals varying financial performance across different store locations.', 'The chapter introduces a new function called the filter function. The chapter presents a new filtering function called the filter function.']}], 'duration': 111.195, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/BtiVbY7lhqw/pics/BtiVbY7lhqw89.jpg', 'highlights': ['The chapter covers the basics and advanced techniques of filtering in Microsoft Excel.', "The fictional company, 'Kevin's Cookie Company,' has 15 different locations with varying revenue and expenses.", 'The data includes 15 store locations with diverse financial performance.', 'The chapter introduces a new function called the filter function.']}, {'end': 423.874, 'segs': [{'end': 160.782, 'src': 'embed', 'start': 131.22, 'weight': 4, 'content': [{'end': 135.243, 'text': "One of them is you wanna set up your data so it's in a table.", 'start': 131.22, 'duration': 4.023}, {'end': 136.664, 'text': 'So how do we get a table?', 'start': 135.363, 'duration': 1.301}, {'end': 144.891, 'text': "Well, what we could do is if we go up to the top bar here and we click on the insert pivot, there's an option to turn this into a table.", 'start': 136.985, 'duration': 7.906}, {'end': 150.375, 'text': "Now what you could see as I'm hovering over, you also see that the shortcut key is control T.", 'start': 145.291, 'duration': 5.084}, {'end': 154.638, 'text': 'If you press control T, that will also turn this data into a table.', 'start': 150.375, 'duration': 4.263}, {'end': 160.782, 'text': 'So let me just go ahead and click on this button and I get this prompt here that says where is the data for your table?', 'start': 154.918, 'duration': 5.864}], 'summary': 'Convert data into a table using insert pivot or control t shortcut.', 'duration': 29.562, 'max_score': 131.22, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/BtiVbY7lhqw/pics/BtiVbY7lhqw131220.jpg'}, {'end': 185.253, 'src': 'heatmap', 'start': 154.918, 'weight': 0.743, 'content': [{'end': 160.782, 'text': 'So let me just go ahead and click on this button and I get this prompt here that says where is the data for your table?', 'start': 154.918, 'duration': 5.864}, {'end': 168.047, 'text': 'Well, since I had my selection within the area of the table, Excel assumes that this is my table, and it assumed correctly.', 'start': 160.822, 'duration': 7.225}, {'end': 173.909, 'text': 'Also, when I look at this, my table has headers, store number, state, revenue, expenses, profit lot.', 'start': 168.567, 'duration': 5.342}, {'end': 175.19, 'text': 'These are all my headers here.', 'start': 173.929, 'duration': 1.261}, {'end': 178.611, 'text': "So I'm going to check that box and I'm going to click on OK.", 'start': 175.27, 'duration': 3.341}, {'end': 185.253, 'text': "Now this turns my data into a table and you'll see here that I have these drop down icons that appear.", 'start': 179.031, 'duration': 6.222}], 'summary': 'Excel converted data to a table with headers including store number, state, revenue, expenses, and profit.', 'duration': 30.335, 'max_score': 154.918, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/BtiVbY7lhqw/pics/BtiVbY7lhqw154918.jpg'}, {'end': 205.908, 'src': 'heatmap', 'start': 175.27, 'weight': 0.722, 'content': [{'end': 178.611, 'text': "So I'm going to check that box and I'm going to click on OK.", 'start': 175.27, 'duration': 3.341}, {'end': 185.253, 'text': "Now this turns my data into a table and you'll see here that I have these drop down icons that appear.", 'start': 179.031, 'duration': 6.222}, {'end': 186.494, 'text': 'These are different.', 'start': 185.714, 'duration': 0.78}, {'end': 188.975, 'text': 'This is how I can apply filtering to my data.', 'start': 186.554, 'duration': 2.421}, {'end': 193.598, 'text': "Now I'm going to go back for a moment because I said I would show two different ways to filter my data.", 'start': 189.395, 'duration': 4.203}, {'end': 199.523, 'text': 'The other way I can do it is I go to the data pivot up on top on the ribbon in Excel.', 'start': 194.019, 'duration': 5.504}, {'end': 205.908, 'text': 'And then within here, if I go over to the sort and filter category, I see an option for filtering.', 'start': 199.883, 'duration': 6.025}], 'summary': 'Converting data to a table enables applying filtering in excel.', 'duration': 30.638, 'max_score': 175.27, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/BtiVbY7lhqw/pics/BtiVbY7lhqw175270.jpg'}, {'end': 222.143, 'src': 'embed', 'start': 194.019, 'weight': 0, 'content': [{'end': 199.523, 'text': 'The other way I can do it is I go to the data pivot up on top on the ribbon in Excel.', 'start': 194.019, 'duration': 5.504}, {'end': 205.908, 'text': 'And then within here, if I go over to the sort and filter category, I see an option for filtering.', 'start': 199.883, 'duration': 6.025}, {'end': 210.112, 'text': 'And once again, as I hover over, you could see what the shortcut key is.', 'start': 206.548, 'duration': 3.564}, {'end': 215.256, 'text': "It's control shift L, and this will also allow me to filter my data.", 'start': 210.172, 'duration': 5.084}, {'end': 215.957, 'text': "So I'm going to go ahead.", 'start': 215.276, 'duration': 0.681}, {'end': 217.218, 'text': "Let's click on filter here.", 'start': 215.997, 'duration': 1.221}, {'end': 222.143, 'text': "And just like with a table, you'll see these similar icons here that allow me to filter.", 'start': 217.579, 'duration': 4.564}], 'summary': 'Use excel shortcut control shift l to filter data in pivot table.', 'duration': 28.124, 'max_score': 194.019, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/BtiVbY7lhqw/pics/BtiVbY7lhqw194019.jpg'}, {'end': 371.636, 'src': 'embed', 'start': 331.962, 'weight': 1, 'content': [{'end': 338.71, 'text': "What's interesting is not only can I select items here, not only can I search for items, but you'll also see this option that says text filters.", 'start': 331.962, 'duration': 6.748}, {'end': 343.256, 'text': "Let me click on that and I'll show you how you could filter based on text using Excel.", 'start': 338.75, 'duration': 4.506}, {'end': 350.121, 'text': 'So here within the submenu, you could search for text that equals something, does not equal something, begins with, ends with, contains.', 'start': 343.696, 'duration': 6.425}, {'end': 353.743, 'text': 'So you have lots of power over how you filter for text.', 'start': 350.461, 'duration': 3.282}, {'end': 357.106, 'text': "So let's say I wanted to look at all states that start with an N.", 'start': 354.083, 'duration': 3.023}, {'end': 364.791, 'text': "I could say begins with and then I could type in an N and I'll click on OK and this will give me New York and New Jersey.", 'start': 357.106, 'duration': 7.685}, {'end': 368.053, 'text': 'So another way where I could filter based on text.', 'start': 364.871, 'duration': 3.182}, {'end': 371.636, 'text': "Now what I'm going to do, I'm going to go ahead, let's clear this filter from here.", 'start': 368.553, 'duration': 3.083}], 'summary': 'Excel offers powerful text filtering options, allowing users to search and filter text based on specific criteria, such as starting with a certain letter, providing flexibility and efficiency in data analysis.', 'duration': 39.674, 'max_score': 331.962, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/BtiVbY7lhqw/pics/BtiVbY7lhqw331962.jpg'}, {'end': 412.65, 'src': 'embed', 'start': 386.322, 'weight': 3, 'content': [{'end': 393.845, 'text': "So I'm going to highlight all those colors because I had a conversation with those store managers and maybe I want to follow up with them on how they're performing.", 'start': 386.322, 'duration': 7.523}, {'end': 398.046, 'text': "let's say that I just want to view these locations that I highlighted.", 'start': 394.665, 'duration': 3.381}, {'end': 403.007, 'text': "What I'm going to do is I'll click on this dropdown and then I can go down to filter by color.", 'start': 398.306, 'duration': 4.701}, {'end': 408.589, 'text': "And here I could filter by yellow, the color I just highlighted with, and there you'll see my selection.", 'start': 403.127, 'duration': 5.462}, {'end': 412.65, 'text': 'Now I could highlight any color and I could apply filters based on any colors I want.', 'start': 408.629, 'duration': 4.021}], 'summary': 'Store manager conversation highlights color filter functionality for performance tracking.', 'duration': 26.328, 'max_score': 386.322, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/BtiVbY7lhqw/pics/BtiVbY7lhqw386322.jpg'}], 'start': 111.645, 'title': 'Excel data filtering techniques', 'summary': "Demonstrates two methods for filtering data in excel, including converting data into a table using 'insert pivot' or pressing control t, and accessing the filter option through the data pivot on the ribbon by pressing control shift l. it also explains how to filter data in excel by state, using search to filter specific states, filtering based on text, and filtering by color to quickly view highlighted locations.", 'chapters': [{'end': 234.627, 'start': 111.645, 'title': 'Excel data filtering techniques', 'summary': "Demonstrates two methods for filtering data in excel: converting data into a table by using the 'insert pivot' option or pressing control t, and accessing the filter option through the data pivot on the ribbon by pressing control shift l.", 'duration': 122.982, 'highlights': ["The chapter demonstrates two methods for filtering data in Excel. The speaker explains two ways to filter data in Excel: converting data into a table using the 'insert pivot' option or pressing control T, and accessing the filter option through the data pivot on the ribbon by pressing control shift L.", "Converting data into a table using the 'insert pivot' option or pressing control T. The speaker explains that data can be turned into a table by using the 'insert pivot' option or pressing control T, which prompts a prompt for the data selection and turns it into a table with headers and drop-down icons for filtering.", 'Accessing the filter option through the data pivot on the ribbon by pressing control shift L. The speaker demonstrates that the filter option can be accessed through the data pivot on the ribbon in Excel by pressing control shift L, which provides similar filter dropdown icons as in a table for data filtering.']}, {'end': 423.874, 'start': 234.927, 'title': 'Excel data filtering', 'summary': 'Demonstrates how to filter data in excel, including filtering by state, using search to filter specific states, filtering based on text, and filtering by color to quickly view highlighted locations.', 'duration': 188.947, 'highlights': ['The chapter explains how to filter data by state, demonstrating the process of filtering for New Jersey locations and how to filter for multiple states, showcasing a quick and efficient way to analyze specific locations.', 'The speaker shows how to utilize search to filter for specific states in Excel, providing a practical method for narrowing down data and enhancing efficiency in data analysis.', 'The tutorial highlights the process of filtering data based on text in Excel, including filtering for states that start with a specific letter, showcasing the extensive capabilities for text-based filtering in Excel.', 'The tutorial demonstrates how to filter data by color in Excel, allowing users to quickly view and analyze data based on highlighted locations, providing a convenient feature for tracking and following up on specific store managers or locations.']}], 'duration': 312.229, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/BtiVbY7lhqw/pics/BtiVbY7lhqw111645.jpg', 'highlights': ["The chapter demonstrates two methods for filtering data in Excel, including converting data into a table using the 'insert pivot' option or pressing control T, and accessing the filter option through the data pivot on the ribbon by pressing control shift L.", 'The tutorial demonstrates how to filter data by state, showcasing a quick and efficient way to analyze specific locations and utilize search to filter for specific states in Excel.', 'The tutorial highlights the process of filtering data based on text in Excel, including filtering for states that start with a specific letter, showcasing the extensive capabilities for text-based filtering in Excel.', 'The tutorial demonstrates how to filter data by color in Excel, allowing users to quickly view and analyze data based on highlighted locations, providing a convenient feature for tracking and following up on specific store managers or locations.', "Converting data into a table using the 'insert pivot' option or pressing control T, which prompts a prompt for the data selection and turns it into a table with headers and drop-down icons for filtering.", 'Accessing the filter option through the data pivot on the ribbon by pressing control shift L, which provides similar filter dropdown icons as in a table for data filtering.']}, {'end': 981.005, 'segs': [{'end': 463.419, 'src': 'embed', 'start': 439.301, 'weight': 4, 'content': [{'end': 446.807, 'text': 'So what I could do is when I click on this filter, what I can do is I can filter it down to just the locations that have lost money.', 'start': 439.301, 'duration': 7.506}, {'end': 453.693, 'text': 'So maybe I need to follow up with these locations, maybe give some additional training, or maybe I even consider closing some of these locations,', 'start': 446.867, 'duration': 6.826}, {'end': 457.496, 'text': 'since they seem to be losing money and some of these have been open for a while.', 'start': 453.693, 'duration': 3.803}, {'end': 463.419, 'text': "So what I'm going to do is I'm going to click on the filter again and we have a section here called number filters.", 'start': 457.876, 'duration': 5.543}], 'summary': 'Filter locations losing money for potential action and follow-up.', 'duration': 24.118, 'max_score': 439.301, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/BtiVbY7lhqw/pics/BtiVbY7lhqw439301.jpg'}, {'end': 533.707, 'src': 'embed', 'start': 509.81, 'weight': 3, 'content': [{'end': 517.818, 'text': "So I'm going to click on top 10 and what you could do here is not only can you look at the top locations, you could also look at the bottom locations.", 'start': 509.81, 'duration': 8.008}, {'end': 520.861, 'text': 'So here, maybe I want to just look at the bottom three locations.', 'start': 517.878, 'duration': 2.983}, {'end': 522.381, 'text': 'across all states.', 'start': 521.341, 'duration': 1.04}, {'end': 530.306, 'text': 'I can look at the bottom three items, just the bottom absolute three or you could even say, hey, I want to see the bottom 10% or the bottom 20%.', 'start': 522.802, 'duration': 7.504}, {'end': 533.707, 'text': 'So you have some power here in terms of how you view your data.', 'start': 530.306, 'duration': 3.401}], 'summary': 'Analyzing locations based on top and bottom percentages across all states.', 'duration': 23.897, 'max_score': 509.81, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/BtiVbY7lhqw/pics/BtiVbY7lhqw509810.jpg'}, {'end': 603.816, 'src': 'embed', 'start': 569.119, 'weight': 2, 'content': [{'end': 573.28, 'text': "and you'll see that it starts from just days to weeks to months to quarters and then years.", 'start': 569.119, 'duration': 4.161}, {'end': 577.961, 'text': 'And so I could click on last year and here I had two locations that opened last year.', 'start': 573.32, 'duration': 4.641}, {'end': 580.462, 'text': 'So quick way just to filter down to that.', 'start': 577.981, 'duration': 2.481}, {'end': 582.282, 'text': 'What I can also do here.', 'start': 581.222, 'duration': 1.06}, {'end': 588.244, 'text': "I'm gonna go back to date filters and I could even say after, let's say I wanna see locations maybe opened.", 'start': 582.282, 'duration': 5.962}, {'end': 591.445, 'text': "after, let's say, 2010,, I could go ahead, filter that.", 'start': 588.244, 'duration': 3.201}, {'end': 594.125, 'text': 'And here are all my locations that opened after 2010.', 'start': 591.725, 'duration': 2.4}, {'end': 603.816, 'text': "With filters, What I've shown so far is how you filter individual columns on their own, but you can also apply multiple filters at the same time.", 'start': 594.125, 'duration': 9.691}], 'summary': 'The speaker demonstrates filtering data by date, showing locations opened after 2010.', 'duration': 34.697, 'max_score': 569.119, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/BtiVbY7lhqw/pics/BtiVbY7lhqw569119.jpg'}, {'end': 778.969, 'src': 'heatmap', 'start': 748.365, 'weight': 0.75, 'content': [{'end': 757.49, 'text': 'Now one thing to call out before I do this for the criteria range the header of the criteria range has to match one of the headers of your list range.', 'start': 748.365, 'duration': 9.125}, {'end': 764.194, 'text': 'In this case, I have the store number header in my criteria range and it matches this store number header over here in my list range.', 'start': 757.53, 'duration': 6.664}, {'end': 769.74, 'text': "So let's go ahead, I'm gonna select all these store numbers and now I'm gonna click on okay.", 'start': 764.614, 'duration': 5.126}, {'end': 774.505, 'text': "And what you'll see happened is it filtered down to store one, five, 13 and 15.", 'start': 769.9, 'duration': 4.605}, {'end': 778.969, 'text': 'It was all the same numbers that I had in this advanced range over here.', 'start': 774.505, 'duration': 4.464}], 'summary': 'Filtered store numbers to 1, 5, 13, and 15 based on matching criteria.', 'duration': 30.604, 'max_score': 748.365, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/BtiVbY7lhqw/pics/BtiVbY7lhqw748365.jpg'}, {'end': 806.53, 'src': 'embed', 'start': 779.915, 'weight': 1, 'content': [{'end': 785.578, 'text': "Now, if I click on clear, this now will remove the filtering again and I'm back to where I started from.", 'start': 779.915, 'duration': 5.663}, {'end': 787.219, 'text': 'What you can do is here.', 'start': 786.039, 'duration': 1.18}, {'end': 791.742, 'text': 'in this example, I simply showed how you can do advanced filtering based on one column,', 'start': 787.219, 'duration': 4.523}, {'end': 797.186, 'text': 'but you could have two columns or three columns any number of columns and you could use that as your criteria range.', 'start': 791.742, 'duration': 5.444}, {'end': 804.189, 'text': 'The one thing to keep in mind is that the column header here in the criteria range, has to match the column headers of the list range.', 'start': 797.486, 'duration': 6.703}, {'end': 806.53, 'text': 'That is advanced filtering.', 'start': 804.809, 'duration': 1.721}], 'summary': 'Demonstrated advanced filtering based on one column in excel.', 'duration': 26.615, 'max_score': 779.915, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/BtiVbY7lhqw/pics/BtiVbY7lhqw779915.jpg'}, {'end': 923.837, 'src': 'heatmap', 'start': 833.942, 'weight': 0.844, 'content': [{'end': 836.203, 'text': 'Well, with the filter function, I can do that.', 'start': 833.942, 'duration': 2.261}, {'end': 839.445, 'text': 'So let me show you how you can use the filter function.', 'start': 836.583, 'duration': 2.862}, {'end': 842.767, 'text': "And to do that, I'm going to go up here to insert function.", 'start': 839.485, 'duration': 3.282}, {'end': 846.208, 'text': "So I'm gonna click on this and now I'm gonna search for a filter.", 'start': 843.447, 'duration': 2.761}, {'end': 850.15, 'text': "This is a new function that's available to Microsoft 365 customers.", 'start': 846.528, 'duration': 3.622}, {'end': 855.272, 'text': "If you're not a Microsoft 365 customer, unfortunately you won't be able to take advantage of this.", 'start': 850.23, 'duration': 5.042}, {'end': 858.313, 'text': "Okay, so I'm gonna go ahead, let's insert this function.", 'start': 855.372, 'duration': 2.941}, {'end': 862.315, 'text': "And I'm gonna walk through exactly what we're going to insert here.", 'start': 858.993, 'duration': 3.322}, {'end': 866.917, 'text': 'So once again, I said, I wanna filter my data based on the state that I have entered in this cell.', 'start': 862.415, 'duration': 4.502}, {'end': 869.879, 'text': "So what I'm gonna do is it asks for the array.", 'start': 867.317, 'duration': 2.562}, {'end': 871.86, 'text': 'Well, the array is my data set.', 'start': 869.939, 'duration': 1.921}, {'end': 875.342, 'text': "And so I'm gonna go ahead and select this array of data.", 'start': 871.92, 'duration': 3.422}, {'end': 878.403, 'text': 'And in this case, I did not select the column headers.', 'start': 875.702, 'duration': 2.701}, {'end': 881.605, 'text': "Next, it's asking me what I want to include.", 'start': 878.843, 'duration': 2.762}, {'end': 886.606, 'text': "What this is, is it's going to look at my data and it's going to make a determination of true or false.", 'start': 882.165, 'duration': 4.441}, {'end': 891.067, 'text': "And so basically what it is, is what is the data that I'm filtering on? So I'm going to select this column.", 'start': 886.646, 'duration': 4.421}, {'end': 894.988, 'text': "This is the column I'm filtering on, and then I want it to look for New Jersey.", 'start': 891.087, 'duration': 3.901}, {'end': 900.429, 'text': "So I'm going to put in an equal sign and I'm going to go ahead and select this cell reference I1.", 'start': 895.048, 'duration': 5.381}, {'end': 906.23, 'text': 'I could also simply, if I wanted to, I could also type in New Jersey, but in this case, I want to insert a cell reference.', 'start': 900.769, 'duration': 5.461}, {'end': 911.772, 'text': "And if it's empty, what I'm gonna do is I'm gonna insert quotes and I'm just gonna enter two quotes.", 'start': 906.65, 'duration': 5.122}, {'end': 913.773, 'text': 'So basically returns an empty string.', 'start': 911.792, 'duration': 1.981}, {'end': 916.114, 'text': "And now I'm gonna click on OK.", 'start': 914.193, 'duration': 1.921}, {'end': 919.895, 'text': 'And what this has done now is it filtered my database on New Jersey.', 'start': 916.534, 'duration': 3.361}, {'end': 923.837, 'text': "Now, the neat thing about using the filter function is let's say I change this to New York.", 'start': 919.935, 'duration': 3.902}], 'summary': 'Demonstration of using the filter function in microsoft 365 to manipulate and filter data based on specific criteria.', 'duration': 89.895, 'max_score': 833.942, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/BtiVbY7lhqw/pics/BtiVbY7lhqw833942.jpg'}, {'end': 866.917, 'src': 'embed', 'start': 839.485, 'weight': 0, 'content': [{'end': 842.767, 'text': "And to do that, I'm going to go up here to insert function.", 'start': 839.485, 'duration': 3.282}, {'end': 846.208, 'text': "So I'm gonna click on this and now I'm gonna search for a filter.", 'start': 843.447, 'duration': 2.761}, {'end': 850.15, 'text': "This is a new function that's available to Microsoft 365 customers.", 'start': 846.528, 'duration': 3.622}, {'end': 855.272, 'text': "If you're not a Microsoft 365 customer, unfortunately you won't be able to take advantage of this.", 'start': 850.23, 'duration': 5.042}, {'end': 858.313, 'text': "Okay, so I'm gonna go ahead, let's insert this function.", 'start': 855.372, 'duration': 2.941}, {'end': 862.315, 'text': "And I'm gonna walk through exactly what we're going to insert here.", 'start': 858.993, 'duration': 3.322}, {'end': 866.917, 'text': 'So once again, I said, I wanna filter my data based on the state that I have entered in this cell.', 'start': 862.415, 'duration': 4.502}], 'summary': 'Demonstrating the insertion of a new filter function available to microsoft 365 customers.', 'duration': 27.432, 'max_score': 839.485, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/BtiVbY7lhqw/pics/BtiVbY7lhqw839485.jpg'}], 'start': 424.174, 'title': 'Data filtering and analysis in excel', 'summary': 'Covers techniques for filtering and analyzing data in microsoft excel, including number and date filters, basic and advanced filtering techniques, and the new filter function, enabling targeted decision-making and efficiency for microsoft 365 customers.', 'chapters': [{'end': 643.356, 'start': 424.174, 'title': 'Filtering and analyzing data', 'summary': 'Explains how to filter and analyze data using number and date filters to identify locations that have lost money and those opened in specific years, allowing for targeted follow-up and decision-making.', 'duration': 219.182, 'highlights': ["Filtering locations that have lost money by using number filters, such as 'less than or equal to' zero, to identify areas for follow-up or potential closure. Identifying locations that have lost money and may require follow-up or closure.", "Using number filters like 'top 10' to identify top and bottom performing locations, allowing for focused analysis and follow-up. Identifying top and bottom performing locations for focused analysis and follow-up.", 'Applying date filters to analyze locations opened in specific years, enabling targeted follow-up and decision-making based on opening dates. Analyzing locations opened in specific years for targeted follow-up and decision-making.', 'Demonstrating the capability to apply multiple filters simultaneously, such as filtering locations in New Jersey opened in 2010, showcasing the additive nature of filters. Showcasing the capability to apply multiple filters simultaneously for targeted data analysis.']}, {'end': 981.005, 'start': 643.356, 'title': 'Excel filtering techniques', 'summary': 'Demonstrates basic and advanced filtering techniques in microsoft excel, including using pivot data, advanced filtering, and the new filter function, allowing users to filter data efficiently and easily, with the new filter function being rolled out to microsoft 365 customers.', 'duration': 337.649, 'highlights': ['The new filter function allows users to efficiently filter data by simply entering the desired value, automatically updating the table, and is currently rolling out to Microsoft 365 customers. The new filter function in Microsoft Excel allows users to efficiently filter data by simply entering the desired value, automatically updating the table, and is currently rolling out to Microsoft 365 customers.', 'Demonstrating advanced filtering techniques, such as using the advanced filter option, selecting list range and criteria range, and filtering based on multiple columns, allowing for more complex filtering processes. The tutorial demonstrates advanced filtering techniques, such as using the advanced filter option, selecting list range and criteria range, and filtering based on multiple columns, allowing for more complex filtering processes.', 'The chapter begins with demonstrating basic filtering in Microsoft Excel, including removing filters, turning off all filters, and filtering based on specific data criteria. The chapter begins with demonstrating basic filtering in Microsoft Excel, including removing filters, turning off all filters, and filtering based on specific data criteria.']}], 'duration': 556.831, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/BtiVbY7lhqw/pics/BtiVbY7lhqw424174.jpg', 'highlights': ['The new filter function in Microsoft Excel allows users to efficiently filter data by simply entering the desired value, automatically updating the table, and is currently rolling out to Microsoft 365 customers.', 'Demonstrating advanced filtering techniques, such as using the advanced filter option, selecting list range and criteria range, and filtering based on multiple columns, allowing for more complex filtering processes.', 'Applying date filters to analyze locations opened in specific years, enabling targeted follow-up and decision-making based on opening dates.', "Using number filters like 'top 10' to identify top and bottom performing locations, allowing for focused analysis and follow-up.", "Filtering locations that have lost money by using number filters, such as 'less than or equal to' zero, to identify areas for follow-up or potential closure."]}], 'highlights': ['The new filter function in Microsoft Excel allows users to efficiently filter data by simply entering the desired value, automatically updating the table, and is currently rolling out to Microsoft 365 customers.', 'Demonstrating advanced filtering techniques, such as using the advanced filter option, selecting list range and criteria range, and filtering based on multiple columns, allowing for more complex filtering processes.', 'Applying date filters to analyze locations opened in specific years, enabling targeted follow-up and decision-making based on opening dates.', "Using number filters like 'top 10' to identify top and bottom performing locations, allowing for focused analysis and follow-up.", "Filtering locations that have lost money by using number filters, such as 'less than or equal to' zero, to identify areas for follow-up or potential closure.", "The chapter demonstrates two methods for filtering data in Excel, including converting data into a table using the 'insert pivot' option or pressing control T, and accessing the filter option through the data pivot on the ribbon by pressing control shift L.", 'The tutorial demonstrates how to filter data by state, showcasing a quick and efficient way to analyze specific locations and utilize search to filter for specific states in Excel.', 'The tutorial highlights the process of filtering data based on text in Excel, including filtering for states that start with a specific letter, showcasing the extensive capabilities for text-based filtering in Excel.', 'The tutorial demonstrates how to filter data by color in Excel, allowing users to quickly view and analyze data based on highlighted locations, providing a convenient feature for tracking and following up on specific store managers or locations.', "Converting data into a table using the 'insert pivot' option or pressing control T, which prompts a prompt for the data selection and turns it into a table with headers and drop-down icons for filtering.", 'Accessing the filter option through the data pivot on the ribbon by pressing control shift L, which provides similar filter dropdown icons as in a table for data filtering.', 'The chapter covers the basics and advanced techniques of filtering in Microsoft Excel.', "The fictional company, 'Kevin's Cookie Company,' has 15 different locations with varying revenue and expenses.", 'The data includes 15 store locations with diverse financial performance.', 'The chapter introduces a new function called the filter function.']}