Узнайте, как создать основные листы & таблицы в 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)