Search results

Create the page "Microsoft Excel" on this wiki! See also the search results found.

Page title matches

Page text matches

• Rows/Swimlane Tab
  ...ones into each row based on values from a Microsoft Project or a Microsoft Excel plan’s data column. ...you can group together using values from a Microsoft Project or Microsoft Excel plan’s data column. For example, you could group all rows containing tas
  3 KB (503 words) - 16:55, 6 May 2016
• Task Bars Tab (OnePager Express)
  ...based on” radio button allows you to select a column from your Microsoft Excel plan to assign a data-driven to each task. ...Each endpoint can display the date held in any date column from Microsoft Excel. These properties are essentially the same controls as described above for
  6 KB (899 words) - 16:08, 21 September 2015
• Milestones Tab (OnePager Express)
  ...color. In this option, clicking the drop down provides a list of Microsoft Excel plan columns from which to select. ...the same for Task related Deadlines also allows control over the Microsoft Excel plan column that controls the color and delay color of the deadline decorat
  6 KB (967 words) - 16:07, 21 September 2015
• Legend Tab
  :b) The automatic title may also reflect your Microsoft Project plan columns used for color or shape in conditional formatting.
  10 KB (1,559 words) - 13:03, 10 May 2024
• Advanced Tab (OnePager Pro)
  ...ish dates, the task/milestone name, and the Unique-ID of the task from the Microsoft Project plan. An example is shown below. ...asks (coming in from the second Microsoft Project plan) are from the first Microsoft Project plan when they are clearly not. Having the “Safely combine tasks
  11 KB (1,686 words) - 15:30, 22 September 2015
• Advanced Tab (OnePager Express)
  ...the task/milestone name, and the Unique-ID of the task from the Microsoft Excel plan. An example is shown below. ...king a new project view from the first plan, you open the second Microsoft Excel plan and update the project view in “Replace Snapshot” mode. If the ch
  10 KB (1,672 words) - 15:30, 22 September 2015
• Using Fiscal Years and Weeks (OnePager Express)
  ...t with the single task spanning two standard calendar years. The Microsoft Excel spreadsheet will look like this:
  8 KB (1,320 words) - 16:14, 21 September 2015
• Template Only Features (OnePager Express)
  ...mplates that are designed to focus on summary information from a Microsoft Excel plan. “Detailed” templates are designed to support information at a ta ...bered tasks and milestones that can be imported from the various Microsoft Excel plans. This is necessary so that OnePager can establish a means to support
  8 KB (1,200 words) - 14:53, 22 September 2015
• Splitting and Parsing Columns (OnePager Express)
  ...multiple resources (or anything else). Because assignments from Microsoft Excel often are comma-delimited, this feature enables OnePager to parse the comma ...you want to use color-codes on tasks/milestones based upon your Microsoft Excel plan’s “Resource Names” column as shown below:
  3 KB (527 words) - 15:08, 18 September 2015
• Creating a NEW Project View - OnePager Express
  1) Launch Microsoft Excel and bring up the desired Microsoft Excel plan. 2) Insert a “Flag” column into the Microsoft Excel plan. This will be the flag that OnePager will use to determine which plan
  4 KB (567 words) - 22:34, 17 September 2015
• Creating Another New Project View - OnePager Express
  ...This is accomplished by inserting two or more Flag fields into Microsoft Excel plan’s columns and instructing OnePager to produce additional project vi ...press]] articles). By inserting these three flag fields into the Microsoft Excel plan and appropriately populating the cells with “Yes” and “No”, th
  3 KB (485 words) - 20:44, 15 September 2015
• Opening an Existing Project View - OnePager Express
  ...es not import any new or old data from Microsoft Excel. However, Microsoft Excel needs to be launched so that you can access the “OnePager Express” butt ...oft Excel and bring up a desired Microsoft Excel plan or a blank Microsoft Excel spreadsheet.
  2 KB (331 words) - 16:45, 21 September 2015
• ADDING a Snapshot - OnePager Express
  ...f a regular reporting process for the project. When updated, the Microsoft Excel plan becomes an important source for providing management with updated sche OnePager uses the updated Microsoft Excel plan to ADD snapshots to help manage the project
  4 KB (578 words) - 22:18, 17 September 2015
• REPLACING a Snapshot - OnePager Express
  ...replacing its task/milestone data with updated information from Microsoft Excel. OnePager supports three ways to replace a snapshot: ...Dates and Progress” mode, PLUS it updates the task names from Microsoft Excel. It will also refresh fields that are used for row and swimlane organizatio
  3 KB (525 words) - 22:18, 17 September 2015
• Easier Multi-Source File Reports
  ...eir OnePager Pro ('''OPP''') reports without the need for a master file or Microsoft Project integrated master schedule ('''IMS'''). ...nformation necessary to later associate the Microsoft Project or Microsoft Excel files with the multi-project project view. Below is an example.
  5 KB (723 words) - 09:26, 11 February 2024
• OnePager Desktop Shortcut
  ...versions were embedded into Microsoft Project for '''OPP''' and Microsoft Excel for '''OPX'''. We have retained these capabilities in '''OPP''' and '''OPX 2) Launching '''OPP''' and '''OPX''' from Microsoft Project and Microsoft Excel remains fully functional. Now, you can click the above icons to launch '''
  7 KB (1,163 words) - 16:25, 23 November 2016
• Smarter Installer
  ...required the user to know the '''bitness''' of his or her installation of Microsoft Office and select the appropriate matching installation download package li ...er a need to be concerned about this distinction between 32-bit and 64-bit Microsoft Office.
  1 KB (204 words) - 13:58, 23 February 2016
• Installing and Activating OnePager Express for Version 5.3 (Portal)
  ...o installation options to launch '''OPX''' as an '''Add-in''' to Microsoft Excel and a new option to launch '''OPX''' directly from a '''desktop''' icon. (S ...these two options is selected, your computer still requires that Microsoft Excel be installed and available.
  6 KB (907 words) - 19:47, 10 July 2016
• Getting Started with Version 5.3 (Portal)
  ...you will be importing your data from either Microsoft Project or Microsoft Excel, the two sets of article links below are organized in the table below so th
  2 KB (267 words) - 19:44, 10 July 2016
• Getting Started with OnePager Express Version 5.3 Add-in
  ...can be launched from a '''desktop''' icon as well as from within Microsoft Excel. ...the '''Getting Started''' process when you launch '''OPX''' from Microsoft Excel.
  21 KB (3,448 words) - 14:21, 3 March 2016
• Getting Started with OnePager Express Version 5.3 Desktop
  ...can be launched from a '''desktop''' icon as well as from within Microsoft Excel. ...des '''Getting Started''' guidance when launching '''OPX''' from Microsoft Excel is at [[Getting Started with OnePager Express Version 5.3 Add-in | Getting
  21 KB (3,480 words) - 14:21, 3 March 2016
• Uninstalling OnePager Express for Version 5.3
  ...uninstalled from your computer so that it no longer appears when Microsoft Excel is launched. [[Category:Microsoft Excel]]
  839 B (121 words) - 16:39, 2 March 2016
• Creating a NEW Project View - OnePager Express Add-in for Version 5.3
  1) Launch Microsoft Excel and bring up the desired Microsoft Excel plan. 2) Set a '''flag''' column into the Microsoft Excel plan. This will be the '''flag''' that OnePager will use to determine which
  5 KB (820 words) - 15:47, 3 March 2016
• Creating a NEW Project View - OnePager Express Desktop for Version 5.3
  1) Set a '''flag''' column into the Microsoft Excel plan. This will be the '''flag''' that OnePager will use to determine which ...'''BROWSE FILES…''' option as shown below to select a desired Microsoft Excel source file.
  6 KB (968 words) - 15:53, 3 March 2016
• Creating Another New Project View - OnePager Express Add-in for Version 5.3
  ...is accomplished by inserting two or more '''Flag''' fields into Microsoft Excel plan’s columns and instructing OnePager to produce additional project vi ...r customer. By inserting these three '''flag''' fields into the Microsoft Excel plan and appropriately populating the cells with '''Yes” and “No''', th
  4 KB (662 words) - 17:16, 16 September 2016
• Opening an EXISTING Project View - OnePager Express Add-in for Version 5.3
  ...icrosoft Excel needs to be launched so that you can access the '''OnePager Excel''' button. The steps to open an EXISTING project view from within Microsoft Project are shown in the steps below:
  4 KB (624 words) - 16:32, 3 March 2016
• Opening an EXISTING Project View - OnePager Express Desktop for Version 5.3
  ...Using this methodology does not import any new or old data from Microsoft Excel. ...ePager to retrieve and display it. No data are imported from any Microsoft Excel plan.
  4 KB (586 words) - 16:33, 3 March 2016
• REPLACING a Snapshot via Push Update - OnePager Express Add-in for Version 5.3
  ...does in '''Dates and Progress''' mode plus it updates the task names from Microsoft Project. It will also refresh fields that are used for row and swimlane org 4) OnePager uses the updated Microsoft Excel plan to REPLACE snapshots.
  6 KB (877 words) - 19:45, 3 March 2016
• ADDING a Snapshot Via Push Update - OnePager Express Desktop for Version 5.3
  ...ked up as part of a regular reporting process. When updated, the Microsoft Excel plan becomes the source for reporting schedule updates. OnePager uses the updated Microsoft Excel plan to add snapshots to record how the project changes from reporting peri
  5 KB (718 words) - 16:53, 3 March 2016
• ADDING a Snapshot via Push Update - OnePager Express Add-in for Version 5.3
  ...ked up as part of a regular reporting process. When updated, the Microsoft Excel plan becomes the source for reporting schedule updates. OnePager uses the updated Microsoft Excel plan to add snapshots to record how the project changes from reporting peri
  4 KB (688 words) - 16:53, 3 March 2016
• REPLACING a Snapshot via Push Update - OnePager Express Desktop for Version 5.3
  ...does in '''Dates and Progress''' mode plus it updates the task names from Microsoft Project. It will also refresh fields that are used for row and swimlane org 4) OnePager uses the updated Microsoft Project plan to REPLACE snapshots.
  6 KB (899 words) - 19:47, 3 March 2016
• Creating a NEW Project View via Pull Operation - OnePager Express for Version 5.3
  1) Let’s suppose you have a Microsoft Excel plan that you want to present to two different audiences – Your Project M ...reparation, you '''flag''' the rows to be shown to the PMO using Microsoft Excel’s '''Show It1''' column and put a '''Yes''' in the appropriate rows. You
  8 KB (1,229 words) - 20:19, 3 March 2016
• REPLACING a Snapshot via Pull Operation - OnePager Express for Version 5.3
  ...ever, on 12/3/2015 you receive new information that updates your Microsoft Excel plan. You now want to update the project view’s snapshot for 12/1/2015 t ...that there are two different project views created form this one Microsoft Excel plan:
  8 KB (1,330 words) - 16:58, 4 March 2016
• Handling Microsoft Excel Spreadsheets Containing Multiple Projects
  Representing multiple projects originating in a single Microsoft Excel plan can be easily done using the Rows and Swimlanes feature. One method is to add a column to your Microsoft Excel plan with a column name of “Project.” This name is recognized by OnePa
  2 KB (248 words) - 16:25, 18 January 2016
• Making Multi-Project Graphs from Separate Microsoft Excel Plans for Version 5.3
  ...mportant schedule items. You can do this as long as the related Microsoft Excel plans are constructed with unique '''Task ID''' column contents. This is necessary because unlike Microsoft Project, Microsoft Excel does not automatically provide a unique identifier for rows. Additionally,
  7 KB (1,050 words) - 19:59, 4 March 2016
• ADDING a Snapshot via Pull Operation - OnePager Express for Version 5.3
  ...15/2015 you receive updated status information that updates your Microsoft Excel plan accordingly. You now want to add this latest status information to yo ...that there are two different project views created form this one Microsoft Excel plan:
  9 KB (1,406 words) - 17:07, 4 March 2016
• Creating Another New Project View - OnePager Express Desktop for Version 5.3
  ...is accomplished by inserting two or more '''Flag''' fields into Microsoft Excel plan’s columns and instructing OnePager to produce additional project vi ...r customer. By inserting these three '''flag''' fields into the Microsoft Excel plan and appropriately populating the cells with '''Yes” and “No''', th
  4 KB (700 words) - 16:13, 3 March 2016
• Custom Update (Replacing) of a Snapshot via Pull Operation - OnePager Express for Version 5.3
  ...ly updating the snapshot in view by '''pulling''' in the updated Microsoft Excel plan's '''source file''', OnePager presents you with the standard OnePager 2) For this example, let’s suppose you have a Microsoft Excel plan for which you have already created a snapshot for a particular date, s
  8 KB (1,336 words) - 17:27, 4 March 2016
• Using the OnePager "Data" Tab's "Selected file(s)" Button
  ==Validating Source Files (Microsoft Project or Microsoft Excel)== ...ew named '''BlueGrass 2J-303-Working'''. That project view would have the Microsoft Project name and path name saved in the '''.TAM''' file.
  9 KB (1,536 words) - 17:44, 4 March 2016
• Merging the Wrong Tasks into a Project View for Version 5.3 - OnePager Express
  ...snapshots from period to period with updated information from a Microsoft Excel plan. The tasks that are presented to OnePager in '''UPDATE''' mode should ...Microsoft Excel plan if you are making several project views from the same Microsoft Project plan using several '''flag''' fields.
  11 KB (1,905 words) - 17:48, 4 May 2016
• Making Multi-Project Graphs from Separate Microsoft Excel Plans
  ...n contents. This is necessary because unlike Microsoft Project, Microsoft Excel does not automatically provide a unique identifier for rows. Additionally, ==Preparation for Making a Multi-Project Graph from Separate Microsoft Excel Plans==
  6 KB (906 words) - 16:32, 18 January 2016
• Handling Microsoft Excel Spreadsheets Containing Multiple Projects For Version 5.3
  Representing multiple projects originating in a single Microsoft Excel plan can be easily done using the Rows and Swimlanes feature. ==Multi-Project Excel Spreadsheet==
  4 KB (687 words) - 18:44, 4 March 2016
• Hiding/Unhiding/Moving/Finding/Changing/Resizing Tasks/Milestones for Version 5.3
  ...the integrity of the data received from the Microsoft Project or Microsoft Excel plan that provided the task/milestone’s original '''Start''' and '''Finis
  7 KB (1,167 words) - 21:24, 3 May 2016
• Labeling Task/Milestone Dates for Version 5.3 (OnePager Express)
  ...''' data imported from the Microsoft Excel plan. Every task in a Microsoft Excel plan has a designated '''start and finish date'''. A milestones’ '''start
  6 KB (853 words) - 16:14, 13 July 2016
• Percent complete for Version 5.3 (OnePager Express)
  ...ential that these data be properly represented in the associated Microsoft Excel plan before the data are imported to OnePager Express ('''OPX''').
  6 KB (862 words) - 15:28, 15 March 2016
• Baselines for Version 5.3 (OnePager Express)
  ...sential that the associated data be properly represented in your Microsoft Excel plan before the data are imported to OnePager Express ('''OPX''').
  10 KB (1,513 words) - 14:37, 15 March 2016
• Deadlines for Version 5.3(OnePager Express)
  ...ith '''Start and Finish dates''', a '''deadline date''', and the Microsoft Excel '''Show It''' column set to yes so that OnePager imports the data for all t ...me resembling a '''Deadline date''' column you specified in your Microsoft Excel spreadsheet.
  8 KB (1,241 words) - 15:55, 15 March 2016
• Endpoints for Version 5.3 (OnePager Express)
  The initial association of '''Endpoints 1 through 4''' to Microsoft Excel columns is determined from your initial '''template''' settings input to On ...ow whereby you may configure the '''endpoint''' association with Microsoft Excel spreadsheet columns.
  7 KB (1,032 words) - 16:35, 15 March 2016
• Zebra Striping for Rows and Swimlanes for Version 5.3 (OnePager Express)
  ...hem, or through reconfiguring rows and swimlanes by changing the Microsoft Excel column driving the configuration, OnePager will automatically re-stripe the
  4 KB (631 words) - 22:02, 3 May 2016
• Linking Tasks and Milestones (Adding, Deleting, Modifying) for Version 5.3
  ...does not import dependency information from Microsoft Project or Microsoft Excel.
  6 KB (849 words) - 21:28, 18 March 2016