Publishers of technology books, eBooks, and videos for creative people
Maria Langer explains how to perform a variety of tasks with workbook sheets, windows, and files in Excel 2007.
Join Maria Langer as she dives into Excel 2007 and shows you how to create a worksheet to use for professional budgeting.
Today’s Office 2008 Automator workflow is for Excel. This workflow will retrieve a list of selected tracks in iTunes. It will then create a formatted and sorted list of the names of those tracks in a new Excel workbook and save that workbook in HTML format. You could then incorporate the HTML into your Web site to display a list of your favorite iTunes tracks.
Mac users are probably aware that Microsoft released a new version of Office back in January. The new Office 2008 includes loads of new features and options, including more than 90 Automator actions (which I actually developed under contract) for Entourage, Excel, PowerPoint, and Word. Using these actions, you can now integrate your Office applications together—as well as other applications such as iCal, iTunes, iPhoto, and Safari—to create simple automated workflows. Throughout this week, I will be discussing the Office 2008 Automator actions and giving you some examples of things that can be done with them.