This blog is dedicated to Microsoft Excel,excel TIPS.This blog will explain advance Macros(VBA), PIVOT tables, Advanced Filter, CHARTS, complex usage of FUNCTIONS like VLOOKUP, Index, Match, OFFSET,SUMPRODUCT data functions, FILTERS, ChARTS , DYNAMIC charts,SLICERS,Sparklines, DYNAMIC FIlters, Dynamic LISTS, Dynamics Tables....DASHBOARDS....MIS usage of excel with Advance DATA ANALYSTICS
Sunday, 17 July 2011
Subscribe to:
Post Comments (Atom)
Popular Posts
-
Named range are used to ease calculations and save time. Instead of selecting ranges for calculating or to retrieve a search value we can us...
-
We all know that virtually all the windows OS freezes. One quick solution to kill the frozen application to free the resources. we would...
-
:::::TALK TO ME ::::: This file will play an audio and read out the text from string variable stalk following steps will help you create a ...
-
Dynamic list to create a list:: you can select data validation -> list -> select a range of cells as source(you can even you named ra...
-
Tips on windows,Excel, Access, POWERPOINT, VBA
-
We all know that virtually all the windows OS freezes. One quick solution to kill the frozen application to free the resources. we would...
No comments:
Post a Comment