title
Excel Tips and Tricks

description
In this step-by-step tutorial, learn the best 11 Microsoft Excel Tips and Tricks that are sure to make your work easier and more efficient. As a few examples, with these hacks, you can move columns with just a simple drag and drop, sum up all the values with just a simple shortcut key, and pick out just the information you want from a column. 👋 Additional resources - Sample workbook to follow along: https://1drv.ms/x/s!AmxrofZZlZ-whN9VtTrY5dl9UugRBA?e=lSNnBq - Full course on formulas and functions in Microsoft Excel: https://youtu.be/Y8xhrUa3KH4 - Learn the fundamentals of Excel in just 2 hours: https://kevinstratvert.thinkific.com ⌚ Timestamps 0:00 Introduction 0:34 Drag and drop to move columns 2:38 Auto sum with ALT + = 4:01 Calculations with paste special 5:52 Unique count 7:06 Complicated functions 8:45 Custom lists 10:34 Named ranges 12:33 Status bar metrics 13:39 Flash fill 15:00 CTRL + Enter 17:27 Quick access toolbar 18:57 Wrap up 📃 Watch related playlists - Playlist with all my videos on Microsoft Excel: https://www.youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY 🚩 Connect with me on social - LinkedIn: https://www.linkedin.com/in/kevinstratvert/ - Discord: https://bit.ly/KevinStratvertDiscord - Twitter: https://twitter.com/kevstrat - Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818 - TikTok: https://www.tiktok.com/@kevinstratvert - Instagram: https://www.instagram.com/kevinstratvert/ 🙏 Request How To Tutorial Videos https://forms.gle/BDrTNUoxheEoMLGt5 🔔 Subscribe to my YouTube channel https://www.youtube.com/user/kevlers?sub_confirmation=1 🎬 Want to watch again? Navigate back to my YouTube channel quickly http://www.kevinstratvert.com 🛍 Support me with your Amazon purchases: https://amzn.to/3kCP2yz ⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same. #stratvert #microsoftambassador

detail
{'title': 'Excel Tips and Tricks', 'heatmap': [{'end': 823.26, 'start': 793.726, 'weight': 0.76}, {'end': 1008.927, 'start': 983.343, 'weight': 0.705}], 'summary': "'excel tips and tricks' features chapters on various excel tips, shortcuts, functions, and tricks to save time and effort, including moving columns, using functions for profit calculation, custom sorting, leveraging the excel status bar, and data manipulation techniques.", 'chapters': [{'end': 336.875, 'segs': [{'end': 30.865, 'src': 'embed', 'start': 0.449, 'weight': 0, 'content': [{'end': 3.671, 'text': 'You can move a column simply by dragging and dropping.', 'start': 0.449, 'duration': 3.222}, {'end': 7.913, 'text': 'You can sum up cells with a simple shortcut key.', 'start': 4.371, 'duration': 3.542}, {'end': 12.795, 'text': 'You can extract information out of a column with just the click of your mouse.', 'start': 8.853, 'duration': 3.942}, {'end': 15.296, 'text': 'Hi everyone, Kevin here.', 'start': 13.955, 'duration': 1.341}, {'end': 21.259, 'text': "Today we're going to look at even more Excel tips and tricks just like these.", 'start': 15.676, 'duration': 5.583}, {'end': 25.721, 'text': "And I'm sure you'll likely find a new one that you haven't seen before.", 'start': 21.919, 'duration': 3.802}, {'end': 30.865, 'text': "To follow along, I've included a sample workbook down below in the description.", 'start': 26.701, 'duration': 4.164}], 'summary': 'Excel tips: drag to move, shortcut for sum, click to extract. more tricks and a sample workbook available.', 'duration': 30.416, 'max_score': 0.449, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/qHaZYN5uINc/pics/qHaZYN5uINc449.jpg'}, {'end': 75.661, 'src': 'embed', 'start': 48.359, 'weight': 2, 'content': [{'end': 53.023, 'text': 'Then I could copy all these contents, cut it, paste it, and then I could delete this column.', 'start': 48.359, 'duration': 4.664}, {'end': 58.63, 'text': "That's a lot of clicks, and on the Kevin Stratford YouTube channel, we don't like clicks.", 'start': 54.164, 'duration': 4.466}, {'end': 65.619, 'text': "So instead we can highlight all the contents of this column, and here I'll hover over the edge of the selection,", 'start': 59.191, 'duration': 6.428}, {'end': 68.142, 'text': 'and there you see that it changes to an arrow icon.', 'start': 65.619, 'duration': 2.523}, {'end': 75.661, 'text': "Now I'll press the shift key together with my left mouse button, and now I can drag this column wherever I want it.", 'start': 69.099, 'duration': 6.562}], 'summary': "Demonstrating an efficient method to move columns, reducing clicks on kevin stratford's youtube channel.", 'duration': 27.302, 'max_score': 48.359, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/qHaZYN5uINc/pics/qHaZYN5uINc48359.jpg'}, {'end': 135.836, 'src': 'embed', 'start': 110.933, 'weight': 3, 'content': [{'end': 117.216, 'text': 'and this opens up a context menu and down here, here I could shift right and move, and that once again moves that column.', 'start': 110.933, 'duration': 6.283}, {'end': 122.019, 'text': "And if you notice with that context menu, I had a few other options, so let's see what those do.", 'start': 117.656, 'duration': 4.363}, {'end': 125.122, 'text': 'Here, this column header has no formatting.', 'start': 122.819, 'duration': 2.303}, {'end': 127.025, 'text': 'I could also move over the formatting.', 'start': 125.403, 'duration': 1.622}, {'end': 135.836, 'text': "I'll select zip hover over the edge and with my right mouse button drag over to country, and here I have the option to move over just the formatting.", 'start': 127.666, 'duration': 8.17}], 'summary': 'Demonstrating column shifting and formatting options in a context menu.', 'duration': 24.903, 'max_score': 110.933, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/qHaZYN5uINc/pics/qHaZYN5uINc110933.jpg'}], 'start': 0.449, 'title': 'Excel tips and shortcuts', 'summary': 'Explores various excel tips and shortcuts, such as moving columns by dragging and dropping, summing up cells with shortcut keys, and performing calculations without formulas, promising to save time and effort for the user.', 'chapters': [{'end': 68.142, 'start': 0.449, 'title': 'Excel tips and tricks', 'summary': 'Explores excel tips and tricks, including how to move columns by dragging and dropping, summing up cells with shortcut keys, and extracting information with a click of a mouse, with the promise of discovering new tips.', 'duration': 67.693, 'highlights': ['You can move a column simply by dragging and dropping, reducing the need for multiple clicks and enabling efficient reorganization of data.', 'You can sum up cells with a simple shortcut key, providing a quick and efficient method for performing calculations within Excel.', 'You can extract information out of a column with just the click of your mouse, demonstrating a convenient and time-saving feature for data extraction.', 'Kevin introduces even more Excel tips and tricks, offering the audience the potential to discover new tools and techniques for Excel usage.', 'Kevin provides a sample workbook for the audience to follow along, enhancing the practical application of the Excel tips and tricks being presented.']}, {'end': 336.875, 'start': 69.099, 'title': 'Excel tips and shortcuts', 'summary': 'Demonstrates how to move and manipulate data in excel, utilize shortcuts to quickly sum up cells, and perform calculations without formulas, ultimately saving time and effort for the user.', 'duration': 267.776, 'highlights': ['Alt equals shortcut for summing cells and performing calculations without formulas The Alt equals shortcut allows for quick summation of cells and performing calculations without using formulas, providing a more efficient way to obtain results.', 'Dragging and moving columns and cells using mouse and keyboard shortcuts The chapter illustrates the process of dragging and moving columns and cells using both mouse and keyboard shortcuts, offering a flexible method for reorganizing data in Excel.', 'Paste Special feature for performing arithmetic operations on selected cells The demonstration of using the Paste Special feature to perform arithmetic operations on selected cells, such as addition, subtraction, multiplication, and division, streamlines the process of manipulating data in Excel.']}], 'duration': 336.426, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/qHaZYN5uINc/pics/qHaZYN5uINc449.jpg', 'highlights': ['You can sum up cells with a simple shortcut key, providing a quick and efficient method for performing calculations within Excel.', 'Alt equals shortcut for summing cells and performing calculations without formulas The Alt equals shortcut allows for quick summation of cells and performing calculations without using formulas, providing a more efficient way to obtain results.', 'You can move a column simply by dragging and dropping, reducing the need for multiple clicks and enabling efficient reorganization of data.', 'Dragging and moving columns and cells using mouse and keyboard shortcuts The chapter illustrates the process of dragging and moving columns and cells using both mouse and keyboard shortcuts, offering a flexible method for reorganizing data in Excel.', 'You can extract information out of a column with just the click of your mouse, demonstrating a convenient and time-saving feature for data extraction.']}, {'end': 622.454, 'segs': [{'end': 360.082, 'src': 'embed', 'start': 336.875, 'weight': 2, 'content': [{'end': 343.878, 'text': 'you can press Ctrl Alt and V, and that opens up that same dialog, and here I can click on Multiply.', 'start': 336.875, 'duration': 7.003}, {'end': 352.56, 'text': "it still does look kind of low, so maybe I should go through and let's multiply this by a way bigger number and that'll accurately reflect our profit.", 'start': 345.498, 'duration': 7.062}, {'end': 358.281, 'text': 'Tip number four, Excel now makes it really easy to get a unique or distinct count.', 'start': 353.22, 'duration': 5.061}, {'end': 360.082, 'text': 'Here at the cookie company.', 'start': 359.002, 'duration': 1.08}], 'summary': 'Using excel, ctrl alt v opens dialog, multiplying by bigger number accurately reflects profit, and excel makes it easy to get a unique or distinct count at the cookie company.', 'duration': 23.207, 'max_score': 336.875, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/qHaZYN5uINc/pics/qHaZYN5uINc336875.jpg'}, {'end': 409.68, 'src': 'embed', 'start': 380.196, 'weight': 4, 'content': [{'end': 385.943, 'text': 'Here it asks me for the array or basically the range or array from which to return unique values.', 'start': 380.196, 'duration': 5.747}, {'end': 394.429, 'text': "So here I'll simply select this entire list and then I have two other parameters that I can pass into this function, but they're optional,", 'start': 386.604, 'duration': 7.825}, {'end': 396.971, 'text': "so I'll just leave them as is and then click on OK.", 'start': 394.429, 'duration': 2.542}, {'end': 402.955, 'text': 'So, here now I can see all of the unique types of cookies that we sell here at the Kevin Cookie Company.', 'start': 397.672, 'duration': 5.283}, {'end': 409.68, 'text': 'Now, I wanted a count of how many unique cookies we sell, so I can combine this with another function.', 'start': 403.616, 'duration': 6.064}], 'summary': 'Returned unique values from array, showing types of cookies sold.', 'duration': 29.484, 'max_score': 380.196, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/qHaZYN5uINc/pics/qHaZYN5uINc380196.jpg'}, {'end': 488.146, 'src': 'embed', 'start': 465.034, 'weight': 0, 'content': [{'end': 472.483, 'text': 'Well, here I could click on find and here I could click on the function helper and this will open up the function arguments just for the find function.', 'start': 465.034, 'duration': 7.449}, {'end': 477.729, 'text': "So here I can see what it's looking for within what text and I can make sense of how this portion works.", 'start': 472.563, 'duration': 5.166}, {'end': 480, 'text': "Here I'll click on OK.", 'start': 478.919, 'duration': 1.081}, {'end': 481.401, 'text': 'Then I can click on len.', 'start': 480.18, 'duration': 1.221}, {'end': 488.146, 'text': 'Here I can click on the insert function helper and then here I can understand just how this function works and what arguments I need to pass in.', 'start': 481.881, 'duration': 6.265}], 'summary': 'Demonstrating how to use find and len functions in a tool interface.', 'duration': 23.112, 'max_score': 465.034, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/qHaZYN5uINc/pics/qHaZYN5uINc465034.jpg'}, {'end': 587.131, 'src': 'embed', 'start': 560.674, 'weight': 1, 'content': [{'end': 565.658, 'text': "So you can create your own custom list and it's actually pretty easy to do.", 'start': 560.674, 'duration': 4.984}, {'end': 569.08, 'text': 'Click on the file menu, then go down to options.', 'start': 566.298, 'duration': 2.782}, {'end': 576.966, 'text': "Within options, let's click on advanced and then go all the way down to the bottom and here you have the option to edit custom lists.", 'start': 570.561, 'duration': 6.405}, {'end': 579.924, 'text': "Here you'll see some of the lists that we already looked at.", 'start': 577.762, 'duration': 2.162}, {'end': 582.967, 'text': 'You have Sunday, Monday, Tuesday, you have all the months of the year.', 'start': 580.064, 'duration': 2.903}, {'end': 587.131, 'text': "And down below, here's my list that I created with different cookie types.", 'start': 583.547, 'duration': 3.584}], 'summary': 'Creating custom lists in excel is easy. simply go to file > options > advanced, then edit custom lists.', 'duration': 26.457, 'max_score': 560.674, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/qHaZYN5uINc/pics/qHaZYN5uINc560674.jpg'}], 'start': 336.875, 'title': 'Using excel functions and tips', 'summary': 'Covers utilizing excel functions for multiplying values to accurately reflect profit, utilizing unique functions for distinct cookie count, finding unique values, counting items, understanding complex and nested functions, and creating custom lists.', 'chapters': [{'end': 379.295, 'start': 336.875, 'title': 'Excel tips and functions', 'summary': 'Discusses using excel to multiply values for accurate reflection of profit and utilizing the unique function for distinct count of cookies sold at the cookie company.', 'duration': 42.42, 'highlights': ['Excel now makes it really easy to get a unique or distinct count at the cookie company.', 'Pressing Ctrl Alt and V opens up the dialog for multiplying values, providing an accurate reflection of profit.', "The function 'unique' in Excel helps in getting the distinct count of cookies sold at the cookie company."]}, {'end': 622.454, 'start': 380.196, 'title': 'Excel functions and custom lists', 'summary': 'Discusses using excel functions to find unique values, count unique items, understand complex and nested functions, and create custom lists, offering tips and techniques for each process.', 'duration': 242.258, 'highlights': ['Understanding complex and nested functions The chapter provides techniques for understanding complex and nested functions, including using the function helper to see the arguments and results of specific portions, as well as the F9 key to evaluate specific portions or the entire function.', 'Creating custom lists in Excel The process of creating custom lists in Excel is explained, including accessing the options menu, going to advanced settings, editing custom lists, and sorting by custom lists, offering a user-friendly approach for customizing data.', "Finding unique values and counting unique items The chapter demonstrates using Excel functions to find unique values and count unique items, with a specific example of using the 'countA' function to count non-blank rows and obtaining a count of six unique types of cookies."]}], 'duration': 285.579, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/qHaZYN5uINc/pics/qHaZYN5uINc336875.jpg', 'highlights': ['Pressing Ctrl Alt and V opens up the dialog for multiplying values, providing an accurate reflection of profit.', "The function 'unique' in Excel helps in getting the distinct count of cookies sold at the cookie company.", 'Understanding complex and nested functions The chapter provides techniques for understanding complex and nested functions, including using the function helper to see the arguments and results of specific portions, as well as the F9 key to evaluate specific portions or the entire function.', "Finding unique values and counting unique items The chapter demonstrates using Excel functions to find unique values and count unique items, with a specific example of using the 'countA' function to count non-blank rows and obtaining a count of six unique types of cookies.", 'Creating custom lists in Excel The process of creating custom lists in Excel is explained, including accessing the options menu, going to advanced settings, editing custom lists, and sorting by custom lists, offering a user-friendly approach for customizing data.', 'Excel now makes it really easy to get a unique or distinct count at the cookie company.']}, {'end': 1154.494, 'segs': [{'end': 660.942, 'src': 'embed', 'start': 622.454, 'weight': 1, 'content': [{'end': 630.198, 'text': "I want to sort based on the cookie name, but instead of Z to A or A to Z, I can select custom list, and here's my list that I created.", 'start': 622.454, 'duration': 7.744}, {'end': 634.78, 'text': "I'll click on OK and OK and now it's sorted in this exact format.", 'start': 630.438, 'duration': 4.342}, {'end': 640.102, 'text': 'Tip number seven, you can make it easier to write formulas by using named ranges.', 'start': 635.5, 'duration': 4.602}, {'end': 646.625, 'text': 'Here for example, I want to calculate the tax that we had to pay on the profit for all of these different cookie sales.', 'start': 640.562, 'duration': 6.063}, {'end': 649.147, 'text': 'Now here I could enter a formula.', 'start': 647.205, 'duration': 1.942}, {'end': 653.613, 'text': "I could type in equals and let's take the profit here and then multiply it by the tax.", 'start': 649.348, 'duration': 4.265}, {'end': 656.376, 'text': 'Now I probably also want to make this an absolute reference.', 'start': 654.033, 'duration': 2.343}, {'end': 660.942, 'text': "So here when I copy over the formula to these other columns, it'll continue to work.", 'start': 656.837, 'duration': 4.105}], 'summary': 'Custom sort applied to cookie names. use named ranges for easier formula writing.', 'duration': 38.488, 'max_score': 622.454, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/qHaZYN5uINc/pics/qHaZYN5uINc622454.jpg'}, {'end': 734.55, 'src': 'embed', 'start': 706.813, 'weight': 0, 'content': [{'end': 713.137, 'text': "Here for example, let's say I want to add each quarter's profit to the name manager, so I could reference this anywhere in my workbook.", 'start': 706.813, 'duration': 6.324}, {'end': 716.779, 'text': 'Here I can select the header and also the values.', 'start': 713.877, 'duration': 2.902}, {'end': 723.823, 'text': 'Then I can click on formulas, and here I can create from selection, and here the name is in the top row.', 'start': 717.319, 'duration': 6.504}, {'end': 726.005, 'text': 'Then I can click on OK.', 'start': 724.504, 'duration': 1.501}, {'end': 734.55, 'text': "and now, if I want to, let's say, reference the first quarter profit, I can enter equals and then I'll press F3 and here's the Q1 profit.", 'start': 726.005, 'duration': 8.545}], 'summary': 'Using excel to create and reference named ranges for profit data.', 'duration': 27.737, 'max_score': 706.813, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/qHaZYN5uINc/pics/qHaZYN5uINc706813.jpg'}, {'end': 788.464, 'src': 'embed', 'start': 763.078, 'weight': 3, 'content': [{'end': 770.347, 'text': 'and I want to know how much total revenue did we collect, how many orders were there, what was the average order revenue, all that kind of stuff.', 'start': 763.078, 'duration': 7.269}, {'end': 774.992, 'text': "Now I could go to the bottom and I could enter in formulas, but that's going to take a little bit of time.", 'start': 770.827, 'duration': 4.165}, {'end': 779.297, 'text': "Instead, here I'll select this cell and press Ctrl Shift and up arrow.", 'start': 775.172, 'duration': 4.125}, {'end': 782.701, 'text': 'That way I could select just all of these cells.', 'start': 780.278, 'duration': 2.423}, {'end': 788.464, 'text': 'Now if I look down on the status bar, I can see that we had about $66,000 of revenue.', 'start': 783.402, 'duration': 5.062}], 'summary': 'Collected $66,000 in total revenue from multiple orders.', 'duration': 25.386, 'max_score': 763.078, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/qHaZYN5uINc/pics/qHaZYN5uINc763078.jpg'}, {'end': 841.632, 'src': 'heatmap', 'start': 793.726, 'weight': 4, 'content': [{'end': 798.027, 'text': 'I can right click on this, and if I scroll down a little bit, here I could also add the min.', 'start': 793.726, 'duration': 4.301}, {'end': 801.789, 'text': 'I could add the max, the numerical count, and I could add all of these metrics.', 'start': 798.287, 'duration': 3.502}, {'end': 806.975, 'text': "Now when I click back, here you'll see them all in the status bar and this is a new one now.", 'start': 802.569, 'duration': 4.406}, {'end': 809.739, 'text': 'I can click on the status bar to copy this value.', 'start': 807.075, 'duration': 2.664}, {'end': 814.525, 'text': 'Now I can click into a cell and paste and this is now pasted in the sum.', 'start': 810.32, 'duration': 4.205}, {'end': 819.732, 'text': 'So once again, a neat way to not even use formulas to get some quick metrics.', 'start': 815.086, 'duration': 4.646}, {'end': 823.26, 'text': 'Tip number nine is flash fill.', 'start': 820.899, 'duration': 2.361}, {'end': 830.485, 'text': 'So what can you do with flash fill? Well, you can extract information from a column or you could combine various columns together.', 'start': 823.681, 'duration': 6.804}, {'end': 832.066, 'text': "Let's see how you can do this.", 'start': 831.045, 'duration': 1.021}, {'end': 836.308, 'text': 'Here in this first column, I want to pull out the first name.', 'start': 832.826, 'duration': 3.482}, {'end': 838.69, 'text': 'So here, let me type in the first name.', 'start': 836.989, 'duration': 1.701}, {'end': 841.632, 'text': "I want to give Excel an example, then I'll hit enter.", 'start': 838.77, 'duration': 2.862}], 'summary': 'Excel allows adding metrics and using flash fill for quick data extraction and combination. flash fill can extract information from a column or combine various columns together.', 'duration': 39.063, 'max_score': 793.726, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/qHaZYN5uINc/pics/qHaZYN5uINc793726.jpg'}, {'end': 930.377, 'src': 'embed', 'start': 904.155, 'weight': 6, 'content': [{'end': 908.497, 'text': 'You can very quickly enter a formula or function into multiple cells at once.', 'start': 904.155, 'duration': 4.342}, {'end': 914.318, 'text': 'Here I have an investor meeting coming up and I need to tell them how many cookies we sold by market.', 'start': 909.277, 'duration': 5.041}, {'end': 918.842, 'text': "And I don't have that data, so let's see if I could use a function to do this.", 'start': 915.157, 'duration': 3.685}, {'end': 924.008, 'text': "Here I'll highlight all of these different cells and we can use a function called randBetween.", 'start': 918.982, 'duration': 5.026}, {'end': 925.29, 'text': 'I just want a random number.', 'start': 924.249, 'duration': 1.041}, {'end': 930.377, 'text': "And here for the bottom let's enter in 500 and for the top value I'll enter 1000.", 'start': 926.011, 'duration': 4.366}], 'summary': 'Using the randbetween function to generate a random number between 500 and 1000 for investor meeting.', 'duration': 26.222, 'max_score': 904.155, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/qHaZYN5uINc/pics/qHaZYN5uINc904155.jpg'}, {'end': 1014.989, 'src': 'heatmap', 'start': 983.343, 'weight': 0.705, 'content': [{'end': 986.947, 'text': 'Now we could use that same Control-Enter to fill in all these blanks.', 'start': 983.343, 'duration': 3.604}, {'end': 989.49, 'text': "Here I'll select all of these different cells.", 'start': 987.608, 'duration': 1.882}, {'end': 991.552, 'text': "Let's click on the Home tab.", 'start': 990.151, 'duration': 1.401}, {'end': 994.815, 'text': "Go over to Find and let's go to Special.", 'start': 992.273, 'duration': 2.542}, {'end': 1000.28, 'text': 'Here I can select all blanks, then click on OK, and now all of the blank cells are selected.', 'start': 995.456, 'duration': 4.824}, {'end': 1004.283, 'text': 'And I want this first blank cell, I just want it to equal the cell above it.', 'start': 1000.92, 'duration': 3.363}, {'end': 1008.927, 'text': "So here for the formula, I can enter equals and then I'll select this cell.", 'start': 1005.024, 'duration': 3.903}, {'end': 1014.989, 'text': "Now, it'll apply this formula relatively, so here the next cell will look at the one above it.", 'start': 1009.946, 'duration': 5.043}], 'summary': 'Using control-enter to fill in blank cells and applying relative formulas to select cells.', 'duration': 31.646, 'max_score': 983.343, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/qHaZYN5uINc/pics/qHaZYN5uINc983343.jpg'}], 'start': 622.454, 'title': 'Excel tips and tricks', 'summary': 'Covers a range of excel tips and tricks, such as custom sorting, named ranges for formulas, leveraging the excel status bar for quick metrics, using flash fill and control enter for data manipulation, and customizing the quick access toolbar for efficient data management.', 'chapters': [{'end': 986.947, 'start': 622.454, 'title': 'Excel tips and tricks', 'summary': 'Discusses various excel tips and tricks, including using custom sorting, named ranges for formulas, leveraging the excel status bar for quick metrics, and using flash fill and control enter for efficient data manipulation.', 'duration': 364.493, 'highlights': ['Using named ranges for formulas Creating named ranges for formulas can simplify and clarify the calculations, making it easier to manage and reference different cells, improving efficiency and reducing errors.', 'Leveraging the Excel status bar for quick metrics Utilizing the Excel status bar provides a quick and efficient way to obtain metrics such as total revenue, number of orders, average order size, and other metrics without the need for complex formulas.', 'Using Flash Fill for data extraction and combination Flash Fill allows for easy extraction of information from columns and combining various columns, providing a convenient and quick method to manipulate and format data.', 'Efficient data manipulation using Control Enter Control Enter enables the quick application of formulas or functions to multiple cells at once, streamlining the process of populating data and enhancing productivity.']}, {'end': 1154.494, 'start': 987.608, 'title': 'Excel tips and tricks', 'summary': 'Demonstrates how to quickly select, fill and delete cells, and customize the quick access toolbar in excel, providing techniques for efficient data manipulation and management.', 'duration': 166.886, 'highlights': ['The chapter provides a quick technique to select all blank cells in a spreadsheet, improving efficiency in data manipulation. The narrator demonstrates how to select all blank cells in the spreadsheet by navigating through the Home tab, Find, and Special, ultimately improving efficiency in data manipulation.', 'The technique of filling cells using the equals formula and Ctrl Enter is showcased, enabling the quick application of formulas to multiple cells. The narrator demonstrates the use of the equals formula and Ctrl Enter to efficiently fill cells with the content of the cell above, showcasing a technique for quick application of formulas to multiple cells.', 'The process of customizing the quick access toolbar is described, allowing for the efficient addition of frequently used commands for easy access. The narrator explains the process of customizing the quick access toolbar, including the addition of frequently used commands for quick and easy access, enhancing efficiency in Excel usage.']}], 'duration': 532.04, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/qHaZYN5uINc/pics/qHaZYN5uINc622454.jpg', 'highlights': ['Using named ranges for formulas can simplify and clarify calculations, improving efficiency and reducing errors.', 'Leveraging the Excel status bar for quick metrics provides a quick and efficient way to obtain metrics without complex formulas.', 'Using Flash Fill for data extraction and combination allows for easy manipulation and formatting of data.', 'Efficient data manipulation using Control Enter streamlines the process of populating data and enhances productivity.', 'The chapter provides a quick technique to select all blank cells in a spreadsheet, improving efficiency in data manipulation.', 'The technique of filling cells using the equals formula and Ctrl Enter enables the quick application of formulas to multiple cells.', 'Customizing the quick access toolbar allows for the efficient addition of frequently used commands for easy access.']}], 'highlights': ['The Alt equals shortcut allows for quick summation of cells and performing calculations without using formulas, providing a more efficient way to obtain results.', 'You can sum up cells with a simple shortcut key, providing a quick and efficient method for performing calculations within Excel.', 'You can move a column simply by dragging and dropping, reducing the need for multiple clicks and enabling efficient reorganization of data.', 'The chapter illustrates the process of dragging and moving columns and cells using both mouse and keyboard shortcuts, offering a flexible method for reorganizing data in Excel.', 'You can extract information out of a column with just the click of your mouse, demonstrating a convenient and time-saving feature for data extraction.', 'Pressing Ctrl Alt and V opens up the dialog for multiplying values, providing an accurate reflection of profit.', 'Understanding complex and nested functions The chapter provides techniques for understanding complex and nested functions, including using the function helper to see the arguments and results of specific portions, as well as the F9 key to evaluate specific portions or the entire function.', "Finding unique values and counting unique items The chapter demonstrates using Excel functions to find unique values and count unique items, with a specific example of using the 'countA' function to count non-blank rows and obtaining a count of six unique types of cookies.", 'Creating custom lists in Excel The process of creating custom lists in Excel is explained, including accessing the options menu, going to advanced settings, editing custom lists, and sorting by custom lists, offering a user-friendly approach for customizing data.', 'Using named ranges for formulas can simplify and clarify calculations, improving efficiency and reducing errors.', 'Leveraging the Excel status bar for quick metrics provides a quick and efficient way to obtain metrics without complex formulas.', 'Using Flash Fill for data extraction and combination allows for easy manipulation and formatting of data.', 'Efficient data manipulation using Control Enter streamlines the process of populating data and enhances productivity.', 'The chapter provides a quick technique to select all blank cells in a spreadsheet, improving efficiency in data manipulation.', 'The technique of filling cells using the equals formula and Ctrl Enter enables the quick application of formulas to multiple cells.', 'Customizing the quick access toolbar allows for the efficient addition of frequently used commands for easy access.']}