If Function in Excel

The Excel IF function runs a logical test and returns one value for a TRUE result, and another for a FALSE result. For example, to "pass" scores above 70: =IF(A1>70,"Pass","Fail"). More than one condition can be tested by nesting IF functions.  Purpose  Test for a specific condition Return value  The...
Read More

Excel Data Analysis – Subtotals with Ranges

Excel Data Analysis - Subtotals with Ranges If you have a list of data that you want to group and summarize, you can use Excel Subtotal and Outline to display summary rows or columns. You can use PivotTable also for this purpose, but using Subtotal and Outline is the quickest way to analyze a range of data. Note that Subtotal and Outline can be...
Read More

Excel TIMEVALUE Function

The Excel TIMEVALUE function converts a time represented as text into a proper Excel time. For example, the formula =TIMEVALUE("9:00 AM") returns 0.375, the numeric representation of 9:00 AM in Excel's time system. Numeric time values are more useful than text since they can be directly manipulated with formulas and...
Read More

Excel DATEVALUE Function

The Excel DATEVALUE function converts a date represented as a text string into a valid excel date. For example, the formula =DATEVALUE("3/10/1975") returns a serial number (27463) in the Excel date system that represents March 10, 1975. Proper Excel dates are more useful than text dates since they can be directly manipulated...
Read More

Excel TRANSPOSE Function

The Excel TRANSPOSE function "flips" the orientation of a given range or array: TRANSPOSE flips a vertical range to a horizontal range, and flips a horizontal range to a vertical range. Purpose  Flip the orientation of a range of cells Return value  An array in a new orientation. Syntax  =TRANSPOSE...
Read More

How To Remove Duplicates And  Converting Table to Range

When you gather data from different sources, you probably can have duplicate values. You need to remove the duplicate values before going further with the analysis. Look at the following data where you have information about various products of various brands. Suppose, you want to remove duplicates from this data....
Read More

Table Name In Excel

Table Name Excel assigns a name to every table that is created. Step 1 − To look at the name of the table you just created, click table, click on table tools – design tab on the Ribbon. Step 2 − In the Properties group, in the Table Name box, your Table Name will be displayed. Step 3 −...
Read More

How To Create Table In Excel

TABLE IN EXCEL A Table is a rectangular range of structured data. The key features are − Each row in the table corresponds to a single record of the data. Example - Employee information.Each column contains a specific piece of information. Example - The columns can contain data such as name, employee...
Read More

How to use SUM function in excel

The Excel SUM function returns the sum of the values supplied. These values can be numbers, cell references, ranges, arrays, and constants, in any combination. SUM can handle up to 255 individual arguments. Purpose  Add numbers together Return value  The sum of values supplied. Syntax  =SUM (number1, [number2], [number3], ...)...
Read More

How to create Macros In excel

HOW TO CREATE MACROS IN EXCEL With Excel VBA you can automate tasks in Excel by writing so-called macros. In this chapter, learn how to create a simple macro that will be executed after clicking on a command button. First, turn on the Developer tab. Developer Tab To turn on the Developer tab, execute...
Read More

Top Reasons why you should use Power BI

According to Microsoft, “Power BI is a business analytics solution that lets you visualise your data, share insights across your organisation, or embed them in your app or website.” It is a collection of products and services for individuals and teams in the areas of business intelligence (BI), reporting, and data...
Read More

Microsoft Power BI Features

Reasons Why Power BI is a Leader in its Field! What is Microsoft Power BI? Microsoft Power BI is a suite that is a collection of business intelligence tools such as software services, apps and data connectors. It is a cloud-based platform used to consolidate data from varied sources into...
Read More

PowerBI: Introduction

What is Power BI? Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. Your data may be an Excel spreadsheet, or a collection of cloud-based and on-premises hybrid data warehouses. Power...
Read More

Best WordPress Theme Builders

Searching for the best WordPress theme builder? With a theme builder, you can design a responsive website using drag-and-drop. This is a great solution if you can’t find an off-the-rack theme that you like, or if you just plain want more flexibility to build your or your clients’ sites. You’re...
Read More

Battle of Giants: CorelDraw vs Illustrator

CorelDraw and Illustrator are two massively popular graphic design software. If you are starting up a new project and you are having a hard time figuring out which of the two software will work best for you. As they almost seem similar, this CorelDraw vs Illustrator differences guide will help...
Read More

CorelDraw 2022: What’s New?

Releasing a new update to the CorelDraw 2022, coreldraw inc has added some new features to make it so much better than the other versions. Some of the Major updates are: NEW! Adjustment PresetsNEW and ENHANCED! Adjustments docker/inspectorNEW and ENHANCED! Adjust menuAdjustments docker performance up to 10x fasterENHANCED! Multipage view...
Read More

Top In-Demand IT Skills in 2022

Over the years, we can see a steady trend: the quality of talents improves. To stay competitive in a talent market, it’s not enough to be competent in a specific area. However, with hands-on IT skills on a CV, candidates can outshine the other talents. IT pros must actively acquire...
Read More

Is Tableau better than Microsoft PowerBI?

Tableau is built for data analysts, while Power BI is better suited to a general audience that needs business intelligence to enhance their analytics.Power BI comes at a lower price point than Tableau, but scaled features and additional users will increase that price. The world of data visualization and analytics...
Read More

What are the differences between coding and programming?

These both look like they are pointing towards the same thing. But really it doesn’t mean it, they are two different terms for a software developer who actually works with real-world problems.  In real Programming is a superset of Coding. That means every element of Coding is a part of...
Read More

What are the uses of a spreadsheet in Excel?

Spreadsheets are an essential business and accounting tool. They can vary in complexity and can be used for various reasons, but their primary purpose is to organize and categorize data into a logical format. Once this data is entered into the spreadsheet, you can use it to help organize and...
Read More
1 2 3 32