Numbers - Beyond The Basics - Preview

Lee is a nerd that has to work with spreadsheets a lot in his professional life and over the years has had to learn some of the more advanced functionality that Numbers can provide. So in this show, he's decided to share some of that with you and look at some functions that may have previously seemed quite daunting.

If you want to know how XLOOKUP can make pulling references from other tables a breeze, how functions like SUMIF and COUNTIF can add another dimension to your summaries, then this is the video for you. You also learn how to use nested functions, validate data entry, and format text automatically with functions like PROPER and TRIM. Lee had a lot of fun recording this one and certainly hopes you enjoy learning new tricks in Numbers.

This video covers:

• Absolute vs Relative References
• IF Function
• AND Function
• OR Function
• Conditional Highlighting
• COUNTIF Function
• SUMIF Function
• AVERAGEIF Function
• SUMIFS Function
• XLOOKUP Function
• Nested Functions - TRIM and PROPER
• Nested Functions - Calculations
• Cross-Referencing Sheets and Tables
• Data Validation
• Using Tickboxes in Formulas
• Using Star Ratings in Formulas
• Putting It Together

Application Download

Download Numbers

Resources

Show 1436 - Don’s Top 10 Numbers Tips

Show 1167 - Numbers - Pt 1

Show 1171 - Numbers - Pt 2

Show 1177 - Numbers - Pt 3

Show 1101 - Pivot Tables in Numbers