Excel
5 Unique Techniques for Excel 
If you are an Excel user, look here for some unique techniques that will help you be more effective with your spreadsheet development. AutoSum Function (Excel)
Excel´s AutoSum Function allows you to quickly add sum formulas in your worksheet. Learn several techniques on how to use it effectively. Basic Excel Charting Techniques 
Basic charts are pretty easy to do. Here I will show you some simple techniques to get yourself acclimated to creating charts. Beyond Technology  [offsite link]
Beyond Technology delivers custom solutions and support for spreadsheet applications. You will find useful tips ranging from the beginner to the guru levels of experience. Checkbook Register using Excel
Start the year off with a New Year’s resolution to keep your checking account balance in check using Excel. Combination Charts in Excel
How to look at related but widely dispursed data using a secondary axis and a combination chart. Common Keyboard Shortcuts for Excel
Find out how Keyboard Shortcuts and make your work in Excel more efficient. Computer Training 2000 [offsite link]
Nearly 60 How to snippets for Excel. Controlling Pagination - Excel
Learn how to control pagination by manipulating Excels automatic page breaks. Converting a List of Names to Multiple Columns in Excel
Ever wonder how you can separate information in a single cell in Excel into multiple columns. Learn how this can be done. Cool Secrets About Microsoft Excel [offsite link]
A listing of powerful and useful features in Excel from the support people at Microsoft. Copying Worksheet Data to MS Word
Techniques for imbedding Excel data in your Word documetn Create a List of Cell Phone Numbers
Have you ever considered what will happen if you lost your cell phone? Every one of your important contacts are stored in that little device. How can you back up that information? Document Your Work with Cell Comments
You will learn how to use cell comments to document your work in Excel. Easy Spreadsheet Solutions [offsite link]
Good source for accounting and business software applications. Highly experienced consortium of financial professionals who can help you find solutions to your business needs. Eight Ways to Add Numbers in Excel
Adding number can be so simple with Excel but it may not be as simple as you think. Learn the 8 ways to get a sum value for a set of numbers. Excel - Arranging Multiple Worksheets
Here is a technique you can use to help you view more than one worksheet at the same time. Excel Cell Comments
You will learn how to use cell comments to document your work in Excel. Excel Charting to Goal
Learn how you can graphically measure your actual results against the goal that was set using Excel´s charting feature. Excel Desktop - Formatting Toolbar
Excel Desktop - Standard Toolbar
Excel Examples [offsite link]
Over 50 examples of solutions to real problems from John F. Lacher CPA on the Excel Help Pages. Excel Pie Chart
Instructions on creating Pie Charts using Excel. Excel Pivot Tables Recipe Book Review
Written by Debra Dalgleish, Excel Pivot Tables Recipe Book will help you with solving problems using Pivot Tables. Here is a review of what the book has to offer. Excel-Types of Formula References
Understand how Excel uses cell referencing when formulas are copied within the worksheet. Family Finances Spreadsheet Software [offsite link]
Free customizable Family Finances worksheet to help you with your budgeting and money management needs. Choose between Excel or Works file format. 30 day evaluation period, requires registration after 30 days to continue using the worksheet. No fee required.
Fill Handle – Excel
Quick and easy data entry with Excel´s Fill Handle Free OzGrid Excel Newsletter Archive [offsite link]
Archive of past Ozgrid newsletters. Ozgrid is a site I respect. Ozgrid is generous with sharing their considerable knowledge and experience. I´ve learned much from them. Glossary of Spreadsheet Terms
Look here for definitions that will help you understand Excel´s termonology Go To Options (Excel)
Excel´s GO TO command is a powerful navigation tool. Guide to MS Excel User Interface
This is your guide to the Excel User Interface where you will find an explanation for each of the features found on the Excel Desktop. Use this guide to help you get around Excel. Guide to MS Excel User Interface
This is your guide to the Excel User Interface where you will find an explanation for each of the features found on the Excel Desktop. Use this guide to help you get around Excel. Headers and Footers - Excel
The Header/Footer tab on the Page SetUp dialog box provides options for establishing custom headers and footers for your printed worksheet. J. Walkenbach Spreadsheet Site [offsite link]
John Walkenbach is a recognized expert in Excel and VBA for Excel. You will find expert advice and great information you can use to build your worksheets. Great resource. List Management – Excel
Excel list management requires that your data conform to certain standards to take advantage of the powerful data tools. Margin Options - Excel
In Excel, the margins tab allows you to manipulate the size of the top, bottom, left and right margins and the size of the margins for the header and footer. Mathematical Operators and Order of Operations
Mathmatical Operators are the keyboard characters that Excel understands to perform a mathematical calculation. When developing formulas in Excel, it is important to understand how Excel interprets these operators. Microsoft Excel Tips [offsite link]
More than 40 tips on general Excel techniques, formula creation, and VBA. No Title
Office Tips  [offsite link]
Great site with down to earth instruction on important VBA techniques. Thanks Martin for sharing your knowledge! Office XP Tips: Manage Large Spreadsheets [offsite link]
Good article from PC World describing how to use Excel’s watch window to keep an eye on critical cells. Ozgrid Business Applications [offsite link]
This site contains lots of tips, tricks, code, macros, formulas and information on the use of Excel and VBA for Excel in general. We also publish a Free Excel Newsletter.
Page Options - Excel
Page options for setting up your printed Excel reports including orientation, scaling, paper size and print quality. Page SetUp Dialog Box - Excel
How to use the Page SetUp Dialog Box in Excel Password Protect Your Document On Open
Learn how you can keep others from viewing your work with a password protection option. Pivot Table Data Crunching Review
Pivot Table Data Crunching is an ideal text book for the serious Excel student. Here is a review of what is contained in the book. Print Area – Excel
Setting a print area for you Excel document. Print Preview - Excel
My advice is never to print an excel worksheet without having first looked at the print preview so that you can manipulate the layout of your document. Printing Address Labels from Excel File
MS Word´s mail merge feature must be used to print labels from an Excel file. Here´s how it´s done. Qwik and Dirty Task Guides for Excel [offsite link]
Well designed site with lots of Excel tips, tricks and techniques. Consider signing up for their free newsletter. Scatter Charts
This article will lead you through the steps needed to create a scatter chart in Excel. Sheet Options - Excel
The Sheet tab of the Page SetUp dialog box provides various options you can use to control the printing of your Excel document. This Isn't Excel, It's Magic - Review
A review of Bob Umlas´ new book loaded with tips and tricks. Types of Excel Charts
Today’s charting is simplified by Excel’s Charting tools. Data can be displayed in 10 different categories of charts with each category offering several sub-categories. Look here for a description of Excel´s chart types. Unique Technique 4 - Centering Excel Titles
Centering a title above a block of cells is a common application in Excel. There are two techniques for accomplishing this formatting technique. Learn the two techniques, how they differ and reasons why you would chose one vs. the other. Using Excel’s Auto Sum [offsite link]
Excel´s AutoSum Function allows you to quickly add sum formulas in your worksheet. Learn several techniques on how to use it effectively. Using Named Ranges (Excel)
This article describes the creation, use, editing, and deletion of Named Ranges in an Excel Worksheet. Working with Worksheet Tabs
Everything you´ll ever need to know about using Excel´s worksheets. Learn how to add, copy, rename, order, etc the worksheets in an Excel Workbook Links marked with the [offsite link] designation point to websites not associated with BellaOnline.com. BellaOnline.com is not responsible for the material found there.
Desk Top Publishing Homepage |
Desk Top Publishing Site Map
Think your link belongs here? Use the contact page to let this editor know.
|
