- 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.
Most Popular Blog Posts
How to extract a unique distinct list from a column How to return multiple values using vlookup Create a date range using excel formula Count unique distinct values in a column Sorting text cells using array formula How to create a dynamic chart Match two criteria and return multiple rows Merge two columns into one list Lookup with multiple criteria and display multiple search results using excel formula Find latest date in a list


Related blog posts
- Change chart data range using a drop down list (vba)
- How to create a dynamic pivot table and refresh automatically in excel
- List people with the highest scores based on criteria in a pivot table (Excel 2007)
- Auto refresh a pivot table in excel
- Extract a unique distinct list by matching items that meet a criterion in excel 2007 using pivot table
Recent Comments
- Tom on How to return multiple values using vlookup in excel
- Tom on Use a drop down list to extract and concatenate unique distinct values
- Jonah on Excel udf: Lookup and return multiple values concatenated into one cell
- hrvoje on Extract a unique distinct list from two columns using excel 2007 array formula
- khuram khalil on How to return multiple values using vlookup in excel
- Nick on How to extract a unique distinct list from a column in excel
- Ryan on Sorting text cells using array formula in excel
- Paul on How to return multiple values using vlookup in excel
- Oscar on How to return multiple values using vlookup in excel
- Oscar on Match two criteria and return multiple rows in excel
Recent Posts
- Create comments in cells whose value is larger than the column width
- Lookup multiple values in different columns and return a single value
- Learn how to return values depending on udf deployment (vba)
- Select a cell in a table and the chart updates automatically (vba)
- Excel template: Getting Things Done (vba)
- Disable autofit column widths for all pivot tables in a sheet
- Vba macro: Normalize data
- Date ranges: Weeks within a month
- Add values to different sheets (vba)
- Add values to a table (vba)
