microsoft excel course

Pareto Chart

Pareto charts are extremely useful for analyzing what problem needs attention first, the taller bars on the chart, which represent frequency and the line shows the cumulative frequency percentage. The Pareto principle (also known as the 80/20 rule), states that, for many events, roughly 80% of the effects come from 20% of the causes. Let’s …

Pareto Chart Read More »

Custom Number Formatting

Custom Number Formatting- Sometimes when you download or import any data into Excel, its formatting looks weird. Dates get converted to numbers or Numbers are showing in scientific characters (2.34568E+12), Decimal points, Currency symbols, convert number into percentage, friction, Text format etc. For these unexpected formats we have a listed options available in under “Number …

Custom Number Formatting Read More »

Microsoft Updates six new Excel functions in Office 365

Hi, In February, Microsoft office has introduced Office 365. In this version, Microsoft introduced Six new functions which are more useful in the calculation and can save your time. In this article, you’ll learn how to use Excel’s new function to create more efficient expressions. Six new formulas are listed below- 1-      TextJoin 2-      IFS 3-      MaxIFs 4-      MinIfs …

Microsoft Updates six new Excel functions in Office 365 Read More »

Sales Dashboard

Hi All, Dashboard- Dashboard is one platform that helps management in tracking Performance, evaluation and help them to take a decision based on it. A dashboard is often called a report, however, not all reports are in the dashboard. Now that we understand what a dashboard is, let’s dive in and learn how to create a …

Sales Dashboard Read More »