Category: MS Excel

In statistics, the maximum value in a dataset is the value of the greatest observation of a sample. You can use the MAX function to find the largest value …

There are many different ways to write a date. If you get a list of dates to convert them into another formats, you may first check the "Format cells" …

If you work with Excel 2019 or the version after, you can create a 3D map. Please see the steps below: Step 1: Select the data for the map; …

When working with Excel, it is very common to copy a table to a new location. However, the format of the table often changes in the new location. To …

A checkbox is a small widget that allows users to make binary choices. The checkbox will display as ☑ when you answer "yes" while the checkbox will display as …

In Excel (or Word), you can edit a shape after you insert it to your worksheet, either the regular shapes or the customized shapes. Step 1: Select the shape …

In Excel or any other Microsoft products, you can insert many shapes into a worksheet. However, there are situations that you may need to draw a freeform shape. Please …

In Excel or Word, you can add a happy face by inserting a "happy face" shape, however, there is no sad or neutral face shape to insert to your …

You may get frustrated when you draw a horizontal line in Excel or Word and it is not straight. Actually, Microsoft has a trick for you to draw a …

"Ctrl+T" is the shortcut to display the "Create Table" dialog box, which is the quick way to turn your data range into a table. The shortcut Ctrl+L has the …