Use conditional formatting in Excel to automatically highlight cells based on their content. Apply a rule or use a formula to determine which cells to format.
When we format cells in Excel we change the appearance of a number without changing the number itself. We can apply a number format (0.8 $0.80 80% etc) or other formatting (alignment font border etc).
Use the IFERROR function in Excel to return an alternative result such as text when a formula evaluates to an error. For example Excel returns the #DIV/0! error ...
This example teaches you how to add information to the header (top of each printed page) or footer (bottom of each printed page) in Excel.
Excel offers five different depreciation functions. We consider an asset with an initial cost of $10000 a salvage value (residual value) of $1000 and a useful life of 10 periods (years).
Learn all about Excel's lookup & reference functions such as VLOOKUP HLOOKUP MATCH INDEX and CHOOSE.
This page explains how to calculate the standard deviation based on the entire population using the STDEV.P function in Excel and how to estimate the standard deviation based on a sample using the STDEV.S function in Excel.
This page teaches you how to find duplicate values (or triplicates) and how to find duplicate rows in Excel. Select a range of cells. On the Home tab in the Styles group click Conditional Formatting Highlight Cells Rules Duplicate Values.
An easy formula that returns the quarter for a given date. There's no built-in function in Excel that can do this.
Excel offers three different workbook views: Normal Page Layout and Page Break Preview.
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.
