April 19, 20267 min read
Conditional SUMPRODUCT for Data Analysis in Excel
Conditional SumProduct. Using SumProduct with conditions to exclude data that does not meet a certain criterion.
Garfield Stinvil
G
Garfield Stinvil
48 articles
Garfield is an experienced software trainer with over 16 years of real-world professional experience. He started as a data analyst with a Wall Street real estate investment company & continued working in the professional development department at New York Road Runners Organization before working at Noble Desktop. He enjoys bringing humor to whatever he teaches and loves conveying ideas in novel ways that help others learn more efficiently.
Since starting his professional training career in 2016, he has worked with several corporate clients including Adobe, HBO, Amazon, Yelp, Mitsubishi, WeWork, Michael Kors, Christian Dior, and Hermès.
Outside of work, his hobbies include rescuing & archiving at-risk artistic online media using his database management skills.
Articles
April 19, 20264 min read
Date Analysis with Pivot Tables: Grouping and Timelines
Pivot Tables, Grouping, and Timelines. In this section, we'll look at how Pivot Tables make it really easy for you to work with dates in...
Garfield Stinvil
April 19, 20267 min read
Top N Filters with Parameters for Data Visualization
We're going to create another parameter just to show you another way that it's useful.
Garfield Stinvil
April 19, 202610 min read
Mixed Cell References in Excel Formulas
Advanced cell locking. Create powerful formulas by locking either the column or the row or both.
Garfield Stinvil
April 19, 20263 min read
HLOOKUP: Mastering Horizontal Data Searches
HLOOKUP. HLOOKUP is exactly like VLOOKUP except for two things.
Garfield Stinvil
April 19, 20264 min read
Joining Text in Excel: Using Concatenate and Ampersand
Joining Text. In this section, we're going to take a look at joining text.
Garfield Stinvil
April 19, 20265 min read
Creating Line Charts in Excel
In this section, we're going to go over how to create a basic line chart. Now, when you're selecting the information for creating your...
Garfield Stinvil
April 19, 202610 min read
Statistical Measures: Percentiles and Quartiles Explained
Measures of position. We're going to take a look at two types of measures of position when it comes to statistics.
Garfield Stinvil
April 19, 20269 min read
Excel's Autosum: Simplifying Calculations
AutoSum functions. Excel's AutoSum functions help you to automate your calculations when it comes to coming up with answers for complex...
Garfield Stinvil
April 19, 20264 min read
Match Function: Finding Positions in Rows and Columns
VLOOKUP and the MATCH function. The MATCH function serves a single purpose.
Garfield Stinvil
April 19, 20265 min read
Inserting, Deleting, Hiding, and Grouping Rows and Columns
Rows and columns. In this section, we'll take a look at how to insert, delete, hide, and group rows and columns.
Garfield Stinvil
April 19, 20266 min read
Calculating Weighted Averages Using SUMPRODUCT and Conditions
This topic is called statistics according to the worksheet tab at the bottom, but it's basically an overview of the SUMPRODUCT function and...
Garfield Stinvil
April 19, 20267 min read
Paste Special: Excel Skills with Key Techniques
Paste Special. In this section, we will use Paste Special to apply formats as well as perform calculations on selected cells.
Garfield Stinvil
April 19, 202611 min read
Visualizing Data with the Normal Distribution Curve in Excel
The normal curve is a visual representation of the bell-shaped curve. That is something we have yet to create and we're actually going to...
Garfield Stinvil
April 19, 20267 min read
Excel's True-False Comparisons for Data Analysis
The true/false statement. What does the true/false statement do?
Garfield Stinvil
April 19, 20269 min read
Skewness and Kurtosis in Descriptive Statistics
Descriptive statistics. Our first topic for descriptive statistics is related to something called skewness and also something called...
Garfield Stinvil
April 19, 20267 min read
Excel's User Interface: Key Features Explained
The Microsoft Excel User Interface. We're going to start this particular video off by talking about the Quick Access Toolbar.
Garfield Stinvil
April 19, 20264 min read
Advanced Formatting Techniques for Data Sheets
I'll just mention again that when you go into the formatting sidebar, you can do more than just formatting fields.
Garfield Stinvil
April 19, 20269 min read
Probability: Events, Expected Values, and Conditional Outcomes
Probability 2. We're going to take a look at a couple more probability exercises.
Garfield Stinvil
April 19, 20264 min read
Navigate Data: Mastering Freeze Panes in Spreadsheets
Freeze panes. In this section, we're going to discuss how you can lock rows and columns to be able to efficiently view your data as you...
Garfield Stinvil
April 19, 202610 min read
Predicting Future Data Trends in Excel with Forecasting Techniques
Forecasting. In this section, we're going to take a look at forecasting at a more extensive level.
Garfield Stinvil
April 19, 20267 min read
Excel Solver for Optimal Decision-Making and Profit Maximization
Solver overview. Solver is a tool that's available right next to the data analysis tool pack.
Garfield Stinvil
April 19, 20267 min read
Multi-Chart Visualizations with Shared Axes
Our next topic is creating multi-chart worksheets. Multi-column rows and charts.
Garfield Stinvil
April 19, 202610 min read
Creating and Organizing Data Groups
Groups. This is a little different. Like sets, groups are a method of subdividing a single dimension.
Garfield Stinvil