excel shortcuts tagged posts

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
Navigating through Workbook Tabs in MS Excel

November 13, 2012 Excel  No comments

Working with multiple sheets in a workbook can be useful if you’re working with similar data. However, moving through the workbook may seem difficult or even annoying. In this brief tutorial, learn a few ways to quickly & easily move from worksheet to worksheet in Excel. If you have any questions, feel free to email us at questions@pbttinfo.com.

* * * * *


1...

Read More
Conditional Formatting in Excel: Make Your Life Easier!

September 24, 2012 Excel  No comments

Conditional formatting is a great way to make your life easier with Excel. All you’re basically tell it to do is, “If this is the case, then do this.” Let’s see how one form of conditional formatting works. If you have any questions, as always, feel free to email us at questions@pbttinfo.com.

* * * * *

Read More
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
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