• Store

Forums

  • MS Office Forums

Follow us on our channels

RSS
Follow by Email
Facebook
YouTube
  • HOME
  • Access
  • Excel
  • VBA
MSOG

Category: Formulas

Excel 2007: Show image according to chosen name

January 25, 2009 Robert Martin Leave a comment

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
  • Formulas
  • Functions

Excel 2007: Inserting Formulas in a Flash

January 17, 2009 Robert Martin Leave a comment

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.

Read more

  • Excel
  • Formulas
  • Functions

Excel 2007: Diagonal Sum

November 9, 2008 Robert Martin Leave a comment

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.

Read more

  • Excel
  • Formulas
  • Functions

Excel: How to return names of files located in a folder

July 5, 2008 Robert Martin Leave a comment

In this short tip, I describe how you can return the names of files located in a folder without using VBA.

This is a very neat and easy trick to perform.

Read more

  • Excel
  • Formulas
  • Functions
April 2021
M T W T F S S
« Dec    
 1234
567891011
12131415161718
19202122232425
2627282930  

Recent Posts

  • Microsoft Word Training: Outline
  • Excel 2010 No Cell Icon
  • What is the factorial of 0.5 (0.5!)?
  • Microsoft Access: Creating a subdatasheet
  • SQL 2005 Reporting Services drilldown

Archives

  • December 2009
  • August 2009
  • June 2009
  • February 2009
  • January 2009
  • November 2008
  • October 2008
  • July 2008
  • April 2008

Recent Comments

    Categories

    • Access
    • Conditional Formatting
    • Excel
    • Form
    • Formulas
    • Functions
    • Outline
    • Query
    • Reporting
    • Reporting Services
    • SQL
    • VBA
    • Word

    Site options

    • Log in
    • Entries RSS
    • Comments RSS
    • WordPress.org

    Tags

    access conditional formatting excel forms formulas functions labelling outline query reporting SQL SSRS styles subdatasheet vba word

    Powered by WordPress and Dynamic News.