In our last chapter we have learnt the Adavantages of the Pivot charts/tables over the regular charts in Excel spreadsheets. Creating Pivot Charts Creating a Pivot Charts is as simple as we used to generate regular charts in excel. For this, we have to first collect the data in tabular format in an excel sheetRead More
Excel
Computer Basics -12 || Advantages of PivotCharts over Simple Charts in Excel.
PivotCharts are the basically extended version of the simple charts like Column, Line or Pie Charts. PivotCharts provides a customized functionality to handle normal charts. In my previous blog, I had described how to implement, a different type of charts in Microsoft Excel. So, I would recommend before moving ahead just have a look atRead More
Computer Basics -11 || Using Charts in place of Data Tables in Excel.
Charts are the graphical representation of the data. Using Charts in place of Data Tables are more realistic than tables or any other mode of presenting data. This is a very attractive feature of Excel, which is used by each professional to create their presentations, reports, data collection, etc. Note: A table should have atRead More
Computer Basics -10 || How to apply Filter in a data set in Excel?
Simple meaning of Filter is to get only relevant information from the heap of data. Data and Information Before moving ahead I just wanted to make you understand the difference between Data and Information. Data is a collection of lots of content in the form of Numbers, characters, images etc. On the other hand, identifyingRead More
Computer Basics -9 || Understand and Implement Data Validation in Excel.
Data Validation is the feature to restrict the end user to enter incorrect or invalid data in a particular cell or report. Data Validation Data Validation can be used for a range, specific list of values, formula-based condition etc. based on the requirement. There are multiple scenarios where we need to restrict the user, fewRead More
Computer Basics -8 || Let’s learn the usage of MS-Excel.
Excel is mainly used to do accounts related work and to maintain huge record like we do in databases. When we open the Excel application and create a new file it looks like the Math Copy, we have used in our school during the study. These files contain grids to store data and records. ExcelRead More