Major topics covered in this excel macro tutorial are -
1. Excel Macro
Topics covered in this book are -
What do you think on above excel macro topic? Please provide your input, comments, questions on excel macro. I will try to reply as soon as possible. I value your opinion on Excel Macros.
1. Excel Macro
- Why we need excel macros
- Applications of excel macro
2. Visual Basic Editor
- Recording excel macros
- Debugging excel macro
- Running
- Modules
- Sub routines
- Functions
3. Excel Macro Settings
- Saving excel macro workbooks
- Enabling excel macro
- Assigning Macros to the buttons
4. Excel Object Model
- Objects
- Collections
- Methods
- Properties
5. Workbooks
- Creating new workbooks
- Deleting workbooks
- Opening workbooks
- Saving workbooks
6. Worksheets
- Add new worksheet
- Edit worksheet
- Delete worksheet
- Sort worksheets
- Move worksheets to different workbooks and within a workbook
7. Working with data using Excel Macro
- Sort data
- Filter data
- Insert rows and columns
- Delete existing rows and columns
- Format the cells
- Find blank rows and cells
- Remove spaces from the cell values
- Replace the cell values with other text
8. Working with Charts using Excel Macro
- Create a chart
- Delete a chart
- Edit chart options
9. Pivot Table and Pivot charts
- Create a pivot table
- Edit pivot chart
10. Working with other office products
- Send mail with attachment
- connecting to access database
The link to buy this book on excel macro is here.
Topics covered in this book are -
- Excel Macro - what are they and why we need them.
- Visual Basic Editor in Excel - recording, running, debugging, modules, sub, functions.
- Macro Settings - saving, enabling, assigning buttons to macros on Tool bar.
- Excel Object Model - objects, collections.
- Workbooks - create, open, read, save, edit, protect, delete, search in directory, find open books.
- Worksheets - add, delete, hide, move, reorder, sort, changing tab Colour of sheet.
- Manipulating and formatting with data->copy/paste, trim, font, padding, replacing, filter, add/delete rows and columns, working with cells in the range, functions and formulae.
- Automating Charts ->creating new chart, delete, edit chart source, legend etc.
- Working with Pivot Table and Charts.
- Communicating with other office products like outlook, word, Powerpoint and access.
What do you think on above excel macro topic? Please provide your input, comments, questions on excel macro. I will try to reply as soon as possible. I value your opinion on Excel Macros.