I am trying to summarize a table of thousands of values into simple year ranges. It should be simple. So basically, there is a table that looks something like this:
The table has many, many values between about 1900 and today. I would like to make a table like this:
1900 - 1909 23.6
1910 - 1919 64.3
1920 - 1929 73.1
Again, I'm using Access 2010. Any help would be massively appreciated.
posted by rybreadmed
on Aug 1, 2014 -
I don't just mean in page view. I am translating a book and would like to produce a dual-language book with the original on the left and the translation on the right, like in the Loeb library and so forth.
I can sort of do this with two columns, but they're not really independent. (If I keep typing in one, it'll eventually bleed into the other.) [more inside]
posted by Opengreen
on Jul 23, 2014 -
I want to get a Microsoft Database certification so I can become a database developer (I know some basic SQL using Postgres but I'd like to know more and get a certification). What's the best way to do this using a book instead of taking a class? [more inside]
posted by Mrs. Pterodactyl
on Jul 15, 2014 -
I work extensively with Microsoft Excel, and I'm putting together a list of little known facts about Excel for a presentation. I haven't found much on the interwebs that's exceptionally interesting. Does anyone have any facts they can share that come from off the beaten path? [more inside]
posted by scottso17
on Jun 25, 2014 -
At work, I have been deemed the person in my group who should learn Microsoft Access. I am allowed to take a class. Can anyone recommend a good Microsoft Access class in NYC? [more inside]
posted by millipede
on Jun 18, 2014 -
For some recent while, probably since updating the OS X Mavericks, Microsoft Word for OS X keeps coming to the foreground on its own when I'm doing other things, as long as a document is open in Word. If I click out to the Finder, Word makes itself the frontmost program. If I click into the browser, Word comes forward. [more inside]
posted by Mo Nickels
on May 6, 2014 -
I'm using the Winebottler program to install IE8 on my Mac (for testing a site). It looks great but doesn't seem to connect to the Web. Is there a fix for this?
posted by johngoren
on Apr 30, 2014 -
I am finally waking up, smelling the coffee ... and seeing that I must say goodbye to XP. My machines are old (but not ancient) ThinkPads - one T60 and three X60s maxed out on RAM (systems built 2006-2008). I'm looking for an honorable seller of Win 7. [more inside]
posted by ferkit
on Apr 21, 2014 -
I have a list of names on an Excel file. I'd like to transfer each name (along with other details) to one PowerPoint slide. Is there any way I can do this without having to manually type in each name?
posted by AngryTypingGuy
on Apr 18, 2014 -
My company currently has a computer that has a Japanese version of Windows 7 Professional installed on it. We want to install an English language version of Windows 8.1 on the computer. Will the language for the Microsoft Office software (currently also Japanese) already installed on the computer also change to English when we change to the new English language version of Windows 8.1? [more inside]
posted by tokaidanshi
on Apr 7, 2014 -
Seriously if I knew this was the story - wouldn't have gotten a brand new webcam today. But so here it is - Livecam VX800 - uninstalled, reinstalled - and as a plug and play install for *New Hardware* (XP) is not recognizing it as a webcam - but as *USB Audio Device* Then when I check it in Device Manager under Imaging Devices, it's a *USB video device*. [more inside]
posted by watercarrier
on Apr 1, 2014 -
I am still using Office 2003 for personal use. It meets my limited needs perfectly well, and I want to avoid learning curves and costs associated with alternatives if at all possible.
I understand that Microsoft will no longer be issuing security patches for it soon, so there are potential risks in continuing to use it, but how serious are those risks given my actual pattern of use? And can they be easily mitigated by avoiding various features or behavior? [more inside]
posted by philipy
on Mar 21, 2014 -
My church is upgrading its computers and the old copies of Office are long since vanished, evidently. (If they ever existed; I kind of suspect the last person who did IT stuff may have pirated it.) So, we're buying new versions. But our office manager is... well, she's not at all computer literate. She's kind of continuing to be employed more on a charity basis than because she's actually very capable. But I need to get her able to actually use the basic features of Word, Excel, and Publisher on the new versions, in the simplest way possible that does not involve my personally sitting with her for days at a time. Help? [more inside]
posted by Sequence
on Mar 3, 2014 -
I need a new laptop. Replacing my old MacBook Pro. Considering a MacBook Air. Details inside. [more inside]
posted by dbirchum
on Feb 9, 2014 -
I use an ancient MS Natural Keyboard, but the main thing that's relevant here is the key mechanism.
The Goog will show you models old and new
I recently took mine apart, cleaned the plastic parts with water, got it nice and clean (years of accumulated cookie crumbs, etc.)
The problem is - now the keys are kind of stiff. For example, if I strike them at a slight angle, they don't depress as smoothly as before.
The standard advice online is to clean a keyboard to prevent
sticky keys, but I have the opposite problem.
Is there some kind of lube/oil/spray I can use?
posted by 4midori
on Dec 30, 2013 -
My company uses Exchange for email. Since they block POP and IMAP access for security reasons, I cannot use Gmail (or Google Apps) to read my email. They do support Active Sync, so Apple Mail and Outlook both work fine. I would prefer a web based option, as close to gmail as possible. Are there any other options out there for me? [more inside]
posted by kdern
on Dec 3, 2013 -
My sister has a WP8 phone, but she doesn't remember what Microsoft account she associated with when she first set it up. Is there any way, on the phone, to discover this?
posted by kickingtheground
on Nov 28, 2013 -
IE-11 for Win7-64 rolled out yesterday, and it makes one of my favorite sites break. The site isn't mine and it isn't going to get fixed any time soon. [more inside]
posted by Chocolate Pickle
on Nov 27, 2013 -
I have an Apple MacBook Pro Retina display with NVIDIA GeForce GT 750M
I use Parallels Desktop 9 for Mac and I installed Microsoft Windows 8.1 Pro with success, however windows does not recognize that I have nvidia installed in my system.
My question is:
How to let Parallels Desktop 9 to enable NVIDIA work in windows 8.1 pro?
If it does not support it, what other tools or software to make nvidia work in windows 8.1 pro?
posted by omaralareefi
on Nov 13, 2013 -
I'm having problems with microsoft synctoy and would like advice on how to troubleshoot it or find an alternative. [more inside]
posted by medusa
on Oct 29, 2013 -
I am a high school teacher in the UK (11-18). Can I buy office 365 for mac at (£54) and be eligible to install it? It is unclear about the installation process. I have my school email, bank slips etc. but it is not a .ac address so do I need to get the home and student addition instead? Don't want to waste money either way!
posted by starrjenny
on Oct 26, 2013 -
Is there a way to transfer files using the remote PC app in windows 8.1?
If not, what is the best way to transfer files flawlessly and fast?
Thank you. [more inside]
posted by omaralarifi
on Oct 21, 2013 -
I will be starting to work on several small, overlapping projects soon and need a lightweight tool. WANT: Ability to manage 2-3 resources (mostly me, really), schedule tasks, create and output Gantt charts. DO NOT WANT: The security hole of suck known as Java, so Project Libre, OpenProj and the like are right out. MEH, WILL ACCEPT IF NEEDED: Cloud app. I really prefer desktop programs for various reasons, but if the best solution is on the cloud, so be it. A PLEA: I'm going to a presentation on Office 365 tonight with a devotee of MS Project. Please arm me in advance against the call of the dark side! [more inside]
posted by maudlin
on Sep 26, 2013 -
How do I fix this? I "imported" a table from a PDF (big mistake). In the pdf, the dates were formatted as AA-BB, where AA was the month and BB was the year. Excel interpreted that as AA is the month and BB is the day, and gave them all 2013 as the year. So now the date reads as 11-Jan instead of Jan 2011. I no longer have access to the original dataset because I only just noticed the mistake. I am using Excel 2010 on Windows.
posted by rebent
on Aug 26, 2013 -
I own my own business. After a screen crack on a lap top, I bought a new laptop. I also bought Office 2013, with Outlook.
How can I get a single inbox? It wants to set up multiple inboxes and I do not want to have to check different inboxes. I had a single inbox on my Outlook 2010. Every link I see on Google has ridiculous levels of power user requirements that I have neither the time nor the ability to do. Can anyone help?
Running Windows 8 on an HP Pavilion.
posted by Ironmouth
on Aug 23, 2013 -
What is the most cost effective way to purchase roughly 50 Microsoft Office Standard 2010/2013 licenses? [more inside]
posted by lattiboy
on Aug 14, 2013 -
We're building a new PC. We're also an avid gamers. What OS do we want (and/or monitor and mouse/trackpad combo)? [more inside]
posted by Diagonalize
on Aug 14, 2013 -
Kingsoft Office appears to have hitched a ride on some software I downloaded recently (thank you, CNET). In a further act of pushiness, it seems to have converted all my MS Word files into Kingsoft Write 2013 files. Is there any way to convert them back to MS Word and make Kingsoft just go away? [more inside]
posted by IndigoJones
on Jul 30, 2013 -
Can you recommend some apartment rentals in Seattle which are within walking distance to a Microsoft Connector bus going to the Bellevue office? Thank you! :)
posted by jchaw
on Jul 23, 2013 -
I have a 100-page Word document full of miscellaneous content from different websites.
Unfortunately, after each section taken from a website, there's basically a citation for where the content was taken from that contains the URL for the website.
I need to find a way to find all these hyperlinks and delete them completely from my document. They're all from different websites, so really, the only commonality is the "http://" part.
posted by beammeup4
on Jul 19, 2013 -
A week ago a well intentioned doofus dropped my Asus N53S, Win7x64 Pro. She was a champ. Snapped the motherboard, but I safely extracted the harddrive. The venue of its demise bought me a Asus N76VX which has the dreadful Win 8, but 2 TB harddrive with lots of partition space. Is there any way I can "run" my old machine from its harddrive in an emulated Win 7 environment on this new beast? [more inside]
posted by moonbird
on May 23, 2013 -
In Mac Word 2011 - When editing a block of existing text, with the insertion point at the end of newly typed word, using command-B or command-I seems to style the word preceding the insertion point, and that I just applied styles to, rather than turning the styles off for the word I am about to type. Can this behavior be altered? [more inside]
posted by snuffleupagus
on May 9, 2013 -
I sat on the phone with Microsoft support and they weren't able to help me. I've scoured the internet trying to find a solution to this problem and I'm just about ready to give up. Can Metafilter rise to the challenge?
How do I stop Microsoft Excel from formatting numbers into scientific notation? No matter what I do, Excel keeps doing this. Please make it stop.
See the youtube video
I made explaining my problem (45 seconds). [more inside]
posted by crios
on Apr 16, 2013 -
I have read that John Walkenbach's books are the de-facto standard for learning to use VBA in Microsoft Excel. I'd like to know what books are recommended to learn to use vba in other Office products - primarily Access, but also Word and Powerpoint. I'm more interested in books than in websites.
posted by Proginoskes
on Apr 6, 2013 -
Microsoft advertises their "BlueTrack" mice as being able to work on almost any surface, with only a few exceptions (mirrors and glass, if I remember correctly). But mine works on almost no surface. [more inside]
posted by Flunkie
on Mar 8, 2013 -
I was just working on a proofreading file for hours. I closed it, thinking I had been saving it (I'm pretty sure I was saving it!). Then I went to email it , and it's nowhere to be found on my computer. I searched for it. I thought that if you don't save something it will be recovered when you open Word again, but nope. And I can't find it on my computer anywhere. Does anywhere have an idea where it could have gone and how/if I can get it back?!
posted by bearette
on Mar 3, 2013 -
So I upgraded from Microsoft Office Starter 2010 to Microsoft Office 2010. I uninstalled the Office Starter program. Then things went wrong. Please help! [more inside]
posted by merocet
on Jan 26, 2013 -
I currently don't have any version of Windows installed on my PC (it's a Mac). I would like to install Windows on a Bootcamp partition. I noticed that Microsoft has a special offer
where they are selling a Windows 8 download for $40 through Jan. 31. That's a good price for me. The possible catch: Microsoft seems to be saying that I need to have an earlier version of Windows installed in order to use that download. I can't quite tell whether they are serious about this.
Do I really need to have a preexisting Windows install to take advantage of the $40 Windows 8 offer? [more inside]
posted by grobstein
on Jan 19, 2013 -
If I'm using Word for Windows, I can double click at the bottom of a page to create one big page. But if I double click at the bottom of a document inside Word on MacOS it opens up the footer prompt. Does Word for Mac have a similar "join pages" feature?
posted by professor plum with a rope
on Jan 12, 2013 -
How might I recover an Office 2010 product key from a Windows install now located on an external hard drive? [more inside]
posted by dumbland
on Dec 19, 2012 -
Our small office uses a MS Access database daily for non profit work. The database is small enough where I'm not certain it warrants upgrading to SQL. Most of the work done in the database is remote (7 users total) so we are looking to move from a standalone PC w/remote access to the cloud.
I would greatly appreciate any advice with regard to moving the DB to a cloud service provider that supports MS Access. One that is reliable, is relatively easy to admin e.g., backups and lastly, inexpensive.
posted by Sagres
on Dec 3, 2012 -