Office 2007 – Adding Custom Colors to Color Picker

The new color scheme introduced in Office 2007 looks impressive, but personally I feel,  it does lose a bit of important functionality when it comes to Charts. Excel Charts is an important tool in business areas to represent the facts graphically. Excel 2003 has a 56 color set, which allowed user to customize the color […]

VLookup Function

Function Description: Vlookup stands for ‘Vertical’ lookup. This function searches for a value in the first column of a table array and returns a value in the same row from another column in the table array. Syntax: VLookup(lookup_value, table_array, column_index_number, range_lookup) in simpler terms we can also say VLookup(ItemtoFind, RangetoFind, ColumntoPickValueFrom, SortedorUnsorted) Example: A B […]