Browsing Archive December, 2013
Dec 19, 2023
Looking for ways for automated data cleaning in Excel? Then, this is the right place for you. Sometimes, the data we get is not clean and ready for ...
Dec 19, 2023
While working in Microsoft Excel sometimes we need to extract filename from a given path to work more effectively. This might seem difficult as the ...
Dec 18, 2023
Sometimes you may need to randomize the rows in a column. Say you are a teacher of a school, and you have some naughty students who try to copy the ...
Dec 18, 2023
While working with Excel, users have to deal with various Excel functions for their working purposes. These functions are mainly used for analysis or ...
Dec 24, 2023
Flash Fill is one of the most important features in Excel. The beauty of Flash Fill is that separation happens within a flash and does not need any ...
Dec 21, 2023
Say you have a column with duplicate values. Now, you just want to find out which values are duplicate and how many times they are duplicated. In ...
Dec 20, 2023
Looking for ways to find and highlight duplicates in Excel? Do not worry, we are here for you. In this article, we will describe 3 easy ways to do ...
Jan 4, 2024
One very common use of Excel is: that it is used as a tool to clean up data. Cleaning up data means:
Getting raw data into a worksheet
...
Dec 21, 2023
Importing text files into Excel can be a powerful way to bring data from external sources into your Excel workbooks. This can include data from ...
Dec 21, 2023
Importing data means bringing the data from any external source (text file, another workbook, database, etc.) into your Excel workbook.
In this ...
Dec 18, 2023
This tutorial will demonstrate how to use the contextual tab in Excel. In case of insert any charts, tables, or shapes, then you will notice that you ...
Dec 21, 2023
Task Pane is a useful tool using which you can tweak different settings quite easily. If you are curious to know different Task Pane and their ...
Jan 22, 2024
The Excel ribbon consists of various tabs, each designed for specific functions and tasks. However, Sometimes, there isn’t enough space to show all ...
Dec 18, 2023
If we try to select a Ribbon command in Excel, a floating box will appear containing small descriptions about the command. Observe the Ribbon ...
Feb 7, 2023
This article will illustrate how to use reference worksheets in MS Excel. In Excel, data are stored in cells in various worksheets. Each worksheet ...