# Talon Computer Associates > Excel Customizations > Generated by All in One SEO Pro v5.0.4, this is an llms.txt file, used by LLMs to index the site. ## Sitemaps - [XML Sitemap](https://taloncorp.com/sitemap.xml): Contains all public & indexable URLs for this website. ## Posts - [Customer Solutions](https://taloncorp.com/blog/): View news and tips relating to Excel automation, business intelligence and integration. - [Analyze PDF Files in Excel](https://taloncorp.com/analyze-pdf-files-in-excel-2/): Discover how Power Query and VBA can transform complex PDFs into actionable Excel data, streamlining business analysis from 60 pages to insights. - [Supporting your growing business](https://taloncorp.com/50019-2/): Here’s a situation we run into with our client. Someone builds a model in Excel and it works great. Time goes by and the business grows. That single workbook gets copied for the new customer/division/business unit. Quite a bit of manual work is needed to make it work with the new data. Then another is - [Franklin Knows Best](https://taloncorp.com/franklin-knows-best/): Find out how Talon can make those reports accurate and quicker to run. Give us a call to set up a time to review those reports. - [Don't Be Bound by a Sluggish System!](https://taloncorp.com/dont-be-bound-by-a-sluggish-system/): Our client had a 15 year old program that uses Excel for the user interface and Access to store the data. The company is expanding and the program was running slow and running out the space. We migrated the data from Access to SQL Server. This effectively removes the size constraint and make the queries - [Will Excel go away?](https://taloncorp.com/will-excel-go-away/): Core Values | - [Adding integrity to an Excel based quote process](https://taloncorp.com/adding-integrity-to-an-excel-based-quote-process/): Adding integrity to an Excel based quote process We have a client who needed to track sales quotes, who did them, how much, the status, etc. They were using Excel and emailing the files to each other. They liked the layout they were using, it was just too hard to keep track of all the quotes. Because everyone connected to the network through - [Update PowerPoint from Excel using a Database and Excel](https://taloncorp.com/updating-powerpoint-slides-from-a-database-and-excel/): Update PowerPoint from Excel using a Database and Excel - [Merging Inventory Lists](https://taloncorp.com/creating-solutions-with-vba-code/): Here’s how we resolved a recent customer’s project. Customer’s Current Situation - The client receives updated inventory lists from a variety of customers. They need to be reviewed and validated before uploading into the client ‘system. They had to first move the columns to fit, then look through the list to validate the information. Talon’s ## Pages - [Home](https://taloncorp.com/): Talon Computer Associates provides Excel customization, automation, VBA and business intelligence. Let us make your team more efficient. - [Privacy Policy](https://taloncorp.com/privacy-policy/): Who we are Our website address is: https://taloncorp.com. Comments When visitors leave comments on the site we collect the data shown in the comments form, and also the visitor’s IP address and browser user agent string to help spam detection. An anonymized string created from your email address (also called a hash) may be provided - [Services](https://taloncorp.com/services/): View our excel automation services. We are a Microsoft Certified Partner located in Laguna Niguel, CA. Make your business more efficient today. - [Testimonials](https://taloncorp.com/testimonials/): Talon did a great job of reviewing/updating existing macros and developing word and excel macros under a tight timeline and developed effective documentation of the process so it could be replicated in the future. The purpose of the macros was to take the output from our existing accounting/project management processes and separate word documents to I have used Talon Computer Associates since 1999 to create user-friendly dashboards that turn raw data into findings, conclusions, insights and sales growth recommendations. The Talon team takes Excel and uses its hidden power to generate functionality at a fraction of the cost of most IT consulting firms. High level of user satisfaction!!!ead testimonials and reviews of our Excel Development Services. Our business automation and VBA reviews from our clients speak to the quality of work we provide. - [About](https://taloncorp.com/about/): Talon Computer Associates is a Microsoft Certified Partner specializing in automation, integration and business intelligence. Based in Laguna Niguel, CA. - [Contact](https://taloncorp.com/contact/): Contact our team today to start your next Excel project or automation project. Located in Laguna Niguel, CA, we're ready to serve anywhere in the nation. ## Categories - [Project spotlight](https://taloncorp.com/category/uncategorized/): In today’s data-driven landscape, extracting valuable information from PDF files is a common challenge. We often encounter PDFs that contain structured data we would love to analyze in Excel. Our client had a 60-page PDF that he needed answers from the data to run his business. The PDF file looks like data, spanning 60-pages. Power Query allows us to import those PDF tables into Excel, one page at a time. We used VBA to automate importing all sheets at once. We then used a Pivot Table to find what we needed. With Power Query and VBA, we have turned complexity into clarity. - [Project Spotlights](https://taloncorp.com/category/project-spotlights/): In today’s data-driven landscape, extracting valuable information from PDF files is a common challenge. We often encounter PDFs that contain structured data we would love to analyze in Excel. Our client had a 60-page PDF that he needed answers from the data to run his business. The PDF file looks like data, spanning 60-pages. Power Query allows us to import those PDF tables into Excel, one page at a time. We used VBA to automate importing all sheets at once. We then used a Pivot Table to find what we needed. With Power Query and VBA, we have turned complexity into clarity. - [Core Values](https://taloncorp.com/category/core-values/) ## Tags - [Excel](https://taloncorp.com/tag/excel/) - [Quotes](https://taloncorp.com/tag/quotes/) - [Integrity](https://taloncorp.com/tag/integrity/)