Q: MS Excel and Mac Numbers
-
Sep 6, 2016 4:52 AMby Wayne Contello,Numbers can import Excel most files and can edit the Numbers document that results from having imported an excel document. You can save what you edited as a Numbers file, or export back to excel. If, however, you need excel for work, then drag the excel file onto the excel icon in your doc to force the Mac OS to open the file with excel.
You can also select any excel file, then select the menu item "File > Get Information". In the resulting window, choose "Excel" from the "Open With" menu, then click the "Change All..." button
-
Sep 6, 2016 6:51 AMby t quinn,Hi John,
There are some differences in how Excel and Numbers work that can create difficulties if you need to translate between the two frequently. If you are looking to move on over, Welcome!
There are certain functions that Numbers is missing, notably some array functions. There are many people here who use both Numbers and Excel and they can help you modify formulas that need it.
One big difference between the two is Numbers preference for multiple tables on a sheet ratther than a monolithic table with different sections.
My impression from these forums is that you can accomplish nearly everything with Numbers on your Mac that you did in Excel. If you are used to linking between documents you will need a workaround.
quinn
-
Sep 6, 2016 1:08 PMby johnfromplattsmouth,I am certain that Excel is much more than I really need. I was happiest with the now dead Microsoft Works. And I don't even know what arrays are.
"One big difference between the two is Numbers preference for multiple tables on a sheet ratther than a monolithic table with different sections." This is one part of the area in which I need help. I don't understand multiple tables on a sheet. Thought that by looking at some of the Apple sample spreadsheets I would get an idea of how they work. But so far that hasn't helped. Each sample presented appears to be a finished product, and I don't see what went into creating it.Would really like a simple guide to constructing Numbers spreadsheets. I have a feeling that Pogue's book on iWorks would be too complicated for me to begin with. If anyone has a hint on a simple book, web guide or YouTube tutorial, I would really appreciate it. My spreadsheet is monthly, with days of the month across the top and expense categories down the left column. But I do run the entire year with YTD info as I go.
-
Sep 6, 2016 1:34 PMby notcloudy,At least in Numbers(Iwork9) version - noticed that complex spreadsheets really did not convert well.
You can have multiple table spreadsheets but I broke up the one I had with two tables as it did not perform well.
AppleWorks was equal to Works for Windows - and many of us miss that too - as the Iwork package was a step backward.
Generally I found what I wanted to do by browsing through the menus.
