Categories：Excel Tips
-
The Perfect Color Matching And Combinations In Excel.
When we use Excel to make bar or pie charts, matching colors really tests our aesthetic skills. If the color is not chosen properly, it will look very messy. So, the author would share with you more than ten sets of color combinations (Of course it’s totally for free). Remember to bookmark this site, so […]
-
How To Use Nested IF Functions In Excel-Simple Tutorial
IF function is perfectly used in our daily work. And the nested IF is just two more IF statements in a formula. When you have multiple conditions to meet, nested IF is powerful. Let’s take a simple example to show you how to use it well. Here’s a transcript of math and chemistry. If the […]
-
How to Add Prefix or Suffix Batches in Microsoft Excel
If you need to add the same prefix and suffix to many cells, would you choose to add them one by one? This will definitely add to your workload. So today I want to share with you guys an easy skill for auto-adding prefixes/Suffix or changing prefixes/Suffix to existing text. Method 1: Highlight the cells […]
-
How To Use Ctrl + E In Microsoft Excel?
There are a lot of really useful shortcut keys in Excel. Ctrl + E is one of the most powerful keyboard shortcuts. This can help us flash fill, split, merge and extract data. Lets’ stop here and see the examples. Merging Data We first copy and paste the name “Marry” and number “001” into cell […]
-
How To Merge Multiple Excel Files Into Only One Sheet
It is common to combine multiple Excel Worksheets into one in our daily work. Many friends may choose to open each table in turn and then copy and paste them together. This only works with a small number of files, but too many files can be a huge waste of time. So today I’m going […]
-
How To Convert Negative Number Into Positive Quickly In Excel
If you need to change all the negative numbers in the Excel sheet into positive, what should you do? In today’s tutorial, we are going to learn two ways to convert negative numbers into positive ones. Method 1 Insert Function Select a blank cell and go to Formulas, Choose Insert Function. Choose ABS in the […]
-
Simple Excel Tutorial–How To Sum Multiple Excel Tables Across Sheet
Let’s say you are a class teacher, and the math teacher and chemistry teacher have each given you a report card. You need to sum up the class’s grades in math and chemistry. How to do this quickly? Highlight cell C2 and go to the Formulas tab. Click on the arrow of Math & Trig, […]
-
How Do I Add 10 To All The Cells in Excel
Do you know how to add or subtract 10 from all the cells? I mean at the same time. If you haven’t mastered this technique yet, read on. Now we open an Excel sheet and enter some random numbers. Let’s take 10 as an example. Just type 10 in any cell. Select 10 and press […]
-
How to Use Data Validation for Entering Dates in Excel
When we want to enter data in Excel, in order to reduce data entry errors, we can use the data validation function to set the valid range of the data. Let’s take the below pic as an example. The picture shows the grades of the students. The score must be between 0 and 100. To […]
-
How to Use Excel Text Function in Microsoft Excel?
The TEXT function is one of the very frequently used functions, it can be used as a worksheet function in Excel. You can use the TEXT function to embed formatted numbers inside text. Syntax =TEXT (value, format text) Value: Value you want to format Format text: Format code you want to apply Now, Let’s learn […]
