DavidOverton.com
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.  
David Overton's Blog » All Tags » Excel (RSS)

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...

  • Simple Office / Excel information to share with customers

    This is a fab tool - for example, the page has: Inside Microsoft Office Excel 2007 Stop the Press -Microsoft Office Excel 2007 - making working with numbers easier than ever! Where minutes are kept and hours are wasted Well-planned and organised meetings can be very useful. However, not all meetings leave attendees feeling like their time has been well spent! ttfn David Technorati Tags: Excel , Tips

  • 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...

  • Iris World information

    We did promise at IrisWorld that all the information from the event would be available on the website. It is almost all ready. See below for information that is available now and subscribe to this entry to be notified when the video is available for download too. If you click the link here you should see a section like this and if you put in your e-mail address you will get a mail when this is updated. The e-mail address will not be used to contact you in any other way or passed on to anyone else. Excel Demos and Links: http://office.microsoft.com/en-us/training/CR100479681033.aspx - Training http://office.microsoft.com/en-us/excel/CH100740791033.aspx - Demos Office Live Choices for Office Live range from free to less than £23 per month for 50 users Setting up websites is very simple and can be free - click the picture at the top of the page to sign up Sharing information with your customers can be simple - click the picture at the top of the page to sign up for the "Workspaces Beta" http://www.officelive...

  • Fix for Excel 2007 and Excel Services calculation errors

    I know that a few people had the pleasure of throwing a few pies at Microsoft when this was discovered, but a fix is now available. Description of the Excel 2007 hotfix package: October 9, 2007 This hotfix package fixes the following issue that was not previously documented in a Microsoft Knowledge Base article: When you perform a calculation in Excel 2007, the following behavior occurs: The result of the calculation is a number from 65534.99999999995 to 65535. The calculation is performed correctly. However, the result is incorrectly shown as 100000. The result of the calculation is a number from 65535.99999999995 to 65536. The calculation is performed correctly. However, the result is incorrectly shown as 100001. To resolve this problem, apply this hotfix. After you apply the hotfix, recalculate the spreadsheets that are in manual calculation mode. When you do this, the values in the spreadsheet will be updated to the correct values. Excel 2007 Download the Excel 2007 hotfix package now. ( http://download.microsoft...
    Filed under: ,

  • 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...

  • Job aids (things to help you do your job) with Microsoft Office 2007

    2007 Microsoft Office System Be productive while using the new versions of Microsoft Office desktop applications. · Microsoft Office Fluent User Interface Get Started · Microsoft Office Charts and SmartArt Get Started · Microsoft Office Styles Get Started · Microsoft Office Tasks Get Started · Microsoft Office Tasks Learn More Everyday Work Discover best practices for working with e-mail, organizing your time, and more. · Windows Vista and Microsoft Office Work Smarter Checklist · InfoPath 2007 Forms Get Started E-mail · E-Mail Basics Get Started · Outlook 2007 E-Mail Signatures Get Started · Outlook 2007 E-Mail Rules Get Started · Outlook 2007 Out of Office Assistant · Delegating Outlook 2007 Access Learn More · Outlook 2007 and SharePoint Server 2007 Integration Overview · Outlook 2007 and SharePoint Server 2007 Integration Get Started · RSS (Really Simple Syndication) Overview · Subscribing to Web Content with RSS Time and Task Management · Microsoft Office Tasks Get Started · Microsoft Office Tasks Learn More...

  • 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-23