How To Combine Multiple Workbooks Into One Workbook In Excel
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.
How to Convert Any Currency to Words in Excel
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.
How to create multiple folders on your PC at once based on cell values in Excel
Do you need to create thousands of folders on your computer based on a list of names? If yes, hop on.
How to Automatically Enter Date and Time After Data Entry in Excel
An automatic system using an excel formula that allows you to populate date and time when data is entered into a different cell, leaving you with endless opportunities in excel.
How to Automatically Move Rows to a Specific Worksheet Based on Text in Microsoft Excel
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.
How to Import Each File Details from a Folder into Cells in Excel
In this Intermediate excel tutorial you'll learn to import important file details using Power query. This will be a dynamic Data table and you don't need any VBA to do this.
How to import multiple filenames, paths, and extensions into cells in excel
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.
How to Rename Multiple Files at Once
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.
