You know the frustration of incorporating a new logo into presentation decks with dozens of slides. Chances are you can cut your work exponentially by taking advantage of the master in Google Slides.
The Office Tech Pro
A Microsoft® Certified Trainer, Melissa Esquibel combines her 25+ years experience in information technology with a background in training, technical writing and business risk analysis. Her goal: To take you from “No, how?” to “Know how!”
If you’ve recently made the transition from Microsoft Office to Google Sheets, you might think you’re missing some treasured features. You just need to know where to look and perhaps a few differences in how they work.
Wouldn’t it be great to have your own personal translator wherever you go? Well, you do! Google Translate allows you to translate words and phrases, and even upload whole documents for translation.
One of the differences many “converts” from Excel to Sheets lament is keyboard shortcuts. Here are ways to work with many of the same shortcuts you were used to in Excel, in Sheets.
Permissions can become confusing in SharePoint. A few basic principles help clear the mist a little. The more complex you allow your permissions structure to become, the less secure and, ultimately, the bigger nightmare it is to administer.
One of the exercises to do while preparing for a SharePoint rollout is to think about how it can be used to answer questions that would otherwise fill up email or voice mail. A well-built company-facing team site should be a reliable resource for frequently asked questions. With a few tweaks, the Issues List app (or list template in 2010) can serve two functions: a place to record open issues or questions, and, when answered, an FAQ.
If you’ve ever inherited a workbook that has been passed down from several individuals without a lot of Excel knowledge who had a very definite idea of what they wanted, but not how to get it in the best way possible, learning opportunities abound. Here are the biggest lessons that came out of a real whopper …
Say Yes to Archive! When the Archive prompt comes up, just say Yes! You probably don’t realize it, but when Outlook archives an email, it just goes to a separate file structure which is still accessible from the Navigation Pane. This process keeps your Inbox and regular folders clean, neat and current, while still allowing you to easily access your older ones.
Here is the problem … You are trying to filter using multiple AND and OR criteria in Microsoft Excel or one or more columns in your list have more than 10,000 unique items (think employee numbers, serial numbers, transactions).