Excel 2008 for Mac Essential Training
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.
- 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
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 .
Here are the FAQs that matched your search "" :
- 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:
Sorry, there are no matches for your search "" —to search again, type in another word or phrase and click search.
Illustrator CC 2013 One-on-One: Fundamentals1,633,291 Views
Illustrator CC 2013 One-on-One: Mastery286,020 Views
Illustrator CC 2013 One-on-One: Advanced376,037 Views
Edge Animate Essential Training590,974 Views
iOS 8 App Development with Swift 1 Essential Training999,394 Views
Pages 5 Essential Training158,731 Views
Numbers 3 Essential Training137,387 Views
Illustrator CC 2013 One-on-One: Intermediate526,337 Views
MVC Frameworks for Building PHP Web Applications176,233 Views