Intro Course For Excel For Mac

Узнайте, как создать основные листы & таблицы в Microsoft Excel

Microsoft Excel is second only to Microsoft Word as the oldest and most powerful pieces of industry standard software from Microsoft for the Macintosh operating system. Let long-time user and veteran instructor Tamás Revoczi teach you how to create basic worksheets in Microsoft Excel 2011...

App Features:

• 221 minutes of video training

• Super clear explanations

• Offline Playback (no internet connection needed)

• Easy to navigate

Course Outline:

1. Introduction to Excel (02:30)

2. Installing and Launching MS Excel for the First Time (06:31)

3. Creating New Documents from Templates (06:58)

4. A Whirlwind Tour of the Menus - Part 1 (06:04)

5. A Whirlwind Tour of the Menus - Part 2 (08:05)

6. Home Tab Basics (07:09)

7. More Home Tab Functions (02:48)

8. More Tabs (07:25)

9. Creating and Saving New Workbooks (11:25)

10. Open and Closing Workbooks (04:14)

11. Selecting Single Cells (04:22)

12. Selecting Multiple Cells (06:52)

13. Copying and Pasting Data (06:55)

14. Cutting and Pasting “Special” (07:12)

15. Auto Data (07:36)

16. Inserting Symbols and Special Characters Inside Excel (04:54)

17. Inserting Symbols and Special Characters Within MS Office (04:17)

18. Inserting Symbols and Special Characters From Mac OSX (03:50)

19. Inserting and Moving Data (09:34)

20. Freezing Windows (06:56)

21. Splitting Panes (03:49)

22. Finding and Replacing Data (08:10)

23. Adding and Deleting Worksheets (03:57)

24. Moving and Copying Worksheets (04:57)

25. More Worksheet Management Tips (02:30)

26. Introduction to Formulas (06:43)

27. Introduction to Functions (02:39)

28. Formula Tab Basics (06:50)

29. The Formula Builder (05:15)

30. More Formula Tab Features (03:47)

31. Data Formats (08:04)

32. Data Alignment and Orientation (05:48)

33. Operator Precedence (09:18)

34. Setting Up the Basic Structure (06:06)

35. Adding Placeholder Data (04:30)

36. Gathering the Totals (with Diet Tips) (03:50)

37. Formatting for Legibility (07:14)

38. Sharing Worksheets Online (01:25)