Excel VLookup Tips: Learn One of the Most Useful Excel Functions

July 31, 2013 Excel  2 comments

One of the most useful functions in Excel is VLookup.

What is VLookup?

The VLookup function allows you to find data that is stored in a table from another spreadsheet or a smaller table.

Read More
Excel Math Formulas: Quick & Easy Guide to Start Now!

July 24, 2013 Excel  No comments

One of the most common uses for Excel is computing large amounts of complex data.

Knowing the best Excel Math Formulas to use allows you to crunch those numbers quickly to get the results you need. The formulas you can use vary from simple computation to condition-based criteria. Excel even provides you with specific error messages when data is entered incorrectly. Let’s get started with some of the most used simple formulas.

Excel...

Read More
How to Create Macro in Excel: Get Started in No Time!

April 5, 2013 Excel  No comments

Macros in Excel can save you a lot of time, especially if you have repetitive tasks. With this post we will learn how to create macro in Microsoft Excel.

In Microsoft Excel 2007/2010, you can automate frequently used tasks by creating and running macros. A macro is a series of commands and instructions that you group together as a single command to accomplish a task automatically.

Read More
Save Time in Excel: Keys Shortcuts to Speed Up Your Workflow

March 22, 2013 Excel  No comments

Who would not want to save time in Excel?

Here at Desktop Training Academy we are committed to help you using Excel in a professional setting, saving time, getting more effective and reducing the frustration that comes with it.

We talk and work with MS Certified Professionals on a daily basis, and we were able to come up with some key tips, tricks and shortcuts that will make your life in Excel much easier!

Save...

Read More
Manually Find Formula Cells in MS Excel

December 10, 2012 Excel  No comments

Read More
Create an Instant Chart in Excel: Easy Power Shortcuts

December 4, 2012 Excel  No comments

Crating an instant chart in Excel is easy and convenient!

You’re in the middle of a meeting and you want to show all of the data you’ve collected as a chart. Don’t bore your coworkers by taking the time to click around creating one! In this brief tutorial, learn a quick keyboard shortcut to create a chart instantly!

Read More
How to Reply with Meeting in Outlook 2010

November 27, 2012 Outlook  No comments

Outlook 2010 Tutorial – Learn Reply with Meeting Function

Within an email, you have the option to “Reply with Meeting” in order to schedule a follow-up get-together that pertains to the email. Let’s see how it works! If you have any questions, as always, feel free to email us at questions@pbttinfo.com.
* * * * *

1...

Read More
Sorting in Pivot Tables

November 20, 2012 Excel  No comments

When your Excel 2010 worksheet becomes quite massive, using the Sort dialog box to sort on multiple columns can make it easier to find the data you need. The Sort dialog box can tell Excel what column to sort on next if two cells in the main sort column hold the same value or data.  If you have any questions, as always, feel free to email us at questions@pbttinfo.com.

Read More