Workshop on
Developing Excel Based Application: Advanced MS Excel 2007
Course Description
09:45 AM 10:15 AM
Reading real life business cases with trainer
Recognize the need of advanced Excel applications
Discussion on content and developing expectation from the course
10:15 AM 10:30 AM
Tea/Coffee Break + Group Consultation with Trainer
10:30 AM 11:30 AM
Understand and identify various objects in Excel
Creating Variables: Naming cells, ranges of cells and worksheets
Understand and apply Absolute and Relative Referencing
Create links between worksheets and workbooks
11:30 AM 1:00 PM
Get introduced to advanced logical functions
Learn how and when to use basic IF and nested IF functions
Learn how and when to use IF with AND logic and IF with OR Logic
Know the use and application of SUMIF, SUMIFS, COUNTIF, COUNTIFS and similar other functions.
1:00 PM 2:30 PM
Lunch and Prayer Break
2:30 PM 3:45 PM
Get introduced to advanced tools in Excel
Understand and apply various data validation techniques
Understand and apply formula based conditional formatting
Understand and apply Advanced Filtering
3:45 PM 4:00 PM
Tea/Coffee Break + Group Consultation with Trainer
4:00 PM 5:30 PM
Get introduced to advanced lookup and referencing functions
Understand and apply Vlookup and Hlookup Function
Understand and apply Match, Index and Choose Functions
Understand and apply Row and Column Functions
Day Two
10:00 AM 11:00 AM
Get introduced to Forms and Control Toolbox
Know how to use Drop-down Box, Combo Box, Option Button and Check Boxes
Know how to use ActiveX controls
11:00 AM 11:15 AM
Tea/Coffee Break + Group Consultation with Trainer
11:15 AM 12:45 PM
Know how to record macros and assign macros to Buttons and Control Tools;
Interpret macro codes and VBA environment
Get introduced to VBA programming and writing User-Defined-Functions
12:45 PM 1:45 PM
Lunch and Prayer Break
2:00 PM 4:30 PM
Fundamentals of Application Interface Development
Develop Practical Applications (any two of the following)
(a) Data Presentation Application (Market/Sales/Finance/Accounting Data)
(b) Financial recording application (Journal to Financial Statements)
(c) Sales performance dashboard and forecast model;
(d) Business Valuation Application;
(e) Investment Project Selection Application.
4:30 PM 5:00 PM
Consolidation of learning
Questions and Answers
Training Evaluation
Discussion on future learning initiatives
5:00 PM 5:15 PM
Certificate distribution and participant speech
Closing Speech
Resource Person
Muhammad Arifur Rahman is an independent consultant having expertise on traditional and Islamic finance, Accounting Information System, Cost Accounting, Management Information System, Project Management, Data Driven Business Research, Quality Management, Business Process Outsourcing, Business Development and ,most importantly, on learning and development.
In the recent years, Muhammad had worked as Head of Business Development of a leading BPO company in Bangladesh. Before that he worked for British investment firm as a Budgeting Expert. He has gained experience in consulting profession by working independently with a number of MNCs and major telecom operators in Bangladesh. He had successfully conducted more than 100 training programmes on his expert areas over the last 5 years. His major academic area is finance. Besides this he carried on gaining professional qualification on management accounting, Islamic finance, project management and risk management. He also achieved number of IT certifications including Microsofts certification on Excel and ICDL certification computing and information technology.
Muhammad, started his career as a web developer back in 2002. Later on, he independently worked as a software developer and developed number of finance and accounting software on sole effort. He also worked as lecturer in number of local universities, colleges and schools with British curriculum.
At present, Muhammad is dedicatedly working on various business consulting, professional training and development projects.