- Using the Excel 2013 Interface
- Feb 20, 2013
- This chapter introduces the Excel 2013 interface elements such as the ribbon, formula bar, and status bar.
|
- Forcing the Constant in Regression to Zero: Understanding Excel's LINEST() Error
- Feb 12, 2013
- One of the options in Excel's LINEST() function is to force the constant in the regression equation to a value of zero. This article focuses on a serious error in the LINEST() results when the option is selected. The error was not corrected until Excel 2003, and it remains in Excel 2010.
|
- Getting Started with PowerPoint: Set Up a Theme
- Oct 25, 2012
- This chapter explains the colors, fonts, and effects - the steps to defining your theme elements - that form the foundation of a PowerPoint template.
|
- Predictive Analytics in Microsoft Excel: Building Your Own Data Collector
- Aug 22, 2012
- Suppose you supply a product that another company or companies resell on their own websites. Although those companies might share their web traffic information with you, it’s more likely that they regard it as proprietary. This chapter show how to retrieve data from the web and perform analytics without the active cooperation of the source website.
|
- Rotating Factors with Excel using Varimax
- Jun 25, 2012
- Conrad Carlberg discusses a method in Excel used to rotate principal components to a simple structure that clarifies the meaning of the factors.
|
- Using Principal Components in Excel
- Jun 22, 2012
- Conrad Carlberg describes a test using Excel that looks at how states in different regions of the United States exhibit similar crime patterns.
|
- What to Expect from Microsoft Office 15
- Jun 5, 2012
- Office 15 promises to be the most significant Microsoft Office release in quite some time. Brien Posey explains why this new release is such a big deal and what you can expect from it.
|
- The Significance of Microsoft OneNote Mobile for Android
- Apr 13, 2012
- Peter O'Kelly provides an overview of the new OneNote Mobile app for Android and its role in the expanding OneNote product family.
|
- What’s New with Evernote? Five Big Features
- Mar 19, 2012
- Katherine Murray introduces five new features recently rolled out for Evernote users.
|
- Revisiting the Evernote/Microsoft OneNote Competitive Landscape
- Mar 9, 2012
- Peter O'Kelly highlights some of the differences between Evernote and Microsoft OneNote.
|
- OneNote for iPad: Ample Room for Improvement
- Mar 8, 2012
- Peter O'Kelly explains how the limitations in the initial release of OneNote for iPad might frustrate people who have more elaborate information-management needs.
|
- OneNote for iPad: A Hopeful Leading Indicator
- Mar 7, 2012
- Peter O'Kelly provides an overview of OneNote for iPad, along with some analysis of what Microsoft may do next with OneNote for Windows, iPad, and other platforms.
|
- Tweeting To and From Your Evernote Account
- Mar 5, 2012
- Katherine Murray shows how you can follow people and subjects on Twitter that bring the information you're looking for right to your browser window. And, thanks to Evernote, you can send the tweets you want to keep directly to your Evernote notebook, too.
|
- Capturing Audio Notes in Evernote
- Mar 2, 2012
- Katherine Murray shows you how to record, save, and manage audio notes in Evernote, whether you’re using a desktop computer or a mobile device.
|
- Alternatives To Apple’s iWork Apps For Managing Microsoft Office Files On An iPad
- Mar 1, 2012
- Jason R. Rich offers a handful of solutions for iPad users who want to create, view, edit, print, and share Microsoft Office-compatible files and documents on their tablet.
|
- Excel Web App Improvements, Part 2
- Dec 13, 2011
- Laura Acklen covers the enhancements to the Excel Web App in the second installment in a multi-part series.
|
- Adding Ink in Microsoft OneNote
- Dec 12, 2011
- After a brief but vigorous campaign by pen users, Microsoft added ink rendering to its OneNote Web App. Office expert Laura Acklen walks you through it.
|
- Excel Web App Improvements, Part 1
- Dec 12, 2011
- Laura Acklen describes (in this first in a multi-part series) the latest updates to the Excel Web App.
|
- Microsoft Office 365 First Impression
- Sep 12, 2011
- Tom Bunzel runs through some of the key features and capabilities of Microsoft Office 365.
|
- New Versions of Pages, Numbers, and Keynote Make Work on the Go Easier
- Sep 7, 2011
- Jason R. Rich explains some of the newest features added to the latest versions of the Pages, Numbers, and Keynote iPad apps, plus offers a preview of what you'll be able to do with these apps once iOS 5 is released this Fall.
|