Sumproduct Function

(adsbygoogle = window.adsbygoogle || []).push({}); How does the SUMPRODUCT Function work ?   The SUMPRODUCT function returns the sum of the products of corresponding array components. This means also of range values. Let's check an example of the Sumproduct function: Example: Average values from survey answers Assume that you analyze the answers given to a [...]
By Mark Kelly | Marticles
DETAIL

Excel Calculations

  Below are Solutions to common questions on Excel Calculations asked by our students. Feel  free to comment on them below.   (adsbygoogle = window.adsbygoogle || []).push({}); How to create a random number between 0 and 1 in Excel ?   To create a random number between 0 and 1 in Excel , use the [...]
By Mark Kelly | Marticles
DETAIL

Excel Text function

  Students of our online Excel Course have asked these Excel Text function questions over the years. Below are suggested solutions.Please feel free to comment on this solutions.     (adsbygoogle = window.adsbygoogle || []).push({}); How to convert text to uppercase letters ?   To convert text to uppercase letters -capital letters , use the [...]
By Mark Kelly | Marticles
DETAIL

Vlookup Function

  These are the type of   vlookup function questions   that students of our 'Real Life'  online Excel Course “Workplace Excel” have asked us over  the years. Here in this Vlookup tutorial,  we are going to provide solutions to the most  common of these  questions like vlookup formula not working. (adsbygoogle = window.adsbygoogle || []).push({}); Vlookup [...]
By Mark Kelly | Marticles
DETAIL

Sorting in Excel

    Having problems sorting in Excel.Below are solutions to many of the sorting questions  that users of our  Excel training online course “Workplace Excel” have asked us over over the years from sorting columns in excel, sort by color in Excel and sorting data in Excel. (adsbygoogle = window.adsbygoogle || []).push({}); How to Sort [...]
By Mark Kelly | Marticles
DETAIL

Excel Help

  These are the 20 most popular Excel Help type of  questions  on Excel Layouts that students of our online Excel training Course “Workplace Excel” have asked us over over the years. Here in this article we provide some suggested solutions. (adsbygoogle = window.adsbygoogle || []).push({}); How  to copy Excel Formulas without them changing? A [...]
By Mark Kelly | Marticles
DETAIL

Excel errors

    These are the type of  questions on Excel errors and Excel error Functions  that students of our practical  online Excel training Course “Workplace Excel” have asked us over over the years. Here, we will provide our solutions to these questions. (adsbygoogle = window.adsbygoogle || []).push({}); How to suppress the errors in Excel 2007/2010/ [...]
By Mark Kelly | Marticles
DETAIL

Drop down list excel

  These are the type of  questions on drop down list in Excel that students of our intermediate and advanced online Excel training Course “Workplace Excel” have asked us over over the years.   Here in this article,  we are going to provide solutions to the most  common of these  questions not just how to [...]
By Mark Kelly | Marticles
DETAIL

Data tables Excel

    These are the type of  Excel’s data tables /lists   questions that users  of our online  advanced Excel training Course “Workplace Excel” have asked us over the last three years. Here we are going to provide solutions to how to compare lists and tables, how to deal with duplicates , counting unique values and [...]
By Mark Kelly | Marticles
DETAIL

Excel Data Analysis Tools.

    These are the type of  Excel's basic  data analysis tools  questions that students of our online Excel training Course “Workplace Excel” have asked us over during the  year. Here we are going to provide solutions to the most  common of these  questions,covering the subtotal tool, the advanced filter, Goal seek and Excel's scenario [...]
By Mark Kelly | Marticles
DETAIL
Page 1 of 212