As indicated by its name, “Startup Folder” is a hidden Windows system folder; containing references or shortcuts to apps, desktop programs, scripts and files that have been allowed to automatically […]
How to Freeze Rows and Columns in Excel
If you are usually working with large worksheets, it is really important that you become familiar with the steps to Freeze Rows and Columns in Microsoft Excel. For example, if […]
Fix: Formula Not Working in Microsoft Excel
When you insert a Formula in a spreadsheet, Microsoft Excel should automatically execute the formula and display the result in the selected cell. However, it is also not uncommon to […]
Fix: Empty Cells and Error Values in Pivot Table
When you make use of Formulas or calculations in an Excel Pivot Table, the Pivot Table is likely to come out with some Empty Cells and Cells with #DIV/0! Error […]
How to Hide and Unhide Values in Pivot Table
When you create a Pivot Table, it comes up with values for all the items that are available in the source data sheet. Hence, an important part of formatting a […]
How to Change Pivot Table Data Source and Range
It is quite common in most workplace situations to find additional or revised data being received or suggested for inclusion in a Pivot Table. In such cases you can incorporate […]
How to Insert Checkbox in Microsoft Excel
As you must have seen on online forms, a checkbox, selection box or tick box (British English); is a little square box that provides an interactive way to make choices […]
How to Use COUNTIF Function in Excel
The COUNTIF Function in Microsoft Excel can be used to Count cells matching a particular criteria or condition. It can be used to Count cells containing Numbers, Dates and Text […]
How to Use Concatenate Function in Excel
The “Concatenate” Function in Microsoft Excel can be used to join or combine contents of two or more cells into a single cell. For example, if you have a worksheet […]
How to Add Prefix or Suffix in Excel
If you are dealing with a large spreadsheet, the act of manually adding a Suffix or Prefix to each and every cell of an Excel spreadsheet can take a very […]
Fix: Application was unable to start correctly (0xc0000005)
While “Application Was Unable to Start Correctly (0xc0000005)” error is known to occur while trying to open an app or desktop program, it can also occur while trying to open […]
How to Make One Page Landscape in Word Document
The default setting in Microsoft Word is to open documents in Portrait mode, which suites most users most of the times. However, is it possible to make One Page Landscape […]