Advanced Tutorial
In this advanced Excel tutorial, you’ll learn how to copy data from one sheet to another based on cell value in Excel using VBA. It is easy and takes only two minutes.
Learn to create thousands of folders on your computer automatically using excel. You can either add a list of names or type them one by one.
Merging and combining multiple workbooks into a master workbook in excel is easier than ever. It takes 2 minutes to prepare and a few seconds to merge. Don’t believe me? Click.
In this advanced tutorial, we'll be able to easily convert currency to words using VBA. This will be an easy-to-follow instruction, and you don't need to be an expert on VBA for this. If you have a currency other than the dollar, you can do that also.
Do you need to create thousands of folders on your computer based on a list of names? If yes, hop on.
In this tutorial, you’ll be amazed to see how easy it is to move data to different worksheets based on condition. It is quick, easy and everyone can do it. I’ll be using vba to transfer data from sheet to sheet and the code is also given so that you can use it in your project.
In this advanced excel tutorial, you’ll learn to extract multiple filenames from a folder to an excel worksheet. You’ll be able to extract filenames, file paths, and file extensions.
In this advanced excel tutorial, you'll learn to rename multiple files at once from a folder. You'll be able to change names with any file type like PDF, JPEG, Xlsx, etc.