Microsoft Excel
Finding Formula Errors in Excel 2010
Synopsis: In this article we look at how to locate formula errors in an Excel 2010 workbook. We also show you how to setup Excel to warn you about errors in formulas. Fac LinkedinTwitter Excel 2010 may detect an error in one of the formulas you are using in a workbook. When it does, it…
Exporting to Microsoft Excel in Project 2010
Synopsis: Sometimes you need to process project information in a way that Project 2010 itself does not support. In this article, we look at the facilities in exporting project data to Microsoft Excel. Project 2010 includes flexible facilities for both the import and export of data. Wizard features are provided to assist with both of…
Creating PDF and XPS documents in Excel 2010
Synopsis: In this article we look at how to convert a workbook to PDF or XPS format. These formats are readable by people who do not have Excel 2010 installed. Excel 2010 is a very popular spreadsheet program, but not everybody has it installed. To share a workbook with people who do not have Excel…
Creating and Formatting Sparklines in Excel 2010
Synopsis: Sparklines were introduced in Excel 2010. In this article, we look at how to create and format these tiny charts. Until now Excel charts have been graphic objects that are generally positioned and sized independently of worksheet cells. In Excel 2010 Microsoft introduced the Sparkline, a new type of chart that actually lives in…
Creating a Chart with Excel 2010
Synopsis: In this article we look at how to create charts in Excel 2010. The ability to create informative and good looking charts is one of the great strengths of Excel 2010. Recent versions of MS Excel have not only made this process easier, but have added powerful additional design and formatting features. A chart…
