Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Use Excel's conditional formatting to find errors
- Formats distinguish values in a spreadsheet. You might add a currency character, align numeric values to the right, or change the font type or size for heading rows. The possibilities are endless and most of us go through a phase of formatting everything. Then, we get bored with the process...
- Tags: Overtime, Hour, Format, Possibility, Spreadsheet, Productivity, Microsoft Excel, Microsoft Office, Office Suites, Software, Susan Harkins
- Blog posts 2008-02-16
- How to subtotal Excel lists the easy way
- Lists are new in Excel 2003 and they're great, unless you want to subtotal columns; Excel disables the Subtotal feature for lists. Now, you can keep the list and produce subtotals the hard way. Or you can temporarily convert the list into a conventional range and subtotal the easy way....
- Tags: Spreadsheet, Subtotal, Salesperson, Dialog Box, Microsoft Excel, Microsoft Office, Office Suites, Software, Susan Harkins
- Blog posts 2008-01-25
- How to sort a single column in Excel without disrupting the rest of the spreadsheet
- We tend to view spreadsheet data as a whole, and that's as it should be. Seldom does a single column of values mean much to us without some related data to define it. Together, seemingly useless values become information. In fact, that's the definition of data and information. Information is...
- Tags: Information, Column, Microsoft Excel, Spreadsheet, Cell, Productivity, Susan Harkins
- Blog posts 2008-01-19
- Mailing to selected contacts via Excel 2000/Outlook 2003
- Good Morning,I work in the illustrious world of P&C Insurance, and to help streamline my workflow, I've created a "risk submission log" in Excel. The spreadsheet has 5 columns, from left to right: Insurance Company Name, Submit check boxes correspond with the Insurance Company, Date Submitted, Response, & Notes.Here's...
- Tags: Financial Planning, PRODUCTIVITY, Microsoft Office, Chip Seelig, Date Submitted, insurance, Microsoft Excel, e-mail, spreadsheet
- Discussion threads 2007-11-14
- Excel 2003 spreadsheets opening in IE6
- On one of my client computers, when he opens an excel spreadsheet using the link on our web page, the sheet opens, but only the IE6 specific buttons along the top tool bar work. There are no menus displayed for the view, data, format, tools buttons. If the spreadsheet is...
- Tags: PRODUCTIVITY, Microsoft Office, michael.frongillo@..., Microsoft Internet Explorer 6, spreadsheet, Microsoft Excel 2003, Microsoft Excel
- Discussion threads 2007-11-08
- SolutionBase: Gnumeric and KSpread offer spreadsheet application alternatives for Linux users
- Jack Wallen takes cursory looks at two alternative spreadsheet programs for Linux. by Jack Wallen
- Tags: TechRepublic Inc., Jack Wallen, Productivity, Linux, Operating Systems, Software, spreadsheet, office
- Image galleries 2007-11-07
- SolutionBase: Gnumeric and KSpread offer spreadsheet application alternatives for Linux users
- In the word of general office spreadsheet needs, Microsoft Excel and OpenOffice.org Calc are probably considered the big guns, but the possibilities don't end with those two tools -- at least not when you're using Linux. Two alternative spreadsheet applications in particular stand out: a piece of the KOffice suite...
- Tags: Gnumeric, KSpread, Processor, Linux, Author, KOffice, Spreadsheet, Tool, Spreadsheet Application, KSpread KSpread, Figure G, Script Edit Function, Gnumeric Let, Productivity, Jack Wallen
- Technical articles 2007-11-07
- By Greg Shultz (Taking a look at IBM Lotus Symphony Spreadsheets)
- Lotus SymphonySymphony is where I cut my teeth with Spreadsheets but more importantly where I fell in love with databases. So I eagerly downloaded and went to install it only to fail time and time again.Does anyone have any idea why it failed? I am not a newby...
- Tags: PRODUCTIVITY, raicsl@..., IBM Corp., spreadsheet, Lotus Symphony, IBM Lotus Symphony Spreadsheets, IBM Lotus Symphony, Greg Shultz
- Discussion threads 2007-11-06
- Excel: Shared a workbook and now spreadsheet will not calculate
- I have a sorce spreadsheet for which another sheet is linked to pull data. I shared the workbook which may or may not be part of the problem. When I make formula changes in the workbook, the formulas are copying and show in the cell, but the calculation...
- Tags: PRODUCTIVITY, Microsoft Excel, cmikesh@..., workbook, cell, spreadsheet
- Discussion threads 2007-10-30
- MS Excel - no scroll
- I have created a spreadsheet for my customers to use, however some users are unable to "scroll' up/down. They say they can scroll from side-to-side though.My spreadsheet was created using MS Excel 2003. Does anyone know why this may be happening?All responses are appreciated!!!Possible compatibility problemFind out what version of...
- Tags: PRODUCTIVITY, Microsoft Office, Microsoft Corp., thurmbo@..., csv, Microsoft Excel, spreadsheet
- Discussion threads 2007-10-30
- Geeks should learn communication, so why aren't suits required to learn technology?
- In my job, I have to keep close tabs on the statistics surrounding our site usage. I have access to spreadsheets that show every number I could ever want to know and even some I don't want to know. Most of the time, I can extrapolate the info I need,...
- Tags: Problem, Geek, Spreadsheet, Productivity, Professional Development, Career, Toni Bowers
- Blog posts 2007-10-29
- Taking a look at IBM Lotus Symphony Spreadsheets
- Continuing my series of first-look galleries covering the IBM Lotus Symphony office suite, I've created a gallery introducing the spreadsheet application, Symphony Spreadsheets. (I covered the word processor, Symphony Documents, in the previous gallery.) In keeping with its goal of making the Lotus Symphony product an easy-to-use...
- Tags: Spreadsheet, IBM Corp., Productivity, Greg Shultz
- Blog posts 2007-10-26
- By Greg Shultz (Taking a look at IBM Lotus Symphony Documents)
- Compatible with Lotus 1-2-3 Spreadsheets?Is the Spreadsheets part of the program compatible with the old Lotus 1-2-3 Spreadsheets? This was the most widely used of the Lotus Programs.RE: By Greg Shultz Taking a look at IBM Lotus Symphony DocumentsWith true OpenOffice available, also free - why bother with this?...
- Tags: PRODUCTIVITY, OOA/OOD/OOP, mike-hanscom@..., IBM Corp., spreadsheet, IBM Lotus Symphony
- Discussion threads 2007-10-23
- Taking a look at IBM Lotus Symphony Spreadsheets
- IBM recently revived the Symphony name for its new office suite. by Greg Shultz
- Tags: Ibm, Lotus, Symphony, Spreadsheets, TechRepublic Inc., Spreadsheet, IBM Corp., Productivity, Greg Shultz
- Image galleries 2007-10-22
- Spreadsheet Printing
- I have several spreadsheets that I use in my business. Up until last week, no problems. I have not changed anything. Now it will print 4 or 5 columns, then the ink will gradually taper off and it will not print the rest of the ten. ...
- Tags: Printers, PRODUCTIVITY, nancymack1@..., printer, printer model, spreadsheet
- Discussion threads 2007-10-15
- excel best for this?
- i have a text file that i have been convertingto an excel file, i download a new text filedaily so that now i have 2 different workbooks that look like this:Spreadsheet #1YESTERDAY DATE 10/12/2007Item No. Price Retail123458 10.00 ...
- Tags: PRODUCTIVITY, Databases, rooniwife@..., inventory tracking, text-file, spreadsheet
- Discussion threads 2007-10-14
- Microsoft Service Packs: A necessity before you deploy?
- In case you hadn't heard, Microsoft watchers have been abuzz over the Excel display bug discovered a couple of weeks ago. Members of the Excel team tried to reassure users by posting an explanation of the bug in this blog entry, maintaining that even if certain decimal values are displayed...
- Tags: Microsoft Office 2007, Service Pack, Microsoft Corp., Spreadsheet, Adage, Microsoft Excel, Microsoft Office, Productivity, Office Suites, Software, William Jones
- Blog posts 2007-10-11
- 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
- Zoho adds database application to roster of online productivity apps
- Zoho, the online productivity suite company, recently added a database application to its increasing popular online applications. The database and reporting tool is simple to use and supports several database language dialects. Here's a quote from an article at Wired: Zoho DB can import data from...
- Tags: Spreadsheet, Zoho, Storage, Productivity, Databases, Hardware, Enterprise Software, Software, Data Management, Arun Radhakrishnan
- Blog posts 2007-10-05
- ms excel
- hello sir, iam working as an accountant in cardiac scan centre.I want to know about the links in ms excel i.e links between two different spreadsheets e.g. Spreadsheet and spreadsheet 2. I want to make changes automatically when i...
- Tags: PRODUCTIVITY, clemy_everonline@..., spreadsheet
- Discussion threads 2007-10-03
Introducing SmartPlanet
-
-
Find thought-provoking progressive ideas on topics that intersect with technology, business and life.
Visit Today
-
-
Technology, perspective, and insights shaping the world
-
Learn innovative and practical skills for your business and your life. SmartPlanet offers 360 degree coverage that you need to feel connected to the information that matters to the world at large.
Go to SmartPlanet
