Excel for Mac 101
Creating Basic Worksheets
  • 38 Videos
  • 3h 41m
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...
A seasoned lecturer and dedicated educator, Tamás has instructed at a variety of recognized post-secondary institutions including the Vancouver Film School (VFS), The British Columbia Institute of Technology (BCIT), the University of British Columbia (UBC) and Capilano University for nearly 2 decades.
  • Library Pass
  • Own It For Life!
Watch Free Previews!
View up to 5 free videos from ANY course each day.
Out of free previews? Come back tomorrow to watch some more!
Get A Library Pass!
Watch this course – and ALL macProVideo.com courses – for as long as your pass is active.
Purchase just this course! Watch it anytime, for life.
Overview
Status: Available | Released: Aug 21st, 2013
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!
Outline
Section 1: Section 1: Overview:
Section 2: Section 2: The Ribbon
Section 3: Section 3: Inserting Symbols and Data
Section 4: Section 4: Data Manipulation and Window Management
Section 5: Section 5: Worksheet Management
Section 6: Section 6: Formulas and Data Formats
Section 7: Section 7: Mini Project - Creating a Calorie Tracker Spreadsheet
Other courses in this series
What to do next
Embed Video
Embed this video in a blog, forum post, or webpage.
Copy
Become an affiliate and earn 50% of every sale you send our way - Sign Up!
Reviews
Feedback
Course Advisor
Don't Know Where To Start?
Ask A Course Advisor
Ask Us!
Copy the link below and paste it into an email, forum, or Facebook to share this with your friends.
Make money when you share our links
Become a macProVideo.com Affiliate!
The current affiliate rate is: 50%
Classes Start Next Week!
Live 8-week Online Certification Classes for: