Category Archives: Basics
Basics
December 5, 2012 – 4:09 am
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.
read more »
Basics
December 5, 2012 – 4:09 am
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.
read more »
Basics
December 5, 2012 – 4:09 am
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.
read more »
Basics
December 5, 2012 – 4:09 am
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.
read more »
Basics
December 5, 2012 – 4:09 am
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.
read more »
Basics
December 5, 2012 – 4:09 am
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.
read more »
Basics
December 5, 2012 – 4:09 am
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.
read more »
Basics
December 5, 2012 – 4:09 am
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.
read more »
Basics
December 5, 2012 – 4:09 am
In this tutorial, you will learn about the status bar in Excel and how it is useful to the user. This feature of Ms Office Excel allows you to view different totals like the average, sum, etc by simply selecting the cell whose values you want to figure out.
You can even customize the status bar so that it shows the mathematical values that you need rather than the ones present there by default.
To learn how to customize the status in Excel, follow the tutorial below.
read more »
Basics
December 5, 2012 – 4:09 am
This tutorial will talk about and explain a few keyboard shortcuts in Excel that allow you to work more efficiently in this software.
Knowing different shortcuts in Excel gives you the opportunity to save time by working faster and more accurately while using this program.
To learn more about these shortcuts, follow the tutorial given below.
read more »
Home