Highline Excel Class 29: Basic Statistics Numerical Measures

I am fairly good at excel.

I have been asked to train about 5 colleagues in Excel.
These are very basic users.
Can anybody suggest where I might get some suitable tutorial notes to download.

Ideally just a small number of pages explaining the basics.

so I just had my annual performance review and we were talking about new projects and responsibilities for me for 2009
I do reports for a hospital in new york city, the data is in access and the reports are in excel
I am by no means an expert in either, but I do know a few things, so I suggested that I teach a beginner / intermediate excel class. My supervisor really liked the idea.
(I'm obviously looking for things to make me more valuable to the hospital)
so, if you were to teach a beginner / intermediate excel class, what topics would you include?
formatting? importing other file types? vlookup? array functions? charting? pivot tables? date functions?
I figure vba is definitely out, but vba and sql is what I'm best at.

right now I'm going to search google for beginner intermediate excel class, and see which topics come up most often

Fellow Forum Members,
I'm the kind of person that has always pronounced the word "statistics" as "sadistics". Nevertheless, I need to figure something out that invovles statistics and I'm wondering if Excel 2003 is the right tool. My objective is to figure out the total quantity of combinations the number range 1 through 44 has when it's combined with a second number range that also has number values of 1 through 44. I don't know what the statisical forumla is, but does Excel 2003 provide the function needed to figure this out? Better yet, can it generate a list of all the number combinations existing between two number sets made up of values 1 through 44 combined. Any help will be greatly appreciated. Thanks.

First post here - thanks to all who contribute for refining our work with Excel. Here's my question:

Two days ago downloaded and started working with PowerPivot, which looks like a great tool. When tried to add calculated fields in pivots, found that it was greyed. Surprise!

Googled it and found that it was replaced by the new DAX measures and said ok. Later I found that this feature is more complicated and less productive than the old 'calculated fields'. For example, I need to divide two columns 'revenue' and 'units sold', to find the unit revenue for reach line item of the pivot. Spent quite some time over the dialogue boxes and found nothing there.

Can anybody give a hand with the complex syntax of the DAX functions for simply dividing two columns?

Thanks in advance

So my company does business with a huge bank in the US, that sort of rhymes with "hold", anyway I requested that they send statements/invoices to me via email, no problem...

Well they sent me an Excel file that was password protected and then emailed me the password they used to "protect" the excel file (If we are worried email about security then why are you sending passwords via email? ).

I opened the excel file with the given password and in Sheet1 was two embedded PDF's... Which I was not able to open for whatever reason. After a couple of back and forths I said just send my the PDF's, which they did, but this was in their postscript of the email:

Quote:

Although G______ has offered addressee(s) named above a secure alternative to sending the information contained in and accompanying this communication, addressee(s) named above have selected this insecure means at their sole risk and agree that G______ shall have no liability and shall indemnify G______ for any loss, liability, cost, expenses, demands, charges and claims of any kind resulting from the use of this insecure means. If this is incorrect, please contact your G_____s representative and ask for the secure alternative.

[bolding is mine]
Really, a secure alternative? an embedded object? If I had the ability to intercept email the ability to crack the excel password would barely be an annoyance, let alone secure the information. Did these guys hire the TSA for advice?

Using the limited tools in my corporate sandbox, would not zipping it and password protecting the zip file be more secure? or if I was a multi-billion dollar mega-corp and could spend some jack on a product, any other of a hundred other methods actually provide some semblance of security?

Another bank I deal with sends their stuff via something called "Ironport" it at least something more than the pretext of security.

Ah the Theater of Security - if it was not so maddening then it would be hilarious.

Anyone have a method for repeated measures ANOVA using Excel 2007?

I recently used XIRR to calculate the return on an investment where I had paid monthly premiums into a policy and wanted to compare the return based on the latest policy value. The formula worked fine but I wanted to check my understanding of what it has calculated. My understanding is that it calculates the rate of return of the total premiums paid over time. It is my understanding then that it will compound the return on a monthly basis rather than annual. e.g. the result will always look lower than it would if it was calculated on an annual return.

How does this measure compare with for example XNPV?

What type sof options are available to protect data contained within a form once it is entered?

I am envisioning a checkbox that could be selected for a defined area. When the data for that designated area is entered, the checkbox would be selected, thus locking the text for that area.

I thought that it may be possible to use a Macro for this, but I am just learning so have no idea.

Thanks in advance for any suggestions.

What type sof options are available to protect data contained within a form once it is entered?

I am envisioning a checkbox that could be selected for a defined area. When the data for that designated area is entered, the checkbox would be selected, thus locking the text for that area.

I thought that it may be possible to use a Macro for this, but I am just learning so have no idea.

Thanks in advance for any suggestions.

I am trying to write a Make Table query that pulls in all the fields from another table but multiplies two meaures to create a new measure.

Below is the table I am using for this query. I want to multiply " Average NB Written Premium" by "Ultimate NB Policy Count." I know I have to use the build feature in Query Design view but I havn't had any luck yet. Any ideas?

zAverage Premium 2 (YE Numbers) Cube Version Source Term Channel Rate_Level LOB Region Measures Period SumOfValue sfm_prod:Premiums Scenario Plan Reported 12 month Agt Spon Home Legacy Homesaver AL.Birmingham Average NB Written Premium 2010 1410.20250404491 sfm_prod:Premiums Scenario Plan Reported 12 month Agt Spon Home Legacy Homesaver AL.Birmingham Average NB Written Premium 2011 1785.55261301715 sfm_prod:Premiums Scenario Plan Reported 12 month Agt Spon Home Legacy Homesaver AL.Birmingham Ultimate NB Policy Count 2010 2.14660729808804 sfm_prod:Premiums Scenario Plan Reported 12 month Agt Spon Home Legacy Homesaver AL.Birmingham Ultimate NB Policy Count 2011 2.06602104153363

I am using MS Access 2003.

Thanks in advance for any help. It is greatly appreciated!