Sponsored White Papers, Webcasts, and Downloads
Additional Resources
- Sumif with Find and Mid
- Your June 8,2000 article "Using Excel's Find and Mid to extract a substring when you don't know the start point" is perfect for my application...I now need to combine it with a sumif statement, if possible. Let's say that I would need to sum sales for all products with...
- Tags: juaniyoegy@...
- Discussion threads 2007-03-20
- 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
- Get Excel to calculate formulas with circular references
- Don't go around in circles unnecessarily—when you have a circular reference in Excel, the program usually gives you an error message. However, if you want to calculate repeatable formulas, you can get Excel to do circular calculations on your terms. Mary Ann Richardson tells you how. In Excel, formulas...
- Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, Microsoft Office Suite Excel Tips Newsletter, Formula, Office Suites, Software
- Technical articles 2006-11-07
- Use Excel's Autofill to generate a series of dates
- Isn't it frustrating to do a task manually in Microsoft Excel when you know there must be a faster and easier method for accomplishing your goal? One Excel feature that will save you time is Autofill, which can generate a series of dates for your worksheets. Microsoft Excel 2002...
- Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, Use Excel, Smart Tag, AutoFill, donation, B50, Microsoft Office Suite Excel Tips Newsletter, Office Suites, Software
- Technical articles 2006-01-31
- Organ (dmg)
- Organ is a software organ emulation with all controls found on the original Hammond B3 as well as a sophisticated rotary speaker simulation. Detailed reconstruction makes it first choice for any music style. Many new features open sonic possibilities never heard from any other organ before.
- Tags: Organ, Tools & Techniques, Management
- Software downloads 2006-12-15
- Filtering Columns
- I in fact want to filter columns like filtering rows with Auto Filter. However, I know Excel cannot filter columns. Then, I thought of using VBA to do it.I intend to set values in A3:Z3. If the values in any of these 26 cells = 1, then hide the whole...
- Tags: Scripting languages, D2Coop05@...
- Discussion threads 2007-10-23
- Use one-way Excel tables to analyze data
- Analyzing data doesn't have to be a headache-inducing endeavor. This example shows how you can use Excel's one-way tables feature to determine if a project will come in under budget without a lot of calculations. Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite...
- Tags: PC, Microsoft Excel, Microsoft Office, Desktops, Mary Ann Richardson, Microsoft Office Suite Excel Tips Newsletter, TechRepublic Inc., Office Suites, Software, Hardware
- Technical articles 2005-04-20
- Use VBA to hide some columns
- I in fact want to filter columns like filtering rows with Auto Filter. However, I know Excel cannot filter columns. Then, I thought of using VBA to do it.I intend to set values in A3:Z3. If the values in any of these 26 cells = 1, then...
- Tags: Scripting languages, HeHeMan, VBA
- Discussion threads 2007-08-08
- Moving data in Excel
- I have an excel spreadsheet template with multiple formulas. Users do not access the formulas but they have a horrible habit of dragging the bottom row of data to the top and then filling down when starting a new form. This throws everything out as now the last formula is...
- Tags: Microsoft Excel, damian.murphy@..., cell
- Discussion threads 2007-10-03
- Change the labels in an Excel data series
- The Chart Wizard in Excel may work a little too well at times, which is why you'll want to read this tip from Mary Ann Richardson. Learn how to change the labels in a data series so you have one set of information from multiple selections. When you select...
- Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, Click Next, Chart Wizard, Microsoft Office Suite Excel Tips Newsletter, Data Series, Office Suites, Software
- Technical articles 2007-02-06
- Do not update formula when inserting rows in Excel
- In Excel, I want to be able to insert a row but NOT update a formula referencing that row. For example in Cell B1 I have the formula =AVERAGE(B3:B33) now when I insert a new row at row 3 the formula automatically changes to =AVERAGE(B4:B34) I want to ALWAYS average...
- Tags: 7s1u7le79ba7089@..., Microsoft Excel
- Discussion threads 2007-05-03
- How to program to print comments for/next to the specified cell
- Excel sheet consists of cell a b c d e f g 1 Name SC1 sc2 sc3 sc4...
- Tags: abC, achoksi@..., cell, Excel Sheet, Name, software
- Q&A 2005-03-03
- You Control (dmg)
- You Control is a collection of 19 powerful, yet flexible menu utilities that allow you to create custom menus that extend the functionality and usability of your Macintosh. Accessing your files and the information that is important to you has never been easier. Rediscover your Macintosh with You Control and...
- Tags: Menu, Apple Macintosh, Desktops, Tools & Techniques, Hardware, Management
- Software downloads 2007-12-10
- XTS-400 Trusted Computer System
- As a trusted computer system, BAE Systems's XTS-400 is ideal for hosting trusted guard and server applications. With high-power Pentium or Xeon server hardware, the XTS-400 design is based on its predecessor, the XTS-300, the only general-purpose computer system in the world rated at the B3 level by the National...
- Tags: BEA Systems Inc., Computer, Productivity, Servers, Processors, Hardware, Semiconductors, Components
- White papers 2005-02-04
- Create an Excel chart that automatically updates with new data
- Are you constantly changing your Excel chart's data range as new information becomes available? Mary Ann Richardson shows how to set up the chart to automatically update as you add new rows of data to your spreadsheet. If you add a row or two of data to your...
- Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, Click Add, Microsoft Office Suite Excel Tips Newsletter, Data, Chart, Office Suites, Software
- Technical articles 2006-04-25
- Create a gauge chart in Excel to show a job's progress
- A useful way of conveying what percentage of a job is complete is to create a gauge chart in Microsoft Excel. Even though a gauge chart is not listed in the default chart types, you can still create one based on the pie chart type. When you want to...
- Tags: Microsoft Excel, Microsoft Office, Recruitment & Selection, Mary Ann Richardson, job, Click Pie, pie chart, Microsoft Office Suite Excel Tips Newsletter, Pie, Slice, A3, Office Suites, Software, Human Resources, Workforce Management
- Technical articles 2005-08-02
- Use the Scenario toolbar to quickly analyze Excel data
- Mary Ann Richardson shows you how to set up a scenario using a lot fewer steps than navigating all the menus you might ordinarily use in Excel. While Excel's Scenario toolbar can be a powerful analysis tool, clicking through all the menus needed to set up a scenario...
- Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, PRODUCTIVITY, tool, toolbar, Microsoft Office Suite Excel Tips Newsletter, Scenario, Office Suites, Software
- Technical articles 2006-09-05
- Netfee (exe)
- Integrated with popular firewall systems (ISA server, Winroute, Winproxy), Netfee can do Usage Analysis, Reporting, and Performance management. It is a network software solution for managing Internet access. It consists of an analysis module, charge module, and reporting module. Netfee analyses the firewall's log files, then write the result into...
- Tags: Module, Netfee, Firewalls, Network Security, Security, Networking
- Software downloads 2006-06-15
- Tech Tip: Create a Word text box/Exclude zero values in Excel/Use the Access crosstab query
- Create a text box from existing text People often use text boxes to highlight aspecific part of their document. But when you want to use a textbox, there's no need to retype the text. Follow these steps: Copy the text you...
- Tags: text box, AVERAGE function, Microsoft Access, Microsoft Word
- Technical articles 2004-08-03
- << Previous
- page 1 of 1
- Next >>
