Microsoft Dynamics 365 PowerBI - Key Features

Microsoft Dynamics 365 PowerBI - Key Features

Please join us on November 13, 1:30 PM – 3:30 PM at our Customer Appreciation Seminar in Mississauga. Click here to RSVP.  We will be showing you the latest release of Microsoft Dynamics Business Central – NAV, Dynamics 365 – CRM, and Business Intelligence.  Join Vox ISM, our Dynamics 365 Experts, keynote speakers, and our special guests.  We will be discussing the following:  USMCA (formally called NAFTA); CAMM, ASCIP, Microsoft and Vox ISM’s APPS; Cyber Security; COJG (Government Funding); and how they can benefit manufacturing companies.

Living Arts Centre
Rogers Theatre
4141 Living Arts Dr,
Mississauga, ON L5B 4B8

Dynamics 365 Business Central is a business management solution that helps companies connect their financials, sales, service, and operations to streamline business processes, improve customer interactions, and make better decisions, in real time.

In this blog, we will outline some of the Microsoft Dynamics 365 – PowerBI (Business Intelligence and AI) agenda items.

Worldwide, the manufacturing industry is highly competitive and evolves quickly.  Microsoft Dynamics 365 provides you with a 365 degree view of your customers, tracking your field and project services, giving you the intelligence to improve your decision making process.


Evolution of Management Reporting

Microsoft Dynamics PowerBI_Evolution of Data Awareness

Artificial intelligence continues to drive the conversation for manufacturing companies as they are demanding automated and ease-of-use solutions powered by machine learning and other IoT technology. As a result, top manufacturers have made AI a priority while staying focused on CRM fundamentals.  Come to see firsthand how your business can keep in touch with analytics, operate faster, be L.E.A.N. by being more cost-effective with a more personalized customer experience.

Excel Analysis Cubes – Supply Chain, Purchasing, Manufacturing Jobs, and Sales

Microsoft Dynamics PowerBI_2

Join us at our November 13 Customer Appreciation Seminar at the Living Arts Centre in Mississauga, Ontario, we will show you how you how easy it is to use Microsoft PowerBI to get the information that is important to you.  Allowing you to make informed and intelligent decisions in real time.  Best of all it is free with the purchase of Microsoft Dynamics 365.  We at Vox ISM, look forward to discussing Microsoft Dynamics 365 – PowerBI with you and your manufacturing team.

Power BI – Make Data Driven Decisions

Microsoft Dynamics PowerBI_3

Blog post by Linda Heaton – Marketing Specialist. 

Linda Heaton_Vox ISM

Linda Heaton is Vox ISM’s most experienced marketing specialist. She has been with Vox ISM for 20 years and has touched every piece of marketing material that has gone through Vox ISM in that time. Linda has been an integral part in Vox ISM’s continued drive towards increasing sales while lowering cost per lead. Many of our customers and prospects will know Linda as she is actively engaged in our webinar and event coordination.


Business Central (CRM) - Key Features

Microsoft Dynamics 365 (CRM) - Key Features

Please join us on November 13, 1:30 PM – 3:30 PM at our Customer Appreciation Seminar in Mississauga. Click here to RSVP.  We will be showing you the latest release of Microsoft Dynamics Business Central – NAV, Dynamics 365 – CRM, and Business Intelligence.  Join Vox ISM, our Dynamics 365 Experts, keynote speakers, and our special guests.  We will be discussing the following:  USMCA (formally called NAFTA); CAMM, ASCIP, Microsoft and Vox ISM’s APPS; Cyber Security; COJG (Government Funding); and how they can benefit manufacturing companies.

Living Arts Centre
Rogers Theatre
4141 Living Arts Dr,
Mississauga, ON L5B 4B8

Dynamics 365 Business Central is a business management solution that helps companies connect their financials, sales, service, and operations to streamline business processes, improve customer interactions, and make better decisions, in real time.

In this blog, we will outline some of the Microsoft Dynamics 365 (CRM) agenda items and key features.

Business Central CRM_1

Microsoft Dynamics 365 has the best and leading CRM software and solutions on the Canadian manufacturing market.  It scores well on its depth of functionality.  It excels in its usability and has an amazing ecosystem to adapt to the compelling ways of how the manufacturing companies work today.

Financials – Project Service Automation – Field Service – Customer Service – Marketing Customer Insights – Operations – Sales & Marketing

Business Central CRM_2

The number one reason our manufacturing customers purchase Microsoft Dynamics CRM is due to its tight integration across the Microsoft product family creating a captivating case for companies, like yours, to purchase Dynamics 365 – CRM Premise or other more expensive Cloud offerings.

Full Integration With All The Microsoft Software

The number one reason the Sales Team is glad their boss purchased Microsoft Dynamics – CRM is due to the fact that the package comes with the business APP ecosystem.  Microsoft’s Citizen App Builder (PowerApps) is a remarkable tool that makes Microsoft Dynamics – CRM a serious platform contender.  Vox ISM’s favourite APP is the integration of CRM to Microsoft Outlook.  Those working on the road or in Operations love the Mobile APP.

View Dynamics 365 Financials and CRM data right from Outlook with the Dynamics 365 APP for Outlook.  Create follow-up activities, convert emails directly to leads, opportunities, and cases.  As well, quickly generate quotes, orders, invoices, and credit memos direct from your desktop, tablet, or mobile device.

At our November 13 Customer Appreciation Seminar at the Living Arts Centre in Mississauga, Ontario, we will show you how you can do the following: increase sales; track sales statistics; relationship selling with LinkedIn; increase your hit rate with synchronized marketing; mobility; and, full integration to other Microsoft software.  We at Vox ISM, look forward to discussing Microsoft Dynamics 365 – CRM and its key features with you and your manufacturing team.

Business Central CRM_3
Business Central CRM_4

Blog post by Linda Heaton – Marketing Specialist. 

Linda Heaton_Vox ISM

Linda Heaton is Vox ISM’s most experienced marketing specialist. She has been with Vox ISM for 20 years and has touched every piece of marketing material that has gone through Vox ISM in that time. Linda has been an integral part in Vox ISM’s continued drive towards increasing sales while lowering cost per lead. Many of our customers and prospects will know Linda as she is actively engaged in our webinar and event coordination.


Business Central (NAV) - Key Features

Microsoft Dynamics Business Central (NAV) - Key Features

Please join us on November 13, 1:30 PM – 3:30 PM at our Customer Appreciation Seminar in Mississauga. Click here to RSVP.  We will be showing you the latest release of Microsoft Dynamics Business Central – NAV, Dynamics 365 – CRM, and Business Intelligence.  Join Vox ISM, our Dynamics 365 Experts, keynote speakers, and our special guests.  We will be discussing the following:  USMCA (formally called NAFTA); CAMM, ASCIP, Microsoft and Vox ISM’s APPS; Cyber Security; COJG (Government Funding); and how they can benefit manufacturing companies.

Living Arts Centre
Rogers Theatre
4141 Living Arts Dr,
Mississauga, ON L5B 4B8

In this blog, we will outline some of the Microsoft Dynamics 365 – Business Central (NAV) agenda items and key features.

Dynamics 365 Business Central is a business management solution that helps companies connect their financials, sales, service, and operations to streamline business processes, improve customer interactions, and make better decisions, in real time.

Business Central_1

Join us at our November 13 Customer Appreciation Seminar at the Living Arts Centre in Mississauga, Ontario, for our manufacturing seminar, we will demonstrate the easy-to-use Work Order Level Scheduler allowing the Scheduler to see the progress and sequence of tasks for each given job.

Manage bottlenecks and critical paths, completion date versus the due date.  Business Central makes it easy for the Project Manager to determine customer priorities and to fix project or shipping issues.  Changing priorities is as simple as drag and drop.

Business Central_2
Business Central_3

Microsoft Dynamics Business Central (NAV) is fully deployed on all of your favourite devices including:  Web deployment

  • Handhelds
  • iPhones
  • Androids
  • Blackberry
  • Windows Phone 8
  • Laptops
  • Tablets
  • No additional costs

Business Central_4

Learn how to create amazing reports without a need for a Developer.

Business Central_5

Blog post by Linda Heaton – Marketing Specialist. 

Linda Heaton_Vox ISM

Linda Heaton is Vox ISM’s most experienced marketing specialist. She has been with Vox ISM for 20 years and has touched every piece of marketing material that has gone through Vox ISM in that time. Linda has been an integral part in Vox ISM’s continued drive towards increasing sales while lowering cost per lead. Many of our customers and prospects will know Linda as she is actively engaged in our webinar and event coordination.


Vox ISM to Hold Customer Appreciation Event

Vox ISM to Hold Customer Appreciation Event

Vox ISM is excited to announce Customer Appreciation Event which will be held on Tuesday, November 13, at the Mississauga Living Arts Centre.

The Customer Appreciation Event by Vox ISM will include presentations on the latest Microsoft technology, computer security, industry updates, Dynamics 365 software demos, live software lab, excellence awards and much more.

Following is the copy of the print release invitation.

Customer Appreciation Event Invite
Customer Appreciation Event Invite_Agenda

For more information and event registration, click here.


Dynamics 365 Business Central Keyboard Shortcuts

Dynamics 365 Business Central Keyboard Shortcuts

Overview

The keyboard shortcuts aide accessibility and can make it easier and more efficient to navigate to different areas and elements on a page.

The keyboard shortcuts are supported by most web browsers; however, the behavior may vary slightly.

The keyboard shortcuts described here refer to the U.S. keyboard layout. The layout of the keys on other keyboards may not correspond exactly to the keys on a U.S. keyboard.

Most of the shortcuts are the same no matter whether the operating system is Windows or macOS; however, there are some shortcuts that differ for macOS. These are indicated in parantheses in the tables in the sections that follow.

General Keyboard Shortcuts

The following table describes keyboard shortcuts for navigating and accessing different elements of a page, such as actions, drop-down lists, lookups, and more. For details about keyboard shortcuts for navigating records once you get inside a list, see the next section.

Press these keys To do this
Alt+Q Open Tell me what you want to do box that can help you find a page, a report, an action on the current page, or an article in the documentation.
Alt+Up Arrow Show tooltip for a field or a column header of a table. If the field has validation errors, press “Alt+Up Arrow” to show the validation error. Press “Esc” or “Alt+Up Arrow” to close the tooltip.
Tab Move focus to the next control or element on a page, such as actions, buttons, fields, or list headings.
Shift+Tab Move focus to the previous control or element on a page, such as actions, buttons, fields, or list headings.
Enter Enable or access the element or control that is in focus.
Alt+Down Arrow Open a drop-down list or look up a value for a field.
Alt+Right Arrow See the transactions that resulted in a calculated value in a field.
Esc Close the current page or drop-down.

Keyboard Shortcuts in Lists

The following table describes the keyboard shortcuts that you can use in a list page. The shortcut action is slightly different depending on whether the page is shown in the list view or tile view.

Press these keys
(in macOS)
To do this in a list view To do this in a tile view Remarks
Up Arrow Move in the same column to the field in the row above. Move in the same column to the tile in the row above.
Down Arrow Move in the same column to the field in the row below. Move in the same column to the tile in the row below.
Right Arrow In a view-only list, move in the same row to the next field to the right.

In an editable list, move to the right within the current field.

Move in the same row to the next tile to the right.
Left Arrow In a view-only list, move in the same row to the previous field to the left.

In an editable list, move to the left within the current field.

Move in the same row to the previous tile to the left.
Tab In editable list, move in the same row to the next field to the right. Not applicable.
Shift+Tab In editable list, move in the same row to the previous field to the left. Not applicable.
Home
(Fn+Left Arrow)
Move to the first field in the row. Move to the first tile in the row.
End
(Fn+right Arrow)
Move to the last field in the row. Move to the last tile in the row.
Page Up
(Fn+up Arrow)
Scrolls to display the set rows above the current rows in view. Scrolls to display the set of tiles above the current tiles in view.
Page Down
(Fn+down Arrow)
Scrolls to display the set rows below the current rows in view. Scrolls to display the set of tiles below the current tiles in view.
Enter
(Fn+down Arrow)
Open the record that is associated with the field. Opens the record. Only relevant if a card page is associated with the record.
Ctrl+Enter Move focus to the next element outside the list. Move focus to the next element outside the list.

Select, copy and paste

Press these keys
(in macOS)
To do this in a list view To do this in a tile view Remarks
Ctrl+Home
(Fn+Ctrl+Left Arrow)
Select the first row in the list; focus moves to the first field in row. Move to the first tile in first row.
Ctrl+End
(Fn+Ctrl+Right Arrow)
Select the last row in the list; focus moves to the last field in row. Move to the last tile in last row.
Ctrl+Click
(Cmd+Click)
Extend the selection of rows to include the row that you click. Not applicable.
Shift+Click Extend the selection of rows to include the row that you click and all the rows in between. Not applicable. You can use this after using Ctrl+Up Arrow or Ctrl+Up Down to expand your selection.
Ctrl+Up Arrow
(Ctrl+Cmd+Up Arrow)
Move focus to the row above and keep the current row selected. Not applicable.
Ctrl+Down Arrow
(Ctrl+Cmd+Down Arrow)
Move focus to the row below and keep the current row selected. Not applicable.
Ctrl+Space Bar
(Ctrl+Cmd+Space )
Extend the selection of rows to include the focused row. Not applicable. You can use this after using Ctrl+Up Arrow or Ctrl+Down Arrow to expand your selection.
Ctrl+A Select all rows. Not applicable.
Shift+Up Arrow Extend the selection of rows to include the row above. Not applicable.
Shift+Down Arrow Extend the selection of rows to include the row below. Not applicable.
Shift+Page Up
(Shift+Fn+Up Arrow)
Extend the selection of rows to include all visible rows above the current selection of rows. Not applicable.
Shift+Page Down
(Shift+Fn+Down Arrow)
Extend the selection of rows to include all all visible rows below the current selection of rows. Not applicable.
Ctrl+C
(Cmd+C)
Copy the selected rows to the Clipboard. Not applicable.
Ctrl+V
(Cmd+V)
Paste the selected rows from the Clipboard into the current page or external document, like Microsoft Excel or Outlook email. Not applicable. You can only do this editable lists.
F8 Copy the field in the same column of the row above, and paste it into the current row. Not applicable. You can only do this in editable lists. Using this shortcut followed by a Tab lets you quickly fill out fields in line items that you want to have the same value as the row above.

Keyboard Shortcuts for Searching and Filtering Lists

Press these keys
(in macOS)
To do this
F3 Toggles the search box.

  • Activates the search box, so you can start typing your search text.
  • If the search box is already activated, F3 returns to the list without clearing the search text.
Shift+F3 Opens and closes the filter pane.

  • If the filter pane is not open, Shift+F3 opens it and focuses on the + Filter action under Filter list by, which lets you just hit Enter to start adding a field filter.
  • If the filter pane is already open, Shift+F3 closes it but does not clear any filters that you have added.
Ctrl+Shift+F3 Opens and closes the filter pane.

  • If the filter pane is not open, Ctrl+Shift+F3 opens it and focuses on the + Filter action under Filter total by, which lets you just hit Enter to start adding a totals filter.
  • If the filter pane is already open, Ctrl+Shift+F3 closes it but does not clear any filters that you have added.
Alt+F3 Toggles filtering to this value.

  • Applies a column filter on the selected field value in the list. This does the same as choosing Filter to this value from a column heading. It opens the filter pane, sets filter to the selected value, while focus remains on cell in the list.
  • If the column is already filtered, Alt+F3 clears the filter on that column.
Shift+Alt+F3 Opens the filter pane and adds a filter on the selected column in the list. Focus is on the new filter field which lets start typing the filter criteria right away.

This does the same as selecting Filter from the column heading. er menu. Displays the filter pane, adds the filter, sets focus to it so the user can type a value to filter on.

If there is already a filter on the field, a new filter is added.

Ctrl+Shift+Alt+F3 Resets filters. This does the same as choosing Reset filters in the filter pane, and it applies to field and totals filters.

Filters return to the default filters for the current view. If the current view is All, then this is the equivalent to returning to an unfiltered view with all records.

Ctrl+Enter Returns to the list from the filter pane.

Keyboard Shortcuts in the Calendar (Date Picker)

When setting a date field, you can either enter the date manually or open a calendar (date picker) that lets you select the date you want. The following table describes the keyboard shortcuts for the calendar.

Press these keys
(in macOS)
To do this
Page Up Move to the previous month.
Page Down Move to the next month.
Ctrl+Home Open the calendar if closed.
Ctrl+Home
(Cmd+Home)
Move to the current month, current day.
Ctrl+Left Arrow
(Cmd+Left Arrow)
Move to the previous day.
Ctrl+Right Arrow
(Cmd+Right Arrow)
Move to the next day.
Ctrl+Up Arrow
(Cmd+Up Arrow)
Move to the previous week, same day of the week.
Ctrl+Down Arrow
(Cmd+Down Arrow)
Move to the next week, same day of the week.
Enter Select the focused date.
Ctrl+End
(Cmd+End)
Close the calendar and delete current the date.
Esc Close the calendar without a selection, keep current date.

Keyboard Shortcuts in the Report Preview

Press these keys
(in macOS)
To do this
Down Arrow Scroll down the page.
Up Arrow Scroll up the page.
Right Arrow Scroll to the right when the page is zoomed in so that it is not entirely in view.
Left Arrow Scroll to the left when the page is zoomed in so that it is not entirely in view.
Ctrl+0 (zero)
(Cmd+0)
Fits the entire page in the window.
Ctrl+Home
(Cmd+Home)
Go to the first page of the report.
Ctrl+End
(Cmd+Home)
Go to the last page of the report.
Page Down
(Fn+Down Arrow)
Go to the next page of the report.
Page Up
(Fn+Up Arrow)
Go to the previous page of the report.


Business Central Canadian Premiere

Microsoft Dynamics Business Central Canadian Premiere

Microsoft for Manufacturing: Business Central 365 Seminar

With the release of Business Central updates this October, there are five improvements worth noting that make it easier to run your business. Vox ISM had Mike Fontaine introduce the newest features and benefits of Business Central at our Seminar in Mississauga. Vox ISM will be hosting more events like this coming up. You can check out our event calendar here.

Business Central Canadian Premiere

Why Business Central?

There are a few big changes to business software in 2018 that come standard with Business Central. Without sacrificing functionality that was seen in Dynamics NAV, you can reap the benefits of Business Central.

Top 5 Features of Business Central

  1. Power BI Integration

Power BI is one of the powerhouses in Microsoft’s business suite. Not only is it a premiere business intelligence reporting tool, but it’s now fully integrated with Business Central. Numerous reporting tasks can be done right in Business Central without having to open up Power BI separately. Often, you only need critical information on certain screens. The integration between software allows more personalization to fit your unique business needs.

  1. Outlook Integration

The newest trend in Microsoft software has been to reduce the amount you need to have multiple tools open. Similar to how Power BI has been integrated into Business Central, Business Central has been integrated into Outlook. Without ever leaving Outlook, you can access Business Central data that is relevant to any email you receive.

  1. AI – Artificial Intelligence

Power BI used to be the only tool to really harness the power of AI to assist users in reporting. Microsoft has begun to nest AI into Business Central to assist users in completing tasks by suggesting common tasks to complete alongside others to optimize your business.

  1. In the Cloud or On Premise

As of October 2018, you can choose to continue to stay on premise with Business Central with all the newest features or make the move to the cloud. The cloud allows full integration into Dynamics 365 which allows users to stay on one platform for an entire workday. From emailing, invoicing, scheduling, and reporting you can do all your tasks in one place.

  1. Visual Production Scheduler

For manufactures using Business Central, the visual production scheduler is a handy tool to manage your production if your business produces in jobs or batches. With a smooth click and drag user friendliness, it is easily one of the best schedulers on the market today. On top of that, it is fully integrated to your business data to avoid data silos from hindering your business.

Blog Post by Jeff Vandenberg – Sales Team Member

Jeff Vandenberg_Vox ISM

Jeff Vandenberg graduated with a B.Comm from Seneca College with a major in Enterprise Resource Planning (ERP).

Jeff currently works as part of the Conversion Team for Vox ISM to help bring customers to a solution that fits their needs. Jeff’s years of experience in the service industry can provide value to companies that are looking for ways to constantly improve.


Flip Switch Microsoft Dynamics 365

How to enable Flip Switch control for Two OptionSet in Microsoft Dynamics 365 CRM

With the release of Dynamics 365 Version 9.0, Microsoft has released some great new features for better user experience and visualizations. One of them is Flip Switch.

Two OptionSet field – Flip Switch

Flip switch control (Yes/No) options would give the nice field look in the web, mobile app and Tablet. Instead of using checkboxes and radio buttons, this control adds a visual effect like the On/Off switch way.

Flip Switch Dynamics 365

To enable Flip Switch for any Two OptionSet field you need to follow below steps:

  1. Open Form Editor for the entity you wants to enable Flip Switch. E.g: Enabling Flip Switch to opportunity form.

Flip Switch Dynamics 365_Step1

2. Select field for Flip Switch and click on Change Properties.

Flip Switch Dynamics 365_Step2

3. Click on Change Control tab and Add Control

Flip Switch Dynamics 365_Step3

4. Select Flip Control and Add the control to selected field

Flip Switch Dynamics 365_Step4

5. Enable Flip Switch for Web, Mobile and Tablets in any combination.

Flip Switch Dynamics 365_Step5

6. Save and Publish Customization and refresh the form

Flip Switch Dynamics 365_Step6

You can create any number of Flip Switch fields in the form.

Post by Ashish Rana – Microsoft Dynamics 365 CRM Consultant

Ashish Rana_Vox ISM

Ashish is a Microsoft Certified CRM Consultant, Graduated with a Bachelor of Technology in Computer Science and an MBA in Information Technology from Symbiosis University. With experience over 5 years in Microsoft Dynamics CRM and Power BI consulting in North America, South East Asia, and the Middle East.

Ashish is a member of CRM Consulting team with Vox ISM, Implementing CRM and BI Business solutions to Manufacturing customers.


The first rule of Microsoft Excel - Don’t tell anyone you’re good at it

Article by Ira Iosebashvili – The Wall Street Journal

When Anand Kalelkar started a new job at a large insurance company, colleagues flooded him with instant messages and emails and rushed to introduce themselves in the cafeteria. He soon learned his newfound popularity came with strings attached. Strings of code. Many of Mr Kalelkar’s co-workers had heard he was a wizard at Microsoft Excel and were seeking his help in taming unruly spreadsheets and pivot tables went wrong.

New York analyst Colin McIllece says being an Excel expert is a “ double-edged sword.” (Mark KauzlarichBloomberg News)
“People would come up to me and say, ‘Hey, I hear you’re the Excel guy,’ ” said the 37-year-old metrics consultant from Oak Brook, Ill. Mr Kalelkar said he has become “a little more passive-aggressive,” warning help-seekers, “Don’t come to me, go to Google first.”

Microsoft Excel

Excel buffs are looking to lower their profiles. Since its introduction in 1985 by Microsoft Corp., the spreadsheet program has grown to hundreds of millions of users world-wide. It has simplified countless office tasks once done by hand or by rudimentary computer programs, streamlining the work of anyone needing to balance a budget, draw a graph or crunch company earnings. Advanced users can perform such feats as tracking the expenditures of thousands of employees.
At the same time, it has complicated the lives of the office Excel Guy or Gal, the virtuosos whose superior skills at writing formula leave them fighting an endless battle against the circular references, merged cells and mangled macros left behind by their less savvy peers.

“If someone tells you that they ‘just have a few Excel sheets’ that they want help with, run the other way,” tweeted 32-year-old statistician Andrew Althouse. “Also, you may want to give them a fake phone number, possibly a fake name. It may be worth faking your own death, in extremworldwideances.”
The few Excel sheets in question, during one recent encounter, turned out to have 400 columns each, replete with mismatched terms and other coding no-nos, said Mr Althouse, who works at the University of Pittsburgh. The project took weeks to straighten out.

“Let’s just say that was a poor use of time,” he said. He advises altruistic Excel mavens to “figure out what you’re getting into” before offering to lend a hand.

Microsoft’s Jared Spataro, a corporate vice president for Office and Windows marketing, wrote in a recent blog post that “Excel’s power comes from its simplicity,” calling it “an incredibly flexible app.”
A company spokeswoman said the program has recently added artificial intelligence features that are “opening up new possibilities for all users.”

Nevertheless, years of dealing with colleagues’ Excel emergencies have taught John Mechalas to keep his mastery of spreadsheets a secret.
The trouble often starts with a group email asking if there is anyone who knows Excel really well, said Mr Mechalas, a 48-year-old software engineer at IntelCorp. in Hillsboro, Ore.

“People say, ’Oh, this is just a really quick thing,’ ” he said. “Then I look at it, and it’s not a quick thing.”

These days, Mr Mechalas will lay low until someone has a dire need before offering his expertise. His willpower was put to the test earlier this week, as he suppressed the urge to yell “just come to me for help” while staring at a badly tangled spreadsheet during a presentation.

“I’m an altruist, but it’s not my job to save the world,” he said.

Colin McIllece, 36, a New York purchasing analyst, said being good at Excel has benefits. “It’s kind of like being a wizard,” he said. “You say, ‘I can think of a spreadsheet for that,’ and it’s like you performed a magic trick.”

Mr McIllece recalls one fiasco where a colleague presented him with a huge document saved into a jumble of folders and teeming with dreaded # symbols, usually an indication of an Excel error.
Like Mr Kalelkar, he is now more likely to show colleagues they can find answers to their problems though Google searches—a method even the most experienced Excel users often fall back on. People who keep bothering him get their instant messages ignored. As an Excel expert, “you become indispensable, and that’s a double-edged sword,” Mr McIllece said.

Jen Lipschitz, a 32-year-old data analyst and project manager from Quincy, Mass., says colleagues often turn to her and the rest of her department for help with their Excel travails.
People say, “ ‘This is Jen, she’s in the smart department,’ ”Ms Lipschitz said. “If they can’t figure out why the data is being weird, they’ll just go ask Jen down the hall.”

Ms Lipschitz’s solution: “I’ll just stand there,” she said. As co-workers are explaining the problem, they will frequently figure it out for themselves. She believes some people get overwhelmed by the possibilities of Excel, a program that manages to be at once simple and mind-bogglingly complex.

“People get intimidated that Excel can do so many things,” she said. “They forget that they need to try.”

Interested to learn more about Microsoft Excel?

Excel with Microsoft Excel

Join our exclusive webinar “Excel with Excel” on October 17 to learn more about Microsoft Excel.

Click here for webinar agenda and reserve your seat.

See you in the webinar room.


Mobile ERP

4 Ways Manufacturing Companies Can Benefit from Mobile ERP

Mobile ERP is an Enterprise Resource Planning system that can be accessed through mobile devices. Users can access the system using a standard browser or mobile apps. Being able to access your business software remotely means staff and field service personnel can capture and enter data wherever they are from the warehouse to the customer site. For this reason, mobile ERP solution plays a vital role in running a business smoothly.

Companies get benefited from higher productivity, competitive benefits, extensive business relationships and data capturing. Most of the companies have also started developing mobile ERP applications for reporting and dashboards. In coming years, companies will demand for more mobile solutions as end users seek to carry out ERP processes on the move via their mobile devices.

Your Legacy ERP System Is Holding You Back

Legacy ERP systems cannot offer you the accessibility a mobile ERP can. Today, every business is embracing mobile technology as it provides a complete view of business activities by just a simple login from anywhere.

Mobile ERP and Manufacturing

As the manufacturing industry grows, ERP software continues to evolve and improve, with software companies continually launching new applications. Each of these applications seeks to address the changing needs of the industry. The addition of mobile ERP provides another such opportunity. Manufacturing companies should not overlook the need for switching to mobile ERPs when everyone is doing so to keep up with the competition.

Mobile ERP

4 Ways Manufacturing Can Benefit from Mobile ERP

  1. Remote accessibility

Mobile ERP system gives manufacturers the convenience to access ERP application from a mobile device at any location. From procurement, inventory, and supply to logistics data are stored in ERP can be easily obtained by any mobile device. So, it improves customer experience as employees, managers, and sales managers can conveniently access data.

  1. Reduced costs

Another way manufacturing companies can get benefit from mobile ERP is through reduced costs. By centralizing data and allowing all departments access from mobile devices, ERP solutions mitigate both operations and administrative expenses. Operations can be managed from any location, minimizing delays and disturbances. Decisions can be made instantly. Also, mobile ERP provides a more comprehensive and enhanced system of visibility and tracking, from components and supplies through completed products and delivery, helping identify any potential areas where time or costs could be improved.

  1. Real-time updates

In production, receiving real-time notifications and alerts is essential to have complete visibility of the stocks and everything. Hence, this clarity on the production activities permits managers to keep track of all of the processes and update work orders. With mobile ERP system, workers can track activities of the inventory, warehouse, supplies, and equipment sections.

  1. Improved Communication and Collaboration

When a company grows, departments tend to develop their separate databases of information. This separation can lead to communication challenges. As a result, the integrity of company data can be compromised, leading to production mistakes, lost product, and decreased sales. ERP solutions ensure that all information from all departments is maintained in a central database, accessible to everyone. Using mobile ERP, users in any department can access this information from any mobile device. Also, mobile ERP allows departments to collaborate on projects, offer input on issues, or discuss topics.

Interested to know more?

Business Central for Manufacturing

On October 16, Microsoft and Vox ISM are organizing the most significant Manufacturing Seminar at Best Western, Mississauga.

Click here for the complete seminar agenda and reserve your seat.

If you are looking for a new manufacturing software or upgrading from a legacy version of Microsoft, this seminar will provide you with the answers you need to make an informed decision.

See you at the seminar room!


ASCM

Introducing the Association for Supply Chain Management (ASCM)

The Association for Supply Chain Management (ASCM), an organisation for supply chain, had its initial launch on 30 September.

ascm_logo

As the supply chain landscape is changing at an increasingly rapid pace, the ASCM will focus on supply chain organisational transformation, innovation and leadership.

Formed on the foundation of APICS, ASCM will be the supply chain management association and an industry leader in certification, training, and networking.

“ASCM is the leader for end-to-end supply chain management, bringing corporations and professionals the latest ideas and proven best practices to help transform supply chains. We want to empower both the people who elevate supply chains and the companies who utilize them.

With ASCM, we recognized an exciting opportunity with this new association to expand our reach and elevate our position even further. Something special is happening in the supply chain.As supply chain practices rapidly evolve, organizations need accessible tools and resources from an unbiased partner. ASCM is ready to make a powerful impact on the industry, corporations and their workforces.” – CEO of APICS, Abe Eshkenazi, CSCP, CPA, CAE

ASCM will provide learning and development through a powerful global network of alliances and thought leadership collaborations.

It will also offer the first comprehensive corporate designation that enables organizations to assess their supply chains in key areas for maximum sustainability, scalability and competitive advantage.

Group learning

ASCM Website FAQs

What is the mission of ASCM?

Our mission is to be the global leader in supply chain management transformation — every aspect, every audience. We will continue to hold ourselves to the highest standards, while we constantly redefine what’s standard. We are and will be driven by a desire to do more than just move the dial — to propel supply chain forward and transform how organizations do business.

What is new and different about ASCM?

ASCM’s largest differentiator is our network of global alliances and thought-leadership collaborations, which allows us to provide products and services for supply chain leaders and global organizations that have an end-to-end impact on supply chains around the world.

What is the mission of ASCM? What will happen to APICS?

The APICS brand and logo will continue to be a part of ASCM. APICS credentials (CPIM, CSCP, CLTD and SCOR-P) and the APICS body of knowledge will continue to be a global standard in learning and professional development for 60 years. Companies around the world recognize APICS certifications when recruiting and making hiring decisions. APICS North America Chapters and International Partners have been integral in providing members and candidates with the networking and training necessary to enhance their careers and earn their APICS certifications. Therefore, we will continue to uphold the credibility and integrity of the APICS learning systems, training and certification programs – all under the ASCM umbrella.

What is the ASCM Global Network?

ASCM works with a global network of world-class organizations. These collaborations fuel opportunities to initiate supply chain innovation and deliver a portfolio of products and services to our members and customers worldwide.

ASCM is expected to launch early in 2019.