Excel tutorial on how to use the IFS function in Excel. Available in versions of Excel 2016 or better, the IFS function works like the IF function in that it returns a value based on criteria you set. It differs from IF in that IFS doesn’t require a statement if False. Plus, hence the name, […]
Excel Tutorials
How to Use Text to Columns – Excel Tutorial
Excel tutorial on how to split the contents of cells in Excel using Text to Columns. With Text to Columns, you have 2 options for how you can split the cell data: Delimited or Fixed Width Split the Contents of Cells using Text to Columns / Fixed Width Fixed Width adds splits in the same […]
Macro Buttons in Excel – ALL You Need to Know (+ video tutorial)
If you’ve recorded a macro to automate spreadsheet actions, you’ll need to know how to make a macro button in Excel. Automating your spreadsheet with macros can save you insane amounts of time. But, sifting through a list of macros to find the one you need can be a pain. Having a macro button to […]
What is a Macro in Excel??? + How to Make One (with video tutorial)
Macros in Excel are essentially instructions, in the form of code, used to automate steps in a process. This can be anything – like reformatting, inserting formulas, new text, etc. It sounds complex, and they sometimes can be, but, for a lot of everyday spreadsheet tasks, creating a macro is super easy and can save […]
How to Make a Pivot Table Timeline in Excel – Tutorial
Excel tutorial on how to Make a Pivot Table Timeline in Excel. What is a Pivot Table Timeline? Pivot table timelines are date filters that work something like sliders. They can be styled and, because of the slider element, are a great way to make filtering dates in pivot tables and dashboards more interactive and […]
How to Use the IFERROR Function in Excel (+ video tutorial)
Step-by-step tutorial on how to use the IFERROR function in Excel to customize what to display when a formula error happens. You can use the IFERROR function to display: For example, you could display a blank space or instructions on how to fix the error – rather than the default error message. How to Use […]