Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
In Computer Literacy for the Mac, author Garrick Chow walks through the skills necessary to use Mac computers comfortably, while improving learning, productivity, and performance. This course focuses on the Apple Mac OS X operating system and offers a thorough introduction to computers, networks, and computer peripherals such as printers, digital cameras, and more. In addition, basic procedures with software applications, the Internet, and email are covered. Exercise file accompany the course.
This course also includes chapter-level assessments for use as instructional aides. To download the assessments, click the following link: Computer Literacy Assessments. The file contains an assessment movie, chapter-level assessments, and answer keys.
Formatting a spreadsheet is very similar to formatting a word processing document. First, select the text or cell you want to format and then apply your changes. I'm working with the very simple spreadsheet I previously created. Let's take a look at some formatting things we can do. First of all, we've already seen that you can use the Numbers section of the Formatting palette to specify the appearance of numbers, like currency, or percentages, or date, or time. The Formatting palette also contains many of the same options you'll find in a word processor for formatting text. For example, I could select the cells containing the Job A and Job B. And here in my Formatting palette, I can make them bold.
And if I go under Alignment and Spacing, I can center them. And in the Borders and Shading section, I can change the color and outline of selected cells. For instance, I could select the Annual Income cells and then make them, say, a light green, and maybe with a slight border around them, like so. Now, Excel even has some built-in formatting options, under Format > AutoFormat. First, I'm going to select all the cells currently in use, and I'll select AutoFormat.
And in here, I can browse through several designs, clicking on them to get previews, and I can apply any one that I like. I kind of like that one. I'll click OK, and there it is. Now, I'm not going to get into the details of formatting with Excel exclusively, because I want to keep this general enough to apply to all spreadsheet applications, but this should give you an idea of how formatting works. Again, it's very similar to formatting a word processing document. First select what you want to change and then change it.
There are currently no FAQs about Computer Literacy for the Mac.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.