Free Microsoft Excel 2013 Quick Reference

Forest Plots......can these be done in excel or powerpoint

Forest Plots......can these be done in excel or powerpoint


Post your answer or comment

comments powered by Disqus
I have two columns with the following format:
Long Lat
97-31-10.2 W 25-57-51.2 N

So i need to change this format(Minutes-Degee-Sec) to Decimal Degrees.

So from the first column Long:
(97/3600)+(31/60)+10.2=97.5195.This is the number in Decimal degree for Long.

Can this be automated in Excell ?

Regards
Rick

print area can't be defined in Excel?

One of our users showed me this yesterday:
http://marcmedina.com/Microsoft/excel_issue.jpg

In 2003 she was able to define the columns of a spreadsheet to print, but it's not able to be chosen in 2007. She has a full install and I went through the security settings (and the other options too) but can't find anything to resolve it.Has anyone else run into this?

To be more specific, she is trying to do this from the print preview menu. I did find how to do it within Excel, but this is a user who finds it very difficult to change "the way she's always done it".
I just spoke with her again and got more clarification. This particular spreadsheet is 5 pages wide. She needs to print it so that column A is at the beginning of each page as it prints.

I have data that is being pasted from excel into access. i do not want the users to have to format any data in excel. can an access table be formatted something like Code:
 or is this something that can only be done in excel??

Example
A1 = smith1234

When copied from excel and pasted to a table in access I want to see '1234'.

Does the formatting have to take place prior to access?? thanks!!

Lets say I want to plot some data (on a scatter chart) which is a function
of temperature. For convenience I would like to show two x-axes which gives
the correpsonding x-values in Fahrenheit and Celcius. So then I could chose
to plot(x_fahrenheit, y1) on x-axis1 or plot(x_celsius, y2) on x-axis2
(forgive the Matlab plot notation) and could choose whether to read off the
x-axis values in Fahrenheit or Celsius directly from the plot.
Can this be done in Excel (or Matlab). What if I needed 3 x-axes?

Thanks.

Hi there,
Does anyone know how to do this with a macro? (I could do it with
multiple formulas but would end up with a spreadsheet from hell)

I have several sheets, each with a grid of cells B6 to I45 filled with
its own data. I want to create a new grid on another sheet comprised of
segments of these other grids on these sheets. Some type of looping
macro is needed to do the following.

The macro will start on a “base” sheet and start copying cells from the
B6 to I45 grid onto a “compiler” sheet. I need to be able to specify
where to start and stop copying on the base sheet. (via some input data
cells eg Cell P3 contains start cell reference, Cell P4 contains stop
cell reference ) Once the macro has reached the specified stop cell it
must then go to another “input” cell (e.g. P5) which will contain the
name of the sheet it must then go to. The macro will then go to that
specified sheet and continue compiling values from that sheet onto the
compiler sheet. Each sheet will contain P3,P4,P5 to tell the macro
where to start and stop copying cells from and then which sheet to go
to next. This start copying from this cell and stop copying at this
cell routine will continue until a sheet has cell P5 = “Compiler”. On
this sheet the macro will copy the last set of specified cells to the
compiler sheet (as specified on P3, P4), then read P5, go to the
compiler sheet and stop.

Here is an example
(Note each sheet except the compiler sheet will have P3 as its start
copying cell reference, P4 as its stop copying cell reference and P5 as
the name of which sheet to go to next.

Sheet 1 inputs
(start cell) P3= B6
(stop cell) P4=I7
(go to)P5= SHEET 2

On “Sheet 1”, the Macro will copy all cells B6 to I6 and then B7 to I7
onto the “compiler” sheet, it will then go to the sheet named in P5 (in
this case it is sheet 2)

Sheet 2 inputs
(start cell) P3 = B8
(stop cell) P4 = H8
(go to) P5 = Sheet 3

On “Sheet 2” the macro will again copy cells as but this time it will
be copying B8, D8, E8 onto the compiler sheet. The macro will then read
the value of P5 on sheet 2 which tells it to go to “Sheet 3”

Sheet 3 inputs
(start cell) P3 = B9
(stop cell) P4 = I39
(jump to) P5 = Compiler

On “Sheet 3” the macro will copy all cells as specified between and
including B9 and I39 then go to the Compiler sheet where the macro will
end.

Can this be done or not? Any help very much appreciated

Cheers

Simon

--
simonsmith
------------------------------------------------------------------------
simonsmith's Profile: http://www.excelforum.com/member.php...o&userid=34235
View this thread: http://www.excelforum.com/showthread...hreadid=542712

Hi there,
Does anyone know how to do this with a macro? (I could do it with multiple formulas but would end up with a spreadsheet from hell)

I have several sheets, each with a grid of cells B6 to I45 filled with its own data. I want to create a new grid on another sheet comprised of segments of these other grids on these sheets. Some type of looping macro is needed to do the following.

The macro will start on a “base” sheet and start copying cells from the B6 to I45 grid onto a “compiler” sheet. I need to be able to specify where to start and stop copying on the base sheet. (via some input data cells eg Cell P3 contains start cell reference, Cell P4 contains stop cell reference ) Once the macro has reached the specified stop cell it must then go to another “input” cell (e.g. P5) which will contain the name of the sheet it must then go to. The macro will then go to that specified sheet and continue compiling values from that sheet onto the compiler sheet. Each sheet will contain P3,P4,P5 to tell the macro where to start and stop copying cells from and then which sheet to go to next. This start copying from this cell and stop copying at this cell routine will continue until a sheet has cell P5 = “Compiler”. On this sheet the macro will copy the last set of specified cells to the compiler sheet (as specified on P3, P4), then read P5, go to the compiler sheet and stop.

Here is an example
(Note each sheet except the compiler sheet will have P3 as its start copying cell reference, P4 as its stop copying cell reference and P5 as the name of which sheet to go to next.

Sheet 1 inputs
(start cell) P3= B6
(stop cell) P4=I7
(go to)P5= SHEET 2

On “Sheet 1”, the Macro will copy all cells B6 to I6 and then B7 to I7 onto the “compiler” sheet, it will then go to the sheet named in P5 (in this case it is sheet 2)

Sheet 2 inputs
(start cell) P3 = B8
(stop cell) P4 = H8
(go to) P5 = Sheet 3

On “Sheet 2” the macro will again copy cells as but this time it will be copying B8, D8, E8 onto the compiler sheet. The macro will then read the value of P5 on sheet 2 which tells it to go to “Sheet 3”

Sheet 3 inputs
(start cell) P3 = B9
(stop cell) P4 = I39
(jump to) P5 = Compiler

On “Sheet 3” the macro will copy all cells as specified between and including B9 and I39 then go to the Compiler sheet where the macro will end.

Can this be done or not? Any help very much appreciated

Cheers

Simon

Hi All

Basically in the box marked 'A' & 'AA' is a drop down list and using data validation users are only allowed to input the following letters ....

n - Normal Work Day
h - Holiday
s - Sick
t - Training
u - Unauthorised Absence
b - Bank Holiday
c - Company Shutdown

Then in boxes marked 'B-E' is the following formula (D11 refers to box 'A') .....

=LOOKUP(D11,{"b";"c";"h";"n";"s";"t";"u"},{"Bank Holiday";"Company Shutdown";"Holiday";"";"Sick";"Training";"Unauthorized Absence"})

Then in boxes marked 'F - I' is the following formula (D15 refers to box 'AA') ......

=LOOKUP(D11,{"b";"c";"h";"n";"s";"t";"u"},{"Bank Holiday";"Company Shutdown";"Holiday";"";"Sick";"Training";"Unauthorized Absence"})

My intention is to display holiday, sick etc in boxes 'B - I' by copying the Lookup formula into each box.

Then eventually i will use conditional formatting to look for those words to colour those fields a different colour for clarity.

The table shown will be repeated 365 times vertical to represent every day per year.

The table shown will be repeated 9 times horizontally to represent each employee.

I'm trying to use the VLOOKUP and HLOOKUP to automate this and reduce the number of statements within the spreadsheet, making it easier to change if needed.

I'm struggling using these statements as D11-D14 is a merged box and the value of box 'A' is only held in D11.

Can this be done?

DateDayTypeTimeConfirmed Order No.Site Location01/01/08TuesdayABCDEAAFGHI02/01/08Wednesday

I want to paste in a list of stock symbols and then use my own rating
system to rank them. I have a list of criteria I will use to rank them
with but I want to map written values to numeric values and use those
to create a score for each stock.

Ill try to explain in a little more detail. Below is a very simplified
version of what I am trying to achieve.

Column A | ColumnB | ColumnC | ColumnD | Score |
SYMBOL | Trend | Close Price| Volume |

ColumnB/C/D all use drop down lists with friendly names to pick from.
For example, ColumnB would have the choices Up, Down and Sideways as
the three options in the dropdown list. Each choice needs to map to a
numeric value. Let's say Up has a value of 1, Down has a value of -1
and Sideways has a value of 0.

Similarly, the other columns would be setup in the same manner.

Finally I want the Score cell to tally the values of columns B,C and D
etc.

I can get dropdown lists to make my friendly choices but I cannot get
any further. I tried using VLOOKUP because all the research I could
find made it seem like that was the correct method, but my Excel
ineptness becomes apparent in trying to make it work.

I would much appreciate some help please.

Oh, and to further complicate this a little, I would also like to make
each list configurable without having to recode a bunch of stuff. My
current scoring strategy is still very infantile and I expect to be
adjusting it many times before I settle on a scoring system I feel is
accurate. For this reason I would like to have each list on its own
worksheet rather than multiple ones on a single worksheet. This would
make it more intuitive to update for me...

How can Sparse a field in Excel? I have a column/field with LastNM, FNM and
Mid all together I need to break it up into a column/field for each part of
the name. Can this be done in Excel? Can you convert a Spreadsheet into a
Table in excel to be able to use New Database Query?

I would like to create a command button in excel on the worksheet to print a
portion of the worksheet and/or graphs at the bottom of the worksheet. Can
this be done in Excel and how much VBA programming is involved?

I am setting up a document in Excel and need to split a cell into two
additional cells, but they need to match with a previous row...I know you can
do it in Word, can this be done in Excel

I would like to create a command button in excel on the worksheet to print a
portion of the worksheet and/or graphs at the bottom of the worksheet. Can
this be done in Excel and how much VBA programming is involved?

I want to set up a schedule of task that need to be done on a certain date
with a automatic reminder set to remind me 5 to 10 days in advance of the
task date, can this be done in excel and how do i do this.
thanks

In word you can animate your text i.e. marching ants! Can this be done in
excel too?

Hello all,

Office 2000/Win 98

I am new to excel but know a little about access and I am only just now
learning VBA. I hope someone can help me.

I am working on our family budget worksheet in my spare time.

In Access you can ask for user input from a query. Can this be done in
Excel?

I want to:

1. Push a command button
2. Have a little form pop up that asks for the paycheck amount
3. Press ok; Excel sums the last paycheck's leftover amount with current
paycheck
4. Excel places new pay amount in Start Amount cell.
5. Excel clears last pay period line item budget amounts.

Can this be done in Excel? If not, any suggestions?

TIA

Jake

I want to be able to open an Access table (from an .mdb file) in Excel 2003
and then use the data I've entered in Excel to update the Access table. I
think this has something to do with ODBC, but I am just stumped!

I can do it (sort of) in Open Office, but it's kind of clunky for this
application. Can it be done in Excel?

(Obviously, I don't have Access...but you knew that already, right? )

Thanks,
Ray

I want to hide my formulas (formuli ?) and leave everything else unprotected.

Can this be done in Excel 2000 ?

I have an invoice that I have set the print area for and it has set every
nonadject set of cells as its own page giving me 26 pages on the same sheet.
I have tried everything help has suggested but nothing has worked. Can this
be done in excel 2002?
Thanks for any help.

In word 2002 the first line you type, when you go to save becomes the
sugested file name.

Can this be done in excel? Instead of the book1, book2, etc..

With this question can the refrance cell for the file name have lookups
involved?

My wife & I made a spreadsheet for our buisness and save from the master to
a specific job numbr and property adress. If it can be lookuped in the cell
this would save alot of time.
Thanks for all the help to come!

I was hoping to be able to do a MOD-10 check on a credit card number in Excel
2000. If it can't be done in Excel itself, is there a macro that can be done
in Visual Basic that can run in Excel 2000?

I have a data set based on an uneven distribution of cards in a 60 card deck, each with a value ranging from 0-5.

I need to build a probability distribution of all the random samples of 10. So, how many random sets of 10. have an average value of 1 (or a total of 10) etc.

Then, I need to build a variable distribution so that it changes as I change the sample size. So, with a sample of 20 cards, what does the distribution look like?

Can this be done in excel? Should I post what I have now to work with?

To comply with federal and university regulations, we need to encrypt
sensitive data, such as Social Security numbers. How can this be done in
Excel?

I would like to create a macro to navigate within a spreadsheet and pause for
user input. I remember in Quattro the "?" would pause for input and "right"
would move one cell to the right after the enter key was pressed. Can that
be done in Excel?

I've seen an date/time signature stamp button in Access using the Lotus notes
email address list. Can this be done in Excel using the Outlook email
address list?


No luck finding an answer? You could always try Google.