Index of Vertex42 Articles

General Excel Articles

• Excel Tips
• Array Formulas
• Dashboard Reports
• Sparklines
• Using Excel Solver
• Excel Web Queries
• Custom Excel Functions
• Excel Toolbar Buttons
• Excel Keyboard Shortcuts
• Rounding to Significant Figures
• How to Create a Timeline
• Excel's COUNTIF Function
• Drop Down List via Data Validation
• Dynamic Named Ranges
• Grouping and Outlining
• Using the EVALUATE Function
• Fun and Games

Finance Articles

• Amortization Formulas
• Financial Modeling
• Amortization Calculation
• Simple Interest
• Negative Amortization
• Debt Consolidation
• How to Make a Budget
• Budget Software
• How to Budget
• Small Business Invoicing
• How to Calculate NPV and IRR
• Calculating Discount Factors in Excel

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
• Using a Cause and Effect Diagram

Mathematics

• Exponential Growth

Engineering

• Excel in Kinematics - Some stuff I created in/for school