归档: Sandra
-
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 […]
-
How Do I Replace Pictures With Words In Microsoft Word?
It’s actually a very simple skill, and many people do not often do this in their daily work, but multi-skills are not pressured. Some tricks come in handy when you need them. Now we prepare a paragraph and the picture. I want to turn all the words “dogs” into a pic of a cute dog […]
-
How To Adjust The Width And Height Of All Tables In A Word Document?
In today’s tutorial, the author would like to share with you guys the fastest way to adjust the width and height of tables in a Word document. Let’s take an example. There are four tables of different sizes, and we need to adjust them to the same size quickly. Go to the Developer tab and […]
-
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 Rename Multiple Files At The Same Time
Sometimes we need to rename some files, such as after a trip. We import the pictures from the camera into the computer. Changing photo names one by one is a waste of time. So how do you quickly rename a group of travel photos? There is a way. Let’s make this a little bit more […]
-
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 […]