The Pivot Table function in Microsoft Excel allows you to summarize, tabulate and analyze data with effortless ease. You can find below the steps to Create Pivot Table in Excel. […]
Office
How to Separate First and Last Names in Excel
A common task given in an Excel class and also in practical work related situations is to separate First and Last Names. You can find below the steps to separate […]
How to Lock Cells In Excel to Protect Them
Sometimes, you may want to Lock all or specific cells in Excel, in order to protect the content in those cells from being modified or erased. You can find below […]
Fix: Microsoft Word Not Responding Error
Most users have experienced the problem of Microsoft Word Not responding, freezing and refusing to work on their computers. When this happens, Microsoft Word fails to open the requested file […]
How to Insert PDF Into Excel
Microsoft Excel allows you to Insert Pictures, Charts, PowerPoint Presentation, PDF and Word Files into an Excel File. You can find below the steps to Insert PDF into Excel. Insert […]
Excel File is Locked For Editing By Another User
If you are unable to open or edit an Excel file due to “File is locked for editing by another user” error, you can find below the steps to fix […]
How to Set Rounding Precision In Excel
The Rounding Precision feature in Excel can be used to fix the issue of rounding or floating point errors in Microsoft Excel. You can find below the steps to set […]
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. You can find below the steps to Merge and Unmerge cells in […]
How to AutoFit Column Width and Row Height in Excel
It is possible to setup Microsoft Excel to automatically adjust its Column widths and Row heights to match the size of data being input. You can find below the steps […]
Fix For Formulas Not Updating Automatically in Excel
At times you may notice the Formulas are not updating automatically in Excel. You can find below the steps to fix the problem of formulas not updating automatically in Microsoft […]