Enhancing productivity and performance may seem obvious in theory but actual implementation requires careful replacing drudgery of repetitive command sequencing to automation, especially in data manipulation tasks using spreadsheet application brands like Excel 2013. Most executives use Excel tool to accomplish their daily task but most are not aware that they can save a lot of their energy by learning Macros in Excel.
Why Walk when you can Leap
This Saturday (21-06-2014), PMtutor offers a practical workshop on Macros and it Visual Basic Application.
Time: 3pm to 6pm
Venue: The PentHouse, 125A Apapa Road behind Skye Bank, Costain Bus Stop
Fee: N25, 000 N10, 000
Payment Details: Access Bank 0006551542 Poet Solvers Ltd
Prerequisite: Advance Knowledge in Excel
At the end of the training, participants must have learnt the following below:
- Basic Understanding of Macros
- Security regarding Macros
- Recording a Macro
- Absolute and Relative Recording
- Using the Quick Access Toolbar to run macros
- Using keystroke as a short cut to run macros
- Using Buttons as a short cut to run macros
- Intro to Visual Basic Application
- Components of Visual Basic Application
- Recording Macros in Stages
- Altering Macros
- Creating Non-recordable VBA code
- Case Study: Converting a Mailing List into a Database List
