Excel & Sheets Mastery with AI

To prevent duplicate values from being entered into Excel use data validation and the COUNTIF function.

If you know the result you want from a formula use Goal Seek in Excel to find the input value that produces this formula result.

The 'subscript out of range' error in Excel VBA occurs when you refer to a nonexistent collection member or a nonexistent array element.

You can specify rows and columns in Excel that will be printed on each printed page. This can make your printed copy easier to read. To print titles execute the following steps.

The difference between a function and a sub in Excel VBA is that a function can return a value while a sub cannot. Functions and subs become very useful as program size increases.

Excel does not offer Gantt as a chart type but it's easy to create a Gantt chart by customizing the stacked bar chart type. Below you can find our Gantt chart data.

This example teaches you how to import data from a Microsoft Access database. In Excel when you import data you make a permanent connection that can be refreshed.

Use the SUBTOTAL function in Excel (instead of SUM COUNT MAX etc.) to ignore rows hidden by a filter or to ignore manually hidden rows.

To separate strings in Excel use RIGHT LEN FIND and LEFT. If you're not a formula hero use Flash Fill to split text strings in Excel.

You can edit Excel files with Excel Online from anywhere without having Excel installed on your computer. First save an Excel file to your OneDrive location.