Category Archives: Basics

Basics

How to apply, create and share styles in Excel 2010

October 19, 2012 – 1:25 pm

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 »

Tags , , , , , | Permalink | Comments Off on How to apply, create and share styles in Excel 2010
Basics

How to coordinate a look using themes in Excel 2010

October 19, 2012 – 1:25 pm

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 »

Tags , , , , | Permalink | Comments Off on How to coordinate a look using themes in Excel 2010
Basics

How to Insert SmartArt in Excel 2010

October 19, 2012 – 1:25 pm

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 »

Tags , , , | Permalink | Comments Off on How to Insert SmartArt in Excel 2010
Basics

How to Add pictures and shapes in Excel 2010

October 19, 2012 – 1:25 pm

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 »

Tags , , , | Permalink | Comments Off on How to Add pictures and shapes in Excel 2010
Basics

How to use custom conditional formatting in Excel 2010

October 19, 2012 – 1:25 pm

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 »

Tags , , , , | Permalink | Comments Off on How to use custom conditional formatting in Excel 2010
Basics

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

October 19, 2012 – 1:25 pm

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 »

Tags , , , , , | Permalink | Comments Off on How to apply fonts, background colors, and borders in Excel 2010
Basics

How to adjust columns, rows and text in Excel 2010

October 19, 2012 – 1:25 pm

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 »

Tags , , , , | Permalink | Comments Off on How to adjust columns, rows and text in Excel 2010
Basics

How to Format numbers and dates in Excel 2010

October 19, 2012 – 1:25 pm

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 »

Tags , , , , | Permalink | Comments Off on How to Format numbers and dates in Excel 2010
Basics

How to use the different font and color options in Microsoft PowerPoint

October 3, 2012 – 3:22 pm

Microsoft PowerPoint allows its users to gain potential outcomes out of their presentations in a beneficial manner. It makes the process of deliberation easy to understand and convey. With the help of Microsoft PowerPoint design slides, you can have an outlined text and image appearance to simply insert the content and not worry about starting anything from scratch.
Selecting a theme for such slides in Microsoft PowerPoint allows you to connect the design of your complete presentation. For that it is essential to know how to use the different font and color options in this software. Already stylized slide options can also be chosen from different PowerPoint templates present in it.
To understand more about this follow the tutorial below.


read more »

Tags , , , | Permalink | Comments Off on How to use the different font and color options in Microsoft PowerPoint
Basics PC

How to set the tabs in Microsoft Word 2010

October 3, 2012 – 3:08 pm

In this tutorial, you will learn to set the Microsoft word tabs. While typing, it becomes difficult to set the position of the text with the same spacing in between words in an orderly fashion. Setting tabs in Word saves you from the trouble of hitting the Tab key again and again. You just have to press the “TAB” key to move your cursor forward to the next tab position and align your text accordingly.


read more »

Tags , , , | Permalink | Comments Off on How to set the tabs in Microsoft Word 2010

« Previous Page — Next Page »

« Previous Page — Next Page »