Microsoft Word Training: Outline
Here’s a quick tip on how to use outline in your document in order to speed up your formatting job. Read more
Excel 2010 No Cell Icon
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:
What is the factorial of 0.5 (0.5!)?
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…
Microsoft Access: Creating a subdatasheet
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.
Read more
SQL 2005 Reporting Services drilldown
In this video, I show you how to create a drilldown system using SQL Server Business Intelligence Development Studio 2005:
Alternate row color in an Access Report
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:
Excel 2007: Show image according to chosen name
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!
Read more
Excel 2007: Inserting Formulas in a Flash
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.
Excel 2007: Diagonal Sum
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.
Excel 2007: Highlight Active Row (Take 2 – Part 2)
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.