Microsoft Excel 2010 Developer Tab

Microsoft Excel is one of the most powerful applications within the Office suite. It also lets you add some programmatic power to it, you can use your programming skills to automate tasks in Excel. Two examples of this scenario are VBA and Macros. Microsoft Office 2007 and 2010 include the ‘Developer’ tab which lets you add code chunks to your Excel sheet, also it is a great way to access various Options.

Read More

Microsoft Office Word 2010 Shortcut Keys [Tips]

In this post we have quickly compiled some useful Word 2010 hotkeys. For those who don't know, we are covering tips on Microsoft Office 2010 for a  few months now, and have covered quite some tips on Word 2010 as well. In order to work faster and improve your productivity, here is a short list of shortcuts available in Word 2010. Read More

Office Word 2010 Format/Formatting

Microsoft Word 2010 is one of the powerful word-processing application to date. The most important aspect of your document is that it should be well formatted so that readers can understand your point easily. Lets discuss some of the most common formatting tips that help us to create attractive looking documents. Read More

Excel 2010: Remove/Delete Duplicate Rows

Microsoft has made it quicker to remove duplicate rows in Excel 2010, all it takes now is two simple steps. The best part is that you don’t need to select any specific row before removing the duplicate rows, the build-in Remove Duplicate feature takes care of it. Read More

Microsoft Word 2010 Spacing

Spacing is very important while creating documents as it impacts the outlook  and presentation of the document. You can easily increase or decrease the spacing between paragraphs, lines, and even words in Microsoft Word 2010. Read More

Microsoft Excel 2010 Columns

Microsoft Excel is the most prominent and widely used spreadsheet program. One of the basic elements of the spreadsheet application is the column, which contains our data, and a spreadsheet consists of columns. We identify different pieces of data in the spreadsheet as columns. Read More

Office Excel 2010 Charts And Graphs

Charts and graphs are a great way of representing your data. Microsoft Excel 2010 offers almost every chart type and makes it easier to draw them so that your data can quickly understood in a graphical format. In this post you will learn what each chart and graph represents and the additional functionality that you might not have heard about. Read More

Office Excel 2010 Solver Add-In

The Solver is an add-in for Microsoft Excel which is used for the optimization and simulation of business and engineering models. It solves complex linear and non linear problems and can also be used in conjunction with VBA to automate tasks. Read More

VBA In Office Excel 2010

VBA stands for Visual Basic for Application. As you know that VB (Visual Basic) is one of the great programming languages. If you need to do repeated tasks in excel every day, then it is always recommend to automate such tasks so that you can save time and energy. Macros are a great way of automating tasks in Excel, we have already covered a basic tip on recording and using Macros. Macros basically add VB code to your excel sheet. Read More

Ribbon And Tabs In Office 2010

The main interface of Office 2010 is based on Ribbon, which consists of two types of tabs, Main Tabs and Tool tabs, each one of them contain certain options. By default almost all tabs are enabled except the Developer tab. To enable/disable a tab, go to Office Backstage(File menu), and select Options. Read More

Office 2010 Quick Access Toolbar

Quick Access Toolbar was included in Office 2003 and 2007 as well, but plays a bigger role in Office 2010. This post is will teach Home Users the benefit of Quick Access Toolbar and why you should use it and make the most out of it. In short, it is one complete crash course. Read More

Excel 2010 Formulas And Functions

Introduction

Microsoft Office Excel is a very popular application for spreadsheet management. We have covered a detailed post on it's new features here. One of it's strengths lies in Formulas and Functions. They let you perform basic calculations within Excel spreadsheets.

Read More

Microsoft Office Publisher 2010: What’s New?

Microsoft Office Publisher is a well known application by Microsoft which lets you create brochures, postcards, newsletters, websites, e-mails and much more. Millions of people are using it to manage all their marketing activities. We are in the process of reviewing the main products in Microsoft Office 2010, such as,  Word 2010, PowerPoint 2010, Excel 2010, Outlook 2010 and OneNote 2010. Lets see what new additions have been made to Office Publisher 2010. Read More

Fix Outlook 2010 Problem: PST File Repair Tool

Microsoft Office Outlook 2010 is quite stable but not perfect, if your PST file becomes corrupt then you will need a repair tool to fix it. PST stands for Personal Storage Table(also referred as Personal Folder File) and is used to store all your Inbox, and other information. If it becomes corrupt, then your Inbox will also get corrupted. Read More

Cannot Start Outlook 2010? Use Safe Mode

If your Outlook 2010 is crashing due to a culprit add-in, then the only possible way is to start it in safe mode and remove the add-in. Apart from add-ins, there could be hundreds of other reasons why your Outlook is crashing. In all cases you will need to start Outlook 2010 in safe mode. Read More