Take a Guess to Win Windows 10 Pro Key!
Categories: Excel Tips
-
How To Use The Subtotal Function In Microsoft Excel
Have you used the Subtotals function in Excel ever before? This can help you sort and sum data quickly. If you always handle tables or Excel worksheets. This is a really great command. Let’s take a simple example. Go to the Data and click on Subtotal. At each change in Sales Departments and add subtotal […]
-
How To Use REPT Function In Excel –Funny And Simple Tutorial
We have learned how to use the EXACT function in the last tutorial. Today, we are going to get something new—that’s the REPT function. The REPT function repeats characters or text a given number of times. Syntax: =REPT(text, number_times) Look at the example below. We type =REPT(“*”, A3) in cell B3 and press Enter key. […]
-
How to Change The First Letter to Lowercase in Microsoft Excel
In the last tutorial, we use the PROPER formula to capitalize the first letter in Excel. But how to change uppercase to lowercase?—that’s the Lower formula. Let’s take the same table as an example, and change the case into the yellow cells. Now, we type LOWER() in cell I1 and press Enter key. Then hit […]
-
How To Capitalize First Letter In Microsoft Excel-Simple Tutorial
We have mentioned methods of how to quickly change the case of a Word in a previous Microsoft Word tutorial. But that doesn’t work in Excel. Let’s take the words in the green cells as an example, capitalize them in the blue cell. Now, we type PROPER() in cell E1 and press Enter key. Then […]
-
Microsoft Excel Quick Analysis Tool–Super Powerful Feature
There is a really useful and amazing tool in Microsoft Excel. That’s Quick Analysis. You can just press Ctrl and Q to open it or click on the right mouse button. This feature contains a number of shortcut options (Formatting, Charts, Totals, Tables, Sparklines) which can greatly improve the efficiency of our rules. No.1 Formatting […]
-
How To Use VBA To Insert Blank Row After Every Row In Excel?
In our previous tutorial, we have learned how to insert blank rows in every (alternate) row. But, today, we will get to learn a better and advanced way. if you are familiar with VBA, this method may be very easy for you, if not, that’s fine. just go ahead. Prepare a sheet and press Alt […]
-
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 perfect 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 an 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 the 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 […]
