Advanced Excel Training Guide

Michael K asked:


I want to make a simple Excel program that will randomly place employees in different areas of a job sight and not repeat names, for example, there are 5 different areas that they can work, and I get complaints of favoritism when placing them. If I can get Excel to do it randomly they can’t complain.

Anne

denim asked:


I need to be able to figure what the interest rate is when the loan amount, payment amount and terms are known. Does anyone know the way to build a formula in Excel for calculating this?
That helped somewhat. I used the RATE function to get the monthly rate on a 60 month loan, then multiplied by 12 to get yearly, but it is coming out about .005 percent off. When I put the numbers into my amortization schedule the payment is off by about 25 dollars. (74,500 total loan, 60 months with $1500 pmt is what I want. The rate it gives me makes the payment $1475 in my schedule.)
Never mind that last comment. It is working perfectly. THANKS!!!

Dora

battlepig53 asked:


All of a sudden the formulas in my excel worksheets do not work automatically. I have to hit control+alt+F9 to get them to calculate. I use office 2007.

Brent

darylvin1987 asked:


I have got an Excel ‘07 file (an inventory list) with 13+ worksheets. I want each of these worksheets to be given to 10 different people, where the worksheet becomes a workbook as a whole. The file is on our server and I want these 10 people to get the data updated when I update my excel workbook.

Heidi

GamerGeek Review asked:


I am trying to have Excel add up the value of numbers listed in a particular column and provide the sum of it all in a particular cell within that column. How does it work?

Gregory

coleycole asked:


I need a list of three work items and three three home/leiaure items, and three school items that would be or are useful in an excel spreadsheet?? I also need one visual excel example.

Leo

TomandShannan asked:


The software I use to generate reports kicks them out in an excel format. I need to turn the report into a word document that is more visually pleasing to view the information from the bland excel report. Any suggestions or ideas how I can accomplish this?

Bradley

Hans F asked:


I am trying to archive lots of data in Excel from different sources. I am having the problem of little spelling errors from the different sources not being recognized by excel as the same type of data. For example if one person had used the term “Table” and another used the short hand “Tab”, I paste them both into a spreadsheet hoping that they are recognized as the same- but of course excel treats them as different.

Is there a command in excel where I could search out every example of “Tab” and have excel change it to “Table”? Or some other quick way to get the same result?

Danielle

NMAL524 asked:


I created an excel spreadsheet in the newest verison of Microsoft excel 2007. I want to email it to my mother but she has the old version of Microsoft excel, is there a way the file can be converted so she can open it?

Patricia

burnside 2020 asked:


I need to learn VBA because it is what we use at our work to parse data from Excel spreadsheets. I have learned so many programming languages in school such as Pascal, BASIC, C and MATLAB. However, it was so long ago and I almost forgot everything. It seems like looking into those books they sell at Borders doesn’t help enough. I would like to start from scratch. All my co-workers are pretty skilled with VBA for Excel and I would like to learn more. How do I start?

Rose