Fill in your details below or click an icon to log in: You are commenting using your WordPress.com account. With a quick glance, you can learn two things: the data set has a total of seven records, and three of those records match the current filter. Pros of MS Excel include: Following are the major disadvantages of Microsoft Excel: Following are the advantages and disadvantages of MS Excel: As we have already seen, Microsoft Excel is a versatile spreadsheet application that can be used for a variety of purposes. This software has a high price. When you talk about data intelligence or business intelligence, it's usually the actionable output that dominates. On the other hand, Access offers relational tables at multiple levels. As an example, applying the filter to a signal with a period of approximately 1/0.09082 completely eliminates that signal. Thats why it returned five when B5 and B7 were empty and zero after filtering for blanks. Microsoft released the first version of Excel for the Mac OS in 1985, and first Windows version in November 1987. Excel has the ability to organize large amounts of data into orderly spreadsheets and charts quickly, It is easy to enter and format the data, It has the ability to create the graphical or the visual representations of your data and it is easy to integrate Excel with other business applications. However, if you find yourself clicking through layers of date components, you can upgroup date filtering values as follows: Disabling this option forces Excel to display literal dates, as shown in Figure K. Access lets you filter by the selected value; the feature is called Filter By Selection. However, there are a few disadvantages of tables which a lot of answers in this thread are ignoring: You can't share a workbook with a table Tables don't work properly with sheet protection - e.g. You can use Excel to format worksheets, work with multiple sheets, find information in your workbook, and embed pictures. Whether youre a student, business professional, or an amateur spreadsheet maker, Microsoft Excel is the go-to tool for all sorts of data analysis. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.