AppleVis Podcast

• Getting Started with Numbers on Mac: Lesson 07 - 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 06 - 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 05 - 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 04 - 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 podcast, he diving 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 five…

  --------  
• Getting Started with Numbers on Mac: Lesson 03 - Autofill and Quick Calculation Bar

  In this episode of the AppleVis Podcast, Gaurav is back with Lesson 3 in his series on mastering spreadsheets with Numbers, Apple’s free spreadsheet app for Mac.Today, he’ll continue working with our monthly budget spreadsheet and dive into two powerful time-saving tools: Autofill and the Quick Calculation Bar.First, we’ve already completed the budget for January and February. Now, instead of re-entering all the data for March, we’ll use Autofill to do the work for us. Just head over to the March column, open the Autofill menu, and like magic, your February values are copied into March in a flash.Next up is the Quick Calculation Bar – a handy feature that gives you instant stats just by selecting your data. Whether you need a total, average, or want to find the highest or lowest value in a range, this tool has you covered with zero extra steps.Key Features CoveredAutofillQuickly copies values across multiple cells.Demonstrated by filling March’s budget with February’s data using the Autofill tool.Quick Calculation BarInstantly displays summaries like sum, average, minimum, maximum, and count for any selected range.No formulas required.How-To StepsUsing Autofill:Select the cell range from the previous month (e.g., February).Open the Autofill menu.Apply the data to the next column (e.g., March).Using the Quick Calculation Bar:Select any range of cells.The summary (sum, average, min, max, count) appears automatically at the bottom of the window.RecapIn this lesson, you learned how to:Use Autofill to speed up repetitive data entry.Leverage the Quick Calculation Bar for fast data insights.Give these tools a try and see how much smoother your budgeting becomes. Happy spreadsheeting!Would you like a visual handout version of this for reference or teaching?In this episode of the AppleVis Podcast, Gaurav returns with the third lesson in his series on mastering spreadsheets using Apple’s free app,Numbersfor Mac.Welcome to Lesson 3 on mastering numbers! Today, he diving back into our monthly budget spreadsheet to explore some nifty features that will save you time and effort: Autofill and Quick Calculation Bar.First, if you remember, he already filled out our budget for January and February, and now we're moving on to March. Instead of manually copying the values from February, we'll use the Autofill feature to make it a breeze! Simply navigate to the March column, use the autofill menu, and voilà, your data from February is neatly copied over to March.Next, let's talk about the Quick Calculation Bar – a powerful tool for quick insights. Whether it's calculating totals, averages, or finding the minimum and maximum values, this feature does it all by just selecting your data range.Autofill: Quickly duplicate values across multiple cells with ease. Quick Calculation Bar: Instantly access totals, averages, min, max, and more for selected ranges…

  --------  

Más podcasts de Tecnología

Podcasts a la moda de Tecnología

Acerca de AppleVis Podcast