Microsoft-Office

How to use DCOUNTA Function in Excel

With the help of DCOUNTA function you can easily count all those non-blank cells which match the criteria in active database.

Two ways to quickly Autosave Excel file to protect any crashes. Either you can use the code or turn on Autosave feature to protect the file.

Excel Pivot table allows you to manage and summarize excel worksheet data. You can group & ungroup pivot table data row or column wise.

Sometime you need a quick way to add a prefix or suffix to all cells with in a range. Excel allows you to add suffix in range of cells.

Normally you can’t do this job, but Sum array allows you to get the get the sum cells with text & numbers appended in same cell Excel Sheet.

Pivot table allows you to create, add calculated fields, apply formulas, & delete them. You can modify calculated fields in Pivot Table.

Paste special dialog box you can easily paste, copied data in different Paste Special Formats in MS Word and also create paste link.

Lot of text function in MS Excel. If you want to apply any formula on text that you have to use given important text functions of Microsoft Excel.

Trick to split active worksheet in several pages in MS Excel, in different pages to set or print header or footer area.

Sometime you need to add blank rows, Excel allows you to quickly and easily insert a blank row between existing each rows of data in Excel.