Excel and programs

The UK's most regular instructor-led training courses.
Training information: excel-training-course · Excel course · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version 2003

Excel and programs

Katlin has attended:
Excel Intermediate course

by - delegate Katlin [1 post] (2008 May 20 Tue, 16:06) Reply

Can you transfer information from an excel spreadsheet to a program?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Aug 29 Fri	Southwark	3	book now	£224	£235
2003	2008 Sep 3 Wed	Bloomsbury	5	book now	£219	£235
2003	2008 Sep 5 Fri	Bayswater	4	book now	£195	£205
2002/XP	2008 Sep 10 Wed	Tooting	0	FULL
2003	2008 Sep 10 Wed	Bloomsbury	5	book now	£219	£235
2003	2008 Sep 12 Fri	Southwark	7	book now	£203	£230
Full Schedule: See all 127 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: excel and programs

by - trainer Stephen gold contributer [326 posts] (2008 May 21 Wed, 11:10) Reply

Hi Kaitlin

Thank you for your question

Could you please clarify, which program you are interested in transfering data to?

The anser is almost certainly yes, but I need to know which application you want so that I can advise you as to the best technique

Regards

Stephen

· Microsoft Excel Courses Teach Advanced Macro Techniques
· Advanced Excel Training - takes you to the next level
· How to Create Better Excel Spreadsheets: Part Two
· A Beginners Guide To Formulas In Excel
· 3 Ways that MS Excel Courses Can Drastically Improve Productivity for Teachers

Please browse our web site to find out more about
excel-training-course and other Microsoft training courses.

Excel tip:

Checking if a calculation adheres to Order of Precedence

When writing formulas you must make sure that results will be calculated as you intended.

Excel adheres to the standard order of precedence for calculations. It calculates percentages, exponents, multiplication, and division in this order before calculating addition and subtraction.

For example, =7+5*3 results in an answer of 22, not 36.

To force a calculation to be completed before another calculations, place the section in parentheses: =(7+5)*3 will result in 36.

To check how excel is evaluating a formula, click on the cell and select the 'Tools' menu, select 'Formula Auditing' and click 'Evaluate Formula'

In the dialog box click on 'Evaluate' to watch as each part of the formula is successively calculated.

View all Excel hints and tips