Numbers for Mac - A Journey from Beginning to Advance level

Navigate the numbers interface, divided into four sections: menu bar, a bar with icons, inspector, and work area. Start with a template such as a budget sheet to enter data.

Learn to save, open, rename, and duplicate Numbers files on Mac, including choosing a save location, using the file menu, and keyboard shortcuts.

Discover how to work with sheets in Numbers for Mac, including understanding sheet naming, default behavior when adding new sheets, and managing the sheet container.

Master how to add multiple sheets in Numbers for Mac, use keyboard shortcuts to insert and navigate between sheets, and save time through efficient workflow practices.

Rename sheets and learn duplicating with Numbers for Mac, using keyboard-driven steps to work with sheets.

Learn to duplicate and delete sheets in Numbers for Mac, and organize your work efficiently.

Move sheets around using mouse controls to position elements toward a desired base, observe visual adjustments, and build practical skills in user interface placement.

Explore how tables organize data in Numbers for Mac, with rows, columns, and headers. Learn to resize columns by dragging grid handles to tailor your table.

Learn to rename and resize tables, apply table styles, manage header and footer, and insert new tables in Numbers for Mac.

Learn to add and manage headers and footers in Numbers for Mac, including page numbers, dates, and names, to ensure consistent printing across all pages.

Learn to insert and delete rows and columns in Numbers for Mac using three methods: right-click, insert above or below, and insert before or after.

Learn how to hide and unhide rows and columns in Numbers for Mac, select multiple rows or columns with shift, and manage visibility to keep your worksheet organized.

Adjust font size, outlines, and gridlines in Numbers for Mac to format tables. Control borders, colors, dotted lines, and header or column headers to tailor appearances.

Enable alternating colors for rows and columns in Numbers for Mac, and resize rows or columns to fit content while removing unnecessary space.

Learn how to add a new table within a sheet in Numbers for Mac, using the toolbar insert option or an alternative method to insert tables as needed.

Learn how cells in a Numbers spreadsheet are named by combining column letters and row numbers, how named cells simplify formulas, and how copying and pasting data works.

Enter data into a selected cell and navigate with the tab key. Copy data across cells using the copy editor or drag-fill, and move content between cells across rows.

Learn to apply fill to cells and add borders in Numbers for Mac by selecting multiple cells, choosing colors or gradients, and configuring borders in the format section.

Use autofill in Numbers for Mac to quickly fill cells with a repeated value or a defined sequence, like months or days of the week, by dragging the fill handle.

Learn how to format cell content in Numbers for Mac, including applying currency symbols, adjusting decimal precision, and choosing date, time, and text formats to present data clearly.

Master merging cells in Numbers for Mac, center and align text in the table using the format and table options, and apply merge commands to create a clean layout.

Explore how to use simple formulas in numbers for mac to calculate sum, average, minimum, maximum, and product, then create custom formulas and apply them across data from two tables.

Explore complex formulas in Numbers for Mac, using functions like count, max, and average to analyze a student table, enter formulas with =, and select ranges.

Learn to create and apply custom formulas in Numbers for Mac using the formula box and formula bar, performing addition, subtraction, and cell-based calculations, and reuse formulas with fill handle.

Discover grouping formulas in Numbers for Mac by building custom functions and combining the sum function with division and averages to perform complex operations.

Learn how the count function in Numbers for Mac counts numeric values while ignoring text. Use countif with a range and a quoted criteria, such as greater than 20.

Apply the if function in numbers to evaluate a condition and decide pass or fail for student grades, and learn pricing rules with prices greater than 10000 increasing or decreasing.

Learn absolute and relative cell referencing in Numbers for Mac, see how formulas adjust when copied, and use dollar signs to lock rows and columns for accurate results.

Explore basic charts in numbers, including bar graphs (color charts), pie charts, and stacked column charts; understand x and y axes, regions, and how interactive charts present data in stages.

Create and customize charts in Numbers for Mac, selecting data ranges, choosing chart types, and formatting axes, colors, gaps, background, and positions with the inspector.

Create interactive 3d and pie charts in Numbers for Mac, format visuals, customize colors, and observe stage-by-stage changes, including names of students as data updates.

Learn to insert text and shapes into a Numbers for Mac worksheet, resize text with the drag handle, and format text using different styles and shapes.

Sort data by selecting a column and choosing ascending or descending order, using sort or filter options to apply the desired order (e.g., column b).

Filter data in numbers for mac using the third option to extract values from large tables, with practical steps for isolating members by amount paid or join date.

Create a custom filter in Numbers for Mac to perform complex data extractions. Select the column, apply starts with or ends with, add rules, and manage or delete filters.

Learn to insert a checkbox in Numbers for Mac and use a formula to conditionally populate tables when the box is checked or unchecked.

Learn to build an interactive star rating in Numbers for Mac. Use a 1–5 rating and conditional formulas to classify books as good or bad based on the rating.

Explore creating an interactive slider in Numbers for Mac to set a min–max range, connect to a volume table, and apply conditional logic for values below or above 50.

Learn to build interactive pop up menus in Numbers for Mac, with pre-populated items, default values, and minus and up-down controls, and create your own custom menu.

Learn to create a custom format for selected column in Numbers for Mac, name it, and use a text box to prepend or append text like Mr. to names.