How do I create a daily task tracker to track all the things I do during a day, week or month? So I can easily explain what I’ve been working on and keep track of important tasks or projects?

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

I just use a physical planner and then put recurring reports/tasks on outlook as well. Serves as a double entry system and I have never missed any deadline or request

likefunny

I would use a tool like Airtable instead of trying to build something from scratch in Excel.

like

I will look into this, thanks!

I’d just do a google of “excel task tracker templates.” I’m sure you’ll get millions of hits.

like

I guess the ask is to find one that has been working well for others, I’m sure the chief can google

like

I use an outlook calendar for this. Tasks can be dragged into the calendar during the time you worked them (or plan to work them).

like

I use a physical planner. Your admin can add it to the next supply order for you, or you should be able to expense one. I am trying out an undated one this year.

If you have access to Smartsheets, they have a couple of great templates you can use.

Notepad

Try using a JIRA board. (Web based not part of excel)

I use Teams Tasks to help me keep track and they are supposed to be releasing a planner feature soon.

Will something like Asana not work for your use?

Related Posts

Hi Fishes,

My current CTC is 16lpa and received an offer of 24.5lpa from
UST Global. But I have one doubt before joining UST Global, how much would be the annual appraisal hike on an average in UST?

YOE: 7
TechStack: Boomi

like

I am Sr. Software engineer with 9 YOE and proficiency in PHP, Codeigniter, Wordpress, Drupal, Html, CSS, Bootstrap, JavaScript. How much package should i have with these skills and experience? Please let me know if anyone has any idea.

Healthcare consulting practice. Deloitte vs Accenture vs other players. Thoughts on who has the best practice overall?

And any insight/who has the best practice in the provider space specifically?

like

Anybody here work as a BDR/SDR for Okta ? Just accepted a BDR offer, have to relocate for this job. Is it worth it in the long run?

like

Is paralegal burn-out a thing? And if it is, how do you overcome it?

like

Given the hot sellers market, do you guys think I should plan to sell my house on my own (private) vs get an agent? Want to minimize closing costs/fees. Thanks!

like

Steve Wozniak isn't afraid to critique Apple devices, and said he couldn't tell the difference between the newly released iPhone 13 and its predecessor, the iPhone 12.

like

This is an emotional dump rn. It may be lack of social interaction but I'm really frustrated lately. I feel like I lost last 2.5 years of my life with ongoing lockdowns and job instability in the first half of the pandemic. I was 28 turing 31. I get good dates but -ve self talk
Inflation is high & coming from a low income family where you're supposed to help your parents is driving me nuts. Although I make a good salary, after rent, car insurance, there isn't much left (unfav currency exchange)

like

What's your worst story of you or someone you know being "thrown under this bus"?

like

Any good job pivots from wealth management into another career? I’ve been a wealth management advisor at a wirehouse for 7 years. Wanting something with less emphasis on selling and business development. Any suggestions?

like
like

What is the notice period at Mphasis? Is it varies based on the band and level? Can anyone answer?

like

Hi Fishes,
My zs joining date is June 1, before that when can I expect the joining formalities and onboarding process and laptop.
As of now there is no intimation except Idfy verification. Would be great help if you please suggest.

like

Praise be to Harambe 🐵

like

What do you do when a store manager let's a cashier.walk all over the assistant manager? Dm isn't any help. I'm at my wits end! Store manager sticks up for cashier every single time. I've offered to give that cashier my keys . I'm so done with trying to do right, only to have manager make up excuses.

like

Hi Guys, I have an offer from Marlabs,Pune location( hybrid) and joining is in 4 days. Interview process with Mouser Electronics and E-zest is still in progress. Shall I accept the marlabs offer? Any feedback regarding the company? I am worried as hiring of many companies is suspected to be freezed in upcoming days/months. Please guide.

like

I am fairly new to the pharma industry (in for about 3 years). I recently was promoted to a global program manager role and while the programs I manage aren’t terribly complex, I’m finding it difficult to be confident when everyone I interact with is senior level (Director and above). I feel like I’m starting my career at the top. Any recommendations on how I can develop my drug development knowledge and skill set?

like

Accenture can you guys go back to Marriott and fix their customer service please I've been on hold for 30 minutes and I still have missing nights

likefunny

I’ve been racking up a ton of Etihad Guest points (~300k) but have been having a hard time spending them bc the Etihad Reward chart is dynamic 🙄🙄. Any suggestions on how to spend those points? They expire in a year.

like

Additional Posts in Excel Genius

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

After I set a print area, how do I showcase the page 1 - page x in the excel sheet and have the background be grey?

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

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

like

Hi All,
Looking to automate a manual process for the client and thinking of creating macros for with VBA. Has anyone done anything similar?

In the process of learning but wanted to reach out for any tips, tricks and advice anyone may have.

Thanks I’m advance.

like

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

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

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

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

Anyone know what these badges are?

Post Photo
likefunny

How do I change line style@back to default on excel? Accidentally click on one, and now it wants to use that style every time. I just want to be able to use the ones in the typical drop down

like

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!

Timesaver: If you’re working on a file saved on the cloud (teams, share point, etc.) and need the URL to communicate out, tap FILE -> INFO -> COPY PATH and the url will be on your clipboard. Pre-established sharing privileges of orig folder will apply. Hopefully this saves you time reshuffling open windows! Bonus: Same on standard MS suite files.

likesmart

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

like

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

like

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

likehelpful

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

Post Photo
likehelpful

Still don't have xlookup. #fomo

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

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