Categories：Excel Tips
-
How to Extract the Root of a Number in Excel 2016
While processing data in Excel, sometimes we may need to extract the roots of numbers. At this point, you can insert a function to do the operation. For example, I want to extract the cube root of 3375. Type the number in A1 and input the formula “=3375^(1/3)” in half-angle. Then press [Enter] key or […]
-
How to Add Watermark to Excel
It’s true that Word has a feature of inserting watermark directly while Excel does not. But with the similar reason (claim the ownership, protect the information from being tampered, etc.), we may also want to add watermarks to Excel files. How can we do it? Open the file you want to add a watermark. Click […]
-
How to Insert a Random Number in Excel
Random numbers are quite useful in many situations of life and work. And it’s very simple to generate them with Excel function. Here’s the method. 1. Open the Excel file, click a cell and type the formula in it. If you want to generate a number in the range of 1-100, then input “=RANDBETWEEN(1,100)” . […]
-
How to Insert Excel Files to PPT
While making presentations at work, a detailed PPT with a series of relevant Excel data can be very persuasive. Therefore, I’d like to share the experience of inserting Excel file into a PPT.. Open the PPT and turn to the page you want to insert an Excel file. Then switch to Insert tab. Click Object […]
-
How to Speed Up the Boot Time of Excel
When you open an Excel file on your computer and find the startup speed is rather slow, it’s may not due to the size of the file, but the quantity of add-ins. To improve the boot speed of Excel, you can try disabling some add-ins. Let’s see how to achieve it. Choose Options in File […]
-
How to Batch Convert Number to Date Format in Excel
While working with Excel, if there are a large number of dates to enter, you can enter the numbers without the format at first for convenience, then batch convert them to the format of date. So how can we achieve it? Here’s a simple guide. 1. First, enter the numbers and select all of them. […]
-
How to Change the Background of the Chart Area in Excel
If you’ve inserted a chart in the Excel file, you can change the chart style to make it fit your taste. But do you know how to change the background of the chart? The method is also simple. First, open the file, right-click the chart you want to adjust. Please note that if the place […]
-
How to Restore the Default Setting of Excel
We may make some changes to the setting of Excel in the process of editing files like adding ribbons and quick access toolbars. But if we don’t want those changes after opening a new file, how can we restore the default setting of Excel? First, switch to File tab in the new file. Click Options […]
-
How to Import Data from HTML into Excel
If you have some brilliant tables on your computer but not in Excel format, can you import the data from them to Excel directly? In one of my previous post I’ve introduced how to convert TXT to Excel. Here I’d like to share the tip of importing the data from HTML to Excel as well. […]
-
How to Copy a Sheet to Another Excel File
It’s convenient to copy and paste a table in the same sheet or even workbook. But copying & pasting a sheet between two or more files might cause some problems. I’d like to share a method here to copy worksheets across Excel files. Open the two files you want to copy and paste the sheet. […]
