Quadra

Connecting Technology and Business.

Import web data for Analysis in Excel

In Excel 2016, Microsoft has added an easier way to make “import data from the web” happen simple and fast.

If you need to grab a specific piece of data such as tablet with content, you need to follow these steps:

1- While in the web browser, visit the webpage that has the data you want, right-click and copy the link to the clipboard.

2- Open Excel and go to Data tab.

3- Click on New Query, select From other Source, and click on From Web.

http://www.windowscentral.com/sites/wpcentral.com/files/styles/larger_wm_brb/public/field/image/2015/09/data-source-web-excel216.jpg?itok=zB_AOB8g

4- On the next window, paste the source link and click OK, and select how you want to access the data, and click connect.

http://www.windowscentral.com/sites/wpcentral.com/files/styles/larger_wm_brb/public/field/image/2015/09/web-data-access-excel2016.jpg?itok=vDD-GMAQ

5- Excel 2016 will open the "Navigator", and it will load the data available from that web page, click on the table you would like to import, and click Edit.

http://www.windowscentral.com/sites/wpcentral.com/files/styles/larger_wm_brb/public/field/image/2015/09/web-data-import-excel2016.jpg?itok=1DUV93rJ

6- Now, Excel will fetch the data. Because this is an automated process, and data from the web isn't very reliable, you can easily clean up the table before inserting the data into your new document.

You can right-click on one of the columns to remove, or you can click the top-left corner of the table to convert the first row as headers, and much more. When you're satisfied with the data, click the Close & Load button.

http://www.windowscentral.com/sites/wpcentral.com/files/styles/larger_wm_brb/public/field/image/2015/09/query-editor-excel2016.jpg?itok=iWAmf8Wu

Now that the table is in Excel 2016, you can manipulate the data any way you want by using graphs, formulas, and more.

Tip: Furthermore, now that you have imported data from the web, Excel will save the source link into the file. This ability means that you can right-click the table and clicking Refresh. If the data has changed on the web, you will see the new data also updating in your table. This feature is particularly useful if you make any changes, and you want to roll back to the original data.

http://www.windowscentral.com/sites/wpcentral.com/files/styles/larger_wm_brb/public/field/image/2015/09/refresh-web-data-excel2016.jpg?itok=UGhcg7GY

Tell me what "Tell me what you want to do" is in Office 2016

Although, there aren't many new features in Office 2016, over the years Microsoft has been adding a lot of new features and even has added new apps (e.g., Sway and Planner). So, today is becoming more difficult to track and remember where a feature or a button is located within the app. This is when Tell Me becomes very useful.

http://www.windowscentral.com/sites/wpcentral.com/files/styles/larger_wm_brb/public/field/image/2015/09/tell-me-desktop-office-2016.jpg?itok=oYZizjRV

Tell Me sits on the tabs menu of every Office 2016 app. To use the feature, simply click on "Tell me what to do", and type what you want to know, such as commands you can't find or options you want to configure.

On the results, you will have instant access to the feature you're seeking. From the results, you can also get more help from the online Office documentation, and you can even jump right to Smart Lookup.

Look up anything using Smart Lookup in Office 2016

There is a new feature included in the Office 2016 apps called Smart Lookup. (This feature is similar to the one you'll find in Microsoft Edge when you ask Cortana for assistance in the web browser).

Smart Lookup allows users to research specific content using the web information through the Insights functionality.

http://www.windowscentral.com/sites/wpcentral.com/files/styles/larger_wm_brb/public/field/image/2015/09/office2016-smartlookup.jpg?itok=00zUOVqr

If you need to know the definition of a word, or you need to research a place or a person, or you simply want to know more about something specific. Instead of using the web browser and leaving the document, simply select and right-click the text you want to research, and select Smart Lookup.

Word opens a new Insights panel to the right of the screen and displays two tabs – Explore and Define.

Explore provides options to explore the web for the contents that deal with the selected word.

Define provides the dictionary definition of the word including phonetics and pronunciation of the word

Not only does Smart lookup add to user’s confidence but also proves itself as a wonderful language learning tool for Students and learners.

Here is an example of what you will see when you Smart Lookup “Edge”:

Explore tab:

Loading...

Explore Wikipedia

https://www.bing.com/th?id=OIP.M15f33cb6f9a897e3e3a00c928de45c87o0&pid=Api

Microsoft Edge - Wikipedia, the free encyclopedia

 

Microsoft Edge (codename "Spartan") is a web browser developed by Microsoft and included in the company's Windows 10 operating systems, replacing Internet Explorer as the default web browser on all device classes.

Enhanced Data Rates for GSM Evolution - Wikipedia, the ...

 

Enhanced Data rates for GSM Evolution (EDGE) (also known as Enhanced GPRS (EGPRS), or IMT Single Carrier (IMT-SC), or Enhanced Data rates for Global Evolution) is a digital mobile phone technology that allows improved data transmission rates as a backward-compatible extension of GSM.

 

More

Bing image search

Edge - Villains Wiki - villains, bad guys, comic books, anime

Edge

edge ancien champion world heavyweight

Edge WWE Superstar

 

Edge showing his well built 6 pack abs. Click on image to enlarge

 

Edge returns to SmackDown, only to get mixed up in a therapeutic ...

 

 

 

 

 

 

 

 

 

 

More

Web search

Edge.org

https://www.edge.org

 

To arrive at the edge of the world's knowledge, seek out the most complex and sophisticated minds, put them in a room together, and have them ask each other the questions they are asking themselves.

Edge - definition of edge by The Free Dictionary

http://www.thefreedictionary.com/edge

 

edge (ĕj) n. 1. a. A thin, sharpened side, as of the blade of a cutting instrument. b. The degree of sharpness of a cutting blade. c. A penetrating, incisive quality: "His simplicity sets off the satire, and gives it a finer edge" (William Hazlitt).

More

Powered by Bing



  • Copy

    Copy

    Define Tab:

    Loading...

    Edge

    [ej] Listen to the pronunciation

    noun

    noun: edge, plural noun: edges

1.     the outside limit of an object, area, or surface; a place or part farthest away from the center of something:

"a willow tree at the water's edge"

synonyms border, boundary, extremity, fringe, margin, side, lip, rim, brim, brink, verge, perimeter, circumference, periphery, limits, bounds border, boundary, extremity, fringe, margin, side, lip, rim, brim, brink, verge, perimeter, circumference, periphery, limits, bounds

antonyms middle middle

2.    the sharpened side of the blade of a cutting implement or weapon:

"a knife with a razor-sharp edge"

verb

verb: edge, third person present: edges, past tense: edged, past participle: edged, present participle: edging

1.     provide with a border or edge:

"the pool is edged with paving"

synonyms border, fringe, verge, skirt, surround, enclose, encircle, circle, encompass, bound, outline, trim, pipe, band, decorate, finish, border, fringe, bind, hem border, fringe, verge, skirt, surround, enclose, encircle, circle, encompass, bound, outline, trim, pipe, band, decorate, finish, border, fringe, bind, hem

2.    move gradually, carefully, or furtively in a particular direction:

"she tried to edge away from him"

synonyms creep, inch, work one's way, pick one's way, ease oneself, sidle, steal, slink creep, inch, work one's way, pick one's way, ease oneself, sidle, steal, slink

3.    give an intense or sharp quality to:

"the bitterness that edged her voice"

4.    ski with one's weight on the edges of one's skis.

origin

Old English ecg ‘sharpened side of a blade,’ of Germanic origin; related to Dutch egge and German Ecke, also to Old Norse eggja (see egg2), from an Indo-European root shared by Latin acies ‘edge’ and Greek akis ‘point.’

Powered by OxfordDictionaries © Oxford University Press

Powered by Bing



  • Copy


    Copy


Drive adoption of Office 365 - successfully

A successful Office 365 rollout focuses on driving adoption and helping everyone understand the benefits of working in a new way.

Driving adoption is about understanding the business challenges that organizations will address with solutions based out of Office 365. It is about ensuring that people across the organization understand the benefits and embrace the solutions you provide.

That's why Microsoft recommends a four-step approach to help organizations to successfully drive Office 365 adoption.

1. Define a vision and identify business scenarios

One of the most important factors in driving Office 365 adoption is to define a clear, concise, and comprehensive vision and outline the organization’s desired business scenarios. A well-defined business vision and list of targeted business objectives will serve as a guiding light throughout the launch and rollout planning, and also help secure buy-in across the organization.

2. Prioritize solutions and create an adoption plan

Once the organization has established its vision and has assessed its business challenges and opportunities, the next step is all about mapping the Office 365 capabilities to the organization’s targeted business goals and prioritizing the workloads that will help it get there.

3. Commit resources and execute an adoption plan

Raising awareness is an essential step to driving Office 365 adoption as it informs, involves, and inspires the users about the business value that Office 365 can bring to their day-to-day functioning. As the organization goes about launching the messaging and events, it must remember to highlight the vision and business scenarios that it has identified in the previous adoption stages so it can easily convey the "What's in it for me?"

4. Measure, share success, and iterate

As the organization moves through its adoption journey, it's important to continuously consolidate feedback, assess levels of success, and iterate on the approach through identifying new business scenarios, use cases, and audiences. After an organization-wide launch, it is essential to measure how well Office 365 has been received and how usage relates back to the success criteria that was established early on.

Archive your mails on the Cloud - No more local PSTs

Microsoft Exchange Online Archiving is a Microsoft Office 365 cloud-based, enterprise-class archiving solution for organizations that have deployed Microsoft Exchange Server 2013, Microsoft Exchange Server 2010 (SP2 and later), or subscribe to certain Exchange Online or Office 365 plans.

Note: For Exchange Online customers, Exchange Online Archiving is what is referred to as “In-Place Archive” as feature in Exchange Online.

Exchange Online Archiving assists organizations with their archiving, compliance, regulatory, and eDiscovery challenges while simplifying on-premises infrastructure, and thereby reducing costs and easing IT burdens.

Features

Archive mailbox

  • An archive mailbox is a specialized mailbox that appears alongside the users’ primary mailbox folders in Outlook or Outlook Web App.

  • Users can access the archive in the same way that they access their primary mailboxes. In addition, they can search both their archives and primary mailboxes.

Move messages to Exchange Online Archiving

  • Users can drag and drop messages from .pst files into the archive, for easy online access.

  • Users can also move email items from the primary mailbox to the archive mailbox automatically, using Archive Polices, to reduce the size and improve the performance of the primary mailbox.

Deleted item recovery

  • Users can restore items they have deleted from any email folder in their archive.

  • When an item is deleted, it is kept in the archive’s Deleted Items folder. It remains there until it is manually removed by the user, or automatically removed by retention policies.

  • After an item has been removed from the archive’s Deleted Items folder, the item is kept in the archive’s Recoverable Items folder for an additional 14 days before being permanently removed.

  • Users can recover these items using the Recover Deleted Items feature in Microsoft Outlook or Outlook Web App.

  • If a user has manually purged an item from the Recoverable Items folder, an administrator can recover the item within the same 14-day window, through a feature called Single Item Recovery.

Retention policies

  • Helps organizations reduce the liabilities associated with email and other communications.

  • Administrators can apply retention settings to specific folders in users’ inboxes.

  • Administrators can also give users a menu of retention policies and let them apply the policies to specific items, conversations, or folders.

  • Offers two types of policies: archive and delete. Both types can be applied to the same item or folder. For example, a user can tag an email message so that it is automatically moved to the personal archive in a specified number of days and deleted after another span of days.

In-Place eDiscovery

  • Supports In-Place eDiscovery for searching the contents of mailboxes, primary mailboxes and archives.

  • Administrators or authorized Discovery managers can search a variety of mailbox items – including email messages, attachments, calendar appointments, tasks, and contacts.

Scenarios

  • Reduce potential liabilities. Archive and delete emails as per business needs. Employees don’t have to create and manage multiple PST files on their devices any more

  • Reduce Risk. Compliance search and eDiscovery gives Legal/Compliance teams ability to search all emails

  • Drive Mobile Productivity. Employees can search and view all their emails from Outlook, Outlook on the Web and mobile devices.

Your company's IP remains your company's in Office 365

Rights Management Services enables users to restrict access to documents and email to specific people and to prevent anyone else from viewing or editing them, even if they are sent outside the organization.

  • Exchange Online IRM Integration. Enables users of Exchange Online to IRM protect and consume e-mail messages (and attachments). Exchange Online administrators can enable additional features, such as transport rules, to ensure content is not inadvertently leaked outside of the organizational boundary and edit the content of the message to include disclaimers.

  • SharePoint Online IRM Integration. Enables SharePoint Online administrators to create IRM-protected document libraries so that when a user checks-out a document from the IRM-protected document library, protection is applied to the document no matter where it goes and the user has the usage rights to that document as they were specified for the document library by the administrator.

  • Office IRM Integration. Enables Microsoft Office users to be able to IRM protect content using predefined policies provided by the service within an organization. Office applications that include these capabilities are Word, Excel, PowerPoint and, Outlook.

Features

  • Help protect emails against unauthorized access by applying different IRM options to email messages.

  • Enhance security of your SharePoint libraries by using IRM to set up appropriate permissions.

  • Help keep information safe, online or offline, because files are protected whether they’re viewed using Office Online or downloaded to a local machine.

  • Seamless integration with all Office documents helps guard an organization’s intellectual property.

  • Apply custom templates based on business needs in addition to using default Rights Management Services templates.

Examples of policies users can apply to email and documents with Rights Management for Office 365 are:

  • Do not forward (email)/ Restricted Access (Office apps): Only the recipients of the email or document will be able to view and reply. They cannot forward or share with other people or print.

  • ABC Company Confidential: Only people inside the organization (that is, people with an Office 365 account @companyname.com) can access the content, make edits, and share with others inside the company

  • ABC Company Confidential View Only: People inside the organization can view this content but cannot edit or change it in any way. They can print and share with other people inside the company.

Levels of Protection

Native

  • For text, image, Microsoft Office (Word, Excel, PowerPoint) files, .pdf files, and other application file types that support AD RMS, native protection provides a strong level of protection that includes both encryption and enforcement of rights (permissions).

 Generic

  • For all other applications and file types, generic protection provides a level of protection that includes both file encapsulation using the .pfile file type and authentication to verify if a user is authorized to open the file.

The Where and the How of Data Leak Prevention

To comply with business standards and industry regulations, organizations need to protect sensitive information and prevent its inadvertent disclosure. Examples of sensitive information that they might want to prevent from leaking outside their organization include financial data or personally identifiable information (PII) such as credit card numbers, social security numbers, or health records. With a data loss prevention (DLP) policy in the Compliance Center, organizations can identify, monitor, and automatically protect sensitive information across Office 365.

With a DLP policy, organizations can:

  • Identify sensitive information across many locations, such as SharePoint Online and OneDrive for Business.

For example, admins can identify any document containing a credit card number that’s stored in any OneDrive for Business site, or admins can monitor just the OneDrive sites of specific people.

In addition, separately from the Compliance Center, admins can also create a DLP policy in the Exchange Admin Center that applies to email and other mailbox items.

  • Prevent the accidental sharing of sensitive information.

Across all sites, admins can identify any document containing a health record that’s shared with people outside the organization, and then automatically block access to that document for everyone except the site owner, document owner, and the person who last modified the content.

  • Monitor and protect sensitive information in the desktop versions of Excel 2016, PowerPoint 2016, and Word 2016.

Just like in SharePoint Online and OneDrive for Business, these Office 2016 desktop programs include the same capabilities to identify sensitive information and apply DLP policies. DLP provides continuous monitoring when people share content in these Office 2016 programs.

  • Help users learn how to stay compliant without interrupting their workflow.

Admins can educate the users about DLP policies and help them remain compliant without blocking their work. For example, if a user tries to share a document containing sensitive information, a DLP policy can both send them an email notification and show them a policy tip in the context of the document library that allows them to override the policy if they have a business justification. The same policy tips also appear in Excel 2016, PowerPoint 2016, and Word 2016.

  • View DLP reports showing content that matches your organization’s DLP policies.

To assess how the organization is complying with a DLP policy, one can see how many matches each policy and rule has over time.

Admins create and manage DLP policies on the Data loss prevention page in the Office 365 Compliance Center.

- Office 365 Help pages

Your mails and attachments are the safest in Exchange Online

Microsoft Exchange Online Protection (EOP) is a cloud-based email filtering service that helps protect an organization against spam and malware, and includes features to safeguard the organization from messaging-policy violations. EOP can simplify the management of the company’s messaging environment and alleviate many of the burdens that come with maintaining on-premises hardware and software.

The following are the primary ways organizations can use EOP for messaging protection:

  • In a standalone scenario.   EOP provides cloud-based email protection for the organization’s on-premises Exchange Server 2013 environment, legacy Exchange Server versions, or for any other on-premises SMTP email solution.

  • As a part of Microsoft Exchange Online.   By default, EOP protects Exchange Online cloud-hosted mailboxes.

  • In a hybrid deployment.   EOP can be configured to protect the messaging environment and control mail routing when the company have a mix of on-premises and cloud mailboxes.

Features

Anti-malware protection

  • Using multiple anti-malware engines, EOP offers multilayered protection that’s designed to catch all known malware

  • Messages transported through the service are scanned for malware (viruses and spyware)

  • If malware is detected, the message is deleted. Notifications may also be sent to senders or administrators when an infected message is deleted and not delivered.

  • Office 365 Admins Customize anti-malware policies in the EAC. They can configure the default policy for company-wide settings.

  • Admins can create custom content filter policies and apply them to specified users, groups, or domains in the organization

Anti-spam protection

  • Uses proprietary anti-spam technology to help achieve high accuracy rates.

  • Provides strong connection filtering and content filtering on all inbound messages.

  • Outbound spam filtering is also always enabled if the service is used for sending outbound email.

  • Spam filtering cannot be completely disabled, but certain company-wide settings can be modified by editing the default anti-spam policies

  • Admins can create custom content filter policies and apply them to specified users, groups, or domains in the organization.

Quarantine

  • Messages identified as spam and messages that match a transport rule can be sent to the administrator quarantine.

  • Administrators can search for and view details about quarantined email messages in the EAC.

  • After locating the email message, Admins can release it to specific users and optionally report it as a false positive (not junk) message to the Microsoft Spam Analysis Team if it was misidentified as spam.

  • Spam quarantine for end users lets them manage their own spam-quarantined messages.

Junk Email Reporting

  • From Office Outlook or Outlook Web Access, EOP lets users easily report junk (spam) email to Microsoft for analysis to help reduce the number and impact of future junk email messages filtered by the service.

Hold a Townhall style meeting using Skype Meeting Broadcast

Skype Meeting Broadcast enables organizations to broadcast a Skype for Business meeting on the Internet to up to 10,000 people, who can attend from a browser on nearly any device. Meeting broadcast makes it easy to host large virtual meetings like internal “Town Hall” style meetings and public webinars. The service includes integration with Bing Pulse, for real-time polling and sentiment tracking, and Yammer, to enable attendee dialogue during the broadcast.

Skype Meeting Broadcast roles

  • Organizer. Creates the meeting request and invites attendees. Reviews meeting reports.

  • Producer. Manages the meeting sources (live presentations, dial-in presentations, audio, video, and PowerPoint decks), records the event, and posts the recording to Office 365 Video.

  • Event team member. Participates in the meeting by presenting live or dialing in from a remote location.

  • Attendee.  Watches the event online.

 Attendee options

  • Anonymous: anyone with the meeting link can join the meeting

  • Secure: only attendees listed below can join the meeting

  • All Company: anyone from my company can join the meeting

Features

Schedule a meeting: Use the Skype Meeting Broadcast scheduling and management portal to schedule a meeting

  • Manage an Event: Upload PowerPoint decks, cue live feeds from Camera sources, activate feeds and, switch sources during event. Users can have one feed providing audio and another providing video.

  • Customize a meeting: Add a Yammer feed or Bing Pulse to meeting so the audience can participate during the event and the user can gauge their involvement and satisfaction

Large Meeting Capabilities

The Maximum audience Size is 10,000. The presenter can have the audio and video capabilities. The presenter can also present a PowerPoint show and also share the Desktop / app. Yammer, Pulse and Q & A can be used during the meeting to engage with listeners. The whole meeting can be recorded and stored on the cloud. Client side DVR controls like pause and rewind are allowed. The whole meeting can be branded. There is also a possibility of nominating somebody as a Meeting Producer.

Set up Skype Meeting Broadcast

Distribution of the media content of a broadcast meeting utilizes Microsoft Azure's Content Delivery Network (CDN) to achieve very high scale, supporting thousands of people watching a broadcast. The chunked media content passing through the CDN is encrypted, and the CDN cache has a limited lifetime. Skype Meeting Broadcast has been disabled by default for all locations worldwide.


Customers with EU Standard Contractual clauses must choose whether or not to opt into the service after reviewing the information in Microsoft’s communication to them.  In the regions not affected by the EU Standard Contractual Clauses, the IT Admin can manually activate the Skype Meeting Broadcast feature.

To setup …

  • Enable Skype Meeting Broadcast for your organization: The O365 / Skype for Business Admin has to enable Skype Meeting Broadcast for the organization.

  • Enable external access and setting up allowed domains: The Admin can use either Skype for Business admin center or the Office 365 admin center to enable external access and allow access.

The Skype Meeting Broadcast portal can be found at portal.broadcast.skype.com.

Microsoft Azure and the small / medium business

With the fast pace of innovation constantly accelerating, it’s becoming increasingly expensive for SMBs to keep investing in the latest and greatest IT solutions. At the same time, relying on older solutions while competitors invest in new ones gives a leg up on them to anticipate, manage, and respond more quickly to change.

By turning to Microsoft Azure and the cloud, SMBs can keep their competitive edge without expanding their budget. Azure helps SMBs bring products and services to market quickly. They can instantly scale globally, with everything needed to support worldwide business growth. They can run their operations more cost-effectively, paying only for what they use as opposed to for what they don’t. They can also free up their budget to spend on other business needs by eliminating the cost of new hardware. And they can gain enterprise-level security with the same data protection and datacenter security that many of the world’s largest organizations receive today.

Business focus

SMBs want to focus on running their business and increasing their bottom line,  not on their infrastructure. With Azure, they can build, deploy, and manage applications in the cloud without worrying about the cost of purchasing new server hardware. They can easily scale up or down as needed and gain peace of mind knowing they have the added protection of multiple data backups in Microsoft-managed datacenters.

Business Continuity

Many businesses lose critical data because they don’t have a data backup solution. Azure offers simple, reliable backup for company's data and applications that is affordable because they pay only for the storage they use. There are no typical infrastructure costs or per-server or data transfer fees. Plus their applications receive the same level of protection that Microsoft enterprise customers, including many of the world’s largest financial institutions, receive.

Business Boost

Any business can host its own website, but is the risk of poor performance, security breaches, and skyrocketing costs worth the price? With Azure, SMBs can quickly and easily host scalable websites in the cloud. Microsoft uses multiple datacenters around the world, helping provide business and their customers with a reliable, satisfying, and secure experience that enables them to deploy their applications close to their customers.

Microsoft uniquely offers a flexible platform that lets SMBs choose the path that is best for their business, whether that’s on-premises, in the cloud, or a hybrid combination. Working seamlessly with other Microsoft software and services such as Windows Server, SQL Server, and SharePoint, Azure helps make the cloud a seamless part of a business' IT in a way that is best for a company’s specific needs.