A data source for a mail merge operation can be a microsoft excel worksheet, the office address book, a filemaker pro database, or a microsoft word document. Why they changed the name for the windows side, i dont know, but its called the list feature on the mac. When you open excel, the excel workbook gallery opens. I have a few cells in a column displaying formulas instead of results. Getting started with microsoft excel and its new features within the office for mac. If youre into archeology, mac excel 2008 supports xlm macros a. Training tutorials and videos from official microsoft download center. Word 2008 for mac essential training linkedin learning. 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. Rename a worksheet doubleclick a sheet tab to change its name. Get the most out of microsoft office 2008 for mac with handy tips for working in office in general as well as wordprocessing in word, making spreadsheets in excel, creating powerpoint slides, and emailing with entourage. See the full list of keyboard shortcuts, organized into logical categories.
Microsoft excel 2008 its been more than three years since the last update to excel, the leading mac spreadsheet. It provides a variety of template choices and quick access to recent workbooks. Applying themes in different applications under office 2007 and office 2010 for windows has already been discussed in our previous tutorials. Solver for mac excel 2008 looks and behaves very much like solver for excel 2004. To create a pdf from your current document, go to the. Youll have a hard time finding relevant documentation about xlm, as it appears to have gone out of fashion many years ago. The first time you save your spreadsheet, click on file, then on save as. Microsoft excel 2008 pivot table tutorial for mac using the. The microsoft office for mac team shows you just how to build formulas by using the new formula builder in. Learn how to use excel for mac, from beginner basics to advanced techniques, with online video tutorials taught by industry experts. It depends on your level of proficiency with excel, but excel for mac is just fine. Microsoft office 2008 free version download for mac os x. In the small pivottable box that appears, click either.
Of course, you can also find help on the microsoft office for mac support page from the office community and support team. Pivot tables for data analysis, microsoft most valuable professional curt frye helps dispel the common fear of the pivot table feature, demonstrating how to use this powerful tool to discover valuable business intelligence. Applying themes in word, excel, and powerpoint 2008 for mac. Solver 2008 for mac solver excel solver, optimization. A university of michigan library instructional technology workshop. Get started quickly with new, modern versions of word, excel, powerpoint, outlook and onenotecombining the. Word 2008 for mac comes with professionally designed templates that you can use to create brochures, calendars, forms, flyers, labels, and more. If you use office 2008 for mac, you should be aware that microsoft. Click anywhere in the data and then from the view menu choose view toolbars list. How to stay in charge of spreadsheets in excel 2008 for mac. This article describes how to use the mail merge manager that is included in word 2008 for mac to create mailing labels or envelopes. A short tutorial demonstrating how to create a simple database.
According to this article, the mac bu at microsoft is working on a way to get that pack available again for mac. Getting started with excel 2008 for mac is easy, and this video overview will show beginners or even the most seasoned professional. Can i download the analysis toolpak for my mac for excel. Use excel for mac 2011 to check out a sharepoint file so that only you can make changes. Excel tutorial using microsoft 2008 for mac youtube. If you are taking vba classes, the assumption will be that it is windowsbased and either excel 2003 vb 6. Compatible with excel 2007, excel for mac 2008 sheets now support more than 1 million rows and 16 thousand columns each. Generate barcodes in microsoft word or excel for mac with ease. Create a new blank workbook in excel, you create and save data in a workbook. Edit cells doubleclick a cell to edit the cell formula or cell contents on the worksheet. Excel for mac online courses, classes, training, tutorials on lynda. Excel 2004 have vba support based on vb 5, which is the equivalent of excel 97 on the windows side, and that will not be sufficient for any class work. Using excel for mac 2008, but the issue is the same when using windowsexcel 2007.
Be sure to save your spreadsheet every 1015 minutes so you wont lose all of the work youve done if the computer loses power or freezes. Pivot tables for data analysis, microsoft most valuable professional curt frye helps dispel the common fear of the pivot table feature, demonstrating how to use this powerful tool to discover. Tutorial for excel 2008 i am just beginning with excel 2008 for mac and am encountering a lot of issues which i do not understand. If you need additional support, you might consider purchasing a subscription to to take advantage of its thorough office for mac tutorial. For basic operations like simple formulas, sorting. Microsoft excel 2008 pivot table tutorial for mac using. Office 2008 was developed by microsofts macintosh business unit and released on january 15, 2008. Using microsoft excel 2008 macintosh to create a chart. The microsoft office for mac team shows you just how to deal with visual basic macros in this howto video. Microsoft excel 2008 pivot table tutorial for mac using the federal campaign donation data from the syllabus. I have been a pc user but decided to change to mac, i was told that everything would work the same once i had the programs installed, or if they didnt a. Instead of always going to the community for help i would like to get a detailed tutorial for excel 2008. Using the split and freeze features tutorial duration.
Microsoft office 2008 for mac allinone for dummies cheat. Solver now available for microsoft excel 2008 for mac. Getting started wtih excel 2008 mac university of michigan library. You can start with a blank workbook, an existing saved workbook, or a template. Excel 2008 for the mac i have done some searching and have just realised excel 2008 does not support macros,if only they had mentioned that when i was thinking of upgrading to office 2008. Word excel powerpoint entourage microsoft server exchange support automator actions for workflows in microsoft officecheck out the demonstration video with new features in office 2008 for mac. Curt shows how to create pivot table reports from internal excel data and outside data sources, use filters to focus on the most important data in the sheet, and prepare a pivot table report by applying formats and rules. To do the same in office 2008 for mac, the procedure is little different. Shows how to create pivot table reports, an amazing tool for data analysis, using internal excel data and outside data sources. You could always do it before, but now with the new formula builder feature, building formulas just got one step closer to simple. Applescript tutorial for excel using universal fonts this tutorial is designed to guide mac users implementing applescript within excel for mac 2004 and 2008. Microsoft office 2008 is a suite of products that allow you to create fantastic looking documentsfrom dynamic presentations to stunning reports and engaging communications. The intrinio excel addin is supported on both windows and mac, including the following operating systems. The table feature in excel for windows got its start in excel 98 on the mac.
Its not free, but its still a great resource if you need to learn the software quickly. Visual basic macros are no longer supported in excel 2008 for mac, which might make things a little difficult for you if youre used them a lot in the past, or if somebody else gives you spreadsheets using them. Pressing the f11 key can be used to create a quick graph, but you must first reassign the function assigned to that key. I was a power user on pc and now am a power user on mac. Excel 2008 for mac basic formulas and autosum youtube. Step 1 reassign f11 pressing the f11 key on a macintosh will minimize all applications, displaying the desktop. In word 2008 for mac essential training, instructor david rivers examines each important feature of this ubiquitous word processing software. Excel 2008 for mac makes it easy to create formulas for cells. Hampshire college information technology 9,641 views. Utilize the highquality design layouts and styles that are always within easy reach via excels elements gallery. Do your best workanywhere, anytime and with anyone. How to use the mail merge manager to create mailing labels.
Most programs on your mac, including excel, can create pdf files. Excels powerful, predefined formulas, data import tools, and new helpful layouts will guide you through what. How to open microsoft excel spreadsheets using apple. Hi, right now, 2008 does not support vba, which is what the tool pack is based on. Enter a formula excel for mac microsoft office support office 365. For example, the date 1092008, the number 210, and the text quarterly earnings are all constants. Open statplus you will repeat this part at least once more a. Microsoft excel 2008 data analysis walkthrough for mac.
You can also export spreadsheets in numbers so that they. You can customize these word templates to make them appear just the way you want. Hi, i come from windows and excel 2007, and cannot find the possibility to create a new macro in excel 2008 save macro in excel for pc. Excel 2008 for mac workspace and view options overview duration. If you open a workbook with a solver model that you created in excel 2004, or in most other versions of excel, the model will appear automatically in this dialog you can just click solve. Formulas are equations that perform calculations on values in your sheet. Applescript tutorial for microsoft excel for mac using. Is there a way to create macros in excel 2008 for mac. Use these quick steps for your most common activities. Here also you will find plenty of builtin themes which you can choose from. Hampshire college information technology 3,809 views. This course can only be played using a subscription. Solver is an excel addin that allows linear programming analysis tool for excel which was initially released for the mac when excel 2004 shipped but was dropped from excel 2008 due to its.
835 212 570 32 1627 869 1659 1118 376 1219 59 892 1090 874 784 924 1172 1275 523 1251 822 1299 1384 400 520 4 566 82 316 1340 964 1484 1318 1203 520 1633 196 127 53 278 1371 220 1309 150 1017 1017 900 1223