EXCEL SEQUENCE FUNCTION

The Excel SEQUENCE function generates a list of sequential numbers in an array. The array can be dimensional, or two-dimensional, determined by rows and columns arguments.  Purpose  Get an array of a list of sequential numbers Result An array of sequential values Arguments  rows - Number of rows to return. columns - [optional] Number of columns to...
Read More

Data Financial Analysis

You can perform financial analysis with Excel in an easy way. Excel provides you several financial functions such as PMT, PV, NPV, XNPV, IRR, MIRR, XIRR, and so on that enable you to quickly arrive at the financial analysis results. In this chapter, you will learn where and how you...
Read More

HOW TO CREATE A PIE CHART IN POWER BI

A pie chart is a circular statistical graphic often used in business showing percentages of types of customers, percentages of revenue from different products, and profit from a different department in an organization. First step; get data into power bi click on the get data ribbon on the power bi...
Read More

Cybersecurity Certification Costs

Cybersecurity (sometimes called computer security or information security) is the practice of protecting computers, networks, and data from theft, damage, loss, or unauthorized access. Organizations are prone to cybersecurity threats globally than ever before. Company resources are highly exposed to data breaches and systematic hacks, and this trend is only...
Read More

Cybersecurity salaries in different Global Companies

IBM’s annual Cost of a Data Breach study revealed a single data breach can cost a company up to $3.29 million, a 12 percent increase from the cost of breaches from the previous year. Add to this the devastating impact cyberattacks have had on corporations like Equifax, Facebook, and T-Mobile and there’s no wonder businesses are paying...
Read More

Excel FILTER Function

The Excel FILTER function filters a range of data based on supplied criteria and extracts matching records. Purpose  Filters range with given criteria Return value  Array of filtered values Syntax  =FILTER (array, include, [if_empty]) Arguments  array - Range or array to filter. include - Boolean array, supplied as criteria. if_empty - [optional] Value...
Read More

Creating Relationships between Tables

If you want to make calculations across the tables, you have to first define relationships among them. Click the Home tab on the Ribbon in the PowerPivot window. As you can observe, the tables are displayed in the Data View. Click Diagram View. The tables appear in the Diagram View....
Read More

Difference Between Cybersecurity and Ethical Hacking

First, let’s understand the term Cyber Security in detail, and then, we will discuss Cyber Security vs Ethical Hacking. What is Cyber Security? Cyber Security is a combination of different skills and tools, which combines together to provide the best security environment to users. Cyber security is the practice to...
Read More

10 Best Cybersecurity Certifications

Cybersecurity is a rapidly growing field, with a projected 33% market growth from 2020-2030. Considering the average for other industries is 8% – that’s pretty significant! And it’s no wonder, considering the rise of data breaches, including government hackers seeking important data.  Looking for a career change? There’s no better...
Read More

Creating Data Model while Importing Data

When you import data from relational databases like Microsoft Access database that contain multiple related tables, Data Model is automatically created if you import more than one table at once. You can optionally add tables to the Data Model, when you import data from the following data sources − Relational...
Read More

EXCEL SUMPRODUCT FUNCTION

The Excel SUMPRODUCT function multiplies ranges or arrays together and returns the sum of products. This sounds boring, but SUMPRODUCT is an incredibly versatile function that can be used to count and sum like COUNTIFS or SUMIFS, but with more flexibility. Other functions can easily be used inside SUMPRODUCT to extend functionality...
Read More

XLOOKUP FUNCTION IN EXCEL

The Excel XLOOKUP function is a modern and flexible replacement for older functions like VLOOKUP, HLOOKUP, and LOOKUP.  XLOOKUP supports approximate and exact matching, wildcards (* ?) for partial matches, and lookups in vertical or horizontal ranges. Purpose  Lookup values in range or array Return value  Matching value(s) from return...
Read More

No Internal Rate of Return

In certain cases, you may not have IRR. Consider the following cash flows. Calculate IRR with different guess values. You will get the result as #NUM for all the guess values. The result #NUM means that there is no IRR for the cash flows considered. Cash Flows Patterns and IRR...
Read More

Internal Rate of Return (IRR)

Internal Rate of Return (IRR) of an investment is the rate of interest at which NPV is 0. It is the rate value for which the present values of the positive cash flows exactly compensate the negative ones. When the discount rate is the IRR, the investment is perfectly indifferent,...
Read More

How to Create a Dashboard in Excel

What Is a Dashboard? Dashboards track KPIs, metrics, and other data points in one visual, central place. They give you a high-level view of work, helping you make quick decisions and keeping everyone up to date. A dashboard’s visual nature simplifies complex data and provides an at-a-glance view of current...
Read More

Creating an Interactive Report (Inquire )

You can use the Workbook Analysis command to create an interactive report that can show detailed information about the workbook and its Structure, Formulas, Cells, Ranges and Warnings. Click the Inquire tab on the Ribbon. Click Workbook Analysis in the Report group. The report will be displayed after the Workbook Analysis is...
Read More

Excel Data Analysis – Inquire

You can use Inquire to − Compare two workbooks. Analyze a workbook for problems or inconsistencies. View the links between workbooks. View the links between worksheets. View the relationships between cells. Clean excess cell formatting. Manage passwords. The INQUIRE tab will be on the Ribbon. If you find the INQUIRE...
Read More

Cleaning Data with Text Functions

The data that you obtain from different sources may not be in a form ready for analysis. You will understand how to prepare your data that is in the form of text for analysis. Initially, you need to clean the data. Data cleaning includes removing unwanted characters from text. Next,...
Read More

Date Function in Excel

The Excel DATE function creates a valid date from the individual year, month, and day components. The DATE function is useful for assembling dates that need to change dynamically based on other values in a worksheet. Purpose  Create a date with year, month, and day Return value  A valid Excel...
Read More

How To Put Quotation Marks In Excel Formulas

When you add text in a formula in Excel, you have to enclose the text with quotation marks (”…”).  This is useful when you want to create a dynamic string that changes based on some conditions.  But what happens when you want to put quotation marks as part of the...
Read More
1 2 3 34