Index of Vertex42 Articles
Articles on Excel, Personal Finance, Statistics, etc.
This page is an index to articles about Excel, personal finance, statistics, engineering, data visualization, Monte Carlo simulation, and other articles - may of which were written prior to the creation of our Blog.
Master Excel, one tip at a time
Download the new Vertex42 Spreadsheet Tips Workbook to learn and practice essential Excel skills right in Excel!
Try it for Free!Excel Formulas
- Create LAMBDA Functions
- Blog: Experts Share Their 10 Favorite Excel Functions
- VLOOKUP and INDEX-MATCH Examples
- SUMIF and COUNTIF in Excel
- Use DATEDIF to Calculate Age
- Custom User-Defined Functions in Excel
- Dynamic Named Ranges in Excel
- Text Manipulation Formulas
- Volatile Functions in Excel
- Excel Array Formula
- Pre-Blog: Using the EVALUATE Function
- Julian Date Conversions
- Rounding to Significant Figures
- Exponential Growth
Other Excel Articles
- Blog: Using Unicode Character Symbols in Excel
- Add Cool Features to Your To Do Lists in Excel
- 10 Ways to Use Calendar Templates
- Analyze Data with a Calendar Chart in Excel
- New Gantt Chart for Excel Online
- Showing Actual Dates vs. Planned Dates in a Gantt Chart
- Excel Drop Down List
- Dynamic Drop Down Lists for Dates and Check Numbers
- Custom Number Formats
- Pre-Blog: Excel Tips
- Theme-Enabled Templates
- Excel Keyboard Shortcuts
- Using Excel Solver
- Dashboard Reports
- Sparklines
- Excel Web Queries
- How to Create a Timeline
- How to Create a Vertical Timeline in Excel
- Grouping and Outlining
- Free Excel Training
Finance Articles
- Amortization Formulas
- Financial Modeling
- Amortization Calculation
- Simple Interest
- Negative Amortization
- Debt Consolidation Pros and Cons
- CAGR Formulas in Excel
- How to Make a Budget
- How to Budget
- Small Business Invoicing
- How to Calculate NPV and IRR
- Calculating Discount Factors in Excel
- Resources for Homeowners
Statistics & Quality Control
- Pareto Analysis & Pareto Chart template
- Create a Control Chart in Excel
- Create a Dot Plot
- Monte Carlo Simulation
- Histograms in Excel
- Random Numbers
- Normal Distribution Graph
- Formulas for Summary Statistics
- Using a Cause and Effect Diagram
Other
- Unicode Symbols
- Charts and Graphs in Excel
- Math Resources for Kids
- Fun with Excel
- Excel in Kinematics
For more Excel resources elsewhere on the web, check out our Excel Resource Directory.
