Working Let’s take an example of Sales information which looks as below. We want to summarize sales amount by Screen size by grouping products by Large Display, Small Display & Others. Step 1: Select the Sales table from A1 to G25 Step 2: Go to INSERT Tab Step 3: Click on Pivot Table Step 4:
Subject Line How to Print Headers on All Pages Overview You can print pages in excel using Print option and if the worksheet is more than one page and want the header or top row/rows to be printed then we can use Print Titles option in the page layout option. Same can achieved for repeating
Subject Line Import SQL data in Excel Overview Sometimes you may have to Import data from other sources and not from excel. We can Import data from other sources like SQL Server, Analysis Services, Windows Azure Marketplace, OData Data Feed, XML Data Import, Data Connection Wizard, Microsoft Query. You will learn to Import data from
Overview With the help of Calculation Option you can choose to calculate formulas automatically or manually. If you make a change that affects a value then excel will automatically recalculate it You have 3 Options available in Calculation Options Manual Automatic Automatic Except for Data Tables Working Let’s understand the working with the help of
Subject Line Provide your own Name for range of cells Overview Sometimes you may need to use ranges in formulas which can be simplified by giving the range a name and then using the name in the formula. Name manager is used to create, edit, delete and find all the names used in the workbook.
