IF Statement Without Repeating Formula | Excel LET Function | Excel Named Formula
Microsoft Excel Tips and Tricks In this Microsoft Excel video tutorial I show you how to avoid having to repeat[…]
Read more
Category: Excel
Excel Timeline Template | How to Create a Timeline Chart in Microsoft Excel
Microsoft Excel Tips and Tricks In this Microsoft Excel video tutorial I explain how to create a timeline chart. There[…]
Read moreCreate Data Tables in Excel | What-If Analysis Data Tables – One Variable and Two Variable
Microsoft Excel Tips and Tricks In this Microsoft Excel video tutorial I demonstrate how to create what-if analyses data tables.[…]
Read more
Excel – Sort by Color and Sort Using Conditional Formatting
Microsoft Excel Tips and Tricks Sorting in Excel gives us a lot of options, but many users do not know[…]
Read moreExcel For The Infection Preventionist – Preview of APIC Pre-Conference
Microsoft Excel Tips and Tricks The Association for Professionals in Infection Control and Epidemiology is holding their annual conference in[…]
Read moreExcel Print Options – Set Print Area, Print Selection, Margins, and Printing Gridlines
Microsoft Excel Tips and Tricks Excel has many print options. We will look at setting the Print Area, Print Selection,[…]
Read moreExcel Magic Revealed: Unstacking Data Like a Pro!
Microsoft Excel Tips and Tricks Excel Magic Revealed: Unstacking Data Like a Pro! Credit Chandoo
Read moreChange Chart Y or X Axis Start Value in Excel | Change Minimum Bounds | Customise Axis Scale
Microsoft Excel Tips and Tricks In this Microsoft Excel video tutorial I demonstrate how to change the X or Y[…]
Read moreAlternative to Merging Cells In Excel | Why You Should Avoid Merging Cells | Center Across Selection
Microsoft Excel Tips and Tricks In this Microsoft Excel video tutorial I demonstrate two alternatives to ‘merge and center’. Merge[…]
Read moreExcel + ChatGPT – Center Across Selection Shortcut Macro!
Microsoft Excel Tips and Tricks 🚀 Excel + ChatGPT Automation – No more annoying Merge & Center! Use this Center[…]
Read more