Excel Statistics 50: Probability Basics (by hand notes)

I have a spreadsheet that shows a date, because of shipping I need to enter a
date and then calculate three months back and enter that date, For example
Cell A1 March, 2004 and I have to enter into cell B1 January 2004, how do I
get Excel to do this automatically.

Please can anyone help me answer any of these questions:

How would you add the contents of the cells from A1 to A10. Give 2 ways
to do this. (hint: Look up "Examples of common formulas" in Excel
help



How do you format a cell to have dollar signs next to the numbers?



How do you add the contents of cells A1 through A10 on sheet 1 and make
the answer show up on sheet 2?



How do you rename a sheet?



Can I delete the sheets that I don't need? If so how?



How do I freeze rows or columns of the sheet so that they don't'
move when you scroll up or down? Example: My name is in Column A, when
I scroll right my mane stays on the screen and column B moves behind A



How do you add up all the contents of column D and make the answer show
up in column C?


Thanks in advance!
abi

I went to the website cpearson.com and got the information for the syntax and the formula to sum numbers in different colors on a worksheet
now my problem is where do i put the visual basic part of the works so the formula can call on it
can you tell i have no idea but great hopes!!!
thanks everyone

I'm trying to populate a Word 2003 document with data from an Excel 2003 document -- I realize some use mail merge but this, for me, has been an excruciating pain in the neck, so I am trying to avoid it by going the Word bookmark route, which looks like it will fit the bill... if only I could figure it out!

I have done some searches on here and this is the code that seems to have set the precedent:

http://www.mrexcel.com/forum/showthread.php?t=478182

However, as a beginner, it's a bit overwhelming for me. While I'm learning a lot by looking at it and looking up the things I don't understand, it's taking a long time and I actually need to use something similar for my own project.

Specifically, I wanted to open a template letter; populate it from the active Excel row I'm working on; and then "Save As" so I can keep the template.

Is there some more generalized information out there that outlines this procedure? Otherwise, would someone be kind enough to separate the code and/or elaborate more on what the invididual lines/sections do?

Hope you can help!

Basicly the same as the title.. I want to learn more about excel... I consider myself to be just a bit better then a noob, i can use the sum function, and i think i understand how most easy things work

Alright i'm using Excel 2007, i created a table with 2 columns and 5 rows
cell A1 - A5 has a list of numbers, and Cells B1 - B5 has a list of food items,

I've created a blank User-Interface form, using VisualBasics which came inside excel 2007, how do i get the table in my Excel Sheet, to show as it is with it's color coding and grid lines in the VisualBasics Form,


My second question is, I also created a Seperate Visual Basics form in Visual Basics 2008, could i get the table in the Excel form, to show in the form in Visual Basics 2008 programme, I have no clue how to link Visual basics, to Excel so a non-overly technical step-by-step guide would be extremely appreciated,


Thank you,

Say you have a table (5x5, for argument's sake)-- along the top is
demand from customer A, on the bottom is demand for customer B. Say the
legend for both the rows and the columns is (0,1,2,3,4), and in the
table itself is the corresponding probability for each pair.

In other words, if you want to see the probability that demand from
both customers was zero, you'd look in the upper left corner of the
array. If you wanted to see the probability that customer A demanded 2,
and customer B demanded 3, you'd go down 3, and over 4 (remember that
0,0 is upper left, not 1,1).

Without using a macro, or manually writing out sum commands, is there a
way to create a total probability distribution table from the table I
have given you? In other words, we know that minimum demand is 0, and
that sum is given by the upper left cell, but the probability that the
total demand is 3 is the sum of cells (0,3), (1,2), (2,1), and (3,0).
The table in this example would be 9 wide, with the probability of 0 on
the left, and 8 on the right.

Perhaps there's a way to match a VLOOKUP, and HLOOKUP, and a few IFs,
maybe, but if anyone can suggest a more automated way or a clean
syntax, I'd be grateful.

Thanks!

Is there a hand tool in excel to click and drag a sheet around the window? It would be similar to the hand tool in Adobe Reader. Linked to a short cut, this would be the fastest way to get around a sheet.

I have tinkered with this for a few days. I am getting the header row to copy and the first sales person (SP) as a secondary header. The problem is that the SP has more than one row of data. The number of rows is arbitrary; some have one, some have many, and in a lot of cases the SP is a blank cell. The macro executes and creates a separate workbook for the same sales person over and over until I break execution of the macro. Any thoughts most welcome.

Sub CreateWorkbooks()
Dim WBO As Workbook ' original workbook
Dim WBN As Workbook ' new workbook
Dim WSO As Worksheet ' original worksheet
Dim WSN As Worksheet ' new worksheet

Set WBO = ActiveWorkbook
Set WSO = ActiveSheet

finalrow = WSO.Cells(Rows.Count, 1).End(xlUp).Row + 1

LastSP = Cells(2, 53)

StartRow = 2

For i = 2 To finalrow
ThisSP = WSO.Cells(i, 1)
If ThisSP = LastSP Then
' do nothing
Else
' We have a new salesperson starting
' Copy all of the previous rows to a new workbook
LastRow = i - 1
RowCount = LastRow - StartRow + 1

' Create a new workbook.
Set WBN = Workbooks.Add(Template:=xlWBATWorksheet)
Set WSN = WBN.Worksheets(1)

' Set up the headings for the report
WSN.Cells(1, 1).Value = "Prospect List"
WSN.Cells(1, 1).Font.Size = 14

WSN.Cells(2, 1).Value = WSO.Cells(StartRow, 53)
WSO.Range("A1:BD1").Copy Destination:=WSN.Cells(4, 1)

' copy all of the records for this salesperson
WSO.Range(WSO.Cells(StartRow, 1), WSO.Cells(LastRow, 56)).Copy Destination:=WSN.Cells(5, 1)

FN = LastSP & ".xlsx"
FP = WBO.Path & Application.PathSeparator

WBN.SaveAs Filename:=FP & FN
WBN.Close SaveChanges:=False

LastSP = ThisSP
StartRow = i
End If
Next i
End Sub

Hello everyone,
I've been increasingly working with Excel for my job. With some tasks becoming repetitive, I thought that I should start learning Macros to make what I have to do as quick and efficient as possible.

I don't have experience working with Macros, although I've been studying VB.Net for several months now, so that should speed along my learning process at least a little bit.

One of the first Macros I hope to write is something that I believe would help big time with some of the sales report that I have to do.

One simple report for example is I take the weekly sales figures for each of our sales people and put them into a spreadsheet every month, while comparing it to the previous year... It's not a difficult report to put together, but there's one issue that makes it a pain in the rear end. In the software that we use to store our sales reports, if a sales person has $0 in sales for the date range that I've specified, they will not show up at all. This makes me unable to just copy and paste columns because a sales person may be in the data one week and not in the data the next. I want to make a Macro that will compare a column listing sales people to a list of all of our sales people and create rows for sales person that is not already included in the column.

Since I'm new to this, I was hoping somebody could give me either some sample code or a suggestion on how to best go about accomplishing this. Thank you in advance for any helpful feedback.