Office Archives | Your All Questions Answered
CVS file

How to convert a CVS file to Excel spreadsheet file

The CVS is a simple format. The tabular data is stored in CVS format. It is the delimited text file that uses a comma to separate values. Each line of…

Read more »
Microsoft Excel

View Two Sheets Side-by-Side in the Same Workbook in Excel

Sometimes, we need to flip back and forth between two worksheets in order to compare numbers, copy and paste entries, or create formulas. In these instances, it much easier to…

Read more »
Create Table

How You Can Create Table to Organize Data in Excel

Adding data to a spreadsheet in  Microsoft Excel gives you the ability to sort data, edit it, and perform a number of different mathematical operations and functions on it. Creating…

Read more »
Excel

How to Convert the Dates and Times unit in the Excel

Dates and times are two of the most common data types people work within Excel. Excel uses the serial number to represent the data instead of a proper month, day,…

Read more »
Excel

How to add the Slicer in Table of the Excel Spreadsheet

Excel gives us many features to make our tasks easy and reliable. That’s why Excel has given us the Slicker option. The slicer is nothing but the visual filter buttons…

Read more »
Excel

How to Manually Refresh the Pivot Table in MS Excel

Once you have created the Pivot Table, it does not automatically refresh when you add new data or change the existing data. Since your Pivot Table is created using the…

Read more »
Excel

How to Link first worksheet to other worksheet in Excel

MS Excel provides the ability for cells in one worksheet to be linked with another worksheet. But we can create a link between two worksheets or workbooks to automatically updated…

Read more »
Excel

How to Split Data into Different Columns using Flash Fill

Flash Fill is one of the amazing features provided by Excel. It grabs a task that would take hours to be performed manually and executes it automatically in a flash….

Read more »