I have used Lotus 123 for more than 20 years and can write macros and create spreadsheets easily, and link spreadsheets to Freelance. Now I have moved to W7 64 bit I have bought MS Office 2007 and incuding Excel. I tried reading a library book to learn it but find it very confusing as I keep trying to think through "Lotus" knowledge - can anyone suggest a quick way of learning the basics like entering data, adding, sorting by number or alphabet etc.The book was very opaque.
Thanks. For example in .123 just to add nunbers in a column you enter @sum in the place you want the sum and highlight the numbers by starting at the top and shift and highlight the colunm of numbers. IN Excel I think you enter a + sign. To copy in .123 you use the /copy command - then there is the @abs etc. I was just wondering if there was a book that gives the Lotus and Excel equivalents, as Lotus was once the leader in this field. Also eg if you want a number to appear as text in Lotus you put ', " or ^ in front.
I loved playing with i23, john bunyan, I still use it from time to time, but it's been so long since I last did. I use Lotus 97, that'll show you how far back I am with it, lol. Everything was dead easy to access in it.