Excel Guides

Convert a Crosstab Table to a Database Table in Excel

Crosstab tables are easy to read but useless for Power BI, Tableau, or any database. Excel's PivotTable Wizard has a hidden trick that flattens them automatically — no formulas, no manual work.

Count Unique Values in Excel (Ignore Duplicates)

When you need a count of distinct items in a list full of duplicates, Excel's SUM/COUNTIF array formula gives you the answer in a single cell — no pivot table, no manual counting.

Excel Formulas for PPC Keyword Match Type Manipulation

FIFO vs. LIFO Calculations using Visual Basic Modules

Fill Data in Multiple Empty Cells

Find the largest or smallest numbers in a range of data using LARGE and SMALL functions

How to Calculate Bond Payment Dates in Excel

Bond payment dates that fall on weekends or holidays shift to the next business day — extending the accrual period. Here's how to calculate adjusted payment dates automatically using EDATE, WEEKDAY, and IFNA.

How to Compare Multiple Values in Excel

Comparing two values in Excel is easy. Comparing three or more requires a different approach. Here are the formulas and tools that actually scale.

Internal Rate of Return (IRR) Calculations with different Accrual Basis

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

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

Using Transpose Function to change the Data Layout

WORKDAY and NETWORKDAYS Functions