ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Good Examples (https://www.excelbanter.com/excel-discussion-misc-queries/234112-good-examples.html)

Annie

Good Examples
 
Hi - I am teaching Excel this week and am looking for good examples of when
to use the following topics in class. Can anyone suggest some sites where I
might find some good exercises:

Forecasting with Goal Seek and Scenarios including Scenario Merging.
Macros
IF AND OR Formulas
Consolidation

Many thanks

--
Kind regards

Ann Shaw

Bob Phillips[_3_]

Good Examples
 
It depends upon the level of the class Annie.

--
__________________________________
HTH

Bob

"Annie" wrote in message
...
Hi - I am teaching Excel this week and am looking for good examples of
when
to use the following topics in class. Can anyone suggest some sites where
I
might find some good exercises:

Forecasting with Goal Seek and Scenarios including Scenario Merging.
Macros
IF AND OR Formulas
Consolidation

Many thanks

--
Kind regards

Ann Shaw




JLatham

Good Examples
 
I'll touch on some of the easy ones since I don't use the others in my work
with Excel: IF, AND, OR, macros

IF AND OR
These are (some of) your decision makers.
Examples for IF: you need to make a price decision based on a quantity
purchased; need to convert numeric values to letters [as with class grades];
testing for error conditions in formulas to help keep the spreadsheet 'neat
and clean'; validation of a value prior to performing a calculation.

AND and OR go along with IF to provide the ability to use multiple
conditions to base a decision on. Lets say you give a 10% price break for
quantities over 100 OR for any quantity if a purchaser is an OEM purchasing
from you, the IF(OR()...) As for AND - one I see right now: testing to see
if a value is within a range or not.

MACROs - any time you find you need to do something that can't be done with
worksheet functions, such as adding/deleting rows/columns or automatically
hiding/displaying rows/columns; validating data in multiple areas of the
workbook before taking some action as saving/printing; creating a new user
defined function to perform a special operation; working with UserForms; to
perform an often used procedure such as adding and setting up a new sheet in
a workbook; to cause an action to take place in response to input as perhaps
going to a specific cell after a predetermined value is entered in some other
location. Or, if you're like me and just better at coding than with
worksheet functions, whenever the urge comes over you.

Hope this gives you some ideas for those areas.

"Annie" wrote:

Hi - I am teaching Excel this week and am looking for good examples of when
to use the following topics in class. Can anyone suggest some sites where I
might find some good exercises:

Forecasting with Goal Seek and Scenarios including Scenario Merging.
Macros
IF AND OR Formulas
Consolidation

Many thanks

--
Kind regards

Ann Shaw


Annie

Good Examples
 
It is an Intermediate Class - they would not have VBA experience so I have
some examples just looking for more exercises to keep them busy!

Thanks


--
Kind regards

Ann Shaw


"Annie" wrote:

Hi - I am teaching Excel this week and am looking for good examples of when
to use the following topics in class. Can anyone suggest some sites where I
might find some good exercises:

Forecasting with Goal Seek and Scenarios including Scenario Merging.
Macros
IF AND OR Formulas
Consolidation

Many thanks

--
Kind regards

Ann Shaw


Bob Phillips[_3_]

Good Examples
 
Then I would suggest that you think of a few examples that they might use,
such as formatting some tables, looping and deleting based upon a condition,
and show them how to record macros, then show them how to remove the macro
recorder gumpf.

--
__________________________________
HTH

Bob

"Annie" wrote in message
...
It is an Intermediate Class - they would not have VBA experience so I have
some examples just looking for more exercises to keep them busy!

Thanks


--
Kind regards

Ann Shaw


"Annie" wrote:

Hi - I am teaching Excel this week and am looking for good examples of
when
to use the following topics in class. Can anyone suggest some sites
where I
might find some good exercises:

Forecasting with Goal Seek and Scenarios including Scenario Merging.
Macros
IF AND OR Formulas
Consolidation

Many thanks

--
Kind regards

Ann Shaw




RagDyeR

Good Examples
 
All right, I'll bite!<g

What's "gumpf"?
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Bob Phillips" wrote in message
...
Then I would suggest that you think of a few examples that they might use,
such as formatting some tables, looping and deleting based upon a condition,
and show them how to record macros, then show them how to remove the macro
recorder gumpf.

--
__________________________________
HTH

Bob

"Annie" wrote in message
...
It is an Intermediate Class - they would not have VBA experience so I have
some examples just looking for more exercises to keep them busy!

Thanks


--
Kind regards

Ann Shaw


"Annie" wrote:

Hi - I am teaching Excel this week and am looking for good examples of
when
to use the following topics in class. Can anyone suggest some sites
where I
might find some good exercises:

Forecasting with Goal Seek and Scenarios including Scenario Merging.
Macros
IF AND OR Formulas
Consolidation

Many thanks

--
Kind regards

Ann Shaw





JLatham

Good Examples
 
I'm thinking maybe it's that stuff that squishes up between your toes when
you walk barefooted in the yard after days of heavy rain. Or maybe things
like all those "ScrollLarge", "ScrollSmall", "Select this - select that", and
the With... that is 47 lines long to change a single property.

"RagDyeR" wrote:

All right, I'll bite!<g

What's "gumpf"?
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Bob Phillips" wrote in message
...
Then I would suggest that you think of a few examples that they might use,
such as formatting some tables, looping and deleting based upon a condition,
and show them how to record macros, then show them how to remove the macro
recorder gumpf.

--
__________________________________
HTH

Bob

"Annie" wrote in message
...
It is an Intermediate Class - they would not have VBA experience so I have
some examples just looking for more exercises to keep them busy!

Thanks


--
Kind regards

Ann Shaw


"Annie" wrote:

Hi - I am teaching Excel this week and am looking for good examples of
when
to use the following topics in class. Can anyone suggest some sites
where I
might find some good exercises:

Forecasting with Goal Seek and Scenarios including Scenario Merging.
Macros
IF AND OR Formulas
Consolidation

Many thanks

--
Kind regards

Ann Shaw






Bob Phillips[_3_]

Good Examples
 
It's all that spurious stuff that gets inserted into documents and such like
to make the author seem erudite and smarter than us mere plebs. The macro
recorder creates the same unnecessary garbage, albeit for different reasons.

--
__________________________________
HTH

Bob

"RagDyeR" wrote in message
...
All right, I'll bite!<g

What's "gumpf"?
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Bob Phillips" wrote in message
...
Then I would suggest that you think of a few examples that they might use,
such as formatting some tables, looping and deleting based upon a
condition,
and show them how to record macros, then show them how to remove the macro
recorder gumpf.

--
__________________________________
HTH

Bob

"Annie" wrote in message
...
It is an Intermediate Class - they would not have VBA experience so I
have
some examples just looking for more exercises to keep them busy!

Thanks


--
Kind regards

Ann Shaw


"Annie" wrote:

Hi - I am teaching Excel this week and am looking for good examples of
when
to use the following topics in class. Can anyone suggest some sites
where I
might find some good exercises:

Forecasting with Goal Seek and Scenarios including Scenario Merging.
Macros
IF AND OR Formulas
Consolidation

Many thanks

--
Kind regards

Ann Shaw







RagDyeR

Good Examples
 
I took that for granted Bob.

Just figured it actually pertained to something (someone), perhaps in the
UK.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Bob Phillips" wrote in message
...
It's all that spurious stuff that gets inserted into documents and such like
to make the author seem erudite and smarter than us mere plebs. The macro
recorder creates the same unnecessary garbage, albeit for different reasons.

--
__________________________________
HTH

Bob

"RagDyeR" wrote in message
...
All right, I'll bite!<g

What's "gumpf"?
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Bob Phillips" wrote in message
...
Then I would suggest that you think of a few examples that they might use,
such as formatting some tables, looping and deleting based upon a
condition,
and show them how to record macros, then show them how to remove the macro
recorder gumpf.

--
__________________________________
HTH

Bob

"Annie" wrote in message
...
It is an Intermediate Class - they would not have VBA experience so I
have
some examples just looking for more exercises to keep them busy!

Thanks


--
Kind regards

Ann Shaw


"Annie" wrote:

Hi - I am teaching Excel this week and am looking for good examples of
when
to use the following topics in class. Can anyone suggest some sites
where I
might find some good exercises:

Forecasting with Goal Seek and Scenarios including Scenario Merging.
Macros
IF AND OR Formulas
Consolidation

Many thanks

--
Kind regards

Ann Shaw









All times are GMT +1. The time now is 02:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com