Category Excel

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
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
Excel Charts: A Quick Guide to What You Can Do and Getting Started

November 6, 2013 Excel  No comments

One of the many useful features when using Excel is the ability to create Charts. Charts are a visual representation of data. By making your data presentable and easy to read, you can find important trends, make quick comparisons and present your date in a visually appealing way to executives. Here is a quick guide to different types of Excel charts you can create and how to get started.

Chart Types:

  • Column and Bar Chart: Used to compare multiple values
  • Line Chart: Used to look at continuous data
  • Area Chart: Used to observe differences between several sets of data over time
  • Pie Chart: Used to look at the relationship of pieces to the whole
  • Doughnut Chart: Used like a pie chart, but can display more than one series of data
  • Scatter Chart: Shows the relationship between two sets of data

Tr...

Read More
A Quick Guide to the Excel Macro Button

October 24, 2013 Excel  No comments

Why should you use Macros?

Using macros is a great way to save time by automating tasks that you do often. This eliminates the repetition of doing the same action over and over. It also helps standardize procedures by doing them the same way each time.

Excel Macro Button & the Developer Tab

“Developer” Tab:

The Macros button is located on the “View” tab, but you can also add the “Developer” tab to give you even more options. To add the “Developer” tab, go to the Microsoft Office Button (in the top left-hand corner), select “Options.” Then select “Customize Ribbon” and click on the Developer check box (Office 2010) or check the box “Show Developer Tab” (Office 2007). In the “Code” section of the “Developer” tab, you will find all things Macro.

The “Macro...

Read More
Excel Dashboards Simple Tips for Easy Creation

October 4, 2013 Excel  No comments

Dashboards are a visual interpretation of data that act as an interactive reporting tool and give you a comprehensive snapshot of your data. They are created with a specific goal or purpose in mind, so it saves the user time and energy, because they don’t have to perform their own analysis of the data. Consequently, the data is more focused and relevant, so dashboards are able to communicate information more accurately and faster. This post will give you the Excel Dashboards simple tips to get started today.

Read More
Excel Formatting Top Tips: Easy Ways to Save Time!

September 18, 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 great tips and tricks to make use of all the formatting features Excel has to offer.

 

Free...

Read More