Author Archives: XZoLMLRU2Pg

How to apply, create and share styles in Excel 2010

Microsoft Excel is a program which specifically allows you to use spreadsheets in order to organize your data and perform complex mathematical calculations. When working with these Excel sheets, one can perform various activities with the cells in order to make them stand out or even apply color to them. Apply styles to your worksheet and give it some final touches. This allows the user to customize the sheet and give it a personalized touch. There are a variety of styles already provided by the program, but one can moreover, even create their own customized styles, as per their requirements.
In this tutorial we will teach you how to apply, create and share styles in Excel.


read more »

How to coordinate a look using themes in Excel 2010

Microsoft Excel is an extremely helpful program when it comes to arranging data in the form of spreadsheets or carrying out mathematical calculations. One can also use themes in excel in order to make it look more attractive; add some color and eye catching features to it. Customizing the sheet gives it a personalized approach.
In this Excel tutorial, we will teach you how to coordinate a look using themes in Excel.


read more »

How to Insert SmartArt in Excel 2010

MS Excel allows its users to use smart art in their excel sheets in order to make them more attractive and eye catching. One can even choose to add colors, shapes and layouts to their Smart Art in order to customize them. Using Smart Art additionally helps one in giving their worksheets an edge over others of their kind.
Follow this step by step tutorial to learn how to insert Smart Art in excel.
Inserting in Excel is not as difficult as it may appear to be.


read more »

How to Add pictures and shapes in Excel 2010

MS Excel provides its users with the option of using a variety of features to make their worksheets stand out, and make them appear more attractive. It allows them to add graphics, pictures and shapes in Excel worksheets. One can also add a number of effects to their pictures, change its shape, or add colors to them.
Follow this step by step tutorial to learn how to use excel add ins while working with Microsoft Excel.


read more »

How to use custom conditional formatting in Excel 2010

In this excel tutorial, we will teach you how to apply conditional formatting in Excel. We will show you how to apply color scale. We will teach you how to insert highlight cells rule where cells get highlighted on a certain custom condition that you place. Furthermore, we will teach you how to make new rules in Excel. After creating these rules, we will show you how to manage them and use them to your advantage.


read more »

How to adjust columns, rows and text in Excel 2010

The Excel spreadsheet can be used to present large amount of data and conduct various calculations. In this tutorial, we will teach you how to adjust column width in Excel. Apart from column width, we will also teach you how to apply line break in Excel. By applying line breaks, you can make long text in one cell appear in multiple lines.
Follow this tutorial to learn how to adjust columns, rows, and text in Excel.


read more »

How to apply fonts, background colors, and borders in Excel 2010

While working with spreadsheets and workbooks in excel Microsoft, one can use a variety of fonts, background colors and borders to give their data a new and different appearance. You can even use the colors and borders for excel to make one cell stand out against the others or color code information.
Follow this step by step tutorial to learn how to apply fonts, background colors and borders in Excel.


read more »

How to Format numbers and dates in Excel 2010

In a excel workbook when you enter numbers, all of them are formatted in a similar manner. You can choose to add different signs to them or even increase and decrease their decimal places etc. The date entries can also be formatted to show different formats in which the date can be displayed.
Follow this step by step tutorial in order to learn how to format dates in Excel along with numbers.


read more »

How to work with the Wind Filter in Photoshop

When working with Photoshop, many people believe the software is a complex and difficult one to understand .However, this opinion is only created because of the lack of knowledge regarding its functions and different Photoshop tools. Working with Photoshop can be a fun filled experience, as not only does it allow you to discover a wide variety of options you could use to create icons and edit images, it also allows you to give your image a brand new look which differentiated it from others of its kind.
While working with this software you can use existing options like filters in Photoshop to add on to image or your illustration to as to enhance its output. In this tutorial, we will teach you how to work with the Wind Filter in Photoshop.


read more »

How to create a mesh typographic image in Photoshop

Adobe Photoshop is an extremely useful tool when one is working with pictures etc. You can use this software to edit pictures, crop people, and perform a number of tasks along with applying cool effects and different Photoshop styles. At first you might find it difficult to deal with Photoshop but once you learn the various techniques of performing tasks with it, you will be thrilled with the number of options its provides you with.
Various tutorials on Photoshop allow you to learn to use these effects easily. In this tutorial we will teach you how to create a mesh typographic image in Photoshop through a simple step by step process.


read more »