Tuesday, 18 March 2014

Excel macro tutorial

Major topics covered in this excel macro tutorial are -

1. Excel Macro
  1. Why we need excel macros
  2. Applications of excel macro
2. Visual Basic Editor
  1. Recording excel macros
  2. Debugging excel macro
  3. Running
  4. Modules
  5. Sub routines
  6. Functions
3. Excel Macro Settings
  1. Saving excel macro workbooks
  2. Enabling excel macro
  3. Assigning Macros to the buttons
4. Excel Object Model
  1. Objects
  2. Collections
  3. Methods
  4. Properties
5. Workbooks
  1. Creating new workbooks
  2. Deleting workbooks
  3. Opening workbooks
  4. Saving workbooks
6. Worksheets
  1. Add new worksheet
  2. Edit worksheet
  3. Delete worksheet
  4. Sort worksheets
  5. Move worksheets to different workbooks and within a workbook
7. Working with data using Excel Macro
  1. Sort data
  2. Filter data
  3. Insert rows and columns
  4. Delete existing rows and columns
  5. Format the cells 
  6. Find blank rows and cells
  7. Remove spaces from the cell values
  8. Replace the cell values with other text
8. Working with Charts using Excel Macro
  1. Create a chart
  2. Delete a chart
  3. Edit chart options
9. Pivot Table and Pivot charts
  1. Create a pivot table
  2. Edit pivot chart
10. Working with other office products
  1. Send mail with attachment
  2. connecting to access database

The link to buy this book on excel macro is here

Topics covered in this book are -
  1. Excel Macro - what are they and why we need them.
  2. Visual Basic Editor in Excel - recording, running, debugging, modules, sub, functions.
  3. Macro Settings - saving, enabling, assigning buttons to macros on Tool bar.
  4. Excel Object Model  - objects, collections.
  5. Workbooks - create, open, read, save, edit, protect, delete, search in directory, find open books.
  6. Worksheets - add, delete, hide, move, reorder, sort, changing tab Colour of sheet.
  7. 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.
  8. Automating Charts ->creating new chart, delete, edit chart source, legend etc.
  9. Working with Pivot Table and Charts.
  10. 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.

Popular Posts

Search This Blog