Excel 2008 for Mac Essential Training

with David Rivers
please wait ...
Excel 2008 for Mac Essential Training
Video duration: 0s 8h 25m Beginner

Viewers:

From customizing the interface to producing professional reports, Excel 2008 for Mac Essential Training fully explores the intricacies of working with this information management software. Using real-world examples, instructor David Rivers explains how to manipulate workbooks; use formulas and functions; perform goal-seeking analyses; lay out and present text and charts; use basic templates; and create custom templates, themes, and layouts. Exercise files accompany the course.

Topics include:
  • Customizing the user interface Using workbooks Adding and removing sheets Restricting input with validation rules Formatting workbooks Using formulas and functions Working with charts Adding, removing, and editing text Aligning and layering objects Creating PivotTable reports Sharing spreadsheets Creating custom templates
Subject:
Business
Software:
Excel for Mac
Author:

Welcome

Hi, I'm David Rivers and welcome to Microsoft Excel 2008 for Mac Essential Training. You know, Excel is the world's leading spreadsheet application, and there have been a number of improvements and enhancements made to this latest version from Microsoft. In this title we'll be exploring changes to the user interface before moving on to the basics of working with a spreadsheet application like Microsoft Excel. We'll explore tips and tricks for working efficiently with sheets in a workbook. We'll get into common formulas and functions as well as some of the more advanced functions when it comes to working with numbers in Excel.

And then we'll explore ways to make your spreadsheets standout by enhancing your data and adding components like charts, graphics and other objects. Of course sharing your work with others is always important, so we'll examine several ways to effectively do that while protecting the integrity of your data at the same time. So let's not waste any time. Let's get started with Microsoft Excel 2008 for the Mac.

Find answers to the most frequently asked questions about Excel 2008 for Mac Essential Training .


Expand all | Collapse all
please wait ...
Q: How does one generate an average using cells in columns that are not consecutive i.e. a7,c7,e7...?
A: To get an average of non-contiguous cells, you can either select them individually, or type them in manually.  Here are the steps involved:
1. Click in the cell where you want the average to appear
2. Start the function by typing: =average(
3. Now, either type the cells addresses (ie A7,C7,E7) or select each cell by clicking them while holding the Command key.
4. Close off the function with closing round bracket: ) and press Return key
You should see the answer in the cell where you entered the function.  Checking the formula bar, your finished "formula" will look something like this:
=average(A7,C7,E7)
please wait ...