Use Excel Tables to save you hours of time with formatting, formulas, and calculations.
🔥 Take our Power BI Course: https://www.careerprinciples.com/courses/power-bi-for-business-analytics
🆓 DOWNLOAD Free Excel file for this video: https://careerprinciples.myflodesk.com/p2ysu49zxw
Not using Excel tables is one of the most common mistakes in Excel. In fact, this mistake has cost me hours of time. So in this video we go over why you should use Excel Tables, and how they're going to save you hours of time. First, with Excel tables, you won't need to format data by adding a header color, a border, etc. Instead, you just need to convert the data into a table, and it formats automatically. Second, you don't need to use the $ sign for relative referencing. Instead, with Excel tables, the ranges are fixed automatically. We show an example of this with SUMIFS. If you add new data, these are also automatically included in the range. Third, with the total row option, we can easily calculate the SUM, AVERAGE, MIN, and much more without needing to use functions. Fourth, we can use Slicers instead of a traditional filter. Slicers are visually more elegant and user friendly.
LEARN:
👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance
📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course
🚀 All our courses: https://www.careerprinciples.com/all-courses
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Automatic Formatting with Tables
1:17 - Frozen Headers
1:56 - No more $ Sign
4:57 - Dynamic Ranges
6:19 - New Columns
7:15 - Calculations Without Formulas
8:19 - Filter Alternative
9:35 - Remove Table Format