Skip to the main content.

Technology

As the preferred Microsoft Dynamics 365 and Power Platform Service provider, TrellisPoint has the expertise to help your business grow the strategic way.

 

Dynamics 365

Microsoft Dynamics 365, a comprehensive suite of intelligent business applications designed to revolutionize the way you manage and grow your business.

 

Artificial Intelligence

Radically accelerate your productivity with AI features built directly into Microsoft tools and services.

Microsoft Co-Pilot 
copilot365

 
Resources
Connect with Us

Contact Form

Phone: 888.719.0248
Social: LinkedIn Icon 100x100 Twitter Icon 100x100 Facebook Icon 100x100 YouTube Icon 100x100

 

Resources
Connect with Us

Contact Form

Phone: 888.719.0248
Social: LinkedIn Icon 100x100 Twitter Icon 100x100 Facebook Icon 100x100 YouTube Icon 100x100

 

Resources
Connect with Us

Contact Form

Phone: 888.719.0248
Social: LinkedIn Icon 100x100 Twitter Icon 100x100 Facebook Icon 100x100 YouTube Icon 100x100

 

1 min read

Build Efficiency by Bulk Editing Excel Data using Dynamics 365

Did you know that it’s quick and simple to change multiple records at once using the bulk editing option in Dynamics 365? This brief post will show you how you to use Excel Online to easily edit and change data without having to navigate to numerous screens or download and upload spreadsheets into the system.

Step 1: To begin bulk editing Excel data, first access the view you wish to edit data from. For this example we have selected a sample view of cases to bulk edit.

Step 1: To begin bulk editing Excel data, first access the view you wish to edit data from. For this example we have selected a sample view of cases to bulk edit.

Step 2: Using the Export to Excel dropdown on the ribbon, select “Open in Excel Online”.

Step 2: Using the Export to Excel dropdown on the ribbon, select “Open in Excel Online”.

Step 3: Begin editing data by adding, deleting, or modifying the rows.

For this example, we can delete the average order shipment time and change the complete overhaul required status to Active. Click save to begin the import process.

Step 3: Begin editing data by adding, deleting, or modifying the rows.

Step 4: My Imports confirms the changes have been made.

The bulk editing in Excel process is extremely helpful for deleting numerous records, making mass changes, or just auditing a datasheet which is suspected to have errors.

Step 4: My Imports confirms the changes have been made.

It’s as easy as that!

There so many ways you can use this tip! We’d love to hear how you use the bulk editing feature in D365 to save you time and energy! Also, if you found this tip helpful, take a moment to share your feedback using the comments section below!

For more tips on using Dynamics 365 CRM including Power BI Dashboards, be sure to visit our blog!

Submit a Comment

Your email address will not be published. Required fields are marked

Close More Deals with Microsoft Sales Copilot

4 min read

Close More Deals with Microsoft Sales Copilot

Is your sales organization working up to its potential? Or is their productivity constantly hampered by lagging data and low-value activities that...

Unveiling the Exciting 2023 Release Wave 2 Plans for Microsoft Dynamics 365 and Power Platform

3 min read

Unveiling the Exciting 2023 Release Wave 2 Plans for Microsoft Dynamics 365 and Power Platform

Microsoft's 2023 release wave 2 plans for Dynamics 365 and Microsoft Power Platform are set to introduce a myriad of new features. These updates,...

Discover the Next Generation of AI For Microsoft Power BI

6 min read

Discover the Next Generation of AI For Microsoft Power BI

Microsoft has recently introduced two new AI-based features that will revolutionize the way users interact with Power BI. These features are known as...