Official Softs

Well the USA may be out of the World Cup but that’s not the only international competition going on these days. The Imagine Cup is a (some would say THE) major student technology competition in the world and the international finals are taking place in Warsaw, Poland. And the US is still in that. And represented by some truly outstanding young people from universities and even one high school.Microsoft Office is so great!

 

Team USA, ably headed by  Randy Guthrie (including Tom Zieg

mann our Student Insider) is off to the Worldwide Finals starting, July 3rd to compete, collaborate and celebrate with students from 70 countries to solve the world’s toughest challenges with software- for all the action check: http://www.microsoft.com/presspass/events/imaginecup/.Office 2010 download is available now!

 The 2010 competition started with more than 325,000 high school and university students registering across more than 100 countries and regions. Among this elite group of students, there are 5 outstanding teams from the United States, which The invention of Microsoft Office 2010 is a big change of the world.

ties Taiwan and Brazil with the most teams representing their countries in the finals. Of course a personal favorite of mine is TEAM BEASTWARE who won the Windows Phone 7 “RockOffice 2010 –save your time and save your money.

 

star” award from the US. You have to love a high school team who can hold their own against university students. If that doesn’t give you some hope about the US education system I don’t know what will!Office 2010 key is for you now!

 

Who are Team USA? Here’s an introduction to the teams who will be representing the United States in this final round:1.TEAM MOBILIFE (Software Design) using Windows Phone: Kayvon Microsoft outlook is great!

 

Ghaffari, Wilson To, Helena Xu from University of California, Davis; University of California, Los Angeles; University of California, San DiegoBy using Office 2010 Professional, you can save your money and time.

 

The Mobilife project introduces innovative application technologies into the market of mobile medicine by pairing the widely-available Windows Mobile platform with computer-assisted intravital microscopy to provide on-field analysis of the human microcirculation to detect developing microangiopathy in children using a cellphone. This non-invasive, in-vivo procedure will provide doctors with information on a patient – enough to pre-diagnose different vascular diseases such as type-1 diabetes mellitus, pediatric hypertension, and sickle cell anemia. Mobilife’s technology offers a scientifically-validated approach that cost-effectively provides accurate microcirculatory information to diagnose vascular diseases in children. Windows 7 is convenient and helpful!

 See a video of Team Mobilife’s project on the People’s Choice website.· 2.TEAM VACCINE (Embedded Development): Patricia Day and Shawn McGhee from the University of Arkansas, Little Rock· This project is aimed at helping children around the world. There is a potential to save tens of thousands (or more) children from preventable diseases by providing a mechanism to the World Health Organization, Unicef, Outlook 2010 is powerfull.

Doctors Without Borders, Kenya Partnership, and others to allow for effectively recording/tracking of immunizations in remote regions of least developed and developing countries.3. TEAM ONEVIEW (Touch and Tablet Accessibility): Shaun Kane and Kristen Shinohara from University of Washington OneView is a Tablet PC-based application that enables students with varying abilities to collaboratively create, read, and edit diagrams. OneView provides a synchronized multimodal interface (visual, audio, text) that allows each student to use their preferred interface mode while collaborating with other students with different abilities. OneView enables pairs of students, either blind or sighted, to collaboratively view and edit diagrams. Using a single Tablet PC, a blind student can use an accessible audio interface, while her sighted collaborator uses a visual interface.4.TEAM NOTE-TAKER (Touch and Tablet Accessibility): David Hayden and John Black from Arizona State University

Note-Taker is a portable, custom-designed hardware/software assistive device that improves the accessibility of higher education for students who are legally blind or have reduced vision. The Note-Taker Application allows low-vision users to view streaming video of a classroom presentation while, at the same time, taking notes in a split-screen interface with Microsoft OneNote. Much like their sighted peers, low-vision users can rapidly look between their notes and the board. Whereas fully students glance up or down, low-vision students using the Note-Taker need only move their gaze from one half of the display to the other. The Note-Taker Camera is a custom-designed USB camera that can be precisely pointed to any location where a whiteboard or digital projector might be located in a classroom, relative to the student desk. The camera provides 36x optical zoom and streams video to a tablet PC. Users can control camera positioning and zoom through intuitive tapping, dragging, and multitouch pinching gestures applied directly to the streaming video display. Microsoft outlook 2010 is convenient!

The following is a guest post by Pat Yongpradit. Pat is the computer science teacher at Springbrook High School in Silver Spring, Maryland. His students competed in this year’s Imagine Office 2010 key is for you now!

Cup in the Game division and were one of the top 10 teams in the US. This is pretty impressive when you realize that most of the other teams were from colleges and universities. I asked Pat to write up some information and advice for potential future Imagine Cup teams. His reply is below.Microsoft Office is so great!

 

So you’ve learned XNA, have made a couple cool games, and want to flex your skills on the national and international stage and tackle a social cause as well? Then the Imagine Cup is right for you. The Imagine Cup is an international game and software design competition that encourages students to use the technical skills to address social issues.Office 2010 –save your time and save your money.

 

Do you also enjoy distracting yourself and your peers with impromptu video game challenges, spending 100 plus hours on a project in addition to your homework, and being berated by a mentor for still not having a functioning prototype with one week before the deadline?Windows 7 is convenient and helpful!

 Then the Imagine Cup should be renamed the “Your Name Here” Cup, because it has your name written all over it. (Of course there isn’t The invention of Microsoft Office 2010 is a big change of the world.

actually a physical Imagine Cup like there is a Stanley Cup…that is kind of the reason why they called it the “Imagine” cup.) Assuming you know what the Imagine Cup is, here is some advice, not in order of importance.1.Most importantly, come up with a basic version of your game that you can be satisfied with and build off of, if and when you have extra time. Many teams end up with some code here and there,Microsoft outlook is great!

 but nothing completed that sticks together and resembles a game. 2.Get a good artist. There must be some digital art kids in your school who would jump at the chance to work on a real game. 3.Do not put programming brilliance above sound game design skills. Office 2010 download is available now!

 

Plot. Progression. User Interface. These things are probably more important than a really cool physics effect. 4.Realize that a good project will take dozens and dozens of hours… more time than you will definitely have allotted from the beginning… so plan for the fact that you won’t plan enough time. Outlook 2010 is powerfull.

5.Make small goals with clear deadlines. Delegate the goals. Impose consequences on those that don’t make their deadlines. If they are a scrawny programmer, make them do push-ups. If they are a buff Microsoft outlook 2010 is convenient!

programmer, make them do push-ups with the scrawny one on their back. Just don’t punish anyone by taking the Xbox away, By using Office 2010 Professional, you can save your money and time.

for what will 70 percent of your team meeting time be spent doing? 6.Take the Xbox away. 7.Lastly, and definitely most important of all… take the Xbox away. Now. You can read more about 

Springbrook’s High School Imagine Cup Team at

You’ve heard it said many time that “No one who takes a high school programming course is qualified for a software development job.” Sounds reasonable. But how about people graduating from universities not being qualified? That is the question that shows up in a number of posts and news articles lately. Keith Ward asks the “Over-Educated, Yet Under-Qualified?” question in a recent editorial post in MSDN Magazine. He references an article from InfoWorld Web’s site, “The sad standards of computer-related college degrees”. Is it that bad? Well I hear mixed reviews on recent graduates.Microsoft Office is so great! One VP at a major software company said that it takes an average of a year and a half for a recent college graduate to become a fully productive member of a development team. By using Office 2010 Professional, you can save your money and time. On the other hand I do know high school students who have gotten software development or testing jobs while still in high school. Some of my students were in that category. Outlook 2010 is powerfull. Hélène Martin reports that she has “I’ve got 5 students doing technical internships this summer” as an aside in a great post she has reviewing a Teach SCHEME workshop she is attending. (The post is TeachOffice 2010 –save your time and save your money. Scheme Workshop at Brown University and brings up a lot of important points that are very worth reading and considering. )As usual the truth is really between extremes. Some high school students do get technical internships and some of them even involve programming or at least software testing. Microsoft outlook is great! And some university graduates are not as prepared as many employers would like. Part of the problem though may be expectations. One expects a lot more from a university graduate than from a high school student. Office 2010 download is available now! Entry level positions, rather than just internships, usually want more experience with larger teams and larger projects. A large university project may include 3-5 students working for a couple of months. A small commercial project may involved 20 people working for a year. Vastly different scales.The invention of Microsoft Office 2010 is a big change of the world. I’m not convinced that the problem is a dumbing down of university curriculum though. Windows 7 is convenient and helpful! I don’t think that is happening. Yes many programs are trying to make their programs more interesting by adding robotics or game development and similar creative areas of case study. But they are working hard not to do so in a way that waters down the curriculum. Fun and dumb are not synonyms. Microsoft outlook 2010 is convenient! The XNA Game Curriculum resources that Microsoft has are serious and often complex materials for example. (XNA Resources and Teaching Tools for your Classroom) No I think that the problem is that professional development has gotten more complex at a faster rate than education programs have adapted.Office 2010 key is for you now!

Today’s author is Shane Devenshire, who has been an Excel MVP for many years and who regularly contributes to Excel Newsgroups. He has published over 300 articles in different computer magazines, and co-authored numerous books. Excel might be better today because of the many bugs he posted when he was a Beta tester! This post shows you how to use a formula or custom VBA function to calculate the ISO Start of Year date.Office 2007 professionaland Office 2007 ultimate are so powerfull.

Here is a formula for calculating the ISO Start of Year date for any legal Excel date.

=("1/4/"&YEAR(B2))-MOD("1/2/"&YEAR(B2),7)

.csharpcode, .csharpcode pre { font-size: small; color: black; font-family: consolas, “Courier New”, courier, monospace; background-color: #ffffff; /*white-space: pre;*/ } .csharpcode pre { margin: 0em; } .csharpcode .rem { color: #008000; } .csharpcode .kwrd { color: #0000ff; } .csharpcode .str { color: #006080; } .csharpcode .op { color: #0000c0; } .csharpcode .preproc { color: #cc6633; } .csharpcode .asp { background-color: #ffff00; } .csharpcode .html { color: #800000; } .csharpcode .attr { color: #ff0000; } .csharpcode .alt { background-color: #f4f4f4; width: 100%; margin: 0em; } .csharpcode .lnum { color: #606060; }

This assumes the date you are entering is in B2. With this formula you enter any date in a year and Excel returns the ISO Start of Year date. For example if you enter 9/12/09 in B2 the result of this formula is 12/29/08. Microsoft Office 2007 is powerfull.

You can create a custom user-defined function (UDF) using VBA to perform the same calculation. To do that, open the Visual Basic editor, click Module on the Insert menu, and then copy the following function into the module. After adding this UDF to your workbook, you can use it like a built-in function =ISOYS(B4): 

'Returns Start of Year date (1st Monday) based on an input date
Public Function ISOYS(mydate As Date) As Date
    Dim D as Long

    D = CDate("1/2/" & year(mydate))
    ISOYS = D + 2 - D Mod 7
End Function

.csharpcode, .csharpcode pre { font-size: small; color: black; font-family: consolas, “Courier New”, courier, monospace; background-color: #ffffff; /*white-space: pre;*/ } .csharpcode pre { margin: 0em; } .csharpcode .rem { color: #008000; } .csharpcode .kwrd { color: #0000ff; } .csharpcode .str { color: #006080; } .csharpcode .op { color: #0000c0; } .csharpcode .preproc { color: #cc6633; } .csharpcode .asp { background-color: #ffff00; } .csharpcode .html { color: #800000; } .csharpcode .attr { color: #ff0000; } .csharpcode .alt { background-color: #f4f4f4; width: 100%; margin: 0em; } .csharpcode .lnum { color: #606060; }

For more information on ISO dates, see the Power Tips post: Week Numbers in Excel. Windows 7 Home Premium is perfect.

Today’s author is Jan Karel Pieterse, an Excel MVP. You can find more useful tips from Jan Karel on his website: http://www.jkp-ads.com/. This post informs you about Name Manager, a free utility that helps you manage defined names in your workbooks. Windows 7 Home Premium is perfect.

If you need a free utility to manage defined names in your workbooks, this one is a must-have. List all names in your active workbook. Filter them using 13 filters including “With external references,” “With errors,” “Hidden,” and “Visible.” Show only names that contain a substring. Show only names unused in worksheet cells. Edit them in a simple dialog box or edit them in a list and update all names at once. Supports the 2007 Office system. QuickBooks 2010 is so Helpful!

To download Name Manager, visit www.jkp-ads.com/officemarketplacenm-en.asp.

For information about how to define names, see Define and use names in formulas. Photoshop CS4 is so magic!

Excel Services does a good job of rendering Excel spreadsheets with a high degree of fidelity.  In other words, what you see in Excel is what you will see in Excel Services.  Excel, however, is incredibly feature rich, comprising features added over decades of development. Many people use Microsoft Office 2007 to help their work and life. By comparison, Excel Services is a young product, so naturally Excel Services doesn’t yet support all the things you might create in Excel.  So what does Excel Services in SharePoint 2010 support?  And how does Excel Services deal with files that contain features it doesn’t support?  That is the topic of today’s blog post.MS Office 2007 Professional is such a good assistant of the office.

I am going to assume readers are aware of our feature support in Excel Services 2007.  If you need a refresher, read our original blog topic on the matter.  The following sections build on top of this topic.

Support For New Excel 2010 Features

Hopefully by now you’ve heard about some of the great features in Excel 2010 (If not, read through our posts here).  By and large, most of the new features you’ll hear talked about for Excel 2010 will work in some way in Excel Services.  Some features will display as they do in Excel.  Others are also interactive.Office 2007 Pro is great! Many people like it!

• Sparklines can be viewed
• Icon Set and Data Bar improvements can be viewed
• The new functions are supported
• Slicers can be viewed and interacted with
• PivotTable Named Sets can be viewed
• Other PivotTable improvements can be viewed
• PowerPivot files can be viewed and interacted with

In addition to this, I am happy to announce that embedded images, a long time feature of Excel, are now supported and can be viewed in Excel Services.  Here’s an example of a report with an embedded image:

Improved Handling of Unsupported Features

In Excel Services 2007, if a file contained an unsupported feature, Excel Services would not be able to open the file at all.  Ms office 2007 is so Charismatic.This was a frustrating point for customers, as the unsupported feature was often something that the customer didn’t care about in the context of rendering in Excel Services.  For example, a workbook may have a cell comment, which is unsupported, on Sheet3, but the workbook, when rendered via Excel Services, was only meant to show the chart on Sheet1.  In this scenario, the only recourse for the customer was to remove the unsupported feature.Office 2007 professionaland Office 2007 ultimate are so powerfull.

In the SharePoint 2010 release of Excel Services, a lot of work went into bringing support for new features as well the other investment areas that were discussed in the Excel Services overview post.  With every release we narrow the functionality gap between Excel and Excel Services and reduce the number of unsupported features, but even in this new release, unsupported features still exist.  To help users work with this limitation, Excel Services will simply “ignore” certain unsupported features.  In other words, rather than blocking the entire file from loading, Excel Services will load the file just fine, you just won’t see the features that Excel Services doesn’t support. Microsoft Office 2007 is powerfull.

So which features fall into this bucket?  Here are the features that will not prevent Excel Services from loading a file:

• Cell comments
• Formula references to external books
• Query Tables (also known as external data ranges)
• VBA
• Anything using OfficeArt technology, such as Shapes, WordArt, SmartArt, Org Chart, Diagrams, Signature Lines, Ink Annotations, etc.

A couple notes about the above list.  These features continue to be unsupported, so that means they don’t render, execute, or work in any way like they do on the client.  Most of the features in the above list will not render at all in Excel Services. IS Windows 7 Professional better than Windows 7 Ultimate ? For example, if there’s a shape near cell A1 when viewed in the client, you will see no shape at all when viewed on the server.  Other features, like formula references and query tables, show you values that were last refreshed in the client.  In other words, the values in the cells are still there, but you cannot update them in any way.  Lastly, VBA code will not execute on the server.Windows 7 Home Premium is perfect.

One additional note about VBA.  Excel Services 2007 didn’t support loading *.xlsm files at all because such files are meant to contain macros and files with macros would not load.  Now that the SharePoint 2010 version of Excel Services knows how to ignore VBA macros, I am happy to say that also means *.xlsm files can now be loaded in Excel Services. QuickBooks 2010 is so Helpful!

Viewing a File with Ignored Unsupported Features

You may be wondering, if Excel Services will load files and not render certain unsupported features, how do I know if the file I’m viewing is missing features?  Excel Services will display a notification above the sheet that the file has missing features.Photoshop CS4 is so magic!

This is your first clue that the file is rendering different than Excel.  If you’d like to learn more about which unsupported features Excel Services found in the file, click the “Details…” button.Acrobat 9 is so useful!

What About Other Unsupported Features?

All other unsupported features will continue to behave as they do in Excel Services 2007.  That is, Excel Services will block loading of the file if it detects the existence of one of these features.Dreamweaver CS4 is very easy-to-use!

This help topic for the 2007 release covers the detailed list (just ignore any mention of images, as I already mentioned those are now supported).

Summary

I hope that the changes we’ve made to how we handle unsupported features will alleviate many of the pain points our customers experience when rendering spreadsheet files with Excel Services.  I would love to hear your feedback about the work we’ve done, as well as any thoughts you have on which unsupported features you’d like to see supported in a future release.

Skip to minute 6 in this video

http://blogs.msdn.com/danielfe/archive/2008/02/12/the-bill-gates-interview.aspx.

Office 2007 professionaland Office 2007 ultimate are so powerfull.

Access, of course, has been phenomenally successful, but you think of it as just client forms and client data. Now [with Access] 2007, they did a great job where you could replicate from SharePoint down to Access lists back and forth, but that still didn’t let you run your logic up on the server. So the next step is to take that base of Access users and literally let them write things that connect directly up to SharePoint and so it’s server-based. So it’s a logical step for Access. There’s a lot of smart people working on that, so in no sense are we leaving the Access people behind. IS Windows 7 Professional better than Windows 7 Ultimate ? The same way we moved Excel up to the server, now we’re moving Access up there as well.

Sorry—I won’t be able to comment more about our plans but it is always fun to have Bill talk about your work.

Mike Hnatt at Gladstone Solutions has a nifty Report Writer utility, available at http://gladstonesolutions.com/default.aspx. The utility lets you create reports and mailing labels quickly and easily, just by stepping through a few wizard-like screens. Ms office 2007 is so Charismatic.

What’s more, Mike is offering a 25% discount through August 31, 2009 for blog readers. When ordering, just type Access Team Blog in the Please tell us how you found out about us box on the order form. Microsoft Office 2007 is powerfull.

This is guest post from Allie Rutherford a summer college intern on the Access team.Ms office 2007 are so Charismatic.Do you own your own business or are you in a position where you have to keep track of your customer relationships and sales leads? Have you ever wished your CRM or sales software was a little bit different or easier to use?

Today, I am posting to ask the users what they expect and desire from Customer Relationship Management software. We are currently doing research into how businesses and small companies track their leads and customers. Your input is invaluable to us and will greatly aid our research into this topic! Office 2007 professionaland Office 2007 ultimate are my favorite.To help facilitate convers ation on this topic, we have created a rough prototype database in Access of a streamlined CRM system. Here’s a link for you to try it out:

Some questions for you all:

- What system do you currently use?

- Are you satisfied with your current system?

- What makes it better than other systems you have tried?

- Does our prototype meet your expectations of a simple CRM system?

- How could our prototype be improved? Are there any features you wish were included or are especially important to you and your business? 

QuickBooks 2010 is so Helpful! You can respond in the comments or directly to us via the contact page.

Thanks everyone!

Allie