Excel Functions
Reference guides for every Excel function — syntax, arguments, examples, and common errors.
Calculation of Bond Payment Dates
Compare Multiple Numbers and Text in Microsoft Excel
Convert a Crosstab Table into a Database Table Format
Count duplicates as one item
indexmatchvlookuphlookupdata referencingfunctions
Data Referencing with MATCH, INDEX, VLOOKUP and HLOOKUP
Excel Formulas for PPC Keyword Match Type Manipulation
vlookuplookupfunctions
Excel Vlookup Function
FIFO vs. LIFO Calculations using Visual Basic Modules
fillempty cellsgo to specialdata cleaning
Fill Data in Multiple Empty Cells
Find the largest or smallest numbers in a range of data using LARGE and SMALL functions
Internal Rate of Return (IRR) Calculations with different Accrual Basis
joinsunionaccesssqlqueries
Joins and Union in Microsoft Access and SQL
Manipulate Text by using Excel Commands and Functions
Mark to Market Financial Report
Mortgage Amortization Schedule
Prime Factoring using a Visual Basic Module
US Holidays Calculations
vbaarraysaccessrecordsetdatabase
Use Arrays to Read and Write Data in Access VBA
Use Conditional Formatting to create Quick Graphical Presentations
Use COUNTIF function and sorting to analyze the PowerBall Playout
Use Data Table for Scenario Analysis
Use Excel Pivot Table to create a Crosstab Table
Use Goal Seek command to reverse engineer desired results
Use OFFSET Function for Dynamic Referencing
Use RAND or RANDBETWEEN Functions to generate test data
Using Transpose Function to change the Data Layout
vlookuphlookuplookupfunctions