Apple Numbers, Apple Pages, Apple Keynote - 3 in 1 Combo

Download the provided zip folder of premium resources containing all course materials and assignments, then unzip it on Windows or Mac to access practical, hands-on learning materials.

Learn how to open the Apple Numbers spreadsheet and access Apple’s official templates. Choose templates, start from scratch, save files, and reopen from stored locations.

Create documents in Apple Numbers by organizing content with unlimited sheets and multiple tables per sheet, then add, edit, and delete sheets and tables, and include charts as needed.

Explore how each table consists of cells organized into columns and rows, with unique addresses like C7 or F5, and learn keyboard navigation using arrows, tab, end, and enter.

Master advanced table management in Apple Numbers by adding, removing, and resizing rows and columns, editing data in edit mode, and inserting or deleting columns and rows with arrows.

Explore how to manage data in Apple Numbers by adding rows and columns, using arrows to insert data, and choosing before or after options to structure your spreadsheet.

Learn to customize titles and headers in Apple Numbers by renaming sheet labels for monthly receipts, adjusting header alignment and styles, adding photos, and using the footer for totals.

Explore how to apply diverse cell formats in Apple Numbers, including data formats, steppers and sliders with min/max limits, pop-up menus, star ratings, and date, time, currency, and decimal formatting.

Learn to use basic formulas in numbers by selecting a cell, typing equals, and referencing other cells to add, subtract, and multiply with examples like seven plus three.

Create an expenses report in Numbers by setting up a simple spreadsheet with headers for date, name, and cost, format dates and currency, and sum totals using multiple methods.

Learn how relative formulas work in Numbers and Pages, copy and paste formulas to new cells, and see automatic adjustment of references across rows and columns.

Master absolute formula implementation by fixing cell references with dollar signs, copying formulas across columns, and applying dynamic references for correct sums in Numbers.

Explore how to use formula functions in Apple Numbers, including sum and average, with live updates and practical examples that show applying various function categories to spreadsheets.

Perform calculations using footers in numbers and create sum formulas across a column. Watch totals update automatically as you modify data, with header and footer usage.

Create a practical checkbook in Apple Numbers using a basic template; input deposits, expenses, and starting balance, format dates and currency, and calculate and copy the balance formula.

Learn how to sort rows in Apple Numbers by ascending or descending order, apply sorting to entire tables or selected rows, and sort by multiple columns with advanced options.

Apply filters in numbers to show only rows with specific text, such as Apple, and learn to add rules for text, numbers, dates, or blanks.

Explore how to use the count if function in Apple Numbers to count how many times a specific text, such as Apple, appears in a data set, with practical examples.

Learn to create and connect tables across sheets in Apple Numbers, using formulas to sum values with cell references, and build cross-sheet calculations for quick answers.

Explore mortgage calculations using Apple Numbers templates, creating a mortgage calculator to compute monthly payments, total cost, and interest for a $20,000 loan over 10 years at 5 percent.

Apply practical spreadsheet skills to a car review demo: format text and numbers, set dates, use filters, pop-up menus, and count reviews for premium SUVs and luxury cars.

Explore how to view and customize borders in Apple Numbers, adjusting outlines, inside borders, colors, styles, and even no borders to highlight data.

Learn to customize Apple Numbers cells with fill colors, gradients, and text color, highlight multiple cells, format columns and rows, and save color templates to create attractive spreadsheets.

Explore conditional highlights in numbers to automatically color cells by rules, such as greater than five, between one and four, or less than five, for teaching.

Create charts in Numbers by selecting a table and choosing a chart, with automatic chart generation and style options to visualize sales data.

Discover how to customize charts in numbers with adjustable size, colors, fonts, shadows, borders, axes and labels, gradients and 3d options, plus real-time updates and chart placement.

Create and customize multi-column charts in Apple Numbers to compare sales data using 2D, 3D, interactive columns, and remove unwanted rows and columns.

Learn to create and customize a pie chart in Numbers by selecting data, inserting the chart, and adjusting 3-D options, labels, and wedge spacing.

Create a sales sheet in Apple Numbers using a data table and charts to analyze monthly sales for products A, B, C, D, with customization options.

Create and customize shapes in Numbers, Pages, or Keynote with fill, gradients, borders, shadows, and reflections; add text inside shapes, adjust fonts, alignment, bullets, and numbering, and manage layering.

Explore how to create and customize text boxes in Apple Numbers, Pages, and Keynote by adjusting fill, borders, text color, size, rotation, and adding links or copying and pasting text.

Learn how to add and customize images in Apple Numbers, Pages, and Keynote, including inserting logos, resizing, borders, reflections, exposure, and using internal or external images in spreadsheets and presentations.

Master layout and design in Apple Numbers, Pages, and Keynote, mastering print setup, page numbers, margins, and formatting of spreadsheets, tables, charts, and shapes, plus exporting to PDF.

Create a copper water product sheet in numbers by inserting an image, arranging text and tables, and calculating prices, discounts, and totals for a ready-to-print layout.

Explore how the if function in Apple Numbers evaluates logical tests, returning true or false (yes or no) when one cell is greater than another.

Master the and/or function in Apple Numbers by crafting if statements that compare cell values such as greater than and less than, returning true or false with quoted responses.

Learn to compute duration between dates in a spreadsheet by subtracting dates, view the day difference, and format results in days, weeks, hours, or minutes, and easily add durations.

Explore practical examples for managing due dates in a to-do list, using Numbers to set due dates, compute overdue status, hide completed or non-overdue items, and highlight upcoming tasks.

Learn to use the lookup function in Numbers to fetch item prices from a second table, apply the correct currency, and auto-calculate totals based on item and quantity.

Master text functions in Apple Numbers to combine words, insert spaces, and perform substitutions across cells, with practical examples and guidance for using dozens of text operations.

Master merging cells and wrapping text across tables in Apple Numbers, Pages, and Keynote, with centering, header insertion, and versatile text formatting.

Export spreadsheets from Apple Numbers to PDF, video, or Excel formats and share them via Mail or Airdrop, with universal browser-friendly viewing and PDF editing restrictions.

Create and customize sales charts in Numbers using a monthly ABCD data table; compare product performance and explore chart types, labels, and formatting for insight.

Explore the new stock and currency features in numbers—symbols, prices, market cap, and open values—plus chart and lead-line tools for portfolios and tracking net worth.

Explore the collaborate feature in the 3 in 1 suite to share sheets on iCloud.com, invite teammates, and enable easy collaboration and editing.

Discover new chart features in version 6.1, launched in 2018, including centering the chart title or placing it at the top right to improve clarity.

Download the premium zip file to access templates and images used in this course, unzip it on your computer, and practice with ready-to-use materials in your lessons.

Learn to create a new Pages document by locating Pages, downloading it, and opening a blank template. Save with Command-S and explore default templates such as reports, letters, and newsletters.

Learn how to manage page versions in Mac Pages by saving, browsing all versions, restoring previous versions, and copying content from earlier versions.

Rename a Pages document by editing the title, entering the new name, and pressing enter; duplicate to create versions for testing, then save to the download folder.

Learn to maximize focus by switching Pages documents to full screen using the green button, then minimize or exit full screen, while using the dock and toolbar.

Master selecting text in Pages using mouse and keyboard: double-click a word, triple-click a sentence, drag to select, and use shift with arrow keys to extend the selection.

Master copy, cut, paste, and undo in Apple Numbers, Pages, and Keynote by using keyboard shortcuts like Command+C, Command+V, and Command+Z, plus selecting all from the Edit menu.

Master inserting special and spatial characters in Pages by long-pressing keys to reveal options, selecting emojis and symbols, and using control-space and command-space shortcuts.

Master font properties in Apple Pages by selecting fonts, sizing text, applying bold, italic, underline, and color, and adjusting alignment, capitalization, and character spacing for paragraph styling.

Master paragraph styles to set titles, subtitles, and headings in Pages, and create custom character styles for consistent formatting, color, and emphasis across your document.

Learn how to control text layout in Pages by adjusting line spacing, paragraph spacing before and after, and left, center, or right alignment, with indentation.

Customize your document size and margins through the document options, header and footer controls, and page setup. Create a custom size from page setup and apply it to your file.

Learn how to insert page breaks and section breaks in Apple Pages to move content to the next page and keep topics separate, with a clear difference between the two.

Explore how to use page thumbnails in a document: view four pages, navigate between them, and manage which pages show as thumbnails, including selecting, shrinking, and hiding thumbnails.

Explore how to create and customize a two-column layout in Pages, including selecting text, adjusting column width, placing images, and comparing two-column versus single-column flow.

Master Apple Pages techniques to prevent orphan lines by adjusting line settings, keeping content on one page, or starting a paragraph on the next page.

Add text boxes in Pages by dragging a text box, typing content, and styling borders, colors, shadows, and reflections while wrapping around surrounding text.

Add images to Apple Pages by dragging into the page or using media, then refine with Instant Alpha, borders, shadows, cropping, and exposure adjustments.

Master adding and styling shapes in Apple Pages, including color, gradients, borders, and shadows, with text and images inside shapes.

Create and customize lines and arrows, adjust endpoints and stroke weight, colors, and dotted options. Draw with Apple Pencil to form custom shapes.

Discover how to convert Apple Pages between word processor and page layout, switch modes via documents or file menus, and use page layout templates for posters or certificates.

Demonstrates creating a one-page poster in page layout by showing rulers, removing header and footer, adding shapes, text, and images, applying color, borders, shadows, and layout alignment.

Master how to align, arrange, and group elements using grid lines, alignment guides, and distributing elements evenly, with grouping, front/back layering, and precise centering in Apple Pages.

Connect shapes with versatile connection lines, customize endpoints and color, add text and borders, group elements, and reuse a practice template to build flowcharts.

Create and customize bullet lists with letters, numbers, dashes, or images, explore bullet styles, adjust size, and master continuing and exiting bullets for clean note-taking.

Create and customize tables in Apple Numbers, Pages, and Keynote by building columns and rows, entering data, adjusting headers, colors, borders, and applying basic calculations with formulas.

Explore building and customizing charts in Apple Pages, including 2D and 3D charts, line and bar options, data tables, labels, colors, shadows, and interactive features.

Learn how to insert and customize links in Apple Pages, including pasting URLs, editing or removing links, and creating email links with subject and compose actions.

Add videos to your pages by dragging or inserting clips. Customize with borders, posters, and styles, then adjust playback, trim, and size while locking the video on the page.

Add audio to Apple Pages by inserting music from media or your library, replace the audio, adjust the volume, and position it anywhere in your document.

Learn to create and customize a table of contents in a document by using heading and subheading levels, inserting the table of contents, and viewing page numbers for navigation.

Learn how to add footnotes in Pages, insert and format footnotes, choose between document footnotes and page footnotes, and customize numbering and spacing for clear document explanations.

Enable and customize headers and footers across pages, insert and format page numbers (for example 1 of 4), and update header content automatically, with options to adjust color and bold.

Customize and modify templates in pages by selecting text, changing fonts and colors, and saving new templates for quick reuse.

Create a template from scratch in Apple Pages by setting placeholders for address, name, and date, saving it as a reusable template for future documents.

Learn to use Apple Pages to highlight text and add comments, explain words with contextual notes, and manage visible comments for clearer articles.

Collaborate with others via iCloud link sharing and track changes with accept or reject, versions, and markup to manage edits across Apple Numbers, Apple Pages, and Apple Keynote.

Export your Apple pages document in digital or physical form by using print, select a printer, adjust copies and page ranges, and preview in PDA format.

Learn how to export Apple Pages documents in multiple formats, including video format, Word, EPUB, plain text, and rich text, with password protection and cross-device compatibility.

Customize the Pages toolbar by dragging items, removing tools, and using icon-only or icon-with-text modes for actions like insert table, shapes, media, and text.

Learn to find and replace words in Apple Pages, count occurrences, and replace single or all instances, with options like match case and precise navigation.

Learn how to use Apple Pages to check spelling and grammar, enable automatic corrections, and recognize blue underlines and green grammar hints to polish your writing.

Explore layouts, borders, and rulers in pages, with content written inside borders, and learn to view layout, count words and characters, and manage spacing for single-page layouts.

Explore how to use the tab feature across Apple Numbers, Apple Pages, and Apple Keynote, moving right with tab stops, adding numbers, and aligning content with rulers and decimals.

Use section masters to add a watermark across every page by placing text or a logo. Adjust rotation, opacity, and position to personalize your watermark and safeguard your documents.

Learn to reduce file size in Apple Pages by compressing images, removing them when needed, and using the reduce file size tool to create an external reduced copy.

Protect Apple Pages, Numbers, and Keynote documents by setting, changing, or removing passwords, and securely export to password-protected PDFs.

Use the Mac Pages help from the help menu to read about pages, learn shortcut keys, undo, and navigate Section Masters, topics, and the search bar for support.

Explore web-based iCloud tools for Apple Pages and Numbers, enable online collaboration, set sharing permissions, edit across devices including Windows, and save or restore documents with iCloud Drive.

Demonstrate building a school project in Apple Pages using borders, bold titles, color, shapes, and images, with page numbers and author details for a Mars discovery project.

Design a landscape poster in Apple Pages page layout, using rulers, images, opacity, borders, shadows, and bold text to create a print-ready poster with contact details.

Discover how to add and manage bookmarks in your document, link text to bookmarks, and navigate between them with rename and delete options.

Learn to insert and format mathematical equations in Apple Numbers, Apple Pages, and Apple Keynote using built-in tools, LaTeX, and MathML.

Use the replace fonts feature to quickly swap fonts across your documents in Apple Pages, Apple Numbers, and Apple Keynote, creating consistent typography and simplifying edits.

Insert an image gallery in pages via media, select images to create a carousel, enable per-image captions or per-page descriptions, and adjust image order, theme, captions, and quality.

Explore facing pages to view and organize your document pages in one view, with live updates across headers and footers.

Edit master slides in keynote to design reusable templates and layouts for your articles and presentations. Create and apply personalized templates for different pieces, saving time on repetitive tasks.

Access a folder of practical examples and premium resources, download and unzip the zip file, extract on Windows or double-click on Mac, and use the included images templates for practice.

Learn to create a new Keynote document, choose themes or templates, work with multiple templates, and save your file to desktop or iCloud.

Learn to add and customize slides in keynote by choosing layouts, inserting or replacing images, editing text, applying bullets, and using undo and delete to refine your presentation.

Learn to arrange slides quickly by dragging with a long press, select multiple slides with command-click, and nest or detach slides to structure your presentation.

Learn how to present slides in Keynote using basic keyboard controls, including play, escape, skip, arrow keys, space, and clicking, to navigate and review your presentation.

Master alignment guides and grid lines in Keynote to precisely align and space shapes, copy and paste elements with shortcuts, and build clean, balanced slides.

Explore text basics in Keynote: create and edit text boxes, format font, color, and alignment; apply bullets, borders, shadows, gradients, and two-column layouts while learning text behavior inside layouts.

Explore practical text formatting in Apple Numbers, Pages, and Keynote by editing, styling, and customizing text with center alignment, bold, color, size, drop shadow, reflection, and bullets.

Learn to create and customize shapes in Apple keynote, including color fills, gradients, borders, shadows, and text, and save custom shapes for reuse.

Practice inserting and editing images in Keynote, from dragging and resizing to applying borders, shadows, reflections, and crop or instant alpha for transparent backgrounds, plus exposures, saturation, and sharpness adjustments.

Explore practical image handling in Keynote: resize a background image, adjust exposure, saturation, shadows, and text styling; duplicate images, add a logo, and customize colors and fonts for compelling slides.

Practice creating and styling an image-based slide by layering shapes, colors, shadows, and text, duplicating templates, and testing color variations for marketing or presentation visuals.

Create a photo slideshow in keynote by adding, resizing, and arranging images with shapes and text, and discover free image sources for your presentation.

Learn to design and connect shapes using lines, arrows, and curves in Apple Numbers, Apple Pages, and Apple Keynote, customizing endpoints, styles, colors, shadows, and straight, curved, and elbow connections.

Explore using lines and arrows in Apple Numbers, Pages, and Keynote, including connecting lines, endpoints, borders, colors, and shadows to map a car-purchase flow.

Draw with the pen tool in Keynote to create and customize shapes, connect lines, and annotate maps with colors, borders, and drop shadows.

Arrange shapes and text using align and distribute to center or create equal spacing. Group items to move together, control layering with back and front, rotate, and flip as needed.

Create and customize Keynote tables with templates, colors, headers, borders, and fonts, and apply formulas for calculations. See how Apple Numbers offers excel-like calculations for budgeting, loans, and stocks.

Create and customize 2D and 3D charts in Apple Numbers by editing data, adjusting colors, borders, shadows, and legends, and enabling chart titles to visualize and compare data effectively.

Explore creating and editing a table and its charts in Apple Numbers, including duplicating, resizing, entering monthly data, and switching between 2D bar, 2D line, and 3D chart styles.

Add and customize a video in your Keynote presentation by dragging it in, resizing, applying styles like shadows, reflection, blur, and color, then control playback, auto-start, loop, and poster frame.

Add and position audio in Keynote, and control playback with play, rewind, forward, and volume. Trim audio, set a repeat loop, and manage start behavior and on-screen visibility in presentations.

See how to create an animated keynote from scratch using video, audios, and stills, record audio with QuickTime player, and set auto animations and delays.

Learn to apply slide transitions in Keynote, choose effects like dissolve and droplets, and control timing with delay, duration, and direction.

Explore a practical transition example in Keynote, building a slide with text, shapes, colors, and a chart to show a losses-to-recovery narrative, and save the template for practice.

Explore object transitions in presentations by applying appear, blink, and dissolve effects to shapes and images, and control timing and order for automatic playback.

Learn to draw and animate lines in keynote, defining start and end points, applying line draw animations, timing, shadows, and previewing the result.

Master using magic move to animate shapes and other objects by duplicating them, applying the magic move effect, and adjusting each duplicated object to create automated, seamless motion.

Learn how to create a magic move animation by duplicating an object, zooming a map from north to south India, and linking scenes to produce a seamless flight path.

Learn to present Keynote slides by connecting to projectors or Apple TV, and customize the presenter display with notes, glow timer, and remaining time.

Learn to add and customize presenter notes for slides in the presenter view, including inserting links and reminders. Use notes to remember key points and guide your lecture whenever presenting.

Record keynote presentations with slide-by-slide narration, export the recording as video, and publish lectures on platforms like YouTube or Udemy.

Learn how to use the comment feature in Keynote to gather feedback on slides, shapes, and images, add and delete comments, and manage colors and visibility.

Learn to add and manage links in keynote slides by copying a website and pasting it, or right-clicking to link web pages, shapes, images, or emails.

Link slides to create interactive quizzes by connecting options to specific slides, adding buttons for feedback, and guiding learners to correct answers.

Learn how to create slide links in Keynote, using colored boxes to navigate between slides with go to slide and last viewed options, and apply Magic Move for smooth transitions.

Use your iOS device as a remote to control Keynote on your MacBook over wifi. Connect, enable remote, and swipe slides while annotating to enhance presentations.

Master slides let you apply a chosen theme, edit layouts, and create reusable templates from the master slides to use across future presentations.

Learn to create and save a custom Keynote theme, edit master slides, adjust colors, add images, and reuse it across projects for consistent presentations.

Export your Keynote templates and print hard copies with customizable options, including slide range, printer selection, background printing, presenter notes, and page layouts.

Learn to export keynote documents into pdf, powerpoint, or video with options to include slides and adjust image quality. Share outputs across devices and formats such as images and e-books.

Explore paid and free image sources for presentations, including Shutterstock, iStock, Pixabay, Flickr, and Google Images, and learn to download with licensing for copyright-safe use.

Learn Keynote shortcuts on Mac to save time and boost efficiency by using commands for new files, save, duplicate, print, undo, zoom, and quick navigation.

Explore the object list feature in Keynote to identify and manage slide elements such as images, shapes, and text. Use search, lock, and unlock to organize and navigate slides efficiently.

Learn to use Keynote's view options to switch to dark or light mode and replace fonts across slides, enabling consistent typography and presentation visibility.

Collaborate in real time with others so they can edit your Keynote presentation; sign up with iCloud to share a link that lets people join and view a live Keynote.

Explore free and paid courses on Kuku courses with direct links and no signup. Discover updated tutorials and flexible payment options across free courses and memberships.

Learn to clean, optimize and secure your Mac using CleanMyMac. Scan for junk, caches, duplicates, malware, free up space, boost performance, and manage cloud cleanup.

Install and run Windows on your Mac with Parallels Desktop, install Windows 11, activate the license, and optimize gaming performance while using window view, full screen view, and coherence view.