Month: February 2014
HOW TO DO A VLOOKUP
Originally posted on Excel in Excel:
VLOOKUP(lookup_value,table_array,col_index_num,range_lookup) lookup_value Cell that contains the value you are looking up (name of employee here) table_array Where is your information located, including identifier…
How can I get PowerPivot add-in?
Originally posted on ThinkLeaf Consulting Ms-Office Resources:
For excel 2013 version, PowerPivot is available only for the below 2 versions: Microsoft Office 365 – Pro Plus Version…
In Excel 2010, how to activate the PowerPivot add-in?
Originally posted on ThinkLeaf Consulting Ms-Office Resources:
Open the folder where you have downloaded your PowerPivot add-in. Double-click the PowerPivot_for_Excel.msi file, and follow the self-guiding steps in…
In Excel 2013, how to activate the PowerPivot add-in?
Originally posted on ThinkLeaf Consulting Ms-Office Resources:
As far as Excel 2013 version is concerned, the add-in is built-in already. But it is not enabled. Here’s how…
Nesting IF and AND Functions in Excel
Originally posted on diplopi:
Short clip showing how to use the nested IF and AND function in Excel 2007. This is an example of a simple formula…
Set Realistic Goals
Originally posted on Navigate Consulting Group's Best Practices Blog:
For some of us, we are just people pleasers. Or workaholics. Overachievers? Perfectionists! However you spin it,…
How to Fetch Access Token in Salesforce
Originally posted on Gagan Bansal:
Scenario: Access Token required to authorize the web service connection. Components Required: One Apex Class (AuthorizationClass). Points to Remember: 1. Content Type…