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.
Many people don’t know how to create a PivotTable in Excel. They consider it too complicated. In the preparation of the Pivot table, you have to select the data range the Pivot Table is going to use. Next you choose the fields that you want to use in the Pivot Table. Then you assign these fields roles; place some in rows while others in column headings. In this tutorial, we will teach you how to create a basic Pivot Table in Excel.
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.
Macros are scripts that you record; certain actions you may perform in a specific sequence. You might have to perform a set of actions in a particular order on a day to day basis. Instead of doing it manually, do it just once when recording the macro. Next time you want to perform those set of actions, simply run the macro.
In this tutorial, we will teach you how to record and use a simple macro in Excel.
Home