 |
|
|
|
Home >
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Excel Help Portal| Follow this link to see help for ExcelUser products. |
|
|
Help with Excel Dashboards You can create outstanding
dashboard reports using only Excel. You'll see several samples
on this page.
Our Excel Dashboards section offers help with Excel charting. For example, this Excel dot plot chart provides an excellent way to compare measures of performance by category. More generally, this section
discusses Excel
dashboards. For more detailed help we recommend our Excel book,
Dashboard Reporting With Excel. |
|
|
Plug-N-Play Excel Dashboard Reports About
90% of the work has been done for you with our Plug-N-Play
reports. You just set them up, enter your data, and then
print your dashboard reports.You can change colors, print a variety of report designs, change the reports, add additional metrics, and so on. |
|
|
Excel ApplicationsExcel users in business often need help in creating Excel solutions. You know how to use the functions you need, but you're not sure how to use those functions to create your report or analysis.The Excel Solutions
area introduces articles about how to create a variety of Excel
applications, including cash management, new product tracking,
and variance reporting. |
|
|
Hands-On Excel, and More ChartsAre you looking for help using Excel charts or other areas of Excel functionality? For example, this Excel dot plot chart provides an excellent way to compare measures of performance by category.The
Exploring Excel section
explains how to summarize spreadsheet data, how to display areas
under a curve, how to display any color in Excel, and a lot
more. |
|
|
Help with Excel With Business Ideas For
years, people have used the Z Score to calculate the likelihood
that a business will go bankrupt. Our
Business Tools section explains
how to create an Excel Z Score analysis.Is your company
profitable enough to support your growth? Are you making or
losing money on the cash you borrow. You'll learn about issues
like these here. |
|
|
Excel in the EnterpriseMany companies that sell business software say that business should "move beyond" Excel. The Enterprise Excel section explains how Excel can be a key resource for even the largest companies. |
|
|
Excel QuestionsWe handle Excel questions in a different way than other Excel sites. When someone asks a question that other Excel users might also be asking, we answer the question with a complete article. Many of the articles in the following sections were written for this reason.So if you have an Excel question that other Excel users might also have, send us your question using this link: Send us your Excel question. |
|
|
Excel Help by Category
Here, we offer links to a massive directory of Excel help topics. You can browse both short links or long ones. The short links offer only the titles. The long ones include more detailed information. You also can search this site for the Excel help you need.We wrote a VBA program -- in Excel, of course -- to extract and categorize these links. Honestly, the subject categories need work. So when you find an article that's in the wrong category, isn't worth listing in the first place, or has a broken link, please let us know.
| Category | Link | Category | Link | |||
| Add-Ins | Short | Long | Mathematics | Short | Long | |
| Charts | Short | Long | Miscellaneous | Short | Long | |
| Customize | Short | Long | PivotTables | Short | Long | |
| Database | Short | Long | Printing | Short | Long | |
| Date-Time | Short | Long | Programming VBA | Short | Long | |
| Download | Short | Long | Setup | Short | Long | |
| External | Short | Long | Statistical | Short | Long | |
| Finance | Short | Long | System | Short | Long | |
| Formats | Short | Long | Text | Short | Long | |
| Formulas | Short | Long | Web | Short | Long | |
| Lookup | Short | Long | Worksheets | Short | Long | |
The links in the table above are to pages on the following sites. If you can suggest additional sites with good Excel information, please let us know.
 |
|
|
|
More Help In ExcelUser.... |
Use Benford's Law to Help PlanningAuditors use this fascinating insight to look for fraud. But it might help you to make your budgets and forecasts more accurate. |
Future Values from Scheduled Cash FlowsCalculate Future Values from a schedule of dates and cash flows, dates that aren't necessarily periodic. |
Explore business data with small chartsWhen you compare measures of performance to other measures, you add context that brings insight. We use data about public companies to illustrate the process. |
Summarize data with SUMPRODUCTThis function offers extensive power to summarize lists of data in Excel worksheets. It works somewhat like array formulas, but without the complications. |
Raise alerts in your Excel reportsExcel can analyze and present data from any number of sources in one report. This makes it the ideal program to uncover strategic and operational problems that are invisible to other software. |
Track product sales performanceDo you launch products, stores, or sales offices occasionally? Here's an easy way to use Excel charts to track their early sales performance. |
|
|
Copyright © 2004 - 2009 by Charles W. Kyd, all rights reserved. Content, graphics, and HTML code are protected by US and International Copyright Laws, and may not be copied, reprinted, published, translated, hosted, or otherwise distributed by any means without explicit permission. Terms of Use | Privacy Policy | Earnings Policy.
|
|
