Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- sort by:
- Relevance
- Date
- Popularity
- Enter text without changing the underlying cells in Excel 2007
- Mary Ann Richardson discusses text boxes, which can hold unlimited amounts of text without affecting any of the cells in your Excel 2007 spreadsheet. Excel cells are limited to 256 characters. However, the cell's size and ability to display its contents change with the size of its...
- Technical articles 2007-06-19
- Print what you see in Excel 2007's Page Layout View
- Excel 2007's Page Layout View allows you to avoid the frustration of creating unnecessary printouts of your spreadsheets. Here's an easy way to see your work including headers and footers using this view. In versions of Excel prior to 2007, it is difficult to know how many printed...
- Technical articles 2007-06-12
- Turn off gridlines in your Excel applications
- Gridlines in your Excel worksheets can be quite distracting. Mary Ann Richardson explains how to make gridlines invisible in Excel 2002, 2003, and 2007. Your users may find it easier to work with your worksheet applications if they can't see the gridlines. For example, let's say you...
- Technical articles 2007-06-05
- Save steps when wrapping text and inserting worksheets in Excel 2007
- Excel 2007 contains a number of improvements that make your job easier. Here are two tips that, prior to Excel 2007, required multiple mouse clicks. Now you can perform these tasks with a single click of the mouse. Prior to Excel 2007, if you wanted to enter First...
- Technical articles 2007-05-29
- Use Excel's Solver tool to schedule your employees
- Solve a problem with Excel's Solver. This tool can help you help you optimize your employees by determining the right number of techs you need at any particular time. You don't need to guess when it comes to determining how many employees you will need to cover a shift...
- Technical articles 2007-05-22
- 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...
- Technical articles 2007-05-15
- Make Excel charts more meaningful with reference lines
- Give numbers shape and form by illustrating your Excel reports with charts. Mary Ann Richardson describes how to create a chart that shows the ups and downs of data changes against a constant, targeted value so your users can visually ascertain the differences. It's more compelling to analyze how...
- Technical articles 2007-05-08
- 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...
- Technical articles 2007-05-01
- Respond quickly to business changes with Excel's smoothing add-in
- Excel's smoothing add-in helps you predict changes based on previously recorded data. It also makes it easy to adjust your plans to accommodate what's to come. Excel's smoothing add-in can help you respond to a significant change that may affect business operations by providing a forecast that balances...
- Technical articles 2007-04-24
- Use Excel's Moving Average add-in to predict customer service call load
- Monitor and predict call center volume using Excel's Moving Average add-in, which can help you spot trends that may warrant further attention, saving you headaches down the line. UPDATE: You can download an Excel example of this tip here.Your call center manager notices that the center has received an...
- Technical articles 2007-04-17
- Analyze performance through common-sized income statements with Excel
- Perform percentage and comparison analyses in Excel by creating a common-sized income statement. Find out how in this tip by Mary Ann Richardson. How do your company's profit margins compare with others in your industry? What percentage of revenue goes to salaries? What percentage of revenue goes...
- Technical articles 2007-04-10
- 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...
- Technical articles 2007-04-03
- Make it easy for users to enter symbols in Excel worksheets
- Recalling symbols in your applications can be challenging, but it's easy in Excel. Mary Ann Richardson gives step-by-step instructions for creating shortcuts for some of your most-used symbols in Excel. While Excel has a number of special characters for you to work with, they require a number of...
- Technical articles 2007-03-27
- Two tips for giving your Excel worksheets a professional look
- Mary Ann Richardson describes how you can give your Excel spreadsheets a polished look by using the appropriate type of line formatting and removing zero values. Excel provides several underline formats to give your spreadsheets a professional look and to make them easier to read at a glance....
- Technical articles 2007-03-20
- Create a General Ledger in Excel from General Journal data
- Convert your daily General Journal data into a more extensive, yet focused, General Ledger using Excel in this tip from Mary Ann Richardson. Many businesses keep a journal of their daily transactions, called the General Journal. The General Journal entries, which can be entered directly into an...
- Technical articles 2007-03-13
- Analyze future profits against variable costs with Excel's data table feature
- Extrapolate with Excel! By using Excel, you can calculate current profits as well as potential profits based on the variables of your choice. Mary Ann Richardson shows how you can use Excel to help you make predictive calculations. You know that if you sell your company's product for $45...
- Technical articles 2007-03-06
- 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...
- Technical articles 2007-02-27
- Create Excel order forms that automatically compute shipping charges
- Online order forms are great for figuring out shipping charges—as long as you're working with the right data. Mary Ann Richardson tells how to set up Excel so it automatically calculates the right shipping charges based on the bottom line. Online order forms should be able to perform all...
- Technical articles 2007-02-20
- Make Excel spreadsheets easier to read with natural language range names
- Use the labels already in your Excel spreadsheet to help you easily understand what your formulas mean. Mary Ann Richardson gives meaning to the mystery of formula results. Whether you are using Excel spreadsheets for training or to present an analysis of last year's sales results, it is...
- Technical articles 2007-02-13
- 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...
- Technical articles 2007-02-06
- << Previous
- page 1 of 6
- Next >>
Refining Tags
- Mary Ann Richardson (104 results)
- Microsoft Excel (103 results)
- Microsoft Office (101 results)
- Office Suites (100 results)
- Software (100 results)
- cell (26 results)
- TechRepublic Inc. (18 results)
- Sales strategy (12 results)
- Chart (11 results)
- worksheet (10 results)
- Productivity (10 results)
- Sales (10 results)
- Formula (9 results)
- Use Excel (8 results)
- Click OK (8 results)
- Hardware (7 results)
- Spreadsheet (7 results)
- Excel spreadsheet (7 results)
- Data (6 results)
- workbook (5 results)
- toolbar (5 results)
- Peripherals (4 results)
- Mice (4 results)
- font (4 results)
- Box (4 results)
- header (3 results)
- data entry (3 results)
- Click Next (3 results)
- Click Add (3 results)
- mouse (3 results)
- Desktops (3 results)
- Microsoft Word (3 results)
- tool (3 results)
- Word processors (3 results)
- Sales force management (3 results)
- Go-to Format (3 results)
- Microsoft Excel 2007 (3 results)
- printing (3 results)
