Announcing Python in Excel: Combining the power of Python and the flexibility of Excel.
Since its inception, Microsoft Excel has changed how people organize, analyze, and visualize their data, providing a basis for decision-making for the millions of people who use it each day. Today we’re announcing a significant evolution in the analytical capabilities available within Excel by releasing a Public Preview of Python in Excel. Python in Excel makes it possible to natively combine Python and Excel analytics within the same workbook - with no setup required. With Python in Excel, you can type Python directly into a cell, the Python calculations run in the Microsoft Cloud, and your results are returned to the worksheet, including plots and visualizations.
QR or RFID card scan to cloud
Good afternoon - We are looking for a solution to track, through MS 365, unique QR or RFID card scans. The idea is to create unique ID cards (QR or RFID) to our members who will then scan them when they get to their appointment verifying they were there vs. our current process of them filling out paperwork and having the clinic sign it. Our thought is we'd place a dongle RFID or QR Code reader at certain locations and give them a link to a form, an app, a website, etc that records the information from the card once scanned. The challenge is we do not manage the individual sites so the solution would need to be easy enough that we provide the dongle reader, direct them to a site or install small app and when our members arrive and scan their card, the information is scanned to a secure spreadsheet or database that would document the date, time, card number and scan location. The designated locations would rather scan a card then sign a paper (COVID-19, etc). The intent is to add accountability and ease administrative work through a process of capturing attendance at various locations improving not only the experience of our members but the work needed to process these types of requests manually with paper. We do have the full suite of MS 365 and are just learning about all the functionality and features it offers. Thanks in advance.
Cloud-Only Configuration
The customer wants to start from NULL O365 "Cloud-Only" environment. What should be done so that the employees can work in an O365 Cloud-Only environment? I see most links talk about Hybrid Scenarios but not something start Cloud-Only from scratch. The tenant is arranged Domain registration E5 Licenses are ordered DNS entries Create Cloud-Only account and assign License to accounts Configure O365 Intune Win10 Devices How O365 Cloud-Only should be configured?
Arguments for the management (cloud features of core Office apps)
We are trying to convince the management of the amazing features that the Office 365 versions of the core products (Word, Excel, Powerpoint) brings. Especially small features that have a considerable effect on productivity or other things. You can say Office 2016 vs Office 365. An example for such a thing would be the dictate function within Word. Or also the editor function. If you could provide me with any resources that would be highly appreciated.
Access on the cloud?
Hello! I am new to learning Access and have a question about remote use. The small business I work for is interested in developing a practice management database using Access. We have about 20 employees, many who work remotely in other states. I'm seeing some mixed information on the internet, so I'm coming to the pros. Our concern is to make this database easily accessible for our employees, without slow runtimes, lost data, etc.. We would love for it to be cloud-based, but have a VPN our employees currently use to access company files. I've seen some people who run the frontend on Access and host the backend on MySQL. Some seem to prefer VPN. Some say Access isn't really well-suited to remote use. What is the best way--is it even realistic--to use Access as a database for a mostly-remote organization? If we're going to do this we want to ensure I'm learning what will be most beneficial, whether that's access or SQL/PHP, or something else altogether. Thank you for your help!
