Excel – Impact Analysis – Trace Dependents
The Need: Trace Dependents Excel workbooks are complex. Multiple persons share and handle the same file. We keep mailing them to each other. Often the person who created the file
The Need: Trace Dependents Excel workbooks are complex. Multiple persons share and handle the same file. We keep mailing them to each other. Often the person who created the file
Photo credit: Donald Jusa / Foter / CC BY In today’s world of mobile phones and apps, finding options is becoming more and more difficult. These weird looking symbols have
This is a common problem. Someone has sent a critical message repeatedly and you cannot find it. There are two probable places to find it. Junk Mail or on the
A new way of Filtering Pivot Tables by time is now available (2013) – called Timeline. It allows filtering of one or more pivot tables by years, months and quarters
Another simple but extremely useful action. Press Ctrl key and drag the item to copy it. Works in File Explorer, Desktop icons, Paragraphs, SmartArt, Charts, Pivots, Shapes, Pictures, Videos, Visio
Just one button to press. Data – Remove Duplicate. Data should be a table (or like a table – column headings with data below). If it is a table choose
Lot has been written about it. With Excel 2013, Microsoft did the smartest thing. They added a chart type called Recommended Chart. Now Excel is smart enough to look at
This is a confusing set of features. This is a frequently asked question during my sessions. Read on to find out which one to use when and why. Estimated reading
This feature has been there for over 18 years. But only with 2013 version did it become easy enough for everyone to use it. You will need it someday –
Yes. You use Pivot Tables everyday. Now it is time to find out the real power and nuances. 5.5 hours video, exercises, samples, Q&A.
Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.
