title
Excel Interview Questions and Answers | Excel Questions Asked in Job Interviews | Edureka

description
🔥 Edureka Online Training and Certification (Use Code "𝐘𝐎𝐔𝐓𝐔𝐁𝐄𝟐𝟎") : https://www.edureka.co/search This Edureka video on 'Excel Interview Questions' will help you prepare for your upcoming Excel interviews with the top 50 MS Excel Interview Questions and answers. Here are all the categories the questions are divided into: General Excel Interview Questions Excel Pivot Tables and Pivot Charts Interview Questions Excel Formulas and Functions Interview Questions #Edureka #ExcelEdureka #ExcelInterviewQuestions #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 ----------------------------------------------------------------------------------------------------------- For more information, Please write back to us at sales@edureka.in or call us at IND: 9606058406 / US: 1833

detail
{'title': 'Excel Interview Questions and Answers | Excel Questions Asked in Job Interviews | Edureka', 'heatmap': [{'end': 1296.106, 'start': 1267.142, 'weight': 1}], 'summary': 'Prepare for 50 excel interview questions and answers, covering general, pi-related, and formula & function-related questions. learn ms excel basics, features, and tools with key quantifiable data, excel sheet tips & functions, macros, drop-down lists, pivot tables, functions, formulas, count functions, percentage calculation, what-if analysis, and built-in functions like sum, if, and count.', 'chapters': [{'end': 44.245, 'segs': [{'end': 44.245, 'src': 'embed', 'start': 11.314, 'weight': 0, 'content': [{'end': 14.196, 'text': 'Hey everyone, welcome back to a whole new session from edureka.', 'start': 11.314, 'duration': 2.882}, {'end': 20.719, 'text': "My name is Vajiha and in this session, you'll be preparing for the 50 most important Excel interview questions and answers.", 'start': 14.696, 'duration': 6.023}, {'end': 25.542, 'text': 'So this session will be divided into three different sections, that is, general questions,', 'start': 21.32, 'duration': 4.222}, {'end': 30.045, 'text': 'questions related to pi with tables and then questions dealing with formulas and functions in Excel.', 'start': 25.542, 'duration': 4.503}, {'end': 37.003, 'text': 'So before we begin just make sure you subscribe to our channel and hit the bell icon to stay updated with all the latest edureka videos.', 'start': 30.822, 'duration': 6.181}, {'end': 42.025, 'text': "Also, if you're looking for an online training certification in any of the training Technologies,", 'start': 37.544, 'duration': 4.481}, {'end': 44.245, 'text': 'check out the link given in the description box below.', 'start': 42.025, 'duration': 2.22}], 'summary': 'Prepare for 50 important excel interview questions and answers in three sections.', 'duration': 32.931, 'max_score': 11.314, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/8rh2RpAjenQ/pics/8rh2RpAjenQ11314.jpg'}], 'start': 11.314, 'title': 'Excel interview q&a preparation', 'summary': 'Covers preparation for 50 important excel interview questions and answers, divided into three sections: general questions, pi-related questions, and formula & function-related questions.', 'chapters': [{'end': 44.245, 'start': 11.314, 'title': 'Excel interview q&a preparation', 'summary': 'Covers preparation for 50 important excel interview questions and answers, divided into three sections: general questions, pi-related questions, and formula & function-related questions.', 'duration': 32.931, 'highlights': ['The session covers 50 important Excel interview questions and answers, which are divided into three sections: general questions, pi-related questions, and formula & function-related questions.', 'The presenter encourages viewers to subscribe to the channel and stay updated with the latest videos, and also promotes online training certification.', "The presenter's name is Vajiha and the session is hosted by edureka."]}], 'duration': 32.931, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/8rh2RpAjenQ/pics/8rh2RpAjenQ11314.jpg', 'highlights': ['Covers preparation for 50 important Excel interview questions and answers, divided into three sections: general questions, pi-related questions, and formula & function-related questions.', "The presenter's name is Vajiha and the session is hosted by Edureka.", 'The presenter encourages viewers to subscribe to the channel and stay updated with the latest videos, and also promotes online training certification.']}, {'end': 297.399, 'segs': [{'end': 107.997, 'src': 'embed', 'start': 45.025, 'weight': 0, 'content': [{'end': 52.107, 'text': 'So now moving on towards the first question, that is, explain MS Excel in brief, Microsoft Excel, as we all know,', 'start': 45.025, 'duration': 7.082}, {'end': 56.948, 'text': 'is a spreadsheet or a computer application that allows the storage of data in the form of table.', 'start': 52.107, 'duration': 4.841}, {'end': 64.965, 'text': 'Excel was developed by Microsoft and can be used on various operating systems such as Windows Mac OS iOS Android Etc.', 'start': 57.66, 'duration': 7.305}, {'end': 72.791, 'text': 'Some of the important features of MS Excel are the availability of graphing tools built-in functions such as some date count if Etc.', 'start': 65.726, 'duration': 7.065}, {'end': 77.659, 'text': 'Excel allows data analysis through tables charts filters, etc.', 'start': 73.837, 'duration': 3.822}, {'end': 85.424, 'text': 'It also provides the visual basic for application flexible workbooks and worksheet operations and also allows data validation.', 'start': 78.36, 'duration': 7.064}, {'end': 88.186, 'text': 'So these were a few features of MS Excel.', 'start': 85.964, 'duration': 2.222}, {'end': 90.827, 'text': "So now let's move on towards the next question.", 'start': 88.866, 'duration': 1.961}, {'end': 93.529, 'text': 'That is what do you mean by cells in MS Excel?', 'start': 90.867, 'duration': 2.662}, {'end': 100.013, 'text': 'So, as you can see on the screen, the area that falls as an intersection of the columns and the rows is known as a cell.', 'start': 94.349, 'duration': 5.664}, {'end': 107.997, 'text': 'The total number of rows that are available in Excel are 10 lakhs 48 thousand 576 and the total number of columns are 16, 000 384.', 'start': 100.874, 'duration': 7.123}], 'summary': 'Ms excel is a spreadsheet application with features like graphing tools, data analysis, and a huge capacity of 10,48,576 rows and 16,384 columns.', 'duration': 62.972, 'max_score': 45.025, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/8rh2RpAjenQ/pics/8rh2RpAjenQ45025.jpg'}, {'end': 194.346, 'src': 'embed', 'start': 132.867, 'weight': 3, 'content': [{'end': 138.309, 'text': 'So as you can see over here at the bottom of the workbook, you can see all the sheets that are available in this workbook.', 'start': 132.867, 'duration': 5.442}, {'end': 142.01, 'text': 'So by default they are named as sheet 1 sheet 2 Etc.', 'start': 139.089, 'duration': 2.921}, {'end': 147.852, 'text': 'In case you want to change the name of any of these sheets just double click on them and give any name of your choice.', 'start': 142.59, 'duration': 5.262}, {'end': 148.792, 'text': "I'll just say example.", 'start': 147.952, 'duration': 0.84}, {'end': 151.593, 'text': "So now let's move on towards the next question.", 'start': 149.673, 'duration': 1.92}, {'end': 160.342, 'text': 'What exactly is cell address? So the address of a cell refers to the address that is obtained by combination of the row number and the column letter.', 'start': 151.933, 'duration': 8.409}, {'end': 164.525, 'text': 'So each cell of an MS Excel sheet will have a unique address.', 'start': 161.062, 'duration': 3.463}, {'end': 166.606, 'text': 'So I hope you guys are clear with this.', 'start': 165.305, 'duration': 1.301}, {'end': 172.731, 'text': 'So now moving on towards the next question of the session, which is can you add new cells to an Excel sheet?', 'start': 167.407, 'duration': 5.324}, {'end': 176.634, 'text': 'The answer is yes, you can insert new cells into a sheet.', 'start': 173.251, 'duration': 3.383}, {'end': 178.681, 'text': 'To add a new cell.', 'start': 177.481, 'duration': 1.2}, {'end': 183.923, 'text': 'what you have to do is simply select the cell where you want to insert a new cell and then right-click on it,', 'start': 178.681, 'duration': 5.242}, {'end': 188.804, 'text': 'go to the insert option and then select the place where you want to insert a new cell.', 'start': 183.923, 'duration': 4.881}, {'end': 194.346, 'text': 'So, in case you want to shift all these cells towards the right and then insert a cell before this,', 'start': 189.385, 'duration': 4.961}], 'summary': 'Excel workbook contains sheets with unique cell addresses. new cells can be added.', 'duration': 61.479, 'max_score': 132.867, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/8rh2RpAjenQ/pics/8rh2RpAjenQ132867.jpg'}, {'end': 246.157, 'src': 'embed', 'start': 217.075, 'weight': 6, 'content': [{'end': 219.817, 'text': 'You can use the commands present in the phone group of the home tab.', 'start': 217.075, 'duration': 2.742}, {'end': 222.299, 'text': "So what I'm going to do is just open this of here.", 'start': 220.318, 'duration': 1.981}, {'end': 230.066, 'text': 'So as you can see the number group allows you to format cells to be of any type such as currency accounting date percentage Etc.', 'start': 223.22, 'duration': 6.846}, {'end': 237.795, 'text': "Alignment allows text control, alignment and setting of the direction of the text that's present in the cell font.", 'start': 231.073, 'duration': 6.722}, {'end': 241.976, 'text': 'enables various fonts, styles, sizes, colors, etc.', 'start': 237.795, 'duration': 4.181}, {'end': 246.157, 'text': 'border allows cell borders to be changed, removed, colored and so on.', 'start': 241.976, 'duration': 4.181}], 'summary': 'Phone group allows formatting cells for currency, accounting, date, percentage etc. alignment controls text alignment and font enables various font styles and border allows changing cell borders.', 'duration': 29.082, 'max_score': 217.075, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/8rh2RpAjenQ/pics/8rh2RpAjenQ217075.jpg'}, {'end': 282.432, 'src': 'embed', 'start': 256.619, 'weight': 7, 'content': [{'end': 264.925, 'text': "So now let's move on towards the next question, which is can you add comments to a cell? Yes comments can be added to add comments to a cell.", 'start': 256.619, 'duration': 8.306}, {'end': 268.966, 'text': 'All you have to do is right-click on that cell and choose the new comment option.', 'start': 265.165, 'duration': 3.801}, {'end': 274.628, 'text': 'As you can see over here a dialog box will open wherein you can type any comment of your choice.', 'start': 270.047, 'duration': 4.581}, {'end': 276.409, 'text': "So I'll just write down comment over here.", 'start': 274.889, 'duration': 1.52}, {'end': 282.432, 'text': "Okay So as you can see I've added a comment to the cell.", 'start': 276.429, 'duration': 6.003}], 'summary': 'You can add comments to cells by right-clicking and choosing the new comment option.', 'duration': 25.813, 'max_score': 256.619, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/8rh2RpAjenQ/pics/8rh2RpAjenQ256619.jpg'}], 'start': 45.025, 'title': 'Ms excel basics and features', 'summary': 'Covers the basics and features of ms excel, including its development by microsoft, availability on various operating systems, and important tools such as graphing tools, built-in functions, data analysis through tables and charts, visual basic for application, cell addressing, adding new cells, formatting cells, and adding comments, with key quantifiable data such as the total number of rows and columns and the available formatting options.', 'chapters': [{'end': 88.186, 'start': 45.025, 'title': 'Ms excel: features and functions', 'summary': 'Explains the features of ms excel, including its development by microsoft, availability on various operating systems, and important tools such as graphing tools, built-in functions, data analysis through tables and charts, and visual basic for application.', 'duration': 43.161, 'highlights': ['Excel was developed by Microsoft and can be used on various operating systems such as Windows Mac OS iOS Android Etc.', 'Important features of MS Excel include the availability of graphing tools, built-in functions such as date count, data analysis through tables and charts, and visual basic for application flexible workbooks and worksheet operations.', 'Excel allows data analysis through tables, charts, filters, etc.', 'MS Excel provides the visual basic for application flexible workbooks and worksheet operations and also allows data validation.']}, {'end': 297.399, 'start': 88.866, 'title': 'Ms excel basics and features', 'summary': 'Covers the basics of ms excel, including the definition of cells, total number of rows and columns, spreadsheet management, cell addressing, adding new cells, formatting cells, and adding comments, with key quantifiable data such as the total number of rows and columns and the available formatting options.', 'duration': 208.533, 'highlights': ['The total number of rows that are available in Excel are 10 lakhs 48 thousand 576 and the total number of columns are 16, 000 384. The total number of rows and columns in Excel are 10,48,576 and 16,384 respectively.', 'A single workbook may have more than one worksheet, and the sheets can be renamed by double-clicking on them. A workbook can have multiple worksheets, and the sheets can be renamed by double-clicking on them.', "The address of a cell refers to the combination of the row number and the column letter, providing each cell with a unique address. A cell's address is formed by combining the row number and the column letter, ensuring each cell has a unique address.", 'New cells can be inserted into a sheet by selecting the cell, right-clicking, and choosing the insert option, with the ability to shift cells to the right or insert above specific lines. New cells can be inserted by right-clicking on the selected cell and choosing the insert option, allowing for shifting cells or inserting above specific lines.', "MS Excel cells can be formatted using commands in the Home tab's font group, including options for number format, alignment, font, border, cell fill, and protection. MS Excel cells can be formatted using commands in the Home tab's font group, offering options for number format, alignment, font, border, cell fill, and protection.", 'Comments can be added to a cell by right-clicking and choosing the new comment option, with a purple symbol indicating the presence of a comment. Comments can be added to a cell by right-clicking and selecting the new comment option, and a purple symbol will indicate the presence of a comment.']}], 'duration': 252.374, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/8rh2RpAjenQ/pics/8rh2RpAjenQ45025.jpg', 'highlights': ['MS Excel was developed by Microsoft and is available on various operating systems such as Windows, Mac OS, iOS, and Android.', 'MS Excel provides important features such as graphing tools, built-in functions, data analysis through tables and charts, and visual basic for application.', 'The total number of rows in Excel is 1,048,576 and the total number of columns is 16,384.', 'A single workbook may have more than one worksheet, and the sheets can be renamed by double-clicking on them.', 'The address of a cell is formed by combining the row number and the column letter, ensuring each cell has a unique address.', 'New cells can be inserted by right-clicking on the selected cell and choosing the insert option, allowing for shifting cells or inserting above specific lines.', "MS Excel cells can be formatted using commands in the Home tab's font group, offering options for number format, alignment, font, border, cell fill, and protection.", 'Comments can be added to a cell by right-clicking and selecting the new comment option, and a purple symbol will indicate the presence of a comment.']}, {'end': 963.058, 'segs': [{'end': 324.991, 'src': 'embed', 'start': 298.239, 'weight': 0, 'content': [{'end': 304.943, 'text': 'So one more important thing that you guys have to note is that these comments will be visible to all those people who have access to this Excel sheet.', 'start': 298.239, 'duration': 6.704}, {'end': 307.865, 'text': 'Not just that they can also answer to your comments.', 'start': 305.524, 'duration': 2.341}, {'end': 314.189, 'text': 'So now moving on towards the next question, which is can you add new rows and columns to an Excel sheet?', 'start': 308.665, 'duration': 5.524}, {'end': 317.971, 'text': 'Yes, you can add new rows and columns to an Excel sheet.', 'start': 314.909, 'duration': 3.062}, {'end': 324.991, 'text': "What I'm going to do over here is select this column right click over it and then select the insert option.", 'start': 318.809, 'duration': 6.182}], 'summary': 'Comments in excel are visible to all, new rows and columns can be added.', 'duration': 26.752, 'max_score': 298.239, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/8rh2RpAjenQ/pics/8rh2RpAjenQ298239.jpg'}, {'end': 402.058, 'src': 'embed', 'start': 367.082, 'weight': 5, 'content': [{'end': 372.246, 'text': 'The ribbon is basically your key interface with Excel and it appears at the top of the Excel window.', 'start': 367.082, 'duration': 5.164}, {'end': 375.978, 'text': 'So as you all can see on the screen, this is nothing but the ribbon tab.', 'start': 372.856, 'duration': 3.122}, {'end': 380.682, 'text': 'It consists of file home insert page layout formulas, etc.', 'start': 376.539, 'duration': 4.143}, {'end': 385.766, 'text': 'The ribbon tab basically allows users to access many of the important commands directly.', 'start': 381.483, 'duration': 4.283}, {'end': 390.049, 'text': 'So in case you want to access any of these commands, all you have to do is just click on them.', 'start': 386.286, 'duration': 3.763}, {'end': 396.133, 'text': 'Not just this Excel also allows you to customize the ribbon now in order to customize the ribbon tab.', 'start': 390.709, 'duration': 5.424}, {'end': 402.058, 'text': 'All you have to do is right-click anywhere on this and then choose the customize the ribbon option.', 'start': 396.394, 'duration': 5.664}], 'summary': "The ribbon in excel provides access to key commands and can be customized by right-clicking and choosing the 'customize the ribbon' option.", 'duration': 34.976, 'max_score': 367.082, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/8rh2RpAjenQ/pics/8rh2RpAjenQ367082.jpg'}, {'end': 586.578, 'src': 'embed', 'start': 557.332, 'weight': 1, 'content': [{'end': 564.493, 'text': 'So to do that, all you have to do is right click on any of the sheet that is present in the workbook and then click on the select all sheets option.', 'start': 557.332, 'duration': 7.161}, {'end': 570.491, 'text': 'Now, after doing this, if I apply some format to any of the sheet present in this workbook,', 'start': 565.569, 'duration': 4.922}, {'end': 574.153, 'text': 'that format is going to be applied to all the sheets that are present in this workbook.', 'start': 570.491, 'duration': 3.662}, {'end': 577.154, 'text': 'So as you can see, I just have one workbook over here.', 'start': 574.733, 'duration': 2.421}, {'end': 579.055, 'text': 'Let me just add on a new workbook.', 'start': 577.534, 'duration': 1.521}, {'end': 586.578, 'text': "And then I'll select all sheets and what I'm going to do over here is go to the home tab font.", 'start': 580.535, 'duration': 6.043}], 'summary': 'Select all sheets to apply format to entire workbook.', 'duration': 29.246, 'max_score': 557.332, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/8rh2RpAjenQ/pics/8rh2RpAjenQ557332.jpg'}, {'end': 628.155, 'src': 'embed', 'start': 603.09, 'weight': 4, 'content': [{'end': 608.732, 'text': "So now let's move on towards the next question, which is what do you understand by relative cell addresses?", 'start': 603.09, 'duration': 5.642}, {'end': 611.392, 'text': 'whenever you copy formulas in Excel,', 'start': 608.732, 'duration': 2.66}, {'end': 617.795, 'text': 'the addresses of the reference cells get modified automatically in order to match the position where the formula has been copied.', 'start': 611.392, 'duration': 6.403}, {'end': 621.816, 'text': 'Now, this is done by a system called as the relative cell addresses.', 'start': 618.455, 'duration': 3.361}, {'end': 625.195, 'text': 'So let me get back to Excel in order to show this to you guys.', 'start': 622.614, 'duration': 2.581}, {'end': 628.155, 'text': "So what I'm going to do over here is type in some numbers.", 'start': 625.955, 'duration': 2.2}], 'summary': 'Relative cell addresses in excel automatically modify reference cells when formulas are copied.', 'duration': 25.065, 'max_score': 603.09, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/8rh2RpAjenQ/pics/8rh2RpAjenQ603090.jpg'}, {'end': 845.675, 'src': 'embed', 'start': 820.258, 'weight': 3, 'content': [{'end': 826.92, 'text': "Okay, So now let's move on towards next question, which is can you protect the cells of a sheet from being copied??", 'start': 820.258, 'duration': 6.662}, {'end': 829.58, 'text': 'So the answer is yes.', 'start': 827.76, 'duration': 1.82}, {'end': 832.641, 'text': 'you can do it by protecting the required cells or the complete sheet.', 'start': 829.58, 'duration': 3.061}, {'end': 841.433, 'text': 'Now to do this all you have to do is select the cells that you want to protect go to this font group over here and then select protection.', 'start': 833.59, 'duration': 7.843}, {'end': 845.675, 'text': 'From here check the hidden option and then click on OK.', 'start': 842.674, 'duration': 3.001}], 'summary': 'You can protect cells from being copied by selecting and hiding them in the font group.', 'duration': 25.417, 'max_score': 820.258, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/8rh2RpAjenQ/pics/8rh2RpAjenQ820258.jpg'}, {'end': 979.261, 'src': 'embed', 'start': 948.504, 'weight': 2, 'content': [{'end': 953.269, 'text': 'So now moving on towards the next question, which is what do you mean by macros?', 'start': 948.504, 'duration': 4.765}, {'end': 957.513, 'text': 'Excel allows you to automate the task that you do regularly by recording them into macros.', 'start': 953.269, 'duration': 4.244}, {'end': 963.058, 'text': 'So a macro is basically an action or a set of them that you can perform and number of times.', 'start': 958.253, 'duration': 4.805}, {'end': 971.386, 'text': 'So for example, if you have a record of sales of each item and at the end of the day, you have to calculate the sales profits loss Etc.', 'start': 963.818, 'duration': 7.568}, {'end': 979.261, 'text': 'So if you create a macro it will automatically calculate all these values and then you can use the same for future purposes.', 'start': 972.518, 'duration': 6.743}], 'summary': 'Macros in excel automate repetitive tasks, saving time and effort.', 'duration': 30.757, 'max_score': 948.504, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/8rh2RpAjenQ/pics/8rh2RpAjenQ948504.jpg'}], 'start': 298.239, 'title': 'Excel sheet tips & functions', 'summary': 'Covers adding new rows and columns, customizing ribbon interface, freezing panes, protecting workbooks and sheets, and using cell references and named ranges in excel.', 'chapters': [{'end': 424.407, 'start': 298.239, 'title': 'Excel sheet tips & ribbon interface', 'summary': 'Explains how to add new rows and columns to an excel sheet and customize the ribbon interface, including enabling the developer tab, ensuring user visibility and interaction with comments, and the positioning and functions of the ribbon interface.', 'duration': 126.168, 'highlights': ['Users can add new rows and columns to an Excel sheet by selecting a column or row, right-clicking, and choosing the insert option, allowing for easy customization and expansion of the sheet.', "Comments in Excel are visible to all users with access to the sheet, enabling interaction and collaboration, and users can customize the ribbon interface by right-clicking and choosing the 'customize the ribbon' option.", 'The ribbon interface in Excel, located at the top of the window, provides access to essential commands such as file, home, insert, page layout, and formulas, with the option to customize by adding or removing tabs and commands.']}, {'end': 963.058, 'start': 425.407, 'title': 'Excel functions and features', 'summary': 'Covers freezing panes, adding notes to cells, protecting workbooks and sheets, applying a single format to all sheets, understanding relative cell addresses, using absolute cell references, and creating named ranges in excel.', 'duration': 537.651, 'highlights': ["Excel allows you to apply the same format to all the sheets of a workbook by right-clicking on any sheet and selecting the 'select all sheets' option, enabling efficient formatting across multiple sheets. By using the 'select all sheets' option, any format applied to one sheet will be automatically applied to all sheets in the workbook, streamlining the formatting process.", 'Macros in Excel enable the automation of repetitive tasks by recording them as actions or a set of actions, offering increased efficiency and time-saving benefits. Macros in Excel allow users to automate repetitive tasks by recording them as a series of actions, providing a time-saving and efficient way to execute regularly performed tasks.', "Protecting cells and sheets in Excel can be achieved by selecting the cells to protect, navigating to the 'font' group, choosing 'protection', and then setting the desired protection options such as 'hidden', providing enhanced security for important data. By selecting specific cells, accessing the 'font' group, and setting the protection options such as 'hidden', users can protect sensitive data and formulas, enhancing the security of the worksheet.", 'Understanding relative cell addresses in Excel involves recognizing that when copying formulas, the reference cell addresses automatically adjust to match the new position, offering a dynamic way to work with data across different cells and ranges. Relative cell addresses in Excel automatically adjust the reference cell addresses when formulas are copied, providing a dynamic method for working with data across various cells and ranges.']}], 'duration': 664.819, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/8rh2RpAjenQ/pics/8rh2RpAjenQ298239.jpg', 'highlights': ['Users can add new rows and columns to an Excel sheet by selecting a column or row, right-clicking, and choosing the insert option, allowing for easy customization and expansion of the sheet.', "Excel allows you to apply the same format to all the sheets of a workbook by right-clicking on any sheet and selecting the 'select all sheets' option, enabling efficient formatting across multiple sheets.", 'Macros in Excel enable the automation of repetitive tasks by recording them as actions or a set of actions, offering increased efficiency and time-saving benefits.', "Protecting cells and sheets in Excel can be achieved by selecting the cells to protect, navigating to the 'font' group, choosing 'protection', and then setting the desired protection options such as 'hidden', providing enhanced security for important data.", 'Understanding relative cell addresses in Excel involves recognizing that when copying formulas, the reference cell addresses automatically adjust to match the new position, offering a dynamic way to work with data across different cells and ranges.', "Comments in Excel are visible to all users with access to the sheet, enabling interaction and collaboration, and users can customize the ribbon interface by right-clicking and choosing the 'customize the ribbon' option.", 'The ribbon interface in Excel, located at the top of the window, provides access to essential commands such as file, home, insert, page layout, and formulas, with the option to customize by adding or removing tabs and commands.']}, {'end': 1566.443, 'segs': [{'end': 1005.614, 'src': 'embed', 'start': 963.818, 'weight': 0, 'content': [{'end': 971.386, 'text': 'So for example, if you have a record of sales of each item and at the end of the day, you have to calculate the sales profits loss Etc.', 'start': 963.818, 'duration': 7.568}, {'end': 979.261, 'text': 'So if you create a macro it will automatically calculate all these values and then you can use the same for future purposes.', 'start': 972.518, 'duration': 6.743}, {'end': 984.763, 'text': 'So now moving on towards the next question, which is how do you create drop-down lists in Excel?', 'start': 980.181, 'duration': 4.582}, {'end': 992.266, 'text': 'So now, in case you want to create a drop-down list, all you have to do select on the data tab that is present in the ribbon and then,', 'start': 985.583, 'duration': 6.683}, {'end': 996.188, 'text': 'from this data tools group over here, select the data validation command.', 'start': 992.266, 'duration': 3.922}, {'end': 1005.614, 'text': "Okay from the given options select list provide the source So I'll just provide the vegetable names as a source and then I'll click on OK.", 'start': 997.768, 'duration': 7.846}], 'summary': 'Automate sales calculations with macros, create drop-down lists in excel using data validation.', 'duration': 41.796, 'max_score': 963.818, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/8rh2RpAjenQ/pics/8rh2RpAjenQ963818.jpg'}, {'end': 1093.082, 'src': 'embed', 'start': 1026.666, 'weight': 2, 'content': [{'end': 1032.39, 'text': 'Pivot tables are statistical tables that condense the data of those tables that have extensive information.', 'start': 1026.666, 'duration': 5.724}, {'end': 1041.715, 'text': 'The summary can be based on any field such as sales averages sums Etc that the Pivot table represents in a simple and an intelligent manner.', 'start': 1033.29, 'duration': 8.425}, {'end': 1048.56, 'text': 'Some of the important features of Pivot tables are they allow the display of exact data that you have to analyze.', 'start': 1042.516, 'duration': 6.044}, {'end': 1052.041, 'text': 'They provide various angles in order to view the data.', 'start': 1049.321, 'duration': 2.72}, {'end': 1054.902, 'text': 'They allow you to focus on important details.', 'start': 1052.382, 'duration': 2.52}, {'end': 1061.623, 'text': 'comparison of data is very handy and Pivot tables can detect different patterns relationships, data Trends, Etc.', 'start': 1054.902, 'duration': 6.721}, {'end': 1067.204, 'text': 'They can also create instant data accurate reports and serve as the base for Pivot charts.', 'start': 1062.383, 'duration': 4.821}, {'end': 1073.325, 'text': "So now let's move on towards the next question, which is how do you create Pivot tables?", 'start': 1068.184, 'duration': 5.141}, {'end': 1077.786, 'text': 'in order to create a Pivot table? You will first need to prepare the data in the tabular format.', 'start': 1073.325, 'duration': 4.461}, {'end': 1081.797, 'text': "Now while preparing this data, you'll have to keep a few points in mind.", 'start': 1078.695, 'duration': 3.102}, {'end': 1086.139, 'text': "The first thing is you'll have to arrange the data into rows and columns.", 'start': 1082.497, 'duration': 3.642}, {'end': 1093.082, 'text': 'The first row should contain unique heading for each of the columns and the columns should have only one type of data present in them.', 'start': 1086.899, 'duration': 6.183}], 'summary': 'Pivot tables condense extensive data, providing exact analysis and enabling creation of accurate reports and charts.', 'duration': 66.416, 'max_score': 1026.666, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/8rh2RpAjenQ/pics/8rh2RpAjenQ1026665.jpg'}, {'end': 1230.254, 'src': 'embed', 'start': 1202.447, 'weight': 5, 'content': [{'end': 1206.33, 'text': 'are data visualization tools that help you visualize the data in various ways.', 'start': 1202.447, 'duration': 3.883}, {'end': 1212.271, 'text': 'These charts can be of any type such as bar pie area line donut Etc.', 'start': 1207.19, 'duration': 5.081}, {'end': 1216.332, 'text': 'So in case I want to create a pivot chart for this pivot table over here.', 'start': 1213.091, 'duration': 3.241}, {'end': 1223.113, 'text': 'What I have to do is go to the insert tab and then from the charts group and select any chart of my choice.', 'start': 1216.632, 'duration': 6.481}, {'end': 1225.373, 'text': "And then I'll click on OK.", 'start': 1224.373, 'duration': 1}, {'end': 1230.254, 'text': 'So as you can see a pivot chart has been created for this pivot table.', 'start': 1226.773, 'duration': 3.481}], 'summary': 'Data visualization tools create various charts to represent data, facilitating analysis and decision-making.', 'duration': 27.807, 'max_score': 1202.447, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/8rh2RpAjenQ/pics/8rh2RpAjenQ1202447.jpg'}, {'end': 1296.106, 'src': 'heatmap', 'start': 1267.142, 'weight': 1, 'content': [{'end': 1270.143, 'text': 'Please note that both the tables should be present in the same worksheet.', 'start': 1267.142, 'duration': 3.001}, {'end': 1275.825, 'text': "So now to show this to you guys or what I'm going to do is insert a new sheet and over here.", 'start': 1271.003, 'duration': 4.822}, {'end': 1280.646, 'text': "I'll just copy half of this data.", 'start': 1275.845, 'duration': 4.801}, {'end': 1288.109, 'text': "So what I've done over here is separated the table that I've created previously into two different tables.", 'start': 1283.087, 'duration': 5.022}, {'end': 1292.57, 'text': "So what I'm going to do here is click all plus D and then I'll click on P.", 'start': 1288.929, 'duration': 3.641}, {'end': 1296.106, 'text': 'From this Pivot table and Pivot chart wizard.', 'start': 1293.965, 'duration': 2.141}], 'summary': 'Demonstrating data separation into two tables for pivot table and pivot chart creation.', 'duration': 28.964, 'max_score': 1267.142, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/8rh2RpAjenQ/pics/8rh2RpAjenQ1267142.jpg'}], 'start': 963.818, 'title': 'Excel macros, drop-down lists, and pivot tables in excel', 'summary': 'Discusses how macros in excel automate calculations for sales profits, creating drop-down lists for data validation, and introduces pivot tables, highlighting their features such as condensing extensive data, creating instant accurate reports, and allowing data visualization through pivot charts. it also explains the process of creating pivot tables, charts, using multiple tables, along with various functionalities like filtering, changing value fields, and stopping automatic sorting in pivot tables.', 'chapters': [{'end': 1025.872, 'start': 963.818, 'title': 'Excel macros and drop-down lists', 'summary': 'Discusses how macros in excel can automate calculations for sales profits and the process of creating drop-down lists for data validation, enabling efficient data management and analysis.', 'duration': 62.054, 'highlights': ['Creating macros in Excel automates the calculation of sales profits and loss, improving efficiency for future use.', 'The process of creating drop-down lists in Excel involves navigating to the data tab, selecting data validation, and providing a source for the list, enhancing data management.', 'Drop-down lists in Excel enable efficient data entry and validation, leading to streamlined data analysis and management.']}, {'end': 1566.443, 'start': 1026.666, 'title': 'Pivot tables in excel', 'summary': 'Introduces pivot tables in excel, highlighting their features such as condensing extensive data, creating instant accurate reports, and allowing data visualization through pivot charts. it explains the process of creating pivot tables, charts, and using multiple tables, along with various functionalities like filtering, changing value fields, and stopping automatic sorting in pivot tables.', 'duration': 539.777, 'highlights': ['Pivot tables condense extensive data and allow the display of exact data for analysis. Pivot tables condense extensive data and allow the display of exact data for analysis, such as sales averages and sums, in a simple and intelligent manner.', 'Creating Pivot tables involves preparing data in tabular format with unique headings for each column, no blank rows, and separate data for creating the Pivot table. Creating Pivot tables involves preparing data in tabular format with unique headings for each column, no blank rows, and separate data for creating the Pivot table, ensuring data accuracy and efficiency.', 'The process of creating Pivot tables involves dragging and dropping fields into filters, columns, rows, and values areas to generate the desired table. Creating Pivot tables involves dragging and dropping fields into filters, columns, rows, and values areas to generate the desired table, providing flexibility and customization in data analysis.', 'Pivot charts in MS Excel are data visualization tools that help visualize data in various types such as bar, pie, area, line, and donut charts. Pivot charts in MS Excel are data visualization tools that help visualize data in various types such as bar, pie, area, line, and donut charts, enhancing data presentation and analysis.', 'Pivot tables can be created using one or more base tables, provided they are present in the same worksheet, allowing for comprehensive data analysis. Pivot tables can be created using one or more base tables, provided they are present in the same worksheet, allowing for comprehensive data analysis and comparison across different data sets.']}], 'duration': 602.625, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/8rh2RpAjenQ/pics/8rh2RpAjenQ963818.jpg', 'highlights': ['Creating macros in Excel automates the calculation of sales profits and loss, improving efficiency for future use.', 'Drop-down lists in Excel enable efficient data entry and validation, leading to streamlined data analysis and management.', 'Pivot tables condense extensive data and allow the display of exact data for analysis, such as sales averages and sums, in a simple and intelligent manner.', 'Creating Pivot tables involves preparing data in tabular format with unique headings for each column, no blank rows, and separate data for creating the Pivot table, ensuring data accuracy and efficiency.', 'The process of creating Pivot tables involves dragging and dropping fields into filters, columns, rows, and values areas to generate the desired table, providing flexibility and customization in data analysis.', 'Pivot charts in MS Excel are data visualization tools that help visualize data in various types such as bar, pie, area, line, and donut charts, enhancing data presentation and analysis.', 'Pivot tables can be created using one or more base tables, provided they are present in the same worksheet, allowing for comprehensive data analysis and comparison across different data sets.']}, {'end': 2102.891, 'segs': [{'end': 1630.143, 'src': 'embed', 'start': 1605.988, 'weight': 0, 'content': [{'end': 1612.329, 'text': 'So, as you can see on the screen, functions present in MS Excel have been categorized in this list of options that are present over here.', 'start': 1605.988, 'duration': 6.341}, {'end': 1621.519, 'text': 'So you have categories based on the dates and time financial functions, functions based on mathematics and trigonometry, statistical functions,', 'start': 1613.436, 'duration': 8.083}, {'end': 1630.143, 'text': 'look up and reference functions, database text, logical information and engineering functions, cube functions, compatibility and web functions.', 'start': 1621.519, 'duration': 8.624}], 'summary': 'Ms excel functions categorized into 9 types', 'duration': 24.155, 'max_score': 1605.988, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/8rh2RpAjenQ/pics/8rh2RpAjenQ1605988.jpg'}, {'end': 1667.29, 'src': 'embed', 'start': 1641.852, 'weight': 1, 'content': [{'end': 1647.436, 'text': 'Bodmas as many of us know stands for brackets order division multiplication addition and subtraction.', 'start': 1641.852, 'duration': 5.584}, {'end': 1651.579, 'text': 'So that means in every formula brackets are executed first.', 'start': 1648.076, 'duration': 3.503}, {'end': 1655.421, 'text': 'If any of them are present followed by multiplication division Etc.', 'start': 1651.699, 'duration': 3.722}, {'end': 1657.323, 'text': 'Now to show an example of this.', 'start': 1656.062, 'duration': 1.261}, {'end': 1658.724, 'text': 'Let me get back to Excel.', 'start': 1657.623, 'duration': 1.101}, {'end': 1660.865, 'text': 'Let me just give in some values of here.', 'start': 1659.304, 'duration': 1.561}, {'end': 1665.929, 'text': "I'll say 3 4 5 now in this cell.", 'start': 1660.945, 'duration': 4.984}, {'end': 1667.29, 'text': "I'll just type in some expression.", 'start': 1665.989, 'duration': 1.301}], 'summary': 'Bodmas prioritizes operations in formulas, e.g. in excel.', 'duration': 25.438, 'max_score': 1641.852, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/8rh2RpAjenQ/pics/8rh2RpAjenQ1641852.jpg'}, {'end': 1773.728, 'src': 'embed', 'start': 1744.71, 'weight': 2, 'content': [{'end': 1750.491, 'text': "I just specified this range to be all the values to be added using the sum function and now I'll hit enter.", 'start': 1744.71, 'duration': 5.781}, {'end': 1757.604, 'text': 'So, as you can see over here, the sum function has added all the values that are present between a 1 and D 1.', 'start': 1751.403, 'duration': 6.201}, {'end': 1760.465, 'text': 'similar to the sum function, is a summit function.', 'start': 1757.604, 'duration': 2.861}, {'end': 1766.426, 'text': 'one difference is that this function is used to calculate the sum of values that comply to a given condition.', 'start': 1760.465, 'duration': 5.961}, {'end': 1773.728, 'text': 'now, in case I just change this from some to some, if I have to specify the range followed by the criteria.', 'start': 1766.426, 'duration': 7.302}], 'summary': 'Sum function adds values in specified range, summit function calculates sum based on condition.', 'duration': 29.018, 'max_score': 1744.71, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/8rh2RpAjenQ/pics/8rh2RpAjenQ1744710.jpg'}, {'end': 1813.53, 'src': 'embed', 'start': 1788.532, 'weight': 3, 'content': [{'end': 1796.699, 'text': 'So now moving on towards the next question, which is what are the different types of count functions available in Excel?', 'start': 1788.532, 'duration': 8.167}, {'end': 1804.426, 'text': 'Excel provides five types of count functions, that is, count count, a count, blank count if and count if s.', 'start': 1796.699, 'duration': 7.727}, {'end': 1806.808, 'text': 'so talking about the first function, that is, the count function.', 'start': 1804.426, 'duration': 2.382}, {'end': 1813.53, 'text': 'This function returns the total number of cells that have numbers in the range that is specified to it as a parameter.', 'start': 1807.549, 'duration': 5.981}], 'summary': 'Excel offers five count functions, including count, counta, countblank, countif, and countifs.', 'duration': 24.998, 'max_score': 1788.532, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/8rh2RpAjenQ/pics/8rh2RpAjenQ1788532.jpg'}, {'end': 1933.966, 'src': 'embed', 'start': 1911.098, 'weight': 5, 'content': [{'end': 1918.344, 'text': 'So now talking about count if s this is a very special function that allows you to specify a set of conditions in order to count them.', 'start': 1911.098, 'duration': 7.246}, {'end': 1921.478, 'text': "So what I'm going to do is go to the table that I've created of here.", 'start': 1919.016, 'duration': 2.462}, {'end': 1924.76, 'text': "So what I'm going to do over here is type in an equal to sign.", 'start': 1922.418, 'duration': 2.342}, {'end': 1933.966, 'text': "Then I'll choose the count if s formula and then I'll have to specify the range for criteria 1 the range for criteria 2 and so on.", 'start': 1926.001, 'duration': 7.965}], 'summary': 'Countif s function allows counting based on specified conditions.', 'duration': 22.868, 'max_score': 1911.098, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/8rh2RpAjenQ/pics/8rh2RpAjenQ1911098.jpg'}, {'end': 2035.44, 'src': 'embed', 'start': 1994.526, 'weight': 4, 'content': [{'end': 2003.032, 'text': "Then I'll hit enter and once I've obtained the result, I'll click on home tab and from here, I'll click on the percentage symbol.", 'start': 1994.526, 'duration': 8.506}, {'end': 2006.114, 'text': "Similarly, I'll just copy this formula to the next cell.", 'start': 2003.732, 'duration': 2.382}, {'end': 2011.708, 'text': 'So, as you can see, Yvonne has scored 96% and Sergio has scored in 78%.', 'start': 2007.446, 'duration': 4.262}, {'end': 2019.872, 'text': 'so now moving on towards the next question, which is explain how to calculate compound interest in Excel.', 'start': 2011.708, 'duration': 8.164}, {'end': 2021.793, 'text': 'to calculate compound interest in Excel.', 'start': 2019.872, 'duration': 1.921}, {'end': 2024.414, 'text': 'You can make use of the FV function.', 'start': 2021.993, 'duration': 2.421}, {'end': 2030.457, 'text': 'the FV function returns the future value of an investment based on periodic, constant investment rates and payments.', 'start': 2024.414, 'duration': 6.043}, {'end': 2032.518, 'text': 'So let me get back to Excel.', 'start': 2031.298, 'duration': 1.22}, {'end': 2035.44, 'text': "So, as you can see over here, I've already created a table.", 'start': 2033.119, 'duration': 2.321}], 'summary': 'Demonstrates using excel to calculate percentages and compound interest, with yvonne scoring 96% and sergio scoring 78%.', 'duration': 40.914, 'max_score': 1994.526, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/8rh2RpAjenQ/pics/8rh2RpAjenQ1994526.jpg'}], 'start': 1569.445, 'title': 'Excel functions, formulas, count functions, and percentage calculation', 'summary': 'Covers excel functions and formulas, including categories of functions, operator precedence, and examples of the sum and sumif functions, along with count functions like count, count a, count if, count blank, and count if s, and also explains percentage and compound interest calculations in excel.', 'chapters': [{'end': 1788.532, 'start': 1569.445, 'title': 'Excel functions and formulas', 'summary': 'Covers excel functions and formulas, including categories of functions, operator precedence, and examples of the sum and sumif functions, emphasizing time conservation, the bodmas rule, and practical demonstrations of the sum and sumif functions.', 'duration': 219.087, 'highlights': ['Excel functions are used to perform specific tasks, with many built-in functions aiding in time conservation and ease of execution. Excel functions are used to perform specific tasks, with many built-in functions aiding in time conservation and ease of execution.', 'Functions in MS Excel are categorized based on dates and time, financial functions, mathematics and trigonometry, statistical functions, look up and reference functions, database text, logical information, engineering functions, cube functions, compatibility, and web functions. Functions in MS Excel are categorized based on dates and time, financial functions, mathematics and trigonometry, statistical functions, look up and reference functions, database text, logical information, engineering functions, cube functions, compatibility, and web functions.', 'Formulas in Excel are executed according to the BODMAS rule, where brackets are executed first, followed by multiplication, division, addition, and subtraction. Formulas in Excel are executed according to the BODMAS rule, where brackets are executed first, followed by multiplication, division, addition, and subtraction.', 'Practical demonstration of the sum and sumif functions showcases their ability to calculate the sum of values and the sum of values complying with a given condition, such as sum of values less than 15. Practical demonstration of the sum and sumif functions showcases their ability to calculate the sum of values and the sum of values complying with a given condition, such as sum of values less than 15.']}, {'end': 2102.891, 'start': 1788.532, 'title': 'Excel count functions and percentage calculation', 'summary': 'Discusses the different types of count functions available in excel, including count, count a, count if, count blank, and count if s, and also explains how to calculate percentages and compound interest in excel using specific functions and examples.', 'duration': 314.359, 'highlights': ['Excel provides five types of count functions: count, count a, count if, count blank, and count if s. Excel offers count, count a, count if, count blank, and count if s functions for various counting purposes.', 'The count function returns the total number of cells containing numbers in the specified range, for example, returning 5 for a range with 5 cells containing numbers. The count function returns the total number of cells containing numbers in the specified range, for example, returning 5 for a range with 5 cells containing numbers.', 'The count a function counts all cells that are not empty within the given range, ignoring the empty cells. The count a function counts all cells that are not empty within the given range, ignoring the empty cells.', 'The count if function counts the number of cells that comply with a given condition, such as counting cells with values greater than 10. The count if function counts the number of cells that comply with a given condition, such as counting cells with values greater than 10.', 'The count blank function counts the number of empty cells within a given range, for example, returning 7 for a range containing 7 empty cells. The count blank function counts the number of empty cells within a given range, for example, returning 7 for a range containing 7 empty cells.', 'The count if s function allows specifying multiple conditions to count data meeting specific criteria within a range. The count if s function allows specifying multiple conditions to count data meeting specific criteria within a range.', 'To calculate percentages in Excel, the example demonstrates dividing the part by the whole and then converting the result to a percentage, such as Yvonne scoring 96% and Sergio scoring 78%. The example demonstrates dividing the part by the whole and then converting the result to a percentage, such as Yvonne scoring 96% and Sergio scoring 78%.', 'The FV function in Excel is used to calculate compound interest, returning the future value of an investment based on periodic, constant investment rates and payments, as shown in the example with a 500 investment at 10% rate for 5 years with 12 compounding periods. The FV function in Excel is used to calculate compound interest, returning the future value of an investment based on periodic, constant investment rates and payments, as shown in the example with a 500 investment at 10% rate for 5 years with 12 compounding periods.']}], 'duration': 533.446, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/8rh2RpAjenQ/pics/8rh2RpAjenQ1569445.jpg', 'highlights': ['Excel functions are categorized based on dates and time, financial functions, mathematics and trigonometry, statistical functions, look up and reference functions, database text, logical information, engineering functions, cube functions, compatibility, and web functions.', 'Formulas in Excel are executed according to the BODMAS rule, where brackets are executed first, followed by multiplication, division, addition, and subtraction.', 'Practical demonstration of the sum and sumif functions showcases their ability to calculate the sum of values and the sum of values complying with a given condition, such as sum of values less than 15.', 'Excel offers count, count a, count if, count blank, and count if s functions for various counting purposes.', 'The FV function in Excel is used to calculate compound interest, returning the future value of an investment based on periodic, constant investment rates and payments, as shown in the example with a 500 investment at 10% rate for 5 years with 12 compounding periods.', 'The count if s function allows specifying multiple conditions to count data meeting specific criteria within a range.', 'To calculate percentages in Excel, the example demonstrates dividing the part by the whole and then converting the result to a percentage, such as Yvonne scoring 96% and Sergio scoring 78%.']}, {'end': 2744.564, 'segs': [{'end': 2131.886, 'src': 'embed', 'start': 2102.891, 'weight': 0, 'content': [{'end': 2109.978, 'text': 'the future value for an investment of 500 at the rate of 10% for five years and the compounding periods being 12 is 822.65 dollars.', 'start': 2102.891, 'duration': 7.087}, {'end': 2122.839, 'text': 'So the future value for an investment of $500 at the rate of 10% for five years and 12 compounding periods is 822.65 dollars.', 'start': 2113.792, 'duration': 9.047}, {'end': 2125.04, 'text': 'So I hope you guys are clear with this.', 'start': 2123.76, 'duration': 1.28}, {'end': 2131.886, 'text': 'So now moving on towards the next question, which is how do you find averages in MS Excel?', 'start': 2126.421, 'duration': 5.465}], 'summary': 'Investing $500 at 10% for 5 years with 12 compounding periods yields $822.65.', 'duration': 28.995, 'max_score': 2102.891, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/8rh2RpAjenQ/pics/8rh2RpAjenQ2102891.jpg'}, {'end': 2201.56, 'src': 'embed', 'start': 2174.072, 'weight': 1, 'content': [{'end': 2179.797, 'text': 'The vlookup is a function present in Excel, used to look up and bring forth data from a given range.', 'start': 2174.072, 'duration': 5.725}, {'end': 2184.981, 'text': 'V stands for vertical and to use this function, data should be arranged vertically.', 'start': 2179.797, 'duration': 5.184}, {'end': 2189.625, 'text': 'vlookup is very useful when you have to find some piece of data from a huge amount of data.', 'start': 2184.981, 'duration': 4.644}, {'end': 2192.067, 'text': 'So how does this vlookup function work?', 'start': 2190.365, 'duration': 1.702}, {'end': 2201.56, 'text': 'The V lookup function in Excel takes a lookup value and begins to look for the same in the leftmost column when it finds the first occurrence of the given lookup value.', 'start': 2192.876, 'duration': 8.684}], 'summary': 'Vlookup in excel is used to retrieve data from a vertical range, helpful for finding specific data in large datasets.', 'duration': 27.488, 'max_score': 2174.072, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/8rh2RpAjenQ/pics/8rh2RpAjenQ2174072.jpg'}, {'end': 2433.924, 'src': 'embed', 'start': 2404.628, 'weight': 2, 'content': [{'end': 2407.389, 'text': 'You can check out the vlookup in Excel video from edureka.', 'start': 2404.628, 'duration': 2.761}, {'end': 2408.989, 'text': 'So now moving on.', 'start': 2408.209, 'duration': 0.78}, {'end': 2415.972, 'text': "How do you perform a horizontal lookup in Excel to perform a horizontal lookup? You'll have to make use of the H lookup function.", 'start': 2409.489, 'duration': 6.483}, {'end': 2423.617, 'text': 'The edge lookup function, just like the V lookup function, takes a lookup value, the table array, and instead of the column index number,', 'start': 2416.752, 'duration': 6.865}, {'end': 2426.979, 'text': 'it takes the row index number as a parameter and the range lookup value.', 'start': 2423.617, 'duration': 3.362}, {'end': 2431.823, 'text': "So now to perform an edge lookup what I'm going to do over here is take a new cell.", 'start': 2427.82, 'duration': 4.003}, {'end': 2433.924, 'text': "I'll just type in edge lookup.", 'start': 2432.723, 'duration': 1.201}], 'summary': 'Edureka offers a tutorial on h lookup function in excel.', 'duration': 29.296, 'max_score': 2404.628, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/8rh2RpAjenQ/pics/8rh2RpAjenQ2404628.jpg'}, {'end': 2597.77, 'src': 'embed', 'start': 2557.533, 'weight': 3, 'content': [{'end': 2561.956, 'text': 'Okay. So now moving on towards the next question, which is what is the what-if analysis?', 'start': 2557.533, 'duration': 4.423}, {'end': 2571.024, 'text': 'What if analysis is the technique of performing changes to one or more formulas present in a cell in order to see how it affects the result of those formulas?', 'start': 2562.722, 'duration': 8.302}, {'end': 2572.504, 'text': 'in the worksheet?', 'start': 2571.024, 'duration': 1.48}, {'end': 2579.026, 'text': 'Excel provides three types of what-if analysis tools, that is, scenarios, gold seek and data tables.', 'start': 2572.504, 'duration': 6.522}, {'end': 2584.227, 'text': 'scenarios and data tables take a set of inputs to check for the potential results.', 'start': 2579.026, 'duration': 5.201}, {'end': 2590.106, 'text': 'scenarios can work with many variables, but input values can be at the max 32..', 'start': 2584.227, 'duration': 5.879}, {'end': 2597.77, 'text': 'Data tables, on the other hand, work with just one or two variables, but can accept many distinct values for each of those variables.', 'start': 2590.106, 'duration': 7.664}], 'summary': 'What-if analysis in excel involves changing formulas to see how it affects results. excel provides 3 types of what-if analysis tools: scenarios, goal seek, and data tables.', 'duration': 40.237, 'max_score': 2557.533, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/8rh2RpAjenQ/pics/8rh2RpAjenQ2557533.jpg'}, {'end': 2664.931, 'src': 'embed', 'start': 2638.627, 'weight': 5, 'content': [{'end': 2643.792, 'text': 'A function, on the other hand, is a built-in piece of code that is used to perform some particular action.', 'start': 2638.627, 'duration': 5.165}, {'end': 2650.158, 'text': 'Excel provides a huge number of built-in functions, such as the sum function, product if some, if count, Etc.', 'start': 2643.792, 'duration': 6.366}, {'end': 2656.163, 'text': 'So now moving on towards the last question of the session, and that is how do you use wildcards with?', 'start': 2651.098, 'duration': 5.065}, {'end': 2663.229, 'text': "we look up wildcards can be used when you're not sure of the exact lookup value in order to use wildcards in Excel.", 'start': 2656.163, 'duration': 7.066}, {'end': 2664.931, 'text': 'You should make use of the star symbol.', 'start': 2663.429, 'duration': 1.502}], 'summary': 'Excel has numerous built-in functions, including sum, product, and count. wildcards in excel can be used with the star symbol.', 'duration': 26.304, 'max_score': 2638.627, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/8rh2RpAjenQ/pics/8rh2RpAjenQ2638627.jpg'}], 'start': 2102.891, 'title': 'Excel functions and what-if analysis', 'summary': 'Covers excel functions, including future value calculation, vlookup, and h lookup, and explains what-if analysis with scenarios, goal seek, and data tables, emphasizing built-in functions like sum, if, and count.', 'chapters': [{'end': 2556.632, 'start': 2102.891, 'title': 'Excel functions and formulas', 'summary': 'Covers the future value calculation for an investment, finding averages using the average function, understanding vlookup in excel, performing horizontal lookup using the h lookup function, fetching the current date using the today function, and using the and function to check conditions in excel.', 'duration': 453.741, 'highlights': ['The future value for an investment of $500 at the rate of 10% for 5 years and 12 compounding periods is 822.65 dollars. Demonstrates the future value calculation for an investment with quantifiable data.', 'The vlookup function in Excel is used to look up and retrieve data from a given range, and it can be used for both exact and approximate matches. Explains the vlookup function and its usage, including the types of matches it can perform.', 'The today function in Excel returns the current date in MS Excel date format. Describes the usage of the today function to fetch the current date with quantifiable data.', 'The and function in Excel is used to check whether a given condition or a set of conditions are true or not, and it returns a Boolean true if the conditions are satisfied. Explains the usage of the and function to check conditions with a clear example.', 'The hlookup function in Excel is similar to the vlookup function but is used for horizontal lookup, taking a lookup value, table array, row index number, and range lookup value as parameters. Describes the hlookup function and its parameters for performing horizontal lookup.']}, {'end': 2744.564, 'start': 2557.533, 'title': 'Excel what-if analysis and functions', 'summary': 'Explains what-if analysis in excel, including scenarios, goal seek, and data tables, as well as customization of quick access toolbar and usage of wildcards in vlookup, with an emphasis on built-in functions like sum, if, and count.', 'duration': 187.031, 'highlights': ['Excel provides three types of what-if analysis tools: scenarios, goal seek, and data tables. Excel provides three types of what-if analysis tools, including scenarios, goal seek, and data tables.', 'Data tables can accept many distinct values for each variable, while scenarios can work with many variables but are limited to a maximum of 32 input values. Data tables can accept many distinct values for each variable, while scenarios can work with many variables but are limited to a maximum of 32 input values.', 'Customizing the quick access toolbar allows users to create shortcuts for frequently used formulas. Users can create shortcuts for frequently used formulas by customizing the quick access toolbar.', 'Functions in Excel, such as SUM, IF, and COUNT, are built-in pieces of code used to perform specific actions. Functions in Excel, such as SUM, IF, and COUNT, are built-in pieces of code used to perform specific actions.', 'Wildcards, like the star symbol, can be used in VLOOKUP when the exact lookup value is unknown, ensuring flexibility in searches. Wildcards, like the star symbol, can be used in VLOOKUP when the exact lookup value is unknown, ensuring flexibility in searches.']}], 'duration': 641.673, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/8rh2RpAjenQ/pics/8rh2RpAjenQ2102891.jpg', 'highlights': ['The future value for an investment of $500 at the rate of 10% for 5 years and 12 compounding periods is 822.65 dollars. Demonstrates the future value calculation for an investment with quantifiable data.', 'The vlookup function in Excel is used to look up and retrieve data from a given range, and it can be used for both exact and approximate matches. Explains the vlookup function and its usage, including the types of matches it can perform.', 'The hlookup function in Excel is similar to the vlookup function but is used for horizontal lookup, taking a lookup value, table array, row index number, and range lookup value as parameters. Describes the hlookup function and its parameters for performing horizontal lookup.', 'Excel provides three types of what-if analysis tools: scenarios, goal seek, and data tables. Excel provides three types of what-if analysis tools, including scenarios, goal seek, and data tables.', 'Data tables can accept many distinct values for each variable, while scenarios can work with many variables but are limited to a maximum of 32 input values. Data tables can accept many distinct values for each variable, while scenarios can work with many variables but are limited to a maximum of 32 input values.', 'Functions in Excel, such as SUM, IF, and COUNT, are built-in pieces of code used to perform specific actions. Functions in Excel, such as SUM, IF, and COUNT, are built-in pieces of code used to perform specific actions.']}], 'highlights': ['Prepare for 50 important Excel interview questions and answers, covering general, pi-related, and formula & function-related questions.', 'MS Excel was developed by Microsoft and is available on various operating systems such as Windows, Mac OS, iOS, and Android.', 'MS Excel provides important features such as graphing tools, built-in functions, data analysis through tables and charts, and visual basic for application.', 'The total number of rows in Excel is 1,048,576 and the total number of columns is 16,384.', 'A single workbook may have more than one worksheet, and the sheets can be renamed by double-clicking on them.', 'New cells can be inserted by right-clicking on the selected cell and choosing the insert option, allowing for shifting cells or inserting above specific lines.', "MS Excel cells can be formatted using commands in the Home tab's font group, offering options for number format, alignment, font, border, cell fill, and protection.", 'Users can add new rows and columns to an Excel sheet by selecting a column or row, right-clicking, and choosing the insert option, allowing for easy customization and expansion of the sheet.', "Excel allows you to apply the same format to all the sheets of a workbook by right-clicking on any sheet and selecting the 'select all sheets' option, enabling efficient formatting across multiple sheets.", 'Macros in Excel enable the automation of repetitive tasks by recording them as actions or a set of actions, offering increased efficiency and time-saving benefits.', "Protecting cells and sheets in Excel can be achieved by selecting the cells to protect, navigating to the 'font' group, choosing 'protection', and then setting the desired protection options such as 'hidden', providing enhanced security for important data.", 'Understanding relative cell addresses in Excel involves recognizing that when copying formulas, the reference cell addresses automatically adjust to match the new position, offering a dynamic way to work with data across different cells and ranges.', "Comments in Excel are visible to all users with access to the sheet, enabling interaction and collaboration, and users can customize the ribbon interface by right-clicking and choosing the 'customize the ribbon' option.", 'Creating macros in Excel automates the calculation of sales profits and loss, improving efficiency for future use.', 'Drop-down lists in Excel enable efficient data entry and validation, leading to streamlined data analysis and management.', 'Pivot tables condense extensive data and allow the display of exact data for analysis, such as sales averages and sums, in a simple and intelligent manner.', 'Excel functions are categorized based on dates and time, financial functions, mathematics and trigonometry, statistical functions, look up and reference functions, database text, logical information, engineering functions, cube functions, compatibility, and web functions.', 'Formulas in Excel are executed according to the BODMAS rule, where brackets are executed first, followed by multiplication, division, addition, and subtraction.', 'Practical demonstration of the sum and sumif functions showcases their ability to calculate the sum of values and the sum of values complying with a given condition, such as sum of values less than 15.', 'Excel offers count, count a, count if, count blank, and count if s functions for various counting purposes.', 'The FV function in Excel is used to calculate compound interest, returning the future value of an investment based on periodic, constant investment rates and payments, as shown in the example with a 500 investment at 10% rate for 5 years with 12 compounding periods.', 'The count if s function allows specifying multiple conditions to count data meeting specific criteria within a range.', 'To calculate percentages in Excel, the example demonstrates dividing the part by the whole and then converting the result to a percentage, such as Yvonne scoring 96% and Sergio scoring 78%.', 'The future value for an investment of $500 at the rate of 10% for 5 years and 12 compounding periods is 822.65 dollars. Demonstrates the future value calculation for an investment with quantifiable data.', 'The vlookup function in Excel is used to look up and retrieve data from a given range, and it can be used for both exact and approximate matches. Explains the vlookup function and its usage, including the types of matches it can perform.', 'The hlookup function in Excel is similar to the vlookup function but is used for horizontal lookup, taking a lookup value, table array, row index number, and range lookup value as parameters. Describes the hlookup function and its parameters for performing horizontal lookup.', 'Excel provides three types of what-if analysis tools: scenarios, goal seek, and data tables. Excel provides three types of what-if analysis tools, including scenarios, goal seek, and data tables.', 'Data tables can accept many distinct values for each variable, while scenarios can work with many variables but are limited to a maximum of 32 input values. Data tables can accept many distinct values for each variable, while scenarios can work with many variables but are limited to a maximum of 32 input values.', 'Functions in Excel, such as SUM, IF, and COUNT, are built-in pieces of code used to perform specific actions. Functions in Excel, such as SUM, IF, and COUNT, are built-in pieces of code used to perform specific actions.']}