Below we will look at a program in Excel VBA that calculates the total sales of each employee over a period of three years.
This example shows you how to create an array formula that sums every nth row in Excel. We will show it for n = 3 but you can do this for any number.
This example describes how to create a calendar in Excel (2024 calendar 2025 calendar etc). If you are in a hurry simply download the Excel file.
Below we will look at a program in Excel VBA which creates a User Defined Function that uses the Array function to return the names of the months.
Below we will look at two programs in Excel VBA. One program loops through all charts on a sheet and changes each chart to a pie chart. The other program changes some properties of the first chart.
This page illustrates 4 ways to insert bullet points in Excel. You can use a keyboard shortcut insert a symbol create a custom number format (our favorite) or use the CHAR function.
This example teaches you how to perform an F-Test in Excel. The F-Test is used to test the null hypothesis that the variances of two populations are equal.
Keyboard shortcuts in Excel allow you to do things with your keyboard instead of your mouse to increase your speed.
Below we will look at a program in Excel VBA that can reverse strings.
If you know the original price and the discounted price you can calculate the percentage discount. If you know the original price and the percentage discount you can calculate the discounted price etc.
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.
