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.
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.
Microsoft Office Excel is a spreadsheet application which is used for commercial purposes. Through Excel you can do calculations, use graphs, insert pivot tables etc. One should know how to work in Excel because it makes your life easy when it comes to handling data.
Follow this step by step tutorial to learn how to create a worksheet in Excel along with learning how to copy paste in it.
Layers are a very important part of graphics work. Photoshop layers are like sheets of stacked acetate. You can see through transparent areas of a layer to the layers below. You move a layer to position the content on the layer, like sliding a sheet of acetate in a stack. You can also change the opacity of a layer to make the content partially transparent. Layers are used to perform tasks such as compositing multiple images, adding text to an image, or adding vector graphic shapes. You can apply a layer style to add a special effect such as drop shadow or glow.
You can create layers in Photoshop document in three different ways. In this tutorial, we will teach you how to create a new layer in Adobe Photoshop.
Starburst background is one of the popular effects which can be seen hundreds of times in many posters, press ads, flyers and brochures. In this Photoshop tutorial, we’re going to learn how to create a classic “starburst” background. Creating starburst in Photoshop is easy. There are many way in which you can create this effect. This tutorial covers one easy method to do it. You can use this background that we will create for many different purposes later on.
Follow this tutorial to learn how to create a starburst background in Photoshop.
You can draw various shapes in After Effects CS6 and work on them. You can use the transformation tool to expand them according to your needs. Also, you can adjust the mask settings to highlight the intersection portion of overlapping shapes. Apart from all this, Adobe After Effects gives you the option of pen tool which allows you to do free hand drawing.
In this tutorial, we will guide you on how to create a shape in Adobe after effects CS6.
At the end of the program, you normally see end credits. In this tutorial, we will teach you how to create your very own end credits. Furthermore, we will also teach you how to animate text along the X-Axis. Normally, you see tickers running horizontally on your TV screens on news channels. We will teach you how to make your text run horizontally.
In this tutorial, we will teach you how to animate end credits and crawling titles in Adobe After Effects CS6.
Adobe Photoshop is used for a lot purposes other than photo editing as well. Typography is basically the style and arrangement of text. It is considered as the most powerful way of communication because of its intense visual impact. We can use typography and text effects in websites to bring the attention of viewers. Here we are using Photoshop to convert text into an image. You can also go through our other typography tutorials to learn other helpful techniques.
Follow this step by step guide to learn how to create typography in Photoshop.
Home