How to Find the Right Chart Type to Represent your Numeric Data Charts help you visualize numeric data in a graphical format but the problem is there are just too many types of charts to choose from. You have bar charts, bubble charts, pie charts, line histograms and so on. If you are finding it hard to pick the right chart type for your type of data, refer to chart chooser diagram , also available as a PDF , designed by Andrew Abela . Start from the center of the poster and take the route that best matches your data type. Is the data static or does it change over time? Related: Create Graphs Online with Google Charts
Dashboard reports allow managers to get high-level overview of the business. Excel is an excellent tool to make powerful dashboards that can provide analysis, insight and alert managers in timely manner. In this page (and others linked here) you can find a lot resources, templates, tutorials, downloads and examples related to creating dashboards using Microsoft Excel. Use the below links to quickly access various sections of this page. What is a Dashboard? Dashboard reports allow managers to get high-level overview of the business and help them make quick decisions.
excel 2010 dashboard
Microsoft Excel Tutorials - BetterSolutions.com
Some Useful VBA Functions Category: VBA Functions | [Item URL] This tip contains VBA code for six simple, but very useful functions. You can simply copy the code and paste it to your module. FileExists - Returns TRUE if a particular file exists. FileNameOnly - Extracts the filename part of a path/filename string.
The code is tested in Outlook Express, Windows Mail, Windows Live Mail and Outlook and It may or may not work with other email clients. All code on this page will work in Excel 97-2010 or Excel 2000-2010. If you use Lotus Notes click here : http://www.rondebruin.nl/notes.htm If you use Apple Mail or Outlook 2011 on a Mac click here : http://www.rondebruin.nl/mac.htm#Mail There are four Microsoft mail programs: Microsoft Outlook, Outlook Express, Windows Mail (replace Outlook Express in Vista) and Windows Live Mail. Example Code for sending mail from Excel
Hide an excel sheet without the option of unhiding it using VBA in Microsoft Excel
Important read this : The code on this page is only working with Outlook and not with Outlook Express or Windows Mail. If you not use Outlook see the examples in the first section on my mail index page. Copy the code in a Standard module, if you just started with VBA see this page. http://www.rondebruin.nl/code.htm Check out this page for Tips If you want to change the code on this page. Mail a small message
If you are looking for Excel VBA code samples, here are some pages that should be useful to you. Click on the links above to access the code. I also have a few more generic prcedures listed here. Please note that most of the examples on this site were written for Office 2003, but will work (for the most part) on Office 2007 and 2010. Don't forget to check out the Video Tutorials page ! Fix Badly Imported Formulas Excel VBA
Write values to a header row
Create Default Workbook Template (book.xlt) Create a blank workbook, customized with number of sheets, fonts, styles etc. Hit F12 to save the workbook, in the 'Save As Type' dropdown, choose 'Template' For the filename, type 'book' (to save the template as book.xlt in your XLSTART folder) This will be the default workbook whenever you start Excel. Workbook and Worksheet Templates
varType Function The varType Function in Excel VBA Here are some custom VBA functions that use the varType function to check the variable type. Very useful when debugging your application to test if your variables are being implemented properly, they can also be used as drop-in procedures to check the expected value of a variable. In keeping with the spirit of modular programming, they are small self-contained procedures that can be copied and pasted elsewhere.
Sample Outlook Automation Create Outlook E-Mail Message (From Excel) – Early Binding Create Outlook E-Mail Message (From Excel) – Late Binding Create Outlook Contact (From Excel) – Early Binding Create Outlook Contact (From Excel) – Late Binding
Process all Files in a Folder You might have a collection of files in a folder and want to take some action on each of them. They might not even all be spreadsheets, but you want to print or consolidate data from each of them. Here are a few procedures you might use to do so. The following procedure uses a global Constant variable to loop through a folder and pass each filename to another procedure. The reason we use a global Constant will be shown below. The procedure called by the above code is called ProcessFile .
Freeze Excel Panes with VBA If you want to freeze panes programmatically, here's what you need to do. I recorded a macro of myself freezing panes a few times manually. Here is the resulting code (scrubbed): The trick (unfortunately) is you have to select the cell below and to the right of where you want to stop the worksheet from scrolling. If you try to freeze panes without selecting a cell, it just randomly freezes wherever it wants. Here are two procedures that encapsulate the freezing panes function.
IncSight DB IncSight DB lets you set up professional Excel dashboards linked to an Excel database. Set up your first Excel dashboard report in less than an hour. Add any number of reports. Excel Dashboards
Excel Add-In (XLA) Best Practices and Design Techniques This article contains information regarding best practices for developers creating add-ins using Excel's VBA editor in Office 2003. They may also apply to other Excel versions. I will update this page from time to time.
Adjusting comment properties can be frustrating, especially if you're stuck doing it manually. Here is some sample VBA code that lets you adjust all comments at once, to keep your workbook looking consistent. See All about Comment shapes for even more sample VBA code. Comment Shape Formatting
Check If Office App Is Running You may have a need in your application to check if a particular Office app is running. Here is some sample code that does just that. Paste the following code at the top of a standard module in any Office program that supports VBA. In this example we're checking for the heavy hitters — Excel, Outlook, Access, PowerPoint and Word.
Calculation Mode and Excel Optimization
Automated Word Mail Merge From Excel
Automate Internet Explorer
Send Email from Excel
Different Ways to Take Advantage of the E-mail Features of Excel
Ron's Excel Tips
Excel VBA. FREE Excel VBA Code & Excel Macro Help
Using Microsoft Excel Worksheet Functions in Visual Basic [Excel 2003 VBA Language Reference]
Nested Functions - Nested Functions in Excel