This article is contributed. See the original author and article here.
Adobe has released security updates to address vulnerabilities in multiple Adobe products. An attacker could exploit some of these vulnerabilities to take control of an affected system.
CISA encourages users and administrators to review the following Adobe Security Bulletins and apply the necessary updates.
This article was originally posted by the FTC. See the original article here.
For someone who wanted to run their own business, it seemed like a great opportunity — buy your own burger franchise and get training and support to help you succeed. And if you’re a veteran, you even get a discount. But for people who paid for a Burgerim franchise, the promises of support and refunds didn’t turn out to be true, the FTC says.
According to a lawsuit filed on the FTC’s behalf by the Department of Justice, Burgerim and its owner promoted their franchises as “a business in a box” and said the company would support people as they established the franchise, including securing loans, locations, and licenses needed to run the business. In many cases, Burgerim also promised franchisees it would refund the franchise fee if the franchise was unable to open.
But in many cases, franchisees couldn’t secure financing or locations for their restaurants and didn’t get promised refunds, the FTC says. Buyers also didn’t get all the information they were entitled to under the Franchise Rule, which is designed to make sure that people thinking about buying a franchise have the information they need to weigh the risks and benefits of their potential investment. The FTC says Burgerim made tens of millions from franchise sales, but most franchises that were sold never opened, and some franchisees lost tens of thousands of dollars.
If you’re trying to decide whether a franchise is right for you, start with this guidance for franchisees from today’s Business Blog post. Then read our guide, A Consumer’s Guide to Buying a Franchise. It includes key questions to ask before you invest, and also explains how to use the Franchise Disclosure Document — a document franchisors have to give you so you can investigate and evaluate a franchise opportunity.
Already have an issue or concern about a franchise? The FTC wants to hear from you. Visit ReportFraud.ftc.gov and select the option for reporting issues with franchise opportunities. Or, use this specially created link. It takes you directly to a form created specifically to collect information related to franchises.
Brought to you by Dr. Ware, Microsoft Office 365 Silver Partner, Charleston SC.
This article is contributed. See the original author and article here.
We are excited to announce that LAMBDA and LAMBDA helper functions are now generally available to anyone using Production: Current Channel builds of Excel. In conjunction with LAMBDA going to production, we are also announcing the release of a new add-in, the advanced formula environment, sponsored by the Microsoft Garage and Microsoft Research, which allows for improved formula authoring experiences and easy import/export of named LAMBDAs.
Thanks to all of our Insiders for using the LAMBDA functions and giving us feedback! As a result we’ve also made a few changes that we’ll outline below in addition to talking about the advanced formula authoring environment, a Microsoft Garage project.
Let’s start with a quick example.
A task I regularly encounter is replacing certain values in a dataset, such as errors or blanks cells. Excel provides IFERROR to replace error values, but there is no function to replace blank cells. Fortunately, with LAMBDA, we can define our own function, IFBLANK.
Instead of authoring this in the grid and then importing to the name manager, I will instead author this in the new formula environment and then sync it to the workbook to make use of it in the grid.
In today’s scenario I am trying to create a quick count of the meals that have been requested for a dinner party I am hosting.
Without IFBLANK, Excel, by default returns a 0 for blanks. I could work around this but I also need to get a count of orders which I will do using MAP and REDUCE to author one formula so I can get updated counts as I continue to get more responses from guests.
Here’s the formula I used for the counts:
=MAP(D4#, LAMBDA(meal, REDUCE(0, IFBLANK(Table14[Meal Preference], B1), LAMBDA(meal_count, preference, IF(meal=preference, meal_count+1, meal_count)))))
Lets go over some improvements and changes we have made on our journey through Insiders to the LAMBDA feature in general.
Function tooltips
We have added support for function tooltips for named LAMBDAs in addition to auto-completing the open parentheses character when calling these functions. In other words, calling a function defined using a LAMBDA is exactly the same as calling a native function.
Recursion limit increase
We have upped the limit of recursion by 16 times its original limit. In this example, the text string is 3200 characters long and would have previously returned a #NUM when called with a LAMBDA that recursively reverses a text string.
LAMBDA helper function outputs
We changed the way that the LAMBDA helper functions handle arrays of references.
Previously when a LAMBDA helper function returned an array and the associated LAMBDA returns a single cell, a #CALC error would be returned. We have changed this to automatically return the cell value as the output of the LAMBDA function.
In this example, Excel would have returned a #CALC but now will return the results.
Today we are introducing a new tool to aid in the authoring of more complex named formulas. The advanced formula environment is a space where we are hoping to experiment and explore new and different methods for authoring formulas with special functionality designed with LAMBDAs and LET in mind.
Key features of the new tool:
The environment is available on all platforms where Office Add-ins are available (Mac, Windows, Web)
Let’s take a look at some of the functionality so you can get started with managing and editing your new and pre-existing named functions!
There are two major views contained within the advanced formula environment, Manager and Editor.
Manager
The Manager is where you will see all of your names with their own individual cards and associated quick actions. Much like the Name Manager but with more functionality.
 | Edit the name |
 | Rename the formula |
 | Delete the entry |
 | Export the definition for sharing |
Editor
The Editor is where you can go to edit all entries within the workbook or create new namespaces for collections of formulas.
This is where I usually go when I want to dive in to create more complex functions as you get the full version of the editor in this view and can create multiple names sequentially.
The workbook section contains all names which are not attached to a given sheet but instead are saved globally in the workbook.
Some of my favorite pieces of functionality are the ability to easily add new lines, tabulate sections of the formula while also being able to comment out pieces of my formula that I might be working on, or collapse definitions so I can more easily dig into specific areas. Not to mention, if I change my mind later, I can easily undo/redo any changes I am actively working on.
Here’s another example I made for a chess game I have been building for fun in Excel.
Importing
The advanced formula environment can import definitions into the manager. You can important individual definitions as well as libraries of definitions via text or through GitHub Gists.
The main entry point for importing can be found by selecting the action in the actions bar. The main entry point defaults to “From URL” but the dropdown reveals the “From text” option.
If you’d like to try out this functionality yourself I am including a gist with some of the examples I created today on top of additional LAMBDAs I have used in prior posts. I think this is a better way to share than having you copy/paste from a blog post, so lets be the first to try it out!
aka.ms/LAMBDAGist (make sure to use the URL you are redirected to as the add-in doesn’t let you use non gist paths)
We look forward to the libraries of LAMBDAs the community produces and hearing from you all about what does and doesn’t work in this new environment we have created.
We are actively looking for feedback on the experience and would invite you to provide feedback either through techcommunity or by going to this github repository.
To get access to LAMBDA functions, please make sure you have updated to the latest version of Excel. Specifically versions greater than or equal to:
What version of Office am I using?
You can use this link or manually install if from the app
To access the advanced formula environment, simply search for the “advanced formula environment” within the built-in add-ins store of Excel and install it like any other Office add-in.
Once the add-in is installed, you should be able to find it on your home tab. The ribbon button looks like the picture below.
Click here to learn more about Office Add-ins
To learn more about LAMBDA and the advanced formula environment, please check out the links below and in the meantime we are excited to hear more about the ways you have used LAMBDA in your own workbooks!
LAMBDA is now available to Office 365 Subscribers in Production: Current Channel
To stay connected to Excel and its community, read the Excel blog posts and send us ideas and suggestions via UserVoice. You can also follow Excel on Facebook and Twitter.
The last thing I would like to mention is that all of this was done as a joint collaboration between Microsoft Research and Excel Engineering. It’s been a blast building out all the experiences you see today and it wouldn’t have been possible without the brilliant researchers at Microsoft Research Cambridge.
Chris Gross
Program Manager, Excel
Jack Williams
Lead Developer and Researcher, Microsoft Research Cambridge
This article is contributed. See the original author and article here.
The new era of digital has ushered in a once-in-a-lifetime opportunity, as well as make-or-break challenges. Fast-moving organizations are seizing the moment to capture a sizable audience. But keeping customers is more difficult than ever. Organizations, facing mounting privacy regulations coupled with wary customers, are moving beyond third-party data to zero-party data for powering customer experiences. They are taking a hands-on approach and amassing customer data directly, according to a front-page article in the Wall Street Journal.1 In the wake of disruptive changes, organizations are turning to trusted solutions like Microsoft Customer Experience Platform.
Savvy organizations see privacy as a challenge that can become a strategic opportunity to build trust with customers and differentiate themselves against competitors. They’re embracing transparent and ethical data practices built around zero-party data, which in combination with existing data, makes it easy to deliver highly-personalized experiences that customers actually wantand avoid privacy mishaps. Respecting customer privacy requires a holistic approach encompassing data collection, utilization, and governance. For example, organizations need to ensure that analytics and artificial intelligence initiatives utilize only permissible customer data, which may be highly-sensitive in nature.
The majority of consumers expect companies to deliver personalized interactions. However, this expectation is met with wariness about sharing personal information and fear that data will be misused, or that they will be inundated with a barrage of advertisements, emails, and intrusive outreach. Zero-party data is key to achieving privacy-aware personalization.
Zero-party data is a form of self-reported data a consumer willingly and actively provides a brand. Customers knowingly and intentionally share this data with an organization in order to get a more personalized experiencesuch as a tailored recommendation, pricing, or access to additional resources. Organizations have opportunities to collect this data across the entire customer journeywhile the customer is on the website, social channels, email, inside a mobile app, or even in personthrough loyalty programs and creative approaches like sweepstakes, newsletters, quizzes, polls, and QR codes. Unlike first-party data which is based on historical events and requires interpretation, zero-party data is explicit data that reflects customer motivations, desires, interests, and preferences. Just as important, zero-party data has moved from buzzword to data hero, becoming an essential part of an organization’s digital strategy and countering the eminent demise of the much relied upon third-party cookies.
Nothing beats zero-party data for quality and consent, but there’s still a role for other types of data in your marketing mix.
First-party data, for example, remains an essential source of customer insight. Like zero-party data, first-party data is data about a company’s customers collected and owned directly by the company. Types of first-party data include web and app behavior, purchase history, loyalty status, or call center interactions. And although the methods used to obtain first-party data aren’t always as straightforward or transparent as those used to obtain zero-party data, it’s nonetheless valuable data that will help accelerate the pivot from third-party data.
Third-party data, like those that come from external sources like third-party cookies that track web browsing or advertising, has a place at the table (along with second-party data, which is someone else’s first-party data). The goal is not to banish third-party data entirely; instead, it’s to decrease reliance on third-party data while simultaneously increasing the collection of zero-party and first-party data.
As organizations across every industry face the imminent deprecation of third-party cookies and mounting regulations, the right partner and technology are key. With the right solutions, organizations can respect consumer privacy without compromising the personalized experiences that customers value. For organizations that approach privacy as a fundamental human right, the return on investment will encompass an entirely new relationship with customersone that is built on trust and mutual engagement.
That’s where Microsoft Customer Experience Platform comes in. Microsoft has worked with customers around the world, and their marketing leaders consistently emphasize that to meet today’s expectations of privacy and personalization, they need to deliver consent-aware engagement along the entire customer journey, powered by insights based on zero through third-party datasomething they struggle with because of the proliferation of data sources scattered across multiple systems, making it impossible to gain a complete view of the customer that’s essential for connected experiences. With privacy and consent built into the platform, organizations can be rest assured that data is responsibly collected, utilized, and governedthe foundation for meaningful engagement, raving fans, and lasting customer relationships. To learn more, read the related Microsoft Customer Experience Platform blog post and visit Microsoft Customer Experience Platform.
Sources:
The post Zero-party data is more valuable than ever for customer experiences appeared first on Microsoft Dynamics 365 Blog.
Brought to you by Dr. Ware, Microsoft Office 365 Silver Partner, Charleston SC.
This article is contributed. See the original author and article here.
Mozilla has released security updates to address vulnerabilities in Firefox and Firefox ESR. An attacker could exploit some of these vulnerabilities to take control of an affected system.
CISA encourages users and administrators to review the Mozilla security advisories for Firefox 97 and Firefox ESR 91.6 and apply the necessary updates.
Recent Comments