Course for Microsoft Excel – Creating Basic Worksheets [for Mac]

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…

After a basic tour of the new interface, including the Ribbon and menu systems, you see how easy it is to manipulate your worksheets and the data they contain. You also learn how to add and insert special characters and symbols from various sources, which help you to represent the different data types available.

After a solid grounding in the basics, you bite into the juiciest parts of Excel: Formulas and Functions! While this course covers only some basic functions and formulas, you also learn some important background concepts about data formats, operators and the precedence rules by which they are applied.

As the pièce de résistance, you get to create a calorie tracker which not only encapsulates all the tasty and nutritious Excel tips you’ve learned throughout the course, but provides you with a powerful diet tool to help you lose weight and improve your health and fitness!

Watch all the courses in our growing Microsoft Office for Mac series and increase your office knowledge and productivity!

Table of contents:

1. Introduction to Excel
2. Installing and Launching MS Excel for the First Time
3. Creating New Documents from Templates
4. A Whirlwind Tour of the Menus – Part 1
5. A Whirlwind Tour of the Menus – Part 2
6. Home Tab Basics
7. More Home Tab Functions
8. More Tabs
9. Creating and Saving New Workbooks
10. Open and Closing Workbooks
11. Selecting Single Cells
12. Selecting Multiple Cells
13. Copying and Pasting Data
14. Cutting and Pasting “Special”
15. Auto Data
16. Inserting Symbols and Special Characters Inside Exc…
17. Inserting Symbols and Special Characters Within MS …
18. Inserting Symbols and Special Characters From Mac O…
19. Inserting and Moving Data
20. Freezing Windows
21. Splitting Panes
22. Finding and Replacing Data
23. Adding and Deleting Worksheets
24. Moving and Copying Worksheets
25. More Worksheet Management Tips
26. Introduction to Formulas
27. Introduction to Functions
28. Formula Tab Basics
29. The Formula Builder
30. More Formula Tab Features
31. Data Formats
32. Data Alignment and Orientation
33. Operator Precedence
34. Setting Up the Basic Structure
35. Adding Placeholder Data
36. Gathering the Totals (with Diet Tips)
37. Formatting for Legibility
38. Sharing Worksheets Online