Improve Your Excel.com
Everything you need to improve your Excel in one place!
Home Categories Tips By Email Search Contact Us Other Links Your Questions Answered

  • A formula to calculate a ratio


  • Automatic list numbering


  • Avoid error displays in formulas


  • Calculate the day of the year and days remaining


  • Calculate the number of days in a month


  • Calculating a conditional average


  • Category / ISFunctions


  • Change cell values using Paste Special


  • Change the formatting of your subtotal rows


  • Compare ranges by using an array formula


  • Converting non-numbers to actual values


  • Converting Strings to Numbers


  • Count AutoFiltered rows


  • Counting distinct entries in a range


  • Creating a "megaformula"


  • Dealing with negative time values


  • Delete all input cells, but keep the formulas


  • Displaying AutoFilter criteria


  • Excel FAQ - Functions and Formats


  • Excel Roundup 1


  • Excel Statistical Functions: BINOMDIST


  • Excel Statistical Functions: Implications of Statistical Function Improvements for Analysis ToolPak


  • Excel Statistical Functions: POISSON


  • Force a global recalculation


  • Hiding your formulas


  • Identify formulas using Conditional Formatting


  • Locate phantom links in a workbook


  • Moving Subtotals


  • Perform math operations without formulas


  • Perform two-way table lookups


  • Referencing a sheet indirectly


  • Round values to the nearest fraction


  • Sum the largest values in a range


  • Summing times that exceed 24 hours


  • Text and values in one cell


  • Transforming data with formulas


  • Understanding Relative and Absolute Addressing


  • Using Data Validation to check for repeated values


  • Using the SUBTOTAL Function


  • Working with pre-1900 dates


    • Want more tips? Subscribe to our Free Newsletter today and we will send them to you.
    Most Popular Categories |Bar_Charts |Charts |Pie_Charts |Excel Counting |Excel Filters |Pivot_Tables |Excel_Keyboard_Shortcuts |Conditional_Formating |VLookup |Games |Names_and_ranges |VBA_Examples |Macros