Powered by RND
PodcastsTechnologyAppleVis Podcast

AppleVis Podcast

AppleVis Podcast
AppleVis Podcast
Latest episode

Available Episodes

5 of 100
  • Speed up your typing and your emoji game with text replacements on iOS, iPadOS, and macOS
    In this episode, Dave Nason demonstrates how to create and use text replacements, short snippets of text which are substituted with frequently used words, sentences, or emojis when typed, on iOS, iPadOS, and macOS. This may be useful if you, for example, need to frequently give people directions to your home. Rather than manually type out the directions, you could configure a text replacement so that several sentences could be inserted simply by typing a few characters of your choosing. You may also wish to use it to speed up typing longer words, or even to type emojis that you use regularly.On iOS and iPadOS, text replacements can be created and managed in Settings > General > Keyboard > Text replacement. Here, you can double-tap an item to edit it, or delete it using the "Delete" rotor action. To create a text replacement, double-tap the Add button in the upper right corner, type or paste the word, sentence, or emoji you want inserted in the "Phrase" field, type the text snippet in the "Shortcut" field, and double-tap Save.On macOS, text replacements can be created and managed in System Settings > Keyboard > Text replacements. Navigate the table using the up and down arrow keys, Tab to individual cells to edit them, or delete them using the Remove button. To create a replacement, click the Add button, type the text snippet in the "Replace" field, type the text you want to be inserted in the "With" field, and click Add.Assuming your devices are signed into the same Apple Account, text replacements are synced between them, allowing you to, for example, create text replacements on your Mac, and use them on your iPhone or iPad.TranscriptDisclaimer: This transcript was generated by AI Note Taker – VoicePen, an AI-powered transcription app. It is not edited or formatted, and it may not accurately capture the speakers’ names, voices, or content.Dave: Hello there, David Nason here. I hope you are doing well. Today I wanted to give you a quick demo of how to use text replacements or typing shortcuts on both iOS and macOS. Text replacements are a really handy feature for speeding up your typing, helping you type out regular words or phrases or even you know, full on sentences that you want to type more quickly.Dave: You can type as little as two characters as your shortcut and then you hit space or punctuation like a full stop or a comma and it will expand out into the word or phrase that you have set. So it's really handy. There's probably three key ways which I use it. One would be for kind of longer sentences that I need to type semi-regularly. So, for example, directions to my house.Dave: If a friend is coming over or a taxi driver or a delivery person, that kind of thing. Rather than having to type out those directions each time I'm in that situation, I have a shortcut set up. So I type D-I-R-1. and I hit space and it will turn into those directions. I have one that's Dior2 as well, which is a more detailed version of those directions.Dave: I also use it then, number two, for kind of regular words and phrases that I might use when I'm texting people or emailing. I borrow some of these from contracted Braille, others I have made up myself. So things like YD for yesterday, TM for tomorrow, TAFN…
    --------  
  • Getting Started with Numbers on Mac: Lesson 7 - Understanding the concept of Tables and inserting multiple tables on a Sheet
    In this episode of the AppleVis Podcast, Gaurav returns with Lesson 7 in the ongoing series on mastering Numbers, Apple’s free spreadsheet app for Mac.This lesson focuses on organizing data efficiently in Apple Numbers. Unlike Excel’s single-grid layout, Numbers offers a more flexible, canvas-like approach where multiple tables can coexist on a single sheet. Gaurav demonstrates how to manage tables for different quarters of budget data, making it easier to structure and access your information.Key Concepts CoveredUnderstanding Tables in NumbersNumbers allows multiple tables per sheet, treating each sheet as a flexible workspaceDistinct from Excel’s traditional grid-based formatUsing the Sheet NavigatorAccess the window spots menu with VO + UNavigate through and interact with sheetsRename, duplicate, or delete tables as neededWorking with Multiple TablesAdd multiple tables to a single sheetUse VO and arrow keys to move between themRename each table for clarity and structureManaging Tables EffectivelyCustomize titles and captionsRemove unnecessary rows and columnsOrganize data by period (e.g., Quarter 1, Quarter 2)Advantages of Using Multiple TablesQuickly shift between distinct data setsEnhance visual clarity, especially for sighted usersTranscriptDisclaimer: This transcript was generated by AI Note Taker – VoicePen, an AI-powered transcription app. It is not edited or formatted, and it may not accurately capture the speakers’ names, voices, or content.Gaurav: Okay folks, so in this lesson we are going to discuss about tables. Now tables are different tables you can have on your sheet in Numbers. And what you want to understand is that unlike Microsoft Excel, Numbers doesn't treat each sheet as a massive grid. It instead treats it like a blank canvas where you can have multiple tables. In Excel, it is treated as one massive grid.Gaurav: Now I'll show you what I mean by that and why it's useful to work with various tables on your canvas on a sheet in Numbers. So I'm back on my Numbers table. I'm going to hit VO plus U for umbrella to open the window spots menu.GauravVoiceOver: Sheet navigator tab group. I'm going to go here, hit enter.VoiceOver: Sheet navigator tab group.Gaurav: I'm going to VO shift down arrow to interact.VoiceOver: In budget sheet selected tab.Gaurav: Budget sheet. That's the name I've given to this sheet where we have our January, February, March budget. Here I can hit VO shift M for menu or do the contextual click.GauravV/oiceOver: table one rename ellipsis duplicate show sheet options cut sheet copy sheet paste sheet delete table one rename ellipsis so here currently i have various options of what options i have with this sheet i'm just going to rename it duplicate rename ellipsis you are currently i'm going to rename it toGaurav…
    --------  
  • Getting Started with Numbers on Mac: Lesson 6 - Autofill feature to quickly copy formulas across cells
    In this episode of the AppleVis Podcast, Gaurav returns with Lesson 6 in the ongoing series on mastering Numbers, Apple’s free spreadsheet app for Mac.In the previous lesson, he explored how to insert formulas effectively. This time, the focus is on using the autofill feature to save time and eliminate repetitive tasks.Autofill EssentialsApply formulas across multiple cells with ease using autofill.Insert the same formula into multiple rows by holding Shift and using the arrow keys.Access autofill options from the table menu.How to Use AutofillSelect the range of cells where the formula should be applied.Choose the direction for autofill (up, down, left, or right).Use the autofill command to extend the formula across the selected area.Adjusting FormulasCopy formulas from one column (e.g., January) to others (e.g., February, March).Ensure row numbers stay the same while updating column references.For instance, replicate the formula from B2–B5 in January to C2–C5 in February.Reviewing and EditingReview and edit formulas in each column as needed.Maintain row consistency while adjusting for different columns during autofill.Using these techniques will help streamline your workflow and minimize manual input.TranscriptDisclaimer: This transcript was generated by AI Note Taker – VoicePen, an AI-powered transcription app. It is not edited or formatted, and it may not accurately capture the speakers’ names, voices, or content.Gaurav: So in this lesson, if you remember in the previous lesson, we had learned how to insert formulas. In this lesson today, we are going to learn how to quickly autofill formulas so that you don't need to fill them in again and again when you want to put in the same formula across different cells. So we're back into our numbers table.Gaurav/VoiceOver: Sap Food, Rope Water, Rope Transportation, Internet. So our January has now got a total, but our February and March remain blank.Gaurav: So I'm going to move into the February total cell.VoiceOver: February empty.Gaurav: I'm going to hold down the shift key. And I'm going to hit right arrow again. C6 through D6 are now added to my selection, which means these cells are selected. And I want to insert the same formula into these two rows as I had inserted into column B, where I inserted the total for the January month. I'm going to hit view, press M for menu.Gaurav: I'm going to keep hitting right arrow until I get to table. I'm going to hit down arrow.Gaurav/VoiceOver: I'm going to type in autofill, autofill cells, submenu. I'm going to hit right arrow here.Gaurav/VoiceOver: Here I'm going to explore the various menu options by hitting down arrow. auto fill left auto fill down auto fill up auto fill from row above command option auto fill from column before command control back auto fill from column before so now it if i hit enter it's going to auto fill the formula from column b into columns c and d and only into the cells which i've…
    --------  
  • Getting Started with Numbers on Mac: Lesson 5 - Basic Formulas
    Gaurav is back with the next installment in our Numbers tutorial series, diving into one of the most essential spreadsheet skills: the SUM function. Whether you're tracking expenses or organizing data, learning to total values quickly is a must.Quick Guide: Summing Your January ExpensesSelect the Cell – Click the cell where you'd like the total to appear.Start the Formula – Type = and then SU. Use the arrow keys to highlight SUM and press Enter.Set the Range – Type your cell range, like B2:B5, and close with a ).Finish – Hit Enter. Boom—your total is ready!Want to Make a Change? Just press Option + Enter to jump into the formula editor, tweak your formula, and press Command + Enter to apply it.Introduction to Basic FormulasLearn how to analyze and manage data with formulasFocus: Using the SUM function to total values easilyUsing the SUM FunctionAdds up all values in a defined rangeCommon use: Insert a “Total” row to sum a column’s dataEnter the function where the total should appearHow to Enter the SUM FormulaNavigate to the desired cellPress Option + Enter to begin editingType = to start the formulaEnter SU, then select SUM with the arrow keysInserting the Formula ExampleIn cell B6, type: =SUM(B2:B5)Press Enter to apply and see the resultEditing a FormulaClick the Total cellPress Option + Enter to enter edit modeUse arrow keys to move around and editPress Command + Enter to save changesPro TipsUse larger ranges for more data, like B2:B1000Press Option + Enter anytime to reopen the formula editorArrow keys let you fine-tune your formula line-by-lineSpreadsheet skills made simple—with Numbers on your Mac!TranscriptDisclaimer: This transcript was generated by AI Note Taker – VoicePen, an AI-powered transcription app. It is not edited or formatted, and it may not accurately capture the speakers’ names, voices, or content.Gaurav: okay folks so in this lesson we are now going to get into very basic formulas and formulas are very easy yet powerful methods of analyzing and playing around with our data. So today I'm going to use probably one of the most used function, which is the sum function. So it is a way of totaling all the values in a set of cells.Gaurav: So what we're going to do is, again, jump back into our table.Gaurav/VoiceOver: Food. Rowhead or cell? Cell. water row header cell transportation row header cell internet row header cell row header cell cell okay so we have all of our headings in the category headings in column a internet row…
    --------  
  • Getting Started with Numbers on Mac: Lesson 4 - Sort and Quick Filter
    In this episode of the AppleVis Podcast, Gaurav returns with Lesson 4 in the series on mastering Numbers, Apple’s free spreadsheet app for Mac.In this installment, he dives into two powerful tools for organizing your data: Sort and Quick Filter. These features help you manage and analyze spreadsheets more efficiently—especially when working with larger datasets.We’re using a sample budget spreadsheet with categories like Food, Water, Transportation, and Internet, each with amounts listed for January. Here’s how we sorted that data to quickly find the highest expenses:Sorting the January ColumnOpened the Sort Options via the menu (Command + Option + R).Selected the January column.Chose Descending to sort from highest to lowest values.Instantly, the data reorganized itself to prioritize the largest expenses.Quick Filter: Focusing Your ViewNext, we explored the Quick Filter tool—a great way to temporarily hide or display specific rows without permanently deleting data. For example, we hid the Food row with a checkbox and brought it back with a simple undo (Command + Z).Advanced FilteringWe also touched on advanced filtering available in the Formatter pane. There, you can set precise criteria for what appears in your spreadsheet—ideal for more complex sorting needs.RecapSort Function: Explained how and why to use it.Hands-On Example: Sorted the January column using VoiceOver and keyboard commands.Undo + Quick Filter: Demonstrated hiding rows and bringing them back.Formatter Pane: Previewed more detailed filter controls.These tools make navigating and analyzing your spreadsheet data faster and more intuitive. Try them out, experiment a bit, and as always—reach out if you have questions! 💡📊Happy sorting!TranscriptDisclaimer: This transcript was generated by AI Note Taker – VoicePen, an AI-powered transcription app. It is not edited or formatted, and it may not accurately capture the speakers’ names, voices, or content.Gaurav:Hello everyone. So today we will continue our sessions on the Numbers application. And today we will be talking about the sort function. There are two or three different types of sort that we can apply to our data. The sort function is one of the most used and most useful functions or features of a spreadsheet. And today we'll see how to use that for better navigation and analysis of our data.Gaurav:So we're back in our spreadsheet.VoiceOver: Food column header cell.Gaurav/VoiceOver: I'm back in cell A1. And if we're just going to go and view all the data we have in column A. Food row header cell cell A2.VoiceOver: Water row header cell cell A3. Transportation row header cell cell A3.Gaurav/VoiceOver: A4 internet row header cell cell A5 row header cell cell A6 all right so we have five from row two to row…
    --------  

More Technology podcasts

About AppleVis Podcast

AppleVis is the go-to resource for blind and low vision users of Apple technologies. Our Podcast discusses the latest in Apple vision accessibility. Topics cover OS and accessibility features, apps, interviews with developers, roundtable discussions, and more - centering around accessing the maximum potential of Apple hardware, software, and services. Tune in to learn how you can get the most out of your Apple devices, hear the latest accessibility news, and more.
Podcast website

Listen to AppleVis Podcast, Acquired and many other podcasts from around the world with the radio.net app

Get the free radio.net app

  • Stations and podcasts to bookmark
  • Stream via Wi-Fi or Bluetooth
  • Supports Carplay & Android Auto
  • Many other app features
Social
v7.17.1 | © 2007-2025 radio.de GmbH
Generated: 5/10/2025 - 6:32:08 PM