David Overton's Blog and Discussion Site
This site is my way to share my views and general business and IT information with you about Microsoft, IT solutions for ISVs, technologists and businesses, large and small.  

Browse by Tags

  • How to find ANY command on the new Office Ribbon – Search for it with Search Commands

    There is a great web site out from Microsoft called OfficeLabs and one of the 1st great things published is: Project: Search Commands  Search Commands helps you find commands, options, wizards, and galleries in Microsoft Office 2007 Word, Excel and PowerPoint. Just type what you’re looking for in your own words and click the command you need. Search Commands also includes Guided Help, which acts as a tour guide for specific tasks. Crave more info? FAQ - get answers to frequently asked questions Blog - read the latest news from the team Discussions - connect with other users  Click here to download. Requirements: 32 bit Windows XP or Windows Vista. Office 2007. Limitations: English only. Works with Word, Excel and PowerPoint only. Give it a try!! ttfn David Technorati Tags: Microsoft , Word 2007 , Excel 2007 , Office 2007 , Search , Ribbon , find , If you only read one post today
  • Microsoft Gets Gartner's Business Intelligence Top Ranking -- Business Intelligence

    Remember that BI starts with data in Excel and then includes SQL and builds from there. One of the nice things is that BI is now accessible to any business that wants to analyse their business. Now all that is needed is the understanding of what questions do I want to ask and what data do I have that can help me!! Microsoft Gets Gartner's Business Intelligence Top Ranking The company makes a surprise leap ahead of Business Objects and Cognos in its ability to execute on BI products and pricing. Business Objects and Cognos have long been considered the leaders in business intelligence platforms. But in a surprising new report, Gartner ranks Microsoft ahead of those companies in its ability to execute. Gartner's "magic quadrants" are typically annual market evaluations that place software vendors in one of four quadrants within a square: niche players, visionaries, challengers, and leaders. Specific placement within a quadrant depends on a vendor's ability to execute, which moves them upward...
  • Office 2007 SP1 is here and it does more than just update the desktop - SharePoint gets AJAX for example

    I'm sure you have heard that the Office 2007 Service Pack is here. Darren Strange has documented what is in it and how to get it at Office 2007 sp1 ready for download today and OfficeRocker! : More detail about sp1 . In answer to Susanne's post at here , hopefully this post has some more info in it One of the little things he puts that I like is: Some other factoids about sp1 There are roughly 2500 fixes in SP1. This an average size for a service pack, but the issues fixed are very important to our customers. Almost 20% of those fixes are direct result of customer requests. Over 500 of those fixes focused on security. There are a total of 24 different releases in 38 languages. There are 683 distinct packages. All have released simultaneously today. If you get the whitepaper then you would be keen to see the information below. Notice that SharePoint amongst other things a developer update to support Ajax and that other server products (Groove and Project Server) are also updated. Stability Microsoft continues...
  • Finding out where something is in Office 2007 and where it was in Office 2003 (Outlook, Word, Excel, PowerPoint and Access)

    I saw this recently and thought I had to blog it - if you know something was there in Office 2003 and now can't find it in Office 2007 then look at these spreadsheets to get some advice. The 1st set of links (ms-help:) will work on a machine with Office 2007 installed and the 2nd set pull the data from the Microsoft Office web site. From the installed help files Outlook ms-help://MS.RIBBON.12.1033/RIBBON/outlookmap.xls Word ms-help://MS.RIBBON.12.1033/RIBBON/wordmap.xls Excel ms-help://MS.RIBBON.12.1033/RIBBON/excelmap.xls PowerPoint ms-help://MS.RIBBON.12.1033/RIBBON/powerpointmap.xls Access ms-help://MS.RIBBON.12.1033/RIBBON/accessmap.xls From the Internet Outlook http://office.microsoft.com/search/redir.aspx?AssetID=AM101954661033&CTT=5&Origin=HA101934281033 Word http://office.microsoft.com/search/redir.aspx?AssetID=AM101938681033&CTT=5&Origin=HA100625841033 Excel http://office.microsoft.com/search/redir.aspx?AssetID=AM101864291033&CTT=5&Origin=HA100860481033 PowerPoint http://office...
  • Show Classic Menus and Toolbars on Ribbon of Office 2007 - two product choices

    I saw a blog entry at Susan Bradley's blog about her now deploying Office 2007 with a classic menu . It was worth of a blog link for all those who want to stick to the old, old ways where you search for items over multiple menus (especially if you turn on personalised menus which hide all the things you don't use regularly). The tool looks slick, but then I found a 2nd one are realised that some cunning ISVs had seen this as their great opportunity to fill a gap that is very unlikely to be filled by Microsoft. The Two solutions are shown below and can be linked to from pschmid.net - RibbonCustomizer™ Feature Tour - Part 3: Classic UI Tabs and Show Classic Menus and Toolbars on Ribbon of Office 2007 : V1.1 Feature Tour - Part 3: Classic UI Tabs RibbonCustomizer™ V1.1 ships with a set of Classic UI tabs for Excel, PowerPoint and Word 2007. Those tabs emulate the Office 2003 menus and toolbars in Office 2007. We provide these tabs to help you familiarize yourself faster with the new Ribbon User Interface...
  • Why should a small business use Office 2007

    Once again I thought I would put pen to e-paper on the top reasons I give people to move to Office 2007. I don't think there are many businesses out there that use a PC and don't use some form of office productivity suite and while most use Microsoft Office XX (where XX could be 97, 2000, XP or 2003), some use other products that in my opinion just don't compare for a business that wants to look great and work efficiently. With Office offering a massive choice of products and features, these are the headlines I use when talking to people. For those with a version of Microsoft Office, but not 2007 More Professional and Impressive documents and materials Use Microsoft Publisher 2007 to build sales and marketing materials that look agency made, but are actually in-house work The updated Microsoft Word 2007 has many features to ensure your documents have a professional, consistent look and feel throughout the whole document conforming to your brand goals (no matter how big or small they might be). The...
  • How to find and use an Accounting template to use with Office Excel 2007 and then change it from US to UK currency, change the formatting of dates and drag lists (or Excel Tips and Tricks 1) - all in a Video presented with Silverlight

    The Video I have delivered a number of Vista and Office demos over my time, so I decided to record a number of them for others to borrow, use, learn from or anything else they choose. This video covers the following subjects in enough detail for people to hopefully understand what they need to know on how to use these features in Excel 2007 and apply them to all of the Office 2007 applications: Find a template and use it - I use an accounting template as it is based on Office 2003 and US based Change the currency cells from dollars to pounds using find and replace for formatting Change the date formatting from US to UK Dragging a list across a range of cells to give column a different month To see the Excel 2007 Video played using Silverlight (just try it) click here *. If you want to download it as a WMV file then head over to the new bCentral - the UK Small Business Center on MS.com - It is on this page as an Excel Accounting sample: * it will take a few moments to open if you have Silverlight installed and...
  • Which 2007 Office Application Are You?

    I did this " Which 2007 Office Application Are You? " and apparently I am Excel You are Excel 2007! People trust you to find the right answer. They call you "the wizard" and are in awe of your PivotTable. When you say you love functions, it's understood that you're referring to spreadsheets, not social events. You import and export with ease, always maintaining balance. Thanks to your mastery of numbers, people are constantly asking you for help with their own budgets. With the new Microsoft Office Excel 2007, you'll see how those people can get their own answers - better and faster. They will be amazed that they, too, can create a new chart with only five clicks. You may not have been known as a trendsetter, but your ability to use conditional formatting to "see" new trends was well worth any wait. You can analyze the impressive productivity and efficiency gains in Excel 2007 and prove that the benefits justify the costs. Your favorite new feature in Office 2007 is likely...
  • How to open Office 2007 (Word, Excel, and PowerPoint 2007) files on Office 2000, Office XP and Office 2003 by downloading the Microsoft Office Compatibility Pack for File Formats

    I get asked this question quite often, so I thought I would point out the download location for the tool to make files work between Office 2000, XP, 2003 and 2007. Just to cover off some details - Office 2007 can save in Office 97-2003 file format as well as the new Open XML and PDF file formats. Using this download, files can be opened and saved in Office 2007 format in Office 2000 and later. Of special note is that if you are using Microsoft Office XP or 2003 you MUST install all High-Priority updates from Microsoft Update before downloading the Compatibility Pack . Also, if you don't have those Office programs, but you have the viewers (Microsoft Office Word Viewer 2003, Excel Viewer 2003, and PowerPoint Viewer 2003) then you can use the pack to view files saved in these new formats. For more information about the Compatibility Pack, see Knowledge Base article 924074 . Also Note: If you use Microsoft Word 2000 or Microsoft Word 2002 to read or write documents containing complex scripts, please see http://support...
  • Help to make the Office 2007 document type a standard (Open XML) - click the link

    I love standards - they make life easier. TCP is one, ODF is one, SNA is one, ASCII and EBDIC are. Even PDF is one. It just makes life easier. In this connected world standards are a good thing and sometimes more than one standard is very good. Microsoft has offered the Open XML (Office 2007 document format) as a standard too. We can have it as a standard in a short time frame or a long time frame. I want you to sign the petition to help it happen in the short time frame. Even Novell are supporting this as they see it as just making their customers lives easier. Go here and sign the petition to help move things forward in the short time frame. If you want to see how developers could use the standard have a look at http://openxmldeveloper.org/posts.aspx . You might wonder why I am asking you to do this. Well I've read the text at the microsoft.com site on Open XML and I like the idea of this being a public standard that people can write to without having to pay for the right to do so and the knowledge that...
  • Microsoft Office Small Business 2007 60 day trial (download)

    Microsoft Office system - Office Small Business 2007 English 60 Day trial (Not to US - [ed - makes a change for it to be excluding US rather than only US]) (download it) Source: Microsoft Office Online Technorati tags: Office 2007 , Office Small Business , Office Live , Trial
  • Office 2007 training for Word, Excel, PowerPoint, Outlook, Office, Access

    This is the download your own stuff: http://office.microsoft.com/en-us/templates/CT102036981033.aspx - currently 18 slide decks here Training presentation: Outlook 2007—Create great-looking signatures for your e-mail Rating: (16 votes) Training presentation: Microsoft Office—Get up to speed with the 2007 system Rating: (85 votes) Training presentation: PowerPoint 2007—Get up to speed Rating: (101 votes) Training presentation: Outlook 2007—Get out of your Inbox Rating: (21 votes) Training presentation: Microsoft Office—Keyboard shortcuts in the 2007 system Rating: (6 votes) Training presentation: PowerPoint 2007—Create your first presentation Rating: (81 votes) Training presentation: Access 2007—Get up to speed Rating: (17 votes) Training presentation: Word 2007—Get up to speed Rating: (55 votes) Training presentation: PowerPoint 2007—Get visual with SmartArt graphics New! Rating: (7 votes) Training presentation: Outlook 2007—Calendar basics Rating: (49 votes) Training presentation: Excel 2007—Create a chart Rating...

(c)David Overton 2006-18