What’s the best template you’ve seen for excel task list that can be used for a project management?

like
Posting as :
works at
You are currently posting as works at

I'll have to look up the company, but there is one out there that makes an Excel Project Plan. Works almost as good as MS Project, just more complex. If I find it, I'll repost the link.

like

Are you speaking about the new MS Planner integration into Teams?

Commenting for responses

like

Not Excel, but Microsoft Planner.

like

The ability to retain completed tasks in a clean manner - setting default views for users. And primarily, best when used as a “Planner tab” in a Private Teams group of colleagues you generally split/assign or toss tasks between.

Oh I’d love suggestions, too. I’ve made my own, but would love a ready made template!

like

^

Same

Commenting for responses as well

I’ve found some pretty effective templates via Excel (new > search templates). There are some fab templates if you search “gantt”…you score when you find one that allows you to enter tasks, sun-tasks, dependencies, statuses, etc. and the template had conditional formatting applied to distinguish each task…
Plan B: set up a Kansan board in MS teams
Plan C: Google > images, search for ideas before you build something from scratch

Related Posts

Do you use any method when finding new ideas?

or nothing just think and write something down until you got the idea.

like

What are the average optometry salaries for a 5 year position at americas best ?

like

Looking to go into either management or clinical applications. What’s the starting salary for a radiology supervisor and a clinical application analyst in ohio? I have my MBA and 5 years experience and a rad tech.

Generally what percentage of variable pay based on company and individual performance is paid out to employees ?

like

Infy hiring for various positions across India. Let me know if u need referral.

Hey Guys, Likes Please to activate DM

like

Which techstack according to you is being paid the highest package with same level of experience😇😇😇😇?
Highly appreciate mentioning the yoe, the techstack and the package offered🥰🥰🥰🥰

like

Is Salesforce still continuing WFH or do we need to come to office?

like

Aside from LinkedIn, what are other sources to identify decision makers in large companies?

likehelpful

Question for Sales leaders who’ve said “I did an analysis and concluded we just need more at bats”.

Does it feel like you’re saying something useful? Or are you also writing a book titled “In order to get rich you just need more money”?

likefunny

For new hire who’s struggling, will going back to office actually makes things better and easier?

like

LA vs Boston. Which city pays higher? Big4 tax

like
like
like

Hi,

I am an Open Freelancer Power BI Developer and a result driven Data professional with 6+ years of progressively responsible experience in Data Analysis, Data Modelling, Data Visualization, Business Intelligence using BI technologies/tools like Microsoft Power BI, SQL, DAX etc.

I would like to work on Power BI Projects with your team and would be happy to draw actionable insights and driving value through data.

Please get in touch with me on below contact details.

Mobile:+91-8356921173

like

what tech companies are still hiring?

Any one staying in kumar park infinia, Fursungi and working in Barclays Kharadi?
Need quick information on travelling !! Please help

like

What do u prefer

Post Photo
helpfullike

Manager told to provide onsite by next year if drop resignation since 1 year not completed not eligible for onsite now, is it good option to drop?

like

Additional Posts in Excel Genius

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

like

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.

like

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

like

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

like

Does anyone from PwC have a list of the favorite groups shortcuts for excel? Please provide. Much appreciated .

like

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

like

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

like

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

like

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

like

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

like

What are your top Excel ninja tricks? Ones that few people know...

like

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

like

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

like

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

How do you fix microsoft excel cannot paste data error?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal