background preloader

Microsoft Excel Tips - Excel.Tips.Net

Microsoft Excel Tips - Excel.Tips.Net
Related:  ExcelProductivity Tool

Excel Pages Excel Pages This page describes the various pages on the web site. This is the Page Index to the Excel Web Source site. It lists each page on the site, and describes its contents. The icon indicates that the content is related to Excel itself (typically the user interface) or to formulas. indicates that the content is related to VBA. indicates that the content is related to Visual Basic 6. indicates that the content is related to Visual Basic NET. indicates that the page has been converted from HTML to ASP.NET 2.0 indicates a download on the page. About This Site This page tells a bit about the site, along with acknowledgements, and miscellaneous information. Activating Excel From Other Programs If you are doing cross-application program (such as automating Excel from a Word document or template), you may find it useful for the user's convenience to activate Excel and set keyboard focus to the active sheet. Adding The COM Add-Ins Menu Adding Menu Items To VBE Alert Message Component Array Formulas

50 Firefox 3 Add-ons That Will Transform Your Academic Research Posted on Thursday July 17, 2008 by Staff Writers Out of the box, Firefox 3 is already an incredible web browser. But when you consider all of the power tools that can be added to enhance your research, it’s even better. Check out these add-ons for Firefox 3, and you’ll take your browser to the next level and transform your academic research. Sharing & Discovery Get social with your favorite websites and use these add-ons to share and discover new places on the web. StumbleUpon: This add-on learns what you like and will help you find web sites based on your interests.ShareThis: Share any type of online content with your friends, family, and colleagues with ShareThis.Me.dium: Share your favorite sites and communicate with your friends using this add-on.Shareaholic: Use this add-on to make sharing URLs easy and streamlined. Tabs Make Firefox’s incredibly useful tabs even better with these add-ons. Reference & Connection These add-ons can make simple text turn into usable reference points. Files

Using Microsoft Excel Worksheet Functions in Visual Basic [Excel 2003 VBA Language Reference] The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location. Note Some worksheet functions aren't useful in Visual Basic. For example, the Concatenate function isn't needed because in Visual Basic you can use the & operator to join multiple text values. Calling a Worksheet Function from Visual Basic In Visual Basic, the Microsoft Excel worksheet functions are available through the WorksheetFunction object. The following Sub procedure uses the Min worksheet function to determine the smallest value in a range of cells. Sub UseFunction() Dim myRange As Range Set myRange = Worksheets("Sheet1").Range("A1:C10") answer = Application.WorksheetFunction.Min(myRange) MsgBox answer End Sub If you use a worksheet function that requires a range reference as an argument, you must specify a Range object. Note Visual Basic functions don't use the WorksheetFunction qualifier. Example

Top 10 Useful Sites I’ve Found This isn’t work at home related, but it’s (mostly) helpful stuff I really wanted to share. I’ve come across a lot of different sites that have been helpful for whatever reason and I know you’ll really love some of them too! Get a Human Do you hate calling a company and speaking to a robot right off the bat with no idea of how to get through to an actual person? Then you need GetHuman. Ibotta This is actually an app you can use for your Apple or Android device that actually pays you cash money for the things you buy at the grocery store! Crackle I am loving this site. Nielsen HomeScan This company will send you a cool little scanning thing in the mail that you can use at home to scan the bar codes on your grocery purchases. SuperCook I use this one a lot. Grooveshark This is kind of like Crackle, only for music. Credit Sesame Sometimes you need to know your credit score, but you don’t want to have to sign up for a “free trial” and give your credit card number out. Who Called Us GasBuddy Akinator

Nested Functions - Nested Functions in Excel A nested function in Excel refers to one or more function being placed inside another. This is done to extend the capabilities of a function. How it works is that the nested functions are used as arguments of the first function. These tutorials include step by step examples of using nested functions in Excel. Excel Nested IF Function Step by Step Tutorial Excel Nested IF Function Tutorial The usefulness of the IF function can be extended by using one or more Nested IF functions. Nested IF functions increase the number of possible outcomes that can be tested for and increase the number of actions that can be taken to deal with these outcomes. This step by step tutorial used nested IF functions to determine the deduction rate for employees based on their annual salary. Lookup Formula with Multiple Criteria in Excel Excel Nested Function Tutorial Excel Two Way Lookup Using VLOOKUP This tutorial nest the MATCH and VLOOKUP functions to create a two-way or two-dimensional lookup formula.

100+ Free Tools For You To Access Blocked Sites How many ways have you used to unblocked the internet censorship and get access to Facebook, Twitter, YouTube and some other sites blocked in your country or area? I have used a ton, such as Proxy, SSH, VPN and many other anti-censorship tools, since which may be blocked, too, the more you have, the safer you will be. The following are 100+ free tools for you to access blocked sites: I. Online Proxy Websites (66) The main advantage of online proxy websites (or web proxies) is that you don't need to install anything nor to make any configuration, just to look out those pop-up ads. 1. The Aniscartujo web proxy is workable for both computers and mobile phones. 2. This web proxy allows you to watch YouTube videos as well as to download them in MP4 files. 3. A UK web proxy which supports JavaScript well. 4. The effect of TryCatchMe is nearly same as Daveproxy. 5. Surfagain.com is available for you to watch YouTube videos. 6. 7. The Magaproxy free version is free of pop-up ads. 8. 9. 10. 11. 12-47. a.

Different Ways to Take Advantage of the E-mail Features of Excel Ron de Bruin Microsoft Excel MVP Frank C. Rice Microsoft Corporation August 2003 Applies to: Microsoft® Excel 97 and later versions Summary: Microsoft Excel MVP Ron de Bruin provides a number of samples and a handy add-in that enhances your experience when working with e-mail from Excel. Contents Introduction This article features code samples, a wizard, and an add-in utility that you can use to perform various e-mail functions from Microsoft Excel. Note You should be aware of the two main security features for Outlook 2002 and later versions (and with a security patch for Outlook 2000): Blocking of a customizable list of file attachments considered unsafe because they can be used to propagate viruses. These constraints can affect the way you interact with Outlook in the following procedures. Sending E-mail in Excel One way to send e-mail from Excel is to the use the Mail Merge Wizard which is only available in Excel 2000 and later versions (called the Mail Merge Helper in Excel 2000). ... ...

20 Incredible Web Apps Found in the Chrome Web Store 2010 has been a great year for webapps, with dozens of new, exciting apps that let us move even more of our computer experience to the cloud. Google’s Web Store’s launch last month has accelerated this trend, and many new webapps with unique, often iPad style interfaces are now available for Chrome. However, many of the apps in the Web Store are simply links to great apps that are available to any modern browser. If you install these apps in Chrome, you’ll essentially just get a large bookmark icon to the webapp that you could have accessed by simply entering the app’s URL in your address bar. Todo.ly Todo.ly Need to keep up with everything you need to do? Price: FreeRequires: Chrome; runs in any modern browserInstall App in Chrome HootSuite Hootsuite HootSuite helps you keep track of all your social networks and manage your company’s social interaction from one app. Price: FreeRequires: Chrome; runs in any modern browserInstall App Springpad Springpad Pixlr Editor Pixlr Editor SlideRocket Zootool

Sending Email Sending E-mail Once you've exposed Outlook's object model with binding, you have all the tools you need to begin automating Outlook. The only step that remains is to explore Outlook's object model and figure out how to do what you want. For my money, examples are king. So I've attempted to provide you with some examples in the next sections to show how you might use your new found knowledge and hopefully provide you with some tips and tricks to speed up the learning process. I'll start with a very common activity, sending e-mail. Sending an E-mail with Attachments Sub SendWithAtt() Dim olApp As Outlook.Application Dim olMail As MailItem Dim CurrFile As String Set olApp = New Outlook.Application Set olMail = olApp.CreateItem(olMailItem) ActiveWorkbook.Save CurrFile = ActiveWorkbook.Path & "\" & ActiveWorkbook.Name Set olMail = Nothing Set olApp = Nothing End Sub Comments: This procedure adds two attachments to the e-mail; the ActiveWorkbook and a Word document. Prev Page: Early Binding vs.

stumbleupon Google Scripts offer programmatic access to most Google products including Gmail, Google Docs, Google Drive, Analytics, Google Contacts, Calendar, Maps and Google Analytics. The Google scripts are written in regular JavaScript language and they are hosted on Google’s servers. Here’s an always-updated collection of Google Scripts that will help you do more with your favorite Google products. And you don’t have to be programmer to use any of these scripts. Hire Google Apps Script Developer

Send Email from Excel This article lists several ways to send Outlook messages from Excel. You may also want to visit Send worksheets by email as separate workbooks for more sample code. + UDF to Send Email from Excel using Outlook+ Mail Worksheet Using Outlook+ Embed Picture in Email+ Attach Current Workbook To Email+ Save and Send A Copy of the Current Workbook+ Sending a Range as an Attachment+ Sending Selected Range in Message Body+ Convert Excel.Range to HTML UDF to Send Email from Excel using Outlook This is a VBA macro that can be used as a UDF to send messages directly from the Excel worksheet. First, paste the following at the top of a standard module: Then paste this code into a standard module, along with the helper functions found below: Use this function in a worksheet cell like this: =SendMessage(A1,A2,A3,A4,A5,A6,A7) If you put the code in your PERSONAL.XLS file (or in any workbook other than the one where the function is being used), you may have to qualify the function like this: =PERSONAL.XLS!

stumbleupon There are several options when it comes to backing up a WordPress site. Depending on the type of access you have, retrieving the database or an XML backup is easy. But what if you don’t have access to the database or the backend? Consider the following scenario presented on the WordPress subreddit: A relative who used WordPress recently passed away and you have no way to access the backend of their site. Their site is filled with memorable posts you’d like to archive. One option is to use WGET. In the example below, I used four different parameters. HTML Extension – This will save the retrieved files as .HTMLConvert Links – After the download is complete, this will convert the links in the document to make them suitable for local viewing. wget –html-extension –convert-links -m -w 20 Using this command, each post and page will be saved as an HTML file. Keep in mind that this is saving the output of a post or page into an HTML file. Like this: Like Loading... Related

Calculation Mode and Excel Optimization How to properly set calculation mode in Excel VBA Most people set calculation mode to 'manual' at the beginning of the code, then set it to 'automatic' at the end. This assumes that the setting was 'automatic' in the first place and the user wants the calculation mode to be 'automatic' after the code finishes. While I believe that in 99.9% of cases, calculation should always be set to automatic (see Spreadsheet Speeding up Re-calculations for explanation), your code should never make unrequested changes without notifying the user. Here is how to properly set the calculation mode so it is restored to whatever it was previously. Optimize your macros This can be cut and pasted into your routines to make them run faster. Paste this in right after the initial Sub line in your macro (or you might want to create a separate procedure just for this): Then right before the End Sub, paste this: Minimize interaction between VBA and Excel Believe it or not, VBA and Excel are actually separate entities.

Related: