1 / 11

MS Excel Tool

MS Excel Tool. Column Arranger v1.0. Agenda. Purpose Target User Benefits System Requirement User Guide Introduction Step 1 Step 2 Step 3. Purpose. Column Arranger tool is used to automatically re-arrange the order of columns in MS Excel report to a predefined format. Target Users.

upton
Download Presentation

MS Excel Tool

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. MS Excel Tool Column Arranger v1.0 Property of Cracking Siebel

  2. Agenda • Purpose • Target User • Benefits • System Requirement • User Guide • Introduction • Step 1 • Step 2 • Step 3 Property of Cracking Siebel

  3. Purpose Column Arranger tool is used to automatically re-arrange the order of columns in MS Excel report to a predefined format. Property of Cracking Siebel

  4. Target Users • Business Users/Managers • Reporting Team • Data Conversion Team • EIM Team Property of Cracking Siebel

  5. Benefits • Increased Team Efficiency • Manual arrangement of column takes >20 minutes • This tool can complete the task <5 seconds • MS Office Platform • No installation is required. • Wide acceptance of MS Office enables high availability of the tool. Property of Cracking Siebel

  6. System Requirements • Windows XP or higher. • MS Excel 2003 or higher. • Macros should be enabled in MS Excel. • Please note that Openoffice is not supported. Property of Cracking Siebel

  7. To rearrange the columns: Copy the source data in sheet – Original_Report Copy the column header in sheet – Formatted_Report Run the macro User Guide - Introduction Property of Cracking Siebel

  8. Copy the source data in Original_Report sheet The data which you want to reorder, place it in the first sheet, namely Original_Report. Do include the column headers User Guide – Step 1 Property of Cracking Siebel

  9. Add column header in Formatted_Report sheet Decide the column order you require Add the header to second sheet – Formatted Report Please make sure that column names match their respective column names in source sheet User Guide – Step 2 Property of Cracking Siebel

  10. Run the macro Go to the Macro menu Select ‘ColumnArranger_Macro’ Click Run User Guide – Step 3 Property of Cracking Siebel

  11. Thank you ! Property of Cracking Siebel

More Related