TechRepublic : A ZDNet Tech Community

127 Resources for

microsoft office and sales

  • Subscribe to this listing via:
  • RSS
  • Email

TechRepublic Resources

Named ranges make it easy to summarize year-to-date totals
You have five sheets in your workbook. The first four sheets list the sales for each quarter by month and then total the sales for the quarter in cell N10. The last sheet calculates the year-to-date sales. To have your worksheet summarize the YTD total automatically, follow these steps: ...
Tags: Sheet, Microsoft Excel, Sales Strategy, Microsoft Office, Office Suites, Software, Sales, Mary Ann Richardson
Blog posts 2008-06-03
Are Vista sales slacking off?
Vista SUCKS!In the last 18 months, I've only had 3 students who had Office 2007 and 2 with Vista. One student gave up on Vista because no one else had it & she felt out of place. So she had it removed and replaced with Windows XP and Office 2003....
Tags: Microsoft Windows Vista (Longhorn), Apres Ski, sales, Microsoft Windows Vista, Microsoft Office, Microsoft Office 2007
Discussion threads 2007-10-28
Set up minimum and maximum markers on Excel line charts
Let's say that at the end of each month you provide your sales personnel with a line chart that charts year-to-date sales by month. For the June report, you would like to emphasize which month had the most sales and which month had the least sales. You could manually add...
Tags: Microsoft Excel, Sales Strategy, Microsoft Office, Sales Force Management, Office Suites, Software, Sales, Mary Ann Richardson
Blog posts 2007-10-02
Google - Salesforce pact: Is this the making of a MS Office killer?
Speculations are rife that Salesforce.com, the leader in the SaaS (Software-as-a-Service) segment is teaming up with Google to offer a combined Web Applications solution for enterprises. The package could include Google's collaborative software such as instant messaging, e-mail, Google docs, spreadsheets and presentation service with Salesforce.com's business software to manage...
Tags: Software, Salesforce.com Inc., Google Inc., Microsoft Office, Microsoft Corp., Sales Force Management, Tools & Techniques, Sales, Management, Arun Radhakrishnan
Blog posts 2007-05-23
Create Excel charts that show data comparisons at a glance
If you or your users need data from certain time periods, you can create an Excel chart that makes the specified dates or times contiguous on a stacked column. Here's how to make an easy graphic visualization of information from what may be scattered times. An Excel chart's data...
Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, Microsoft Office Suite Excel Tips Newsletter, Sales Strategy, Office Suites, Software, Sales
Technical articles 2007-05-15
Use a sample record to create an online form in Access 2007
No need to have your users fill out multiple sheets of paper -- build an online form in Access 2007 and have your employees enter the data for you. If you already have a sample of the data that you want to collect, you can use that data...
Tags: Microsoft Access, Microsoft Office, Databases, Mary Ann Richardson, Sales strategy, online form, Microsoft Office Suite Access Tips Newsletter, Zip Code, Sales Force Management, Sales, Office Suites, Software, Enterprise Software, Data Management
Technical articles 2007-05-01
Help users find information with an interactive Excel chart
When you create an interactive Excel chart, the way to really make your users happy is by letting them find data they want according to their parameters. Learn how to do that by following these step-by-step instructions. Instead of creating multiple Excel charts that give different...
Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, Click Add, Click OK, Microsoft Office Suite Excel Tips Newsletter, Chart, Sales Strategy, Office Suites, Software, Sales
Technical articles 2007-05-01
Use dynamic ranges to make your Excel spreadsheets easier to understand
Give your numbers more distinct meanings in Excel with dynamic ranges. By using the OFFSET function and naming feature, you can give labels to your formulas, making them easier to find and reference. You can make Excel formulas easier to understand by using named ranges. For example, the...
Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, Sales strategy, Sales force management, Excel spreadsheet, Click Add, sales, Total Sales, Microsoft Office Suite Excel Tips Newsletter, Formula, Office Suites, Software
Technical articles 2007-04-03
Analyze Excel data with the Match function
You can use Excel's Match function to scan data for certain parameters, such as a specific product sold in a particular month. Mary Ann Richardson narrows down the process in this Excel tip. Management would like a quick and easy way to find total unit sales for any...
Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, Microsoft Office Suite Excel Tips Newsletter, TechRepublic Inc., Sales Strategy, Office Suites, Software, Sales
Technical articles 2007-02-27
Make your Excel charts easier to read with custom data labels
If users are spending time trying to match up each data label in your chart with its corresponding data point, then you may need to remove some of the clutter. In this Excel tip, Mary Ann Richardson shows how to make your charts easier to read by substituting custom...
Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, Sales strategy, data label, Click Next, Microsoft Office Suite Excel Tips Newsletter, Office Suites, Software, Sales
Technical articles 2007-01-16
Add a pivot chart to your Access reports
Pivot charts can add value to your reports. In this tip, Mary Ann Richardson shows how to make the most of this useful Access feature. Pivot charts in Access are not just for display only. You can also distribute your pivot table analysis in a printed report. For...
Tags: Microsoft Access, Microsoft Office, Databases, Mary Ann Richardson, drop-down list, Order Year, Format tab, General Tab, Microsoft Office Suite Access Tips Newsletter, Tab, Sales Strategy, Office Suites, Software, Enterprise Software, Data Management, Sales
Technical articles 2006-08-22
Use conditional formatting in Excel to identify data trends
Looking to track positive or negative changes in your Excel data? Mary Ann Richardson explains how you can use conditional formatting to find out this information automatically. Excel's conditional formatting can help you keep track of positive or negative changes in your business. For example, suppose you've ...
Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, Sales strategy, sales, Go-to Format, Microsoft Office Suite Excel Tips Newsletter, TechRepublic Inc., Office Suites, Software
Technical articles 2006-06-20
Forecast the future with Excel trendlines
Trying to predict the future based on past experiences, but you're lacking the right formula? If you've forgotten high school algebra, fear not. With trendlines, Excel can project future figures based on previous history. Mary Ann Richardson points the way. Let's say you are keeping track of monthly sales...
Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, Sales strategy, sales, Microsoft Office Suite Excel Tips Newsletter, Office Suites, Software
Technical articles 2006-05-30
Create a combo box for users' data in an Excel chart
Combo boxes in Excel are handy because they allow individual users access to various ways to view data without changing the integrity of the information itself. Mary Ann Richardson explains how to set up combo boxes that let users decide which data to chart. When it comes to data...
Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, Sales strategy, combo box, sales, Microsoft Office Suite Excel Tips Newsletter, Box, Office Suites, Software
Technical articles 2006-05-02
Find the top 10 values in an Excel range without sorting
When you want to total the amount of sales from your top 10 performers, you usually would have to sort the data first, then use the SUM function to add up the first 10 values in the sorted range. With Excel's Array function, you can get the same results in...
Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, Sales strategy, performer, sales, Microsoft Office Suite Excel Tips Newsletter, Range, Sales Force Management, Office Suites, Software
Technical articles 2006-03-21
Create top 10 lists in Access with the Top Values combo box
Are you looking for a snapshot of the 10 best performers in your sales department for the last quarter? Then check out how easy it is to create top 10 lists in Microsoft Access with the Top Values combo box. Have you ever wanted to compile a ranked list...
Tags: Microsoft Access, Microsoft Office, Databases, Mary Ann Richardson, Sales strategy, Top Values, combo box, Microsoft Office Suite Access Tips Newsletter, Box, TechRepublic Inc., Sales Force Management, Sales, Office Suites, Software, Enterprise Software, Data Management
Technical articles 2005-08-16
Enhance grouping in your Access reports
Grouping related customer records in your Microsoft Access reports allow you to look at data from different angles. Discover a quick way to put these groups in sections and then enhance these sections by providing summary details about the group. When you're analyzing customer records for trends, grouping ...
Tags: Microsoft Access, Microsoft Office, Mary Ann Richardson, Sales strategy, Group Footer, Group Header, sales, Microsoft Office Suite Access Tips Newsletter, TechRepublic Inc., Record, Databases, Office Suites, Software, Enterprise Software, Data Management
Technical articles 2005-07-19
Building cross-tab queries using Access
Despite SQL Server's stability, performance, and range of tools, no facility is provided for building cross-tab queries. Check out how Arthur Fuller uses Microsoft Access to make up for SQL's lack of a cross-tab wizard. Cross-tab queries are an extremely common requirement in database applications. Given SQL Server's...
Tags: Microsoft Access, Databases, Arthur Fuller, Sales strategy, Sales force management, cross-tab query, sales, SQL Server Newsletter, TechRepublic Inc., Database, Column, Microsoft Office, Enterprise Software, Software, Data Management, Office Suites
Technical articles 2005-05-23
Analyze custom views of your Excel data
If you want a quick analysis of your data, then see why you should utilize Excel 2003's List feature. You'll learn how you can create a simple report in less than a minute that will calculate the sales of a particular product. Help users increase productivity by automatically signing...
Tags: Microsoft Excel 2003, Microsoft Excel, Microsoft Office, Mary Ann Richardson, Sales strategy, Sales force management, Microsoft Office Suite Excel Tips Newsletter, TechRepublic Inc., Office Suites, Software, Sales
Technical articles 2005-04-27
Salesforce.com woos Office programmers
Stay on top of the latest tech news with our free IT News Digest newsletter, delivered each weekday. Automatically sign up today!By ...
Tags: Sales force management, Sales strategy, Microsoft Office, Salesforce.com Inc., Microsoft Corp., sales
Technical articles 2005-02-03


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
IT Help Desk Survival Guide, Third Edition
TechRepublic's IT Help Desk Survival Guide, Third Edition provides tools and recommendations to help you better manage help desk services, improve end-user support, troubleshoot frustrating hardware issues, identify quick fixes to vexing Windows problems, and help users make the most of Microsoft Office 2003.
Buy Now

SmartPlanet

Click Here