Today we will learn about Workbook Events and Procedures Workbook Activate Event This event will run code whenever this specific workbook is activated. Workbook AddinInstall Event This event will run when the specific workbook is installed as Add-In in Excel. Workbook AddinUninstall Event This event will run when this workbook is uninstalled from Excel’s Add-Ins. […]
There are two very similar functions in Excel to look for data inside of cells matching parameters that you dictate: SEARCH and FIND. There are so similar, in fact, that one wonders why have two separate functions that perform virtually the identical results and are identical in the construct of the formula. This article will […]
In Excel 2010 onwards you can create your own Ribbon Tabs as well as add your own Macros to them!. Let’s learn how really easy this is to do. This is really useful if you have a set of commands you use on a regular basis and want to keep them on a totally separate […]
It is not breaking news, but something that anyone working on an Excel Report using formulas and functions, will know the keys of successfully using lookup formulas. They are vital for making almost any spreadsheet or dashboard. That is why when you learn how to extract information from Excel tables, you will be truly excited, […]
The main benefit of connecting to external data from Microsoft Excel is that you can periodically analyze this data in Excel without repeatedly copying the data, which is an operation that can be time-consuming and error-prone. After connecting to external data, you can also automatically refresh (or update) your Excel workbooks from the original data source whenever the data source is updated with new information.
Learn Excel Formula Auditing with examples to take you to the next level! It allows you to graphically display the relationship between formulas and cells. Features: Easy Auditing of formula dependents and precedents, including object dependencies (charts, pivot tables, form controls, Validation formulas, Conditional formatting formulas, etcetera). The example helps you master Formula Auditing quickly and easily.
If you have data from an alternative source, you may be able to import it into Excel 2010 instead of having to re-enter all the information again. Depending on the type of data you would like to import, you can select from a number of options. We’ll look at one of the most common import types – a text file.
To make sure you’re making your data as convincing as possible, you should always customize your graphs in Excel. And by customization, we’re not talking about big sweeping changes. Below are some quick tweaks you can make to your graphs convincing, easy-to-read, and beautiful.
Another underused feature of Excel is Named Ranges. Named Ranges allow you to assign a meaningful name to a cell or a range of cells and then use that name instead of the actual cell reference in your formulas. A name is easier to remember when you are constructing your formulas.
We are often asked by Microsoft Office power users whether, why, and when they should use Microsoft Access versus Microsoft Excel. Especially when they are very comfortable using MS Excel and don’t understand the reasons why anyone would use MS Access or databases. Here’s our perspective.