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.
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 show you how to edit a macro in Excel. We will work with a macro we have already made. We will make some changes to it in order to guide you how to edit your macro for yourself.
There are several functions in Excel with help you in various ways. These functions are not all related to calculations. Calculating end of month dates in Excel is done by using the edate fuction. This edate function calculates end of month dates in Excel from the specific month you input. For example if one needs to find out what will be the date five months from now, this function is used.
In this tutorial, we will teach you how to calculate end of months and future or past dates in Excel.
In this tutorial, we will teach you how to calculate date difference by year, month or day in Excel. In this step by step guide, we will teach you two date functions. The first one calculates the time elapsed and the second one allows you to find a specific day of the week. Such functions are very useful when calculating date differences.
In this tutorial, we will show you how to use time with currency calculations in Excel. There are several times when you have time and currency calculations. For example, we have the number of hours that a person has worked and the hourly wage rate. We have to calculate the total wage. Both the things have different units thus cannot be computed by doing simple multiplication. We will show you how to perform in such calculations.
Home