Excel File Formats and Extensions
In this tutorial we'll discuss the file formats supported by Excel.
Cell and Range
A cell is a single element in a worksheet and a range is a collection (or groups) of one or more cells. This tutorial covoers the following topics: 1. Relative, Absolute, Mix & Named References 2. R1C1 Reference Style 3. External References to other worksheets and workbooks
VBA and Macros
Learn how to use VBA to develop macros to automate tasks and manipulate objects to control Office applications. 1. Absolute and Relative Macro Recording 2. VBA Editor (VBE) 3. VBA Data Types 4. VBa Data Types Examples
Custom / User Defined Functions
Learn how to create and use UDFs.
How to use Loops in VBA
VBA provides a number of ways to use loops in your code. In this tutorial, you’ll learn about the different types of loops. VBA provides several different looping structures. This tutorial covers the following topics: 1. For Each … Next Loop 2. Do While Loop 3. Do Until Loop
Working with Events
Excel fires events in response of user actions. Events are procedures that automatically trigger when something happens to the Excel application.
Worksheet events occur for a particular worksheet when something happens to that worksheet. 1. Worksheet Activate and Deactivate Events 2. Worksheet BeforeDoubleClick and BeforeRightClick Events 3. Worksheet Change and SelectionChange Events 4. Worksheet Delete, Calculate, FollowHyperlink Events 5. VBA TableUpdate Event 6. Worksheet PivotTable Events
Workbook events occur for a particular Workbook when something happens to that Workbook. 1. Workbook Activate and Deactivate Events 2. AddInInstall and AddInUninstall Events 3. Workbook AfterSave and BeforeSave Events 4. AfterXmlExport, AfterXmlImport, BeforeXmlExport and BeforeXmlImport Events 5. Workbook Open and Before Close Events 6. BeforePrint, ModelChange and NewChart Events 7. NewSheet Event 8. Workbook Sheet Events 9. Workbook PivotTable Events 10. WindowActivate, WindowDeactivate and WindowResize Events
Application-level events occurs for the Excel application which affect all available workbooks and worksheets. 1. Protected View Events 2. Activating Application Events 3. Protected View Events 4. Sheet Events for all available workbooks 5. Application Pivot Table Events 6. XML Events for Application Object 7. Window Events for Application Object 8. Workbook Activate, Deactivate, AfterCalculate Application Events 10. Application Workbook Addins Events 11. Workbook Sync and Remote Change Application Events 12. Workbook Open, Close, Save Events for Application Object 13. Workbook Printing and Model Change Events for Application Object 14. New Workbook, New Sheet, New Chart Application Events
Every chart trigger events when you make some changes to it. Learn how to monitor embedded charts events. 1. Inserting Chart Sheet 2. Chart Activate, Deactivate, Resize and Calculate Events 3. Chart Select (single click), Double Click, and Right Click Mouse Events 4. Chart MouseDown, MouseMove and MouseUp Events 5. How to use events with an embedded chart
OnTime Event: Schedule a macro or subroutine
1. OnUndo method to Undo a procedure or macro 2. OnRepeat: Run a sub when user chooses Repeat command 3. OnKey Event: Make shortcut keys using VBA
Learn how to create add-ins to get additional functionality from the Excel.
Using XML with Excel
Learn how to create an XML document. 1. Import XML Documents 2. Export Data to XML Document
Learn previous versions of Microsoft Excel