Pages
Posts
- A1 vs R1C1 Reference Style
- Add a Checkbox in Excel
- Annual Growth Rate in Excel
- Autofilter in Excel
- Autosum Function
- Average Function
- AVERAGEIF Function
- AverageIFS Function
- Clear a filter in Excel
- Compound Annual Growth Rate
- Compound Quarterly Growth Rate (CQGR)
- COUNTIF Function
- COUNTIFS Function
- Creating a Template in Excel
- CUMIPMT Function
- Data Filtering in Microsoft Excel 2013
- Data Validation Techniques in Excel
- DATE Function in Excel
- DATEDIF Function
- DATEVALUE Function
- Display Formula and Value Simultaneously
- DSUM Function
- EXACT Function
- Find and Replace in Excel
- Find and Select
- FV Function – Future Value
- Getting VBA setup in Excel
- GOAL SEEK in EXCEL – What-If Analysis
- How to apply Multiple Filters in Excel
- If Function
- Import/Export Data in Tableau
- INDEX Function
- INDIRECT Function
- Linked Checkbox – True / False
- Loading Data
- Match Function
- MAX Function
- Mortgage Calculator in Excel
- Named Ranges in Excel – Setup, Rules, and Uses
- NETWORKDAYS Function
- NOW Function
- Pivot Tables
- PMT Function
- RAND Function
- RANDBETWEEN Function
- Randomly Sort Data in Excel
- RANK Function
- Selections, Formatting Cells and Color (Color Index)
- SPLIT FIRST and LAST NAMES
- SUMIF Function
- SUMIFS Function
- Summing Only Positive or Negative Values
- SUMPRODUCT and EXACT Formula
- Tableau Interface Review
- TODAY Function
- Using INDEX and Match Functions Together
- VLOOKUP Function in Excel
- What is a Macro?
- What is Tableau?
- What is VBA in Excel?
- Writing Your First Macro
