Learn how to create basic worksheets & tables in 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)