{lang: ‘ar’}In Excel Transpose is a Function used to switch the columns and rows. It switches the columns cell values as rows and vice versa. Transpose can be done by the following methods (1) Using Paste Special and (2) Using Function TRANSPOSE Using Paste Special Consider the example below. We will switch the column headings [...]
{lang: ‘ar’}Formatting a spreadsheet with alternate row colors makes it easy to read, especially if there are several rows with varied information. In Excel 2007 it can be done by one of the following methods: Using AutoFormat Using formulas in Conditional Formatting Using AutoFormat Excel has a standard AutoFormat feature that enables one to format [...]
{lang: ‘ar’}Introduction In Excel 2003 it was possible to retrieve data from a SharePoint list and keep it synchronized. In Excel 2007 you can still export the SharePoint list to Excel, though the ability to synchronize data with the SharePoint list is not available. Access 2007 is now the preferred mode to synchronize data with a [...]
{lang: ‘ar’} Introduction If you maintain data in a spreadsheet the columns and data can be imported to SharePoint. The imported data becomes a list. The steps are outlined below for SharePoint Foundation 2010 and Excel 2007. Application Used SharePoint 2010 Foundation Microsoft Excel 2007 Steps Select Site Actions > More Options Select Import Spreadsheet and click [...]
{lang: ‘ar’}View Side by Side option in Excel makes it easier to compare two worksheets. For example, you have a personal budget worksheet with yearly income and expenditure figures. You also have a similar budget worksheet with some revised estimates. Use Side by Side option to quickly compare the two worksheets. Open the two worksheets [...]
{lang: ‘ar’}PivotTable helps organize data from an existing data source to facilitate analysis. The data source can be either an Excel workbook (stored locally) or it can be from an external data source such as a relational database, or a Sharepoint list etc. This article relates to Excel 2007 and uses an internal data source. For OpenOffice [...]
{lang: ‘ar’} If your worksheet has several pages, it will be useful to have the header row repeat in all the pages. This will improve productivity as the user need not flip to the first page to view the header row columns. These steps are applicable for Excel 2007. Click here for Excel 2003 The [...]
{lang: ‘ar’} Track Changes, as the term suggests, is a feature in that helps keep track of the revisions made to a document. This feature is commonly used when two or more users work on the same document or when a document passes through a review cycle. Let us assume that you work on a [...]
{lang: ‘ar’}This article outlines the steps required to create macro button. For example, if you have a macro enabled worksheet and would like the user to have the option to refresh data as required, have a macro button in the worksheet to initiate refresh of the data. The refresh data cited is just an example. [...]
SharePoint Foundation 2010 A Day to Day ReferenceThis book explains the concepts in SharePoint Foundation 2010 that you are most likely to perform on a daily basis with step-by-step instructions and examples.
SharePoint 2010 Issue Tracking System - Design, Create, and ManagePage optimized by WP Minify WordPress Plugin