Microsoft Dynamics CRM

Easy indication of you User Adoption Levels

I am so excited to present on the topic of CRM visualizations this week at the CRMUG Summit. The reason I am so excited is this basic set of skills is vital to user adoption in every organization. 

As a system admin, how often you are asked to create visualizations in CRM says a lot about your team. If you are constantly being asked for new views, charts, dashboards and templates it shows that your training program has room to grow. If you are going to Summit, Visualizations 101 will walk through these skills and how to grow them within your organization.

If you are not being asked for these things it could mean one of two things. On one end of the user adoption spectrum, it could mean that your users are not in CRM looking for data and trying to make use of that data. This would be a major red flag. If your users are not seeing the value of your CRM data your user adoption is in critical condition. The quality of your CRM will be measured in your user adoption. A beautiful, intricate, unused CRM is pointless. If you find yourself in this camp and you are lucky enough to be headed to CRMUG summit this week you will want to take the time to attend User Adoption focused sessions to help you turn things around.

Now let's explore the other side of the spectrum. If you are not being constantly asked for views, charts, and dashboards but you think your user adoption is strong here are a few ways to check. The more of these statements that ring true for your organization, the higher your user adoption.

  • Your CRM is rich with ever-evolving data. This is easy to tell by measuring the flow of data through your system through views and dashboards.

  • Your users are self-sufficient. When they have a question about data they can usually answer it themselves

  • Your users regularly spot and report issues.  The only users who report data issues are the users who are actually in CRM, usually by pulling views and reviewing data.

  • The data used in meetings is pulled right before the meeting. Users are not storing their own data in their own spreadsheet

  • Your implementation continues to grow because users are constantly asking for more fields and entities for tracking data. The level of excitement creates a sense of urgency to get CRM ready to receive more and more specific data.

  • Each area of data has specific users or departments that defend and uphold the quality of the data. If something or someone is compromising "their data" you hear about it.

These are things I consistently see in healthy, well adopted CRM organizations. Most commonly there are individual departments that score high in this way but others that do not.

If you score high on this list across your whole organization you have an implementation story that needs to be heard. If you don't know how to share that story please reach out to me and I will happily help you getting your story out to the community. 

If you have some departments with room to grow in this area I hope to see you on Thursday so we can dig into this topic.

 

What to try when drag & drop isnt working in the form designer

Today I was going a little nutty. I was in the middle of a very productive swing customizing until my recent loss of drag & drop got the better of me. Frustrated, I turned to the ever helpful community and found just what I was looking for. I wanted to report in the event that anyone is struggling with this issue.

1. Click on the settings in your IE 11 Browser

2. Go to Compatibility View Settings and add https://*.dynamics.com and click OK.

3. Then Go to Security in Internet options.

4. Click on Trusted Sites and then sites

6. Add https://*.dynamics.com to the trusted sites

7. Then Enabled Display Mixed Content in Internet Security Zone.

8. Enabled Display Mixed Content in Trusted Site Security Zone

9. Restart your browser.

Hopefully it works for you as well as it worked for me. Happy Monday!

Special thanks to Jonathon Kazemaini for figuring it out

Excel Oddity with Appointments and the Quick Fix

Not only is Excel vital to my team (in Finance we live in Excel) but it is also a huge piece of my daily work as an Admin. So today when my rows and columns were not agreeing it was cause for crisis. I do not take Excel malfunctioning lightly.

I went into the throw together a report of past appointments I stumbled across this little gotcha (pictured below):

The rows numbered 1 and 2 span one row in some columns but multiple rows in other columns. This does not a happy systems administrator make.

Unfortunately I took it as an Excel glitch, fought with it, gave it a good ol' reboot and was still stuck. When I finally slowed down and looked at the issue I realized that these rows represented Appointments with multiple "Required Attendees." Removing the Required Attendees column resolved the issue.

I am sharing this in hopes your day doesn't have the hit the speed bump that mine did. If you have a better work around for the issue please let me know in the comments.

Nerd Christmas

I have no shame in admitting that tonight, my introvert night, I found myself curled up with a cup of tea and a sleeping dog on my lap, listening to Pandora and grabbing screen shots out of CRM. I wandered through familiar areas, grabbing shots as I went.

Suddenly I threw my hands up, let out an audible shriek of excitement and then froze. Was I going crazy? Was this the indicator I should call it a night?

The abruptly awakened miniature dachshund in my lap was not nearly as excited as I was until I explained to him in excited tones how my quality of life had just radically improved. Call me a nerd, but this find made my week.

Dear friends, the wait is over. The OR function for workflows has arrived!

We have had OR in several ways throughout CRM but it had always been missing from the workflow designer. Ask any workflow enthusiast and I am sure they can share at least one story where they went to impressive lengths to work around the lack of an OR for a workflow.

CRM 2013 Service Pack 1 is like Nerd Christmas. Good things come to those who upgrade.

If you are not excited by this it most likely means that you have yet to dive into workflows. I won’t hold that against you. You’ll just have to trust me, this is a big deal.

Resources for Outlook and Excel for the End User

When Gretchen Opferkew and I were given the privilege of presenting Outlook and Excel for the End User at the CRMUG Regional Conferences in Dallas and Minneapolis, we knew that we couldn't possibly fit all of our favorite tips and tricks into one hour. So, in the hopes of leaving users inspired and equipped, we compiled this list of helpful resources to tide them over until Summit 2014. 

Outlook

Working with Outlook and CRM
An Overview of Tracking records in CRM through Outlook
Maximizing the use of the Outlook Client
Conditional Formatting Emails
Synchronization vs. Tracking

See you at Summit! These classes at CRMUG Summit on October will help you dive even deeper in Outlook and Excel for CRM. 

A Beginners Guide to Outlook Client Administration
The End User's Deep Dive into Excel & Outlook Mastery
Outlook Client Troubleshooting with Dynamics CRM
Techie Talk: SharePoint, Outlook, and Excel - Oh My!
Adoption Leveraging Microsoft Outlook & Excel

Excel

For many users, Excel is intimidating and too reminiscent of high school algebra. Fortunately with a bit of practice and a few helpful resources, any user can learn to benefit from this powerhouse tool:

Getting Started with Excel
Groups and Subtotals in Excel
Conditional Formatting in Excel
Filter Data in Excel
Simply Mathematical Formulas in Excel
How to create a Power View report in Excel with CRM Data
Training courses for Excel 2013 from Microsoft
Mass Editing CRM Data in Excel


Shameless Plug: If you are looking for more on these topics I hope to see you in my sessions at Summit 2014 

Excel Essentials for the CRM Administrator
In this session, we will be walking through the essentials excel skills that any CRM Admin or Power User should have.
Creative Excel Use in xRM Deployments
In this course, we will be diving into the many out of the box opportunities when Excel is pared creatively with CRM. (Those who are just getting into Excel are encouraged to attend Excel Essentials for the CRM Administrator prior to this session)