Home Mail MemberMap Chat (0) Wallpapers
Go Back   ChiefsPlanet > The Lounge

Reply
 
Thread Tools Display Modes
Old 08-29-2009, 12:34 AM  
The Bad Guy The Bad Guy is offline
Scott Pioli
 
The Bad Guy's Avatar
 
Join Date: Jan 2001
Location: The Copacobana
Casino cash: $8689
Any excel gurus?

I'm creating a master schedule for all the students on my caseload this year for school. It's a pretty big file, and I wanted to know how I can make it more printer friendly. I also wanted to write numerous lines in one block without making it way too big. Is this possible?

Any help is much appreciated. Thanks in advance.
Posts: 22,389
The Bad Guy 's phone was tapped by Scott Pioli.The Bad Guy 's phone was tapped by Scott Pioli.The Bad Guy 's phone was tapped by Scott Pioli.The Bad Guy 's phone was tapped by Scott Pioli.The Bad Guy 's phone was tapped by Scott Pioli.The Bad Guy 's phone was tapped by Scott Pioli.The Bad Guy 's phone was tapped by Scott Pioli.The Bad Guy 's phone was tapped by Scott Pioli.The Bad Guy 's phone was tapped by Scott Pioli.The Bad Guy 's phone was tapped by Scott Pioli.The Bad Guy 's phone was tapped by Scott Pioli.
  Reply With Quote
Old 08-29-2009, 12:54 AM   #2
DaneMcCloud DaneMcCloud is offline
Band
 
DaneMcCloud's Avatar
 

Join Date: Sep 2000
Location: The 'Wood
Casino cash: $13114
Hmm.

It sounds like either MS Access or MS Word would be better suited for your needs.
Posts: 50,179
DaneMcCloud is obviously part of the inner Circle.DaneMcCloud is obviously part of the inner Circle.DaneMcCloud is obviously part of the inner Circle.DaneMcCloud is obviously part of the inner Circle.DaneMcCloud is obviously part of the inner Circle.DaneMcCloud is obviously part of the inner Circle.DaneMcCloud is obviously part of the inner Circle.DaneMcCloud is obviously part of the inner Circle.DaneMcCloud is obviously part of the inner Circle.DaneMcCloud is obviously part of the inner Circle.DaneMcCloud is obviously part of the inner Circle.
  Reply With Quote
Old 08-29-2009, 01:08 AM   #3
UsualSuspects UsualSuspects is offline
Starter
 
UsualSuspects's Avatar
 

Join Date: Aug 2009
Casino cash: $5000
Damn big schools.



Know software better than 18 year olds....

Seriously. Then no worries.
Posts: 220
UsualSuspects is a favorite in the douche of the year contest.UsualSuspects is a favorite in the douche of the year contest.
  Reply With Quote
Old 08-29-2009, 11:18 AM   #4
mikeyis4dcats. mikeyis4dcats. is offline
Scarlett Johansson's boytoy
 
mikeyis4dcats.'s Avatar
 

Join Date: Nov 2006
Casino cash: $8832
I'll try and help you if you can explain a little better what you are wanting.
Posts: 9,880
mikeyis4dcats. Forgot to Remove His Claytex and Got Toxic Shock Syndrome.mikeyis4dcats. Forgot to Remove His Claytex and Got Toxic Shock Syndrome.mikeyis4dcats. Forgot to Remove His Claytex and Got Toxic Shock Syndrome.mikeyis4dcats. Forgot to Remove His Claytex and Got Toxic Shock Syndrome.mikeyis4dcats. Forgot to Remove His Claytex and Got Toxic Shock Syndrome.mikeyis4dcats. Forgot to Remove His Claytex and Got Toxic Shock Syndrome.mikeyis4dcats. Forgot to Remove His Claytex and Got Toxic Shock Syndrome.mikeyis4dcats. Forgot to Remove His Claytex and Got Toxic Shock Syndrome.mikeyis4dcats. Forgot to Remove His Claytex and Got Toxic Shock Syndrome.mikeyis4dcats. Forgot to Remove His Claytex and Got Toxic Shock Syndrome.mikeyis4dcats. Forgot to Remove His Claytex and Got Toxic Shock Syndrome.
  Reply With Quote
Old 08-29-2009, 11:22 AM   #5
Chiefless Chiefless is offline
Veteran
 

Join Date: Jul 2001
Casino cash: $5800
In your print dialogue box you can set the printing percentage to reduce it down to fit on whatever page size you are using.

As for the word wrap, you should be able to select all, right click, select cell format and find the word wrap check box. It's probably clicked off, click it on and close the box. Then change your column widths to be more narrow. The type should wrap into several lines. I'm doing this from memory, so some of the terminology may be wrong.
Posts: 1,323
Chiefless is not part of the Right 53.Chiefless is not part of the Right 53.Chiefless is not part of the Right 53.Chiefless is not part of the Right 53.Chiefless is not part of the Right 53.Chiefless is not part of the Right 53.Chiefless is not part of the Right 53.Chiefless is not part of the Right 53.Chiefless is not part of the Right 53.Chiefless is not part of the Right 53.Chiefless is not part of the Right 53.
  Reply With Quote
Old 08-29-2009, 11:23 AM   #6
Chiefless Chiefless is offline
Veteran
 

Join Date: Jul 2001
Casino cash: $5800
Oh, and you can change to paper orientation and margins from "page setup" (I think).
Posts: 1,323
Chiefless is not part of the Right 53.Chiefless is not part of the Right 53.Chiefless is not part of the Right 53.Chiefless is not part of the Right 53.Chiefless is not part of the Right 53.Chiefless is not part of the Right 53.Chiefless is not part of the Right 53.Chiefless is not part of the Right 53.Chiefless is not part of the Right 53.Chiefless is not part of the Right 53.Chiefless is not part of the Right 53.
  Reply With Quote
Old 08-29-2009, 12:48 PM   #7
Fat Elvis Fat Elvis is offline
Beard Merit Badge
 
Fat Elvis's Avatar
 

Join Date: Apr 2001
Casino cash: $7935
Go to youtube.

Seriously.

There is a tutorial for everything you could think of for MS Office products. For me, at least, it is a lot easier to see how to do things and what the results are rather than trying to have someone explain it to me in a chat room.


Edit: And Dane is right; MS Access is the way to go. You can export to excel, generate reports, etc, etc. Access lets you sort the data whereas excel doesn't.
__________________

Mr. Irrelevant
Posts: 6,768
Fat Elvis 's phone was tapped by Scott Pioli.Fat Elvis 's phone was tapped by Scott Pioli.Fat Elvis 's phone was tapped by Scott Pioli.Fat Elvis 's phone was tapped by Scott Pioli.Fat Elvis 's phone was tapped by Scott Pioli.Fat Elvis 's phone was tapped by Scott Pioli.Fat Elvis 's phone was tapped by Scott Pioli.Fat Elvis 's phone was tapped by Scott Pioli.Fat Elvis 's phone was tapped by Scott Pioli.Fat Elvis 's phone was tapped by Scott Pioli.Fat Elvis 's phone was tapped by Scott Pioli.
  Reply With Quote
Old 08-29-2009, 12:50 PM   #8
Mosbonian Mosbonian is offline
On Hiatus
 

Join Date: Aug 2000
Casino cash: $782
Not trying to be smart, but why worry about being printer friendly?

Most things sent home by Teachers these days are done on memory sticks...I haven't printed out a schedule for my kids in a couple of years. We have it downloaded to a calendar that pops up on the computer each morning..

I've seen a couple of people take calendars and put them on digital picture frames....

That said, Dane is probably right...if it is that big you could use either Access or Monarch.

mmaddog
*******
Posts: 8,619
Mosbonian Forgot to Remove His Claytex and Got Toxic Shock Syndrome.Mosbonian Forgot to Remove His Claytex and Got Toxic Shock Syndrome.Mosbonian Forgot to Remove His Claytex and Got Toxic Shock Syndrome.Mosbonian Forgot to Remove His Claytex and Got Toxic Shock Syndrome.Mosbonian Forgot to Remove His Claytex and Got Toxic Shock Syndrome.Mosbonian Forgot to Remove His Claytex and Got Toxic Shock Syndrome.Mosbonian Forgot to Remove His Claytex and Got Toxic Shock Syndrome.Mosbonian Forgot to Remove His Claytex and Got Toxic Shock Syndrome.Mosbonian Forgot to Remove His Claytex and Got Toxic Shock Syndrome.Mosbonian Forgot to Remove His Claytex and Got Toxic Shock Syndrome.Mosbonian Forgot to Remove His Claytex and Got Toxic Shock Syndrome.
  Reply With Quote
Old 08-29-2009, 01:21 PM   #9
The Bad Guy The Bad Guy is offline
Scott Pioli
 
The Bad Guy's Avatar
 

Join Date: Jan 2001
Location: The Copacobana
Casino cash: $8689
Thanks guys.

I was able to accomplish what I wanted.

I need it to be printer friendly because I have to give hard copies to the teachers the students work with. It is much easier for them than having to pull it up on a computer.
__________________
Posts: 22,389
The Bad Guy 's phone was tapped by Scott Pioli.The Bad Guy 's phone was tapped by Scott Pioli.The Bad Guy 's phone was tapped by Scott Pioli.The Bad Guy 's phone was tapped by Scott Pioli.The Bad Guy 's phone was tapped by Scott Pioli.The Bad Guy 's phone was tapped by Scott Pioli.The Bad Guy 's phone was tapped by Scott Pioli.The Bad Guy 's phone was tapped by Scott Pioli.The Bad Guy 's phone was tapped by Scott Pioli.The Bad Guy 's phone was tapped by Scott Pioli.The Bad Guy 's phone was tapped by Scott Pioli.
  Reply With Quote
Old 08-29-2009, 03:06 PM   #10
Chiefless Chiefless is offline
Veteran
 

Join Date: Jul 2001
Casino cash: $5800
Access would be overkill for this. Word...maybe. But every schedule I've seen in my line of work is done in Excel.
Posts: 1,323
Chiefless is not part of the Right 53.Chiefless is not part of the Right 53.Chiefless is not part of the Right 53.Chiefless is not part of the Right 53.Chiefless is not part of the Right 53.Chiefless is not part of the Right 53.Chiefless is not part of the Right 53.Chiefless is not part of the Right 53.Chiefless is not part of the Right 53.Chiefless is not part of the Right 53.Chiefless is not part of the Right 53.
  Reply With Quote
Old 08-29-2009, 04:06 PM   #11
KC native KC native is offline
a toda madre o un desmadre
 
KC native's Avatar
 

Join Date: Feb 2009
Location: Fort Worth, TX
Casino cash: $17393
Pivot Tables FTW!
__________________
The diameter of your knowledge is the circumference of your actions. Ras Kass

Quote:
Originally Posted by Iowanian View Post
I'm just a little pussy from Iowa
Posts: 18,906
KC native is too fat/Omaha.KC native is too fat/Omaha.KC native is too fat/Omaha.KC native is too fat/Omaha.KC native is too fat/Omaha.KC native is too fat/Omaha.KC native is too fat/Omaha.KC native is too fat/Omaha.KC native is too fat/Omaha.KC native is too fat/Omaha.KC native is too fat/Omaha.
  Reply With Quote
Old 08-29-2009, 04:08 PM   #12
DaneMcCloud DaneMcCloud is offline
Band
 
DaneMcCloud's Avatar
 

Join Date: Sep 2000
Location: The 'Wood
Casino cash: $13114
Quote:
Originally Posted by Chiefless View Post
Access would be overkill for this. Word...maybe. But every schedule I've seen in my line of work is done in Excel.
That may be true but that doesn't mean that it's the most efficient.

Once the tables are created in Access, queries can be written to quickly do almost anything. And as FA pointed out, it's very easy to create reports based on those queries. You don't have to worry about expanding data and whether it fit on a page. You can create Keys and sort any which way.

MS Access databases offer infinite possibilities whereas Excel can be very, very limiting at times.
Posts: 50,179
DaneMcCloud is obviously part of the inner Circle.DaneMcCloud is obviously part of the inner Circle.DaneMcCloud is obviously part of the inner Circle.DaneMcCloud is obviously part of the inner Circle.DaneMcCloud is obviously part of the inner Circle.DaneMcCloud is obviously part of the inner Circle.DaneMcCloud is obviously part of the inner Circle.DaneMcCloud is obviously part of the inner Circle.DaneMcCloud is obviously part of the inner Circle.DaneMcCloud is obviously part of the inner Circle.DaneMcCloud is obviously part of the inner Circle.
  Reply With Quote
Old 08-29-2009, 04:13 PM   #13
KC native KC native is offline
a toda madre o un desmadre
 
KC native's Avatar
 

Join Date: Feb 2009
Location: Fort Worth, TX
Casino cash: $17393
Quote:
Originally Posted by DaneMcCloud View Post
That may be true but that doesn't mean that it's the most efficient.

Once the tables are created in Access, queries can be written to quickly do almost anything. And as FA pointed out, it's very easy to create reports based on those queries. You don't have to worry about expanding data and whether it fit on a page. You can create Keys and sort any which way.

MS Access databases offer infinite possibilities whereas Excel can be very, very limiting at times.
See above post. Pivot Tables FTW. It would take so long to set this up in access whereas pivot tables can work with large amounts of data easily and be done very quickly.
__________________
The diameter of your knowledge is the circumference of your actions. Ras Kass

Quote:
Originally Posted by Iowanian View Post
I'm just a little pussy from Iowa
Posts: 18,906
KC native is too fat/Omaha.KC native is too fat/Omaha.KC native is too fat/Omaha.KC native is too fat/Omaha.KC native is too fat/Omaha.KC native is too fat/Omaha.KC native is too fat/Omaha.KC native is too fat/Omaha.KC native is too fat/Omaha.KC native is too fat/Omaha.KC native is too fat/Omaha.
  Reply With Quote
Old 08-29-2009, 04:15 PM   #14
KC native KC native is offline
a toda madre o un desmadre
 
KC native's Avatar
 

Join Date: Feb 2009
Location: Fort Worth, TX
Casino cash: $17393
http://www.microsoft.com/dynamics/en...ot-tables.aspx

Link for pivot tables and info.
__________________
The diameter of your knowledge is the circumference of your actions. Ras Kass

Quote:
Originally Posted by Iowanian View Post
I'm just a little pussy from Iowa
Posts: 18,906
KC native is too fat/Omaha.KC native is too fat/Omaha.KC native is too fat/Omaha.KC native is too fat/Omaha.KC native is too fat/Omaha.KC native is too fat/Omaha.KC native is too fat/Omaha.KC native is too fat/Omaha.KC native is too fat/Omaha.KC native is too fat/Omaha.KC native is too fat/Omaha.
  Reply With Quote
Old 08-29-2009, 04:17 PM   #15
DaFace DaFace is offline
Version 3.0
 
DaFace's Avatar
 

Join Date: Aug 2005
Location: Donkey Land
Casino cash: $12165
Quote:
Originally Posted by KC native View Post
Pivot Tables FTW!
I haven't figured out why pivot tables aren't included in Excel 101. They may seem a bit complicated, but I'd argue that they may be the single most useful feature in Excel when it comes to manipulating data.
Posts: 28,669
DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.
  Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On

Forum Jump




All times are GMT -6. The time now is 02:43 AM.


This is a test for a client's site.
A new website that shows member-created construction site listings that need fill or have excess fill. Dirt Monkey @ https://DirtMonkey.net
Powered by vBulletin® Version 3.8.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.