VBA (Excel,
من 126.81 AED /س
VBA is a tool which is easily within People's reach and can take productivity, accuracy to levels beyond imagination. When data and complexity of projects are not very huge to get into fancy IT applications, VBA comes into picture to get things done efficiently with satisfactory results.
Some of the projects (VBA based) that I have personally undertaken in the past include Building financial and deal models to simulate best/worst case scenarios, Automated Legal contract generation with appropriate wordings and clauses based on specific inputs, Outlook/Mail automation to handle data through attachments or within body of mail, automated market analysis or financial analysis, data consolidation etc...
Based on the level, the training is designed to help and understand VBA and Macros and the power of building custom modules. To reinforce what is taught, there will be a few hands on sessions with a problem statement or example data/files.
Some of the projects (VBA based) that I have personally undertaken in the past include Building financial and deal models to simulate best/worst case scenarios, Automated Legal contract generation with appropriate wordings and clauses based on specific inputs, Outlook/Mail automation to handle data through attachments or within body of mail, automated market analysis or financial analysis, data consolidation etc...
Based on the level, the training is designed to help and understand VBA and Macros and the power of building custom modules. To reinforce what is taught, there will be a few hands on sessions with a problem statement or example data/files.
معلومات إضافية
A discussion would be needed before beginning the session to understand the level and to adapt the training. A hands on session is absolutely recommended to test the learning and reinforce what is learnt
المكان
عند الطالب :
- بالقرب من بروكسل, بلجيكا
عند المعلم :
- Meilaan, 1200 Sint-Lambrechts-Woluwe, Belgium
عبر الانترنت من بلجيكا
من أنا؟
Enterprising, tech savvy person, with proven experience in Financial Modelling and who is also a motivated & fast learner; Open to opportunities which present immense potential to learn, grow and make an impact with people and processes.
I am undertaking involves tasks such as automating workflows to save time, improve processes by building custom Windows applications with VBA on Microsoft Office platform. I would like to offer training to share my knowledge and reach more people.
I am undertaking involves tasks such as automating workflows to save time, improve processes by building custom Windows applications with VBA on Microsoft Office platform. I would like to offer training to share my knowledge and reach more people.
المستوى التعليمي
EDHEC Business School
Master of Science, Strategy and Organization Consultancy
2014 – 2015
EDHEC Business School
Masters in Management, Business Administration and Management, General
2012 – 2013
National Institute of Engineering, Mysore
Bachelor of Engineering (BE), Electrical and Electronics Engineering
2007 – 2011
Master of Science, Strategy and Organization Consultancy
2014 – 2015
EDHEC Business School
Masters in Management, Business Administration and Management, General
2012 – 2013
National Institute of Engineering, Mysore
Bachelor of Engineering (BE), Electrical and Electronics Engineering
2007 – 2011
الخبرة / المؤهلات
DS Smith
Financial Business Analyst
September 2017 – Present (11 months)Brussels Area, Belgium
☛ Coordination of KPI Data Collection, Consolidation, Understanding Key business drivers and Challenge where relevant, trend analysis
☛ Analysis and Support the presentation of Sales and Business Development reports to Sales Organisation and Management
☛ Support Process/Methodology enhancement, tool maintenance and data testing
☛ Dashboard and Report building including profitability reports for Market Segmentation project
MasterCard
Analyst, Deal Management (Business Development, Finance)
September 2015 – September 2017 (2 years 1 month)Belgium
☛ Assisting with analysis to support Customer Account Managers
☛ Supporting operational functions and recommending solutions for problem resolution & process improvement
☛ Identification of opportunities to improve the quality and success rate of proposals
☛ Building and maintaining financial models and business cases - Part of implementation of standard models across Europe and Asia Pacific regions
☛ Addition of features to the financial models and business case based on Regulatory and/or business requirements
☛ Building and maintaining custom made tools for internal control process involved with contract review and signature process
☛ Management and executive reporting
Undertook various initiatives in areas related to Internal controls, compliance, legal/contract management and process improvements.
Entrepreneurs That SOAR!
Business Development Coordinator
December 2014 – August 2015 (9 months)
Virtual Internship - New Media marketing
☛ Collaborated with the president of the group to Create Products and Service Plans to leverage on Video Capabilities for Marketing efforts. (B2B Solutions)
☛ Creation of Online Community offering learning materials on subjects such as benefiting from the tools of new media marketing and use of Webcasts, Webinars and Virtual events to boost business
Toyota Motor Europe
Pricing, Sales & Marketing
June 2013 – July 2014 (1 year 2 months)Brussels Area, Belgium
Principle responsibility was to support the Lexus pricing team to handle pricing process in the Pan-European market, and Price Lexus models expected to be launched in 2014.
Key assignments or Projects included
☛ Price scheduling - A monthly process involving finalizing the pricing structure throughout the value chain and its impact on either side of the chain.
☛ Net price positioning - A quarterly process involving selection of competitor basket, comparing the prices in a normalized platform and providing all the necessary information for taking a pricing decision.
☛ Value table revision - A price table used for net price positing in order to compare Similar cars. The values are used to evaluate the advantages and disadvantages among the models chosen based on standard equipment on each of those models.
☛ New model pricing - Analysis and price structure for the introduction of the Lexus RC and the RC F in 13 countries of Europe.
☛ Assisting the Product division in creating a new safety strategy across all models of Toyota and Lexus in Europe.
☛ On demand / on request study of taxation, products and specifications offered in various countries under jurisdiction.
ABB India Ltd.
Engineer/Management trainee, Sales and Marketing, Low Voltage Systems & Process Automation
June 2011 – July 2012 (1 year 2 months)Bengaluru Area, India
☛ Participated and drove the definition and preparation of marketing tools customized for local needs: Technical clarifications, Solution description, technical consulting.
☛Assisted in planning for production with feeder listing and standard specification
☛ Interfacing with the front-end office for understanding the requirements and assembling them for further processing as every product was custom made.
☛ Involved in costing
☛ Trained in general commercial aspects and Project Management
☛ Worked for standardizing the offers made for stackers-reclaimers in process Automation Division as an individual project
Financial Business Analyst
September 2017 – Present (11 months)Brussels Area, Belgium
☛ Coordination of KPI Data Collection, Consolidation, Understanding Key business drivers and Challenge where relevant, trend analysis
☛ Analysis and Support the presentation of Sales and Business Development reports to Sales Organisation and Management
☛ Support Process/Methodology enhancement, tool maintenance and data testing
☛ Dashboard and Report building including profitability reports for Market Segmentation project
MasterCard
Analyst, Deal Management (Business Development, Finance)
September 2015 – September 2017 (2 years 1 month)Belgium
☛ Assisting with analysis to support Customer Account Managers
☛ Supporting operational functions and recommending solutions for problem resolution & process improvement
☛ Identification of opportunities to improve the quality and success rate of proposals
☛ Building and maintaining financial models and business cases - Part of implementation of standard models across Europe and Asia Pacific regions
☛ Addition of features to the financial models and business case based on Regulatory and/or business requirements
☛ Building and maintaining custom made tools for internal control process involved with contract review and signature process
☛ Management and executive reporting
Undertook various initiatives in areas related to Internal controls, compliance, legal/contract management and process improvements.
Entrepreneurs That SOAR!
Business Development Coordinator
December 2014 – August 2015 (9 months)
Virtual Internship - New Media marketing
☛ Collaborated with the president of the group to Create Products and Service Plans to leverage on Video Capabilities for Marketing efforts. (B2B Solutions)
☛ Creation of Online Community offering learning materials on subjects such as benefiting from the tools of new media marketing and use of Webcasts, Webinars and Virtual events to boost business
Toyota Motor Europe
Pricing, Sales & Marketing
June 2013 – July 2014 (1 year 2 months)Brussels Area, Belgium
Principle responsibility was to support the Lexus pricing team to handle pricing process in the Pan-European market, and Price Lexus models expected to be launched in 2014.
Key assignments or Projects included
☛ Price scheduling - A monthly process involving finalizing the pricing structure throughout the value chain and its impact on either side of the chain.
☛ Net price positioning - A quarterly process involving selection of competitor basket, comparing the prices in a normalized platform and providing all the necessary information for taking a pricing decision.
☛ Value table revision - A price table used for net price positing in order to compare Similar cars. The values are used to evaluate the advantages and disadvantages among the models chosen based on standard equipment on each of those models.
☛ New model pricing - Analysis and price structure for the introduction of the Lexus RC and the RC F in 13 countries of Europe.
☛ Assisting the Product division in creating a new safety strategy across all models of Toyota and Lexus in Europe.
☛ On demand / on request study of taxation, products and specifications offered in various countries under jurisdiction.
ABB India Ltd.
Engineer/Management trainee, Sales and Marketing, Low Voltage Systems & Process Automation
June 2011 – July 2012 (1 year 2 months)Bengaluru Area, India
☛ Participated and drove the definition and preparation of marketing tools customized for local needs: Technical clarifications, Solution description, technical consulting.
☛Assisted in planning for production with feeder listing and standard specification
☛ Interfacing with the front-end office for understanding the requirements and assembling them for further processing as every product was custom made.
☛ Involved in costing
☛ Trained in general commercial aspects and Project Management
☛ Worked for standardizing the offers made for stackers-reclaimers in process Automation Division as an individual project
السن
شباب (13-17 سنة)
الكبار (18-64 سنة)
الكبار (65 سنة فأكثر)
مستوى الطالب
مبتدئ
متوسط
متقدم
المدة
60 دقيقة
الدرس يدور باللغة
الإنجليزية
الفرنسية
المراجعات
الجاهزية في الأسبوع العادي
(GMT -05:00)
نيويورك
عند المدرّس و عبر الانترنت
عند التلميذ
Mon
Tue
Wed
Thu
Fri
Sat
Sun
00-04
04-08
08-12
12-16
16-20
20-24
فصول مماثلة
فصول مماثلة
ضمان المدرس المناسب
اتصل بPavan