On BNET: 3 worst things about the iPhone 3G S
114 Resources for

microsoft excel 2007

  • Subscribe to this listing via:
  • RSS
  • Email
Did you mean Microsoft Excel 2007 (114 results)

TechRepublic Resources

Save effort by defining names for Excel 2007 formulas
Simplify things for your Excel users: Name the formulas they'll need to use. That way, they won't have to create the formulas for themselves. by Mary Ann Richardson
Tags: Formula, Microsoft Excel 2007, Microsoft Excel, Microsoft Office, Office Suites, Software, Mary Ann Richardson
Blog posts 2008-08-04
Create a custom header for your Excel 2007 worksheets
Adding headers to Excel 2007 worksheets differs significantly from earlier releases. Instead of working with a separate Page Setup dialog, Excel 2007 lets you work with the header directly on the worksheet in Page Layout view. For example, to create a header with the title, "2007 Profit & Loss Statement"...
Tags: Microsoft Excel 2007, Microsoft Excel, Microsoft Office, Office Suites, Software, Mary Ann Richardson
Blog posts 2008-03-18
Use pictures to highlight data points in an Excel 2007 chart
Excel 2007 lets you highlight a particular data point in a chart simply by pasting a picture on the data point. For example, suppose you want to highlight the support center with the highest ranking to date. After you create a line chart that charts each center and its corresponding...
Tags: Chart, Customer Satisfaction, Microsoft Excel 2007, Microsoft Excel, Microsoft Office, Product Marketing, Office Suites, Software, Marketing, Mary Ann Richardson
Blog posts 2008-01-15
Use WordArt formatting in Excel 2007 charts
Excel 2007 lets you apply the same Text Fill, Text Outline, and Text Effects formats available for your WordArt objects to chart text. For example, you can use WordArt formatting to create an eye-catching title for your chart. Follow these steps: Select ...
Tags: Microsoft Excel 2007, Microsoft Excel, Microsoft Office, Office Suites, Software, Mary Ann Richardson
Blog posts 2007-12-20
Excel 2007 corrupts data during sort
We're seeing an issue in Excel 2007 related to sorting data using the sort within an auto filter. Excel behaves differently if you run the sort from the filter drop-down or if you run it from the Ribbon. From the Ribbon, the sort function works every time for...
Tags: Microsoft Office, royalmooness@..., Microsoft Excel, Microsoft Excel 2007
Discussion threads 2007-11-11
Excel 2007
I am not a tech guy, but I understand enough to be dangerous. I have been working with some excel workbooks and saving to 2003 format for a client. Now, when I try to click on the file, excel opens in only a blue screen, with no real commands other...
Tags: Microsoft Office, cpa2@..., Microsoft Excel 2007, Microsoft Excel
Discussion threads 2007-11-06
Writing a Macro in Excel 2007
Would like to edit data below so that the first $ sign is removed from the formula in the first cell, then moving to right it is removed in the 2nd cell, etc. When the end of the first row is reached, the macro should drop down to the next...
Tags: Microsoft Office, Programming languages, AMS@..., Microsoft Excel 2007, Col, Microsoft Excel
Discussion threads 2007-10-25
Converting from Excel 2003 to Excel 2007
I have a complicated, multi-tabbed financial model that uses a variety of functions. In version 2003, no problem. The conversion to 2007: calculations = 0. The first problem: =SUMIF(Exp_ID_Lookup,CONCATENATE(A6,A11),Expense_Lookup)Both named ranges are correct. I did an Evaluate Formula, and the CONCATENATE does the correct appending, but still 0 is the...
Tags: Microsoft Office, brifd@..., Microsoft Excel, Microsoft Excel 2007, Microsoft Excel 2003
Discussion threads 2007-10-24
Looking for a Excel 2007 / VBA consultant near Baltimore MD
Does anyone have contact info for above consultant type. Currently have a need for quick VBA / Excel application effort. Could lead to additional consulting on a variety of efforts.Thanks
Tags: Scripting languages, Microsoft Office, ssutay@..., Microsoft VBA, Microsoft Excel, Microsoft Excel 2007
Discussion threads 2007-10-23
excel 2007 has Microsoft really fixed the bug?
If you are following the Excel 2007 Bug issue, you might think it was fixed. I say think again.It you were to start a fresh worksheet and do the simple equation of 77.1 * 850, yes now you do get 65535, not the dreaded 100000 as before installing the patch....
Tags: Microsoft Office, hosford@..., Microsoft Corp., Microsoft Excel 2007
Discussion threads 2007-10-20
Excel 2007 and IE7
Why won't IE7 recognize my links to Excel 2007 files? Is there a workaround (other than saving as an Excel 2003 file)?
Tags: Microsoft Office, Webguy007, Microsoft Excel, Microsoft Excel 2007, Microsoft Internet Explorer 7
Discussion threads 2007-10-15
Excel 2007 Slows Spreadsheet Navigation
Several of my users share an Excel workbook. Up until a couple of weeks ago, they all had Office 2000. Then, one was upgraded to Office 2007. Ever since that user opened and saved the workbook (in 2000-2003 format) the navigation and scrolling, etc., one of the...
Tags: Microsoft Office, spreadsheet, bds1959@..., Microsoft Excel, Microsoft Excel 2007
Discussion threads 2007-10-05
Excel 2007 Macros in Excel 2003?
Hello All,Recently upgraded our office here to Office 2007. We collaborate with different offices/businesses -some of which still use 2003. Some users here use Excel macros -will a macro created in Excel 2007 work in Excel 2003? (In other words if the macro is imported into the...
Tags: Microsoft Office, monseratef@..., Microsoft Excel, Microsoft Excel 2007, Microsoft Excel 2003
Discussion threads 2007-10-04
Excel 2007 -- Internal Hyperlink AutoUpdate
Hello,Currently, I am using Microsoft Excel with a small menu at the top of the window. This little menu simply points to various bookmarks range names I have setup for the spreadsheet I have created. This is what I want to do:Create a macro that asks for the...
Tags: PRODUCTIVITY, oldoak@..., Microsoft Excel 2007, spreadsheet, Microsoft Excel
Discussion threads 2007-10-02
Change Check Box Value in Excel 2007
Hi,I have a very complex excel workbook and I need to create a user friendly front page with check boxes.the output value is true or false where the rest of my workbook use 1 or 0is there a way to change the output?
Tags: Microsoft Office, troy@..., Microsoft Excel 2007, Microsoft Excel
Discussion threads 2007-10-02
Tip: Excel 2007 has interesting bug
Thanks to John Bartow for sending a link to Excel Can't Multiply.  I tried it, and it's true. Be sure to read the first response because he share some interesting insight. I can't add anything to the article. I found that adding 1 to the result, =850*77.1 +1,...
Tags: Expression, Microsoft Excel 2007, Microsoft Excel, Microsoft Office, Office Suites, Software, Susan Harkins
Blog posts 2007-09-28
Tip: Excel 2007 has interesting bug
Excel 2007 can't displayThe problem has been extensively discussed in the blogosphere. It turns out it is a display problem, not an arithmetic problem. It is detailed here:blogs.msdn.com/excel/archive/2007/09/25/calculation-issue-update.aspxHere's the nub of it: Of the 9.214*10^18 different floating point numbers that Excel 2007 can store, there...
Tags: Microsoft Office, SWThomas, Microsoft Excel, Microsoft Excel 2007
Discussion threads 2007-09-28
Tip: Excel 2007 bugs
Thanks to Gustav Brock for this link to Excel 2007 bugs and issues. by Susan Harkins
Tags: Microsoft Excel 2007, Microsoft Excel, Microsoft Office, Office Suites, Software, Susan Harkins
Blog posts 2007-09-26
Excel 2007 Save As Bug
I have Excel 2007 installed on my computer. When I open a .xls document with Excel 2007 and do a Save > As and save the document with a new file name (still using the .xls file format) Excel will create the new .xls file as it should, however...
Tags: Microsoft Office, emuhlethaler@..., Microsoft Excel, Microsoft Excel 2007
Discussion threads 2007-09-11
Excel 2007 Save As Bug?
I have Excel 2007 installed on my computer. When I open a .xls document with Excel 2007 and do a Save > As and save the document with a new file name (still using the .xls file format) Excel will create the new .xls file as it should, however...
Tags: Microsoft Office, emuhlethaler@..., Microsoft Excel, Microsoft Excel 2007
Discussion threads 2007-09-10


IT Professional's Guide to Policies and Procedures, Third Ed
Whether you're creating policies for management, training, personnel, support, privacy, Internet/e-mail usage, security, or inventory, you'll meet the needs of your entire enterprise with this one download!
Buy Now
500 Things Every Technology Professional Needs to Know
Did you know Microsoft's RegClean does not work with XP but you can use shareware to clean your registry? Did you know most wireless access points don't have encryption enabled by default? Did you know there are 500 tidbits of information contained in TechRepublic's 500 Things Every Technology Professional Needs to Know that will help you become a successful IT professional.
Buy Now

SmartPlanet