Excel Examples for Beginners

Statistics for Beginners – Introduction to Excel Data Analysis Tools

Hits: 19 (Basic Statistics for Citizen Data Scientist) Excel Data Analysis Tools Excel provides a number of data analysis tools, which are accessible via Data > Analysis|Data Analysis. If this option is not visible you may need to first install Excel’s analysis tool pack. This is done by selecting Office Button > Excel Options > Add-Ins in Excel …

Statistics for Beginners – Introduction to Excel Sorting and Filtering Functions

Hits: 4 (Basic Statistics for Citizen Data Scientist) Sorting and Filtering Functions Excel Functions: Excel 365 provides the following sorting and filtering array functions. SORT(R1, sortcol, order): returns an array with the data in R1 in sorted order based on the elements in column sortcol (the “sort key”) of R1 (default 1). If order = 1 (default), the sort is in …

Statistics for Beginners – Introduction to Excel Array Formulas and Functions

Hits: 26 (Basic Statistics for Citizen Data Scientist) Array Formulas and Functions Excel also allows you to define a formula that assigns values to a range of cells at the same time. These are called array formulas and they will be used quite often throughout this website. Array formulas We now show how to create formulas …

Statistics for Beginners – Introduction to Excel User Interface

Hits: 5 (Basic Statistics for Citizen Data Scientist) Excel User Interface The entire interface is as follows: Figure 1 – Excel User Interface This is the layout used in Excel 2007. The layout in Excel 2010 and Excel 2013 and later versions of Excel are almost identical. The key components are as follows: Title Bar – …

Excel formula for Beginners – How to find Maximum value with if condition

Hits: 32      (Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to find Max value with if condition.   Excel formula for Beginners – How to find Max value with if condition Generic formula {=MAX(IF(range=criteria,values))} Summary To get a maximum value based on …

Excel formula for Beginners – How to find Max value

Hits: 23    (Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to find Max value.   Excel formula for Beginners – How to find Max value Generic formula =MAX(range) Summary To get the maximum value from a set of numbers, use the MAX function. In …

Excel formula for Beginners – How to find Maximum if multiple criteria

Hits: 20    (Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to find Maximum if multiple criteria.   Excel formula for Beginners – How to find Maximum if multiple criteria Generic formula {=MAX(IF(rng1=criteria1,IF(rng2=criteria2,values)))} Summary To get the maximum value in a data set based …

Excel formula for Beginners – How to find Max value with variable column

Hits: 26    (Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to find Max value with variable column.   Excel formula for Beginners – How to find Max value with variable column Generic formula =MAX(INDEX(data,0,MATCH(column,header,0))) Summary To retrieve the max value in a set …

Excel formula for Beginners – How to find Max value on given weekday in Excel

Hits: 63    (Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to find Max value on given weekday in Excel.   Excel formula for Beginners – How to find Max value on given weekday in Excel Generic formula {=MAX(IF(TEXT(dates,”ddd”)=”Mon”,values))} Summary To find the maximum …

Excel formula for Beginners – How to find Max value in given month in Excel

Hits: 57  (Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to find Max value in given month in Excel.   Excel formula for Beginners – How to find Max value in given month in Excel Generic formula =MAXIFS(sales,dates,”>=”&G4,dates,”<=”&EOMONTH(G4,0)) Summary To find the maximum value …

Excel formula for Beginners – How to find Max value ignore all errors in Excel

Hits: 37    (Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to find max value ignore all errors in Excel.   Excel formula for Beginners – How to find max value ignore all errors in Excel Generic formula =AGGREGATE(4,6,values) Summary To get the maximum …

Excel formula for Beginners – How to find Max of every nth column in Excel

Hits: 629    (Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to find Max of every nth column in Excel.   Excel formula for Beginners – How to find Max of every nth column in Excel Generic formula {=MAX(IF(MOD(COLUMN(rng)-COLUMN(rng.first)+1,n)=0,rng))} Summary To get the max …

Excel formula for Beginners – How to find Larger of two values in Excel

Hits: 65    (Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to find Larger of two values in Excel.   Excel formula for Beginners – How to find Larger of two values in Excel Generic formula =MAX(value1,value2) Summary To get the larger, or greater, …

Excel formula for Beginners – How to find Large element with criteria in Excel

Hits: 938    (Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to find Large element with criteria in Excel.   Excel formula for Beginners – How to find Large element with criteria in Excel Generic formula {=LARGE(IF(criteria,values),n)} Summary To return the largest values in …

Excel formula for Beginners – How to find Unique values with multiple criteria in Excel

Hits: 22   (Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to find Unique values with multiple criteria in Excel.   Excel formula for Beginners – How to find Unique values with multiple criteria in Excel Generic formula =UNIQUE(FILTER(data,(range1=”b”)*(range2>5))) Summary To extract a list …

Excel formula for Beginners – How to find Distinct values in Excel

Hits: 18    (Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to find Distinct values in Excel.   Excel formula for Beginners – How to find Distinct values in Excel Generic formula =UNIQUE(data,FALSE,TRUE) Summary To extract a list of distinct values from a set …