#1 Excel Tutorial on the Net - Excel Easy

Excel Easy: Key Features and Functions

This page serves as a comprehensive index of 69 popular Excel tutorials and techniques. Key topics include:

• Core Functions:
  • Lookup & Reference: VLOOKUP, INDEX and MATCH, OFFSET, INDIRECT.
  • Logical & Conditional: IF, COUNTIF, SUMIF, AVERAGEIF, AVERAGEIFS, Comparison Operators.
  • Mathematical: SUM, SUMPRODUCT, AVERAGE, PMT (loan payments), NPV (net present value), RRI (CAGR), and methods for basic arithmetic (add, subtract, multiply, divide).
  • Text Manipulation: CONCATENATE/TEXTJOIN, TRIM (remove spaces), extracting substrings (MID, LEFT, RIGHT), and checking for specific text.
• Data Management & Analysis:
  • Cleaning: Removing duplicates, deleting blank rows, and using Flash Fill.
  • Organization: Drop-down lists, locking cells, freezing panes, merging cells, and transposing data.
  • Statistical Analysis: Standard deviation (STDEV.P/S), t-Test, ANOVA, correlation, and frequency distributions.
  • Advanced Tools: Goal Seek, Data Tables, Advanced Filters, and Dynamic Arrays (spilling).
• Visualization & Charting:
  • Standard Charts: Line, Bar, Pie, and Scatter plots.
  • Specialized Charts: Histograms, Pareto charts, Gantt charts (via stacked bars), and Box and Whisker plots.
• Practical Applications:
  • Creating budgets, loan amortization schedules, and timesheet calculators.
  • Calculating percentages, compound interest, and age.
  • Formatting tips like inserting check marks, bullet points, and wrapping text.