Excel provides its user with excellent sorting options. You can filter your data in Excel as per your requirements. Sorting in Excel allows you to re-arrange data as per your needs. In the tutorial, we will show you how to filter data according to multiple criteria.
In this tutorial, we will teach you basic and multi-field sorting in Excel.
Sorting data at times can be a huge problem when you have so many rows and columns and so much of data in them. Excel allows you to sort data the way you want. You will have a lot of choices as to how you want to sort it. For example you can classify your data according to the departments. Sorting data in Excel can be done easily by inserting a table. Even more you can delete duplicate entries in Excel after you add them in a table.
Follow this step by step tutorial to learn how to use tables in Excel to sort and filter data.
Excel spreadsheets help users with their calculations and computations. The subtotal feature in Excel allows you to find totals department wise. In this manner, you can compare the individual figures with the grand totals and see each department’s contribution to the grand total. You can make subtotals either using the sum function or working with the average function.
In this tutorial, we will show you how to insert automatic subtotals in Excel.
Vlookup in Excel is considered kind of tricky by most users. We will teach you how to apply vlookup. In the formula, you have to provide the cell where the results would be displayed, the data range, the column you are referencing it to and whether the condition is true or false. It is a logical function and helps people in real life situations when they are trying to maintain a car database or parts database.
In this tutorial, we will show you how to create a lookup table in Excel.
In this tutorial, we will teach you how to explore the analysis toolpak in Excel. First of all, we will show you how to enable Analysis toolpak. Once the toolpak has been enabled, we will show you how to work with it. Under data analysis, you will find several options. We will show you how to work with two of them in this video; correlation and moving average. We will show you how to apply both of the functions.
For the purpose of this tutorial, we will be working with a pivot table. We will apply multiple filters to it in order to filter the data. Furthermore, we will teach you how to apply the slicer option in Excel. Slicer is a quick way to find out the relevant data if you are using one filter at a time. And lastly, we will teach you how to modify a PivotTable in Excel.
In this tutorial, we will teach you how to insert Spark lines in Excel. Sparklines in Excel help you express your data graphically. There are several types of sparklines such as lines, columns or win/loss. In lines, you can view the ups and downs, the peaks and slumps while in win/loss the negative points will be shown in a different color. We will also show you how to change the styles on these sparklines.
Excel sheets usually contains a lot of data and in order to go through all that data it takes time. Hence, you can create graphs in Excel. Graphical representation of the data can help the viewer save time. Also from it people can easily understand the results of something just by having a glance. Comparisons can be made between different months or products. Over here the numbers are replaced by column bars or lines so that the viewer can see which the longest bar is. Detail is written at the corner of the chart for understanding what does the vertical or the horizontal axis mean.
Follow this step by step tutorial to learn how to create a column chart in Excel fairly easily.
A pie chart, also known as a circle graph, is used to show percentages. A whole circle represents 100% and then it is divided into slices which represent portion of the total. Using a pie chart in Excel helps the person to know the data just by having a glance at it. The biggest piece can easily be noticed. You can even use other things like labels and percentages that can be written on the diagram.
Follow this step by step tutorial to learn how to create and modify a pie chart in Microsoft Excel easily.
In this tutorial, we will teach you how to place excel charts into other office applications. Charts in Excel are a great way to represent data in graphical form. They are easier to understand for the viewer. Many a times you might want to move the Excel chart in your Word document. In this tutorial, we will better help you understand how to copy paste excel charts in Microsoft Word or other Microsoft applications. Furthermore, we will also teach you how to move excel charts to other sheets in Excel.
Home