You can edit the same Excel file with multiple users through a feature called co-authoring. This feature lets multiple people make changes in a document stored on a remote, so-called cloud server ...

Setting a password for an Excel workbook is simple. When done, users wanting to access the protected workbook have to enter the password in a dialog box that pops up when they try to open the file.

Now, move the .bat file to the location where you want to create all the folders and double-click on it. Depending on how many cells you selected, it might take 10-15 seconds to complete the job.

The Pivot Table is a tool that Excel uses to create custom reports from your spreadsheet databases. All you need is one common, unique field. Here's how to set it up with multiple spreadsheets.