Awards
Join OfficeTipsAndMethods

Have some suggestions to share with the world?

Join OfficeTipsAndMethods and share your insight in a Comment. You must be a member to comment and all comments are moderated before being published. Membership is free and we would never share your personal information with anyone.

Become an OTM Member

Log In

YouTube Video Channel
OfficeFix
Article Categories

Posts Tagged ‘Azure’

Five Essential Excel Keyboard Shortcuts

Some keyboard shortcuts are designed to enhance your productivity in specific applications. Here are five that have long been my favourites in Excel.

 

<ctrl>;

Insert the current date. The inserted date will remain the same; it does not update when Excel recalculates formulas.

<shift><ctrl>:

Insert the current time. The inserted time will remain the same; it does not update when Excel recalculates formulas.

<ctrl>HOME

Move the selection to the beginning of the worksheet. Cell A1 becomes the active cell. Note: if freeze panes is in effect, the shortcut behaves a little differently, making the top left cell of the lower right quadrant active. If Row 1 contains the header of a structured table, <ctrl>HOME will select cell A2 rather than A1.

<ctrl>END

Selects the cell at the lower right corner of the portion of the worksheet that has actual contents.

F4

When entering formulas, make a cell reference absolute. Each time you press F4 when you are entering a formula the absolute reference changes from Absolute Cell or Range to Absolute Row/Relative Column to Absolute Column/Relative Row to Relative Cell or Range

Links for the technically inclined:

Announcing the Microsoft Cloud Roadshow

https://microsoftcloudroadshow.com/cities/?Wt.mc_id=dx_MVP400580

This is a free, two day technical training event for IT Professionals and Developers that provides best practices and insight from those who run cloud services across Office 365, Micros oft Azure, and Windows 10.

Developer Interview Series #1 –

The Power of Cross Platform Development with Universal Apps and Xamarin

https://channel9.msdn.com/Blogs/Case-Studies/The-Power-of-Cross-Platform-Development-with-Universal-Apps-and-Xamarin?WT.mc_id=dx_MVP400580

In this interview series, we bring you best practices, anecdotes, and insights from developers who are building creative solutions using Microsoft technologies.

We’re on the road to self-driving business applications

http://blogs.msdn.com/b/stevengu/archive/2015/09/09/we-re-on-the-road-to-self-driving-business-applications.aspx?WT.mc_id=dx_MVP400580

A blog by Steve “Guggs” Guggenheimer on self-driving ERP (Enterprise Resource Planning software)

Memory Compression in Windows 10 RTM

https://channel9.msdn.com/Blogs/Seth-Juarez/Memory-Compression-in-Windows-10-RTM?WT.mc_id=dx_MVP400580

The OS is doing some clever optimizations that allow your processes to trim some of the memory but not necessarily page it out to disk.

Managing hidden apps, beta apps and visibility of in-app purchases in Dev Center

http://blogs.windows.com/buildingapps/2015/09/10/managing-hidden-apps-beta-apps-and-visibility-of-in-app-purchases-in-dev-center/?WT.mc_id=dx_MVP400580

The unified Dev Center introduced several new options to manage the visibility of apps and in-app purchase.

Five Essential Keyboard Shortcuts

ShortcutTrying to learn keyboard shortcuts can be intimidating; there are just so many. Like most problems, however, you can overcome the problem by breaking it down to bite-sized chunks. So if you haven’t been using keyboard shortcuts, start by learning and using just these five. Chances once you have used them only a few times, they will become second nature. Remember that some keyboard shortcuts require a combination of keys. That means you press and hold the first (second, and third, in some cases) and tap the last. As you will see, frequently the key to use makes logical sense but sometimes it doesn’t.

<ctrl>A Select the entire document
<ctrl>X Cut the selected content or object(s)
<ctrl>C Copy the selected content or object(s)
<ctrl>V Paste what you have cut or copied
<ctrl>Z Undo the last action you did

These particular keyboard shortcuts (and many more, actually) have a consistent Beachmeaning throughout the Windows world. Whether you are working with a Word Document, an Excel Workbook, a PowerPoint Presentation, any other Office document, or Windows (File) Explorer, you use the same keyboard shortcuts.

Why bother learning these or other keyboard shortcuts? It’s all about time. To be sure, the time you save by using a keyboard shortcut once is insignificantly brief. But these shortcuts do things that you do frequently and repeatedly whenever you are working on your computer. Think of those tiny slivers of time as grains of sand on a beach. Save enough of them any you will have time for a beach vacation.

Links for the technically inclined:

Announcing the Biggest VM Sizes Available in the Cloud: New Azure GS-VM Series

http://weblogs.asp.net/scottgu/announcing-the-biggest-vm-sizes-available-in-the-cloud-new-azure-gs-vm-series?WT.mc_id=dx_MVP4000580

Important announcement in Azure space

 

Announcing VP9 support coming to Microsoft Edge

http://blogs.windows.com/msedgedev/2015/09/08/announcing-vp9-support-coming-to-microsoft-edge/?WT.mc_id=dx_MVP4000580

New feature for Microsoft Edge

 
 

Unity 5.2 and Visual Studio Tools for Unity 2.1

http://blogs.msdn.com/b/visualstudio/archive/2015/09/08/unity-5-2-and-visual-studio-tools-for-unity-2-1.aspx?WT.mc_id=dx_MVP4000580

Visual Studio is the new default Unity scripting editor on Windows

 

Announcing the Microsoft Azure Tour

http://azure.microsoft.com/en-us/blog/announcing-the-microsoft-azure-tour/?WT.mc_id=dx_MVP4000580

The Microsoft Azure Tour is a free one day technical training event for developers and IT professionals to help you achieve more success with Azure.

 

Visual Studio Code and Visual Studio Online

http://blogs.msdn.com/b/cdndevs/archive/2015/09/02/visual-studio-code-and-visual-studio-online.aspx?WT.mc_id=dx_MVP4000580

Blog on the integration with Git

 

Recently on Channel 9

At the 2015 Microsoft MVP Virtual Conference (May 14-15) Crystal Long, Brent Spaulding, and Julian Kirkness presented an information packed session on Access, Access Web Apps, and connecting Access desktop applications to Azure servers.

Channel 9 is a Microsoft community site for Microsoft customers created in 2004. It has video channels, discussions, podcasts, screencasts and interviews with Microsoft. Wikipedia

If you are interested in expanding your knowledge and understanding of the power of Access, the video of this session is a must watch. In it you will see an introduction to data management using Access, a demonstration of a working Access Web app, and a tutorial on connection an Access Desktop frontend to a cloud-based Azure backend.