Excel

Excel related topic to be tagged

5 Date and Time Function in Excel you must know

5 Date and Time Function in Excel

In excel, 5 date and time function in excel are very important as primary data comes in preformatted in date and time format. To analyze data we need to break these preformatted data into our format. Let’s suppose we got data in data and time format to explore this we need to segregate this into a date, month, year, or hour. Let’s understand how to do it by using excel formulas.

How to get the current time in Excel

There are two different ways to get the current time in excel. The first way is to use the formula =NOW() formula in excel. It will give the current time along with date.

5 Date and Time Function in Excel
10
Continue Reading

Oracle SQL developer download : How to install oracle sql developer

SQL developer download

In this article we will be learning sql developer download for windows 10. Oracle sql developer installation is very easy and I will be explaining it in step by step method. We will also be learning how to create connection in SQL developer with SQL database which we learned in our previous article.

how to install oracle sql developer

To install SQL developer we will first go this link the download on Windows 64-bit with JDK 8 included if we don’t have java installed on our system else we can download Windows 32-bit/64-bit.

Oracle SQL developer download
Oracle SQL developer download

We click on the download icon it will redirect to other page for Sign In. If you already have … Continue Reading

How to Install Anaconda for Windows

How to Install Anaconda for Windows

Are you a data geek? Want to know how to install Anaconda for windows. Also want to write your first python or R code with the best distribution platform which arranges code for both.

So I am here with this blog, we will learn about the complete Anaconda setup method (Download and Install Anaconda Python) for Windows.

What Is Anaconda?

Anaconda is a tool that is used in Machine Learning and Data Science. It is a free open source distribution for R and Python Programming Language. It contains the source of software for heavy data processing, data analytics, and many more.

In the below blog, I will be guiding you step-by-step through downloading as … Continue Reading

How to create multiple worksheets from a list of cell values using VBA

How to create multiple worksheets from a list

In our earlier article, we learned about how to create multiple worksheets in excel without using VBA. In this article, we will be learning How to create multiple worksheets from a list of cell values using VBA.

First, we will create a list of names that we wanted to name the worksheets.

How to create multiple worksheets from a list of cell values using VBA
How to create multiple worksheets from a list of cell values using VBA

After making the list we will select the range as our VBA code will work on the selection method.

Sub AddWorksheetsFromSelection()
Dim Ws As Worksheet
Dim Sr As Range
Dim c As Range

Sub AddWorksheetsFromSelection()
    Dim Ws As Worksheet
    Dim Sr As Range
    Dim c 
Continue Reading

How to create multiple worksheets from a list of cell values without VBA

Creating Worksheets from a List of Names

Creating multiple worksheets from a list of values is very easy and it could be created by multiple methods. In this article, we will explore ways of creating it by using the following method. Though manually creating worksheets will be very time-consuming and using some tricks could make easy the task.

The first step in creating the task is to list all the values that we wanted to name the worksheets.

list the names for the worksheet
list the names for the worksheet

After listing the name insert a pivot table by using the newly created list as data range. After inserting the pivot table put the name of worksheet column in pivot table Filter as illustrated in the … Continue Reading

How to create a dynamic table in excel to summarize data

Creating a dynamic table in excel

In this example, we will be creating a dynamic table in excel from a dataset. The dataset has 3 columns out of these three 2 are categorical values while the third is numerical. Now we wanted to create a dynamic table that will have these two columns as rows and columns. Also, we wanted to summarise our data by as count of entries of these two categorical columns. Dataset is illustrated in the below image.

Creating a dynamic table in excel
Creating a dynamic table in excel

To create this kind of excel dynamic table we will first convert our dataset into the excel table. You must be wondering why we are converting this into the table, this is because … Continue Reading

What is SQL

Introduction to SQL language

SQL is a programming language that is used to manage data stored in a relational database management system (RDBMS).

SQL pronounced as /ˈɛs kjuː ˈɛl/ or /ˈsiːkwəl/. SQL full form is Structured Query Language.

SQL has three components:

  • Data Defination Language (DDL): The data definition language deals with the schema/Table/View creation and modification like, CREATE TABLE statement allows us to create a new table in the database and the ALTER TABLE statement helps in changing the structure of an existing table.

  • Data Manupulation Language(DML): The data manipulation language helps to query data such as the SELECT statement and to update the data such as INSERTUPDATE, and DELETE statements.

  • Data Control Language (DDL): The
Continue Reading

New Excel Functions in Excel 2021: 5 Awesome Excel formulas

New Excel Functions in Excel 2021

Every time when Microsoft excel launches a new version new excel functions are also been added there. Excel 2021 also has new functions like  FILTER, SORT, SORT BY, UNIQUE, SEQUENCE. These all excel functions help us reducing our processing time. Let us see in brief what these functions are and how they work. Let us go through these New Excel Functions in Excel 2021.

FILTER function in excel

Excel FILTER function allows us to filter a range of data from a dataset based on some criteria. It is one of the New Excel Functions in Excel 2021. Let us understand first the syntax of Filter formula excel.

New Excel Functions in Excel 2021
New Excel Functions in Excel
Continue Reading

Project Charter: What is a six sigma project charter and how to create it in 7 steps[Free download]

What is project charter in six sigma

Project charter in six sigma very important requirement for the project. It is a living document for the project and it lays out every important project variable. The creation of a project charter is one of the first steps in six sigma project. It is a part of the Define phase of DMAIC process. This includes everything from who is participating in the project, to the project goals. Let us take few minutes to understand the different components of project charter step by step.

Step-1: Defining the project name

The very step in making a Project Charter is to name the project. The project name should reflect what the project is looking … Continue Reading

Flash fill in excel: Everything You Need To Know About Flash Fill In Microsoft Excel [5 Examples]

Flash fill in excel

What is Flash fill in excel?

Flash Fill is a data tool in Microsoft Excel that allows us to combine, extract or transform data based on a few examples. We only need to provide a couple of examples of the results we want, excel will guess the pattern and fill in the rest of the data for us.

What is Flash fill in excel?
What is Flash fill in excel?

In the above gif file, we can see that we only provided one row of input, and after using Flash fill it automatically separates values.

How to Enable Flash Fill in Excel?

To enable flash fill in excel go to File then Options. After that select Advanced and … Continue Reading