Excell Help needed

[nyyki]

I need to learn how to use Excell Pivot Tables to pull data from a document into Excell. Anyone out there got those skills?

Also, I need to learn how to make Excell add times properly. Mostly minutes and seconds. I know there's got to be a way to do this, but Excell isn't the most blind friendly program for help.

Finally, I need to find out how to get Excell to round a number off instead of just truncate decimal places.

Help would be greatly appreciated.

Comments

And the techgoddess speaketh

[cyndtechgoddess.livejournal.com]

It's been a while since I've worked with Excel. I moved over to Office Setup/Outlook and, well, it's true what they say: "Use it or lose it." But, from what I remember.....

Excel is only going to truncate the decimal places when you use the Round function. The Round function is designed to display the result in a spreadsheet presentation. If you want something that actually changes the calculated value in the cell, you need a macro that incorporates the Round function, sees what the rounded value is, and changes the cell value to X.

No, I don't write code.

When getting Excel to add or subtract times, remember that Excel still looks at that time as a numeric value. Excel converts the time to a decimal value first, does the calculation, then converts it back to time format.

KB article http://support.microsoft.com/kb/214094 contains a link for "How to Work With Time Formulas", and some more sub-categories that might be helpful.

I hope this helps. :)

[cyndtechgoddess.livejournal.com]

Oh - pivot tables.... what version of Excel are you running?

[nyyki.livejournal.com]

2003. If I can get the whole Pivot table thing working, I can save myself massive amounts of time on things.

Oh, since you're doing Office support now, how do I make updates that won't install go away?

[cyndtechgoddess.livejournal.com]

You don't make them go away. You find out why they aren't installing and eliminate the problem, then allow them to install. :)

Usually, if an update won't install, something running in the background is hindering it. Sometimes we have to pull in the team that supports Windows Update to assist in those issues. Thing is, support for installing updates is free -- if you have an update that won't install, it's a free call. If you open a support ticket on it, let me know and give me the case number. I can at least monitor the progress of it for you, and if it isn't my team, I can talk to the PTL and say that it's a friend of mine. :)

As for Excel 2003 Pivot Tables...

There are three different online training courses for Pivot Tables, and they're free. I helped tech review these when they were developed for Office XP, and they recreated them for 2003. They designed them for users new to the product. I'm not sure how much you know about pivot tables already, so I don't know if some of this will be a review for you or if it is all new. Anyway, what I think you will find helpful is that there is audio in these courses, too. It's all browser hosted, so it should work with the other tools you use to see things online. This will also step you through doing it yourself, which I think is a better learning style for you (am I right?).

http://office.microsoft.com/training/training.aspx?AssetID=RC010136191033
http://office.microsoft.com/training/training.aspx?AssetID=RC010286901033
http://office.microsoft.com/training/training.aspx?AssetID=RC010381561033

Hope these help. :)