Tag Archives: 2010

Basics

How to Freeze panes and Split cell data into multiple cells in Excel 2010

Microsoft Excel allows it users to freeze panes while working on a large Excel workbook so that when one scrolls downwards or goes in any other direction, the data does not move around. Freeze panes in order to make the headings for each columns stay visible even if you scroll down. Data from one cell can also be split into multiple cells in order to divide off the data and make it appear organized categorically.
In this tutorial, we will show you how to freeze panes and split cell data into multiple cells in excel.


read more »

Basics

How to Find and replace data in Excel 2010

Many a times while working with a worksheet in excel, you might have huge amounts of data placed in your excel spreadsheet. It might thus be necessary at different points to replace various numbers or names etc in the given rows and columns. To make things easier, MS Excel provides you with the option of finding and replacing data in workbooks and spreadsheets to make editing information easier.
Follow this step by step tutorial to learn How to find & replace in excel.


read more »

Basics

How to insert headers and footers in Excel 2010

Microsoft Excel is a great program when it comes to organizing data into rows and columns in a spreadsheet and performing mathematical calculations. One can also add headers and footers in their spreadsheet in order to mention their company logo, email address or other similar information.
In this tutorial, we will teach you how to insert headers and footers in Excel.


read more »

Basics

How to Use templates in Excel 2010

MS Excel provides its users with the option of using templates for excel which are various worksheets available for different uses. Working with templates, not only saves time but also gives a complete and professional look to the worksheet. Since they are preinstalled, putting them into application is not difficult and one can even download more templates if need be. These templates can be customized as per your requirements, which make them even more useful.
Follow this step by step tutorial to learn how to use excel templates.


read more »

Basics

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 »

Basics

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 »

Basics

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 »

Basics

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 »

Basics

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 »

Basics

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 »