Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / April 2008

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Replacing export with descriptions -Vlookup Macro20 Apr 2008 17:00 GMT1
I have a monthly report that I export from an old system.  
Column A contains a number and I have been using VLookup to reference the
description of the number  from Worksheet2 Column A, B with Column B listing
the description.  
Excel 2000  Pivot table in Excel 200720 Apr 2008 14:48 GMT5
I have created over the years a pivot table using Excel 2000 that tracks
heating every day of the year. When I bring the Excel 2000 workbook into
Excel 2007, the pivot table looks ok but when I refresh the data, I get very
strange results. The pivot table is actually a summary of ...
Aligning Gridlines at 45 degrees (Orientation)20 Apr 2008 05:16 GMT6
I have a spreadsheet where the second row is a listing of attributes.  I have
set the orientation (Format-Cells-Alignment) of each column in this row to 45
degrees.  The first row is a higher level group of attributes in which each
one contains a group of the attributes in the ...
Nested IF function20 Apr 2008 02:55 GMT4
I am having trouble in my excel class again.  Nothing seems to be even close
to what we do in the book when we get to the assingments.
Need to enter a formula using the Nested If function to determine the number
of vacation days each employee is eligible for based on the employees ...
Excel Formulas20 Apr 2008 00:03 GMT2
I am trying to create a formula that averages numbers in a specific cells on
multiple worksheets within the same workbook.  Once I set up the template (or
Total page), I would like to be able to copy that page to another workbook
and have it function in the same way.  However, I ...
line chart question - Possible to make the line transition from point     to point via 95-degree angles?19 Apr 2008 23:19 GMT2
I am making some line charts and am wondering if anyone knows a simple
way to have the lines transition from data point to data point in
crisp 95-degree angles, rather than direct lines as is the default.
Thanks for any suggestions.
DSUM function19 Apr 2008 21:14 GMT4
another quetion with my homework.
Use the DSUM function to calculate the total number of vacation days
remaining.
I put in this:  =DSUM('Employee Data'!E6:E109,"17",D4)
excel to make the days cary over month to month automaticly19 Apr 2008 18:05 GMT1
I WOULD LIKE EXCEL TO IMPUT THE DATES OF CALEDAR IN THE EXAM:A CULUM IN SPRED
SHET 1 THEN CARY IT TO THE SPREDSHET2 THE NEXT MONTH AND SO ON
Convert date to number19 Apr 2008 17:46 GMT5
I am wanting to convert date using the today() function to the date only for a sum.
e.g. A1 =Today()
B1= 300
C1= B1/A1
page layout on excel 200719 Apr 2008 14:35 GMT2
I can't seem to change the page layout on any spreadsheets? It should be as
simple as going to page layout , orientation and choosing. I can't access any
options in page layout. Is this because I have no printer attached to my lap
top?
Excel 2007 Conditional Formatting Problem19 Apr 2008 14:34 GMT2
I've got a little problem.
I'm busy with a spreadsheat where i can see if someone has been paid
on a sertain date.
I've made a litte example-spreadsheat:
Can I auto populate Comments in sequence over different sheets ?19 Apr 2008 10:01 GMT2
Anyone out there clever enough to tell me how to sequentially populate
the comments field in cells... the problem I can see is that the cells
are in a grid of A5-10 through to i5 to 10, I want them populating
a5,a6,a7,a8,a9,a10,b5,b6 etc and when I get to i10 I want the sequence
How to find out repeated data19 Apr 2008 06:46 GMT1
Can anybody tell how we can find out any repeated data in the worksheet
easily and then delete it.
slow opening19 Apr 2008 04:04 GMT1
Excel 2007 is slow opening small files.
Email attachments, click to open, could take minutes to open a 30K file.
However, if I click the menu button in Excel, the file will pop open.
Same goes for double-clicking files in Windows Explorer.
Print Area setup with Formula resetting19 Apr 2008 03:09 GMT2
I am having a problem with the Print_Area name.
I have set up a custom print_Area formula using insert->name->define
so that my print range is dynamic based on certain selections a user
makes regarding some calculations
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.