Excel Tricks: Easy Data Summary

April 24, 2014 Excel  No comments

Excel is great for summarizing your data. You can create tables, charts, PivotTables, and more. The following tips are provided to give you the power to do easy data summary in Excel

Special Paste

The Special Paste feature can be used to copy and paste both static and linked data. To use it, first copy the data that you want to paste by highlighting it and either right clicking and selecting copy or pressing “Ctrl” + “C.” Click on the first cell where you want your data to be pasted, right-click, and select “Paste Special.” From there, a dialog box will appear and you can choose how you want the data to be pasted. You can choose to paste everything, only the formulas, only the values, only formats and more...

Read More
Excel Dashboards: Your Guide to Getting Started

April 16, 2014 Excel  No comments

Excel Dashboards: Your Guide to Getting Started

 

Excel Dashboards are a great way to display your data. They give you a comprehensive snapshot of your data and save you the time and energy, because you don’t have to perform your own analysis of the data. They are very customizable and allow you to help steer attention to key trends, comparisons, and exceptions. Essentially, dashboards are a great tool for putting all of your information in one place and making it easy to read. This walkthrough of Excel Dashboards will teach you all the basics to create and use your own dashboard.

What to Include in Your Dashboard

The most important question to keep in mind when you’re creating your dashboard is what is important? To display the most important and relevant data, you should keep a few ...

Read More
Excel Visual Basic for Applications (VBA): How to Get Started

April 9, 2014 Excel  No comments

Microsoft Excel has a built-in Visual Basic tool called Visual Basic for Applications (VBA), which allows you to customize your workbook and save time on repetitive tasks. Instead of repeating the same thing over and over, you can write a short code to replace the repetitive task. Check out these tips for using VBA to make using Excel easier.

Using VBA in Excel

First, you will need to open the Visual Basic Editor (VBE), to do this you can either go to the “Developer” tab and click on “Visual Basics” or click “Alt” + “F11.” In the VBE, click on “Insert” and select “Module” to open a blank window. Now you need to decide if your program is a “Sub” (subroutine, a task that doesn’t return a result) or a “Function” (a task that returns a result)...

Read More
Excel Database Tips

April 2, 2014 Excel  No comments

An Excel database is a great way to organize your data. It includes a series of records in rows with fields of data entered in columns. Here are some tips to make using Excel as database easier.

Organizing Your Data

To use Excel as a database, your data has to be structured in a specific way. First, each column has to contain the same category of data in every row of that column. Similarly, each row must contain all of the data for the same one thing (person, group, organization, object, etc). To indicate this thing that the row represents, the first column of each row must contain a unique name. The top row must contain a unique column heading for each column to indicate which data is stored in that column...

Read More
Excel Tables: Easily Organize and Present Your Data

March 26, 2014 Excel  No comments

There are a variety of ways to sort and organize your data in Excel. These features allow you to quickly process data to get essential analytics, statistics, trends and other information to inform decision-making. One of feature is using Excel tables. Excel Tables are great way to quickly and easily organize and display your data. The following quick guide will provide you with tips, so you can start creating and using Tables for your data.

Creating a Table

To create a table, first highlight the data that you want included, then go to the “Insert” tab on the top toolbar and select “Table.” Your table will be created, and you will automatically be in the “Design” tab. Now, you can choose how you want your table to look by choosing from the different table styles...

Read More
Creating 3-D Formulas in Excels for Multiple Worksheets

March 19, 2014 Excel  No comments

A 3-D formula in Excel can be used to calculate data using multiple worksheets in a workbook. Check out these tips to learn how to create and use 3-D formulas in Excel.

What 3-D Formulas in Excel  Look Like

The syntax for a 3-D formula is “worksheetA:worksheetB!reference”

  • WorksheetA is the first worksheet that you want to be included in the calculation.
  • WorksheetB is the last worksheet that you want included in the calculation.
  • The reference is the cell or cells that contain the values that you want to be a part of the calculation.

Functions that You Can Use with 3-D Formulas

  • SUM: This calculates the sum of all the values you select
  • AVERAGE: This calculates the average of all the values you select
  • COUNT: This counts the number of cells in the range that contain numbers
  • MAX: This r...
Read More
PowerPoint Animations: Your Guide to Getting Started

March 13, 2014 PowerPoint  No comments

PowerPoint Animations can give life to your presentation by increasing visual appeal. Just a note: use caution when incorporating animations. Animations used for a strategic purpose can be very effective. Animations for the sake of animations can detract from a quality presentation.

Once you have figured out the basics of slide creation in PowerPoint and have all of your text and pictures in place, you can begin to add animations to make your presentation more exciting and highlight different parts of it.

What is Animation?

Animation includes all of the entrances, exits, transitions, changes in size and color and movements that you can add to pictures, text, shapes, SmartArt graphics, and other objects in PowerPoint...

Read More
Sorting Data with PivotTables in Excel

March 6, 2014 Excel  No comments

The PivotTable is one of the most useful features in Excel. Sorting data with PivotTables allows you to examine your data from multiple points of view. This convenient tool allows you to summarize your data. You can sort data, count totals and find averages. In addition to giving you the ability to organize your data, PivotTables also help in making your data more presentable. This brief overview from Desktop Training Academy gives you solutions for sorting data with PivotTables in Excel.

Creating a PivotTable

Once you have highlighted the data that you want in your PivotTable report, go to the “Insert” tab and click on “PivotTable.” You can then be able to choose to create the PivotTable report on a new page or keep it on the same page as your data...

Read More