Awards
Join OfficeTipsAndMethods

Have some suggestions to share with the world?

Join OfficeTipsAndMethods and share your insight in a Comment. You must be a member to comment and all comments are moderated before being published. Membership is free and we would never share your personal information with anyone.

Become an OTM Member

Log In

YouTube Video Channel
OfficeFix
Article Categories

So You Want to Expand Your Office Knowledge?

Here are some useful links that I have recently come across on the Web. The list is weighted in favour of Excel only because, at the moment, I am doing mostly Excel training.

OFFICE

Migrating from Excel 2003 to Excel 2010

A help guide to working with the Fluent User Interface (Ribbon) first introduced in Office 2007 and enhanced in Office 2010, replacing traditional menus and toolbars

BLOGS AND PEER SUPPORT SITES

Office Tips and Methods

A blog focusing on tips and how to techniques for getting the most out of Microsoft Office Applications

UtterAccess

User peer support forum primarily focused on Microsoft Access but with an active Excel forum as well

Mr. Excel

Bill Jelen’s (Mr. Excel) site includes peer support forum and many pages of Excel help and tips from Mr. Excel himself

Excel is Fun!

YouTube gateway to the ExcelisFun channel –hundreds of well documented videos illustrating how to do just about anything in Excel.

Microsoft Answers

http://office.microsoft.com/en-us/excel-help/use-excel-spin-boxes-to-help-with-financial-modeling-HA001226521.aspx?pid=CL100570551033

EXCEL

http://www.scoop.it/t/excel-hero-linkedin-group/

An excellent collection of Excel related links

http://www.lynda.com/Excel-2007-tutorials/Data-Validation-in-Depth/77849-2.html

Clever data validation example

http://www.andypope.info/charts.htm

Charting Examples

http://dmcritchie.mvps.org/excel/colors.htm

Color Palette and the 56 Excel ColorIndex Colors:

http://www.contextures.com/xlUserForm01.html

Create an Excel UserForm

https://sites.google.com/site/exceladdinsdirectory/

Excel Add-ins Directory:

http://www.excel-blackbelt.com/

Analytics and Visualization

http://social.msdn.microsoft.com/Forums/en-US/exceldev/threads

Excel for Developers

http://excel.tips.net/C0200_Macros.html

ExcelTips:

http://www.excel-spreadsheet.com/vba/vba.htm

Excel VBA – Reference Guide

http://www.exinfm.com/free_spreadsheets.html

Free Spreadsheets

https://groups.google.com/forum/?hl=en&fromgroups#!forum/microsoft.public.excel.programming

microsoft.public.excel.programming:

http://www.gummy-stuff.org/Excel/

Index of /Excel:

http://spreadsheetpage.com/

The Spreadsheet Page:

https://sites.google.com/site/exceladdinsdirectory/home/main-directory

Excel Add-ins Directory

http://answers.microsoft.com/en-us/office/forum/excel

Use Excel spin boxes to help with financial modeling:

http://www.functionx.com/vbaexcel/

VBA for Microsoft Office Excel 2007

http://tech.groups.yahoo.com/group/ms_excel/

Yahoo Groups MS_Excel

http://tech.groups.yahoo.com/group/ExcelVBA/

Yahoo Groups Excel VBA:training.

Comments are closed.