How do you protect cells on a spreadsheet so that people can only select certain cells? How do you protect cells within a spreadsheet so other people can’t delete your formulas? Gain control of your spreadsheets! The best way is to protect your cells by unlocking them. Check out how to first unlock cells and then protect the sheet with a password. Then, users only have the ability so select the cells that you decide.

Take this Employee Mileage Reimbursement Form, for example. We only want staff members to be able to enter their name, month, commute miles, and other specifics about the expense submission. We don’t want them to be able to select cells that include formulas…only constant values that pertain to them. Once protected, the best practice is to save this document as a template. 

Occasionally, dates or names won’t merge correctly into a spreadsheet. There are extra spaces, for example, and you may want to get rid of them. How do you clean up your spreadsheets quickly? Use the TRIM and SUBSTITUTE functions. Trim blank spaces and substitute text or blanks with something different and clean up hidden characters!

How can you use the fill handle to quickly work with your data? There are lots of cool things that you can do to maximize your use of the fill handle to copy a series and save you time. How can you repeat and or copy data down? Well, by using the fill handle!

Working with a touch-screen device can present a challenge when working with the Ribbon in Microsoft Office Applications. You may wonder how to enable Touch Mode in Excel, for example. Can you make the buttons bigger? Absolutely. You can create more open space on the Ribbon so commands are easier to tap.

Can you customize the branding of the Office 365 Web based sign in experience? Yes you can with Microsoft’s release of Azure Active Directory (AD)!

Can you add Apps to the App Launcher in Office 365? With the continuous adding of new innovations and features by Microsoft, it is very easy to add single sign on apps to improve the user experience. For example, if you want to add a specific HR app to help users access tools without having to go to the external website, you can! Can you add a Twitter app to Office 365 for single sign on to your organization's Twitter account? Yes, you can! There are hundreds of apps to choose from.

With the rollout of Office 365 Government, there are some interesting decisions to make when upgrading potentially old and expensive servers. There is an increasing need to find a long-term solution to meet governmental needs for compliance, modern mobility, collaboration, archiving and, of course, security. Office 365 meets all federal information security and privacy requirements. So why migrate to Office 365 Government? It is an opportunity to modernize, boost productivity, be more efficient and reduce cost.

FLASH FILL: Excel 2013 has an awesome feature called Flash Fill. How does Flash Fill work? It gives you the ability to take a part of the data entered in a column of a worksheet table, type part of it into the next column over, and fill a series.

Excel detects patterns in your initial data entry! The application then figures out the data you want to copy and even offers a few choices to match exactly what you want. Fill a series without a formula! Instead of manually entering your data or copying and pasting, let Excel do the work. Here’s how...

When do I get Skype for Business? If you’re currently use Lync Online in Office 365, you’ll get Skype for Business sometime by the end of May 2015! It is automatically replacing Microsoft Lync as a robust and unified collaboration and communication platform. What is Skype for Business?

Some Excel workbooks contain many worksheets and it can be difficult to easily access them. Is there a way to make more tabs visible? You could certainly use the slider bar to navigate but that takes more time and can be tedious. Here is the easiest way to display multiple tabs in Excel for quick navigation.

In this introductory sharing and collaboration webinar, you’ll receive a tour of the user interface and the many Office 365 offerings. Our goal is to help you better understand how using Office 365 and SharePoint Online will streamline your workflow.

How do you create a Microsoft account using any email address? Is it required to have a Microsoft email address to sign in to Windows or use apps? No it isn’t!

You can use one email address to sign in everywhere!

Why do you get errors such as #N/A, #VALUE!, #REF!, #DIV/0!, #NUM! and #NAME when you know the formula is correct? What is IFERROR? The IFERROR function is an easy way to fix or change the way an error message is displayed in a cell.

Working with a touch-screen device can present a challenge when working with the Ribbon in Microsoft Office Applications. You may wonder how to enable Touch Mode in Word, for example. Can you make the buttons bigger? Absolutely. You can create more open space on the Ribbon so commands are easier to tap.

How do you enter the same text repeatedly in a Word document? You can easily insert blocks of preformatted text using what is called AutoText, or what is sometimes referred to as Quick Parts. Check out the quick and easy way to create AutoText entries by adding selected text to the AutoText gallery. This is an awesome feature that allows you to drop in common text and saves you time by not having to type it in every time!