Free Computer Education and Training Search
excel   1-10 of 6035 results 0.17 seconds
Excel Pivot Tables
Excel Pivot Tables   Lesson 13 of 30: Excel Pivot Tables If Excel recognizes your set of data as a database You can do this First let's demystify the pivot table ... reporting tool it is somewhat limited. When you learn about the magic function and the database functionalities in Excel you don't really need pivot tables and these formulas allow you to develop a report with the ...
http://www.excel-vba.com/e-pivot-table.htm - 3515 bytes - 5/12/2006 - text/html Cache
Hits: 485    Rating: 3 /10    Votes: 4    Comments: 0    Report this site


Excel Index Match
... models. You can also develop reports with data coming from many different sources. With these formulas you can virtually create relational databases in Excel and develop reports downstream. They are more powerful and versatile than LOOKUP formulas. The quantities sold are inExcel Index Match    Lesson 18 of 30: The INDEX/MATCH Formula With INDEX/MATCH you can automate your invoices, quotation workbooks, business
http://www.excel-vba.com/e-formula-index-match.htm - 2759 bytes - 5/12/2006 - text/html Cache
Hits: 301    Rating: 0 /10    Votes: 0    Comments: 0    Report this site


Excel Array Formulas
Excel Array Formulas    Excel Lesson 21 of 30: Array Formulas For years I have been promoting the use of ARRAY FORMULAS ... less limited much easier to handle that VLOOKUP. But there are some things that even INDEX/MATCH cannot do. The other Excel array formula that I use is INDEX/MATCH when I want to lookup a table based on criteria in more ...
http://www.excel-vba.com/e-array-formulas.htm - 2141 bytes - 5/13/2006 - text/html Cache
Hits: 333    Rating: 5 /10    Votes: 1    Comments: 0    Report this site


Excel Database Functions : Sort
Excel Database Functions : Sort   Sort the Data in an Excel Database If you try to sort column "A" and the other columns don't follow or the title ...
http://www.excel-vba.com/e-database-functions.htm - 1381 bytes - 4/16/2006 - text/html Cache
Hits: 152    Rating: 0 /10    Votes: 0    Comments: 0    Report this site


Excel Spreadsheets Tips
Excel Spreadsheets Tips   General Tips on Excel If you navigate a lot within a worksheet, between worksheets, between spreadsheets or between Microsoft applications, use the hyperlink ...
http://www.excel-vba.com/e-tips.htm - 1256 bytes - 4/16/2006 - text/html Cache
Hits: 306    Rating: 5 /10    Votes: 1    Comments: 0    Report this site

[ More results from www.excel-vba.com ]

excel.PDF
... interactivity to web worksheets 4 Use pivot tables 4 Create charts Developed by Scott Sample for Microsoft Corporation. Analyzing Data Using Excel 2 Analyzing Data Using Excel Rev2.01 Touring Excel Before you start using Excel 2000, become familiar with its features. The following illustration shows a new worksheet: Using Excel As an instructor, you have given quizzes, tests, and surveys over the web. You now have data files that are the ... Analyzing Data Using Excel
http://www.paec.org/planetdiscovery/earth/tutorls/workshops/excell/excel.PDF - 4008437 bytes - 2/1/2001 - application/pdf Cache
Hits: 179    Rating: 0 /10    Votes: 0    Comments: 0    Report this site


Excel - My Excel Pages
Excel - My Excel Pages My Excel Pages -- David McRitchie My Excel Pages:  http://www.mvps.org/dmcritchie/excel/excel.htm Copyright (C)1997 - 2006   F.  David McRitchie Brief Description -- My Excel Pages Excel macro solutions as building blocks with usage notes to help beginners and fairly advanced users work with Excel spreadsheets. Worksheet Formulas, VBA Macros, Backup & Recovery, Color Palette, Conditional Formatting, Event Macros, Excel Newsgroups, Response Time Considerations, Generating HTML, List of Functions and Subroutines, Shortcuts, Menus/Toolbars.  – David McRitchie (over 200 Excel web pages) Quick Reference to Other ...
http://www.mvps.org/dmcritchie/excel/excel.htm - 116114 bytes - 5/16/2006 - text/html Cache
Hits: 341    Rating: 0 /10    Votes: 0    Comments: 0    Report this site


Excel
Excel Excel Contents: Introduction Named Ranges Matrix Operations in Excel Introduction Microsoft's Excel spreadsheet program provides an alternative environment for many of the computations required for Macro-Investment Analysis. Its ubiquity ... preparing investment application programs. Here we concentrate on a a discussion of matrix operations in the standard Excel spreadsheet environment. The treatment will be cursory, at best since Excel ...
http://www.stanford.edu/~wfsharpe/mia/mat/mia_mat4.htm - 9933 bytes - 3/31/1999 - text/html Cache
Hits: 106    Rating: 0 /10    Votes: 0    Comments: 0    Report this site


Excel Tutorial
Excel Tutorial Welcome This is a basic tutorial of Excel. START HERE Specific examples may refer to Excel (but most items discussed should work in other spreadsheets). I might also add some more advanced examples w/downloads if there is interest ... This page is just for reference AFTER you have gone through the whole thing once. IT is recommended that you have EXCEL running at the same time. You can try what you are reading. On an PC you can toggle back and forth ...
http://www.usd.edu/trio/tut/excel/ - 3540 bytes - - text/html Cache
Hits: 715    Rating: 8 /10    Votes: 1    Comments: 0    Report this site


Excel Tutorial
... of a Workbook Topic Six: Advanced Excel (Copying Cells) Topic Seven: Linking Documents in Excel Topic Eight: Creating Charts What is Excel? Microsoft Excel is an electronic spreadsheet program. You might of heard the terms "spreadsheet" and "worksheet". People generally use them interchangebly ... values that depend on that first value automatically change when the spreadsheet is recalculated. Rows, Columns, and Sheets The Excel worksheet contains 16,384 rows that extend down the worksheet, numbered 1 through 16384. The
http://einstein.cs.uri.edu/tutorials/csc101/pc/excel97/excel.html - 9197 bytes - 5/10/2001 - text/html Cache
Hits: 168    Rating: 0 /10    Votes: 0    Comments: 0    Report this site



1  2  3  4  5  6  7  8  9  10  
Free Computer Education and Training Search