Want to be an Expert in Excel?
Learn Excel Functions and Formulas with 300+ clearly illustrated Examples. You can ask any Excel questions and get our Free solutions.

Start Learning Ask a Question
Top Functions

See our most viewed chapters amongst over 100+ chapters.

COUNTIFS
This counts the cells within a specified range of cell references that meets the multiple criteria that you specify.
=COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]… , [criteria_range127, criteria127])
VLOOKUP
This searches the value (row label) specified within the first column of the table (cells range) and returns the corresponding value in...
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
IF
This evaluates a logical argument and returns the values as specified in TRUE or FALSE statements.
=IF(logical_test, value_if_true, [value_if_false])
MATCH
This searches a specified value within the specified column (cells range) and returns the relative position of the...
=MATCH(lookup_value, lookup_array, [match_type])
SUMIFS
This returns the average of numeric values range that meets multiple criteria.
=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], …[criteria_range127, criteria127])
Learn all chapters >
Function Categories

All functions in the excel are categorized to following categories as per their functionalities. If you are a beginner to Excel, it is recommended to follow all chapters in these categories.

All Functions >
Learn all functions in date & time, math & trig, statistical, lookup & reference, database, text, logical and information categories.

Learn more
Featured Functions >
Learn most advanced functions in all categories. These functions may help you to solve most of the practical excel issues.

Learn more
Date and Time Functions >
These functions help you to find no of days, months, years and seconds, minutes, hours between two date or time values ect.

Learn more
Math & Trigonometry Functions >
These functions for mathematical calculations such as find sum, round, product, find remainder, find a random number ect.

Learn more
Statistical Functions >
These functions for statistical calculations such as average, count, rank numbers, find maximum or minimum number ect.

Learn more
Lookup & Reference Functions >
These functions let you to match values, search values in a data range, analyze data, find corresponding values ect.

Learn more
Database Functions >
These functions help you to find sum, average, count, product, maximum or minimum number in a database using various conditions.

Learn more
Text Functions >
These functions allow you to combine multiple texts, find left right middle texts, convert text to number, change text case etc.

Learn more
Logical Functions >
These functions evaluate logical arguments and return TRUE or FALSE logical values. Regularly use by experts.

Learn more
Information Functions >
These functions help you to check whether the cell value is an error, blank, text, number, odd value, non-text, logical or formula.

Learn more
How to be an Excel Expert?
Excel has 400+ functions that can be applied for various scenarios. To become an expert, no need to learn all the functions in Excel. We have described most important excel functions from the beginning with simple examples. Follow the all chapters to learn how you can use the excel functions.
How to get our Expert's Solutions?
Struck? There may be lot of practical issues when applying functions and formulas. We are ready to provide our free guidance and support to solve your excel issues. Sign up and start asking your excel questions.
What are the Featured Functions?
We have identified most advanced excel functions among all excel functions and categorized as 'Featured' to make your studies easy and interesting. These functions will help you to solve most of the practical issues.
Sign In & Ask
Existing member? Sign in to your Account and start asking your excel questions. We are ready to provide our free solutions.
Join with Us
We welcome you to improve, share and build your knowledge and career. Create your Much Excel account and join to our community.
Recent Questions
Convert a Number to Words in Excel
How to convert a Number to words using a excel function?...
Simple Library Management & Checkout System
How to design a Library Management & Checkout System using excel funct...
Get total amounts for each reference number
I have a database with Reference number and amounts. Same reference nu...
Daily Stock Report Manual Entry In Excel
Dear Sir, I am facing difficulties to when i enter data manually in th...
One item in sheet multiple rows how to search
Dear Sir, I am facing difficulties to search one item when i use find...
Search One Item multiple rows and filter data in sheets seperately
Dear Sir, I have data attached and i want to one item search multiple...



Featured Functions
AND
This returns TRUE if all conditions are True, and returns FALSE if any...
AVERAGEIF
This returns the average of numeric values range that meets the criter...
AVERAGEIFS
This returns the average of cells range that meets multiple criteria....
COUNTIF
This counts the cells within a specified values range that meets the c...
COUNTIFS
This counts the cells within a specified range of cell references that...
HLOOKUP
This searches the value (column label) specified within the first row...
Our mission
Much Excel is the website that provides the best excel tutorials for those who want to be an expert in excel. Not only that, now you can ask your own excel questions and get our free solutions from our experts.
Home | Functions | Questions | Ask Question | Terms and conditions | Contact us


www.muchexcel.com
Powered by Much Capital Holdings
Since 2017
12/11/2018 4:32:16 AM