Get Digital Help
  • Home
  • Templates
  • Products
  • Categories
    • Advanced Filter
    • Automate
    • Combine/Merge
    • Compare
    • Conditional Formatting
    • Count Values
    • Dates
    • Drop Down Lists
    • Duplicate Values
    • Finance
    • Misc
    • Pivot Table
    • Random
    • Records
    • Search/Lookup
    • Sort Values
    • Templates
    • Unique Distinct Values
    • Unique Values
    • Unique Values
    • User Defined Functions
    • VBA
    • VLookup
    • Unique/Duplicates
    • Sort values
    • Count values
    • Search/Lookup
    • Microsoft Excel
  • Archive
  • Contact
    • Contact me
  • About Me
    • About me
    • Blogs I read
      Popular categories

       Automate

       Charts

       Compare

       Conditional formatting

       Count values

       Dates

       Drop down lists

       Misc

       Pivot tables

       Search/Lookup

       Sort values

       Tables

       Templates

       UDF

       VBA

       Vlookup

      • Advertise Here

      Dashboard reporting with excel This e-book teaches you how to create your own Excel dashboard reports, starting from scratch. Learn how to create mini-charts, how to use Excel's Camera tool, how to set up Excel databases, and a lot more.


      Excel Worksheet-Formula Add-Ins allows worksheet formulas to change chart settings. For the first time ever, your formulas can create traffic-light charts, highlight chart elements, assign number formats, and much more.


    Get Digital Help > Excel > Pivot table

    Archive for the ‘Pivot table’ Category

    Merge two related tables
    Sum security holdings monthly and yearly in a pivot table
    Monthly time sheet by project
    Analyze trends using pivot tables
    Disable autofit column widths for all pivot tables in a sheet
    Vba macro: Normalize data
    Auto populate a sheet
    Change pivot table data source using a drop down list
    Follow hyperlinks in a pivot table
    Count unique distinct values in a pivot table in excel
    Auto refresh a pivot table in excel
    Excel 2007 pivot table: Count unique distinct records (rows)
    Google spreadsheets: Pivot tables
    How to create a dynamic pivot table and refresh automatically in excel
    Tracking a stock portfolio in excel (auto update)
    List people with the highest scores based on criteria in a pivot table (Excel 2007)
    Extract a unique distinct list by matching items that meet a criterion in excel 2007 using pivot table
    How to return the total for orders with more than one item in excel
    « previous entries
    Next Page »
    • Subscribe subscribe  

    • Blog updates by email:

    • Welcome! I am Oscar and here to help you! Feel free to comment and ask excel questions.
      Don´t forget to add my RSS feed and subscribe to new blog articles by email.

    • Recent Comments

      • duisburg_du on Yet another excel calendar
      • duisburg_du on Yet another excel calendar
      • Oscar on Filter unique rows and sort by date using array formula in excel
      • Oscar on Split data across multiple sheets in excel (vba)
      • Louis on Count matching cell values in two columns in excel
      • Laura on Filter unique rows and sort by date using array formula in excel
      • Lefteris on Split data across multiple sheets in excel (vba)
      • Pisit on Concatenate a cell range without vba in excel
      • Oscar on How to use excel SUMPRODUCT function
      • Arturo on How to use excel SUMPRODUCT function

    • Recent Posts

      • Heat map using pictures
      • How to use excel SUMPRODUCT function
      • Count students
      • Use a map in an excel chart
      • SEARCH and FIND functions
      • Yet another excel calendar
      • MMULT function – Matrix multiplication
      • SMALL function and LARGE function
      • Copy/Rename a file (excel vba)
      • Assign each person with randomly unique objects as a daily activity
    Oscar Cronquist