Excel Tutorial

This Excel tutorial section is designed for novice to intermediate users.

The purpose of this tutorial is to get you familiar with basic to advanced functions and formulas of Excel’s data analysis tools and macro. I have been using Excel for 20 years. I love it! I hope you enjoy these pages and learn something new.

• Pivot Table
• VBA
• SUMIF
• Macro
• Excel Index
• VLookup
• Excel Formulas
• Excel Shortcuts
• Excel Match
• Excel Indirect
• Excel Offset
• Excel Lookup
• Excel Hlookup
• Excel Count
• Excel Enable Macros 2003
• Excel Enable Macros 2007
• Excel Enable Macros