List Info

Thread: Re: New Excel features 2007




Re: New Excel features 2007
user name
2007-01-29 13:40:53
Vista and Office 2007 are currently the lead story on
MSNBC:

http://www.msnb
c.msn.com/id/16829423/

Doug Smith
www.abundant-solutions.com


--- Bob Umlas <bobumlasYAHOO.COM> wrote:

> By the way, there is no new MAXIF command. 5 new ones
only:
> IFERROR
> SUMIFS
> AVERAGEIF
> AVERAGEIFS
> COUNTIFS
> 
> Hey, Allan -- congrats on your MVP status! Going to the
Summit?
> 
> 
> Bob Umlas, Excel MVP
> 
> 
> 
> ----- Original Message ----
> From: Allan Fromm <allan.fPIPELINE.COM>
> To: EXCEL-GPEACH.EASE.LSOFT.COM
> Sent: Sunday, January 28, 2007 9:37:03 AM
> Subject: Re: New Excel features 2007
> 
> 
> This will sure save a lot of work arounds...
> 
> <<
> SUMIFS/COUNTIFS - multiple condition SUMIF/COUNTIF
> >>
> 
> Allan Fromm
> Green Bay, WI
> 
> 
> -----Original Message-----
> From: MS Excel General Q & A List
[mailto:EXCEL-GPEACH.EASE.LSOFT.COM] On
> Behalf Of Bob Phillips
> Sent: Sunday, January 28, 2007 4:47 AM
> To: EXCEL-GPEACH.EASE.LSOFT.COM
> Subject: Re: New Excel features 2007
> 
> There are a few.
> 
> IFERROR - to help with checking if a function returns
an error
> (=IFERROR(VLOOKUP(...),""))
> 
> SUMIFS/COUNTIFS - multiple condition SUMIF/COUNTIF
> 
> AVERAGEIF, MAXIF and so on.
> 
> The charting engine has been rebuilt, unlimited
colours, 64 nested
> functions, unlimited conditional formats, etc .
> 
> Read about it at ht
tp://blogs.msdn.com/jensenh/archive/2005/10.aspx
> 
> -----Original Message-----
> From: MS Excel General Q & A List
[mailto:EXCEL-GPEACH.EASE.LSOFT.COM]
> On Behalf Of Joe Hecht
> Sent: Saturday, 27 January 2007 20:40
> To: EXCEL-GPEACH.EASE.LSOFT.COM
> Subject: New Excel features 2007
> 
> 
> I know excel has more rows, columns and format options
as well as the
> ribbon.
> 
> 
> 
> Are there new functions (vlookup, current value) that
kind of thing in
> 2007?
> 
> 
> 
> Thanks
> 
> 
> 
> Joe Hecht
> 
> jmhechtearthlink.net
> 
> 
> 
> 
>
------------------------------------------------------------
------------
> --
> The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
> international's LISTSERV(R) software.  For
subscription/signoff info and
> archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
>                              COPYRIGHT INFO:
> http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
> 
> -- 
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.432 / Virus Database: 268.17.12/654 -
Release Date:
> 27/01/2007 17:02
> 
> 
> -- 
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.5.432 / Virus Database: 268.17.12/654 -
Release Date:
> 27/01/2007 17:02
> 
> 
>
------------------------------------------------------------
--------------
> The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
> international's LISTSERV(R) software.  For
subscription/signoff info
> and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
>                              COPYRIGHT INFO:
> http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
> 
>
------------------------------------------------------------
--------------
> The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
> international's LISTSERV(R) software.  For
subscription/signoff info
> and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
>                              COPYRIGHT INFO:
> http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
> 
> 
>  
>
____________________________________________________________
________________________
> Have a burning question?  
> Go to www.Answers.yahoo.com and get answers from real
people who know.
> 
>
------------------------------------------------------------
--------------
> The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
> international's LISTSERV(R) software.  For
subscription/signoff info
> and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
>                              COPYRIGHT INFO:
> http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
> 

------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software.  For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G

Re: New Excel features 2007
user name
2007-01-29 13:56:22
wonder why... M$NBC?....nahhhh.... LOL 

-----Original Message-----
From: MS Excel General Q & A List [mailto:EXCEL-GPEACH.EASE.LSOFT.COM]
On Behalf Of Douglas Smith
Sent: Monday, January 29, 2007 1:41 PM
To: EXCEL-GPEACH.EASE.LSOFT.COM
Subject: Re: New Excel features 2007

Vista and Office 2007 are currently the lead story on
MSNBC:

http://www.msnb
c.msn.com/id/16829423/

Doug Smith
www.abundant-solutions.com


--- Bob Umlas <bobumlasYAHOO.COM> wrote:

> By the way, there is no new MAXIF command. 5 new ones
only:
> IFERROR
> SUMIFS
> AVERAGEIF
> AVERAGEIFS
> COUNTIFS
> 
> Hey, Allan -- congrats on your MVP status! Going to the
Summit?
> 
> 
> Bob Umlas, Excel MVP
> 
> 
> 
> ----- Original Message ----
> From: Allan Fromm <allan.fPIPELINE.COM>
> To: EXCEL-GPEACH.EASE.LSOFT.COM
> Sent: Sunday, January 28, 2007 9:37:03 AM
> Subject: Re: New Excel features 2007
> 
> 
> This will sure save a lot of work arounds...
> 
> <<
> SUMIFS/COUNTIFS - multiple condition SUMIF/COUNTIF
> >>
> 
> Allan Fromm
> Green Bay, WI
> 
> 
> -----Original Message-----
> From: MS Excel General Q & A List 
> [mailto:EXCEL-GPEACH.EASE.LSOFT.COM] On Behalf Of Bob
Phillips
> Sent: Sunday, January 28, 2007 4:47 AM
> To: EXCEL-GPEACH.EASE.LSOFT.COM
> Subject: Re: New Excel features 2007
> 
> There are a few.
> 
> IFERROR - to help with checking if a function returns
an error
> (=IFERROR(VLOOKUP(...),""))
> 
> SUMIFS/COUNTIFS - multiple condition SUMIF/COUNTIF
> 
> AVERAGEIF, MAXIF and so on.
> 
> The charting engine has been rebuilt, unlimited
colours, 64 nested 
> functions, unlimited conditional formats, etc .
> 
> Read about it at ht
tp://blogs.msdn.com/jensenh/archive/2005/10.aspx
> 
> -----Original Message-----
> From: MS Excel General Q & A List 
> [mailto:EXCEL-GPEACH.EASE.LSOFT.COM]
> On Behalf Of Joe Hecht
> Sent: Saturday, 27 January 2007 20:40
> To: EXCEL-GPEACH.EASE.LSOFT.COM
> Subject: New Excel features 2007
> 
> 
> I know excel has more rows, columns and format options
as well as the 
> ribbon.
> 
> 
> 
> Are there new functions (vlookup, current value) that
kind of thing in

> 2007?
> 
> 
> 
> Thanks
> 
> 
> 
> Joe Hecht
> 
> jmhechtearthlink.net
> 
> 
> 
> 
>
------------------------------------------------------------
----------
> --
> --
> The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft 
> international's LISTSERV(R) software.  For
subscription/signoff info 
> and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
>                              COPYRIGHT INFO:
> http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
> 
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.432 / Virus Database: 268.17.12/654 -
Release Date:
> 27/01/2007 17:02
> 
> 
> --
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.5.432 / Virus Database: 268.17.12/654 -
Release Date:
> 27/01/2007 17:02
> 
> 
>
------------------------------------------------------------
----------
> ---- The EXCEL-G list is hosted on a Windows NT(TM)
machine running 
> L-Soft international's LISTSERV(R) software.  For
subscription/signoff

> info and archives, see 
> htt
p://peach.ease.lsoft.com/archives/excel-g.html .
>                              COPYRIGHT INFO:
> http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
> 
>
------------------------------------------------------------
----------
> ---- The EXCEL-G list is hosted on a Windows NT(TM)
machine running 
> L-Soft international's LISTSERV(R) software.  For
subscription/signoff

> info and archives, see 
> htt
p://peach.ease.lsoft.com/archives/excel-g.html .
>                              COPYRIGHT INFO:
> http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
> 
> 
>  
>
____________________________________________________________
____________
____________
> Have a burning question?  
> Go to www.Answers.yahoo.com and get answers from real
people who know.
> 
>
------------------------------------------------------------
----------
> ---- The EXCEL-G list is hosted on a Windows NT(TM)
machine running 
> L-Soft international's LISTSERV(R) software.  For
subscription/signoff

> info and archives, see 
> htt
p://peach.ease.lsoft.com/archives/excel-g.html .
>                              COPYRIGHT INFO:
> http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
> 

------------------------------------------------------------
------------
--
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software.  For
subscription/signoff info and
archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G

------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software.  For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G

[1-2]

about | contact  Other archives ( Real Estate discussion Medical topics )