Learning Excel

learning Excel

Excel Tip Of The Day: Removing Duplicate Data From Your Spreadsheet

dedupe excel 2010 spreadsheet

How To Deduping Your Excel 2010 Spreadsheet As you compile data in your Excel 2010 spreadsheet, you may encounter duplicate data. Removing the data can be done by using the tools available in your Excel ribbon. This process is quick and efficient. Dedupe Duplicates Using in Your Excel 2010 Spreadsheet 1. Open the spreadsheet...
Read More »

Macro Quick Start Guide

Macro Quick Start Guide

Learn Macro Guide Use this macro quick reference card as a guide when you are learning how to create, execute, and design macros in Office 2000 – 2003.  My students used this often when I taught this course years ago.
Read More »

Excel Training – Video Series

Excel Training – Video Series

Excel Training – Video Series Learn excel 2007 by using video training! If you are a visual learner, this set of videos will be a perfect fit for you as you increase your skill level. Let’s face it….everyone doesn’t learn by readying books or quick tutorials. Sometimes you just want to view a process...
Read More »

Excel Level 1, 2 and 3 Training

Excel Level 1, 2 and 3 Training

Excel Level 1, 2 and 3 Training Ready to get additional structured Excel training. Use the Ozgrid Excel training package to learn excel using real world examples! Each course has lessons, word documents, and workbook examples.  This training is broken down into basic, intermediate, and advanced levels.
Read More »

Do you have an excel template you want to share?

Do you have an excel template you want to share? Do you have an excel template you want to share with our online template community?  If so, send it to admin@myexceltemplates.com and we will post it ASAP.  Be sure to include contact information and clear instructions on how to use it! Have a great...
Read More »

Offering Onsite Microsoft Excel training to your staff members

Offering Onsite Microsoft Excel training to your staff members

Microsoft Excel Training Classes At Your Company Get your staff up to date by offering on-site Microsoft Excel courses.  It has been reported that the majority of Excel users have never had formalized Excel training.  They tend to learn from experiences, co-workers, or work projects.  This can cause productivity issues in your office when...
Read More »

Are there any free alternatives to Microsoft Excel?

Alternatives to using Microsoft Excel This site has made the assumption so far that you have Microsoft Excel.  There is a percentage of the population who don’t use Microsoft Office.  For them, they have to use other solutions to meet their spreadsheet needs.  The excel alternatives below are free and have nearly the same...
Read More »

Time Saving Feature: AutoCorrect in Excel

Time Saving Feature:  AutoCorrect in Excel

Using AutoCorrect to save you time in Excel AutoCorrect is used to have Excel (or any other Office product) automatically correct the spelling of a word, abbreviation, phrase, etc. AutoCorrect can be accessed by selecting the Office button, Excel Options, and Proofing. AutoCorrect can be found by selecting the Office button and select Excel...
Read More »

Keeping Your Spreadsheet Simple And Easy-to-read

Keeping Your Spreadsheet Simple And Easy-to-read When confronted with a mountain of data that you need to sift through and organize, nothing can make your job faster and easier to understand than an effective spreadsheet. When it comes time to share this information with others, you will be able to quickly and succinctly offer...
Read More »

How to Export Email Distribution List From Outlook into Excel?

How to Export Contents of Your Microsoft Outlook Distribution List Into Microsoft Excel To copy the email addresses from your Microsoft Outlook distribution lists and paste them into Microsoft Excel, complete the following steps: Open Outlook and select contacts. You will need to locate your distribution list within your contacts. If you don’t see...
Read More »

Excel 2007: Lesson 1.1 The New Interface of Excel 2007

Excel 2007: Lesson 1.1 The New Interface of Excel 2007 This video is an excellent tutorial of the  new Excel 2007 interface.  It demonstrates the ribbon, quick access toolbar, and the office button. Click here to find FREE excel templates on your computer.
Read More »

How to Create a Workbook Based off an Excel Template Video

Create a workbook based on a template in Excel 2007 This short video illustrates how to use templates that are already loaded on your computer in Excel.  Once you have downloaded excel templates or created your own excel templates, you will need to know how to access them.
Read More »