This is an excerpt from Pierre Leclerc (www.excel-vba.com)
The 2 Most Important
Excel Functions AND
Excel Functions and Formulas Sitemap
This website is divided in 4 sections:
Section 1: Useful Excel Functions by Category
Section 2: Special Excel Functions
Section 3: Other Pages on Excel Functions and Formulas
Section 4: Annexes on All Functions by Category
The most useful and powerful function in Excel
has not changed much since the 1980's but the computer on your desk has changed dramatically. It
is hundreds of times faster and more powerful than 10 years ago. It is
also connected to multiple sources of data within your enterprise and
connected to data sources from around the world through the Internet.
Due to these changes to your computer and its network, Excel macros have become powerful tools to develop data analysis and reporting program.
With 45 years of expertise as C.E.O. and owner of my company, I will help you
develop powerful solutions to do more with your business data.
SUMPRODUCT ¦ INDEX/MATCH ¦ SUBTOTAL ¦ ISERROR ¦ HLOOKUP ¦ LOOKUP ¦ VLOOKUP
AVERAGEIF ¦ AVERAGEIFS ¦ COUNTIF ¦ COUNTIFS ¦ SUMIF ¦ SUMIFS ¦ IFERROR
Retour à la page d'accueil