【實用商業app】Excel for Mac 101 - Creating Basic Worksheets|最夯免費app

Let long-time user and veteran instructor Tamás Revoczi teach you how to create basic worksheets in Microsoft Excel 2011.

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.

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!

-

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

免費玩Excel for Mac 101 - Creating Basic Worksheets APP玩免費

免費玩Excel for Mac 101 - Creating Basic Worksheets App

Excel for Mac 101 - Creating Basic Worksheets APP LOGO

Excel for Mac 101 - Creating Basic Worksheets APP QRCode