Rename multiple files using excel - Any format in less than 1 minute

Rename multiple files using excel -

There are 2 ways to rename file as far as I know. First one is just with single click and then change file name and second one by right click and choose rename option. It is very easy when number of files are less. But when there lots of files need to rename then above process will be time consuming and also boring. 

Today I'll show how to rename bunch files in just 1 minute with help of Excel. It's very simple and easy to understand.

There are two possibility - 

1. Do not have list of new names 

2. You have list of new names in Excel

We'll cover both possibilities in our tutorials. 

Lets Start -  

1. Do not have list of new names 

To rename multiple files in single folder quickly you have to download Change File Name file.

Download Change File Name (55kb)

Once you download file then open that file. You can see below window. First you have to enable Macro to rename file. Click on Option and then mark Enable this content to Enable Marco.

There are 3 Columns in file

1. A column - Path of Old file names

2. B column - New Name

3. C column -  Path of New file names

Keep your all files in single folder which you want to rename. It will be better if you copy that folder on desktop. 

Now click on Get Files button and select destination folder where all files are kept. Then press Ctrl + A and select all files and hit Open.

You can see path of all files automatically updated in column A.

 

Then type new name of files in column B against old names. Here I want to rename all files in number sequence so I have written numeric number against same. After that click on Change File Name Button. It will update New Files path in column C.

Finally Click on Change Name in Folder button to rename multiple files at one time. You will get small error 400 which you can ignore that. Now check your destination folder. You notice that all files name have been rename to new file name.

2. You have list of new names in Excel

In case you have list of new name file in excel then you have to use some formula to get only name of new file in column B. All other processes are similar to above.

Suppose we have two columns contain in our file. First one is old name of files which we want to rename and second is new name of files. You can simply copy paste New names in column B in our master file and then follow other process.

We should noticed that sequence of both files are similar. Other wise result will be wrong. 

If suppose sequence of both files are different then we have to use lookup formula to update new file name in column B only against old file name in column A.

Here I have use below formula to get only names in column B without extension.

=VLOOKUP(MID(A11,28,4),[abc.xlsx]Sheet1!$C$2:$E$35,3,0)

Then follow same procedure as previously done in first condition.

Click on Clear Content if all files have been renamed to delete data.

Please keep below points in mind while renaming multiple files.

1. Not single file is open from files which you want to rename.

2. There should be no duplicate new name of files in column B

3. There should be no extension in column B
4. File should not be exist with same name in destination folder.

Please watch below video for live demonstration.

If you have any issue or any doubt then feel free to comments on this POST.

Hope you like above POST.

Thank you. 

 

outlook move email to folder automatically from Specific Persons

Outlook move email to folder automatically from Specific Persons

Sometimes you have received many emails from person which you think useless and don't want to read these mails. You just simply want to move them in particular folder without reading. Or you can read them afterwords. Also sometimes you want to directly move mails to specific folder receive from specific person which are not related to work at all. Like personal emails. So can save your time for reading them or move them. If you want to read them then all emails you can see in just single folder.

Today we are learning how to move email to folder automatically from specific persons in outlook

Lets Start - 

  

Click on Tools menu and go to Rules and alerts. Below Pop-up window will appear.

You have to crate new rules to those kind of emails. For that click on New Rules and default selection is Move messages from someone to a folder. Keep as it is.

Click on people or distribution list to add names of particular person. You can select contact from list or type email id in From field. If you want to add more contact then put semicolon in between each email id and hit OK.

People or Distribution List

Specific 

After adding contact to distribution list. Click on Specific to select folder where you want to move emails. You can create New Folder by clicking New button at right side or just select existing Folder.

  

After selecting folder click on OK and then Next in Rules Wizard. After that you can see lots of condition in next window. Keep as it is if you want to move all emails from particular person or change rules as per your requirement bye just putting tick mark against specific condition. Then click on Next.

In next window outlook ask what to do with that emails. Whether you want to delete them or move them etc etc. Select option as per your requirement. Click on Next.

 

In next dialog box you can add exception if any. Exception emails will be received in Inbox same as Normal emails.

Finish Rule setup. There may be emails in inbox before you creating rule. If you want to move them also in particular folder then select option Run this rule now on messages already in Inbox under Setup rule option and click on Finish button.

 Do not forget to click on APPLY button in Rules and Alert and then hit OK.

Now all the emails will be automatically moved to specific folder which received from particular person.

Video Tutorial - 

Hope you understand. Thank you. :) 

Thank you !! Have a Nice Day !!

Highlight Mails from Specific Person in Outlook

Highlight Mails from Specific Person in Outlook

There are lots option in outlook to organize your work easily and it help us to do work more efficiently if you know the options available in outlook and their uses. Sometimes we receive mails from lots of people and we might be forgot or overlook mail important mail from specific person.

If you know the mails from specific person are more important than other mails then you can highlight same on receive. Today I'll show you how to highlight those emails from specific person so you'll work on that mails on priority basis.

Lets Start -  


We are going to use Customize Current View to highlight mails from specific person. There are two option available to go to Customize Current View window.

1 . View => Current View => Customize current View - Process might be different if you are using different version of outlook. 

2. By Right Click  => Customize current View 

After clicking on Customize Current View you can see Customize View : Messages window.
Go to Automatic Formatting.



Click on Add button and give name to Rules as you want then click on Font and chose font you want which highlight mails from specific person and click on OK button. If different rules are apply for same mails then first rule will be consider. You can move up or move down to change priority of rules.

 
Then go to Condition. There are bunch of different condition available to highlight mails from specific person. Type email id in From for specific person. You can also select from you contact by clicking on From button.

Now hit OK. 

Whenever you receive mails from that specific person then it'll automatically highlighted in font which you choose.

Video Tutorial - 

Hope you understand. Thank you. :) 

Thank you !! Have a Nice Day !!

Why format painter is not working in Excel ???

Format Painter not working after Paste Special

Hello, Sometimes we have huge list to analyses data. So we have going through many formulas, formats, process etc to examine data easily. And by doing so we face many errors. One of the error is format painter not working on few occasion and specially when value paste data which have formula in it and answer is in number format. Also we can't use that cell value or range value in other formula.
If we use the same then you will get #N/A error instead of answers. If you apply format painter from other cell then it'll not work.

Why Error Occurred ??

When you Paste Special formula then Green Triangle appears in a corner of cell. The reason behind is cell's contents violate one of Excel error checking rules. Excel Rule are turned on by default. 

In our case it is because numbers formatted as text data. When we use this cell or range then formula will not work as formula searching for number format and not text format.

What to do ??

Double Click -

If you double click on  cell then you can see error will disappear. But what if, if you have huge range in your excel and getting same issue then double click on each cell is not possible.

Convert to Numbers - 

If you click on a cell containing a green triangle the error options pop-up appears next to it. First select all range which contain green triangle and then click on yellow diamond option and select Convert to Numbers.

Now all the errors have been disappear and also formula will work which depends on these cells.
  
Text to Column -

If error still display in cell. Then follow below process.

Select Range => Data Tab => Text to Column 

Convert text to Column Wizard dialog box will open. Simply click on Next, Next and Finish.
and Errors are not seen anymore.

Video Tutorial - 

Hope you understand. Thank you. :)

Thank you !! Enjoy Excelling !! Have a Nice Day !!





  

MS Word - Insert table and Line designing with keyboard Shortcut

MS Word - Insert table with Keyboard Shortcut  

There are almost all things can be done without mouse means with just keyboard. Shortcut keys play very important role while working on any projects as they are very time efficient and we take less time with keyboard shortcut keys as compare to Mouse click. But you should remember to use keyboard shortcut.

Today I'll show you how to insert table with keyboard only in MS Word. This trick also work with MS Outlook. Insert table includes Create table, Add row and add column etc.

Let's Start -

To create table we have to use only two keys. first one is "+" and second one is "-".

start with + and then press - till the width of column you want.
Then again press + . Repeat this process till how much column you want.

+----------+------------------+------------------+

Finally press enter key

Now you can see few rows / columns have been added to your documents.

You can start typing with table heading. To go to next cell hit tab button. To enter one more row below press tab button when cursor in last cell.

Here I have added few rows of Data. What if you want to add one more column at last position say JOB. 

Then move cursor to any cell of last column by using arrow keys and Hold ALT key and press J + L + R key simultaneously. It will add one extra column at right side.

- To add extra column at left side of the cursor Hold ALT key and press J + L + L keys.

- To add extra row at above side of the cursor Hold ALT key and press J + L + A keys.

- To add extra row at below side of the cursor Hold ALT key and press J + L + E keys.

 In that way you can insert simple table in your MS Word or Outlook using only keyboard.

Line designing with keyboard Shortcut 

If suppose you want simple line in document which can be separate two topics like below line.
--------------------------------------------------------------
MS Word has keyboard shortcut for same. Press 3 times minus key (-) and hit enter. You'll see line is automatically added to docs. MS Word also give options to design various lines. Refer below Screenshot- 

Same trick also work in Outlook. Please try. 

Video Tutorial - 

If you have any issue then leave comments.

Thank you !! Have a Nice Day !!

Why you should not copy data Word to Blogger ?

Copy data Word to Blogger

Blog is best way to earn money online if you have little skills and the business of blogger is growing day by day. There huge number of people who start blogging to earn money but they unable to do that and they stop blogging. Blogging is all about consistency. So keep trying.

Sometimes you have bunch of documents in Microsoft word and you want to copy or update them in blogger. If you are doing copy directly them to blogger then please stop it.

Why you should not copy data Word to Blogger ?

Lets see why we cant copy data directly from MS word to Blogger. Here I have paste only single word "Hello" from MS word to blogger. It is well displayed in Compose window.

But when you see HTML  part there are lots coding added automatically for only word "Hello"

Why this is happened ?

Microsoft Word is auto added formatted text to documents. Means there are already prefix format in Ms word. So when you copy text / image from Word, format of that text or image also copied and paste in blogger with same format.

Why this need to avoid ?

There is might be chances that formatted text from word might not found by Google SEO. So there is chances of your blog rank go lower. So avoid to use copy paste from MS Word.

What should you use when you have lots of documents in MS Word which you want in your blogger?

There are two ways to transfer data from MS word to blog which I know.

1. Notepad -

Copy all data to notepad from MS Word and Notepad transfer the data without format. And then copy the same data to blogger and change format as you want. Also upload image separately. Surely this is very boring process when you have lots of documents to be uploaded. So I always prefer second one.

2. Google docs

This is very simple. Just upload MS Word documents to  Google docs and then open documents in google docs. You can see google docs holds same format as MS Word. Then copy data from Google docs to Blogger.

Coping from Google docs update only few HTML codes as compare to MS Word.

Hope you Understand :)

Thank you !!! Enjoy Blogging !!! Have a nice Day !!!