Course for Numbers: Mac & iOS|商業線上App不用買

Learn how to be a cross-platform, multi-device number cruncher with Apple’s Numbers software on your Mac, your iOS devices and on iCloud by watching this 41-tutorial course, by our Mac and iOS expert Francesco Schiavon!

Are you used to working on your spreadsheets on your dusty old accounting PC in the dark, neglected corner of your office? Now, thanks to Apple’s new version of Numbers and iCloud, you don’t have to! Now you can put together attractive and eye-catching as well as powerful data/formula-driven spreadsheets anywhere with your iOS devices, Mac or entirely online with any browser!

Imagine starting by setting up the framework of your spreadsheets on your office Mac, but then entering your data and tweaking your formulas on your iPhone on the way to your client’s office. When you arrive, all you need to do is export everything as a PDF and submit it from your iPad while you sit in the waiting area preparing for your meeting. Then at year-end, imagine being able use iCloud to share everything safely and securely with your Windows-centric accountant... in Australia!

In this course, led by our resident Mac and iOS expert, Francesco Schiavon, you learn how to use the Numbers canvas to assemble not just a single spreadsheet, but an entire fully-functional invoicing system, complete with attractive formatting and informative charts for maximum visual appeal and impact.

-

Table of Contents:

1. Introduction

2. Numbers Document Structure

3. Entering Data on the Mac and iCloud

4. Entering Data on iOS

5. Setting up the Project

6. Creating and Renaming Files

7. Formatting the Main Table

8. Table Manipulation in iOS

9. Table Styling on the Mac

10. Entering Formulas in OS X and iCloud

11. Entering Formulas in iOS

12. AutoFill in OS X

13. AutoFill in iOS and iCloud

14. What are Functions?

15. Functions on the Mac

16. Functions on iCloud and iOS

17. Entering the Last Few Formulas

18. Formatting Cells on the Mac

19. Formatting Cells on iCloud and iOS

20. Setting up the Next Steps

21. Creating the Summary Sheet

22. Entering Basic References

23. Advance References Using the INDEX Function

24. Dressing up the Invoice Sheet in iOS

25. Layout for Printing

26. Exporting PDFs

27. Printing from iCloud and iOS

28. Adding Charts

29. Working with Charts on the Mac

30. Working with Charts on iOS

31. To Export or Send a Copy or Share?

32. Exporting Excel Files

33. Sending a Spreadsheet from an iOS device

34. Send and Download a Copy via iCloud

35. Sharing a Link via iCloud

36. Password Protecting an iCloud Link

37. Conclusions

38. How iCloud Works

39. Setting up iCloud

40. Open and Save Dialog Boxes

41. iCloud File Management

免費玩Course for Numbers: Mac & iOS APP玩免費

免費玩Course for Numbers: Mac & iOS App

Course for Numbers: Mac & iOS APP LOGO

Course for Numbers: Mac & iOS APP QRCode