This is a simple, useful but unknown feature available in Office. Documents containing passwords, important numbers should be protected from inadvertent changes using the Mark as Final feature.
Please read the first part of this article – High Impact Presentations: Using Gradient
Fun with gradients continues in this article. I will cover nuances of the gradients like direction, angle, color stops, brightness, transparency. Finally we will see how to apply all this knowledge practically using common scenarios.
Gradient is a smooth transition from one color to another color. It is a simple concept. Rarely used properly, but misused often. The technology is simple, but effective usage is not.
Let us explore why we should use gradients and how to use them with finesse. This article is for Office versions 2010 and above. The concepts shown here work across all Office tools.
Many people ask me – “You teach so many people, but how do you learn?”
I will post specific details on learning methodology later. But periodically, I post this type of blog which lists down new things which I learnt recently. These are not specific to a particular topic. Random assortment.
This is the third article in this series. Please read these articles as well:
Auditors, Risk Managers: Excel spreadsheet analysis using the new Inquire tool
Spreadsheet Analysis using Inquire – Relationship Diagrams
Spreadsheet Risk is very important for everyone – from a single user to a large organization. Because an interpretation mistake or a wrong value can be very costly indeed.
In this article we will see how to compare two spreadsheets. Using the old method and the new amazing tool which comes with Office 2013.
Please read this article first: Auditors, Risk Managers: Excel spreadsheet analysis using the new Inquire tool
In this article, we discuss how to use the Relationship Diagrams using Inquire tool.
These two roles require extensive work with complex workbooks. Auditors need to understand and validate large, complex workbooks in a time bound manner. Risk managers work with complex models with large data sets. They want to implement Spreadsheet Controls in place to reduce the operational risk originating from spreadsheet errors. In either case, you need to understand, validate and troubleshoot spreadsheets in a time bound manner.
In this article, I am not going to cover the regular features of native Excel which include GoTo Special, Trace Precedents, Watch Window, Evaluate Formulas and so on.
Since Office 2013, Microsoft introduced a new add-in called Inquire tool– which is very powerful. But still many people do not know about it. We will explore this tool in this article.
Read the the article Consolidating crosstab data before reading this article.
In this article we understand how we can use Multi-column, Row Heading Cross Tab data consolidation using Power Query.
This is a continuation of the Data Cleanup series. One common form of bad data is called crosstab. Consolidating crosstab data requires lot of manual effort. Pivot – Multiple Consolidation Ranges is a fantastic feature available in Excel which can do this job in a snap. Here is an example of cross tab data…
Let us see how to get this done.
This is a post for developers or those who know PowerShell Script. To understand the context, please read these two posts… This article and the code is contributed by Raj Chaudhuri – my friend and Microsoft platform expert.