Tag Archive


accdb repair access recovery access repair Contacts corrupt Outlook corrupt PST damaged Outlook damaged PST Data Backup Data Loss Data Recovery excel recovery Excel tips Excel VBA Hard Drive inbox repair tool mdb repair mdf recovery MDF repair Ms Access outlook contacts Outlook corruption Outlook Email outlook recovery Outlook repair outlook VBA PST corruption pst recovery pst repair Quick Access Toolbar recover access recover outlook recover PST recover sql repair access repair excel repair outlook repair pst ScanPST SQL recovery SQL Server sql server recovery VBA View Settings Word Macro

How to Open and Populate Template with Excel VBA

Excel Templates are typically workbooks, with a reporting framework, often supported by functions. A templates (xltx) can be used over and again without polluting it with data. After population with data, a template workbook is saved as an xlsx, preserving the virgin state of the xltx itself. In this exercise we will use VBA code  […]

How to Import and Analyze Your Bank Statements in Excel

Unlike others, do not spend too much time and efforts in tracking your expenses. Follow this article and build your own income and expense tracker. This tool accepts your bank statements in an Excel format and then reads it to let you know where you have spent more. Let’s Prepare the GUI The tool needs […]

How to Use the Different Count Functions in Excel

Count functions are the most frequently used functions in Excel. In this article, we will discuss about the different 5 count functions in detail. There are 5 variants of count functions: COUNT, COUNTA, COUNTBLANK, COUNTIF and COUNTIFS. Below we will talk about their usages in detail. 1.      COUNT The COUNT function counts the numbers of […]