Knowing how to work with date and time in excel can come in handy when you need to enter time stamps somewhere or you want to add a date to a specific entry. One should know how to enter time and date in Excel and how to do their formatting.
Follow this step by step tutorial to learn how to work with times and dates in Microsoft Excel.
Handling data in excel can be difficult sometimes. There is always a room for errors and these errors come in different ways. In this tutorial, we will have a look as to what absolute reference is and how can we use it to prevent errors. When you are doing some calculations, you give cell references and when you use the auto fill feature, Excel guesses the pattern and tries to use the same formula or in the same way the previous value was calculated. However, this may sometimes give reference errors.
Follow this step by step tutorial to learn how to prevent errors using absolute references in Ms Excel.
MS office 2010 has a wide range of features including Mail Merge functionality. This lets user create documents (i.e. Letter, Emails, and Fax etc.) that consist of unique elements i.e. Contact Details, Name, etc.
It allows you to create one document for multiple recipients as well. Document includes the personal detail of recipients, which saves a lot of time.
In this tutorial you will how to create a Mail Merge in Microsoft Word 2010.
You might often think of making your document look more attractive and interesting using various methods. MS Word 2010, in this case has the best solution for you. It provides you with a variety of pictures, clip arts, shapes etc. that you can add to your document to give it a more complete look. But at times, you might want to use a particular style of art in order to differentiate your document from that of others. This Office 2010 tutorial guides you on how to use “Smart Art” in your document, and give it just that perfect touch that will make it the favorite amongst many others for those who go through it.
In this tutorial we will be focusing on how to work with Smart Art in Microsoft Word 2010.
Along With the numerous great features MS Word 2010 provides you with it also allow you to insert pictures, clip arts and shapes in a document. This Office 2010 tutorial will solve the various problems you might be facing with trying to insert shapes and will give you a brief overview of how you can do so, along with teaching you how to apply different borders, effects and styles to them.
In this tutorial we will be focusing on how to work with Shapes in Microsoft Word 2010
You must have read newspapers and noticed that the news in newspaper is always arranged in separate columns. You start reading the first column and which ends at the bottom of the page, and all over again you move to the top of the second column in order to read the complete article. MS word 2010 provides a number of interesting features to people working on documents, along with letting them work with newspaper columns.
This office 2010 tutorial will guide you briefly on how to use newspaper columns in a word document, by providing to you a step by step procedure that can be used to do so.
In this tutorial you will learn how to work with Newspaper Columns in Microsoft Word 2010
Using PowerPoint can be really helpful when making a presentation that expresses the data in the form of graphical representations. There are many shapes for PowerPoint that you can work with. You can place them at any position in the content box of the slide, move them around by dragging them using the mouse, rotate and even format them according to the content and the theme. These shapes are a good way to organize and express data on your presentations.
In this tutorial, we will show you how to move, rotate, resize and format shapes in PowerPoint.
Mostly we wish to type out text once and use it over and over again at different points in time in order to save time. Microsoft Word 2010 offers you a feature for exactly this purpose known as “Building Blocks”. Building blocks are created with graphics or any text and can be used over and over again in various documents. In this 2010 tutorial you will learn how to create use a brilliant feature of MS word, known as Building Blocks.
In this tutorial you will specifically learn the way How to create and use new building blocks.
Adding shapes and text boxes to your presentation makes your presentation appear more compelling and attractive. The more shapes in PowerPoint you are going to utilize with consistency and good formatting, the better it is going to be. In this PowerPoint Tutorial, we will show you how to work with different shapes and insert relevant text into them.
In this tutorial, you will learn how to add text to shapes in PowerPoint.
A page color and a background are often seen to give an attractive and eye-catching look to a page. While using MS office 2010 one is likely to find it quite easy to apply various backgrounds to a page in their document.
In this tutorial you will learn how different colors and background on Microsoft word can be used in order to make a document look more appealing to viewers.
Home