A How To Reference for Excel and VBA

Learning how to write VBA for Excel plus general Excel tips

Note that near the bottom of this page are two special sections:
1. Links to just the Excel-only sections
2. Downloadable worksheets for lessons/learning

Keywords to Search for Details Topics

All code here was run using Office Excel 2010
Click the links in the below for more details
Note in the below that all ''COOL VBA Features'' have a blue background

Getting Started

Excel Introductory Topics
Links  to  below  Category
Groups
                                                                                                    

Variables

Variable Types
Data Conversion
Date and Time
Arrays
'

Operators

Excel Shortcut Keys

Program Flow, Error Handling, and Debugging VBA

Search / Find

Workbooks and Worksheets

Workbook
Workbook
Worksheet
Worksheet

Cells, Columns and Rows

Cells
Columns
Rows

Ranges

Formatting

Formulas

Features
Features
Functions by Category (over 420)

Tables, Pivot Tables and Charts

GUI

File I/O

Miscellaneous



For Excel-only-skip-VBA, use these links...

(You can also see (search for) the ''Excel Alternative to VBA'' in the various sections that apply to both Excel and VBA)

Links to Excel-only FUNCTIONS:
AND and OR Functions
CHOOSE Function
Counting and COUNTIFS Function
FIND Function vs. SEARCH Function
HYPERLINK Function
INDEX and MATCH Functions instead of VLOOKUP
INDIRECT Function
LARGE and SUMIFS Functions to Find High Value
Selection with Random Value: RANDBETWEEN Function
SMALL and SUMIFS Functions to Find Low Value
SEARCH function
SUBSTITUTE function
SUMIFS and LARGE Functions
SUMPRODUCT function with other Excel Functions equals Power and Versatility
VLOOKUP
Weighted Randomly Selected Values
Excel Formulas
Excel Functions by Category
Excel Functions by Category: Compatibility
Excel Functions by Category: Cube
Excel Functions by Category: Database
Excel Functions by Category: Date and Time
Excel Functions by Category: Engineering
Excel Functions by Category: Financial
Excel Functions by Category: Information
Excel Functions by Category: Logical
Excel Functions by Category: Lookup and Reference
Excel Functions by Category: Math and Trigonometry
Excel Functions by Category: Statistical
Excel Functions by Category: Text
Excel Functions by Category: User Defined

Links to Excel-only ACTIONS:
Cell Insertion
Cells References for Formulas
Close Workbook or End Excel
Copy only Visible Cells (Rows and Columns)
Count - Various ways
Count Unique Values
Drop Duplicates
Formula Deletion but Keep the Calculated Value
Get Filename
Pivot Build
Pivot Filter
Pivot Slicer
Pivot Sort
Row Alternate Colors
Row Counter
Sorting Data
String Manipulation: Left, Right, Mid
Table Transpose
Values Count, Search and Randomly Select
Workbook and Worksheet Referencing in Formulas
Print Excel including Page Headings
Worksheet Print including Page Heading

Links to Excel-only SPECIAL ITEMS:
Excel Customization for Menu and Toolbars
Excel Options Selections
Excel Shortcut Keys
CarriageReturn / LineFeed / NewLine Find-and-Replace
Special Characters in Excel and VBA
Format Painter
File Import for Delimited other than by Commas
Excel File Save Dialog





Training Spreadsheet - Master File - an Excel demo learning tool
Training Spreadsheet - Supplemental File - open this before opening the above Master
The 'Do It All' Training Spreadsheet - a VBA demo learning tool
Excel Formulas Galore - learn Excel formulas by randomly generating fake accounts





Copyright © 2014- by Larry Wilson, all rights reserved