- 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



Recent Comments
- JG743 on Merge two columns into one list in excel
- Oscar on Dynamic Gantt charts in excel 2007
- Mohamed Ismail on Dynamic Gantt charts in excel 2007
- Cyril on Auto resize columns as you type
- Oscar on Auto resize columns as you type
- Harry on Create a unique distinct sorted list containing both numbers text removing blanks in excel
- Harry on Create a unique distinct sorted list containing both numbers text removing blanks in excel
- Noa on Vlookup across multiple sheets in excel
- gobinda majhi on Create a dynamic border to your list using excel conditional formatting
- Cyril on Create a date range using excel formula
Recent Posts
- Advanced Gantt Chart Template
- Auto resize columns as you type
- Search with conditional formatting
- Tracking calls in excel
- Free School Schedule Template
- Copy a cell range whose size is likely to change from time to time (vba)
- Easily identify groups of duplicate rows
- List all open workbooks and corresponding sheets (vba)
- Basic data entry (vba)
- List all tables and corresponding headers in a workbook (vba)
