MacMost Course: Mac Numbers Fundamentals Intro (00:00:00) Documents, Sheets and Tables (00:00:25) • Launching Numbers • Choosing templates • Blank document • Document window • Sheets • Tables • Cells • Rows and columns • Column letters • Row numbers • Cell references • Selecting cells • Saving documents Cell Basics (00:03:57) • Entering cell values • Moving between cells • Editing cells • Deleting cell contents • Numbers • Text • Dates • Automatic data recognition • Actual values • Checking cell types • Cell display vs. cell value Formula Basics (00:07:37) • Formula entry • Equals sign • Cell references • Typing formulas • Clicking cells in formulas • Addition and subtraction • Editing formulas • Formula results • Live recalculation • Formula references Table Basics (00:11:34) • Sample documents • Database-style tables • Rows as records • Columns as fields • Header rows • Header columns • Adding new rows • Entering rows of data • Table controls • Resizing tables • Adding columns • Deleting rows and columns • Table names • Multiple tables • Multiple sheets Cell Formatting and Styling (00:20:36) • Formatting currency • Decimal places • Thousands separators • Selecting value cells • Double-clicking column letters • Adjusting column widths • Date formats • Text alignment • Font changes • Cell fill colors • Text colors • Borders • Header styling • Table styles Basic Calculations (00:28:12) • Formatting sales data • Month and year dates • Selection calculations • Sum • Average • Minimum and maximum • Count • Adding total columns • Manual addition formulas • SUM function • Function browser • Cell ranges • Autofill formulas • Footer rows • Footer calculations • Column totals • Header references • Row totals • Formula copy behavior • Relative references • Simple financial totals • Income totals • Expense totals • Net totals Sorting and Filtering Tables (00:46:11) • Sorting by column • Ascending sort • Descending sort • Keeping rows together • Sorting by title • Sorting by author • Sorting by year • Grouping by sorting • Sort sidebar • Multi-column sorting • Sort priority • Re-sorting new data • Filters • Quick filters • Filtering by value • Multiple filters • Filtered row visibility • Turning filters off Charts (00:55:57) • Selecting chart data • Chart button • 2D charts • Line charts • Header labels • Chart sidebar • Chart styles • Chart title • Legend • Axis options • Multiple series • Resizing charts • Series colors • Data labels • Bar charts • Charting selected rows • Pie charts Pivot Tables (01:03:22) • Creating pivot tables • New sheet for pivot table • Pivot options • Selecting source columns • Row fields • Date grouping • Year-month grouping • Value fields • Expense totals • Category breakdowns • Reordering fields • Column fields • Pivot table summaries • Updating source data • Refreshing pivot tables • Changing calculations More Advanced Functions and Formulas (01:12:21) • Starting balance table • Running balance • First-row formulas • Copying formulas down • Formula continuation • SUMIF • Category totals • Criteria values • Referencing another table • Summary tables • Conditional sums • Expense breakdowns More Cell Formatting (01:18:56 • Star ratings • Steppers • Sliders • Checkbox values • True and false values • Pop-up menus • Creating pop-up choices • Reusing pop-up menus • Data entry controls • Duration values • Duration formatting • Date and time formats • Custom formats • Conditional highlighting • Highlighting rules • Color scales • Preserving actual values Logic Functions (01:34:26) • Filtering checkbox values • TRUE and FALSE • IF function • Comparison expressions • Returning text • Returning numbers • AND function • OR function • Nested logic • Combining conditions • Boolean results • Logic-based labels • Counting matching rows • Logic with checkboxes Lookup Functions (01:43:36) • Lookup tables • Automatic categories • LOOKUP function • Search values • Search ranges • Result ranges • Referencing another table • Filling lookup formulas • Handling missing matches • XLOOKUP function • Exact matches • Lookup return values • Replacing manual entry • Updating lookup data • Separate data tables Sheet Design and Printing (01:54:22) • Sheet as canvas • Adding text boxes • Formatting text • Moving tables • Selecting objects • Adding shapes • Shape styles • Lines and arrows • Callouts • Arranging objects • Print setup • Page orientation • Scaling • Page margins • Print preview • PDF output Exporting and Importing (02:01:46) • Exporting to PDF • Exporting to Excel • Excel compatibility • Summary worksheets • One worksheet per sheet • One worksheet per table • Checking Excel results • Formula compatibility • Exporting CSV • Exporting TSV • Importing Excel files • Importing CSV files • Dragging files into Numbers • Copying data between apps • Preserving formatting • Sharing Numbers documents Next Steps (02:12:18)