You Suck at Excel - Joel Spolsky (Reupload) #
This video is a reupload of a popular video by Joel Spolsky, a well-known software engineer and entrepreneur. The original video appears to have been lost, but this reupload was salvaged from the Wayback Machine archive.
10 Excel Formulas That Will Set You Apart (Cheat Sheet) #
This video provides a cheat sheet of 10 powerful Excel formulas that can significantly improve your spreadsheet skills. It's aimed at users who want to move beyond basic Excel functions and learn more advanced techniques.
- SUMIF: This formula allows you to sum values in a range based on specific criteria. For example, you could use it to sum all sales figures for a particular product.
- COUNTIF: Similar to SUMIF, but instead of summing values, it counts cells that meet specific criteria. For example, you could use this to count the number of times a specific product appears in a list.
- VLOOKUP: A versatile function for searching for specific values in a table or array. It can be used to retrieve data from another column or sheet based on a chosen value.
- AVERAGEIF: A combination of AVERAGE and IF functions, used to calculate the average of values meeting specific criteria.
- SUMIFS: This function allows you to sum values based on multiple criteria, providing more flexibility than SUMIF.
- COUNTIFS: Works similarly to COUNTIF but lets you apply multiple criteria for counting cells.
- INDEX & MATCH: A powerful combination to look up values in a table based on multiple criteria.
- LOOKUP: A simplified function for searching for values in a single column.
- IFERROR: This function handles errors that might occur with other formulas, allowing you to display a customized message or perform a different action when an error is encountered.
- CHOOSE: Useful for selecting a value from a list based on a given index.
"These formulas will help you become a spreadsheet ninja." (Speaker)
Watch the video for detailed explanations of each formula and practical examples.