Quick Access Toolbar: Move, Customize & Add Buttons for Macros

September 17, 2012 Excel  No comments

Setting up easier ways to complete a project in Excel can be challenging. Did you know that with a few clicks of your mouse you can provide yourself small icons in the “Quick Access Toolbar” for easy navigating?
In this tutorial, you will learn how to relocate your quick access toolbar below your ribbon and how to add icons, specifically an icon for a macro you’ve created, to your quick access toolbar.

Read More
Excel Formatting: Learn How to Easily Format Cells on Your Spreadsheet

September 11, 2012 Excel  No comments

How did my supervisor get all of those decimal places to show up in that cell? What about the percent signs? Can I switch formats? How does it all work?

If you’re unsure of the answers to any of the questions above, this is the tutorial for you. Let’s look at different formatting styles and methods – you’ll learn some shortcuts to keep up with your colleagues and to make the data say exactly what you want. If you have any questions, as always, feel free to email us at questions@pbttinfo.com.

Read More
Make PowerPoint Your Wingman!

September 4, 2012 PowerPoint  No comments

Maybe you know exactly how to put together the perfect PowerPoint presentation, but if you’re not sure how to present it correctly, your audience may not respond as well as you’d hoped. In this brief tutorial, you will find some expert advice on the mechanics of giving the actual presentation in front of an audience. If you have any questions, as always, feel free to email us at questions@pbttinfo.com.

Read More
Excel: Keyboard Shortcuts to Bold, Italicize & Underline Font in a Cell

August 28, 2012 Excel  One comment

How are your keyboard shortcut skills? Are you only mouse-friendly? If so, you may want to consider trying these shortcuts. They’ll make your life easier in the long run, especially if you want to modify your documents quickly. If you have any questions, as always, feel free to email us at questions@pbttinfo.com.

Read More
How to Present Effectively with MS PowerPoint: Top Tips!

August 22, 2012 PowerPoint  No comments

Learn a few but key tips on how to present effectively using MS PowerPoint!

Not everyone can create and present an effective PowerPoint presentation. Let’s look at some pointers from our experts on how to make your presentation the best that it can possibly be.

If you have any questions, as always, feel free to email us at questions@pbttinfo.com.

Read More
Excel Match Function: Learn How to Easly Locate Information on Your Spreadsheet

August 17, 2012 Excel  No comments

Do you have a lot of data that you’re crunching at once? There are a few tips and tricks for locating values and the positions of values quickly and easily. Match is a built-in function that you can use for locating information in a spreadsheet. If you have any questions, as always, feel free to email us at questions@pbttinfo.com.

Read More
PowerPoint Shortcuts: Ctrl+M & Layout Selection!

August 8, 2012 PowerPoint  No comments

CTRL + M is a quick way to create a new slide without touching the mouse, but do you know how to choose certain layouts and other options once you have your new slide? Let’s check out some of the options. If you have any questions, as always, feel free to email us at questions@pbttinfo.com.

Read More
Excel Advanced Filters: Sort & Filter Your Data Like a Pro!

August 2, 2012 Excel  No comments

Do you know how to filter data? Have you ever tried the “Advanced” button nearby the funnel-like “Filter” icon? If you haven’t tried this option until now, you’re in for a nice description of how to filter data based on very specific criteria that you determine. In this tutorial, you will learn how to filter data according to certain criteria and replicate the filtered data so as not to destroy the original. If you have any questions, as always, feel free to email us at questions@pbttinfo.com.

Read More