Excel Conditional Formatting: Quick Guide for Easy Use

February 26, 2014 Excel  No comments

Using Excel in the workplace, or for personal needs, is made much simpler when you know who to use all of the tools and features effectively. This week, Desktop Training Academy brings you our tips for using Excel conditional formatting. The conditional formatting tool in Excel allows you to apply many different formatting options (such as background colors, borders, and font formatting) to data that meets certain conditions. This makes sorting and recognizing date easier

 In order to set a formatting condition, first select the cells that you want to format. Then on the “Home” tab, click “Conditional Formatting” in the “Style” section. See the image below for a reference point.

 

For the next step in the process, choose “New Rule...

Read More
Excel Visual Tools to Help You Save Time

February 19, 2014 Excel  No comments

Excel has many visual tools built in to help you effectively display your data. With features like themes, tables, and SmartArt, you can easily make your data viewer-friendly. Check out these tips to help you effectively use Excel Visual Tools.

Themes:

Themes help you make quick adjustments to the entire workbook for consistent colors and fonts. To choose a theme, click on the “Themes” button on the “Page Layout” tab. The themes you can choose from involve different color schemes and formatting that affect your font, cell background colors, and other colors throughout charts and diagrams. Identical themes exist in Work and PowerPoint, so it’s simple to standardize the appearance of different file types for the same project.

Form Controls:

These help you create interactive worksh...

Read More
Excel Macro Security: A 2007-2010 Comparison

February 5, 2014 Excel  No comments

Excel’s Trust Center, which causes security prompts, was introduced in Excel 2007, so when you are working with a workbook in Excel 2007 or Excel 2010, it runs automatically and handles macros in different ways depending on the settings you select. This post will go through the similarities and differences in excel macro security in Excel 2007 and Excel 2010.

Developer Tab

The first step you will need to perform in both 2007 and 2010 is to show the “Developer” tab. To do this, go to the Microsoft Office button in the top left corner and click on “Excel Options.” From there, in 2007, you will need to check the box that says “Show Developer Tab in the Ribbon...

Read More
Easily Combine Excel Charts in Minutes

January 29, 2014 Excel  No comments

Desktop Training Academy brings you our tip of the week: Easily Combine Excel Charts in minutes. In this quick guide, we aim to provide you with methods for quickly and easily combining Excel charts. This feature is useful for comparing and contrasting your data when using Excel in the workplace.                                 

What is a Combination Chart?

A combination chart consists of at least two data series that use different chart types. The purpose of using a combination chart is to view numbers with extreme differences in value. A secondary value axis represents the second set of numbers making it easier to see the differences. (**Bubble charts and 3-D charts can’t be used for combination charts.)

Create a Combination Chart:

First select all the...

Read More
PivotTable Step-by-step Guide: Quick & Efficient Data Organization

January 17, 2014 Excel  No comments

PivotTables are used to summarize data in a visual way, so people know what is going on with their numbers. It’s a good way to organize large lists of data, so you can understand the data better and produces reports about it. They save you time and energy and ensure accuracy with automatic calculations. Follow these steps as it takes you from beginning to end of the PivotTable process.

Set Up/Build a PivotTable

First you will need to organize your data: you can’t have any blank rows or columns, the columns and rows need to be labeled with unique names, and automatic subtotals and filters need to be removed. Once your data is organized, you can create your PivotTable...

Read More
Best Gmail Tools to Keep Your Inbox Organized

December 18, 2013 Google Docs  No comments

Gmail has many built-in features help you keep your inbox organized and save you time and energy. We here at Desktop Training Academy (DTA) wanted to bring you tips to use the best Gmail tools to keep your inbox organized.

Labels:

Labels can be used to sort e-mails by subject, sender, project, etc. You are able to apply up to 4 labels to each e-mail. To create a label, click on the gear icon on the top right corner of g-mail and select “Settings.” Along the top of the settings window, click on “Labels.” Scroll down to “Labels” and click “Create new label.” Enter the name you want to give your label, and then press “Create...

Read More
Quick Excel Formatting Tips: Best Practices for Easy Use

December 11, 2013 Excel  No comments

With Excel, you can use formatting tools to make your worksheets look better and keep your data organized. Check out these quick Excel formatting tips and tricks to make use of all the formatting features Excel has to offer.

Freezing Column Headings

When you’re working with a long excel document, you want to see what your column headings are so that you don’t have to keep scrolling up or make a mistake. To make this easy, freeze the column headings, this will always keep your first row with the headings at the top of the columns regardless of how far down you scroll. To set this, click on “View” on the tool bar, and then select “Freeze Panes.” Click on the “Freeze Top Row” option.

Quick Tips For Adjusting Columns and Rows

  • To quickly insert a column or row, select the row...
Read More
Getting to Know Our Speakers: An Interview with MS Office Expert Mitzi Gibson Katz

December 5, 2013 Excel  No comments

Desktop Training Academy is proud to present our next interview in our series “Getting to Know Speakers.” Today, we had the special privilege of sitting down with MS Office expert and trainer, Mitzi Gibson Katz. Mitzi has trained thousands of end users and developed curriculum for over twenty-five years. As a consultant, she specializes in the Microsoft Office suite including Excel, Access, PowerPoint, Word, Outlook and much more. After teaching a variety of special education classes in Kansas, Montana, and Alaska for the early part of her career, Mitzi became interested in technology as the first personal computers were introduced to the market...

Read More