We are pleased to present below all posts tagged with 'Excel'. If you still can't find what you are looking for, try using the search box.
Many organizations have not yet upgraded to Microsoft Dynamics CRM 2016 U1. Or those who have may not be fully using it. That's too bad, because there are hundreds of new features. This 4 minute video provides an overview.
Using Microsoft CRM and need to create reports, dashboards, mail-merges or do more efficient data-entry? This article and video summarize the Microsoft Excel and Microsoft Word integration with Microsoft Dynamics CRM 2016.
As it happens with Microsoft products, there are two competing versions of the same thing and eventually one gets phased out. Now it’s Power BI for Office 365’s turn. It had a good run, but Microsoft is finally killing off the initial iteration of Power BI to let its new service move in and run the show. Continue reading as I walk you through What is Power BI, how we got to this point, and what can you do moving forward in your Business Intelligence efforts.
Ever received a trade show list after an event that has email address but doesn’t have website, with a request to import it into your CRM solution? You know those website URLs are locked up inside of the email addresses, but you need to get them imported in a hurry, so you just import it without concern for the website. The problem is that the website can contain critical information. This article explains how to use an Excel formula to quickly pull the website URL out of an email address before importing into your CRM solution.
The release of Microsoft Dynamics CRM – Spring 2015 includes a helpful new feature; Immersive Excel. This functionality allows a user to manipulate Dynamics CRM data in MS Excel, without the cumbersome "Export to Re-import" process required in the past.
Maybe you didn’t even know, but if you are using Office 365 or OneDrive, you can use Excel to create a survey, share it with others, and easily get the results. This blog details why you should use Excel to create a survey. Using Excel won’t be for everyone depending on your requirements, but it does serve a purpose in the landscape of survey tools. Find out what you didn't know before!
Many improvements to Dynamics CRM were announced last week at Microsoft Convergence 2015. But CRM isn't really just one application anymore - there are a host of things that companies need to consider in order to work together better both externally with customers and internally with employees who are striving to serve those customers. This article looks at recent and upcoming improvements to Microsoft Dynamics Marketing (MDM), Social Listening, Parature and Unified Service Desk; as well as some of the more standard products such as Excel, SharePoint and Outlook.
Get ready ... CRM 2015 just came out, but the spring release is just a few months away. Microsoft is including a lot of new features in this release that you'll want to take advantage of including: new (easier) navigation, OneNote integration and Power BI dashboards.
Welcome back to part 2 of my review of tips and gotchas for using Power Query with Dynamics CRM OData feeds. Let’s continue our review and talk about how ugly the option set numeric values are, and how you can improve your query times by tweaking (filtering more specifically) the OData URL used in Power Query.
If you have been following the Excel business intelligence space lately, you are familiar with all of the slick add-ins Microsoft has introduced with Power Query, Power Pivot and Power Map. We work with a lot of Dynamics CRM clients, and I recently set out to use some CRM Online data to create some visualizations and dashboards in Excel. I encountered a few different situations I had to deal with, so in this post I want to walk you through some of the gotchas I found when you use Dynamics CRM data with Power Query.
When working with SharePoint, you occasionally need to work with related data. Since SharePoint isn’t setup for true relational data, that means we’re typically working with lookup columns from a child to a parent list. This is all fine well and good, but I had a client ask me for some special filtering and output with this related data. After reviewing my options, I found that the quickest way to do this (in under 15 minutes) is to use Microsoft’s Power Pivot add-in for Excel. No SharePoint Designer required! If you have Excel 2010, you will need to download and install the add-in. If you use Excel 2013, the add-in is already installed, you just have to enable it.
The primary reason for this blog post is to share what our experience (aka the real world) has taught us on how to practically implement Business Intelligence (BI) for our clients. I’ll do my best to keep this short-and-sweet, because in all honesty there’s plenty to say on this topic, and enough BI buzzwords and statistics to confuse the entire island of Manhattan!
As a company that provides customer relationship management (CRM) services, we’re big advocates of using your CRM system to track and approve sales commissions. But sometimes it can be impractical to do this. This is particularly true in complex organizations, small organizations or fast-growing organizations where you need the flexibility to quickly adapt your commission model to a changing situation in the marketplace. Long-term, everyone should aim to handle commissions in their CRM system, but what do these organizations do in the short-term?
The good news is that SharePoint is an excellent tool for giving you all of the flexibility you need, while still having an efficient process for setting, tracking and distributing commissions. Here’s how it can work for you.
Microsoft Excel is an amazing tool both in terms of the diversity of functions that it can provide and in the depth of data analytics and business intelligence that it makes available to people at every level of an organization. But too often businesses find that they are using it to solve problems that are much more complex that Excel was intended to solve - and paying a price in terms of employee productivity and costly decisions made using bad data.
So how do you know you've taken your Excel application too far? And what do you do about it?
Have you ever been working in CRM and wish you had a way to quickly create (or update) a bunch of records just like you can in Excel? In many cases individuals just starting to use CRM are more comfortable with Excel spreadsheets and find that, while CRM offers many benefits over Excel, entering and updating records using Dynamics CRM can feel like it is slowing them down.
With Dynamics CRM 2011, Microsoft has rolled out significant enhancements for exporting and importing Excel data that makes data entry in Microsoft Excel a simple process for any user. Read on to understand how this functionality is designed and how to put it to use!
When CRM 4.0 was first released you could update CRM data via the Import wizard. But then, for no apparent reason, they took this feature away with UR1.
Well, they've added it back, apparently with Update Rollup 9. Read full blog for additional information...
The complementary paper includes over 12 years of research, recent survey results, and CRM turnaround success stories.
This 60-second assessment is designed to evaluate your organization's collaboration readiness.
Learn how you rank compared to organizations typically in years 1 to 5 of implementation - and which areas to focus on to improve.
This is a sandbox solution which can be activated per site collection to allow you to easily collect feedback from users into a custom Feedback list.
Whether you are upgrading to SharePoint Online, 2010, 2013 or the latest 2016, this checklist contains everything you need to know for a successful transition.