| 1. | - Microsoft Office Goes to Where the People Are: Facebook!
- By
Pat Kinsel
- Aug 6, 2010
- Docs from Microsoft's Future Social Experiences Labs enables you for the first time to discover, create and share Microsoft Office documents directly with your Facebook friends, using the Office tools you already know and love.
|
| 2. | - Unleash the Power of Excel with VBA
- By
Bill Jelen, Tracy Syrstad
- Aug 5, 2010
- This chapter introduces the features and functions of Excel and VBA, showing you how to create and run macros and understand their inner workings using the VBA editor.
|
| 3. | - Microsoft Excel 2010 Keyboard Shortcuts
- By
Bill Jelen
- Jul 29, 2010
- This chapter points out which of the old Excel keyboard shortcuts still work, shows you some new Excel 2010 shortcuts, and introduces you to the new keyboard accelerators.
|
| 4. | - The Promise of PowerPivot in Excel 2010
- By
Bill Jelen
- Jul 27, 2010
- This chapter walks you through one process of building a PowerPivot report in Excel 2010. You will learn how simple it is to merge data from two sources in a single PowerPivot pivot table.
|
| 5. | - Calculated Data Type in Microsoft Access 2010
- By
Scott B. Diamond
- Jul 26, 2010
- This article introduces the new Calculated Field data type added to Access 2010. It discusses how they work and shows how to create them.
|
| 6. | - Collaboration with OneNote 2010: Research, Write, and Collaborate Using OneNote 2010's Sharing Features
- By
Dianne Siebold
- Jul 13, 2010
- Dianne Siebold explores the collaboration features and improvements in Microsoft OneNote 2010.
|
| 7. | - Entering Text in Word 2010
- By
Sherry Kinkoph Gunter
- Jul 13, 2010
- This chapter shows basic techniques for entering and manipulating text in Word 2010, including Quick Parts and symbols.
|
| 8. | - Enhanced Connectivity from SQL to SharePoint to Office
- By
J. Peter Bruzzese
- Jul 12, 2010
- Flexible dynamic data access is an impressive improvement to SharePoint 2010 that provides both read and write capabilities back to an external data source, like SQL, so that you can adjust data between Office, SharePoint and SQL. In this article we will show you how!
|
| 9. | - Entering and Managing Data in Excel 2010
- By
Michael Alexander
- Jul 12, 2010
- This chapter shows the flexibility of Excel in providing various ways to enter/change data, insert cells, rows, and columns, search for and manipulate existing data, leave comments for yourself (or others), and even check spelling.
|
| 10. | - Placing Your Bets on Office for Mac 2011
- By
Yvonne Johnson
- Jul 9, 2010
- Yvonne Johnson describes Microsoft's strategy for Mac Office 2010: to get Mac Office 2010 caught up with WinOffice 2007 and make it as compatible as possible with the new features introduced in WinOffice 2010.
|
| 11. | - Summarizing Business Transactions in Excel 2010: From the Journals to the Balance Sheet
- By
Conrad Carlberg
- Jul 7, 2010
- This chapter shows how you can use Excel to create an account structure in a workbook that contains both a general journal and special journals, and in a workbook that contains both a general ledger and subsidiary ledgers.
|
| 12. | - Microsoft Access 2010 and SharePoint 2010: A Match Made in Redmond
- By
Roger Jennings
- Jul 5, 2010
- Roger Jennings describes Microsoft Access 2010’s latest SharePoint 2010-based Web database features.
|
| 13. | - DIY Desktop Calendar with Microsoft Publisher 2010
- By
JoAnn Paules
- Jun 28, 2010
- Microsoft Publisher was designed to give you the tools you need to create your own beautiful desktop calendar. Using clip art or your own photo, you can easily create a stunning desktop wallpaper calendar.
|
| 14. | - Make Your Own Shapes in Microsoft PowerPoint 2010
- By
Echo Swinford
- Jun 28, 2010
- Learn to use the Combine Shapes tools — Union, Combine, Intersect and Subtract — to create your own shapes in PowerPoint 2010.
|
| 15. | - Microsoft Word 2010: Now's the Time to Upgrade
- By
Todd Meister
- Jun 28, 2010
- Todd Meister shows new features in Microsoft Word 2007 and Word 2010 that will make you a more productive user.
|
| 16. | - Access 2010 Macros: A New Way of Programming
- By
Alison Balter
- Jun 25, 2010
- This exciting article takes you on a tour of the new Access 2010 macro designer and the new features available with Access macros. After reading the article, you will be comfortable with the Access 2010 macro designer and will be able to take advantage of all that it offers.
|
| 17. | - Add Captions and Callouts to Your Video in Microsoft PowerPoint 2010
- By
Echo Swinford
- Jun 21, 2010
- Add captions to your videos using the new Trigger to Bookmark features in PowerPoint 2010. Learn a bit about animations and other new video features along the way.
|
| 18. | - The New Macro Environment in Microsoft Access 2010
- By
Scott B. Diamond
- Jun 18, 2010
- This article introduces the new macro automation language included in Access 2010. It discusses how and when macros can be used and compares them with VBA.
|
| 19. | - How I Got into Bento
- By
Jesse Feiler
- Jun 15, 2010
- Long-time database user and designer Jesse Feiler shares his experiences with Bento — a very different kind of database.
|
| 20. | - Bento and iPad: The Start of Something New
- By
Jesse Feiler
- Jun 11, 2010
- If you’re looking for a great database to run on iPad, Filemaker’s Bento is a good choice. Jesse Feiler tells you why.
|