I've been recently getting interested in various Macros and what they can do in Excel. Is there suppository of various Macros available online as well as clear demonstrations of what they can be used for that I can insert into my spreadsheets.
I will be having a job interview that requires me to have some knowledge of Excel. I know this is vague but it includes, I presume, filters, hlookup, vlookup, and establishing filters to search out education data. The interview is to get a data analyst fellowship in the education setting. [more inside]
So, I just got promoted to a new position at my company (Yay!). Unfortunately, the new requirements involve scheduling a ridiculous number of people. It turns out my predecessor has just been doing dozens of iterations manually until one kind of worked, but every slight change puts a bunch of other things out of wack. I feel like Excel could probably be capable of doing it, but I have no idea how I would go about designing such a spread sheet. [more inside]
For a project, I'm trying to collect uses of Excel that do not include any formulas or other use of math. What are some common documents that people use the format of Excel to create in an office setting? [more inside]
What are the dates for the 9th and 20th business day for the rest of this year and all of next year?
I need to quickly figure the 9th and 20th business days of each month for the rest of 2012 and all of 2013. Preferably not in a manual fashion. [more inside]
Excel skills required for a particular job… I'm not sure what they are asking for. [more inside]
Which programming languages are best suited to creating a timetabling application? [more inside]
Help with Excel 2003... More inside: [more inside]
How do I create an inventory database using Excel? [more inside]
Can I download only OpenOffice Writer? [more inside]
Spreadsheet question: Display Greater Value? I know this is one of those "you-either-know-it-or-you-don't" situations, and I just don't know. [more inside]
I'm using Microsoft Excel 2003 at work and I need to make a chart where the category (x) axis is the y axis; is there any way of doing this? [more inside]
I've got two columns in MS Excel. They each share 200 numbers. However, one of the columns has an additional 700 numbers. I want the column with 900 sorted in ascending order, with like numbers from the column of 200 beside those in the column of 900. How do I do that?
Microsoft Excel. Is it possible to insert some "alarm" function that will notify me if I insert duplicate text in later cells? [more inside]
EXCEL FILTER: I have an entire column of 12 digit numbers with dashes (X-XXXX-XXXXX-X-X) and I need to delete the first five digits (and two dashes) so I can sort the numbers starting with the sixth digit. Is this possible? (more inside) [more inside]
I have an Excel document listing dates times and other information. I'd like to import this "calendar" to iCal but cannot figure out to get the information imported properly. I found this tool, but couldn't get it to work. I also found this application, iCal Maker but it doesn't seem to work either. Anyone have an idea on how to import a bunch of events listed in an Excel document to iCal? [More Inside] [more inside]
I have a mountain of data to move from dozens of Excel spreadsheets into an Access database. The database is an existing one and sort-of documented. How do I go about doing this? I’m very comfortable with Excel, but not at all with Access---I’ve never used it before. How do I push Excel data into Access records? Are there any web resources I could use? Any books I should buy?