title

Excel Tutorial for Beginners

description

Learn how to use Excel with this step-by-step tutorial. As full disclosure, I work at Microsoft as a full-time employee.
Here's the workbook I used throughout this tutorial: https://1drv.ms/x/s!AmxrofZZlZ-whIMkJyovG7A6mX8Qjg
Other Excel Tutorials, including Pivot Tables, Conditional Formatting, Formulas and Functions, etc.: https://www.youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
- Learn the fundamentals of Excel in just 2 hours: https://kevinstratvert.thinkific.com
I walk through the following in this video (includes timestamps if you want to jump through the video):
- Intro, What is Microsoft Excel and how do spreadsheets help you analyze data? 0:00
- How to get Microsoft Excel 1:14
- Navigating the home screen 4:30
- Orientation to the main screen of Excel (including how to reference cells) 6:53
- Formatting (including accounting, comma style, wrap text, and merge and center) 8:20
- Adjust cell size, column size, and row size. 10:30
- Basic formulas (including addition, subtraction, multiplication, division, count, max, sum, and auto sum) 12:10
- Fill series (including absolute references and relative references) 15:57
- Split data 19:18
- Filter and Sort 20:28
- Tables 22:24
- Quick Analysis 23:50
- Ideas 24:40
- Charts 25:30
- Freeze Pane 27:03
- Pivot Tables 28:15

detail

{'title': 'Excel Tutorial for Beginners', 'heatmap': [{'end': 717.713, 'start': 670.47, 'weight': 0.781}, {'end': 844.5, 'start': 822.905, 'weight': 0.768}, {'end': 1049.425, 'start': 971.679, 'weight': 0.815}, {'end': 1125.622, 'start': 1103.937, 'weight': 0.837}, {'end': 1244.782, 'start': 1178.077, 'weight': 0.918}, {'end': 1409.251, 'start': 1344.62, 'weight': 0.871}], 'summary': 'This excel tutorial provides an introduction to the software, covering basic and advanced functionality to analyze data and trends, obtaining and using excel through various methods, fundamental excel features, data manipulation techniques, excel tables and data analysis, and basic chart creation and pivot tables for data analysis.', 'chapters': [{'end': 72.825, 'segs': [{'end': 72.825, 'src': 'embed', 'start': 0.575, 'weight': 0, 'content': [{'end': 2.396, 'text': 'Hi everyone, my name is Kevin.', 'start': 0.575, 'duration': 1.821}, {'end': 9.842, 'text': 'Today we are going to do an intro to Microsoft Excel or a tutorial of Microsoft Excel.', 'start': 2.516, 'duration': 7.326}, {'end': 14.205, 'text': "Now whether you're a completely new user to Excel and you've never used it before,", 'start': 10.222, 'duration': 3.983}, {'end': 19.95, 'text': "or even if you've used Excel before and you're looking to find out about more advanced functionality of Excel.", 'start': 14.205, 'duration': 5.745}, {'end': 21.471, 'text': 'this video is for you.', 'start': 19.95, 'duration': 1.521}, {'end': 29.297, 'text': 'Now my goal is by the end of this video, you will know how to use Microsoft Excel, both the basics and some of the more advanced functionality.', 'start': 21.551, 'duration': 7.746}, {'end': 31.958, 'text': 'So, if I do a good job today, you will be able to do that.', 'start': 29.597, 'duration': 2.361}, {'end': 35.059, 'text': "If I don't, then I'll apologize in advance.", 'start': 32.037, 'duration': 3.022}, {'end': 43.043, 'text': 'Now, one of the first questions you might be wondering is, well, what is Microsoft Excel? Well, Microsoft Excel is a spreadsheet program.', 'start': 35.52, 'duration': 7.523}, {'end': 48.005, 'text': 'And with a spreadsheet program, what you can do is you could analyze data in really amazing ways.', 'start': 43.103, 'duration': 4.902}, {'end': 52.328, 'text': 'You could find insights in your data and you could also analyze trends.', 'start': 48.545, 'duration': 3.783}, {'end': 54.75, 'text': "With this video, I'm going to cover a whole bunch of content.", 'start': 52.388, 'duration': 2.362}, {'end': 57.993, 'text': "If there's some content that you're particularly interested in,", 'start': 54.87, 'duration': 3.123}, {'end': 62.056, 'text': 'you could go down to the timestamps at the bottom and you could just click into the section that you care about.', 'start': 57.993, 'duration': 4.063}, {'end': 68.181, 'text': "If you just want to watch the whole video, that'll really give you a strong foundation in Microsoft Excel.", 'start': 62.576, 'duration': 5.605}, {'end': 72.825, 'text': 'And trust me, if you watch this whole thing, you will know how to use Excel by the end of this.', 'start': 68.361, 'duration': 4.464}], 'summary': 'Intro to microsoft excel: learn basics and advanced functionality to analyze data and trends.', 'duration': 72.25, 'max_score': 0.575, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/e7xGuGqgp-Q/pics/e7xGuGqgp-Q575.jpg'}], 'start': 0.575, 'title': 'Microsoft excel tutorial', 'summary': 'Provides an introduction to microsoft excel for new and experienced users, teaching basic and advanced functionality to analyze data and trends, and establish a strong foundation in excel.', 'chapters': [{'end': 72.825, 'start': 0.575, 'title': 'Intro to microsoft excel tutorial', 'summary': 'Covers an introduction to microsoft excel, aimed at both new and experienced users, with the goal of teaching basic and advanced functionality, enabling users to analyze data and trends, and providing strong foundation in excel.', 'duration': 72.25, 'highlights': ['By the end of the video, viewers will know how to use Microsoft Excel, covering both basics and advanced functionality.', 'Microsoft Excel is a spreadsheet program that allows users to analyze data and trends in amazing ways.', 'The video provides the option to navigate to specific content through timestamps, offering a strong foundation in Microsoft Excel.', 'The tutorial is suitable for both new users and those seeking more advanced Excel functionality.']}], 'duration': 72.25, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/e7xGuGqgp-Q/pics/e7xGuGqgp-Q575.jpg', 'highlights': ['Microsoft Excel is a spreadsheet program that allows users to analyze data and trends in amazing ways.', 'The tutorial is suitable for both new users and those seeking more advanced Excel functionality.', 'By the end of the video, viewers will know how to use Microsoft Excel, covering both basics and advanced functionality.', 'The video provides the option to navigate to specific content through timestamps, offering a strong foundation in Microsoft Excel.']}, {'end': 368.481, 'segs': [{'end': 173.476, 'src': 'embed', 'start': 114.78, 'weight': 0, 'content': [{'end': 117.602, 'text': 'Excel on the desktop is the full feature-rich program.', 'start': 114.78, 'duration': 2.822}, {'end': 119.763, 'text': 'There are a few different options.', 'start': 118.522, 'duration': 1.241}, {'end': 123.305, 'text': 'You can get a subscription to Office 365.', 'start': 119.823, 'duration': 3.482}, {'end': 127.727, 'text': 'With a subscription, not only do you get Excel, but you also get a number of other apps as well.', 'start': 123.305, 'duration': 4.422}, {'end': 135.092, 'text': 'The difference between these two subscriptions with this one, which is a little more expensive, you could share it with up to six people total.', 'start': 128.328, 'duration': 6.764}, {'end': 137.774, 'text': 'with the office 365 personal.', 'start': 135.772, 'duration': 2.002}, {'end': 144.902, 'text': "it's limited to just one person, but once again you get all of these apps, including excel, if you'd rather just pay for it one time.", 'start': 137.774, 'duration': 7.128}, {'end': 148.566, 'text': "there's also an option office, home and student which is 150 dollars,", 'start': 144.902, 'duration': 3.664}, {'end': 153.952, 'text': 'and you get word excel and powerpoint and you just pay for it once and then you get the software on your machine.', 'start': 148.566, 'duration': 5.386}, {'end': 160.113, 'text': "Alternatively, what you can do is, if you're not interested in paying for Office and you'd rather use it for free,", 'start': 154.872, 'duration': 5.241}, {'end': 162.954, 'text': 'what you can do is you could also use it for free online.', 'start': 160.113, 'duration': 2.841}, {'end': 169.595, 'text': "The way to do that is on my screen here, what you're going to do is you click on Sign In and you're going to land on this sign in page.", 'start': 163.554, 'duration': 6.041}, {'end': 173.476, 'text': 'What you do then is you could sign in if you have an existing Microsoft account.', 'start': 170.155, 'duration': 3.321}], 'summary': 'Excel on desktop offers various subscription options including office 365 for multiple users and a one-time payment option for office home and student at $150, or free online usage by signing in with a microsoft account.', 'duration': 58.696, 'max_score': 114.78, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/e7xGuGqgp-Q/pics/e7xGuGqgp-Q114780.jpg'}, {'end': 230.053, 'src': 'embed', 'start': 203.906, 'weight': 3, 'content': [{'end': 210.05, 'text': "you could get what's called the desktop software, which is included on windows, which i showed you before, or you could get the web software.", 'start': 203.906, 'duration': 6.144}, {'end': 211.391, 'text': 'so what is the difference?', 'start': 210.05, 'duration': 1.341}, {'end': 215.454, 'text': 'well, in terms of kind of basic usage of excel, both of them are pretty similar.', 'start': 211.391, 'duration': 4.063}, {'end': 218.556, 'text': "you'll be able to do all the basic functionality, whichever one you choose.", 'start': 215.454, 'duration': 3.102}, {'end': 226.147, 'text': "the web offering is still a lot newer, and so it doesn't have quite the same feature parity as what you'll find in the desktop version,", 'start': 219.196, 'duration': 6.951}, {'end': 230.053, 'text': 'although microsoft is doing a really good job at adding more and more functionality.', 'start': 226.147, 'duration': 3.906}], 'summary': 'Desktop and web excel versions have similar basic usage, with the web version being newer and having less feature parity.', 'duration': 26.147, 'max_score': 203.906, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/e7xGuGqgp-Q/pics/e7xGuGqgp-Q203906.jpg'}, {'end': 309.879, 'src': 'embed', 'start': 280.117, 'weight': 4, 'content': [{'end': 284.179, 'text': 'When you first open Excel, you land on this screen and this is called the home screen.', 'start': 280.117, 'duration': 4.062}, {'end': 286.821, 'text': "And so on the left-hand side, you'll see that it's called home.", 'start': 284.22, 'duration': 2.601}, {'end': 292.445, 'text': "What you'll see on this page is you have a blank workbook that you could jump into if you just want to start from scratch.", 'start': 287.682, 'duration': 4.763}, {'end': 294.025, 'text': 'You also have a number of templates.', 'start': 292.485, 'duration': 1.54}, {'end': 295.346, 'text': 'You have some learning templates.', 'start': 294.046, 'duration': 1.3}, {'end': 297.828, 'text': 'You have a welcome to Excel, get more out of pivot tables.', 'start': 295.386, 'duration': 2.442}, {'end': 304.514, 'text': "If you're new to Excel, this is a very nice sheet to walk through, and it really does a good job at introducing Excel.", 'start': 298.608, 'duration': 5.906}, {'end': 309.879, 'text': 'You also have a number of templates that you can choose from, and if you want more, you could simply click on more templates.', 'start': 305.055, 'duration': 4.824}], 'summary': 'Excel home screen offers blank workbook and templates for new users.', 'duration': 29.762, 'max_score': 280.117, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/e7xGuGqgp-Q/pics/e7xGuGqgp-Q280117.jpg'}], 'start': 73.7, 'title': 'Obtaining and using microsoft excel', 'summary': 'Provides guidance on obtaining microsoft excel through pre-installation, office 365 subscription, or one-time purchase, and discusses accessing excel for free online, differences between desktop and web software, and navigating the home screen, with a focus on office 365 desktop software.', 'chapters': [{'end': 153.952, 'start': 73.7, 'title': 'Getting microsoft excel', 'summary': 'Guides on how to obtain microsoft excel, whether through pre-installation, a subscription to office 365, or a one-time purchase, with details on the various options and their features.', 'duration': 80.252, 'highlights': ["To obtain Microsoft Excel, one can either use the pre-installed Office on the computer or navigate to office.com and select 'Get Office' for the full-featured program, with options of subscriptions for Office 365 or a one-time purchase of Office Home and Student for $150, which includes Word, Excel, and PowerPoint.", 'Office 365 subscriptions offer Excel along with other apps, with the option to share it with up to six people, whereas the Office 365 personal subscription is limited to one person, providing all apps including Excel.']}, {'end': 368.481, 'start': 154.872, 'title': 'Accessing and using microsoft excel online', 'summary': 'Discusses accessing microsoft excel for free online, the differences between desktop and web software, and navigating the home screen of excel, with a focus on the desktop software of office 365.', 'duration': 213.609, 'highlights': ['Accessing Microsoft Excel for free online and creating a new account if needed Instructions for accessing Microsoft Excel for free online, including creating a new account if necessary.', 'Comparison between desktop and web software for Microsoft Excel Explains the differences between desktop and web software for Microsoft Excel, highlighting feature parity and offline usability.', 'Navigating the home screen of Excel and accessing templates and recent workbooks Demonstrates how to navigate the home screen of Excel, access templates, search for recent workbooks, and utilize different options for accessing existing content.']}], 'duration': 294.781, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/e7xGuGqgp-Q/pics/e7xGuGqgp-Q73700.jpg', 'highlights': ['To obtain Microsoft Excel, one can use pre-installed Office or navigate to office.com for full-featured program, with options of subscriptions for Office 365 or one-time purchase of Office Home and Student for $150.', 'Office 365 subscriptions offer Excel along with other apps, with option to share it with up to six people, whereas Office 365 personal subscription is limited to one person, providing all apps including Excel.', 'Accessing Microsoft Excel for free online and creating a new account if needed.', 'Comparison between desktop and web software for Microsoft Excel, highlighting feature parity and offline usability.', 'Navigating the home screen of Excel, accessing templates, recent workbooks, and utilizing different options for accessing existing content.']}, {'end': 956.496, 'segs': [{'end': 481.237, 'src': 'embed', 'start': 456.819, 'weight': 0, 'content': [{'end': 465.166, 'text': "And so if I want to reference an individual cell, so let's say I'm in this cell, what I would say is I'm in cell C and then 6.", 'start': 456.819, 'duration': 8.347}, {'end': 467.788, 'text': 'So you start with the column and then you say the row.', 'start': 465.166, 'duration': 2.622}, {'end': 470.67, 'text': "And you can see up here as well, it says that I'm in cell C6.", 'start': 467.808, 'duration': 2.862}, {'end': 475.113, 'text': 'And what you can also do is you could have a range of cells.', 'start': 472.131, 'duration': 2.982}, {'end': 479.556, 'text': "So here I'm in cell A8 through C8.", 'start': 475.553, 'duration': 4.003}, {'end': 481.237, 'text': "So that's how you could reference cells.", 'start': 479.956, 'duration': 1.281}], 'summary': 'Explains referencing individual cells in a spreadsheet, such as c6, and referencing a range like a8 through c8.', 'duration': 24.418, 'max_score': 456.819, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/e7xGuGqgp-Q/pics/e7xGuGqgp-Q456819.jpg'}, {'end': 652.399, 'src': 'embed', 'start': 627.061, 'weight': 1, 'content': [{'end': 632.085, 'text': 'So there are lots of different ways that I could format text and numbers within Microsoft Excel.', 'start': 627.061, 'duration': 5.024}, {'end': 637.889, 'text': "The next thing that we're going to do is we're going to jump into how to adjust the cell size.", 'start': 633.146, 'duration': 4.743}, {'end': 644.173, 'text': 'So here in my sheet, I have this table of data and I have my columns, I have my rows.', 'start': 638.33, 'duration': 5.843}, {'end': 650.438, 'text': 'What you can do is if you click in between a row, I could expand the size of the row or I could contract it.', 'start': 644.273, 'duration': 6.165}, {'end': 652.399, 'text': 'I could do the same with columns as well.', 'start': 650.778, 'duration': 1.621}], 'summary': 'Demonstrating excel formatting options, including adjusting cell size.', 'duration': 25.338, 'max_score': 627.061, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/e7xGuGqgp-Q/pics/e7xGuGqgp-Q627061.jpg'}, {'end': 717.713, 'src': 'heatmap', 'start': 670.47, 'weight': 0.781, 'content': [{'end': 675.013, 'text': "So I'm gonna double-click and it simply adjusts it to make sure it fits all the text nicely.", 'start': 670.47, 'duration': 4.543}, {'end': 677.074, 'text': 'I could also do the same with rows.', 'start': 675.033, 'duration': 2.041}, {'end': 680.496, 'text': "Here I'm gonna click into the row and then there I could reduce the height.", 'start': 677.554, 'duration': 2.942}, {'end': 693.47, 'text': "A quick little trick that you can do if you want all your data to fit perfectly is you simply click up here in the top left hand corner and then I'm going to double click on the column and you'll notice now that all the columns adjusted to the text size.", 'start': 681.176, 'duration': 12.294}, {'end': 696.133, 'text': "and then I could do the same with the row and it'll adjust all the rows.", 'start': 693.47, 'duration': 2.663}, {'end': 699.337, 'text': 'So kind of a nice way to simply format your data.', 'start': 696.794, 'duration': 2.543}, {'end': 704.305, 'text': "What I can also do is let's say I'm working with my data and I want to insert a column.", 'start': 700.242, 'duration': 4.063}, {'end': 707.286, 'text': "Let's say I wanted some other value in between model and color.", 'start': 704.325, 'duration': 2.961}, {'end': 710.528, 'text': 'I could simply right click up here and I could go to insert.', 'start': 707.627, 'duration': 2.901}, {'end': 717.713, 'text': "So let's say insert another column and then I could go in between rows and I could do the same where I right click and then I could insert and that'll appear right above.", 'start': 710.568, 'duration': 7.145}], 'summary': 'Demonstrates adjusting text and inserting columns and rows in a table.', 'duration': 47.243, 'max_score': 670.47, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/e7xGuGqgp-Q/pics/e7xGuGqgp-Q670470.jpg'}, {'end': 850.625, 'src': 'heatmap', 'start': 822.905, 'weight': 0.768, 'content': [{'end': 825.448, 'text': "hit enter and there it's added up all the values.", 'start': 822.905, 'duration': 2.543}, {'end': 833.113, 'text': 'Now what I can also do is I can also type in equals sum and I can do that across these numbers which are horizontal.', 'start': 826.148, 'duration': 6.965}, {'end': 836.775, 'text': "And I'll close the parentheses and hit enter and now it added up all these numbers.", 'start': 833.453, 'duration': 3.322}, {'end': 844.5, 'text': 'Now a nice little shortcut and this is kind of more of a pro move, what you can do is you simply press the alt and the equals key at the same time.', 'start': 837.576, 'duration': 6.924}, {'end': 850.625, 'text': "So I'm going to press alt and equals and you'll notice that it automatically sums up all those values and I can hit enter.", 'start': 844.52, 'duration': 6.105}], 'summary': 'Using shortcuts to sum values in excel, including using alt+equals for automatic summing.', 'duration': 27.72, 'max_score': 822.905, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/e7xGuGqgp-Q/pics/e7xGuGqgp-Q822905.jpg'}, {'end': 965.717, 'src': 'embed', 'start': 937.982, 'weight': 2, 'content': [{'end': 941.785, 'text': 'And here I could count all the different numbers that appear within this set.', 'start': 937.982, 'duration': 3.803}, {'end': 946.248, 'text': "So using Excel, it's very easy to use Excel.", 'start': 942.605, 'duration': 3.643}, {'end': 953.273, 'text': 'When you use functions and formulas, you could really do some nice kind of calculations on your data in the sheet.', 'start': 946.268, 'duration': 7.005}, {'end': 956.496, 'text': "When I think of Excel, it's really like a very powerful calculator.", 'start': 953.314, 'duration': 3.182}, {'end': 965.717, 'text': "Okay, now that we've wrapped up on basic formulas, now we're going to jump into fill series and I'll kind of walk through what I mean by this.", 'start': 959.255, 'duration': 6.462}], 'summary': 'Using excel, you can perform powerful calculations on data with functions and formulas.', 'duration': 27.735, 'max_score': 937.982, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/e7xGuGqgp-Q/pics/e7xGuGqgp-Q937982.jpg'}], 'start': 368.481, 'title': 'Excel fundamentals and basic formulas', 'summary': "Covers excel basics, such as navigating worksheets, understanding cells, columns, and rows, and referencing cells. it also delves into formatting options, cell adjustment techniques, and basic formula usage, showcasing excel's efficiency in data manipulation.", 'chapters': [{'end': 499.189, 'start': 368.481, 'title': 'Excel basics and formatting', 'summary': 'Covers the basics of excel, including navigating through worksheets, understanding cells, columns, and rows, and referencing individual cells and cell ranges.', 'duration': 130.708, 'highlights': ['The chapter explains the basics of Excel, such as navigating through different worksheets, understanding cells, columns, and rows, and referencing individual cells and cell ranges.', 'It demonstrates how to rename and insert new worksheets, change worksheet colors, and explains the concept of cells, columns, and rows in Excel.', 'The chapter provides a clear explanation of referencing individual cells and cell ranges in Excel, using examples such as cell C6 and range A8:C8.', 'It draws a comparison between Excel cells and the game of Battleship, highlighting the similarity in the setup of columns and rows.']}, {'end': 956.496, 'start': 499.91, 'title': 'Excel formatting, cell adjustment, and basic formulas', 'summary': 'Covers various formatting options for numbers, cell adjustment techniques, and basic formula usage in excel, demonstrating the power and efficiency of excel functions and formulas in performing calculations on data.', 'duration': 456.586, 'highlights': ['Excel formatting options include accounting number format, adding commas, removing decimals, applying fraction format, and text formatting like merging cells and wrapping text, making numbers easier to read and enhancing text presentation. The chapter discusses various Excel formatting options such as accounting number format, adding commas, removing decimals, applying fraction format, merging cells, and wrapping text to improve number readability and text presentation.', 'Demonstrates techniques for adjusting row and column sizes, including expanding, contracting, and using a quick trick to resize all columns and rows to fit the text nicely, providing efficient methods for adjusting cell sizes. The tutorial demonstrates techniques for adjusting row and column sizes, including expanding, contracting, and a quick trick to resize all columns and rows to fit the text nicely, providing efficient methods for adjusting cell sizes.', 'Explains the usage of basic formulas and functions in Excel for addition, subtraction, multiplication, division, finding sum, average, max, min, and counting numbers, showcasing the power and ease of performing calculations on data using Excel functions. The chapter explains the usage of basic formulas and functions in Excel for addition, subtraction, multiplication, division, finding sum, average, max, min, and counting numbers, showcasing the power and ease of performing calculations on data using Excel functions.']}], 'duration': 588.015, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/e7xGuGqgp-Q/pics/e7xGuGqgp-Q368481.jpg', 'highlights': ['The chapter provides a clear explanation of referencing individual cells and cell ranges in Excel, using examples such as cell C6 and range A8:C8.', 'The tutorial demonstrates techniques for adjusting row and column sizes, including expanding, contracting, and a quick trick to resize all columns and rows to fit the text nicely, providing efficient methods for adjusting cell sizes.', 'Explains the usage of basic formulas and functions in Excel for addition, subtraction, multiplication, division, finding sum, average, max, min, and counting numbers, showcasing the power and ease of performing calculations on data using Excel functions.', 'Excel formatting options include accounting number format, adding commas, removing decimals, applying fraction format, merging cells, and wrapping text to improve number readability and text presentation.']}, {'end': 1338.717, 'segs': [{'end': 1049.425, 'src': 'heatmap', 'start': 959.255, 'weight': 1, 'content': [{'end': 965.717, 'text': "Okay, now that we've wrapped up on basic formulas, now we're going to jump into fill series and I'll kind of walk through what I mean by this.", 'start': 959.255, 'duration': 6.462}, {'end': 968.158, 'text': "So let's say I have this table of data.", 'start': 965.777, 'duration': 2.381}, {'end': 971.639, 'text': "So it's a car dealership and I want to know what my profit margin is.", 'start': 968.198, 'duration': 3.441}, {'end': 975.34, 'text': 'Well, to calculate profit margin, you want to take the price and you want to subtract the cost.', 'start': 971.679, 'duration': 3.661}, {'end': 977.42, 'text': "So here I'm going to enter a formula again.", 'start': 975.82, 'duration': 1.6}, {'end': 982.282, 'text': "I'm going to type in equals and then we'll take cell E4 minus cell F4.", 'start': 977.44, 'duration': 4.842}, {'end': 985.404, 'text': 'and so this is my profit margin.', 'start': 983.482, 'duration': 1.922}, {'end': 988.247, 'text': 'now what i mean by fill series is see that little plus sign.', 'start': 985.404, 'duration': 2.843}, {'end': 993.373, 'text': "if i double click on it, it'll simply take my formula and apply it all the way down.", 'start': 988.247, 'duration': 5.126}, {'end': 1000.34, 'text': "so here, if i click into this cell and i click on, i click into the formula you'll notice that what it's doing is it's taking this value,", 'start': 993.373, 'duration': 6.967}, {'end': 1001.081, 'text': 'minus this value.', 'start': 1000.34, 'duration': 0.741}, {'end': 1005.565, 'text': 'so basically took my formula and applied it all the way down, which is pretty nice.', 'start': 1001.081, 'duration': 4.484}, {'end': 1013.785, 'text': "now one of the things i might also want to do is, let's say i want to do my profit margin less kevin's fee,", 'start': 1006.658, 'duration': 7.127}, {'end': 1017.488, 'text': 'because maybe i own this dealership and i want to get paid for every car that gets sold.', 'start': 1013.785, 'duration': 3.703}, {'end': 1019.01, 'text': 'the price minus the cost.', 'start': 1017.488, 'duration': 1.522}, {'end': 1020.211, 'text': "and then here's my fee.", 'start': 1019.01, 'duration': 1.201}, {'end': 1024.395, 'text': "so i'll minus my fee there and now i could copy the formula all the way down.", 'start': 1020.211, 'duration': 4.184}, {'end': 1031.619, 'text': "now one of the problems is, when i go to the second cell, you'll see that it moved all of these down, one That's called a relative cell reference.", 'start': 1024.395, 'duration': 7.224}, {'end': 1035.601, 'text': 'What I want to do is I want it to keep this reference to this spot.', 'start': 1031.66, 'duration': 3.941}, {'end': 1038.482, 'text': "And what I could do then is I'll go back to my original formula.", 'start': 1036.141, 'duration': 2.341}, {'end': 1044.404, 'text': 'You can insert a dollar sign before the management fee and before the letter and before the number.', 'start': 1038.521, 'duration': 5.883}, {'end': 1049.425, 'text': 'And what that basically tells Excel is that you want to fix the position of that cell when you do your calculation.', 'start': 1044.424, 'duration': 5.001}], 'summary': 'Demonstrating fill series and fixing cell references in excel formulas.', 'duration': 41.085, 'max_score': 959.255, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/e7xGuGqgp-Q/pics/e7xGuGqgp-Q959255.jpg'}, {'end': 1099.674, 'src': 'embed', 'start': 1071.963, 'weight': 7, 'content': [{'end': 1079.904, 'text': "you could also press the F4 key when you're hovering over this value and that'll automatically toggle back and forth between an absolute reference.", 'start': 1071.963, 'duration': 7.941}, {'end': 1086.426, 'text': "And you could also just do a dollar sign for a row or for the column, depending on how you're filling your formula.", 'start': 1079.924, 'duration': 6.502}, {'end': 1091.229, 'text': 'so there, there it is one of the things i can also do with this sheet.', 'start': 1086.926, 'duration': 4.303}, {'end': 1092.93, 'text': 'i can also transpose the data.', 'start': 1091.229, 'duration': 1.701}, {'end': 1099.674, 'text': 'so right now you see that the data is organized in kind of this vertical orientation, where i have my column headers and then the data down below.', 'start': 1092.93, 'duration': 6.744}], 'summary': 'Excel tips include using f4 key for absolute reference and transposing data.', 'duration': 27.711, 'max_score': 1071.963, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/e7xGuGqgp-Q/pics/e7xGuGqgp-Q1071963.jpg'}, {'end': 1137.562, 'src': 'heatmap', 'start': 1103.937, 'weight': 4, 'content': [{'end': 1108.158, 'text': "so what i can do is i can highlight all my data And what I'm going to do is I'm going to go to paste.", 'start': 1103.937, 'duration': 4.221}, {'end': 1109.739, 'text': "So I'm going to go up to paste.", 'start': 1108.198, 'duration': 1.541}, {'end': 1111.779, 'text': "I'm going to click there and I'm going to go to paste special.", 'start': 1109.779, 'duration': 2}, {'end': 1113.86, 'text': "And now I'm going to go to transpose.", 'start': 1112.199, 'duration': 1.661}, {'end': 1115.98, 'text': "And so I'm going to click OK.", 'start': 1115.02, 'duration': 0.96}, {'end': 1119.001, 'text': "And you'll see what happened is it transposed all my data.", 'start': 1116.4, 'duration': 2.601}, {'end': 1125.622, 'text': 'So now all of my columns are now rows and all of my data now appears going this way.', 'start': 1119.021, 'duration': 6.601}, {'end': 1129.723, 'text': "So it's a nice way if you want to adjust the orientation of your data.", 'start': 1126.302, 'duration': 3.421}, {'end': 1137.562, 'text': 'Another thing that I want to show with filling data is Excel is pretty smart when you fill data down.', 'start': 1132.859, 'duration': 4.703}], 'summary': 'Using excel, transposing data and filling data down efficiently.', 'duration': 33.625, 'max_score': 1103.937, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/e7xGuGqgp-Q/pics/e7xGuGqgp-Q1103937.jpg'}, {'end': 1174.035, 'src': 'embed', 'start': 1146.327, 'weight': 0, 'content': [{'end': 1153.011, 'text': "Excel is smart knowing that if there's a Q1, well, they're going to be four quarters in a year and it automatically increments that by one.", 'start': 1146.327, 'duration': 6.684}, {'end': 1156.933, 'text': "So when you fill with Excel, it's pretty smart about how it fills.", 'start': 1153.411, 'duration': 3.522}, {'end': 1161.649, 'text': "The next thing that we're going to look at is how to split data.", 'start': 1158.368, 'duration': 3.281}, {'end': 1165.431, 'text': "So I'm going to click into the split data tab in here.", 'start': 1161.669, 'duration': 3.762}, {'end': 1169.173, 'text': "One of the things that you'll see is I have first name and then I have last name.", 'start': 1165.571, 'duration': 3.602}, {'end': 1174.035, 'text': 'What I would like to do is I want to separate these by first name and then last name.', 'start': 1169.193, 'duration': 4.842}], 'summary': 'Excel automates quarter increments, splits data by first and last name.', 'duration': 27.708, 'max_score': 1146.327, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/e7xGuGqgp-Q/pics/e7xGuGqgp-Q1146327.jpg'}, {'end': 1244.782, 'src': 'heatmap', 'start': 1178.077, 'weight': 0.918, 'content': [{'end': 1182.779, 'text': "What you can do is click on all these names and then we're going to click on the data tab.", 'start': 1178.077, 'duration': 4.702}, {'end': 1191.025, 'text': "and within the data tab we are going to click on something called text to columns, and what we're going to say is this is delimited.", 'start': 1183.719, 'duration': 7.306}, {'end': 1196.889, 'text': "so i'm going to click on next, and the way that they're separated is there's a space in between them.", 'start': 1191.025, 'duration': 5.864}, {'end': 1202.593, 'text': 'but you could also do it by tab, semicolon, comma or any other way that the data might be separated.', 'start': 1196.889, 'duration': 5.704}, {'end': 1206.937, 'text': "so i'm going to click on next, then, and for the destination.", 'start': 1202.593, 'duration': 4.344}, {'end': 1210.179, 'text': "what we're going to do is right now it wants to put it in a2.", 'start': 1206.937, 'duration': 3.242}, {'end': 1211.7, 'text': "what i'm going to say is let's put it into b2.", 'start': 1210.179, 'duration': 1.521}, {'end': 1216.623, 'text': "Um, so, basically I want the data to go into this cell and I'm going to click on finish.", 'start': 1213.001, 'duration': 3.622}, {'end': 1224.887, 'text': "And what you'll see happened is it just separated all of my list by the space that appears and it split them up between first name and last name.", 'start': 1216.843, 'duration': 8.044}, {'end': 1227.229, 'text': 'So kind of a nice way you can manipulate your data.', 'start': 1224.907, 'duration': 2.322}, {'end': 1231.131, 'text': "The next thing that we're going to look at is filtering and sorting data.", 'start': 1228.189, 'duration': 2.942}, {'end': 1234.913, 'text': 'This is something that I really love and really helps me look at my data in better ways.', 'start': 1231.191, 'duration': 3.722}, {'end': 1244.782, 'text': 'click on the filter and sort, and what i can do now is so i have this data table of all these different cars models, colors, mileage, price and costs.', 'start': 1236.636, 'duration': 8.146}], 'summary': 'Demonstrates data manipulation by using text to columns and filtering/sorting data.', 'duration': 66.705, 'max_score': 1178.077, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/e7xGuGqgp-Q/pics/e7xGuGqgp-Q1178077.jpg'}, {'end': 1206.937, 'src': 'embed', 'start': 1183.719, 'weight': 5, 'content': [{'end': 1191.025, 'text': "and within the data tab we are going to click on something called text to columns, and what we're going to say is this is delimited.", 'start': 1183.719, 'duration': 7.306}, {'end': 1196.889, 'text': "so i'm going to click on next, and the way that they're separated is there's a space in between them.", 'start': 1191.025, 'duration': 5.864}, {'end': 1202.593, 'text': 'but you could also do it by tab, semicolon, comma or any other way that the data might be separated.', 'start': 1196.889, 'duration': 5.704}, {'end': 1206.937, 'text': "so i'm going to click on next, then, and for the destination.", 'start': 1202.593, 'duration': 4.344}], 'summary': "Using 'text to columns' in data tab to separate data by space or other delimiters.", 'duration': 23.218, 'max_score': 1183.719, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/e7xGuGqgp-Q/pics/e7xGuGqgp-Q1183719.jpg'}, {'end': 1257.933, 'src': 'embed', 'start': 1228.189, 'weight': 6, 'content': [{'end': 1231.131, 'text': "The next thing that we're going to look at is filtering and sorting data.", 'start': 1228.189, 'duration': 2.942}, {'end': 1234.913, 'text': 'This is something that I really love and really helps me look at my data in better ways.', 'start': 1231.191, 'duration': 3.722}, {'end': 1244.782, 'text': 'click on the filter and sort, and what i can do now is so i have this data table of all these different cars models, colors, mileage, price and costs.', 'start': 1236.636, 'duration': 8.146}, {'end': 1249.906, 'text': "and what i can do is i'm going to go up into the data tab up on top and i'm going to click on this thing called filter.", 'start': 1244.782, 'duration': 5.124}, {'end': 1257.933, 'text': "so we're going to apply a filter and what happened is it added this little drop down with an arrow on top of all of the different columns.", 'start': 1249.906, 'duration': 8.027}], 'summary': 'Demonstrating filtering and sorting of car data using excel.', 'duration': 29.744, 'max_score': 1228.189, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/e7xGuGqgp-Q/pics/e7xGuGqgp-Q1228189.jpg'}], 'start': 959.255, 'title': 'Excel data manipulation techniques', 'summary': 'Covers various excel data manipulation techniques, such as using fill series to calculate profit margin and employing functions like absolute and relative cell references, transposing data, smart data filling, text to columns, filtering, and sorting. these techniques aim to increase productivity and efficiency.', 'chapters': [{'end': 1020.211, 'start': 959.255, 'title': 'Using fill series for calculating profit margin', 'summary': 'Demonstrates the use of fill series in excel to efficiently apply a formula for calculating profit margin across a table of data, reducing manual input and increasing productivity.', 'duration': 60.956, 'highlights': ['The use of fill series in Excel allows for the efficient application of a formula across a table of data, reducing manual input and increasing productivity.', 'Demonstration of calculating profit margin by subtracting the cost from the price using a formula in Excel.', 'Explanation of how to utilize the fill series feature by double-clicking the plus sign to apply the formula across multiple cells in a column.']}, {'end': 1338.717, 'start': 1020.211, 'title': 'Excel data manipulation techniques', 'summary': 'Demonstrates various excel data manipulation techniques including absolute and relative cell references, transposing data, smart data filling, separating data using text to columns, filtering, and sorting data.', 'duration': 318.506, 'highlights': ['Excel is pretty smart when filling data, automatically incrementing values when filling with Excel.', 'Transposing data allows adjusting the orientation of the data, converting columns to rows and vice versa.', 'Using text to columns feature to separate data by specified delimiters such as space, tab, or comma for improved data manipulation.', 'Filtering and sorting data enables the user to view specific data subsets and organize data based on different criteria.', 'Applying absolute cell references by adding a dollar sign before cell references in Excel to fix the position of cells during calculations.']}], 'duration': 379.462, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/e7xGuGqgp-Q/pics/e7xGuGqgp-Q959255.jpg', 'highlights': ['The use of fill series in Excel allows for the efficient application of a formula across a table of data, reducing manual input and increasing productivity.', 'Demonstration of calculating profit margin by subtracting the cost from the price using a formula in Excel.', 'Explanation of how to utilize the fill series feature by double-clicking the plus sign to apply the formula across multiple cells in a column.', 'Excel is pretty smart when filling data, automatically incrementing values when filling with Excel.', 'Transposing data allows adjusting the orientation of the data, converting columns to rows and vice versa.', 'Using text to columns feature to separate data by specified delimiters such as space, tab, or comma for improved data manipulation.', 'Filtering and sorting data enables the user to view specific data subsets and organize data based on different criteria.', 'Applying absolute cell references by adding a dollar sign before cell references in Excel to fix the position of cells during calculations.']}, {'end': 1526.125, 'segs': [{'end': 1439.157, 'src': 'heatmap', 'start': 1344.62, 'weight': 0, 'content': [{'end': 1348.821, 'text': "the next thing that we're going to look at is creating tables in microsoft excel.", 'start': 1344.62, 'duration': 4.201}, {'end': 1351.122, 'text': "now, what's the value or benefit of a table?", 'start': 1348.821, 'duration': 2.301}, {'end': 1358.225, 'text': "so i'm going to go here and i'm back on the home tab and i'm going to click on format as a table and we'll just go with.", 'start': 1351.122, 'duration': 7.103}, {'end': 1361.688, 'text': "i'll go with the light design and my table has headers.", 'start': 1358.225, 'duration': 3.463}, {'end': 1362.909, 'text': "okay, so I've just inserted it.", 'start': 1361.688, 'duration': 1.221}, {'end': 1371.257, 'text': "So the benefit is that it's a little easier to read where each row in the table has this color that's been applied to it, so it's easy to read across.", 'start': 1363.349, 'duration': 7.908}, {'end': 1378.064, 'text': "What you can also do is let's say that I expand so here if I click down here, I could expand my table by one,", 'start': 1372.378, 'duration': 5.686}, {'end': 1381.205, 'text': 'and maybe i want to call this my margin column.', 'start': 1378.624, 'duration': 2.581}, {'end': 1387.546, 'text': "and for the margin one we did the formula earlier, but i'll take the price minus the cost and i'll hit enter.", 'start': 1381.205, 'duration': 6.341}, {'end': 1390.206, 'text': "what happened is i don't have to drag it down because it's a table.", 'start': 1387.546, 'duration': 2.66}, {'end': 1396.887, 'text': 'it knows that this formula applies to every single item in the table, so it automatically applies it to the entire table.', 'start': 1390.206, 'duration': 6.681}, {'end': 1397.488, 'text': "it's kind of nice.", 'start': 1396.887, 'duration': 0.601}, {'end': 1401.908, 'text': "it saves you some time if you know all the data is related and one thing that's really cool.", 'start': 1397.488, 'duration': 4.42}, {'end': 1404.649, 'text': "i didn't actually know this until recently, but something i think is cool.", 'start': 1401.908, 'duration': 2.741}, {'end': 1409.251, 'text': "Up here under Table Design there's an option called Total Row.", 'start': 1405.629, 'duration': 3.622}, {'end': 1410.392, 'text': "So I'm going to go ahead and click on that.", 'start': 1409.271, 'duration': 1.121}, {'end': 1413.034, 'text': 'And so see what happened is it added a total now.', 'start': 1410.772, 'duration': 2.262}, {'end': 1417.015, 'text': 'So my total of all my margins is about $12, 000.', 'start': 1413.134, 'duration': 3.881}, {'end': 1420.598, 'text': "If I click on that value, I get this little dropdown and I can say well, what's my average?", 'start': 1417.016, 'duration': 3.582}, {'end': 1422.76, 'text': "What's my average margin?", 'start': 1421.238, 'duration': 1.522}, {'end': 1426.023, 'text': "or what's my max margin that I have?", 'start': 1422.76, 'duration': 3.263}, {'end': 1427.224, 'text': "or I can just say what's my sum?", 'start': 1426.023, 'duration': 1.201}, {'end': 1431.829, 'text': 'So with a table, you can also very easily calculate sums.', 'start': 1427.545, 'duration': 4.284}, {'end': 1437.435, 'text': 'The next thing that I want to show you is how to do quick analysis in Microsoft Excel.', 'start': 1432.27, 'duration': 5.165}, {'end': 1439.157, 'text': 'So I just clicked on quick analysis.', 'start': 1437.635, 'duration': 1.522}], 'summary': 'Creating tables in excel allows for easy data organization and automatic formula application, saving time and enabling quick calculations like sum and average.', 'duration': 77.469, 'max_score': 1344.62, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/e7xGuGqgp-Q/pics/e7xGuGqgp-Q1344620.jpg'}, {'end': 1526.125, 'src': 'embed', 'start': 1472.357, 'weight': 1, 'content': [{'end': 1479.481, 'text': "And so there are many different kind of quick analysis tools that I could use when I'm looking at my data or maybe I just want to identify my top 10%.", 'start': 1472.357, 'duration': 7.124}, {'end': 1482.463, 'text': 'So just kind of a nice little quick way to analyze your data.', 'start': 1479.481, 'duration': 2.982}, {'end': 1487.526, 'text': 'The next thing I want to show is Ideas, and Ideas is something new in Excel.', 'start': 1483.544, 'duration': 3.982}, {'end': 1491.027, 'text': "It's up here on the Home tab, and you just click on Ideas.", 'start': 1487.586, 'duration': 3.441}, {'end': 1498.99, 'text': "This is part of Office 365, and what it does is it'll analyze all my data that I have, and it comes up with interesting insights based on it.", 'start': 1491.087, 'duration': 7.903}, {'end': 1501.451, 'text': 'So here I can see by color, what is the cost.', 'start': 1499.07, 'duration': 2.381}, {'end': 1503.012, 'text': "This one's interesting.", 'start': 1502.232, 'duration': 0.78}, {'end': 1506.173, 'text': 'Price and field cost appear highly correlated.', 'start': 1503.292, 'duration': 2.881}, {'end': 1509.395, 'text': 'So the cost and then the price of the car appear highly correlated.', 'start': 1506.233, 'duration': 3.162}, {'end': 1514.498, 'text': 'Um, the Toyo black Toyotas have a noticeably higher cost.', 'start': 1510.695, 'duration': 3.803}, {'end': 1519.601, 'text': 'And so what it does is it goes through my data and it finds a different outliers in my data.', 'start': 1514.538, 'duration': 5.063}, {'end': 1521.742, 'text': 'So it calls out kind of interesting insights to me.', 'start': 1519.641, 'duration': 2.101}, {'end': 1526.125, 'text': "So that's kind of a fun thing to run against your data to see if there are any interesting insights that might be there.", 'start': 1521.782, 'duration': 4.343}], 'summary': "Excel's new ideas feature analyzes data to provide insights and identify outliers, making analysis quicker and more efficient.", 'duration': 53.768, 'max_score': 1472.357, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/e7xGuGqgp-Q/pics/e7xGuGqgp-Q1472357.jpg'}], 'start': 1338.717, 'title': 'Excel tables, quick analysis, and office 365 data analysis', 'summary': "Covers the benefits of excel tables including time-saving features resulting in a total margin of approximately $12,000, how to use quick analysis tools in excel for calculations and visualization, and office 365's data analysis providing insights into correlation and outliers.", 'chapters': [{'end': 1417.015, 'start': 1338.717, 'title': 'Excel tables and benefits', 'summary': 'Discusses the benefits of creating tables in microsoft excel, such as easier data reading, automatic formula application, and the total row feature, which can save time and provide insights into the data, resulting in a total margin of approximately $12,000.', 'duration': 78.298, 'highlights': ['The Total Row feature in Excel tables provides insights into the data, resulting in a total margin of approximately $12,000.', 'Tables in Excel make it easier to read data, with each row having a distinct color, facilitating data analysis.', 'Formulas in Excel tables automatically apply to the entire table, saving time and effort in data computation.']}, {'end': 1491.027, 'start': 1417.016, 'title': 'Excel quick analysis and ideas', 'summary': 'Covers how to use quick analysis tools in microsoft excel to calculate averages, sums, and visualize data using data bars and color scales, as well as how to utilize the new ideas feature for quick data analysis.', 'duration': 74.011, 'highlights': ['Quick analysis tools in Excel allow for easy calculation of averages, sums, and visualization of data using data bars and color scales.', 'The Ideas feature in Excel provides a quick way to analyze data and is located on the Home tab.']}, {'end': 1526.125, 'start': 1491.087, 'title': 'Office 365 data analysis', 'summary': 'Discusses how office 365 analyzes data to provide interesting insights, such as correlation between cost and price, and identification of outliers in the data.', 'duration': 35.038, 'highlights': ['Office 365 analyzes data to provide insights based on cost and price correlation, identifying outliers (e.g., Toyo black Toyotas have a noticeably higher cost).', 'It calls out interesting insights by analyzing data and finding outliers, providing a fun way to discover unique patterns in the data.']}], 'duration': 187.408, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/e7xGuGqgp-Q/pics/e7xGuGqgp-Q1338717.jpg', 'highlights': ['The Total Row feature in Excel tables provides insights into the data, resulting in a total margin of approximately $12,000.', 'Office 365 analyzes data to provide insights based on cost and price correlation, identifying outliers (e.g., Toyo black Toyotas have a noticeably higher cost).', 'Tables in Excel make it easier to read data, with each row having a distinct color, facilitating data analysis.', 'Quick analysis tools in Excel allow for easy calculation of averages, sums, and visualization of data using data bars and color scales.', 'Formulas in Excel tables automatically apply to the entire table, saving time and effort in data computation.', 'The Ideas feature in Excel provides a quick way to analyze data and is located on the Home tab.', 'It calls out interesting insights by analyzing data and finding outliers, providing a fun way to discover unique patterns in the data.']}, {'end': 1872.03, 'segs': [{'end': 1553.281, 'src': 'embed', 'start': 1528.655, 'weight': 0, 'content': [{'end': 1534.721, 'text': "Okay, now that we've looked at ideas, we're gonna go into charts, and I'm gonna show you how to create basic charts in Microsoft Excel.", 'start': 1528.655, 'duration': 6.066}, {'end': 1541.568, 'text': 'So I have this little table here with, you know, I have years on the left-hand side, and then I have conference attendees on the right-hand side.', 'start': 1534.761, 'duration': 6.807}, {'end': 1548.435, 'text': "And so what I could do is I'm gonna go up here and I'm gonna click on Insert, and then under Insert, I'm just gonna click on Recommended Charts.", 'start': 1541.588, 'duration': 6.847}, {'end': 1552.12, 'text': "And what you'll see is it just gives me all these different charts that I could insert.", 'start': 1549.276, 'duration': 2.844}, {'end': 1553.281, 'text': 'And the first one looks pretty good.', 'start': 1552.16, 'duration': 1.121}], 'summary': 'Demonstrating how to create basic charts in microsoft excel using a table with years and conference attendees data.', 'duration': 24.626, 'max_score': 1528.655, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/e7xGuGqgp-Q/pics/e7xGuGqgp-Q1528655.jpg'}, {'end': 1604.919, 'src': 'embed', 'start': 1577.872, 'weight': 1, 'content': [{'end': 1585.2, 'text': "and this time what i'm going to do is i'm going to click on all charts and i can do a combo chart, uh, where i have two pieces of data that i want to.", 'start': 1577.872, 'duration': 7.328}, {'end': 1586.501, 'text': 'that i want to chart out.', 'start': 1585.2, 'duration': 1.301}, {'end': 1587.502, 'text': 'and so food sales.', 'start': 1586.501, 'duration': 1.001}, {'end': 1589.464, 'text': 'maybe i want to make that a secondary access.', 'start': 1587.502, 'duration': 1.962}, {'end': 1592.847, 'text': 'so this is my primary one, this is my secondary one,', 'start': 1589.464, 'duration': 3.383}, {'end': 1597.932, 'text': "and so my food sales are now against the secondary access and i'm going to go ahead and click on ok,", 'start': 1592.847, 'duration': 5.085}, {'end': 1604.919, 'text': 'and so this is kind of a nice view where you know, here i could see the attendees and then i could see the food sales against the number of attendees.', 'start': 1597.932, 'duration': 6.987}], 'summary': 'Creating a combo chart with food sales and attendees data, providing a clear visual representation.', 'duration': 27.047, 'max_score': 1577.872, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/e7xGuGqgp-Q/pics/e7xGuGqgp-Q1577872.jpg'}, {'end': 1654.912, 'src': 'embed', 'start': 1627.631, 'weight': 2, 'content': [{'end': 1633.176, 'text': 'And here I have, once again, I have all my car data in here and I have a lot of data.', 'start': 1627.631, 'duration': 5.545}, {'end': 1634.236, 'text': "So here I'm scrolling down.", 'start': 1633.196, 'duration': 1.04}, {'end': 1636.298, 'text': 'I have hundreds of hundreds of rows that show up.', 'start': 1634.276, 'duration': 2.022}, {'end': 1642.844, 'text': "And unfortunately, when I scroll down, I don't know what column D is or what column E is or what column F is.", 'start': 1636.879, 'duration': 5.965}, {'end': 1646.687, 'text': 'It would be nice to have the header stick with the data.', 'start': 1642.864, 'duration': 3.823}, {'end': 1649.25, 'text': 'And I can do that with something called freeze panes.', 'start': 1646.828, 'duration': 2.422}, {'end': 1654.912, 'text': "So if I click on, I'm going to click on view, and then you have this option called freeze panes.", 'start': 1649.79, 'duration': 5.122}], 'summary': 'The speaker wants to freeze panes to keep headers visible while scrolling through hundreds of rows of car data in an excel sheet.', 'duration': 27.281, 'max_score': 1627.631, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/e7xGuGqgp-Q/pics/e7xGuGqgp-Q1627631.jpg'}, {'end': 1757.595, 'src': 'embed', 'start': 1732.275, 'weight': 3, 'content': [{'end': 1738.323, 'text': 'And you could kind of do neat things where you summarize by, well, let me see the count of vehicles that I have by color.', 'start': 1732.275, 'duration': 6.048}, {'end': 1742.105, 'text': 'So, what I wanted to do is just give a very quick preview of pivot tables.', 'start': 1739.063, 'duration': 3.042}, {'end': 1745.367, 'text': 'You could feel free to play around with them and kind of see what the capabilities are.', 'start': 1742.145, 'duration': 3.222}, {'end': 1756.194, 'text': 'I also have a few additional videos down in the description and in the comments down below with links to more in-depth overviews of what are pivot tables.', 'start': 1745.787, 'duration': 10.407}, {'end': 1757.595, 'text': 'how do you do conditional formatting?', 'start': 1756.194, 'duration': 1.401}], 'summary': 'Introduction to pivot tables with additional resources for further learning.', 'duration': 25.32, 'max_score': 1732.275, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/e7xGuGqgp-Q/pics/e7xGuGqgp-Q1732275.jpg'}, {'end': 1811.108, 'src': 'embed', 'start': 1786.268, 'weight': 4, 'content': [{'end': 1791.771, 'text': 'or if you want to learn about pivot tables or conditional formatting or a lot more functions and formulas.', 'start': 1786.268, 'duration': 5.503}, {'end': 1795.073, 'text': "I have videos that cover all those topics and I've included links in the description.", 'start': 1791.771, 'duration': 3.302}, {'end': 1800.918, 'text': 'if you want to check those out and really increase your expertise in microsoft excel, but with this video,', 'start': 1795.493, 'duration': 5.425}, {'end': 1804.542, 'text': 'this really covers most of the fundamentals on a day-to-day basis.', 'start': 1800.918, 'duration': 3.624}, {'end': 1811.108, 'text': 'this is most of the stuff that i use and it really helps me use excel in a really good way and really helps me analyze data,', 'start': 1804.542, 'duration': 6.566}], 'summary': 'Learn pivot tables, conditional formatting, and more functions in excel for increased expertise, covering most day-to-day fundamentals.', 'duration': 24.84, 'max_score': 1786.268, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/e7xGuGqgp-Q/pics/e7xGuGqgp-Q1786268.jpg'}], 'start': 1528.655, 'title': 'Basic excel features', 'summary': 'Covers creating basic charts including recommended and combo charts, and freezing panes for data visualization, and provides a quick overview of pivot tables, demonstrating how to analyze data by summarizing costs and counting vehicles by color, and promoting advanced excel tutorials.', 'chapters': [{'end': 1678.762, 'start': 1528.655, 'title': 'Creating basic charts in excel', 'summary': 'Covers creating basic charts in microsoft excel, including recommended charts, combo charts, and freezing panes to enhance data visualization and analysis.', 'duration': 150.107, 'highlights': ['Demonstrating how to insert recommended charts and create basic charts based on provided data in Microsoft Excel. Inserting basic charts based on provided data.', 'Showing how to create a combo chart in Microsoft Excel to visualize two pieces of data and the concept of primary and secondary axes. Creating a combo chart to visualize two pieces of data.', 'Explaining the process of freezing panes to keep headers in place while scrolling through large sets of data in Microsoft Excel. Demonstrating the process of freezing panes to enhance data visualization.']}, {'end': 1872.03, 'start': 1680.145, 'title': 'Pivot tables in excel', 'summary': 'Provides a quick overview of pivot tables in excel, demonstrating how to create and use pivot tables to analyze data, including summarizing costs by color and counting vehicles by color, as well as promoting more in-depth tutorials for advanced excel functionalities and inviting viewer engagement.', 'duration': 191.885, 'highlights': ['The chapter provides a quick overview of pivot tables in Excel, demonstrating how to create and use pivot tables to analyze data, including summarizing costs by color and counting vehicles by color.', 'The video promotes more in-depth tutorials for advanced Excel functionalities, such as VLOOKUP, HLOOKUP, pivot tables, conditional formatting, and various functions and formulas, with links provided in the description for viewers to increase their expertise in Microsoft Excel.', 'The presenter invites viewer engagement by encouraging questions and suggestions for future video topics, while also emphasizing the potential for Excel to enhance professional and personal data analysis.']}], 'duration': 343.375, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/e7xGuGqgp-Q/pics/e7xGuGqgp-Q1528655.jpg', 'highlights': ['Demonstrating how to insert recommended charts and create basic charts based on provided data in Microsoft Excel.', 'Creating a combo chart in Microsoft Excel to visualize two pieces of data and the concept of primary and secondary axes.', 'Explaining the process of freezing panes to keep headers in place while scrolling through large sets of data in Microsoft Excel.', 'Providing a quick overview of pivot tables in Excel, demonstrating how to create and use pivot tables to analyze data, including summarizing costs by color and counting vehicles by color.', 'Promoting more in-depth tutorials for advanced Excel functionalities, such as VLOOKUP, HLOOKUP, pivot tables, conditional formatting, and various functions and formulas, with links provided in the description for viewers to increase their expertise in Microsoft Excel.']}], 'highlights': ['The tutorial provides a clear explanation of referencing individual cells and cell ranges in Excel, using examples such as cell C6 and range A8:C8.', 'The use of fill series in Excel allows for the efficient application of a formula across a table of data, reducing manual input and increasing productivity.', 'The Total Row feature in Excel tables provides insights into the data, resulting in a total margin of approximately $12,000.', 'Demonstrating how to insert recommended charts and create basic charts based on provided data in Microsoft Excel.', 'The video provides the option to navigate to specific content through timestamps, offering a strong foundation in Microsoft Excel.']}