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

  • About using mapping programs in Excel 2002 and later


  • AutoCorrect: The proofreader over your shoulder in Excel


  • Building formulas faster


  • Convert columns to rows, or rows to columns


  • Convert numbers stored as text to numbers


  • Count the number of words in a cell or range


  • Creating a data entry form with the Excel Template Wizard


  • Creating a database table from a summary table


  • Creating international number formats


  • Data validation 1: Control user choices with lists in Excel


  • Delete duplicate rows from a list in Excel


  • Design Access databases with normal forms and Excel


  • Determine optimal product mix with Solver


  • Differences between OLE DB provider and ODBC data source connections


  • Generating Random Testing Data


  • Getting data from the Web in Excel


  • Inserting the current Excel file name in a cell


  • Introduction to optimization with the Excel Solver tool


  • Link data from Excel to Access with AccessLinks


  • Making text and graphics work together


  • More ways to use HLookup and VLookup functions


  • MSN MoneyCentral Stock Quotes help


  • Overview and samples of data validation


  • Overview of improved Web Queries in Excel 2002


  • Print a portion of a worksheet


  • Reorganizing Data


  • Strategies for inserting graphics in Excel headers and footers


  • Synchronize Excel reports with a single data source


  • Tracking payroll data in Excel


  • Use a function to get a stock quote


  • Use HLookup and VLookup functions to find records in large worksheets


  • Using Access or Excel to manage your data


  • Using the Excel Add-in for SQL Server Analysis Services


  • Verify data with the Text To Speech toolbar


    • 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