ms office – Shortcuts in Keynote

I recently switched from Powerpoint to Keynote. Although I'm overall happy with the transition, I feel that there are too many clicks to do simple things. For example:

  1. If I want to align objects after selecting them, I have to press the button Arrange tab> Align drop-down menu> Left. In PowerPoint, I simply click Align left on the Quick access toolbar.

  2. If I want to change the fill color or the outline color of a shape, I have to press Style tab> Fill. In PowerPoint, I just have to click on the button Fill color in the Quick access toolbar.

Although it does not seem like much, it is tedious to have to click on each tab to do something that would otherwise be done in one click. It gets worse if I work with an animation and then I have to work with a shape, adding 1 extra click at the top to select Format

So my question is: Is there a "shortcut toolbar" or "quick access toolbar" in Keynote in the same way as in Powerpoint?

ms office – Can I filter multiple columns at the same time in Excel?

I could not find a good answer for Google, so here it is:

I have a lot of data on which I want to filter two columns: location and evaluation. I've worked how to do one at a time (just the usual filtering function), but I want to filter these two elements at the same time? So, I only have people from location X and Y-rating – is it possible?

Thank you!


sharepoint online – Can we prevent users from accessing Office 365 from certain IP addresses

we have a 365 office tenant and our team in India is actively using it for its daily activities. But now, we only want to allow users to access Office 365 from their desktop network. can we do it in Office 365.

When users connect from an IP address other than the company's network, access is simply blocked.

[ Mythology & Folklore ] Open question: Why did Trump spend 290 of his 547 days in the office, whether at golf or in his private clubs? That's more than half?

Do you think it may be because he works 10 times stronger than other presidents, so he needs 10 times the holidays?

Should not my taxes be used for something useful? Do you like a specialized nurse?

Microsoft Office 365 – How to open a short code file on a USB key?

I was working on an article and my work was not saved between the changes.

My automatic registration was activated, the backup on Onedrive was not, and I remember to be in a hurry to close the document and see the option "Save as copy" instead to "Save" or "Save As". I just closed the document knowing that it was already saved on my desk. I last recorded at 23:09 (I'm 95% sure that's the version I want), but when I reopened it, the version I saw was from from 17.20.

Anyway, after trying to browse the location of AutoSave, recently opened, etc., there was nothing, fearing to write too much file, I quickly installed EaseUS Data Recovery. He found a shortcut file saved at 23:09 that I retrieved on my external USB drive (D 🙂

Now, I'm trying to find it in its original form since last night. I've already missed my deadline so I'm already super late.

But here is what I've done so far:

almost all websites recommended the same line of words for typing cmd; Not been administered =

My last saved was old with barely a few words, so it does not help me =

How to recover shortcut files on a USB key =

I did not understand how to change the path here, so did not help = https: //

CMD executed as administrator after reading this and added a path without the colon because another website stated that it was only required for older versions of windows =

Other things that I have looked at but that I did not think apply to me:

I have tried to scan my computer for viruses and updates, changed my username to a name containing no special characters because I learned that the system Windows operating system did not like that, tried to use cmd: add my username, then try it without username, then insert "C: "as a recovery location (after copying the shortcut to the desktop).

I am totally helpless. I can not rewrite the article the way I wrote it before, is there still hope for me?

NOTE: DO NOT FORGET, I have the version of the shortcut word on USB, I'm just trying to open it

and im mostly a lurker, but first post so new on this forum, so maybe do not know how to answer + formatting

Co-authoring Office documents in sharepoint document libraries, can we do this when opening documents with the help of desktop applications?

The feature you describe is available with Office 365 licenses. The desktop, browser, Mac, phone, and Excel / Word for Windows tablet can be used simultaneously by different people to edit a document residing in SharePoint Online or OneDrive.

It is important to note that the Excel / Word desktop application, etc., must have the Auto Save slider enabled. Otherwise, co-creation is not possible.

enter the description of the image here

Everyone involved in co-authoring must have an Office 365 license.

Here is an excerpt from the Microsoft support page:

Why am I getting the error "File is locked"? There is a handful of
reasons this error may occur. The most common is because
someone opened the file with an Excel version that does not work
support co-creation. If only one person does this, then everyone
will get the error "locked" – even if everyone uses a version
Excel that supports co-authoring.

Excel versions supporting co-authoring:

Excel for Office 365 *

Excel for Office 365 for Mac *

Excel for the web

Excel for Android

Excel for iOS

Excel Mobile

  • Co-authoring in this version requires the latest version of Excel for Office 365 installed and requires you to connect to Office with
    an Office 365 subscription account. Please note that if you have a
    work or school account, you may not have a version of Office
    still supports co-creation. It may be because your administrator
    did not provide the latest version to install.

Windows App – Microsoft Office 2010 Professional Plus SP2 14.0.7236.5000 August 2019 | NulledTeam UnderGround

Windows (x86 / x64) | Languages: English | File size: 2.15 GB / 1.55 GB

Microsoft Office 2010 gives you powerful new tools to express your ideas, solve problems, and make contacts. Office 2010 lets you work where, when and where you want, by allowing you to get information from a computer, from the web, and even from a smartphone. Office 2010 is more "role-based" than previous versions. There are features tailored to employees in "roles such as R & D professionals, sales people and human resources". In its Internet implementation, Office 2010 integrates the features of SharePoint Server and inspires "Web 2.0" ideas. Use Office 2010 virtually anywhere: PC, phone, browser
A flawless stay

With Microsoft Office 2010, you can review and make minor changes to Word, Excel, PowerPoint, and OneNote 2010 documents, virtually anywhere, using Office Web Apps from additional locations on more devices. . Keep your productive employees on the move. Office 2010 allows you to access and edit documents stored on a server when you are offline with SharePoint Workspace 2010, and then synchronize them automatically when you are back online. So you stay productive when you travel.

Microsoft Office 2010 includes updated support for ISO / IEC 29500: 2008, the standard international version of the Office Open XML file format (OOXML). Office 2010 supports reading for ECMA-376, reading / writing for ISO / IEC 29500 Transitional, and reading for ISO / IEC 29500 Strict. In its preliminary version (beta version), however, Office 2010 only supported the transient variant, not the strict version. The objective of ISO / IEC is to allow the removal of the transition variant of the ISO / IEC standard version of the OOXML standard.

• Microsoft Office Access 2010
• Microsoft Office Excel 2010
• Microsoft InfoPath Designer 2010
• Microsoft Office OneNote 2010
• Microsoft Office Outlook 2010
• Microsoft Office PowerPoint 2010
• Microsoft Office Publisher 2010
• Microsoft Office Word 2010
• Microsoft SharePoint Workspace 2010

What's up:
Update for Office 2010: August 13, 2019 (KB4475506)
Update for Office 2010: August 13, 2019 (KB4475531)
Update for Outlook 2010: August 13, 2019 (KB4475573)
Update for Word 2010: August 13, 2019 (KB4475533)




Domain Name System – Switching from MX Record to Office 365

We have recently migrated all of our Zimbra mailboxes to Office 365 and are currently running a split domain. I want to reconfigure my MX records for them to point to Office 365 while minimizing the risks of sending messages to to be lost.

Here is my current configuration: has two configured MX records that point to and, respectively. These two subdomains point to the same IP address, which is the address of our on-premise Zimbra server.

My plan is to point an MX record on and give it a higher priority than the second record, which will remain set to point to until the first registration change spreads. We will make this change around midnight on a Saturday. If I understand correctly, the mail should flow directly to our presence in Office 365 and completely bypass the Zimbra server. The second MX record would capture anything that could fall between the cracks (like DNS servers that ignore my lifetime values). In theory, this should keep the mail flowing continuously. Is this the right approach?

Windows App – Microsoft Office 2016 v16.0.4849.1000 (x86 / x64) Pro Plus August 2019 | NulledTeam UnderGround

Operating system: x64 / x86 | Language: English | File size: 2.13 GB / 1.83 GB

Microsoft Office 2016 is the complete, multi-platform, multi-device solution for the modern workplace, with intelligent tools for individuals, teams and businesses. It can open your applications, documents, anywhere, on multiple devices. Get installed applications you know and trust – Word, Excel, PowerPoint, OneNote, Outlook, Publisher, Access. Always have the latest installed full versions of Word, Excel, PowerPoint, OneNote, Outlook, Publisher and Access, and capture your ideas as you see fit, using a keyboard, a stylus or a touch screen. Microsoft Office 2016 will offer new security, compliance, and deployment features, giving businesses more control over sensitive data and IT more flexibility in deployment and management. Here is a new version of Microsoft Office 2016 – update of one of the most important products of the company, which, despite the status of Preview, is already quite stable. Microsoft Office 2016 shows how the approach adopted today to create documents and use them is changed.
A flawless stay

Microsoft has extended the Office footprint to iPad and Android tablets. Improved Office experiences on Mac, iPhone and Web. We have also added new applications to the Office family with Sway and Office Lens. All designed to keep your work moving, everywhere. While you've seen us focus on setting Office for different platforms over the past year, make no mistake, Office on Windows is at the heart of our strategy.

The Microsoft Office 2016 suite includes applications such as Word, Excel, PowerPoint, and Outlook. Office 2007, Office 2010, Office 365, or Office 2013 users can open created documents without further action. Customers using earlier versions of the Office may need to download and install a compatibility pack.

New in Microsoft Office 2016:
Your documents, wherever you are – Among the Office 2016 applications, it's easier to use the power of feature-rich applications to create, open, edit, and save files in the cloud from your desktop, so that you can access it from anywhere and on any device. In addition, new, modern attachments in Outlook make it easy to join files from OneDrive and automatically configure permissions for recipients without leaving Outlook. All of this facilitates sharing and collaboration on your work with others.

Collaboration – Real-time co-authoring is available in Office Online applications and we bring this experience to Windows Desktop applications, starting with Word. When you and your team are working in Word 2016 and / or Office online, you can see where the other editors are and what they write, all in real time.

Smart Applications – Applications will learn as you work, taking advantage of subtle clues and clues to help you stay on task and get the most out of the Office. Tell Me, a new search tool available in Word, PowerPoint, and Excel, provides the commands you need by simply typing what you want to do. Clutter – a new Exchange feature that glows in Outlook – uses machine learning to scan your mail templates and unclutter your inbox by moving lower priority messages out of your way into a new Clutter folder. And Insights, powered by Bing, finds contextual information on the web as part of the reading experience.

Simplified and Accelerated Data Analysis – New analytics features are built into Excel. You can extract, map, analyze and visualize your data faster and easier than ever before.

• Forecasts in one click. Create one-click forecasts of your datasets for future trends.
• Intuitive connectivity and data formatting capabilities. With built-in Power Query, use Excel as a personal workspace for analysis by connecting to all the data around you and viewing it. Take advantage of a wide range of data sources, including web-based tables, business data such as SAP Business Objects, unstructured sources such as Hadoop, and services such as Salesforce. After you've collected all your data in one place, edit it quickly and combine it to meet the specific needs of your business and quickly access the analysis.
• Easy data modeling and powerful analysis. With the enhanced Power Pivot features built into Excel, you can map different data sets by dragging and dropping to create data models to give you a bigger picture of your business. Take advantage of intuitive analysis features, automatic time grouping, and other features that enhance your PivotTable and PivotChart experience. Now, with the ability to calculate hundreds of millions of rows of data, perform a deeper analysis at high speed.
• Publish to Microsoft Power BI Preview. Easily publish and share your Excel workbooks with Power BI users.
• New, modern charts and graphs, such as TreeMap, Sunburst, Waterfall, Box and Whisker, and Histogram and Pareto in Excel, help you present your data in new ways.

Microsoft Office Professional Plus 2016
Microsoft Access 2016
Microsoft Excel 2016
Microsoft InfoPath 2016
Microsoft OneDrive for Business in 2016
Microsoft OneNote 2016
Microsoft Outlook 2016
Microsoft PowerPoint 2016
Microsoft Publisher 2016
Skype for business in 2016
Microsoft Word 2016

What's up:
Update for Excel 2016 (KB4475550)
Update for Office 2016 (KB3114528)
Update for Office 2016 (KB3141456)
Update for Office 2016 (KB4032254)
Update for Office 2016 (KB4464535)
Update for Office 2016 (KB4464588)
Update for Office 2016 (KB4475516)
Update for Office 2016 (KB4475542)
Update for Office 2016 (KB4475551)
Update for Office 2016: August 13, 2019 (KB4475538)
Update for Outlook 2016: August 13, 2019 (KB4475553)
Update for OneNote 2016 (KB4092450)
Update for PowerPoint 2016 (KB4464577)
Update for the 2016 project (KB4475544)
Update for Skype for Business 2016 (KB4475548)
Update for Word 2016: August 13, 2019 (KB4475540)





Adding the query limit to the search in the SharePoint / Office 365 API list

I have a URL that I use to query a list in Sharepoint in the format below.


Since my list contains more than 100 items, I would like to add a $ top = 1000 to get all the items. However, I do not understand how to add this to my query … is it possible or should I rework something?