Sorry I didn't get back to you sooner, but glad to see you're getting into it and Gigi is helping. The help documentation with Numbers is great. Their formulas and functions help, and the view functions by categories tables, should be all you really need. The Apple Support forums also contain lots of useful stuff. To Gigi's basics, I'll just add these tips. When entering a formula or function, once you start typing, Apple will offer you suggestions. You can just use the left and right arrow keys to hear the different suggestions, and then press return to select the one you want. This is often useful when selecting ranges in other sheets, as it saves a lot of typing and colons. :) Also, to adjust the cell's format data type you just navigate to the cell, press VO-j to jump to the format inspector, select the Cell radio button, navigate to the end of the inspector with VO-Shift-End, interact with the scroll area, and you have lots of great options. I find the popup menus and checkbox formats really useful. I never used to use these with Excell. Also, one last tip. I tend to navigate cell by cell with VO keys plus arrow keys. Not sure if this is strictly necessary, but seems to help avoid any focus issues. When focus is on a cell, you can just type to enter data or a formula in the cell. To stop editing the cell, just stop interacting with it and move on. Good luck, and before long I'll probably be learning from you! P.S. 6x100 doesn't sound too huge. I was thinking of people who seem to have thousands of rows. I tend to use separate sheets pretty extensively, with one sheet for data entry and another sheet to display summaries and other info relating to the data. The data entries tables regularly get up to 60-70 rows, but don't usually get over one hundred. But I tend not to need to read back through those rows. I just jump straight to the end to add a new row, and look at the summary sheets to get the result of the data. Plus the sort and filter options to sort and filter your data works pretty well and helps avoid the need to plough through rows and rows of data.
-- You received this message because you are subscribed to the Google Groups "MacVisionaries" group. To unsubscribe from this group and stop receiving emails from it, send an email to macvisionaries+unsubscr...@googlegroups.com. To post to this group, send email to macvisionaries@googlegroups.com. Visit this group at http://groups.google.com/group/macvisionaries. For more options, visit https://groups.google.com/d/optout.
