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

Hits: 19    (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: 7  (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: 7    (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: 271    (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: 16    (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: 240    (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 First in – last out times 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 First in – last out times in Excel.   Excel formula for Beginners – How to find First in – last out times in Excel Generic formula =MINIFS(times,names,name,actions,action) Summary To get …

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

Hits: 10   (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: 13    (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 …

Excel formula for Beginners – How to Count unique values with criteria in Excel

Hits: 16   (Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to find Unique values by count in Excel.   Excel formula for Beginners – How to Count unique values with criteria in Excel   Generic formula =COUNTA(UNIQUE(FILTER(range,criteria))) Summary To count unique values with …

SQL tutorials for Business Analyst – SQL | Transactions

Hits: 65 (SQL tutorials for Business Analyst & Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: SQL | Transactions.   SQL tutorials for Business Analyst – SQL | Transactions   A transaction is a unit of work that is performed against a database. Transactions are units or sequences of …

SQL tutorials for Business Analyst – SQL | Having Clause

Hits: 52 (SQL tutorials for Business Analyst & Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: SQL | Having Clause.   SQL tutorials for Business Analyst – SQL | Having Clause   The HAVING Clause enables you to specify conditions that filter which group results appear in the results. The WHERE …

SQL tutorials for Business Analyst – SQL | Using Views

Hits: 29 (SQL tutorials for Business Analyst & Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: SQL | Using Views.   A view is nothing more than a SQL statement that is stored in the database with an associated name. A view is actually a composition of a table …

SQL tutorials for Business Analyst – SQL | TRUNCATE TABLE

Hits: 24 (SQL tutorials for Business Analyst & Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: SQL | TRUNCATE TABLE.   The SQL TRUNCATE TABLE command is used to delete complete data from an existing table. You can also use DROP TABLE command to delete complete table but it would remove …

SQL tutorials for Business Analyst – SQL | ALTER TABLE

Hits: 14 (SQL tutorials for Business Analyst & Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: SQL | ALTER TABLE.   The SQL ALTER TABLE command is used to add, delete or modify columns in an existing table. You should also use the ALTER TABLE command to add and drop various …

SQL tutorials for Business Analyst – SQL | Indexes

Hits: 26 (SQL tutorials for Business Analyst & Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: SQL | Indexes.   Indexes are special lookup tables that the database search engine can use to speed up data retrieval. Simply put, an index is a pointer to data in a table. An index …