Excel
How to Add, Subtract, Multiply, Divide in Excel
In this tutorial, we are going to perform basic arithmetic operations i.e. addition, subtraction,...
In this tutorial, we are going to import data from a SQL external database. This exercise assumes you have a working instance of SQL Server and basics of SQL Server.
First we create SQL file to import in Excel. If you have already SQL exported file ready, then you can skip following two step and go to next step.
USE EmployeeDB GO CREATE TABLE [dbo].[employees]( [employee_id] [numeric](18, 0) NOT NULL, [full_name] [nvarchar](75) NULL, [gender] [nvarchar](50) NULL, [department] [nvarchar](25) NULL, [position] [nvarchar](50) NULL, [salary] [numeric](18, 0) NULL, CONSTRAINT [PK_employees] PRIMARY KEY CLUSTERED ( [employee_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO INSERT INTO employees(employee_id,full_name,gender,department,position,salary) VALUES ('4','Prince Jones','Male','Sales','Sales Rep',2300) ,('5','Henry Banks','Male','Sales','Sales Rep',2000) ,('6','Sharon Burrock','Female','Finance','Finance Manager',3000); GO
Once you are connected to the database server. A window will open, you have to enter all the details as shown in screenshot
It will open a data connection wizard to save data connection and finish the process of connecting to the employee's data.
Download the SQL and Excel File
In this tutorial, we are going to perform basic arithmetic operations i.e. addition, subtraction,...
Graphics, images, and charts are great ways to visualize and represent the data, and Excel does...
Training Summary Excel is the most powerful tool to manage and analyze various types of Data. This...
In this tutorial, we are going to import data from a simple external database powered by Microsoft Access...
Microsoft Office is a collection of office-related applications that are used to create documents,...
What is SUMIF Function? SUMIF is the function used to sum the values according to a single...