Home > Excel
Google
Web This Site

The Excel section

Software

Tips

Templates

Charts

Tutorials

Other

MVPLogo2w.gif (9001 bytes)

Microsoft has recognized me as a Most Valuable Professional (MVP) for the Excel program each year starting with 2000, This is an annual award for those who display technical competence and a willingness to help others.  For the Excel program, Microsoft has designated about 95 such people worldwide.

Learn more about the MVP program, or visit the web site maintained by mvps.org.

 

    Excel Tips
      Enter time with seconds
      Read Chart Value
      Multi Area Argument
      Data in blocks
      Random password
      Find All
      Power Set
      Regression Analysis
      Factors and prime numbers
      Hyperlinks
      Delimited Numbers

 

 

 

    Charts
      3D Surface
      Normal curve
      Step chart
      Straight lines
      Supply & Demand
      Demand Elasticity
      Waterfall chart
      Conditional shape colors
      Plot Magnitude Difference
      Single Chart Dual Axis

 

    Tutorials
      Broken y axis
        Broken axis tutorial
      Cascading queries
        Moving the database
      Color zone in X-Y chart
        Color Zone Tutorial
      Chart Custom Formats
      Custom Chart Table
      Clickable Image
      Dynamic Charts
        Named Formulas
        Names in Charts
        Drop Down Box
      Dynamic Chart Title
      Data Labels
      Format formulas
      Flexible Log Scale
      Floating Bars
        Floating bars tutorial
      Frequency Table
      Interpolation
      Numerical Integration
      Random Selection
      Ranking
      RDBMS in Excel
        Introduction
        Query Results
        Build Queries
          Query 1
          Query 2
          Query 3
          Query 4
          Query 5
      Select Markers
      Shaded Band
      Stacked Charts
      Worksheet as Chart
      Worksheet as Gantt Chart
      Unusual interfaces I
      Validate Data I