VBA and Macros and VLookup, Oh My!
I might be ending up on a work assignment where they want someone who can create and edit complex Excel templates that interface with Access and Adobe Forms. I've used all these programs extensively, but I've only used advanced features sparingly (either editing someone else's creation or googling for a specific fix for a specific problem.) Difficulty level: I only have a week to cram on this before I would start.
Is it possible for a quick learner to get up to speed enough not to crash and burn on a project like this? Can anyone recommend an online course I could binge on before having to take on this project?
posted by firechicago
on May 19, 2014 -
I want to be able to open multiple instances of Excel 2010 in Windows 7 on a PC. This is the default for opening Word docs but for some reason Excel limits me to multiple windows inside one instance. Is there a way to do this?
Challenge: I do not
have the ability to edit the registry on this (work) computer.
posted by Wretch729
on Apr 22, 2014 -
Seeking recommendations for on-line training on business applications, particularly MS Office. [more inside]
posted by dg
on Sep 4, 2012 -
Hoping someone can help me sort this problem ...
It's a excel + microsoft word document + mail merge to outlook email to 50 people.
I am trying to help someone out - this is is as it just as it was described to me:
Track changes were accepted and turned off and the email looked as it should - so off went 50 customized emails.
..unfortunately the sent email then shows that all the emails are sent showing all of the tracked change revision markings!
Sorry if this is too vague. Thanks for your efforts :)
posted by anewnormal
on Nov 30, 2011 -
Macgyver IT: I want my team to use something like del.icio.us to share links. But since this is ask.metafilter, I can't use the obvious right answer. I need to make something like it myself, using
bubblegum and string
the MS Office 2000 suite and my knowledge of VB. What would be my best approach? [more inside]
posted by Monday, stony Monday
on Nov 19, 2009 -
I need MS Excel and Word to play together nicely. I can do what I need to in Word, and I can do what I need to in Excel; it's the Relationship that's Complicated. Maybe I need workflow advice? Basic knowledge? Please, please keep reading. [more inside]
posted by cheeken
on Feb 5, 2009 -
MS Excel Question: If I have a column with a range of dates in it, is there a formula that will tell me how many years ago that date was from today? [more inside]
posted by Rock Steady
on Nov 14, 2008 -
MS Excel filter: I'm editing a huge spreadsheet and Excel doesn't like my zip codes. How can I quickly fix this? more after jump... [more inside]
posted by LiveToEat
on Jan 24, 2008 -
I can't get a formula in excel to recalculate when copied and pasted to another cell. Help! [more inside]
posted by batcrazy
on Sep 21, 2006 -
OfficeApp Filter: How can I seamlessly convert lists of project assignment names and deadlines to a calendar view that can be shared? Or can I? [more inside]
posted by Marnie
on Aug 22, 2006 -