background preloader


Facebook Twitter

Add-ins Excel ( Find and remove duplicates in Excel Helpful add-ins to get rid of duplicates in Excel. Remove identical records in one worksheet or compare two tables for dupes or uniques; combine data from duplicated rows; find fuzzy dupes, typos, misspelled words, and similar records in your tables. Merge Excel worksheets, workbooks, cells Update your main table with the matching data from lookup Excel worksheets; combine several Excel workbooks; join duplicated rows and keep unique records; combine Excel cells, rows, or columns and preserve all data. Recover lost passwords Tools for recovering passwords for Microsoft Excel worbooks. Randomize data in Excel Generate random numbers, strings and passwords, Booleans and dates; get a random sample of your data in Excel; shuffle cells or entire rows and columns. Find and replace data Find the necessary data in Excel quickly and easily. Manage data in Excel Learn about tools to manage data in your workbooks.

Collections of add-ins and VBA macros. Amazing Excel Add-ins. XLTest Free Edition XLTest helps you to check the integrity of your spreadsheets far more quickly than with tedious cell-by-cell inspection. Its colour maps of the worksheets give you a visual overview that enables you to very quickly see inconsistencies. Its detailed listings are ideal for audit record purposes. The ability to compare versions and run test cases facilitate compliance with spreadsheet controls. To know more visit ASAP Utilities – The essential add-in for Excel users ASAP Utilities is a powerful Excel add-in that fills the gaps in Excel. To know more visit Find Links Add-in To find the deleted Name Range and Ranges with “#Ref” error. and lots more useful stuff.To Know more Visit JMT Excel Utilities The add-in will help you in formatting, worksheet navigation, export picture as selection, etc.To know more Visit Excel Pivot Table Add-In Name Manager. Exemple d'utilisation d'Excel Data Explorer.

Sign in Blog BI & EPM Blog en français traitant des sujets fonctionnels et techniques autour des solution BI & EPM Options Search Blogs Tags Archive Archives Vidéo: Un ETL dans Excel avec Data Explorer TechNet Blogs » Blog BI & EPM » Vidéo: Un ETL dans Excel avec Data Explorer Vidéo: Un ETL dans Excel avec Data Explorer Franck Mercier Franck Mercier Microsoft France 2,776 Points 3 2 1 Recent Achievements Blog Conversation Starter New Blog Commentator Blogger III View Profile 27 Feb 2013 9:08 AM Comments 0 Likes Data Explorer est un Add-In, pour Excel 2010 et 2013, permettant de récupérer des données provenant de plusieurs sources différentes et d’y apporter des modifications. Le lien ci-dessous vous présente Data Explorer en détail Mais j’ai souhaité faire une petite vidéo afin de présenter l’Add-in en action Bonne vidéo Data Explorer 0 Comments Comments. Fordom. Generate Sample Data. I’ve long been a fan of Jimmy Pena’s Random Sample Data Generator Add-in and I use it quite a bit.

I wanted to write my own, however, and introduce a little more flexibility. In particular, I was creating some sample inventory data and I needed to create inventory part numbers. My part numbers are of the form AIM-0000 or PP-0000. Easy enough to do with a RANDBETWEEN and some concatenation, but I wanted to build it in to the generator. So I did. I’ve attempted to break down the samples into types. Number. Here’s the main screen. You select any number of samples and put them in the output box.

You can also edit existing samples. The compound type is the most interesting. You can also add or edit existing samples from within the Add/Edit Compound dialog. All of the samples can be put into categories. I’ve already noted some bugs as I was writing this post, and I’m sure there are a few more. You can download MapCite for Excel. MAPCITE for Excel®™ enables you to visualize your data in Excel®™ on a map enabling you to understand "the where" factors in your data. MAPCITE is downloaded in seconds as an AddIn for your existing Microsoft Excel®™ installation (Office®™ 2007 onwards & IE9).

MAPCITE for Excel®™ is available in a number of flavours… Free Trial enables you to test the power of the application without cost, Free Forever gives your free limited access to the application forever. The new Viewer enables anyone in your organisation to view fully interactive maps made using the MAPCITE for Excel®™. Upgrade to Lite or Pro versions depending on your data visualisation needs and retain the full functionality of the Addin with no watermarks. The Lite version is suitable for users with less than 300 lines of display, whilst the Pro version has no preset limits to the data display. Create customizable maps and add them to your Office applications. Features comparison User guides & support docs. Esri Maps for Office | ArcGIS. Map your spreadsheets Learn how to map your Excel data using Esri Maps for Office.

You can easily create interactive color-coded, point, clustered-point and heat maps directly in Excel and gain visual insights about your data. Watch a video Enrich your data Utilize Esri's wealth of data collections to add value to your business data. Add demographics and lifestyle data directly to Excel spreadsheets and get more context about the locations that are important to you. Quickly explore locations on-the-fly using pop-up infographics.

Watch a video System requirements Esri Maps for Office requires an account that is part of an ArcGIS Online organization and Microsoft Office Excel or PowerPoint 2010 or Microsoft Office Excel or PowerPoint 2013. Windows XP (must have SP3) (32-bit) Windows 7 (32-bit and 64-bit) Windows 8 (32-bit and 64-bit) Windows Server 2003 with SP2 and MSXML 6.0 (32-bit Office only) Windows Server 2008 R2 Windows Server 2012 What's new Support for custom roles. Previous versions. Bing Maps Excel Addin | Ricky's Bing Maps Blog. Excel is one of the most widely used applications for managing data on the market today. It is said that 80% of of business data has some sort of GIS relevance. In the past, if you wanted to visualize this data you would have to upload your Excel data somewhere and then build out an application that can tie into it an load the data on the map. This can be a lot of work and for the every day business user a huge challenge.

MapCite, has created a Bing Maps addin for Excel called MAPCITE Excel Addin that makes it easy to visualize your excel data on a map. But don’t take my word for it, check out this video: Get your free trial here and give it a try today. Don’t have any data to map out, why not connect to a data set in the Azure Data Marketplace and tie that into Excel using the Azure Marketplace Addin for Excel? Like this: Like Loading... Geocode in Excel with Bing Maps Web Services - Westin's Technical Log. A lot of folks have to geocode data that they get from various folks in their organization, and it often makes its way in to Excel. Of course, you can batch geocode using Bing Maps Services, but in some scenarios it is a lot more convenient or reasonable to use Excel.

Wouldn’t it be handy if there was an Excel function like =GEOCODE(<Some Address>)? Well, here it is. This uses the Bing Maps REST services and synchronous VBA and XML. This is similar to asynchronous JavaScript and XML (AJAX) but in this case it would be SVAX. This code is provided without warranty, etc. You will need a Bing Maps key (See: Getting a Bing Maps Key), Excel, and an internet connection. Option 1: Create your own module Expose the Developer tools (See: Show the Developer Tab) Click the Visual Basic button Insert a Module Paste in this code and modify as you see fit: Now you can use cell references or addresses to geocode your addresses or find the distance between two locations.

E.g. Comersis - Cartes de France. Blog - Mapping. GeodesiX. GeodesiX is an addin for Microsoft Excel which allows you to display maps, perform forward and reverse geocoding, compute distances (Great Circle, driving, bicycling and walking) and verify your results in Google Maps, all within Excel. Features Multi-place display dynamically creates maps with any number of items, each with its own custom icon and popup menuShow on Map context menu displays the place or route with GoogleMaps in an Excel Task PaneOffice-finder shows the nearest items to a location on the map. Relative distances are highlighted by line thicknessHeatmap uses KML files to colour areas according to cell values.

KML for all the world’s countries are builtin.Travelling Salesman Solver computes the shortest route to visit a set of places. PowerPivot. Microsoft PowerPivot pour Excel est un complément que vous pouvez utiliser pour effectuer des analyses de données puissantes dans Microsoft Excel 2010, en bénéficiant du décisionnel libre-service sur votre bureau. Dans cet article Présentation de PowerPivot pour Excel Utilisation de PowerPivot pour Excel pour donner du sens à vos données En utilisant PowerPivot pour Excel, vous pouvez transformer d’énormes quantités de données en informations significatives afin d’obtenir les réponses dont vous avez besoin en quelques secondes. Tirez profit d’outils et fonctionnalités Excel bien connues Traitez des quantités énormes de données en quelques secondes Chargez même les jeux de données les plus volumineux à partir de pratiquement toute source, y compris des bases de données, des flux de données, Reporting Services et des fichiers texte Utilisez les nouvelles fonctionnalités puissantes d’analyse, telles que les expressions DAX (Data Analysis Expressions) Découverte des fonctionnalités de PowerPivot.

Sparklines for Excel® XY Chart Labeler. A very commonly requested Excel feature is the ability to add labels to XY chart data points. The XY Chart Labeler adds this feature to Excel. The XY Chart Labeler provides the following options: Add XY Chart Labels - Adds labels to the points on your XY Chart data series based on any range of cells in the workbook. Move XY Chart Labels - Moves the entire set of data labels or individual labels in any direction and in the increment of your choosing.

Even though this utility is called the XY Chart Labeler, it is capable of labeling any type of Excel chart series that will accept data labels. Download Getting Started If you need help getting started with the XY Chart Labeler, download this instructions document. XlExe. Excel Plugin | Plotly.