18 Resources for

use excel

Subscribe to this listing via:
RSS
Email

Sponsored White Papers, Webcasts, and Downloads

TechRepublic Resources

Use Excel's Solver tool to schedule your employees: vallinathAssistant; Tags: PRODUCTIVITY, valleenath@..., Use Excel, tool; Discussion threads 2007-05-23
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...; Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, Use Excel, tool, Solver, Click OK, Microsoft Office Suite Excel Tips Newsletter, Box, Cell, Productivity, Office Suites, Software; Technical articles 2007-05-22
Use Excel's Moving Average add-in to predict customer service call load: Sample DataThese examples are great, but providing sample data with them would be better.I agreeWe would really find this usefull in our call center so pls if you can give us an example; Tags: Call centers, Customer relationship management (CRM), tbrittnacher@..., customer service; Discussion threads 2007-04-17
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...; Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, Customer relationship management (CRM), Use Excel, customer service, Click Moving Average, Microsoft Office Suite Excel Tips Newsletter, Call, Manager, Office Suites, Software; Technical articles 2007-04-17
Use Excel's MS Query Wizard to query Access databases: Don't have access to Access? You can use Excel to open the database you want, using the MS Query Wizard. Here's how to multitask using Office's versatile spreadsheet program. There's data in your company's Access database that you need to analyze, but the PC you work with does...; Tags: Microsoft Access, Microsoft Corp., Microsoft Excel, Microsoft Office, Databases, Mary Ann Richardson, Use Excel, database, right arrow box, arrow box, drop-down menu, Click Next, Microsoft Office Suite Excel Tips Newsletter, Select, Storage, Office Suites, Software, Enterprise Software, Data Management, Hardware; Technical articles 2006-09-19

Use Excel's formatting tools to attractively arrange charts on a sheet: can't get this to workI have the charts selected but do not have format>objects I have format selected chart area, but there is no size tab on the dialog box. What am I missing?Be sure you'reusing CTRL-Click to select the chart; Tags: kahlmari@..., excel, chart, hardware, tool; Discussion threads 2006-08-31
Use Excel's formatting tools to attractively arrange charts on a sheet: If you're making the effort to organize your data into charts, why not take the extra step and make them look organized with consistent sizing too? In this Excel tip, discover how to format your charts so they appear all the same size. If you are going to publish...; Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, Mice, Use Excel, tool, Microsoft Office Suite Excel Tips Newsletter, Chart, Wizard, Office Suites, Software; Technical articles 2006-08-29
Use Excel's statistical functions to analyze data across worksheets: Multiple Pages - Summary PagesAnytime I create a workbook with multiple sheets, I always create or suggest that their be a summary sheet, exspecially if it's tracking numbers or dollars that are used in reporting or need to be tracked on a daily, monthly, quarterly or yearly bases.creating the same...; Tags: workbook; Discussion threads 2006-08-09
Use Excel's statistical functions to analyze data across worksheets: You aren't confined to one Excel worksheet when you wish to compare or analyze data. Learn how to use Excel's statistical functions to get more out of your worksheets. You can use Excel's statistical functions to analyze data in any worksheet, but they become even more powerful when...; Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, Use Excel, Department06, Department01, cell, Microsoft Office Suite Excel Tips Newsletter, Sheet, Office Suites, Software; Technical articles 2006-08-08
Use Excel's Advanced Filter to delete duplicates in a list: BrilliantThanks, simple and very useful.; Tags: paul@...; Discussion threads 2006-04-12
Use Excel's Advanced Filter to delete duplicates in a list: When you need to find the unique entries in an Excel list, the quickest way to find them is to use the Advanced Filter. Mary Ann Richardson shows us how to use this handy feature. When you need to find the unique entries in an Excel list, the...; Tags: Mary Ann Richardson, Microsoft Office, Use Excel, Advanced Filter, Microsoft Excel, Microsoft Office Suite Excel Tips Newsletter, Office Suites, Software; Technical articles 2006-04-11
Use Excel's Autofill to generate a series of dates: excel sheet sharehow to a excel sheet make share with any ther sheetThe result of cell B4 is #VALUE! So I try to type the date 10/7/2005 without (e.g.,) to get the correct result. I learned something new, that the number 7 or any desired number we type, is...; Tags: vandan_vco@...; Discussion threads 2006-02-09
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
Use Excel to create advanced graphs and PivotCharts: Advanced charting in ExcelThe downloadable version of this article is available herehttp://techrepublic.com.com/5138-10877-5993139.htmlHave you ever used a PivotChart in a presentation? How did it work? Was it effective?; Tags: Microsoft Excel; Discussion threads 2005-12-13
Use Excel to create simple graphs and bring your point home: Simple graphs in ExcelThe downloadable version of this article is available here:http://techrepublic.com.com/5138-10877-5984365.htmlDo you take the time to present analyzed data in graphical form? Do you believe a graphical presentation can increase your ability to communicate a particular point?; Tags: Microsoft Excel; Discussion threads 2005-12-06
Use Excel's Zoom feature to enhance your presentation: It even includes Locked header rows!This is so helpful! I just tried it on a spreadsheet tracking daily change in value for an investment fund. I selected cells A164-F172 and Zoomed to Selection. It smartly enlarged those cells, and included appropriately sized title & column labels rows so the figures...; Tags: Microsoft Word, Word processors, Microsoft Office, cell; Discussion threads 2005-10-26
Use Excel's Zoom feature to enhance your presentation: Considering how much you toil over creating a presentation you want to make sure that every audience member can read the charts and figures in your Microsoft Excel spreadsheet. If you need to enlarge a portion of your spreadsheet, discover how Excel's Zoom feature can automatically adjust the view for...; Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, PRODUCTIVITY, Construction, Use Excel, spreadsheet, Microsoft Office Suite Excel Tips Newsletter, Zoom, Office Suites, Software; Technical articles 2005-10-25
Join character strings with Excel's concatenate function: Cleaning up spreadsheets might not be in your job description, but it's an all too common task for some consultants. Use Excel's handy concatenate function to tidy up databases by joining character strings in destination cells.Consultants frequently find themselves manipulating simple Microsoft Excel databases. Often, the databases have been pulled...; Tags: Beth Blakely, destination cell, character string, cell, database, Microsoft Excel; Technical articles 2002-08-08

Additional Resources

AutoTable for MicroStation Excel (exe): AutoTable is designed to provide MicroStation users a more convenient way working together with Excel. You can import Excel spreadsheet into MicroStation and modify it with Excel at anytime. Besides, you can update table to synchronize it with the original Excel spreadsheet.Version 3.33 can reset the last cell in Excel...; Tags: Excel Spreadsheet, AutoTable, Microsoft Excel, Microsoft Office, Office Suites, Software; Software downloads 2005-12-28
Opening Multiple Copies of Excel in VBA: This probably sounds an incredibly stupid question, but I have been asked to develop an app for a client that uses Excel but is not to behave like Excel. I've gone through the process of removing the menu and toolbars etc, but I want to be able to open...; Tags: Microsoft Office, VBA, dean.crawley@..., Microsoft Excel; Discussion threads 2007-07-18

<< Previous
page 1 of 1
Next >>

Content Types

Discussion threads (9 results)

Technical articles (9 results)

Use Excel Jobs

Windows XP vs. Mac OS X: This presentation, entitled Standardizing on Windows XP Instead of MAC OS X, provides a pre-packaged option for defending Windows XP against MAC OS X. ...; Buy Now

TechRepublic's E-mail Usage Policy: Numerous studies indicate that personal e-mail use at work is a leading cause of lost productivity. In addition, personal e-mail use can introduce vir ...; Buy Now