Use the form on the right to contact us.
16192 Coastal Highway
Deleware
USA
intellitech.analytics.llc@gmail.com
Intellitech Analytics, LLC provides consultative benchmarking and analytics services for businesses seeking to separate themselves from the pack.
Filtering by Category: Excel Functions
Usually you can use the Cell Format option to change the appearance of the cell contents. But other times you may want to force the contents to be more dynamic. These two functions (CONCATENATE and TEXT) can help you to do just that.
Read MoreLearn who wins your office raffle with this little trick using the RAND function.
Read MoreThe IF function asks a simple question with only two answers. Learn how to extend this to include more than one response.
Read MoreSUMPRODUCT is a useful function when you have an inventory of items with associated costs and you're interested in evaluating the total cost of the list.
Read MoreAt the core of Excel is the ability to perform basic mathematical operations on one of more values. The SUMIF and SUMIFS functions allow you to extend that ability by adding only when certain conditions are met.
Read MoreBecoming an expert in VLOOKUP and the INDEX/MATCH function combo will help you navigate your way through any Excel table.
Read More