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.
Subject Line Colourful Comparative View of Data Overview Sometimes you may want to compare data by using colours. Heat map is a visual display that quickly shows you a comparative view of the data with the use of colors. To create a heat map you have to use conditional formatting. Conditional formatting includes the below
