--- description: Read useful articles in Excel solutions category, including solutions, tips, how-to guides, introduction, overview and other resources. title: Excel Solutions Archives - Page 13 of 23 --- - - - [Home](https://www.datanumen.com/blogs/) > [Solutions](https://www.datanumen.com/blogs/category/solutions/) > [Office Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/) > Excel Solutions (Page 13) # Excel Solutions ### [How to Open and Populate Template with Excel VBA](https://www.datanumen.com/blogs/open-populate-template-excel-vba/) [Excel Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/) October 3, 2025 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,... [**Read more »**](https://www.datanumen.com/blogs/open-populate-template-excel-vba/) ### [How to Make a Multiple Choice Exam Sheet in Excel](https://www.datanumen.com/blogs/make-multiple-choice-exam-sheet-excel/) [Excel Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/) October 3, 2025 As a trainer, you would have conducted several seminars to your students. Now it's time that you share an Excel workbook with your students which will help you to identify how much they have understood. Prepare multiple choice digital exam sheet by... [**Read more »**](https://www.datanumen.com/blogs/make-multiple-choice-exam-sheet-excel/) ### [How to Import and Analyze Your Bank Statements in Excel](https://www.datanumen.com/blogs/import-analyze-bank-statements-excel/) [Excel Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/) October 3, 2025 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... [**Read more »**](https://www.datanumen.com/blogs/import-analyze-bank-statements-excel/) ### [How to Create an Automated Shopping Cart in Excel Workbook](https://www.datanumen.com/blogs/create-automated-shopping-cart-excel-workbook/) [Excel Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/) October 3, 2025 Take your customer satisfaction to the next level. Add your product information along with the price in an Excel workbook and create a shopping cart for your business. All you have to do is share this workbook with your customers and let them select... [**Read more »**](https://www.datanumen.com/blogs/create-automated-shopping-cart-excel-workbook/) ### [How to Convert UTM Coordinates into Latitude and Longitude values via Excel VBA](https://www.datanumen.com/blogs/convert-utm-coordinates-latitude-longitude-values-via-excel-vba/) [Excel Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/) October 3, 2025 With UTM converter you can easily convert UTM coordinates into Latitude and Longitude values. A Universal Transverse Mercator (UTM) coordinate is made up of a zone number, an easting, a northing and a hemisphere (N/S). Download Now If you want to... [**Read more »**](https://www.datanumen.com/blogs/convert-utm-coordinates-latitude-longitude-values-via-excel-vba/) ### [How to Create a WHOIS Lookup Tool via Excel VBA](https://www.datanumen.com/blogs/create-whois-lookup-tool-via-excel-vba/) [Excel Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/) October 3, 2025 Using Excel you can easily build your own whois lookup tool. This tool will help website developers or hosting companies to convert domains into leads. This tool displays name of people or organizations owning different domains. Download Now If... [**Read more »**](https://www.datanumen.com/blogs/create-whois-lookup-tool-via-excel-vba/) ### [How to Create a Geographic Tool to Get Latitude and Longitude Coordinates for Addresses with Excel VBA](https://www.datanumen.com/blogs/create-geographic-tool-get-latitude-longitude-coordinates-addresses-excel-vba/) [Excel Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/) October 3, 2025 Follow this article and build your own geographic tool with which you can get the latitude and longitude coordinates for an address.  Converters like this are commonly used by Real estate brokers. Download Now If you want to start to use the... [**Read more »**](https://www.datanumen.com/blogs/create-geographic-tool-get-latitude-longitude-coordinates-addresses-excel-vba/) ### [How to Create Your Own Expense Manager via Excel VBA](https://www.datanumen.com/blogs/create-expense-manager-via-excel-vba/) [Excel Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/) October 3, 2025 This article will help you to create simple and easy to use Expense manager. Now you can log and track all your incomes, expenses and keep a track of your balances. Download Now If you want to start to use the software as soon as possible, then... [**Read more »**](https://www.datanumen.com/blogs/create-expense-manager-via-excel-vba/) ### [How to Create Your Own Resume Reader with Excel VBA](https://www.datanumen.com/blogs/create-resume-reader-excel-vba/) [Excel Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/) October 3, 2025 Large companies use costly software to scan resumes using their custom built keywords list to find candidates for all open positions in their company. If you are a small consultancy firm and if you are still scanning your resumes manually, do not... [**Read more »**](https://www.datanumen.com/blogs/create-resume-reader-excel-vba/) ### [How to Create a vCard (.vcf File) Reader with Excel VBA](https://www.datanumen.com/blogs/create-vcard-vcf-file-reader-excel-vba/) [Excel Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/) October 3, 2025 Have you ever wanted to import contact details from VCF data in to an Excel sheet? Follow this article and create your own VCF reader that would import data from your VCF files into Excel worksheets Download Now If you want to start to use the... [**Read more »**](https://www.datanumen.com/blogs/create-vcard-vcf-file-reader-excel-vba/) Page 13 of 23 [« First](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/) [‹ Previous](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/page/12/) [9](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/page/9/) [10](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/page/10/) [11](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/page/11/) [12](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/page/12/)13 [14](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/page/14/) [15](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/page/15/) [16](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/page/16/) [17](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/page/17/) [Next ›](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/page/14/) [Last »](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/page/23/) ![Data Recovery Blog]() Follow or like us on Facebook, LinkedIn and Twitter to get all promotions, latest news and updates on our products and company. - - - ### Featured Products - [DataNumen Outlook Repair](https://www.datanumen.com/outlook-repair/) - [DataNumen SQL Recovery](https://www.datanumen.com/sql-recovery/) - [DataNumen Exchange Recovery](https://www.datanumen.com/exchange-recovery/) - [DataNumen Access Repair](https://www.datanumen.com/access-repair/) - [DataNumen Excel Repair](https://www.datanumen.com/excel-repair/) - [DataNumen PDF Repair](https://www.datanumen.com/pdf-repair/) - [DataNumen Word Repair](https://www.datanumen.com/word-repair/) - [DataNumen Zip Repair](https://www.datanumen.com/zip-repair/) ### Popular posts ```json {"@context":"https:\/\/schema.org","@graph":[{"@type":"CollectionPage","@id":"https:\/\/www.datanumen.com\/blogs\/category\/solutions\/office-solutions\/excel-solutions\/","url":"https:\/\/www.datanumen.com\/blogs\/category\/solutions\/office-solutions\/excel-solutions\/page\/13\/","name":"Excel Solutions Archives - Page 13 of 23","isPartOf":{"@id":"https:\/\/www.datanumen.com\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.datanumen.com\/blogs\/category\/solutions\/office-solutions\/excel-solutions\/page\/13\/#primaryimage"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/category\/solutions\/office-solutions\/excel-solutions\/page\/13\/#primaryimage"},"thumbnailUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2017\/03\/insert-a-pivot-table-at-A1-of-the-data-sheet.jpg","description":"Read useful articles in Excel solutions category, including solutions, tips, how-to guides, introduction, overview and other resources.","breadcrumb":{"@id":"https:\/\/www.datanumen.com\/blogs\/category\/solutions\/office-solutions\/excel-solutions\/page\/13\/#breadcrumb"},"inLanguage":"en-US"},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.datanumen.com\/blogs\/category\/solutions\/office-solutions\/excel-solutions\/page\/13\/#primaryimage","url":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2017\/03\/insert-a-pivot-table-at-A1-of-the-data-sheet.jpg","contentUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2017\/03\/insert-a-pivot-table-at-A1-of-the-data-sheet.jpg","width":926,"height":591,"caption":"Insert A Pivot Table At A1 Of The “Data” Sheet"},{"@type":"BreadcrumbList","@id":"https:\/\/www.datanumen.com\/blogs\/category\/solutions\/office-solutions\/excel-solutions\/page\/13\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Solutions","item":"https:\/\/www.datanumen.com\/blogs\/category\/solutions\/"},{"@type":"ListItem","position":2,"name":"Office Solutions","item":"https:\/\/www.datanumen.com\/blogs\/category\/solutions\/office-solutions\/"},{"@type":"ListItem","position":3,"name":"Excel Solutions"}]},{"@type":"WebSite","@id":"https:\/\/www.datanumen.com\/blogs\/#website","url":"https:\/\/www.datanumen.com\/blogs\/","name":"Data Recovery Blog","description":"Discuss every aspect of data recovery","publisher":{"@id":"https:\/\/www.datanumen.com\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.datanumen.com\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.datanumen.com\/blogs\/#organization","name":"Data Recovery Blog","url":"https:\/\/www.datanumen.com\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2019\/02\/logowithouttext.jpg","contentUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2019\/02\/logowithouttext.jpg","width":296,"height":397,"caption":"Data Recovery Blog"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataNumen","https:\/\/x.com\/DataNumen","http:\/\/www.linkedin.com\/company\/datanumen","https:\/\/myspace.com\/datanumen\/","http:\/\/www.pinterest.com\/datanumen\/","https:\/\/www.youtube.com\/channel\/UCVIIuuKfUBHSJauUaVP13tw"]}]} ```