Basically, if you’ve used Excel 2004, you’ve used Excel 2008. If you absolutely require Intel-native code on your Mac, or you find Excel 2004 runs too slowly on your Intel-powered Mac, then obviously you should upgrade. Additionally, if you receive files in the new.xlsx format, you’ll have to upgrade as well—there are no file format converters for Excel 2004, as there are for Word and PowerPoint.

David explores the Word 2008 for Mac interface, goes over simple tasks such as creating and saving documents, and delves into advanced editing, formatting, and layout features. Mar 02, 2014  Instead of always going to the Community for help I would like to get a detailed tutorial for Excel 2008. I have the basic tutorial, but it does not have any detail. Does anyone know where would I go to get it.

If you’re running OS X 10.5, however, a known issue with Excel means you cannot use that menu to run the workflows. Instead, you must launch Automator and run the workflows from there—and even then, things may not work. I received warnings about some of the workflows using older versions of certain actions; when I tried to run those workflows, they failed with various error messages. Some workflows, however, worked as expected, though having to switch to Automator to run them is a major inconvenience. You can’t, however, attach an Automator workflow or AppleScript to a button in Excel 2008, as one can do with macros in Excel 2004. The only alternative is to assign it a keyboard shortcut, for use from the Script menu. The new Toolbox merges the old Toolbox and Formatting Palette from Excel 2004; the end result resembles the Inspector panel from Apple’s iWork.

When data has been entered and your cursor is immediately below the entered date, press the F11 key on the top row of your keyboard. Step 4 - Viewing the Charts Gallery - There are things that you probably wish to change about the chart.

Create a projection based on an existing series of data. Use Excel for Mac 2011 to check out a SharePoint file so that only you can make changes. Explore other useful resources Title Description See the full list of keyboard shortcuts, organized into logical categories. Rearrange, show, and hide tabs on the ribbon.

Watch this course anytime, anywhere. Course Contents • Introduction Introduction • • 1. Getting Started with Word 1.

The similar performance isn’t all that surprising—Excel 2004 never felt like much of a laggard when running in the Rosetta emulation mode on an Intel Mac. The shift to a Universal format will benefit those working on truly massive spreadsheets the most; typical users may not see much difference. Regarding Macros and AppleScript The new Formula Builder makes it simple to create even the most obscure formulas. Using the descriptions of each input box, just point and click to build the formula you need.As the ( ) noted, Excel 2008 doesn’t support Visual Basic for Applications (VBA), which is the language used to create and record macros in prior versions of Excel.

Add pictures or clip art to a worksheet by using the Media Browser. Analyze, share, and collaborate Title Description Learn the two different ways to create a Pivot Table and how to use the Pivot Table Field Lists to add, move, and arrange fields.

If you have to do some more advanced formatting not available in the quick toolbar, then go ahead and open the dialog. In this tutorial, I’ll show you the dialog method just so we can see it. In the Format Cells dialog, click on the Patterns tab and select a color from the palette. I chose yellow to make it distinct. Click OK and you’ll now see that the color has been changed for the selected cells. Let’s also add some borders between the cells so that if we decide to print out the Excel sheet, there will be black lines between everything.

Using Bullets and Numbering 8. Using Bullets and Numbering • • • • 9. Creating Tables and Charts 9. Creating Tables and Charts • • • • • • • • • • • 10. Styles • • • • 11. Using Mail Merge Manager 11.

Visual Basic macros are no longer supported in Excel 2008 for Mac, which might make things a little difficult for you if you're used them a lot in the past, or if somebody else gives you spreadsheets using them. The Microsoft Office for Mac team shows you just how to deal with Visual Basic macros in this how-to video.

Data can be entered without the headings I entered in row 1. Step 3 - Creating the chart - Note: this chart will be created without using the Chart Wizard. When data has been entered and your cursor is immediately below the entered date, press the F11 key on the top row of your keyboard.

Working with Columns 13. Working with Columns • • • • 14. Working with Graphics 14.

Excel 2008: Create a Chart or Graph Step 1 - Reassign F11 - Pressing the F11 key on a Macintosh will minimize all applications, displaying the desktop. Pressing the F11 key can be used to create a quick graph, but you must first reassign the function assigned to that key. From the Apple menu, select System Preferences and then select Expose & Spaces. Click on the right end of the Show Desktop area and select something other than F11. If you want a quick way to see the Desktop select something other than the dash. Step 2 - Data entry - Enter data collected with your survey. For this example I took a survey of my class asking them to name their favorite fruit.

Formatting Paragraphs • • • • • • 6. Formatting Pages 6. Formatting Pages • • • • • • • • 7. Proofing Documents 7.

A cell is simply a particular row number and column, i.e. A1 is the very first cell in an Excel worksheet.

It’s been more than three years since the last update to ( ), the leading Mac spreadsheet. Despite the long wait for a new version, when you launch Excel 2008, you’ll see what appears to be a slightly re-skinned version of Excel 2004—or even of Excel v.X. The menus and menu items are nearly identical, and the worksheet itself is the same as it’s always been. Appearances can be deceiving, however—Excel 2008 is a major rewrite, designed to run natively on Intel-powered Macs as well as PowerPC-based machines. This release of Excel also offers some new features, though it drops at least one major area of functionality. As a result, Excel 2008 may leave you feeling somewhat underwhelmed.

Excel 2008: Create a Chart or Graph Step 1 - Reassign F11 - Pressing the F11 key on a Macintosh will minimize all applications, displaying the desktop. Pressing the F11 key can be used to create a quick graph, but you must first reassign the function assigned to that key. From the Apple menu, select System Preferences and then select Expose & Spaces. Click on the right end of the Show Desktop area and select something other than F11.

Proofing Documents 7. Proofing Documents • • • • • • 8. Using Bullets and Numbering 8. Using Bullets and Numbering • • • • 9. Creating Tables and Charts 9. Creating Tables and Charts • • • • • • • • • • • 10. Styles • • • • 11.

Missing features and other foibles Excel 2004 lacked support for Services, a standard OS X feature that lets you select snippets of text and send them to other applications. Despite three-plus years of development, Excel 2008 still doesn’t support Services, so more work is required to use text from Excel in other programs. Excel 2008 also wastes a lot of vertical screen real estate. As already noted, you’ll have to give up a row for the Elements Gallery, and the Standard toolbar also takes up vertical space as well. The Standard toolbar isn’t free-floating as it is in Excel 2004, but anchored within the spreadsheet window—and it cannot be undocked. So the Standard toolbar appears in every worksheet, instead of appearing just once. (You can disable the toolbar entirely, though that will force you to use menus and keyboard shortcuts instead.) If you’re on a laptop, I recommend either hiding the main toolbar or setting it to Icon Only view to save screen real estate.

As respect looks, all of the Microsoft Office 2010 Professional Plus apps happen to be somewhat modified. Without any doubt, Microsoft Office Professional plus Key is ideal for just about any person. For sure you understand Microsoft Office, check the way it operates as well as understand the explanation why it’s trendy. Office 11 for mac product key free. For the very first time, we see the way a brand new version obsesses fewer sources in cases that are many.

Learn about the different kinds of operators (for example, +, -, /, and *) and the order in which they are applied. Learn the difference between relative and absolute cell references and how to switch between them. Work with charts and graphics Title Description Learn the basics of charts, including the elements of a chart, which chart is appropriate for your data, and how to apply chart layouts and styles. Add chart and axis titles, change the axis scale, add data labels, and more. Use error bars to indicate potential error amounts in relation to each data point.

David Rivers specializes in elearning and productivity. His clients include Microsoft and Corel. Author, trainer, and learning and development expert David Rivers has over 20 years experience helping government, hi-tech, and healthcare businesses increase their efficiency and productivity by integrating technology tools. With deep experience in Microsoft Office, elearning tools, and assorted productivity tools such as FrameMaker and RoboHelp, David is passionate about helping people improve their workflows to recover time in their schedules. His clients include Microsoft, Corel Corporation, Halogen Software, and the City of Ottawa. David is also a published book author on topics ranging from Photoshop to Acrobat and the Microsoft Digital Image Suite. Skills covered in this course • • • Course Transcript - [Voiceover] Hi, and welcom to Microsoft Word 2008 for the Mac.

Document Sharing and Collaboration • • • • • • • • • 16. Working with Long Documents 16. Working with Long Documents • • • • • • • Conclusion Conclusion •.

As soon as the chart is created click on the Charts tab immediately above the chart. From that tab you can scroll through each of the chart types and make a selection (This image has been simplified to fit the page) Step 5 - Using the Formatting Palette - Several areas on the palette can be used to make changes.

Proofing Documents • • • • • • 8. Using Bullets and Numbering 8. Using Bullets and Numbering • • • • 9. Creating Tables and Charts 9. Creating Tables and Charts • • • • • • • • • • • 10. Styles • • • • 11. Using Mail Merge Manager 11.

Getting Started with Word • • • • • 2. Creating and Saving Documents 2. Creating and Saving Documents • • • • • • 3. Printing Documents 3. Printing Documents • • • • 4.

Also, one option I really like is choosing Commands Not in the Ribbon from the dropdown. That way you can easily see which commands are already not on the ribbon and then add any you feel you’ll need. At the bottom of the screen, you’ll see three sheets, named Sheet1, Sheet2, and Sheet3. This is the default number that every Excel workbook starts off with. On older versions of Excel the task pane was located on the right side of the screen, however that has now been removed and all the functions have been moved to the File tab. This is where you can perform many common tasks such as opening a workbook, creating a new one, printing and more.

Data can be entered without the headings I entered in row 1. Step 3 - Creating the chart - Note: this chart will be created without using the Chart Wizard. When data has been entered and your cursor is immediately below the entered date, press the F11 key on the top row of your keyboard. Step 4 - Viewing the Charts Gallery - There are things that you probably wish to change about the chart. The new Office 2008 allows you to quickly make those changes.

Excel can do this for you very quickly, so let’s see how. First off, let’s enter some data into the cells in Excel. In Excel, the columns are labeled starting from A and continuing to Z and beyond.

Working with Columns 13. Working with Columns • • • • 14. Working with Graphics 14. Working with Graphics • • • • • • 15. Document Sharing and Collaboration 15.

Excel 2008: Create a Chart or Graph Step 1 - Reassign F11 - Pressing the F11 key on a Macintosh will minimize all applications, displaying the desktop. Pressing the F11 key can be used to create a quick graph, but you must first reassign the function assigned to that key. From the Apple menu, select System Preferences and then select Expose & Spaces. Click on the right end of the Show Desktop area and select something other than F11. If you want a quick way to see the Desktop select something other than the dash. Step 2 - Data entry - Enter data collected with your survey. For this example I took a survey of my class asking them to name their favorite fruit.

Data can be entered without the headings I entered in row 1. Step 3 - Creating the chart - Note: this chart will be created without using the Chart Wizard. When data has been entered and your cursor is immediately below the entered date, press the F11 key on the top row of your keyboard.

No need to type the cells one by one! Go ahead and select cells B2 to D2 and you will see that the formula is automatically updated and is in blue. After you select the range, type in the closing parenthesis (Shift + 0) and press Enter. And now you have the sum of the numbers! Not too hard right!? However, you might say that it would be a royal pain to do this for a set of 100 or 500 students!

Work with sheets and data Title Description Work with cells, rows, and columns. Use the Paste Special command to copy and paste special cell contents or attributes. Keep column headings visible while you scroll. Change the width of columns so that you can see all the data in cells. Prevent unauthorized changes, moves, or deletions of important data.

Formatting Pages 6. Formatting Pages • • • • • • • • 7.

If you have Microsoft Office installed, but have never touched Excel before because you either didn’t know how to use it or didn’t know what it could do for you, then you MUST read this post on learning how to use Excel! Microsoft Excel is a powerful spreadsheet application that can be used for anything from a simple database all the way up to a full fledged Windows application full with windows forms, macros, and add-ons.

Sorting Data 12. Sorting Data • • • • 13.

Word on the Mac like you've never seen it before. In this title we'll explore most of the basic two intermediate concepts of Microsoft Office Word 2008 for the Mac, which I shall refer to as Word from here on in, just because it's a mouthful, and well, I'm a little bit lazy. Word, as I'm sure you know by now, is the world's leading word processing application. It can be used to work on a wide variety of documents.

Since Office 2008 removed support for Visual Basic macros, see one way to get around this limitation. After watching this video, you'll be able to: * Understand the limitation associated with Visual Basic macros in Excel 2008. * Use Excel 2004 and Excel 2008 at the same time to work with Excel workbooks that contain Visual Basic macros.

See a list of known issues as well as potential workarounds.

Editing and Formatting Text • • • • • • • 5. Formatting Paragraphs 5.

Working with Graphics • • • • • • 15. Document Sharing and Collaboration 15. Document Sharing and Collaboration • • • • • • • • • 16. Working with Long Documents 16. Working with Long Documents • • • • • • • Conclusion Conclusion •.