Current Version: Version 2.4
Compatibility: PC Only, Excel 2007 - 2016 (32 or 64-bit)
Add-in Instructions: E2P Help Page
Reduce Your PowerPoint Creation Time!
There are 3 main tasks that every data analyst must be able to do
- Gather the data
- Analyze the data
- Present the data
While there have been enormous amounts of effort towards creating tools that can help automate the first two tasks listed above, the third (presenting data) seems to be overlooked far too often. I myself used to spend hours copying and pasting Excel charts and data tables into PowerPoint every month and it definitely fell into the category of brain-numbing work. One day I had a brilliant idea to take the Excel VBA knowledge I used almost every single day and apply it to transfer my Excel data to PowerPoint for me. After over a year of coding, testing, re-working, & testing some more, I came up with an Excel add-in that has saved me HUNDREDS of hours in PowerPoint creation! I am very pleased to now be releasing my add-in to the public and I know it will save you an enormous amount of time and hassle while updating those monthly PowerPoint presentations.
What Others Are Saying
As a semi-power user of Excel, I have the responsibility of being the office expert for all Excel issues. One of the details that I had to resolve was the monthly assembly of many customer status reports for a litany of information that was all assembled in Excel and then transferred into PowerPoint slides. Try as I might, my VBA skills were not sufficient to build a transfer tool to extract the Excel tab and reliability populate that data into a designated PP slide.
Through significant Google searching, I found a reference to TheSpreadsheetGuru website. After looking over the site, it seemed that I had won the lottery. There were numerous Excel VBA shortcuts and recommendations with VBA code examples – that – sit down for this one - ACTUALLY WORKED!!! (If you do much Web browsing for VBA code – you will understand how rare that is!!). I also found a reference to an Excel to PP transfer tool identified as “E2P”.
Wowowowow – after reading the performance and design description, this tool (appeared) to be exactly what I was looking for. When I contacted Chris from TheSpreadsheetGuru website I felt that I had found a self-taught VBA junkie like myself that was down to earth and not overly full of himself, (like more than a few VBA web individuals are).
When I began testing the E2P program and after configuring my Excel application files correctly, I was able to save myself over 20 hours of boring Excel to PowerPoint transfer time each month – FANTASTIC!!!
Now – I assemble approximately 300 slides in 25 separate reports with the longest Excel to PPT transfer time, (an 85 slide monster), being LESS THAN TEN SECONDS!!!!!!!!!!!!!!!!!!!!!!!!!!!!! Thanks to TheSpreadsheetGuru for an outstanding product that I highly recommend it to anyone who is tired of the manual transfer process of Excel to PPT.
Lynn Crewse / Excel VBA Junkie!!
Mapping With the E2P Table
This is where the magic happens! Specify exaclty what and how you want your Microsoft Excel data sent to PowerPoint within the E2P Table. E2P can even delete and replace last month's data if you keep the names in the Object Name column the same!
Getting The Perfect Placement
Use the Dimension Finder to determine the dimensions of your pictures in PowerPoint so you can tell E2P exactly where you want your images to be placed. The Dimension Finder can even automatically write the data into the E2P table for you!
Multiple Exporting Options
Automatically open a PowerPoint file, create a presentation from scratch, or check out a file from SharePoint. There is are options to specifically satisfy your exporting needs. E2P even remembers the last file path you used so you don't have to navigate to the same folder next month!
Pick Your Default Settings
With the launch of E2P version 2.0, custom settings were introduced. This means you can tweak the functionality and standard defaults of the add-in to make your automation even faster and more efficient.
Choose which types of objects you want brought into your E2P drop down menus; or better yet, tell E2P to only bring in objects that are named a specific way.
These settings will give you even more ways to export your Excel content into your PowerPoint slides.
Multiple Pasting Options
E2P gives you the option to paste your charts, tables, and ranges with a variety of different pasting types! This gives you a great amount of flexibility to have E2P paste-in your graphics just like you would if you were manually doing it. And the best part is you can do any combination of pasting methods within a single export!!!
For optimal resolution, I always recommend using the PNG format for all your Excel charts and the Enhanced Metafile format for everything else.
Trial Version Available!
Not sure if this add-in is the solution for you needs? Well, you can download a trial version of this add-in and check out all the awesome features for yourself! The trial period is 14 days and the add-in will be fully functional. So there are no excuses, pick up a copy of the E2P add-in right now!
We Accept Corporate Cards!
One of the best perks that comes with working for a company is they typically set aside money every year to allow their employees to purchase tools just like this one! Tell your manager you found this awesome tool that will save you loads of time and ask if the company would possibly be able to fund the purchase. It never hurts to ask! Make sure to purchase enough licenses in the event you are buying for multiple co-workers or a whole department. You will be able to enter the amount you need at checkout (click the green button below).
Free Updates For Life!
I am a strong believer in including future updates with the originally purchased software. That is why when you purchase E2P, you don't have to worry about missing out on an awesome new feature or vital bug fix. Any update that is made to E2P will be directly emailed to your inbox.
30-Day Money Back Guarantee!*
I'm so confident you will love this add-in, I'm willing to give you 30 days from your purchase date to decide if this is the tool for you. If you come to the conclusion that E2P was not what you were expecting, just shoot me an email and I'll refund you your money back. So what's there to lose? Now is your opportunity to save time from copying & pasting and spend more of your valuable time focusing on your company's results. Click the Buy Now button below to quickly get your hands on this amazingly simple yet powerful Excel add-in!
Due to the limitations of Office for Mac, the E2P add-in is only compatible on PC versions of Microsoft Office 2007+. This includes Excel 2007-2016 on any Windows operating systems. The E2P add-in is compatible with Microsoft Office 32-bit as well as the 64-bit version. Please reach out with the form below if you are experiencing compatibility issues not addressed in this section.
Bulk Discounts For Your Organization
Buy E2P for your whole team or department and save! The discounted price will be applied automatically during your checkout process.
- 5-9 units per single order --> 15% off total cost
- 10+ units per single order --> 25% off total cost
Download E2P Today!
Stop wasting time and brain cells copy & pasting charts into your PowerPoint presentations every month. Pick up the E2P add-in right now and see how easily you can automate your work so you can spend more time impacting your company and less time clicking back and forth between Excel and PowerPoint!
With your purchase, you will receive one license and an E2P add-in file that can be used on up to 3 of your personal computers. Licenses cannot be shared or used on devices that you do not own.
Have A Question? Ask Away!
You can use this form to directly communicate with me in case you have questions about features, need a PO for a bulk order, or have any other needs concerning the E2P add-in. I can typically reply back to you within 24 hours.