All articles
Blog
Every tutorial on the site, newest first. Looking for something specific? Use the search, or start from a topic: formulas, shortcuts, Pivot Tables, VBA or guides.
How to Share an Excel File for Editing by Multiple Users
Learn how to share an Excel file for editing by multiple users with OneDrive, a copy link, or the legacy shared workbook, step by step.
Excel Formula to Count Days from Date to Today (4 Ways)
Use an Excel formula to count days from a date to today automatically with TODAY, DAYS, DATEDIF or NETWORKDAYS. The count updates every day on its own.
How to Calculate the Difference Between Two Columns in a Pivot Table
Learn how to calculate the difference between two columns in a pivot table with a calculated field, Difference From, or a formula beside it.
How to Make a Bell Curve in Excel (2 Easy Methods)
Learn how to make a bell curve in Excel with NORM.DIST and a smooth scatter chart, from a known mean and standard deviation or from your own data.
How to COUNTIF with Multiple Criteria in Excel (4 Easy Ways)
Learn how to COUNTIF in Excel with multiple criteria using COUNTIFS, operators, SUM with COUNTIF for OR logic, and SUMPRODUCT, with worked examples.
How to Write Scientific Notation in Excel (4 Easy Ways)
Learn how to write scientific notation in Excel by typing E, using the Scientific format, a custom engineering format, or the TEXT function.
How to Move Columns in Excel (4 Easy Ways)
Move columns in Excel without overwriting data using Shift + drag, Insert Cut Cells, a left-to-right sort, or the CHOOSECOLS function.
How to Unprotect an Excel Sheet (3 Easy Ways)
Unprotect an Excel sheet or workbook with the password, or remove protection without it using the ZIP and XML trick or Google Sheets.
How to Move a Chart to a New Sheet in Excel (3 Easy Ways)
Move an Excel chart to its own chart sheet, to another worksheet, or to a new worksheet using the Move Chart dialog or cut and paste.
How to Split Text into Multiple Rows in Excel (3 Easy Ways)
Split text in one Excel cell into separate rows with TEXTSPLIT, Power Query, or Text to Columns plus Transpose. Step-by-step examples with screenshots.