Jonatan Silva

Discover what Excel version control is, the version control features Excel has to offer, and how to use them to share, merge, and review Excel changes.

Learn how to remove password protection from Excel: unlock a file or a sheet when you know the password, and what to try if you’ve forgotten it.

Learn what the debt to equity ratio is, how to calculate it with worked examples, and what a high or low D/E ratio tells you about a company.

There are many ways to combine multiple columns into a single column in Excel. Here’s how to do it without losing any data.

Learn the Excel reference another sheet formula and how to pull a cell, a range, or whole columns from another worksheet or another workbook.

Learn how to use macros in Excel to automate repetitive tasks: record a macro, save it as a macro-enabled template, and run it on new data.

Learn how to share Excel file for multiple users with OneDrive, protect a shared workbook, and choose who can edit it in Microsoft 365.

Learn how to unlock cells in Excel. Unprotect the sheet, unlock only the cells you need while the rest stay locked, and see what to do without the password.

Learn how to insert an Excel hyperlink to another sheet, cell, or website with the Insert Hyperlink command or the HYPERLINK function, and how to remove it.

Use the free Schedule Google Sheets template to plan your week, turn it into an employee shift schedule, share it with your team, and build an annual calendar.