online excel course

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 »