Alan Barasch has specialized in Excel for twelve years. He provides these
excellent Excel Formulas, User-defined Functions, and Excel VBA coding
examples on his website.
These will greatly help you to understand how these advanced Excel
features work and how to use them so you can get Excel working
to its maximum potential.
Excel Formulas
- Four Conditions
- Max Min Match
- eBay Commissions
- Compare 3 Lists Conditionally
- Sum Only Positive Numbers
- Calling All Teachers
- IFs and Calculation
- Find Number of a Letter
- Compare 2 Lists
- Average with an IF Statement
- Test for 3 Conditions
- Count Number by Month
- Holiday - Labor Day
- Holiday - M.L. King
- OverPunch Code
- Perform Calculation if Both Conditions met
- If Rank is Greater than 10…
- Six Nested Ifs
Excel User-defined Functions
- Stock Quote
- Bond Maturity
- Count Numeric Values Function
- Easter Function
- Determine Years, Months, & Days between 2 Dates
- Convert Numbers to Words
Excel VBA
- Convert Lots of Tabs
- Read Option Buttons
- Using MultiPage
- Custom Menu
- Retirement Calculator
- Odd and Even Rows
- Stock Market Tracker
- Build A Formula
- Determine Parse Position
- Parse Text File
- Using Ubound
- Compare List and Insert if Not Found
- Write Contents of Multi Choice Box
- Custom Document Properties
- Move Minus (Revisited)
- Move the Minus Sign to Front
- Add Data to Next Row
- Mail from Excel
- Count Numeric Values in String
- Write Error to Log
- Pad Number of Digits
- Count Occurences of a Digit
- Extract Info from Text File
- Count Occurences in String
- Cascading Style Sheet
- Write an ICS
- Write a Text File
- Add a Single Quote
- HTML Color Chart
- Custom Dialogs
- Increment a Hour/Minute String
- Populate Dialog
- Produce Color Chart
- Clean up Import
- Change Case to Mixed
- Trap Those Errors
- Color Unlocked Cells
- Multiple Page Numbers
- Color Rows by Criteria