Tag: excel

Get Organized in 2017 with Free Excel Calendar Templates
Wednesday, 4 January, 2017
Productivity

Get Organized in 2017 with Free Excel Calendar Templates

You’re back in the office after the new year, and you’ve already got a slew of ambitious new goals to hit. Before you know it, you have a jumble of meetings, appointments, and projects—and your poor calendar starts looking like a Jackson Pollock.  Keeping everything organized takes a lot of work! We've gathered this collection of free calendar templates for Excel to help you plan your time wisely, along with tips for effectively scheduling your day, your week, your month... and even you...
Read more
0 0 0
Using If Then Statements in Excel to Set the Conditions for Success
Tuesday, 29 November, 2016
Project Management

Using If Then Statements in Excel to Set the Conditions for Success

Maintaining spreadsheets is not the easiest or most effective method for managing a project. Still, should you find yourself relying on a workbook to track assigned tasks and overall team performance, it's important to learn how to do if then statements in Excel. These logical functions test whether something is true or false by comparing an entered value and an expected one. This can be helpful for tasks like tracking budgets for online marketing campaigns. If you understand conditiona...
Read more
0 0 0
Can You Build a Gantt Chart Template in Excel?
Wednesday, 23 November, 2016
Project Management

Can You Build a Gantt Chart Template in Excel?

Quality leadership is about being able to step back and maintain perspective without losing your awareness of the details that matter. Keeping a project on time and under budget requires a ton of planning, clearly assigning tasks, and maintaining a close eye on the status of projects to ensure everything gets done. Project managers and teams have a leg up on setting smart goals when they are able to visualize how working hours add up to success. That's where a Gantt chart comes in, brin...
Read more
0 0 0
Understanding Absolute Cell Reference: Using Excel for Budgets and Calculations
Tuesday, 22 November, 2016
Project Management

Understanding Absolute Cell Reference: Using Excel for Budgets and Calculations

We all know spreadsheets are a headache for managing projects. However, they can still come in handy for calculating budgets and generating visuals to track employee productivity, online marketing performance metrics, and other key indicators. Tasks like planning budgets or reviewing progress for a business initiative can go far more smoothly if you have a strong grounding in the basics of putting together a spreadsheet in Excel. One concept you'll have to understand is how to use cell...
Read more
0 0 0
How to Create an Excel Timeline Template
Wednesday, 10 August, 2016
Project Management

How to Create an Excel Timeline Template

Visual timelines are essential tools for planning, tracking, and managing a project. You can map out dependencies and milestones to get an accurate overview of progress and deadlines. But while using these Gantt chart-style timelines for project management is fairly easy, creating one in Excel can be tricky. We'll walk you through the process of how to make a timeline in Excel and share a project schedule template you can reuse for future work. How to Create a Timeline in Excel  Step 1...
Read more
0 0 0
Tutorial: Quickly Create Folders/Tasks and Rename Them with Excel
Wednesday, 3 August, 2016
Project Management

Tutorial: Quickly Create Folders/Tasks and Rename Them with Excel

Looking for a way to quickly mass create Wrike folders and tasks and rename them easily? Here's a trick: use Microsoft Excel. One of the tips we mentioned in our blog post 4 Common Mistakes New Wrike Users Make, was to include the project name in the names of its subfolders. For example, under the "Client A" project folder you can have subfolders such as: "Client A Content," "Client A SEO," and "Client A Social." This way, any notifications that are sent will include the necessary con...
Read more
0 0 0