Search

Advertisements

Showing posts with label Excel. Show all posts
Showing posts with label Excel. Show all posts

Excel - Separate the contents of one cell into separate columns

This articles is about separating the contents in one cell into separate columns in excel .


Suppose we are copying text from notepad as shown below :

Excel - Transpose Rows and Columns

In Excel , we can transpose rows into columns and vice versa  .

Copy the rows or columns to be transposed , while pasting - > Paste Special ...

Check the option Transpose as shown below :

Excel - How to Sort rows in the Pivoted table

In my previous post , I explained about adding Pivot table and chart .

If you click on the drop-down arrow of Row Label , you will find the sort options as shown below :


Excel - How to add Pivot Table and chart

In Excel , We can find PivotTable  and PivotChart options - > Under Insert tab - > PivotTable


How to add Pivot Table ?


Excel - How to pull data from SQL Server

This article is about pulling data from SQL Server into Excel sheet .

Open Excel - > Under Data tab - > From Other Sources - > click the drop-down - >  click on From SQL Server .





Advertisements