Here’s a quick tip on how to use outline in your document in order to speed up your formatting job. Read more
Excel 2007 introduced Icon Sets to Excel Conditional Formatting. Excel 2010 introduces No Cell Icon to Conditional Formatting.
In Excel 2007, after applying your Icon Set Conditional Format, you would get something like this:
If you use Excel and enter the following formula: =FACT(0.5) the answer will be one. However, if you open a more rustic tool such as the Windows Calculator and try again, you will get 0.886226925510.
So, how can a tool such as the Windows calculator come up with the correct answer when Excel can only return 1? What about the factorial of 0.75 (0.75!)? Again, Excel returns 1 whereas the Windows calculator gets the correct answer: 0.919062526898…
A subdatasheet is useful when you want to see the information from several data sources in a single datasheet view. For example, in the Northwind sample database, the Orders table has a one-to-many relationship with the Order Details table.
In this video, I show you how to create a drilldown system using SQL Server Business Intelligence Development Studio 2005:
This tip shows you how to use VBA to alternate the row color of an Access report. Many times, when creating a report, we find it hard to read the details. By alternating the row color we can make life much simpler:
Here’s a nice trick on how to swap images using a list and the camera tool without the need to use VBA. Consider you have a product list and wish to show a picture according to the selected product: well, here’s the solution!
Here are some nice tricks on how to quickly insert formulas in Excel. Forget all that dragging of the fillhandle and stuff. With these tricks you will be inserting formulas in no time.
In this tutorial I show you how to sum diagonally using an array formula. You will also learn how to add conditional formatting in order to track the diagonal being summed.
Here’s a cool way to highlight the active row in Excel (all sheets). This is done using Excel 2007, but it also applies to previous versions of Excel.