Learn the power of grouping! When sheets are grouped together, we can edit all of them at the same time. This can be extremely useful when we are analyzing multiple departments or employees all with the same template. Also, grouping can be done within a formula to save time referencing multiple sheets.
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!
In this part of the project, we cover how to format our data to make it a little nicer before getting started. You’ll learn how to adjust column widths, create a nice header row, and some cool keyboard shortcut formatting. It’s always a good idea to make your spreadsheet look nice before doing calculations as it makes it much easier to work with.
Calculate each student’s grade and see who mastered their course! and who, well, didn’t do to well…We also apply the Vlookup function to assign each student a letter grade based on their percentage score.
In this video we calculate some basic statistics with the MIN, MAX, AVERAGE and STDEV functions followed by creating a frequency distribution of the grades. This distribution lets us see how many students earned each grade as well as the percentage of students earning each grade.
This video covers how to create a data table in Excel. Data tables allow us to sort and filter our data so we can analyze different segments of data. It also covers how to use a Total Row for some quick and easy calculations.
Sometimes a list of numbers isn’t the easiest way to display data. So, in this video we create a beautiful chart (histogram to be precise) to show how the students did. The video explores a variety of ways you can edit your chart so you can customize it to match your company’s style.
Before you can start analyzing a pivot table, it helps to know how to make one to begin with:) This video shows you how to easily create our own pivot table and understand how to manipulate the fields to display the data you want to see. We also demonstrate how to do some frequency analysis with running totals as actual numbers and percentages.
Pivot tables can be used to display data in a variety of calculations. We can look at a percentages of the grand total or analyze particular segments of our data. This video demonstrates some real world applications of the power of pivot tables with the percent of row total, percent of column total and percent of grand total options.
When analyzing large amounts of data, we often want to only view a certain segment. Pivot tables allow us to filter our data so we can look at relationships in a subset of data. For example, if we have national data, we might want to look only at the performance of our advertisement in Florida – thus we would filter the data to only show values which are from Florida. Why Florida though? I happen to live here so I’m a little biased:)
This video shows the power of the SUMIF, COUNTIF, and AVERAGEIF functions. These are great if we only want to analyze a specific segment of our data. Sure, we could filter it and use the total row to find out the answer, but then if someone changes our filter…well…then our answer is gone:( So these functions are great for analyzing data without worrying about how it is sorted or filtered.
