• How to estimate work hours for a typical data profiling and cleansing effort? Any Estimate calculators in Excel can be shared?

    One of my known acquaintance asked a question to help him with an estimator to logically estimate person hours required for data profiling and cleansing. His company is assuming their data quality will be bad. Now that there is a necessity to check and cleanse data, how to arrive at the man hours...

    swamis5 pointsBadges:
  • Change Microsoft Excel numbers to English

    I've noticed a very odd issue in my Microsoft Excel program. My tabs and commands are in the English language but the numbers are in a foreign language (I think it's German but I'm not sure). How can I switch it back to English?

    ITKE1,043,075 pointsBadges:
  • Why are my Microsoft Excel cells hidden?

    Hi all, I noticed that in my Microsoft Excel spreadsheet that several of the cells are hidden. I'm not sure why that happened. What's the cause of this? Thank you.

    ITKE1,043,075 pointsBadges:
  • Record last used Microsoft Excel macro

    In Microsoft Excel, is there a way for me to track when a macro was used last? Looking for the date/time. What do I need to do on my end? Thank you.

    ITKE1,043,075 pointsBadges:
  • Macro for copying data from Excel to AS/400

    Hi,I'd like to create a macro (in AS/400 or Excel VBA, doesn't matter) that copies cell data from an XLS spreadsheet to AS/400. How would I do that?E.g. copying cell A1 in Sheet1 from c:\spreadsheet.xls to 10/035...Thanks in advance.

    Hanisadeq963575 pointsBadges:
  • Merge several Microsoft Excel files into one

    I'm a beginner to Microsoft Excel so bear with me please. I'm trying to merge four different files into one file. Each one has the same column headers. Should I just copy and paste or is there a better way?

    ITKE1,043,075 pointsBadges:
  • Open Microsoft Excel 2013 file on Microsoft Office 2010

    I'm currently on my home laptop that runs Office 2010. My co-worker gave me an Excel 2013 file that I can't open. Excel 2010 is telling me that it's a corrupt file. How can I view / open this file? Thank you so much.

    ITKE1,043,075 pointsBadges:
  • Consolidate multiple Excel 2016 worksheets into one

    I'm using Microsoft Excel 2016 and my workbook contains roughly 15 sheets. I need to consolidate all the sheets into one specific sheet. Obviously, I could copy / paste but that would take way too long. All the data is in the same format. Thanks.

    ITKE1,043,075 pointsBadges:
  • Open Excel XLL file

    Hi, how can I open (to view the code) of an Excel XLL file?

    TutanoKamon5 pointsBadges:
  • Spreadsheets vs. Desktop Analytics

    Has anyone successfully migrated from MS Excel to MicroStrategy? Would love to hear your experience.

    Tareen5 pointsBadges:
  • Why is Microsoft Excel overloading my computer?

    I recently did a Windows 10 update (just a few days back). Ever since the update, my computer fan has been going crazy and I only have a couple of programs open. I looked at Task Manager and it says Microsoft Excel is running. But I closed it out. I'm not sure what to do here. Any suggestions?

    ITKE1,043,075 pointsBadges:
  • Hyperlinks in Microsoft Excel spreadsheet are not working

    I've had an Excel spreadsheet for years for my job and I have certain links in it that open in Google Chrome. But when I upgraded my Windows version, none of the links work. What should I do? I thought it was a cookie issue but that wasn't the case. Not sure what I should do.

    ITKE1,043,075 pointsBadges:
  • Create multi-level list in Microsoft Excel

    I'm not sure if there's a way to do this but I thought I ask. Can I create/implement a multi-level list in Microsoft Excel? I'm looking for something like this: 1. XXXX 1.1. XXXX 1.1.1. XXXXX 1.1.2. XXXXX 1.2. XXXX Does anyone know? Thanks.

    ITKE1,043,075 pointsBadges:
  • Insert Microsoft Excel row through keyboard on Mac

    I'm using Microsoft Excel on a Mac. Can I insert a row through my keyboard? I already tried Control + Shift + '+' but that didn't work. Does anyone know how to do it? Thanks.

    ITKE1,043,075 pointsBadges:
  • Microsoft Excel 2016: Filter function will not work

    For the past few years, my department has been using Microsoft Excel 2013. One of our biggest spreadsheets included a pivot table that had roughly 15 columns and 300 rows of data. Now, we just upgraded to Excel 2016. But here's the issue - the filtering function doesn't work anymore. All the new...

    ITKE1,043,075 pointsBadges:
  • Stop Excel VBA code manually

    For VBA, does there happen to be a way to manually stop/pause an Excel VBA code? I know this is possible in Visual Studio. Thank you.

    ITKE1,043,075 pointsBadges:
  • Microsoft Excel: Writing a fraction in a spreadsheet

    I'm sorry for this simple Excel question but it's been giving me a headache this week. How can I write a fraction in an Excel spreadsheet. Something like 1/4 or 2/3. Thank you.

    ITKE1,043,075 pointsBadges:
  • How do I associate an employee # to a name in Excel 2007?

    I work in a restaurant and created a tip out spreadsheet. I need to insert employee names constantly. It would be much easier to just type in their employee# and have their name appear in another cell. Ex: Column A=Employee#, Column B=Employee's name. I want to type in the employee's # in cell A1...

    Weazel5830 pointsBadges:
  • Move content to top of Microsoft Excel cell

    On my Microsoft Excel spreadsheet, does anyone know how to move text to the top of a cell so I can align it with the rest of my spreadsheet? Thanks so much.

    ITKE1,043,075 pointsBadges:
  • Cannot open Microsoft Excel document

    I work in the IT department for my company and one of our employees came in with an interesting issue with Microsoft Excel. When he tries to open a document, he keeps getting this error message: An error has occurred in sending the command to the application. I already tried a bunch of things but...

    ITKE1,043,075 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following