This video uses SUMIFS, COUNTIFS and AVERAGEIFS allowing us to set up multiple criteria prior to doing our calculation. Now, we can verify multiple conditions before doing our calculation.
Course: Excel Essentials
This course uses realistic business scenarios to show practical application for each technique. It is a comprehensive overview of the critical functions, applications and concepts necessary to proficiently use Excel.
Many people say they “know Excel” but after going through this course, you really will! The learning style includes on screen visual tips and directions to better accommodate visual learners. The audio style is casual and laidback to provide a little extra entertainment and humor.
I hope you enjoy my course!
Learn how to create a data table. Data tables are a great way to easily format your data and offer great options for analyzing and organizing the data. This video shows how you can sort the data in different orders.
Data tables are a great way to consolidate data and filtering lets us choose which data we want to see. The total row is a great feature that automatically updates after we filter our data. This video simulates a real world application of data table filtering and using the total row to answer business type questions.
Line charts are great for tracking data over time. Sometimes we want to compare different metrics on the same chart to see if they are moving together, or diverging. Unfortunately, one number may be measured in dollars ($) and another in percentage (%). When numbers are in very different scales, they are difficult to display in a meaningful way on a single chart. But, this video shows a great trick around this problem by applying a secondary axis, and like magic, the data can be compared!
This video looks at a basic column chart and shows how a little 3D effect can go a long way. Then, we show how stacking columns can help us compare revenue and expenses in each year. Finally, we throw profit margin into our revenue column chart – why? – because what is the point of making more sales if you can’t keep the money?…
Pie Charts are a great tool for analyzing dessert…ahem…I mean categorical data. In this video, the pie charts show a visual distribution of our website visitors over the two years. I also show you how to adjust the legend and data labels to maximize your charts impact!
Stacked charts are a great way to analyze categorical data over time. In this example, we analyze the changing mix of website visitors over time by stacking the values in each year. Stacked charts make it easy to visually see changes in customer mix.
Scatter charts are used when we have one variable the predicts another variable – meaning each point on the graph is a combination of two variables. In English – we are going to explore how hours studying affects your test grade. Naturally, the chart shows a positive relationship between studying and your test score. I even through in a trend line with basic regression analysis for some statistical fun:)
Excel is the ultimate calculator. But with thousands of rows and columns, it can be quite intimidating! But don’t worry, this video will have you pointing and clicking your way through formulas in not time:) And, we even cover how to fix your mistakes so you’ll be golden.
Once you have completed your spreadsheet, it is a good idea to make it look pretty before presenting it to your boss. Even if your calculations aren’t the most complicated (or correct…), aesthetics can go a long way. In this video, I walk you through some basic formatting techniques so you can ensure all your spreadsheets look nice.
