Having the Source Data on a single Worksheet makes it easy to Create Pivot Table. However, it is also possible to Create Pivot Table From Multiple Worksheets, if the Source […]
Office
How to Create Pivot Table in Excel
Knowing the steps to create Pivot Table in Microsoft Excel can make you far more productive at work, compared to using TOTAL, SUBTOTAL and other commands to analyze Data. The […]
How to Separate First and Last Names in Excel
In general, the need to separate First and Last Names in Excel arises due the full names of students or employees being entered in a single Excel column. This situation […]
Fix: Microsoft Word Has Stopped Working
Most users have experienced the problem of a Microsoft Word Document not responding, freezing and refusing to work on their computers. When this happens, Microsoft Word fails to open the […]
Fix: Excel File Locked For Editing By Another User
In case of Shared Files, Microsoft Excel is known to come up with “File is Locked for Editing by another User” error message, both when the File is actually being […]
How to Set Rounding Precision In Excel
Microsoft Excel provides the option to Set Rounding Precision, which can be used to fix the issue of rounding or floating point errors in a Microsoft Excel spreadsheet. The reason […]
How to Merge and Unmerge Cells in Excel
The Merge function in Microsoft Excel allows you to combine multiple Excel cells into a combined single cell and the Unmerge Cells function does the opposite. One of the most […]
How to AutoFit Column Width and Row Height in Excel
As you must have noticed, the size of columns and rows in Excel remains fixed when you type any data into the cells. However, it is possible to setup Microsoft […]
How to Remove Double Spaces in Word Document
If you are looking for a way to Remove Double Spaces in Microsoft Word, it is likely that you are either dealing with document with double spaces between paragraphs or […]
How to Print to PDF And Save As PDF in Microsoft Excel
You can convert any Excel File or Spreadsheet to PDF Format using “Save As PDF” or “Print to PDF” features as available in Microsoft Excel. While both “Print to PDF” […]
How to Save/Print to PDF in Microsoft Word
Microsoft Word provides built-in support for PDF (Printable Document Format), which makes it really easy to Save and Print Word documents to PDF Format. While you can use both “Print […]
How to Use Gmail With Microsoft Outlook
In case you are interested, it is really easy to access all the Emails in your Gmail Account from within Microsoft Outlook and configure Outlook to use Gmail as your […]