Melissa Esquibel, Microsoft Certified Trainer and Microsoft Office Master, has been connecting people with technology for over 30 years. She empowers businesses and individuals to master their e-tools and embrace their ability to streamline and simplify, rather than confuse and confound. Melissa is a Chicago native. She graduated summa cum laude from Strayer University with a Bachelors in Business Administration, majoring in Legal Studies. Her previous experience as a Certified Business Continuity Professional (CPCP) and passion for end-user productivity and business process optimization gives her a unique perspective and allows her to deliver instruction using real-world examples and case studies.
For those with nice clean simple datasets to work with, this might seem like a silly thing to want to do. For those of us who deal with some monster-sized data exports,...
If you find yourself looking for the most recent/best presentation from which to make a new one, or pondering the question, “Now, how did I do that last time?”...
If you know what a secondary axis chart is, then you know what a challenge it can be to show disparate values on the same chart. This used to be somewhat cumbersome in...
Are you planning a big meeting with lots of moving pieces: Catering, handout materials, AV. Wouldn’t it be great to not have to recreate the meeting attendance data...
I recently heard a train-the-trainer presenter refer to all animations and transitions as unnecessary fluff and distractions. While I agree that animation beyond basic...
Microsoft hit it out of the park with Quick Steps in Outlook 2010. On the Home tab, in the Quick Steps group, you’ll find several out-of-the-box Quick...
Are you using SharePoint 2007 or 2010 as a glorified file server? There are many opportunities to make SharePoint do some heavy lifting beyond just keeping your files...
I want to right align part of a line. For example, in a resume the company name might be flush with the left margin, but the dates of employment should be flush with the...
My Ribbon is gone!
This is a common exclamation by new Office 2007 and 2010 users. We come from a long line of “double clickers” even though precious little needs a...
I had an interesting question this week from someone in my network. Their IT decision makers have chosen to host their email and calendars in Gmail. My contact and her...
If you’ve never created a Macro before, this one will be an easy starting place. A macro can be a simple recording of keystrokes that can be played back over and over...
Do you ever get merged cells errors? While merged cells can give your table and worksheet titles a nice appearance, they can cause problems with calculations if they...
Stop counting on your fingers and toes to do date math! Use these Excel tips to calculate past due dates, follow-up dates and other tedious time calculations.
Ctrl + ` (Hint: Look for the tilde “~” symbol)
This keyboard shortcut reveals all the formulas on a worksheet. Changing cells before you know what they do is...
I had a great question last week on our Outlook® webinar. Could Outlook® be used to replace a CRM function when it came to generating tasks with predefined...
Tricks with tables to save you some cutting and pasting when your data doesn't come in the way you expect it. Data to tables, tables to text and sorting data NOT in a...
