 |
  |
|
Home > Exploring ExcelIn this area of ExcelUser, we offer help about specific ways to use
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
|
|
|
|||
|
AN EXCELUSER POLL
The Excel 2007 Market Share?Excel 2007 is significantly different from earlier versions of Excel. So we wondered how widely used it is among its business users. That is, what's the Excel 2007 market share? Six months ago, we started to ask which version of Excel you use. You now can see the results of our poll here.
If you haven't taken the poll, you can take it several places on this site, including
at the right above. Also, please take the other poll at the right, which asks what you
think about Excel 2007's most significant change: The Ribbon. |
|||
|
|
|||
|
REDUCING
SPREADSHEET HELL
Use Excel's SUMPRODUCT Function
|
|||
|
|
|||
|
REDUCING
SPREADSHEET HELL
Summarize Data With Excel ArraysAre you tired of manually summarizing your data for reports and analyses? Excel formulas can do this quickly and easily.We explain the most powerful and flexible approaches. The most powerful method is to use Excel arrays, which can give you summaries using any number of criteria. If you've not using this powerful tool, you're working harder
than you should. |
|||
|
|
|||
|
EXCEL 2007
Excel 2007's New User InterfaceExcel has changed. A lot.Menu bars are gone. All but one toolbar are gone. We now have a ribbon, tabs, groups, and dialog launchers. We present a pictorial introduction to the key features of
Excel 2007's |
|||
|
|
|||
|
OLD AND NEW EXCEL
Excel's Shortcuts to DialogsWith few exceptions, shortcut keys work the same in both old and new Excel. This fact is important, because you'll probably need to use both versions of Excel for a long time. We provide tables that show all shortcuts we know that launch dialogs both in Excel 2007 and in earlier versions of the product. |
|||
|
|
|||
|
EXCEL CHARTS
Create Excel Bullet Graphs Bullet graphs
show the same information that gauges do, but they're smaller and easier to read.
We
show to how to create Excel bullet graphs. |
VISITOR QUESTION
Variable ListsYou can display Excel data in a variable-length list. We show how in response to a visitor's question about purchase orders. |
||
|
|
|||
|
COLORFUL REPORTING
Use Any Color in Your Reports Excel offers only 56 colors in its standard
palette. Even so, you can replace any of those standard colors with
any custom colors you want. This article shows you how. |
VISITOR QUESTION
Deleting RowsYou don't need to write a macro to delete rows or
columns with specific data from a database. Use AutoFilter
instead.
|
||
|
|
|||
|
EXCEL CHARTS
Create Shaded Curves You can create shaded areas in Excel charts to specify areas of
special interest. Here, we show you how to do this using normal
curves. |
VISITOR QUESTION
Weekly ReportingPreparing weekly dashboards and other Excel reports is easy if your data is properly organized. Here's a simple Excel database. |
||
|
|
|||
|
EXCEL PIZZAZZ
Tables with Class
|
VISITOR QUESTION
Cell Reference$A visitor is confused about when to use "$" in cell references. Here's information that every Excel user should know. |
||
|
|
|||
|
EXCEL LINKS
Top MVP SitesHere are the top web sites run by current or former Excel MVPs. All offer useful Excel material in English on their web sites. |
VISITOR QUESTION
Tab Key PrimerA visitor wants to tab from cell to cell. We explain how. |
||
|
|
|||
|
SPREADSHEET FUNCTIONS
Normal DistributionsExcel provides several spreadsheet functions for working with normal distributions. Here's an introduction for people who are statistically challenged. |
 |
VISITOR QUESTION
Import Text FilesHave you ever wanted to read a text file into a workbook, column by column? This article shows how to read text files with VBA. |
|
|
EXCEL TOOLS
Fight Spreadsheet HellYou don't need to spend hours turning raw data into useful information. You can fight this type of Spreadsheet Hell with help from three Excel key functions. |
 |
VISITOR QUESTION
Combo CriteriaSuppose you've got an Excel database with many fields, and you want to find certain records using multiple criteria. We show how. |
|
|
|
|||
|
REPORTING STRATEGIES
Avoid ErrorsWe offer seven ways to avoid many Excel errors. We don't discuss all the ways to avoid Excel errors, but we make a good start! |
VISITOR QUESTION
Debug INDEXWe often recommend the INDEX function. Here's how to debug it. |
||
|
EXCEL TOOLS
Range Name RoundupExcel's range names offer more power than you might think. And they're not hard to use. Here's an introduction to the power that Excel provides. |
 |
EXCEL 2007
Excel 2007 IntroHere's your guide to key Microsoft sources that have information about the next version of Office. |
|
|
|
|||
|
EXCEL TOOLS
Range Name RoundupExcel's range names offer more power than you might think. And
they're not hard to use. Here's an introduction to the power that Excel provides. |
|||
|
EXCEL 2007
Excel 2007 IntroHere's your guide to key Microsoft sources
that have information about the next version of Office. |
|||
|
EXCEL DATES
Work With Dates Before 1900Excel's date-handling system offers little help for dates prior to 1900. We explain ways to work with dates back to the year 0100. |
|||
|
VISITOR QUESTION
Rounding TimesHere's how to round time into quarter-hour increments. |
|||
|
EXCEL DOCUMENTATION
Excel VBA StandardsLearn four VBA documentation standards that
make your VBA code easier for you and others to understand. |
|||
|
DATA ANALYSIS
Import Web DataExcel's Web Query tool provides a quick and
easy way to import web data to Excel. |
|||
|
EXCEL DOCUMENTATION
Include Row & Column HeadingsWhen you document your Excel worksheets, give your readers complete information by including row and column headings in the illustrations of your worksheets. |
|||
|
VISITOR QUESTION
Round Data UpHere's how to round data up rather than up or down as the ROUND function does. |
|||
|
DATA
ANALYSIS
MS Query with ExcelYou can maintain spreadsheet databases that work
like relational tables, and query them with SQL. This article shows you how. |
|||
|
REPORTING STRATEGIES
SUM ErrorsSimple edits to your spreadsheets can cause
significant errors. We offer three ways to protect yourself. |
|||
|
REPORTING TOOLS
Dynamic Range NamesDynamic names can adjust their definitions
in response to values in cells. They let you update a report
merely by changing a value in a cell. |
|||
|
VISITOR QUESTION
VBA PropertiesThese VBA spreadsheet functions can show
when a file was saved and who last modified the workbook. |
|||
|
DATA ANALYSIS
Using Array FormulasArray formulas may be Excel's most powerful feature for
summarizing data. Here's how to use this hidden power. |
|||
|
VISITOR QUESTION
Local NamesExcel range names can be global to your workbook or local to a worksheet. We explain. |
|||
SUMPRODUCT offers extensive power to summarize lists of data in
Excel worksheets. It works somewhat like array formulas, but without the complications.
 |
 What's your greatest Excel challenge? |
 |
Copyright © 2004 - 2008 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.
|
||
|
|
|
||