title
Microsoft Excel Tutorial | Excel Basics for Beginners | Excel Training | Edureka

description
🔥Edureka Online Training: https://www.edureka.co/ This Edureka video on 'Excel Tutorial' will help you learn all the basics of MS Excel. Here are all the topics discussed in this Excel Basics for Beginners video: 0:54 What is Excel? 2:08 Screen Options 7:15 Backstage View 8:10 Excel Workbooks and Worksheets 8:53 Editing Worksheets 19:34 Formatting MS Excel Worksheets 30:53 MS Excel Formulas 33:01 MS Exce Functions #Edureka #ExcelEdureka #ExcelTutorial Do subscribe to our channel and hit the bell icon to never miss an update from us in the future: https://goo.gl/6ohpTV Instagram: https://www.instagram.com/edureka_learning/ Facebook: https://www.facebook.com/edurekaIN/ Twitter: https://twitter.com/edurekain LinkedIn: https://www.linkedin.com/company/edureka Castbox: https://castbox.fm/networks/505?country=in -------------------------------------------------------------------------- For more information, please write back to us at sales@edureka.in or call us at IND: 9606058406 / US: 18338555775 (toll-free)

detail
{'title': 'Microsoft Excel Tutorial | Excel Basics for Beginners | Excel Training | Edureka', 'heatmap': [{'end': 197.042, 'start': 170.784, 'weight': 0.704}, {'end': 1129.3, 'start': 1080.21, 'weight': 0.921}, {'end': 1536.83, 'start': 1507.732, 'weight': 1}, {'end': 1777.741, 'start': 1751.255, 'weight': 0.76}], 'summary': "This tutorial provides an overview of excel's features, interface, status bar, cell modes, data manipulation, efficient functions, cell formatting, sheet manipulation, page setup, page breaks, and formulas and functions, emphasizing their essential role in data storage and manipulation.", 'chapters': [{'end': 111.375, 'segs': [{'end': 111.375, 'src': 'embed', 'start': 52.714, 'weight': 0, 'content': [{'end': 57.818, 'text': 'So now moving on towards the first topic of the session, which is what exactly is Excel?', 'start': 52.714, 'duration': 5.104}, {'end': 63.542, 'text': 'Microsoft Excel is a spreadsheet or a computer application that allows storage of data in the tabular form.', 'start': 57.818, 'duration': 5.724}, {'end': 71.848, 'text': 'It was developed by Microsoft and it can be used on Windows Mac OS iOS and Android platforms according to Excel experts.', 'start': 64.223, 'duration': 7.625}, {'end': 74.931, 'text': 'The most important feature of Excel is conditional formatting.', 'start': 72.109, 'duration': 2.822}, {'end': 79.057, 'text': 'This allows you to represent your data in a number of ways.', 'start': 75.515, 'duration': 3.542}, {'end': 85.579, 'text': 'Excel also provides pivot tables that can be used to count, sort or find the average Etc from your data.', 'start': 79.057, 'duration': 6.522}, {'end': 88.02, 'text': 'copy-pasting is something we do almost every day.', 'start': 85.579, 'duration': 2.441}, {'end': 94.883, 'text': 'for many reasons, Excel provides a special feature, called as the paste special, that gives you many choices while copying data,', 'start': 88.02, 'duration': 6.863}, {'end': 98.365, 'text': 'such as selectively copy-pasting comments, values, formats, Etc.', 'start': 94.883, 'duration': 3.482}, {'end': 105.331, 'text': 'Excel also allows you to add multiple rows, has a system called as the relative cell address that helps,', 'start': 99.568, 'duration': 5.763}, {'end': 109.794, 'text': 'while copying formulas provides print optimizations, built-in functions, etc.', 'start': 105.331, 'duration': 4.463}, {'end': 111.375, 'text': 'Using Excel sheets.', 'start': 110.514, 'duration': 0.861}], 'summary': 'Excel is a versatile tool for data storage and manipulation, offering features like conditional formatting, pivot tables, and paste special functionality.', 'duration': 58.661, 'max_score': 52.714, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Dbd-OfbeW1w/pics/Dbd-OfbeW1w52714.jpg'}], 'start': 0.029, 'title': 'Excel tutorial overview', 'summary': 'Discusses the important features and functionalities of excel, including conditional formatting, pivot tables, paste special feature, and built-in functions, emphasizing its role as a spreadsheet application for data storage and manipulation across multiple platforms.', 'chapters': [{'end': 111.375, 'start': 0.029, 'title': 'Excel tutorial overview', 'summary': 'Discusses the important features and functionalities of excel, including conditional formatting, pivot tables, paste special feature, and built-in functions, emphasizing its role as a spreadsheet application for data storage and manipulation across multiple platforms.', 'duration': 111.346, 'highlights': ['Microsoft Excel is a spreadsheet or a computer application that allows storage of data in the tabular form. Excel is a spreadsheet application for data storage.', 'The most important feature of Excel is conditional formatting, allowing representation of data in various ways. Conditional formatting is a key feature of Excel.', 'Excel provides pivot tables that can be used to count, sort, or find the average from data. Pivot tables enable data analysis in Excel.', "Excel's paste special feature allows selective copy-pasting of comments, values, formats, etc. The paste special feature offers flexibility in copy-pasting data.", 'Excel includes print optimizations, built-in functions, and a system for copying formulas with a relative cell address. Excel offers print optimizations, built-in functions, and formula copying.']}], 'duration': 111.346, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Dbd-OfbeW1w/pics/Dbd-OfbeW1w29.jpg', 'highlights': ['Excel is a spreadsheet application for data storage.', 'Conditional formatting is a key feature of Excel.', 'Pivot tables enable data analysis in Excel.', 'The paste special feature offers flexibility in copy-pasting data.', 'Excel offers print optimizations, built-in functions, and formula copying.']}, {'end': 341.466, 'segs': [{'end': 138.203, 'src': 'embed', 'start': 111.755, 'weight': 1, 'content': [{'end': 119.96, 'text': 'You can create graphs analyze and validate your data and last but definitely not the least you can use macros and visual basic along with Excel.', 'start': 111.755, 'duration': 8.205}, {'end': 125.383, 'text': 'Okay So with this I hope you guys have a basic idea of what is Excel and its features.', 'start': 120.78, 'duration': 4.603}, {'end': 130.82, 'text': "So now let's move on and see what is the first screen that appears when you open a blank workbook.", 'start': 126.218, 'duration': 4.602}, {'end': 138.203, 'text': "So I'll jump on to my Excel workbook from here and I'll just show you guys what exactly is the first screen that you see when you open up Excel.", 'start': 131.84, 'duration': 6.363}], 'summary': 'Excel offers features like graph creation, data analysis, validation, macros, and visual basic, providing a comprehensive tool for data management and manipulation.', 'duration': 26.448, 'max_score': 111.755, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Dbd-OfbeW1w/pics/Dbd-OfbeW1w111755.jpg'}, {'end': 203.168, 'src': 'heatmap', 'start': 164.1, 'weight': 2, 'content': [{'end': 167.042, 'text': 'Okay, So next is the quick access toolbar.', 'start': 164.1, 'duration': 2.942}, {'end': 170.784, 'text': 'this toolbar consists of all commonly used Excel commands.', 'start': 167.042, 'duration': 3.742}, {'end': 174.226, 'text': 'in case you want to add some command that you use frequently to this toolbar.', 'start': 170.784, 'duration': 3.442}, {'end': 177.468, 'text': 'You can do it easily by customizing the quick access toolbar.', 'start': 174.487, 'duration': 2.981}, {'end': 180.03, 'text': 'Now to do this.', 'start': 179.37, 'duration': 0.66}, {'end': 187.374, 'text': 'All you have to do is right-click on the quick access toolbar and from the list of options choose the customize quick access toolbar option.', 'start': 180.15, 'duration': 7.224}, {'end': 192.939, 'text': "So, once you're done with this, you can see the Excel options window that's opened,", 'start': 188.855, 'duration': 4.084}, {'end': 197.042, 'text': 'and from here you can select any of the options that you would like to add to the quick access toolbar.', 'start': 192.939, 'duration': 4.103}, {'end': 203.168, 'text': "Once you're done adding it just click on OK and you will see it appearing in the quick access toolbar.", 'start': 197.823, 'duration': 5.345}], 'summary': 'Customize quick access toolbar in excel to add frequently used commands easily.', 'duration': 39.068, 'max_score': 164.1, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Dbd-OfbeW1w/pics/Dbd-OfbeW1w164100.jpg'}, {'end': 223.14, 'src': 'embed', 'start': 197.823, 'weight': 3, 'content': [{'end': 203.168, 'text': "Once you're done adding it just click on OK and you will see it appearing in the quick access toolbar.", 'start': 197.823, 'duration': 5.345}, {'end': 206.751, 'text': 'Okay So now moving on towards the next which is the ribbon bar.', 'start': 203.888, 'duration': 2.863}, {'end': 215.872, 'text': 'The ribbon bar consists of file home insert page layout and all other tabs that you see over here just like the quick access toolbar.', 'start': 207.583, 'duration': 8.289}, {'end': 218.895, 'text': 'You can also customize your ribbon bar to do it.', 'start': 216.112, 'duration': 2.783}, {'end': 223.14, 'text': 'Just right click anywhere on the ribbon bar and choose the customize ribbon option.', 'start': 219.175, 'duration': 3.965}], 'summary': "Customize the ribbon bar by right-clicking and selecting 'customize ribbon.'", 'duration': 25.317, 'max_score': 197.823, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Dbd-OfbeW1w/pics/Dbd-OfbeW1w197823.jpg'}, {'end': 341.466, 'src': 'embed', 'start': 317.807, 'weight': 0, 'content': [{'end': 324.854, 'text': 'So basically the maximum number of rows that are available in an Excel sheet is 10 lakhs 48 thousand 576 similar to the row bar is the column bar.', 'start': 317.807, 'duration': 7.047}, {'end': 332.343, 'text': 'The column bar shows columns in an A to Z order.', 'start': 329.682, 'duration': 2.661}, {'end': 338.225, 'text': 'It starts from A and goes on till Z following which it goes on as AA AB, etc.', 'start': 332.843, 'duration': 5.382}, {'end': 341.466, 'text': 'The upper limit for columns is 16, 000 384.', 'start': 338.825, 'duration': 2.641}], 'summary': 'Excel sheet can have up to 10,48,576 rows and 16,384 columns.', 'duration': 23.659, 'max_score': 317.807, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Dbd-OfbeW1w/pics/Dbd-OfbeW1w317807.jpg'}], 'start': 111.755, 'title': 'Excel features and interface overview', 'summary': 'Introduces excel features such as graph creation, data analysis, validation, macros, and visual basic. it also provides an overview of the excel interface, covering title bar, quick access toolbar, ribbon bar, zoom control buttons, sheet area, rows, and columns, with customization options and maximum limits for rows and columns.', 'chapters': [{'end': 143.545, 'start': 111.755, 'title': 'Excel features and first screen', 'summary': 'Introduces the features of excel, including graph creation, data analysis, validation, and the use of macros and visual basic, followed by an overview of the first screen of a blank workbook in excel.', 'duration': 31.79, 'highlights': ['The chapter explains the features of Excel such as graph creation, data analysis, and validation, as well as the use of macros and visual basic.', 'The chapter provides an overview of the first screen that appears when opening a blank workbook in Excel.']}, {'end': 341.466, 'start': 144.265, 'title': 'Excel interface overview', 'summary': 'Provides an overview of the excel interface, covering the title bar, quick access toolbar, ribbon bar, zoom control buttons, sheet area, rows, and columns, including customizing options and maximum limits for rows and columns.', 'duration': 197.201, 'highlights': ['The ribbon bar consists of file home insert page layout and all other tabs that you see over here just like the quick access toolbar. Highlights the content of the ribbon bar and its similarity to the quick access toolbar.', 'The maximum number of rows available in an Excel sheet is 10 lakhs 48 thousand 576, and the upper limit for columns is 16,000 384. Provides quantifiable data about the maximum limits for rows and columns in an Excel sheet.', 'The quick access toolbar consists of all commonly used Excel commands, and users can customize it by right-clicking on the toolbar and choosing the customize quick access toolbar option. Emphasizes the customization option for the quick access toolbar and its purpose.', 'Zoom control option allows you to zoom in and out of the sheet, and the sheet area is the combination of all the rows and columns present in the Excel sheet. Highlights the functionality of the zoom control option and defines the sheet area.', 'The title bar displays the title of the sheet and appears in the middle at the top of the Excel window. Provides information about the purpose and position of the title bar in the Excel interface.']}], 'duration': 229.711, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Dbd-OfbeW1w/pics/Dbd-OfbeW1w111755.jpg', 'highlights': ['The maximum number of rows available in an Excel sheet is 10 lakhs 48 thousand 576, and the upper limit for columns is 16,000 384.', 'The chapter explains the features of Excel such as graph creation, data analysis, and validation, as well as the use of macros and visual basic.', 'The quick access toolbar consists of all commonly used Excel commands, and users can customize it by right-clicking on the toolbar and choosing the customize quick access toolbar option.', 'The ribbon bar consists of file home insert page layout and all other tabs that you see over here just like the quick access toolbar.']}, {'end': 697.297, 'segs': [{'end': 384.604, 'src': 'embed', 'start': 341.466, 'weight': 0, 'content': [{'end': 350.85, 'text': 'Okay So now coming down towards the status bar the status bar is used to display the current status of the cell that is active in that sheet.', 'start': 341.466, 'duration': 9.384}, {'end': 355.912, 'text': 'There are basically four states, namely ready, edit, enter and point.', 'start': 351.65, 'duration': 4.262}, {'end': 359.656, 'text': 'Okay. so the first state is the ready state.', 'start': 356.855, 'duration': 2.801}, {'end': 365.138, 'text': "now. this, as the name suggest, is used to indicate that the worksheet can accept the user's input.", 'start': 359.656, 'duration': 5.482}, {'end': 372.08, 'text': 'now, once you select the cell to enter some data, the status bar will show the enter mode now in case I want to enter some data.', 'start': 365.138, 'duration': 6.942}, {'end': 375.421, 'text': "All I have to do is type it in so I'll just write hello world.", 'start': 372.36, 'duration': 3.061}, {'end': 378.982, 'text': "And I'll hit enter.", 'start': 378.342, 'duration': 0.64}, {'end': 384.604, 'text': "So as you can see over here my cell contains the data that I've written to it.", 'start': 380.823, 'duration': 3.781}], 'summary': 'Status bar displays 4 states: ready, edit, enter, point. user can input data in enter mode.', 'duration': 43.138, 'max_score': 341.466, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Dbd-OfbeW1w/pics/Dbd-OfbeW1w341466.jpg'}, {'end': 447.42, 'src': 'embed', 'start': 401.758, 'weight': 1, 'content': [{'end': 407.182, 'text': 'this mode is enabled when a formula is being entered into a cell with reference to the data present in some other cell.', 'start': 401.758, 'duration': 5.424}, {'end': 414.006, 'text': 'Okay, say for example, I have some values say 2 and 3 and I want to calculate the sum of this.', 'start': 408.022, 'duration': 5.984}, {'end': 422.296, 'text': 'All I have to do is write an equal to sign and then say some and give the reference of the cell that I want to point to now,', 'start': 414.77, 'duration': 7.526}, {'end': 424.598, 'text': "since I'm pointing to a3 over here.", 'start': 422.296, 'duration': 2.302}, {'end': 427.801, 'text': 'you can see that the status bar shows the point mode is enabled.', 'start': 424.598, 'duration': 3.203}, {'end': 436.347, 'text': 'Okay, So with this I hope you guys are clear, with all the four modes now moving on towards the next, which is the backstage view,', 'start': 427.821, 'duration': 8.526}, {'end': 437.528, 'text': 'to go to the backstage view.', 'start': 436.347, 'duration': 1.181}, {'end': 440.491, 'text': 'You should click on the file option that is present in the ribbon bar.', 'start': 437.889, 'duration': 2.602}, {'end': 447.42, 'text': 'The backstage view is the central managing place for all your Excel sheets from here.', 'start': 442.737, 'duration': 4.683}], 'summary': 'Excel mode enables referencing cells, summing values, backstage view centralizes excel sheets.', 'duration': 45.662, 'max_score': 401.758, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Dbd-OfbeW1w/pics/Dbd-OfbeW1w401758.jpg'}, {'end': 543.182, 'src': 'embed', 'start': 512.034, 'weight': 2, 'content': [{'end': 515.595, 'text': 'These sheets will be displayed at the bottom of the window with their respective names.', 'start': 512.034, 'duration': 3.561}, {'end': 523.198, 'text': 'So as you can see over here, I just have one sheet in my workbook and it is named as sheet 1 now in case I have to rename this sheet.', 'start': 516.215, 'duration': 6.983}, {'end': 526.819, 'text': 'All I have to do is double click on it and type in whatever name I want.', 'start': 523.298, 'duration': 3.521}, {'end': 527.9, 'text': "So I'll just say example.", 'start': 526.94, 'duration': 0.96}, {'end': 532.477, 'text': "or I'll say example 1 and I'll hit enter.", 'start': 528.635, 'duration': 3.842}, {'end': 537.199, 'text': "Okay So now let's move on and see how you can actually work with Excel sheets.", 'start': 533.317, 'duration': 3.882}, {'end': 543.182, 'text': 'Now the first thing that you will want to do is enter data into your Excel sheets as mentioned earlier.', 'start': 538, 'duration': 5.182}], 'summary': 'Demonstrating how to add and rename sheets in excel.', 'duration': 31.148, 'max_score': 512.034, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Dbd-OfbeW1w/pics/Dbd-OfbeW1w512034.jpg'}, {'end': 578.063, 'src': 'embed', 'start': 551.447, 'weight': 3, 'content': [{'end': 558.25, 'text': 'Now if you wish to choose some particular cell just left click on that cell and then double click on the same to enable the enter mode.', 'start': 551.447, 'duration': 6.803}, {'end': 564.59, 'text': "Once you've entered the required data, you'll have to save your workbook now in order to save the workbook.", 'start': 559.125, 'duration': 5.465}, {'end': 571.076, 'text': 'All you have to do is click on the file tab and choose the save or the save as option according to your preference.', 'start': 564.931, 'duration': 6.145}, {'end': 578.063, 'text': 'The default format in which the Excel file will be saved is the dot xlsx format.', 'start': 573.038, 'duration': 5.025}], 'summary': 'To select a cell, left click and then double click to enter data. save by clicking file tab and choosing save or save as. excel files are saved in dot xlsx format.', 'duration': 26.616, 'max_score': 551.447, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Dbd-OfbeW1w/pics/Dbd-OfbeW1w551447.jpg'}, {'end': 626.243, 'src': 'embed', 'start': 596.206, 'weight': 4, 'content': [{'end': 599.009, 'text': 'All you have to do is click on this plus icon that you see over here.', 'start': 596.206, 'duration': 2.803}, {'end': 603.512, 'text': 'You can also create a new worksheet by clicking on shift f11.', 'start': 600.069, 'duration': 3.443}, {'end': 610.358, 'text': 'So as you can see, I just clicked shift and f11 and a new sheet has been created for me over here.', 'start': 605.374, 'duration': 4.984}, {'end': 615.479, 'text': "Okay So now let's move on and see how you can actually move and copy a worksheet.", 'start': 611.278, 'duration': 4.201}, {'end': 619.981, 'text': 'So in case you have a worksheet and you want to create another copy of it.', 'start': 616.28, 'duration': 3.701}, {'end': 626.243, 'text': 'All you have to do is right click on the sheet that you desire to copy and from here select the move or copy option.', 'start': 620.181, 'duration': 6.062}], 'summary': 'Learn to create new worksheets and copy existing ones with simple shortcuts and commands.', 'duration': 30.037, 'max_score': 596.206, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Dbd-OfbeW1w/pics/Dbd-OfbeW1w596206.jpg'}, {'end': 681.586, 'src': 'embed', 'start': 657.273, 'weight': 5, 'content': [{'end': 665.838, 'text': 'Okay So now if you have some confidential sheets that you do not want others to see Excel provides a very good feature that is to hide your worksheet.', 'start': 657.273, 'duration': 8.565}, {'end': 668.262, 'text': 'Now, if you want to hide your worksheet,', 'start': 666.562, 'duration': 1.7}, {'end': 674.184, 'text': 'all you have to do is right click on the name of the sheet that you wish to hide and select the hide option over here.', 'start': 668.262, 'duration': 5.922}, {'end': 681.586, 'text': 'Okay So as you can see the copy of example that I created is no more seen over here in case I have to unhide it.', 'start': 675.104, 'duration': 6.482}], 'summary': 'Excel allows users to hide worksheets to protect confidentiality, accessed through right-click and hide option.', 'duration': 24.313, 'max_score': 657.273, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Dbd-OfbeW1w/pics/Dbd-OfbeW1w657273.jpg'}], 'start': 341.466, 'title': 'Excel status bar, cell modes, basics, and backstage view', 'summary': 'Explains the four states of the status bar in excel - ready, edit, enter, and point, along with their functions and uses, demonstrating the process of data entry, editing, and formula input. it also covers the four modes in excel, the options and functionality of the backstage view, as well as creating, renaming, saving, and managing worksheets and workbooks.', 'chapters': [{'end': 424.598, 'start': 341.466, 'title': 'Excel status bar and cell modes', 'summary': 'Explains the four states of the status bar in excel - ready, edit, enter, and point, along with their functions and uses, demonstrating the process of data entry, editing, and formula input.', 'duration': 83.132, 'highlights': ['The status bar in Excel indicates four states - ready, edit, enter, and point, each serving different functions for data input and editing.', "The ready state allows user input, the enter mode shows when entering data, and the edit mode enables editing of the cell's content.", 'The point mode is activated when entering a formula referencing other cells, allowing for dynamic calculations.', "Demonstrates data entry by typing 'hello world' and editing by double-clicking on the cell, both reflected in the status bar."]}, {'end': 697.297, 'start': 424.598, 'title': 'Excel basics and backstage view', 'summary': 'Covers the four modes in excel, the options and functionality of the backstage view, as well as creating, renaming, saving, and managing worksheets and workbooks.', 'duration': 272.699, 'highlights': ['The backstage view is the central managing place for all your Excel sheets, providing options to create, save, open, print, share worksheets, and manage account details and settings. The backstage view allows for centralized management of Excel sheets, including creating, saving, opening, printing, sharing worksheets, and managing account details and settings.', 'Excel workbooks can have multiple worksheets, and each sheet can be renamed by double-clicking on the sheet name and entering a new name. Excel workbooks can contain multiple worksheets, and renaming a sheet is as simple as double-clicking on the sheet name and entering the new name.', 'Data is entered into Excel sheets by selecting a cell and entering the required data, followed by saving the workbook through the file tab or using the shortcut Ctrl+S. Data entry in Excel involves selecting a cell and entering the data, followed by saving the workbook using the file tab or the Ctrl+S shortcut.', 'Worksheets can be created by clicking the plus icon or using the shortcut Shift+F11, and copying or moving worksheets can be done by right-clicking on the desired sheet and selecting the move or copy option. Worksheets can be created using the plus icon or the shortcut Shift+F11, and copying or moving worksheets is achieved by right-clicking on the sheet and selecting the move or copy option.', 'Hiding and unhiding worksheets can be done by right-clicking on the sheet name and selecting the hide or unhide option, providing a way to secure confidential data. Hiding and unhiding worksheets is a simple process of right-clicking on the sheet name and selecting the hide or unhide option, offering data security.']}], 'duration': 355.831, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Dbd-OfbeW1w/pics/Dbd-OfbeW1w341466.jpg', 'highlights': ['The status bar in Excel indicates four states - ready, edit, enter, and point, each serving different functions for data input and editing.', 'The backstage view is the central managing place for all your Excel sheets, providing options to create, save, open, print, share worksheets, and manage account details and settings.', 'Excel workbooks can have multiple worksheets, and each sheet can be renamed by double-clicking on the sheet name and entering a new name.', 'Data is entered into Excel sheets by selecting a cell and entering the required data, followed by saving the workbook through the file tab or using the shortcut Ctrl+S.', 'Worksheets can be created by clicking the plus icon or using the shortcut Shift+F11, and copying or moving worksheets can be done by right-clicking on the desired sheet and selecting the move or copy option.', 'Hiding and unhiding worksheets can be done by right-clicking on the sheet name and selecting the hide or unhide option, providing a way to secure confidential data.', "The ready state allows user input, the enter mode shows when entering data, and the edit mode enables editing of the cell's content.", 'The point mode is activated when entering a formula referencing other cells, allowing for dynamic calculations.', "Demonstrates data entry by typing 'hello world' and editing by double-clicking on the cell, both reflected in the status bar."]}, {'end': 1172.878, 'segs': [{'end': 755.437, 'src': 'embed', 'start': 697.317, 'weight': 0, 'content': [{'end': 703.702, 'text': 'Okay, So now talking about a very special feature of Excel, which is the context help feature.', 'start': 697.317, 'duration': 6.385}, {'end': 709.326, 'text': 'this feature provides appropriate information about Excel commands in order to educate the user about its working.', 'start': 703.702, 'duration': 5.624}, {'end': 712.709, 'text': 'So, in case you want any information about some command,', 'start': 710.007, 'duration': 2.702}, {'end': 717.873, 'text': 'all you have to do is just take your cursor over it and Excel will show up the context help window.', 'start': 712.709, 'duration': 5.164}, {'end': 725.699, 'text': "So as you can see over here, I've placed my cursor over the conditional formatting command and Excel has given me a description about it.", 'start': 718.533, 'duration': 7.166}, {'end': 730.811, 'text': "Okay So now let's move on further and see how you can actually edit these worksheets.", 'start': 726.73, 'duration': 4.081}, {'end': 739.413, 'text': 'The total number of cells present in an excel sheet are the number of rows, multiplied by the number of columns.', 'start': 733.492, 'duration': 5.921}, {'end': 745.355, 'text': 'the type of data that is entered in an excel sheet can be of any form, such as text, numbers, formulae, Etc.', 'start': 739.413, 'duration': 5.942}, {'end': 747.556, 'text': 'In order to insert data.', 'start': 746.235, 'duration': 1.321}, {'end': 752.457, 'text': 'All you have to do is simply select the cell wherein you intend to insert the data and type the same.', 'start': 747.836, 'duration': 4.621}, {'end': 755.437, 'text': "So, like I've already shown you all before,", 'start': 753.297, 'duration': 2.14}], 'summary': 'Excel context help provides information on commands. excel sheets contain cells, rows, and columns for various types of data entry.', 'duration': 58.12, 'max_score': 697.317, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Dbd-OfbeW1w/pics/Dbd-OfbeW1w697317.jpg'}, {'end': 884.934, 'src': 'embed', 'start': 857.27, 'weight': 5, 'content': [{'end': 862.311, 'text': 'Now another important thing that we usually do is delete to delete data from an excel sheet.', 'start': 857.27, 'duration': 5.041}, {'end': 863.572, 'text': 'You can use many techniques.', 'start': 862.391, 'duration': 1.181}, {'end': 871.263, 'text': 'So, in case you want to delete the data for some particular cell, click on the desired cell and highlight the data that you want to delete,', 'start': 864.218, 'duration': 7.045}, {'end': 873.405, 'text': 'then press the delete button from the keyboard.', 'start': 871.263, 'duration': 2.142}, {'end': 877.188, 'text': 'So as you can see all the data that was highlighted has been deleted.', 'start': 874.026, 'duration': 3.162}, {'end': 884.934, 'text': 'Also, what you can do is select the cell whose data you want to delete right click over it and from here choose the delete option.', 'start': 878.049, 'duration': 6.885}], 'summary': 'To delete data from an excel sheet, highlight and press delete or right-click and select delete option.', 'duration': 27.664, 'max_score': 857.27, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Dbd-OfbeW1w/pics/Dbd-OfbeW1w857270.jpg'}, {'end': 988.879, 'src': 'embed', 'start': 960.298, 'weight': 1, 'content': [{'end': 967.761, 'text': 'then select the cell where you want to copy the data and then just hit control V or choose paste, option that is present when you hit right click.', 'start': 960.298, 'duration': 7.463}, {'end': 976.293, 'text': "So one more important thing that you guys should know is that when you're working with real-time data, you'll copy many things several times.", 'start': 969.17, 'duration': 7.123}, {'end': 981.056, 'text': "Excel provides a special clipboard that will hold all the data that you've copied.", 'start': 976.293, 'duration': 4.763}, {'end': 988.879, 'text': 'in case you want to paste any of this data, simply selected from the clipboard and choose the paste option now to open up this clipboard.', 'start': 981.056, 'duration': 7.823}], 'summary': "Learn how to use excel's special clipboard for real-time data.", 'duration': 28.581, 'max_score': 960.298, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Dbd-OfbeW1w/pics/Dbd-OfbeW1w960298.jpg'}, {'end': 1131.461, 'src': 'heatmap', 'start': 1072.599, 'weight': 3, 'content': [{'end': 1074.86, 'text': 'Okay, so now talking about commenting a cell.', 'start': 1072.599, 'duration': 2.261}, {'end': 1080.21, 'text': 'Commenting is very important in order to give a clear description of the data.', 'start': 1075.689, 'duration': 4.521}, {'end': 1084.491, 'text': 'Excel allows you to easily add, modify and format comments.', 'start': 1080.21, 'duration': 4.281}, {'end': 1090.372, 'text': 'in order to add a comment, right click on the cell that you want to add the comment to and select the new comment option.', 'start': 1084.491, 'duration': 5.881}, {'end': 1093.733, 'text': 'You can type down any comment of your choice.', 'start': 1091.693, 'duration': 2.04}, {'end': 1100.835, 'text': 'And then hit enter and then click on the green button over here.', 'start': 1093.753, 'duration': 7.082}, {'end': 1107.214, 'text': "So whenever you move down towards that cell, you will see that the comment that you've added will show up over here.", 'start': 1101.952, 'duration': 5.262}, {'end': 1111.795, 'text': 'Now this comment can be seen by all those people who have access to this sheet.', 'start': 1107.894, 'duration': 3.901}, {'end': 1119.457, 'text': 'So in case any of them wants to reply to this comment, they will just have to type down whatever they want in the reply bar that is present over here.', 'start': 1112.475, 'duration': 6.982}, {'end': 1122.458, 'text': 'So just like comment.', 'start': 1121.558, 'duration': 0.9}, {'end': 1124.239, 'text': "There's another option called as note.", 'start': 1122.518, 'duration': 1.721}, {'end': 1129.3, 'text': 'Now this note can contain any information about the data that is present in that cell.', 'start': 1125.099, 'duration': 4.201}, {'end': 1131.461, 'text': "So I'll just write down example of here.", 'start': 1129.88, 'duration': 1.581}], 'summary': 'Excel allows easy addition, modification, and formatting of comments and notes for clear data description and collaboration.', 'duration': 58.862, 'max_score': 1072.599, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Dbd-OfbeW1w/pics/Dbd-OfbeW1w1072599.jpg'}], 'start': 697.317, 'title': 'Excel data manipulation and efficient functions', 'summary': 'Covers excel context help, data manipulation, cut, copy, paste functions, adding comments, and provides comprehensive guidance with examples for efficient data manipulation and organization.', 'chapters': [{'end': 919.253, 'start': 697.317, 'title': 'Excel context help and data manipulation', 'summary': 'Explains the context help feature in excel, such as providing information about commands, and provides guidance on data manipulation including inserting, selecting, and deleting data, with examples and techniques demonstrated.', 'duration': 221.936, 'highlights': ['Excel context help feature provides information about commands by hovering the cursor, aiding user education. The context help feature in Excel provides appropriate information about commands by hovering the cursor over them, aiding in user education.', 'The total number of cells present in an excel sheet are the number of rows multiplied by the number of columns. The total number of cells in an excel sheet is calculated by multiplying the number of rows with the number of columns.', 'Data in an excel sheet can be of any form such as text, numbers, and formulae; inserting data is done by selecting the cell and typing the data. Data in an excel sheet can be of any form like text, numbers, and formulae; inserting data is simply done by selecting the cell and typing the data.', 'Two ways to select data in an excel sheet: using the mouse by double-clicking or dragging, and using the control button to select random cells; finding and selecting options in the home tab. Data in an excel sheet can be selected using the mouse by double-clicking or dragging, or using the control button to select random cells; finding and selecting options are available in the home tab.', 'Various techniques to delete data in an excel sheet including using the delete button, right-clicking and choosing the delete option, or deleting entire row or column regions. Data in an excel sheet can be deleted using various techniques such as using the delete button, right-clicking and choosing the delete option, or deleting entire row or column regions.', "Moving data from one place to another in an excel sheet is demonstrated with an example of typing 'welcome to Edureka'. The process of moving data from one place to another in an excel sheet is demonstrated with an example of typing 'welcome to Edureka'."]}, {'end': 1172.878, 'start': 919.273, 'title': 'Excel cut, copy, paste, and adding comments', 'summary': 'Demonstrates how to use the cut and copy functions in excel, accessing the clipboard, inserting special symbols, and adding comments and notes to cells, providing a comprehensive guide to efficient data manipulation and organization.', 'duration': 253.605, 'highlights': ["Excel provides a special clipboard that will hold all the data that you've copied. Excel has a special clipboard feature to store copied data, ensuring easy access and management of multiple copied items.", 'In case you need to enter a symbol that is not present on the keyboard, you can make use of the special symbols provided in Excel. Excel offers special symbols for insertion, including equations and a variety of symbols, providing flexibility in data representation.', 'Commenting is very important in order to give a clear description of the data. Excel allows you to easily add, modify, and format comments. Excel enables easy addition, modification, and formatting of comments, offering a clear and accessible way to describe data.']}], 'duration': 475.561, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Dbd-OfbeW1w/pics/Dbd-OfbeW1w697317.jpg', 'highlights': ['Excel context help feature provides information about commands by hovering the cursor, aiding user education.', 'Excel has a special clipboard feature to store copied data, ensuring easy access and management of multiple copied items.', 'Data in an excel sheet can be of any form like text, numbers, and formulae; inserting data is simply done by selecting the cell and typing the data.', 'Excel allows you to easily add, modify, and format comments, offering a clear and accessible way to describe data.', 'The total number of cells in an excel sheet is calculated by multiplying the number of rows with the number of columns.', 'Various techniques to delete data in an excel sheet including using the delete button, right-clicking and choosing the delete option, or deleting entire row or column regions.']}, {'end': 1626.013, 'segs': [{'end': 1242.122, 'src': 'embed', 'start': 1216.738, 'weight': 0, 'content': [{'end': 1221.86, 'text': 'date allows various types of date formats and time allows various types of time formats.', 'start': 1216.738, 'duration': 5.122}, {'end': 1228.383, 'text': 'percentage allows the cell to be displayed as a percentage and fraction allows the cell to be displayed as a fraction itself.', 'start': 1221.86, 'duration': 6.523}, {'end': 1232.779, 'text': 'The scientific category displays the cell in an exponential form.', 'start': 1229.338, 'duration': 3.441}, {'end': 1234.2, 'text': 'text is for normal text.', 'start': 1232.779, 'duration': 1.421}, {'end': 1242.122, 'text': 'data special allows you to enter special types of data, such as phone numbers, zip codes, Etc, and custom allows custom formats.', 'start': 1234.2, 'duration': 7.922}], 'summary': 'Excel allows various cell formats including date, time, percentage, fraction, scientific, text, special data, and custom formats.', 'duration': 25.384, 'max_score': 1216.738, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Dbd-OfbeW1w/pics/Dbd-OfbeW1w1216738.jpg'}, {'end': 1282.619, 'src': 'embed', 'start': 1255.615, 'weight': 1, 'content': [{'end': 1262.481, 'text': 'From the format cells window select the font option and from here you can choose any option in order to format your data.', 'start': 1255.615, 'duration': 6.866}, {'end': 1268.687, 'text': "So in case I want to use bold italic and if I want to increase the size of my data, I'll just do this from here.", 'start': 1262.841, 'duration': 5.846}, {'end': 1270.608, 'text': "I'll change the color as well.", 'start': 1268.707, 'duration': 1.901}, {'end': 1277.574, 'text': 'Make all the required changes and then click on OK.', 'start': 1275.172, 'duration': 2.402}, {'end': 1282.619, 'text': 'Okay So as you can see over here the font style of my data has been changed.', 'start': 1278.816, 'duration': 3.803}], 'summary': 'In the format cells window, various font options can be used to change style, size, and color of data.', 'duration': 27.004, 'max_score': 1255.615, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Dbd-OfbeW1w/pics/Dbd-OfbeW1w1255615.jpg'}, {'end': 1371.913, 'src': 'embed', 'start': 1347.747, 'weight': 2, 'content': [{'end': 1353.609, 'text': 'Whenever you merge the cells you do not actually merge the data, but the cells are merged to behave as a single cell.', 'start': 1347.747, 'duration': 5.862}, {'end': 1357.83, 'text': 'If you try to merge two or more cells that have data in them,', 'start': 1354.509, 'duration': 3.321}, {'end': 1363.211, 'text': 'only the data contained in the top left cell will be preserved and the data of the other cells will be discarded.', 'start': 1357.83, 'duration': 5.381}, {'end': 1371.913, 'text': 'To merge the cells simply select the cells that you wish to merge and click on the merge and center option that is present in the home tab.', 'start': 1363.991, 'duration': 7.922}], 'summary': 'Merging cells in excel preserves data in the top left cell only.', 'duration': 24.166, 'max_score': 1347.747, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Dbd-OfbeW1w/pics/Dbd-OfbeW1w1347747.jpg'}, {'end': 1434.213, 'src': 'embed', 'start': 1406.234, 'weight': 3, 'content': [{'end': 1412.999, 'text': "So as you can see over here the content of this data is larger than the cell size and it's highlighting over other cells as well.", 'start': 1406.234, 'duration': 6.765}, {'end': 1415.701, 'text': 'So, in case you do not want this to happen,', 'start': 1413.619, 'duration': 2.082}, {'end': 1422.967, 'text': 'you can use the shrink to fit or the wrap text options that are present in order to reduce the size or align the text vertically.', 'start': 1415.701, 'duration': 7.266}, {'end': 1427.01, 'text': 'to do this, select the cell and from here select the format cells option.', 'start': 1422.967, 'duration': 4.043}, {'end': 1434.213, 'text': 'Click on the alignment tab and from here choose the wrap text or the shrink to fit option when I choose wrap text.', 'start': 1427.671, 'duration': 6.542}], 'summary': 'Data content larger than cell size, use wrap text or shrink to fit for alignment.', 'duration': 27.979, 'max_score': 1406.234, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Dbd-OfbeW1w/pics/Dbd-OfbeW1w1406234.jpg'}, {'end': 1506.071, 'src': 'embed', 'start': 1478.52, 'weight': 4, 'content': [{'end': 1482.142, 'text': "So as you can see I've added the selected type of borders to the cell.", 'start': 1478.52, 'duration': 3.622}, {'end': 1485.303, 'text': 'Similarly, you can also add shades to a cell.', 'start': 1482.882, 'duration': 2.421}, {'end': 1492.401, 'text': 'In case you want to add some shade to a cell, select the cell and then open the fill pane from the format cells window.', 'start': 1486.036, 'duration': 6.365}, {'end': 1494.562, 'text': 'then choose the appropriate color of your choice.', 'start': 1492.401, 'duration': 2.161}, {'end': 1502.048, 'text': "Fill and from here, I'll choose any color say blue.", 'start': 1499.066, 'duration': 2.982}, {'end': 1506.071, 'text': "And I'll click on OK.", 'start': 1505.27, 'duration': 0.801}], 'summary': 'Instructions on adding borders and shades to cells in excel.', 'duration': 27.551, 'max_score': 1478.52, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Dbd-OfbeW1w/pics/Dbd-OfbeW1w1478520.jpg'}, {'end': 1553.207, 'src': 'heatmap', 'start': 1507.732, 'weight': 5, 'content': [{'end': 1514.817, 'text': 'So as you can see the shade of this cell has turned blue Excel also provides a very important feature, which is the sheet options.', 'start': 1507.732, 'duration': 7.085}, {'end': 1521.705, 'text': 'Using these options, you can selectively print your sheet in various ways to open the sheet options pane,', 'start': 1515.723, 'duration': 5.982}, {'end': 1526.206, 'text': 'select page layout from the home tab and open the page setup window.', 'start': 1521.705, 'duration': 4.501}, {'end': 1536.83, 'text': 'Then click on sheet option and over here you will see various options, such as print area, print titles, grid lines, black and white draft quality,', 'start': 1528.067, 'duration': 8.763}, {'end': 1538.15, 'text': 'row and column headings.', 'start': 1536.83, 'duration': 1.32}, {'end': 1539.891, 'text': 'down then over over then down.', 'start': 1538.15, 'duration': 1.741}, {'end': 1547.101, 'text': 'So when you click on the sheet options, you will see many options, such as print area, which is used to set the print area.', 'start': 1540.856, 'duration': 6.245}, {'end': 1553.207, 'text': 'print title, which allows you to set the row and column titles to appear at the top and towards the left respectively.', 'start': 1547.101, 'duration': 6.106}], 'summary': 'Excel provides sheet options for selective printing, including print area and titles, grid lines, and more.', 'duration': 45.475, 'max_score': 1507.732, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Dbd-OfbeW1w/pics/Dbd-OfbeW1w1507732.jpg'}, {'end': 1626.013, 'src': 'embed', 'start': 1585.309, 'weight': 6, 'content': [{'end': 1593.034, 'text': 'all MS Excel pages have margins, and if you have selected some particular margin for one page, then that margin will be applied to all the pages.', 'start': 1585.309, 'duration': 7.725}, {'end': 1596.996, 'text': 'This actually means that you cannot have different margins for each page.', 'start': 1593.914, 'duration': 3.082}, {'end': 1605.783, 'text': 'Okay So in order to add margins open up the margins options present in the page set up and specify whatever margin values you want to respectively.', 'start': 1597.859, 'duration': 7.924}, {'end': 1609.525, 'text': 'Okay, So now talking about the page orientation.', 'start': 1605.803, 'duration': 3.722}, {'end': 1615.068, 'text': 'page orientation refers to the format in which the sheet is printed, that is, portrait or landscape.', 'start': 1609.525, 'duration': 5.543}, {'end': 1619.471, 'text': 'the portrait orientation is default and it prints the page taller than white.', 'start': 1615.068, 'duration': 4.403}, {'end': 1623.273, 'text': 'on the other hand, landscape orientation prints the sheet wider than tall.', 'start': 1619.471, 'duration': 3.802}, {'end': 1626.013, 'text': 'to select some particular type of orientation.', 'start': 1624.031, 'duration': 1.982}], 'summary': "Ms excel doesn't allow different margins for each page. page orientation can be set to portrait or landscape.", 'duration': 40.704, 'max_score': 1585.309, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Dbd-OfbeW1w/pics/Dbd-OfbeW1w1585309.jpg'}], 'start': 1173.919, 'title': 'Excel cell formatting and sheet manipulation in ms excel', 'summary': 'Explains formatting cells in excel, covering data types such as numbers, currency, date, time, percentage, scientific notation, and custom formats, along with customizing fonts, styles, colors, alignments. it also introduces merging and shrinking cells, adding borders and shades, setting sheet options for selective printing, and explaining margins and page orientation.', 'chapters': [{'end': 1329.981, 'start': 1173.919, 'title': 'Excel cell formatting', 'summary': 'Explains how to format cells in excel, including specifying data types such as numbers, currency, date, time, percentage, scientific notation, and custom formats, as well as customizing fonts, styles, colors, and alignments.', 'duration': 156.062, 'highlights': ['Excel provides options to format cells for various data types such as numbers, currency, date, time, percentage, and scientific notation. The chapter explains the various data types that can be specified for cells, such as numbers, currency, date, time, percentage, and scientific notation.', 'Customizing fonts, styles, and colors in Excel can be done by right-clicking on the cell, selecting format cells, and making the desired changes. The process of customizing fonts, styles, and colors in Excel is detailed, including the steps to make changes by right-clicking on the cell and selecting format cells.', 'Changing the orientation and alignment of data in Excel can be done by selecting the cell, right-clicking, and choosing the format cells option. The chapter explains the process of changing the orientation and alignment of data, including the steps to select the cell, right-click, and choose the format cells option.']}, {'end': 1626.013, 'start': 1331.002, 'title': 'Excel sheet manipulation', 'summary': 'Introduces how to merge and shrink cells in ms excel, including merging cells to behave as a single cell, shrinking text to fit cell size or aligning it vertically, adding borders and shades, and setting sheet options for selective printing, as well as explaining margins and page orientation.', 'duration': 295.011, 'highlights': ['Merging cells in MS Excel allows cells to behave as a single cell, preserving only the data contained in the top left cell and discarding other values when merging multiple cells with data. When merging cells in MS Excel, only the data contained in the top left cell will be preserved, discarding the other values.', "Shrinking text in cells can be achieved by using the 'shrink to fit' or 'wrap text' options, which align the text vertically or shrink the data to fit the size of the cell. The 'shrink to fit' or 'wrap text' options in MS Excel can be used to align the text vertically or shrink the data to fit the size of the cell.", 'Adding borders and shades to cells in MS Excel can be done using the format cells window, allowing customization of border type, color, and cell shade color. MS Excel enables the addition of borders and shades to cells using the format cells window, providing options to customize border type, color, and cell shade color.', "Setting sheet options in MS Excel allows selective printing, including defining the print area, titles, grid lines, black and white draft quality, and specifying the order of printing for pages. MS Excel's sheet options enable selective printing by defining print area, titles, grid lines, black and white draft quality, and specifying the order of printing for pages.", 'Margins in MS Excel refer to the unprinted regions along the top, bottom, left, and right sides, and the same margin values are applied to all pages within a sheet. In MS Excel, margins refer to the unprinted regions along the top, bottom, left, and right sides, with the same margin values applied to all pages within a sheet.', 'Page orientation in MS Excel can be set as portrait or landscape, with portrait orientation printing the page taller than wide, and landscape orientation printing the sheet wider than tall. MS Excel allows setting page orientation as portrait or landscape, where portrait orientation prints the page taller than wide, and landscape orientation prints the sheet wider than tall.']}], 'duration': 452.094, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Dbd-OfbeW1w/pics/Dbd-OfbeW1w1173919.jpg', 'highlights': ['Excel provides options to format cells for various data types such as numbers, currency, date, time, percentage, and scientific notation.', 'Customizing fonts, styles, and colors in Excel can be done by right-clicking on the cell, selecting format cells, and making the desired changes.', 'Merging cells in MS Excel allows cells to behave as a single cell, preserving only the data contained in the top left cell and discarding other values when merging multiple cells with data.', "Shrinking text in cells can be achieved by using the 'shrink to fit' or 'wrap text' options, which align the text vertically or shrink the data to fit the size of the cell.", 'Adding borders and shades to cells in MS Excel can be done using the format cells window, allowing customization of border type, color, and cell shade color.', 'Setting sheet options in MS Excel allows selective printing, including defining the print area, titles, grid lines, black and white draft quality, and specifying the order of printing for pages.', 'Margins in MS Excel refer to the unprinted regions along the top, bottom, left, and right sides, and the same margin values are applied to all pages within a sheet.', 'Page orientation in MS Excel can be set as portrait or landscape, with portrait orientation printing the page taller than wide, and landscape orientation printing the sheet wider than tall.']}, {'end': 1850.088, 'segs': [{'end': 1656.069, 'src': 'embed', 'start': 1626.413, 'weight': 1, 'content': [{'end': 1628.595, 'text': 'You can simply check any of these radio buttons.', 'start': 1626.413, 'duration': 2.182}, {'end': 1631.798, 'text': 'So, finally, the header and the footer.', 'start': 1629.436, 'duration': 2.362}, {'end': 1636.483, 'text': 'headers and footers are used to provide some information at the top and the bottom of the page.', 'start': 1631.798, 'duration': 4.685}, {'end': 1640.206, 'text': 'a new workbook does not have a header or footer in order to add it.', 'start': 1636.483, 'duration': 3.723}, {'end': 1644.851, 'text': 'You can open up the page setup window and from there click on the header and the footer option.', 'start': 1640.427, 'duration': 4.424}, {'end': 1649.262, 'text': 'This pain provides a number of options to customize the headers and footers.', 'start': 1645.859, 'duration': 3.403}, {'end': 1652.386, 'text': "If you want to preview the headers and footers that you've added,", 'start': 1649.683, 'duration': 2.703}, {'end': 1656.069, 'text': "click on the print preview option and you will be able to see the changes that you've made.", 'start': 1652.386, 'duration': 3.683}], 'summary': 'Customize headers and footers, add information, and preview changes in page setup.', 'duration': 29.656, 'max_score': 1626.413, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Dbd-OfbeW1w/pics/Dbd-OfbeW1w1626413.jpg'}, {'end': 1698.672, 'src': 'embed', 'start': 1667.902, 'weight': 0, 'content': [{'end': 1668.743, 'text': 'Using page breaks.', 'start': 1667.902, 'duration': 0.841}, {'end': 1671.245, 'text': 'You will be able to control the print of a page,', 'start': 1668.883, 'duration': 2.362}, {'end': 1679.451, 'text': 'such as restrain from printing the first row of a table at the end of a page or printing the header of a new page at the end of the previous page.', 'start': 1671.245, 'duration': 8.206}, {'end': 1683.375, 'text': 'using page breaks will also allow you to print the sheet in the order of your preference.', 'start': 1679.451, 'duration': 3.924}, {'end': 1689.479, 'text': 'You can have both horizontal as well as vertical page breaks to include this,', 'start': 1684.215, 'duration': 5.264}, {'end': 1695.491, 'text': 'select the row or column where you intend to include the page break and then, from the page setup group,', 'start': 1689.479, 'duration': 6.012}, {'end': 1698.672, 'text': 'click on breaks command and choose the insert page break option.', 'start': 1695.491, 'duration': 3.181}], 'summary': 'Control page printing, add page breaks for tables, and customize print order.', 'duration': 30.77, 'max_score': 1667.902, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Dbd-OfbeW1w/pics/Dbd-OfbeW1w1667902.jpg'}, {'end': 1777.741, 'src': 'heatmap', 'start': 1710.374, 'weight': 2, 'content': [{'end': 1716.695, 'text': "All I'm going to do is click on some row and then choose the breaks command and then I'll insert a page break.", 'start': 1710.374, 'duration': 6.321}, {'end': 1721.836, 'text': 'So as you can see over here a vertical page break has been included.', 'start': 1718.495, 'duration': 3.341}, {'end': 1728.444, 'text': 'So now moving on towards another very interesting feature of MS Excel, which is freezing pains.', 'start': 1722.799, 'duration': 5.645}, {'end': 1732.908, 'text': 'Excel provides an option of freezing pains which will enable you to see the row and column headings.', 'start': 1728.444, 'duration': 4.464}, {'end': 1736.691, 'text': 'Even if you scroll down the page in order to freeze the pains.', 'start': 1733.048, 'duration': 3.643}, {'end': 1739.754, 'text': 'All you have to do is select the rows and columns that you want to freeze.', 'start': 1736.951, 'duration': 2.803}, {'end': 1745.939, 'text': 'Then click on the views tab that is present in the ribbon.', 'start': 1743.237, 'duration': 2.702}, {'end': 1747.881, 'text': 'Okay from here.', 'start': 1747.06, 'duration': 0.821}, {'end': 1750.283, 'text': "I'll choose the freeze first column option.", 'start': 1748.241, 'duration': 2.042}, {'end': 1757.497, 'text': "Okay So now that I've frozen the cells a1 and a2 I'll be able to see these cells wherever I move down the screen.", 'start': 1751.255, 'duration': 6.242}, {'end': 1762.898, 'text': 'So as you can see over here column a has been frozen and all of the columns have been changed.', 'start': 1758.157, 'duration': 4.741}, {'end': 1768.439, 'text': 'Okay. So now coming back towards the most important feature, which is conditional formatting.', 'start': 1763.818, 'duration': 4.621}, {'end': 1770.8, 'text': "like I've already mentioned before,", 'start': 1768.439, 'duration': 2.361}, {'end': 1777.741, 'text': 'conditional formatting allows you to selectively format a section to hold values with some specified range values outside.', 'start': 1770.8, 'duration': 6.941}], 'summary': 'Ms excel features: page break, freezing panes, conditional formatting.', 'duration': 47.123, 'max_score': 1710.374, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Dbd-OfbeW1w/pics/Dbd-OfbeW1w1710374.jpg'}, {'end': 1810.599, 'src': 'embed', 'start': 1780.962, 'weight': 4, 'content': [{'end': 1784.164, 'text': 'This feature has a number of options that are listed in the table below.', 'start': 1780.962, 'duration': 3.202}, {'end': 1788.526, 'text': 'So the first thing that you will see over here is highlight cells rules.', 'start': 1784.964, 'duration': 3.562}, {'end': 1795.75, 'text': 'when you move the cursor on this option, you will see that it opens another list that defines the selected cells, contains values,', 'start': 1788.526, 'duration': 7.224}, {'end': 1799.733, 'text': 'texts or dates that are greater than equal to or less than some particular value.', 'start': 1795.75, 'duration': 3.983}, {'end': 1807.197, 'text': 'Similarly, the top bottom rules also opens up another list which highlights the top or bottom values persons,', 'start': 1800.453, 'duration': 6.744}, {'end': 1810.599, 'text': 'as well as the upper and the lower averages data bars.', 'start': 1807.197, 'duration': 3.402}], 'summary': 'Feature offers options for highlighting cells based on specific criteria.', 'duration': 29.637, 'max_score': 1780.962, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Dbd-OfbeW1w/pics/Dbd-OfbeW1w1780962.jpg'}], 'start': 1626.413, 'title': 'Ms excel page setup, page breaks, and formatting', 'summary': 'Covers the usage of headers, footers, and page breaks in ms excel, enabling precise control and customization of printed pages, along with techniques for freezing panes and conditional formatting.', 'chapters': [{'end': 1689.479, 'start': 1626.413, 'title': 'Ms excel page setup', 'summary': 'Discusses the usage of headers and footers, page breaks, and their importance in ms excel, allowing precise control and customization of printed pages.', 'duration': 63.066, 'highlights': ['Headers and footers provide information at the top and bottom of the page.', 'Page breaks in MS Excel allow precise control over what to print and what to omit.', 'Page breaks enable control over the print of a page, such as restraining from printing the first row of a table at the end of a page or printing the header of a new page at the end of the previous page.']}, {'end': 1850.088, 'start': 1689.479, 'title': 'Ms excel page breaks, freezing panes, and conditional formatting', 'summary': 'Explains how to insert vertical and horizontal page breaks, freeze panes to view row and column headings, and utilize the various options of conditional formatting in ms excel.', 'duration': 160.609, 'highlights': ['MS Excel provides the option of freezing panes, enabling the user to see the row and column headings even when scrolling down the page. Excel allows freezing specific rows and columns, providing the ability to view them while scrolling, enhancing user experience and productivity.', 'The chapter details the various options of conditional formatting in MS Excel, including highlight cells rules, top bottom rules, data bars, color scales, icon sets, new rule, clear rules, and manage rules. The conditional formatting options include highlight cells rules, top bottom rules, data bars, color scales, icon sets, new rule, clear rules, and manage rules, offering users a range of flexible formatting options for their data.', 'The process for inserting both vertical and horizontal page breaks in MS Excel is explained, providing a comprehensive understanding of this feature. The chapter explains the process for inserting both vertical and horizontal page breaks in MS Excel, enhancing user knowledge and proficiency in utilizing this functionality.']}], 'duration': 223.675, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Dbd-OfbeW1w/pics/Dbd-OfbeW1w1626413.jpg', 'highlights': ['Page breaks in MS Excel allow precise control over what to print and what to omit.', 'Headers and footers provide information at the top and bottom of the page.', 'The chapter explains the process for inserting both vertical and horizontal page breaks in MS Excel, enhancing user knowledge and proficiency in utilizing this functionality.', 'MS Excel provides the option of freezing panes, enabling the user to see the row and column headings even when scrolling down the page.', 'The chapter details the various options of conditional formatting in MS Excel, including highlight cells rules, top bottom rules, data bars, color scales, icon sets, new rule, clear rules, and manage rules.']}, {'end': 2092.335, 'segs': [{'end': 1890.683, 'src': 'embed', 'start': 1852.75, 'weight': 8, 'content': [{'end': 1857.672, 'text': 'Okay, So now talking about something very important, which is MS Excel formulas.', 'start': 1852.75, 'duration': 4.922}, {'end': 1861.713, 'text': 'formulas are one of the most important features of an Excel sheet.', 'start': 1857.672, 'duration': 4.041}, {'end': 1865.555, 'text': 'a formula is basically an expression that can be entered into cells,', 'start': 1861.713, 'duration': 3.842}, {'end': 1869.877, 'text': 'and the result of that particular expression is displayed in that cell as the output.', 'start': 1865.555, 'duration': 4.322}, {'end': 1877.678, 'text': 'Formulas in an MS Excel sheet can be mathematical operators values or text cell references or worksheet functions.', 'start': 1870.655, 'duration': 7.023}, {'end': 1879.879, 'text': 'So moving on further with formulas.', 'start': 1878.378, 'duration': 1.501}, {'end': 1883.58, 'text': "Let's see how you can actually create and copy formulas in an Excel sheet.", 'start': 1880.199, 'duration': 3.381}, {'end': 1890.683, 'text': "Like I've already mentioned before a formula should always start with an equal sign to manually build a formula.", 'start': 1884.521, 'duration': 6.162}], 'summary': 'Ms excel formulas are important, using expressions and mathematical operators to display results in cells.', 'duration': 37.933, 'max_score': 1852.75, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Dbd-OfbeW1w/pics/Dbd-OfbeW1w1852750.jpg'}, {'end': 2077.141, 'src': 'embed', 'start': 1913.545, 'weight': 0, 'content': [{'end': 1918.889, 'text': 'then hit control, then include the plus sign and then select the next cell, which is a7..', 'start': 1913.545, 'duration': 5.344}, {'end': 1922.272, 'text': "Okay So once I'm done with this, I'm going to hit enter.", 'start': 1919.049, 'duration': 3.223}, {'end': 1929.49, 'text': 'So, as you can see over here, I found the sum of a6 and a7, which is 2 plus 3, and that is 5.', 'start': 1922.907, 'duration': 6.583}, {'end': 1934.532, 'text': 'you can also copy excel sheet formulas in case you have to calculate some common results.', 'start': 1929.49, 'duration': 5.042}, {'end': 1940.634, 'text': 'Excel automatically manages the task of modifying cell references wherever you copy formulas in an excel sheet.', 'start': 1934.532, 'duration': 6.102}, {'end': 1947.097, 'text': 'Now this task is actually accomplished through a system known as the relative cell addresses here.', 'start': 1941.715, 'duration': 5.382}, {'end': 1952.379, 'text': 'The copied formula will have modified row and column addresses that will suit its new position.', 'start': 1947.457, 'duration': 4.922}, {'end': 1961.211, 'text': "Okay, so just to show you guys, I'll enter some new values over here as a 4 and 5, and in this cell I'm not going to type in the formula,", 'start': 1953.288, 'duration': 7.923}, {'end': 1962.712, 'text': "but I'm going to copy it from here.", 'start': 1961.211, 'duration': 1.501}, {'end': 1973.536, 'text': 'Okay So as you can see all I had to do is select the cell that contains the formula and drag it down to the cell where in I want to copy the formula.', 'start': 1962.732, 'duration': 10.804}, {'end': 1982.86, 'text': "So as you can see on the screen Excel has automatically calculated the result of b6 and b7 and it's showing in b8 where in I copied the formula.", 'start': 1974.196, 'duration': 8.664}, {'end': 1985.819, 'text': 'Excel also provides some built-in functions.', 'start': 1983.797, 'duration': 2.022}, {'end': 1989.842, 'text': 'So now talking about functions in MS Excel.', 'start': 1986.739, 'duration': 3.103}, {'end': 1994.525, 'text': 'functions available in MS Excel actually handle many of the formulas you create.', 'start': 1989.842, 'duration': 4.683}, {'end': 2000.77, 'text': 'these functions also Define complex calculations that are difficult to manually Define using just operators.', 'start': 1994.525, 'duration': 6.245}, {'end': 2004.453, 'text': 'Excel provides many functions and if you want to use some particular function,', 'start': 2000.77, 'duration': 3.683}, {'end': 2009.157, 'text': 'all you have to do is type in the first letter of that function in the formula bar to do that.', 'start': 2004.453, 'duration': 4.704}, {'end': 2010.798, 'text': "I'll just get back to my Excel sheet.", 'start': 2009.177, 'duration': 1.621}, {'end': 2012.048, 'text': 'and over here.', 'start': 2011.508, 'duration': 0.54}, {'end': 2016.472, 'text': "I'll go to the formula bar and type in an equal to sign after this.", 'start': 2012.509, 'duration': 3.963}, {'end': 2023.898, 'text': "I'll just specify some letter say a and as you can see all the functions that proceed with the letter a have been listed down over here.", 'start': 2016.872, 'duration': 7.026}, {'end': 2026.92, 'text': 'You can choose any function of your choice from here itself.', 'start': 2024.278, 'duration': 2.642}, {'end': 2033.125, 'text': 'Not just this when you click on some function name Excel brilliantly gives a description about it.', 'start': 2028.041, 'duration': 5.084}, {'end': 2038.329, 'text': 'Okay. So, in case you want to view all the built-in functions that are present in Excel,', 'start': 2033.145, 'duration': 5.184}, {'end': 2042.553, 'text': 'click on formulas tab and from here select the insert function option.', 'start': 2038.329, 'duration': 4.224}, {'end': 2049.917, 'text': 'You will see that a dialog box has appeared and it contains a list of function categories where you can select from.', 'start': 2043.373, 'duration': 6.544}, {'end': 2052.378, 'text': 'so, in case I want to select any of these categories,', 'start': 2049.917, 'duration': 2.461}, {'end': 2056.761, 'text': "I'll just select that and you will see all the available functions under that category.", 'start': 2052.458, 'duration': 4.303}, {'end': 2059.123, 'text': "So I'll just choose any of these options.", 'start': 2057.321, 'duration': 1.802}, {'end': 2060.203, 'text': "So I'll say date.", 'start': 2059.543, 'duration': 0.66}, {'end': 2062.745, 'text': "I'll click on OK and over here.", 'start': 2060.683, 'duration': 2.062}, {'end': 2070.416, 'text': "I'll specify the year to be 2019 the month to be one and the day to be anything say 23.", 'start': 2062.985, 'duration': 7.431}, {'end': 2071.217, 'text': "and I'll click on OK.", 'start': 2070.416, 'duration': 0.801}, {'end': 2077.141, 'text': 'Okay So as you can see the corresponding date has been returned in the Excel date format pattern.', 'start': 2071.996, 'duration': 5.145}], 'summary': 'Excel allows copying formulas, using built-in functions, and provides a list of available functions and their descriptions to make complex calculations easier.', 'duration': 163.596, 'max_score': 1913.545, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Dbd-OfbeW1w/pics/Dbd-OfbeW1w1913545.jpg'}], 'start': 1852.75, 'title': 'Excel formulas and functions', 'summary': "Discusses ms excel formulas, covering their importance, creation, copying, and automatic modification of cell references. it also demonstrates calculating the sum of values and copying formulas. furthermore, it delves into excel's built-in functions and their utilization, including a demonstration of using the date function to return a corresponding date in the excel date format pattern.", 'chapters': [{'end': 1973.536, 'start': 1852.75, 'title': 'Ms excel formulas', 'summary': 'Discusses the importance of ms excel formulas, how to create and copy formulas, and the automatic modification of cell references. it also demonstrates the calculation of the sum of two values and the process of copying formulas in an excel sheet.', 'duration': 120.786, 'highlights': ['Formulas in MS Excel are expressions entered into cells, and can be mathematical operators, values, text, cell references, or worksheet functions.', 'To manually build a formula in Excel, it should always start with an equal sign, and the copied formula will have modified row and column addresses that suit its new position.', 'Excel automatically manages the task of modifying cell references wherever you copy formulas in an Excel sheet.', 'Demonstration of the calculation of the sum of two values using Excel formula, 2 + 3 = 5.', 'The process of copying formulas in an Excel sheet demonstrated by simply selecting the cell that contains the formula and dragging it to the desired cell.']}, {'end': 2092.335, 'start': 1974.196, 'title': 'Excel functions demo', 'summary': 'Demonstrates how excel automatically calculates results, provides built-in functions, and allows users to easily access and utilize functions, with a demonstration of using the date function to return a corresponding date in the excel date format pattern.', 'duration': 118.139, 'highlights': ['Excel automatically calculates the result of b6 and b7 and shows in b8 where the formula is copied.', 'Excel provides many functions, and users can easily access them by typing the first letter of the function in the formula bar.', 'Clicking on a function name in Excel provides a description about it, making it easier for users to understand and utilize.', 'Users can view all the built-in functions in Excel by clicking on the formulas tab and selecting the insert function option, where a dialog box appears containing a list of function categories and available functions under each category.', 'The demonstration shows how to use the date function in Excel to specify the year, month, and day, and return the corresponding date in the Excel date format pattern.']}], 'duration': 239.585, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Dbd-OfbeW1w/pics/Dbd-OfbeW1w1852750.jpg', 'highlights': ['Excel automatically manages the task of modifying cell references wherever you copy formulas in an Excel sheet.', 'Demonstration of the calculation of the sum of two values using Excel formula, 2 + 3 = 5.', 'The process of copying formulas in an Excel sheet demonstrated by simply selecting the cell that contains the formula and dragging it to the desired cell.', 'Excel automatically calculates the result of b6 and b7 and shows in b8 where the formula is copied.', 'Users can view all the built-in functions in Excel by clicking on the formulas tab and selecting the insert function option, where a dialog box appears containing a list of function categories and available functions under each category.', 'The demonstration shows how to use the date function in Excel to specify the year, month, and day, and return the corresponding date in the Excel date format pattern.', 'Excel provides many functions, and users can easily access them by typing the first letter of the function in the formula bar.', 'Clicking on a function name in Excel provides a description about it, making it easier for users to understand and utilize.', 'Formulas in MS Excel are expressions entered into cells, and can be mathematical operators, values, text, cell references, or worksheet functions.', 'To manually build a formula in Excel, it should always start with an equal sign, and the copied formula will have modified row and column addresses that suit its new position.']}], 'highlights': ['Excel offers print optimizations, built-in functions, and formula copying.', 'The maximum number of rows available in an Excel sheet is 10 lakhs 48 thousand 576, and the upper limit for columns is 16,000 384.', 'The status bar in Excel indicates four states - ready, edit, enter, and point, each serving different functions for data input and editing.', 'Excel context help feature provides information about commands by hovering the cursor, aiding user education.', 'Excel provides options to format cells for various data types such as numbers, currency, date, time, percentage, and scientific notation.', 'Page breaks in MS Excel allow precise control over what to print and what to omit.', 'Excel automatically manages the task of modifying cell references wherever you copy formulas in an Excel sheet.', 'Demonstration of the calculation of the sum of two values using Excel formula, 2 + 3 = 5.', 'Users can view all the built-in functions in Excel by clicking on the formulas tab and selecting the insert function option, where a dialog box appears containing a list of function categories and available functions under each category.', 'Formulas in MS Excel are expressions entered into cells, and can be mathematical operators, values, text, cell references, or worksheet functions.']}