To merge Excel files into one use the 'Move or Copy' feature. If you need to merge many Excel files consider using VBA to automate the process.
Use LAMBDA and the Name Manager in Excel to create your own Excel function. You can use this custom function like any other Excel function!
Dynamic array formulas entered into a single cell fill multiple cells. This behavior in Excel 365/2021 is called spilling.
Excel has many functions to offer when it comes to manipulating text strings.
To find unique values in Excel use the Advanced Filter to extract unique values or filter for unique values. If you have Excel 365 or Excel 2021 use the magic UNIQUE function.
Drop-down lists in Excel are helpful if you want to be sure that users select an item from a list instead of typing their own values.
Use CONCATENATE CONCAT TEXTJOIN or the & operator in Excel to concatenate (join) two or more text strings.
Sparklines in Excel are graphs that fit in one cell. Sparklines are great for displaying trends. Excel offers three sparkline types: Line Column and Win/Loss.
Sometimes it can be useful to hide columns or rows in Excel. Learn how to hide a column unhide all columns hide cells and much more.
Sensitivity analysis gives you insight into how the optimal solution changes when you change the coefficients of the model. After the Excel solver found a solution you can create a sensitivity report.
Excel meets AI – Boost your productivity like never before!
At Formulas HQ, we’ve harnessed the brilliance of AI to turbocharge your Spreadsheet mastery. Say goodbye to the days of grappling with complex formulas, VBA code, and scripts. We’re here to make your work smarter, not harder.
Categories
113
49
16
Ready to Get Started?
Improve your proficiency in spreadsheets, increase your productivity and eliminate the challenges associated with intricate calculations and formulas for good.
