Register
Log In
Unanswered
Home
New Member
Excel Expert
June 5, 2017
Offline
Hi guys,
So I'm a records clerk and I need to track everything the office receives or sends out. We are a district and have 22 offices that we overlook. In our office we have 5 managers who all overlook their own specific office. I currently have a tracking sheet made on Excel (includes: file number, office it relates to, date it came in, due date of the file, what the file is, notes on the file, who it is assigned to/manager, it's priority and if it's been concluded).
I HATE THE LAYOUT of it. It's a basic table and every time we have meetings I find it unappealing. I've looked for pre-made templates. I've tried to come up with something more fun, but clearly no luck as i am reaching out to you. I know it's hard with no visual (I can try and post a snapshot of it). But can you guide me into having an appealing tracking sheet???
Thank you so much!!
Mélo
Dashboards
Power BI
Power Query
April 21, 2015
Offline
Did you try making an Excel table of it? (select data, tab insert, button table (on the left)).
And after that you can either choose your colorstyle, or make your own and use that.
I did this recently for somebody who had to make some 'professional looking tables' in a paper and that worked out very well.
Dashboards
June 25, 2016
Offline
Hi Mélo
No idea what you mean by an "appealing" tracker
. I assume you mean more colours/images/charts/data validations/alerts etc.
Maybe the attachment can give you some idea.
Hope this helps.
Sunny
Most Users Ever Online: 57
Currently Online: Max Neumann
10 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Sethu nath
Jose Alvarado
James Villapudua
Sheri O'Connor
Noreen Anagnos
Connie DeMercurio
Shanna Steinberg
Holly Seamons
Mark Cooper
David Matanana
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
