Course for Microsoft Excel - Creating Basic Worksheets

Developer: Nonlinear Educating Inc.

Current Version: 2.0.2

Last Updated: 10 months ago

Download Size: 481.7 MB - Download


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


Release Notes:

• Improved User Interface and Experience.
• Add your own notes to individual tutorials.
• View the outline and jump to any tutorial while playing video or from the Home screen.
• Mark your favourite tutorials.
• Take your learning experience full screen.
• Hide or show the tutorial outline whenever you want.
• Compatible with OS X Mavericks (10.9), Yosemite (10.10), and newer.


Most Helpful Reviews

Version 1.0
Review by emung

Excel - I'm very disapointed that I paid $19.99 and this is not the excel program. I did want to purchase how to use excel.

Found helpful by 37 out of 46 people

More Reviews for Current Version

Version 2.0.2
Review by xio_fra

Its a tutorial - I want my money back!!! I thought it was the actually program, its actually a tutorial!

Found helpful by 10 out of 11 people
Version 2.0.2
Review by Pairat Phu

Don’t buy - I want my money back!!! I thought this was the Excel program.

Found helpful by 1 out of 1 people
Version 2.0.2
Review by Smangelo


Found helpful by 1 out of 1 people