Quadra

Connecting Technology and Business.

Book a room for your Scheduled meeting using Outlook

When you create a meeting request, it is typical and convenient to include the meeting location for the meeting or event. You can use the Address Book to find a conference room.

      • Click New Items - > Meeting or Reply with a Meeting from the Home tab of the Outlook Mail window or New Meeting from the Calendar
      • Keyboard shortcut to create a new meeting request is CTRL+SHIFT+Q.

      • In the Subject box, type a description of the meeting or event.
      • To open the Address Book to see which rooms are available, next to the Location box, click Rooms.

        Note: If you don't see the Rooms button, you might have opened an appointment instead of a meeting request.

        • In the Start time and End time lists, click the start time and end time for the meeting. If it is an all-day event, select the All-day event check box.

        An all-day event is a 24-hour event that lasts from midnight to midnight.

        Note: By default, the current time-zone setting on your computer system is used to schedule meetings. If you want to schedule meetings based on an alternative time zone, on the Meeting tab, in the Options group, click Time Zones.

          • Type any information that you want to share with the recipients or attach any files,
          • On the Meeting tab, in the Show group, click Scheduling Assistant.

        The Scheduling Assistant helps find the best time for your meeting.

          • Click Add Attendees.
          • In the Select Attendees and Resources dialog box, in the Search box, type the name of a person or resource that you want to invite to the meeting, and then click Go.
          • Select the name from the results list. Click Required, Optional, or Resources; and then click OK.

        Required and Optional attendees appear in the To box on the Meeting tab, and Resources appear in the Location box.

        The Scheduling Assistant displays a free/busy grid that shows the availability of attendees. A green vertical line represents the start of the meeting. A red vertical line represents the end of the meeting.

        The Suggested Times pane locates the best time for your meeting, which is defined as the time when most attendees are available. The best meeting time appears at the top of the pane. To select any one of the suggested times, click the time suggestion in the Suggested Times pane. You can also manually select a time on the free/busy grid.

          • If you want to make the meeting recur, on the Meeting tab, in the Options group, click Recurrence, select the recurrence pattern, and then click OK.

        When you add a recurrence pattern to a meeting request, the Meeting tab changes to Recurring Meeting.

          • On the Meeting tab, in the Show group, click Appointment.
          • Click Send.

      - Customized from the Support pages of Microsoft Office

          Don't live with a Cluttered Desktop

          If you open the same folder again and again or if you open the same file very frequently, you can use various tricks to open them with just a click. So, don't save them on your Desktop anymore.

          Here are the tips:

          1. Right click the File Explorer icon pinned to the Task bar and you will see a pop-up with your frequently opened folders and files. You can also pin some of them for quicker access so that they are not lost when others are getting listed in due course.

          2. If you are running Windows 10, the navigation pane also contains a Quick Access feature. Click this and you will see the frequently opened folders and recently opened files. Even here you can pin some of them for quicker access so that they don’t move away from the list in due course.

          3. If you have pinned the Word, Excel or PowerPoint applications to the task bar then, there are jump-lists created for the respective applications that will help you to open the files. (Folders are not listed). Right click the respective icons on the task bar and you will see the recent files listed. Push-pinning some of the files listed will help here too.

          4. If you are spending your whole day in Outlook, you can create Shortcuts to your folders and files in Outlook in the Shortcuts folder (7th from the Mails icon) also use Outlook to open it for you.


          Create a new Shortcut group in the Shortcuts folder on Outlook. Open the File Explorer and drag the folder / file under the new Shortcut group.

          MAXImise productivity & MINImise confusion - Use MAXIFS and MINIFS

          If you’re familiar with statistical functions like COUNTIFS, SUMIFS and AVERAGEIFS, then MAXIFS and MINIFS don’t need much explanation.

          The classic MAX and MIN functions calculate the maximum or minimum value in a range, but what if you need to apply conditions to filter your data? This is precisely what MAXIFS and MINIFS allow.

          Now you can apply conditions and filter data before calculating with MAXIFS and MINIFS in Excel.

          The MAXIFS and MINIFS functions are available if you are an Office 365 subscriber and have the latest version of Office installed on your PC. It is also available in Excel Online and in Excel Mobile or Excel for Android phones and tablets.

           

          You can specify one or more conditions that filter the data before calculating the max or min. The conditions can be applied to adjacent ranges or the range that contains the values. For example, let’s say a retailer has a table containing sales data for all their stores. They can use the MAXIFS and MINIFS functions to calculate the maximum and minimum sales figure for a specified item in stores located in a specified region.

           

          The MAXIFS function returns the maximum value among cells specified by a given set of conditions or criteria.

           

          Here is the Syntax:

           

          MAXIFS(max_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

           

          The MINIFS function returns the minimum value among cells specified by a given set of conditions or criteria.

           

          Here is the Syntax:

           

          MINIFS(min_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

           

          The size and shape of the max_range and criteria_range arguments must be the same, otherwise these functions return the #VALUE! error.

           

          In the example shown below, MINIFS and MAXIFS are used to calculate the min and max sales figures from the table, but it only includes values from the Sales column if the value in the Retailer column is “BigMart,” the value in the Brand column is “Longlast” and the value in the Sales column is greater than zero.

           

           

          Bewildered with nested IFs? Try the new IFS

          The logical function IFS is available if you are an Office 365 subscriber and have the latest version of Office installed on your PC or you are using Excel Online. It is also available in Excel Mobile and in Excel for Android phones and tablets.

           

          The IF function is one of the most commonly used logical functions in Excel, and using IF inside IF (nested IF functions) has been a common practice in Excel, but it can be challenging or confusing at times.

           

          Here is an example of cluttered/ nested Ifs:

           

           

          The new IFS function help specify a series of conditions. IFS gives you an alternative to using a series of nested IF functions, when you have more than one condition that you want to test to find a corresponding result. The IFS function checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.

           

          The advantage of using the new IFS functions is that you can specify a series of conditions in a single function. Each condition is followed by the result that will be used if the condition is true—making it very straightforward to create and read the formula afterward.

           

          Here is the syntax:

           

          IFS(logical_test1, value_if_true1, [logical_test2, value_if_true2], [logical_test3, value_if_true3],…)

           

          Because Excel functions are limited to 254 parameters, you can use up to 127 pairs of condition and result arguments in this IFS function.

           

          For example, let’s say you want to get the grade letter for a given score on a test. Using the IFS function, it might be something like this:

           

          =IFS(C1>=90, “A”, C1>=80, “B”, C1>= 70, “C”, C1>=60, “D”, C1<60, “Fail”)

           

           

          This can be read as, if the grade in C1 is greater than or equal to 90, it’s an A. Otherwise, if it’s greater than or equal to 80, it’s a B. Otherwise, if it’s greater than or equal to 70, it’s a C and so on. It’s pretty easy to write it this way and it’s also straightforward to read and understand what’s going on.

           

          Note:

          The SWITCH function is also a powerful logical function and can handle multiple conditions. What makes it different is that rather than specifying a series of conditional statements, you specify an expression and a series of values and results. The values are compared to the expression, and when the first exact match is found, the corresponding result is applied to the cell. You can also specify a “default” result that will be returned if none of the values are an exact match for the expression. The advantage of the SWITCH function is that you can avoid repeating the expression over and over, which sometimes happens in nested IF formulas.

           

          In the example below, the first part of the formula extracts the size code (i.e. XS, M and G) from the middle of the item in column B. It’s rather long, so it’s nice that SWITCH only needs it to be written once and it can be compared to a list of values.

           

          The example below can be explained as:

           Extract the size code from the item in column B. If it equals “XS”, the result is “Extra Small.” Otherwise, if it equals “S”, the result is “Small” and so on. If there’s no match, the result is “Not Specified.”

           

           

          Again, because Excel functions are limited to 254 arguments, you can use up to 126 pairs of value and result arguments in this SWITCH function.

          Forget CONCATENATE and the Clutter

          Combining text strings has become easier using TEXTJOIN in Excel 2016 of Office 365 ProPlus and is available for subscribers right-away. (You must have the latest version of Office installed in your PC). This is also available for users using Excel Online, Excel Mobile and Excel for Android phones and tablets.

           

          A very common task for users in spreadsheets is to combine text strings, but until now, if you wanted to join text strings from a range of cells, you had to specify each cell individually. The new TEXTJOIN functions let you combine text strings from ranges of cells with or without using a delimiter, such as a comma separating each item. You can simply refer to the range and specify the delimiter once and let Excel do all the heavy lifting. If the delimiter is an empty text string, this function will effectively concatenate the ranges.

           

          The old-fashioned way:

           =CONCATENATE(A3, “, “, B3, “, “, C3,”, “, D3, “, “, E3)

           

          The new way to join text strings using TEXTJOIN:

           =TEXTJOIN(“, “, TRUE, A3:E3)

           

          TEXTJOIN has three arguments – (1) the delimiter to be used, (2) whether to ignore empty cells and (3) the range in which the text strings are located.

           

          So, you simply specify the comma (or whatever separator you want), choose whether to ignore empty cells (True) or include empty cells (False) and then specify the range. If a number is supplied, it will be treated as text.

           

          For example, =TEXTJOIN(" ",TRUE, "The", "sun", "will", "come", "up", "tomorrow.") will return The sun will come up tomorrow.

           

          There can be a maximum of 252 text arguments for the text items, including the first text. Each can be a text string, or array of strings, such as a range of cells. If the resulting string exceeds 32767 characters (cell limit), TEXTJOIN returns the #VALUE! error.

           

          Here is another example:

           

          Let’s say you just want to join the parts of an address into a single text string. The old way would require you to specify each cell and repeat a comma that separates each part:

           

           

          The new way is much simpler.

           

           

           

          Note:


          There is also a similar and improved function CONCAT. This CONCAT replaces the CONCATENATE function though the CONCATENATE function will still be available for backward compatibility.

           

          The CONCAT function combines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or Ignore Empty arguments.

           

          For Example, =CONCAT("The"," ","sun"," ","will"," ","come"," ","up"," ","tomorrow.") will return The sun will come up tomorrow.

           

          There can be a maximum of 253 text arguments for the text items. Each can be a string, or array of strings, such as a range of cells. If the resulting string exceeds 32767 characters (cell limit), CONCAT returns the #VALUE! error.

          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


          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

          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.

          Advanced analytics functionality in Excel 2016

          Excel 2016 provides capabilities that allow users to further enhance your data analysis experiences and share their data and analysis more effectively across their company. These features, usually suitable for professional business analysts, come with all premium plans of Office 2016, including Office 365 ProPlus, Office Professional Plus, Excel 2016 Standalone, and now also in Office 2016 Professional.

          Here is the list of the advanced analytics features:

          Advanced analytics and modelling capabilities with Power Pivot

          With the full Power Pivot management UX, users can benefit from advanced modelling capabilities like Diagram View, KPIs, Hierarchies and DAX Calculated Columns.

          New ways to get the Excel business analytics features  1

          Advanced connectivity options with Power Query

          For corporate users who require advanced connectivity and importing features, Microsoft has added the option to connect to corporate, big data and cloud data sources, such as Oracle, DB2 or MySQL database, a variety of Azure data sources, such as Azure SQL Database, Salesforce, Hadoop files and many more.

          New ways to get the Excel business analytics features  2

          Advanced collaboration

          With an addition of Power BI license, users will also benefit from a corporate data search and will be able to share their import and transformation queries with other analysts within their organization through the means of a Corporate Data Catalog.

          New ways to get the Excel business analytics features  3

          -Microsoft Excel Team

          Enhance visualization using new charts in Excel 2016

          Waterfall—visualizing financial statements with ease

          Most business owners seek to better understand their finances in order to ensure their success. Profit and loss statements can help explain the bottom line of your business. However, quickly understanding and communicating your gains, losses and balances by viewing financial statements can be challenging. With a Waterfall chart, you can quickly illustrate the line items in your financial data and get a clear picture of how each item is impacting your bottom line. The example below shows the income statement for a bookstore. It