Microsoft’s Insert Data from Picture Tool for Excel Users

Microsoft insert data from picture tool

Professionals who rely on Excel to organize and process data for various purposes have one more reason to enjoy using this platform as its developer, Microsoft, has launched a new tool for Android phones that allows users to turn a photo of data into an Excel spreadsheet. The Android app’s Insert Data from Picture feature lets you capture an image of data displayed in rows and columns on a piece of paper and automatically converts it into editable table data. Apart from numbers, one can also turn lists and recipes into the well-known tabular form.

The main process involves taking a photo of the data in question and sending it to Excel’s online image-recognition engine to process and change it into a table. During the import, you’re given the possibility to alter any detail before its conversion. Microsoft said that the iOS version of Excel would be soon available as well.

Here are the main few steps you need to take to turn phone photos into Excel table data:

1. Open the Android Excel app and tap the New button at the top. This will create a new file and you can choose to either format it as a blank workbook or start from one of the templates available.

2. Go to the bottom of the app and tap the Data from Picture button. As a first-time user, you will also need to tap Allow to give Microsoft permission to convert the image to data in order to proceed.

3. Place the red rectangle around the data you need and tap the Capture button. You might be prompted to repeat the process if the image is not very clear and the app cannot identify the data.

4. Once the image is captured, tap the red check button to commence the conversion process. If want to start again, tap the X.

5. In the preview section which appears, tap the red-highlighted cells and then Edit to start entering missing information; to make corrections or changes to the existing data, you need to tap un-highlighted cell. Tap Done after each edit.

6. When you’ve finished editing, tap Insert at the top to position the data in your workbook.

Part of Microsoft’s suite of Office apps for mobile devices, the Android Excel app can help users save time importing their data to other relevant tools that integrate with Excel, such as PowerPoint. As developers of an intuitive add-in that turns Excel data (and not only) into beautiful slides right inside PowerPoint, the Office Timeline team can only welcome this great addition to the range of data processing tools on the market.

Guest Post: Using Office Timeline to Communicate Detailed Engineering Schedules

Hello, I'm Mannix and I've been working for years in project control roles on industrial engineering projects in the oil and gas, pharmaceutical and infrastructure industries. Over the years, I have experienced several poorly planned, chaotic and demoralizing projects. These experiences motivated me to find and document the tools, process and techniques that allowed for the thoughtful, efficient and well executed project delivery.

In this article, I will explain how I use Office Timeline to convert Primavera P6 schedules into easy to understand project plans. I have found this approach to work really well when planning, communicating and executing on engineering projects.

How to Plan for Engineering Projects

Planning an oil and gas engineering project means coordinating thousands of activities. The activities define how the engineering, procurement and construction phases of the project interrelate with each other, and therefore must be developed and organized in great detail.

Enterprise planning systems such as Primavera P6 are typically used to plan the activities and align the project schedule to the cost estimate. The finalized detailed schedule then forms the basis of the contractual relationships between the contractors and suppliers who will work on the project.

One of the dangers of a detailed project schedule is that the forest gets lost for the trees. A comprehensive project schedule for a large oil and gas engineering project quickly turns into a very large document, often up to forty pages long. While it describes the work that needs to be done, it does not communicate the overall plan for the project very clearly. All the pages of data hide the key project activities and deliverables that need to be understood in order for the project to be a success.

As a project planner, I get around this problem by creating two documents. The first is the project schedule, which breaks the project scope into executable chunks and identifies the logical steps needed to get the work done. The second is a project plan, which clearly communicates the key phases and milestones for a project. Read on, and I’ll try to explain the differences in more detail.

Project Plan versus Project Schedule

Simply put, a project plan tells us about where we are going and a project schedule tells us how we are going to get there. Let's discuss them one by one.

What a Project Schedule Does:

1. Defines what - Work Breakdown Structure (WBS)

The WBS is the basis of project management. It breaks the project down into logical pieces and allows the time, cost and scope of a project to be managed.

2. Defines who - Organisational Breakdown Structure (OBS)

This allows each person working on the project to see the activities that they are working on and the key interfaces that they are responsible for.

3. Schedules the work

This means that the logical relationships between project activities and work packages are correctly applied. The resulting sequence means that activities are started and finished in the right order.

4. Defines the time phased budget

The project schedule can be matched with the cost estimate to produce a time phased budget. This gives the project team the likely manpower and cost over the project timeline. This is critical for accurate project staffing and cashflow.

What a Project Plan Does:

1. Identifies the products and milestones

The key project deliverables and milestone dates are identified. This allows the project outcomes to interact with the business objectives of the project.

2. Allows non-experts to understand the project

Project decision makers often do not have the knowledge of the experts who work on a project. The project plan should give everyone involved with the project a working knowledge of the execution strategy and the project outputs.

3. Allows a project manager to sell the value of the project

Being able to clearly tie the project objectives to a detailed project schedule makes everyone feel confident about the overall project management team. An easy to communicate project plan is a vital part of doing this.

How I use Office Timeline to create a project plan from Primavera P6 data

For a project management team, the plan must be sold to a client group and possibly a number of vendor and supplier organisations. In order to do this effectively, the project must be communicated succinctly, preferably on a single page.

When I develop a detailed schedule in Primavera P6, I export the activities and dates into an Excel workbook. I can then import this file into the Office Timeline plugin in Powerpoint. The benefit of this is that as the project details are tweaked, I can easily update the P6 schedule and the Excel export and have an accurate project schedule and project plan for the project team to use.

To do this in Office Timeline is easy. I take my schedule in Primavera P6 and copy the data by clicking select all in the edit field and pressing control+c to copy all the text.

compare to 100 dollar US bill

I then paste the data into an Excel file and save the file in a suitable folder. This file will be the link between my Primavera P6 schedule and the project plan in Office Timeline. Whenever I update my Primavera P6 schedule I update the Excel file and refresh the changes into Office Timeline.

compare to 100 dollar US bill

I then open PowerPoint and use the import function in the Office Timeline ribbon.

compare to 100 dollar US bill

From here I can select the activities and milestones that I want included on my project plan. I generally use a mix of WBS descriptions, activities and milestones from my Primavera P6 schedule to create a meaningful project plan.

compare to 100 dollar US bill

And here you have it, a concise and easily understood project plan.

compare to 100 dollar US bill

I hope you have found the distinction between a project plan and a project schedule useful as you develop engineering schedules with your project teams. And when it comes to communicating your plan, I have found the combination of Office Timeline and a detailed Primavera P6 schedule to work really well. It brings together two powerful professional tools to make a project planner's life easier.

Related content:

Top 10 Task Management Software Based on User Reviews

Your project communications must have impact

How to Add Meaning and Logic to Your Timelines


Taylor Croonquist
Mannix Carney is a project planner based in Calgary, Canada, with over 15 years of experience in planning in the oil, gas and pharmaceutical industries. He writes about Primavera P6 and project planning for large scale projects at www.ProjectPlanningHq.com.







Quickly turn project data into professional timelines

Build stunning, uncomplicated timelines and Gantt charts that are easy to make and simple to communicate. Get the advanced features of Office Timeline Plus free for 14 days.

GET FREE TRIAL

Top 10 Task Management Software Based on User Reviews


Best Task Management Software

Task management software has become a common “assistant” for project managers, helping them and their teams to properly plan and carry out their work, meet client requirements, and manage time, budget and risks. However, the variety of options available can leave one confused about where to begin, especially since many of these task manager apps are constantly expanding their range of functionalities.

To simplify the selection process, we've gathered 10 of the best task management tools in 2019 based on user reviews and ratings. These are:

1. TimeCamp

Average rating (Capterra, G2 Crowd, TrustRadius): 4.9/5

Encompassing features such as graphical timesheets, invoicing and reporting, or manual and automatic time tracking, TimeCamp is an intuitive task management software that integrates with platforms such as Harvest, Xero, and Trello.

The tool has a free version with limited features, as well as multiple paid plans that can cost between $63 and $75 per year depending on the package you choose.

Best Task Management Software

2. Office Timeline

Average rating (Capterra, TrustPilot): 4.55/5

Designed as an extension for Microsoft PowerPoint, Office Timeline is a lightweight task manager and project scheduler that automatically turns task and milestone data into easy-to-understand Gantt charts and timelines. Equipped with pre-formatted templates and task tracking features such as Percent Complete or Time Elapsed, the add-in also integrates with applications like Microsoft Project, Excel, Smartsheet and Wrike.

The PowerPoint task tracker comes in two versions, Free and Plus. While the free tool is fully functional, the Plus edition – which costs $59/year – unlocks more customization options and productivity features.

Office Timeline Customer Review

3. ActiveCollab

Average rating (Capterra, G2 Crowd, TrustRadius, TrustPilot): 4.42/5

A desktop and mobile task management app, ActiveCollab allows you to organize tasks based on their priority, generate a variety of reports, and create a collaborative work environment.

Users have access to a 14-day trial that enables them to get familiarized with the tool's interface and processes. Those who wish to purchase can choose between monthly billing ($7/month = $84/year) and annual billing ($75/year).

ActiveCollab Customer Review

4. Evernote Business

Average rating (Capterra, G2 Crowd, TrustRadius, TrustPilot): 4.41/5

Allowing users to create, edit, upload, and share documents, Evernote Business stores all relevant information in one place and promises to unify workflows across teams and departments. The Business plan is priced at $14.99 per month ($179.88/year), but users can test it for free for 30 days.

Evernote Business Customer review

5. Smartsheet

Average rating (Capterra, G2 Crowd, TrustRadius, TrustPilot): 4.24/5

Smartsheet is a work execution platform with a spreadsheet-like interface and real-time task management, collaboration and automation tools. Enabling you to view data in different formats ranging from card and Gantt to calendar and grid, Smartsheet can be used for sprint and waterfall projects, sprint planning and product roadmaps.

The online task manager comes with a free 30-day trial and several pricing plans, the standard Individual plan costing $14/month ($168/year).

Smartsheet Customer review

6. Intervals

Average rating (Capterra, G2 Crowd): 4.07/5

Intervals is a web-based task management app that combines comprehensive time tracking and reporting features with task management options such as fully integrated and interactive Gantt charts. Built for small businesses to create a collaborative framework, it is ideal for web developers, consultants, IT firms and communications companies.

Users can test Intervals free of charge for 21 days, and subscription prices range from $59 to $299 per month ($708 – $3,588 per year) depending on the plan chosen.

Intervals Customer Review

7. Wrike

Average rating (Capterra, G2 Crowd, TrustRadius, TrustPilot): 4.03/5

A cloud-based collaboration and task management software that offers enterprise-level security and scalability, Wrike is ideal for teams of more than 20 members. With features such as task assignment based on status, Gantt charts, workload view for resource management, custom dashboards and templates, as well as proofing tools, Wrike appeals to project managers and marketers alike.

Users can choose from several Wrike plans depending on the number of users and features required: Free (limited to 5 users and basic features), Professional, Business, Marketers and Enterprise. The featured Business plan costs $24.80/month ($297.6/year) and comes with a free trial as well.

Wrike Customer Review

8. Agile CRM

Average rating (Capterra, G2 Crowd, TrustRadius, TrustPilot): 4/5

Marketed as an all-in-one Marketing, Sales and Service automation platform, Agile CRM provides a drag-and-drop task management tool designed to simplify communication and task tracking between multiple teams or departments.

Prices start at $8.99/month ($107.88/year) and go up depending on the plan chosen. There's also a free task manager available, limited to 10 users and basic features.

Agile CRM Customer Review

9. Bitrix24

Average rating (Capterra, G2 Crowd, TrustRadius, TrustPilot): 3.3/5

Used by companies and small businesses as a team task management tool, Bitrix24 comes with a broad range of organizational features to enhance efficiency at the individual and group level. Among the most used ones are task templates and roles, Gantt charts, supervisor view, task delegation and time tracking.

Bitrix24 offers multiple pricing packages, depending on the number of users and amount of online storage required. The Free plan allows up to 12 users and offers 5 GB of storage, while the popular Standard plan (for 24 users and 24 GB of storage) starts at $35/month ($420/year), but will be discounted to $31/month ($372/year) if you choose to pay for two years in advance.

Bitrix24 Customer review

10. AceProject

Average rating (Capterra, G2 Crowd, TrustRadius): 3.56/5

AceProject is an online task management tool that offers time and cost tracking functionalities to help users manage projects from end to end and keep them on time and on budget. Its intuitive project dashboard gives you easy access to relevant data with color-coded graphs, and the Gantt chart feature lets you view the details and status of a certain project so you can make informed decisions.

AceProject comes with a free version, limited the amount of users, projects and storage available, as well as four paid plans that range between $24 and $199 per month ($288 - $2,388 per year).

AceProject Customer Review

Since task management software development seems to move towards simple web-based solutions, we have a bonus suggestion for you: a free visual task manager from Office Timeline made for the web. Relatively new on the market, the tool lets you make Gantt charts and timelines directly in your browser, update them easily using drag & drop, and download them as PowerPoint slides or .png images to present in meetings.

Of course, in the end, choosing a task management system comes down to the specific needs of each team, but we hope our suggestions will at least help you form an opinion about what tools and functionalities are most popular with professional users today.

If you consider that any other examples are worthy of being included in this list, please leave your suggestions in the comment section.


Quickly turn project data into professional timelines

Build stunning, uncomplicated timelines and Gantt charts that are easy to make and simple to communicate. Get the advanced features of Office Timeline Plus free for 14 days.

GET FREE TRIAL

27 Project Management conferences worth attending in 2019


Project Management Conference


Project management evolves at a frantic pace. Every passing day comes with new trends, methodologies and technologies, and a project manager who wants to stay on top needs to find a way to keep up with the changes. This is why proactive PMs strive to attend at least a few conferences every year, allowing them to learn the latest best practices, expand their network, and find opportunities for growth.

To help project managers and business professionals decide on the best conferences to attend in 2019, we've put together a list of major upcoming PM events that are worth pursuing. For easier planning, we've split the conferences by region (North America and International) and created a visual timeline for each category, so you can quickly see which conventions fit your 2019 calendar best.

A) Project Management conferences in 2019 - North America
B) Project Management conferences in 2019 - International

Read the full article to see what's going on all around the world or use the links above to jump straight to the section you're interested in.


A) 2019 Project Management Conferences in North America



Project Management Conferences North America

Resource Planning Summit

Where and when: Nashville, TN, US, Feb 10 – Feb 13

Why: Advertised as the premier thought leadership event for resource planning, the summit brings together leading experts and authors in the world portfolio and resource management. 2019 topics include driving change in larger organization, military strategies for resource management, portfolio optimization, and more.


ProjectSummit Business Analyst World

Where and when:

-Orlando FL, US, Mar 25 – Mar 27

-Washington DC, US, Apr 29 - May 1

-Toronto ON, Canada, May 27 – May 30

-Vancouver BC, Canada, to be announced

-Boston MA, US, to be announced

-Chicago IL, US, to be announced

Why: ProjectSummit Business Analyst World is a series of educational conferences dedicated to business analysts and project managers, accredited by PMI and IIBA. Attendees earn Professional Development Units (PDU) and Continuing Development Units (CDU) for each hour of learning.


Change Management Conference

Where and when: Orlando, FL, US, Apr 28 - May 1

Why: The annual CM conference held by the ACMP brings together professionals worldwide to explore innovative practices and share the latest solutions in change management. Topics for 2019 include success factors for enterprise change, driving successful change when change is a secret, the role of SaaS apps in change management, and more.


UMD Project Management Symposium

Where and when: College Park, MD, US, May 9 – May 10

Why: Join PM practitioners from the US and abroad to make connections and learn best practices in areas like Stakeholder Management, Agile Project Management, or Construction Management. Other session topics include conflict resolution, negotiation, risk & big data, and integrated project management.


Global Scrum Gathering

Where and when: Austin, TX, US, May 20 – May 22

Why: Scrum Alliance's Global Scrum Gathering aims to provide Agile education and practical project management solutions through keynotes, workshops and activities focused on themes like applications of Scrum in fields other than software, organizational transformation, or Scrum in heavily regulated environments.


Agile and Beyond

Where and when: Detroit, MI, US, May 30 - May 31

Why: Agile and Beyond is a volunteer-run conference that aims to educate on Agile principles and practices. Although details about speakers and themes aren't available yet, judging by past editions, the conference covers a variety of industries and is suitable for both beginner and experienced Agile professionals.


Agile2019

Where and when: Washington, DC, Us, Aug 5 – Aug 9

Why: The annual conference organized by the Agile Alliance is dedicated to advancing Agile principles and providing a venue for professionals to connect and share ideas.


31st. IPMA World Congress

Where and when: Mérida, Yucatán, Mexico, Sep 30 – Oct 2

Why: The 2019 IPMA World Congress promises to bring together professionals from 70 countries for a comprehensive program of academic findings, new insights and best practices focused on the core theme of "Integrating Sustainability into Project Management."


PMI Global Conference - North America

Where and when: Philadelphia, PA, US, Oct 5 – Oct 7

Why: PMI's yearly Global Conference provides insights into the current business and project challenges and strategies. Connect to and learn from chapter leaders, business professionals and industry experts from across the world.


PMO Symposium

Where and when: Denver, CO, US, Nov 3 – Nov 6

Why: Get unique insights and a high-level view of how organizations worldwide approach project management. Choose from over 60 educational formats ranging from traditional sessions to informal knowledge hubs and offsite learning excursions.


B) International Project Management Conferences in 2019


Project Management Conferences North America

Deliver Conference

When and where: Manchester, UK, Jan 24 - Jan 25

Why: The Deliver Conference aims to help professionals deliver value to their clients and customers, regardless off the PM methodology used. Attend two days of talks, workshops and studies to get useful advice and new perspectives.


APM Project Management Conference Edinburgh

When and where: Edinburgh, Scotland, March 21

Why: The APM Project Management Conference in Edinburgh brings together influential speakers with diverse backgrounds, from business strategy consultants to economists and political journalists. The event focuses on two main themes, Sustainability and Investing in the Profession, and promises attendees up to 8 hours of CPD (Continuing Professional Development).


IPMA Project Excellence Assessment Training

When and where: Lisbon, Portugal, Mar 29 – Mar 31

Why: IPMA's 2019 event is aimed at potential Project Excellence Award Assessors who would like to gain a better understanding of the Project Excellence Model, as well as improve their interviewing and reporting skills.


PM Congress 2019 Research Meets Practice

When and where: Delft, The Netherlands, Apr 11 – Apr 12

Why: The Delft University of Technology has teamed up with PMI to organize the 2019 PM conference "Adapt or Die". Attend workshops, Ted-style presentations and research summaries that aim to provide insights on how to adapt to the changing landscape of projects.


New Trends in Project Management

When and where: Gdańsk, Poland, Apr 23 – Apr 24

Why: Held by the PMI Gdańsk Branch, the New Trends in Project Management conference focuses on the exchange of PM knowledge and best practices in Poland and abroad. Learn how to minimize risks in teams, manage large projects with limited resources, or move from Waterfall to Agile in a series of talks and workshops that can earn you up to 14 PDUs.


International Scientific Conference on Project Management

When and where: Riga, Latvia, Apr 25 – Apr 26

Why: The conference focuses on discussing the results of scientific research into project management. Selected papers will be considered for publishing in the Project Management World Journal, and attendees can earn up to 14 PDUs.


APM Project Management Conference London

When and where: London, UK, 2 May

Why: Learn to take control of your projects through a rich program focusing on how to adapt, work smarter, and improve performance in Project Management.


PMI EMEA Congress

When and where: Dublin, Ireland, May 13 – May 15

Why: The PMI EMEA Congress 2019 promises to provide project managers with the knowledge, skills, and behaviors needed to bring about positive change. With participants from over 70 countries and a mix of traditional and non-traditional sessions, it puts a high value on networking and promotes learning by doing.


PMO Conference UK

When and where: London, UK, Jun 13

Why: Focusing on program, portfolio and project offices, the PMO Conference in UK offers a full day of presentations, sessions and networking activities, as well as a dedicated expo with new PMO products and services.


APM National WiPM Conference

When and where: London, UK, 2019 date not announced

Why: The AMP National Conference for Women in Project Management aims to give professional women the tools to develop themselves, their skillset and their teams. The date, themes and speakers of the 2019 edition haven't been released yet – we will provide updates as soon as we find out more details.


The Future PMO

When and where: London, UK, Oct 17

Why: FuturePMO is advertised as a friendly and fun PMO conference and promises to surprise you. The event is designed for PMO Practitioners at all levels and brings together leading industry experts curated from across the globe.


AIPM National Conference

When and where: Melbourne, Australia, Oct 20 – Oct 22

Why: One of the biggest PM events in Australia, AIPM's National targets both established and beginner project leaders, providing a platform to share experiences and gain knowledge on multiple areas that impact project management.


While this is not an exhaustive list of PM conferences worth attending, it should provide PMs with an overview of the education and networking opportunities they have in 2019. As we learn more details and new event dates are announced, we will update the list and the timelines. The Project Management Conference timelines were created in PowerPoint with the help of Office Timeline and are free to download, edit and share.


Get the free PowerPoint timeline file that contains the full 2019 Project Management Conferences timeline here.



Quickly turn project data into professional timelines

Build stunning, uncomplicated timelines and Gantt charts that are easy to make and simple to communicate. Get the advanced features of Office Timeline Plus free for 14 days.

GET FREE TRIAL

Matthew McConaughey Timeline

Matthew McConaughey Timeline

Beloved actor Matthew McConaughey celebrates his 49th birthday this Sunday. Having played in a variety of movies, ranging from romantic comedies and dramas to horror, crime and science fiction productions, Mr. McConaughey has garnered a panoply of awards and nominations, including an Oscar, Golden Globe Award and Screen Actors Guild Award for Best Actor.

To wish a happy birthday to the one whose early performances inspired critics to call him the new Paul Newman, we have created the Matthew McConaughey Timeline, which summarizes his life and acting career, including some of his best known films.

After his breakthrough role in Dazed and Confused in 1993, the debutant McConaughey was then cast in two 1996 high-profile films (Lone Star and A Time to Kill), becoming a sensation and gaining the attention of numerous other directors. Throughout the early 2000s though, he had a series of appearances in romantic comedies that caused him to be typecast, for which reason he took a two-year hiatus to seek new opportunities and to move away from the genre.

He returned to the big screen in 2011 to portray a criminal defense attorney in the thriller The Lincoln Lawyer, giving what was considered one of his best performances until then. Two years later, losing 47lbs for his role as an AIDS patient in the biographical drama Dallas Buyers Club, he reached the prime of his career, winning 4 awards and multiple nominations for Best Actor.

The Matthew McConaughey chronology was designed with Office Timeline, a PowerPoint extension that enables you to easily create stylish timelines and other similar visuals. The slide, which is available to be copied and shared for free, can be further restyled and updated using Office Timeline Plus Edition.

Download the Matthew McConaughey Timeline for PowerPoint here.



Quickly turn project data into professional timelines

Build stunning, uncomplicated timelines and Gantt charts that are easy to make and simple to communicate. Get the advanced features of Office Timeline Plus free for 14 days.

GET FREE TRIAL