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 […]
Excel Tutorials
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 […]
How to Use Slicers in Excel – Tutorial
Excel tutorial on how to use Slicers in Excel. What are Slicers? Slicers are buttons used to filter data in spreadsheets. They can be used to filter pivot tables or Excel Tables. Especially when looking at large amounts of data, using Slicers is a faster way of filtering through that data. They can also be […]