Mekjspa's email address and phone number have been validated.
Mekjspa
- Rate RM101
- Response 1h
RM101/h
See Microsoft Excel tutors
This tutor is currently unavailable
- Microsoft Excel
Excel instructor with 30 years' experience all levels. Learn to create stunning, effective and comprehensive spreadsheets in just a few hours!
- Microsoft Excel
Lesson location
About Mekjspa
I began my 39+ year career as a COBOL programmer creating and maintaining applications in numerous industries including Wholesale Floor Planning, Financial Automation, Inventory Accounting, Healthcare Administration and Automotive Leasing with five companies over a sixteen-year period. My unique experience with The Philadelphia Stock Exchange (PHLX) (seven years) and with Fund Services at Vanguard (five years outsourcing via Capgemini Digital Services) has afforded me the opportunity to build and support innovative financial applications that processed transactions for New Fund Launch, Regulatory Reporting, Reconciliations, Trade Processing, Money Market Funds and Tax Reporting. In developing these systems, my duties have expanded to include Business Analyst and Project Management responsibilities. I have operated in all SDLC phases, from Requirements Analysis to Implementation. At PHLX, I was part of a team that established and maintained Trading Floor Corrections (KEYMASTER batch and CICS / DB2) Next Day (T+1) settlement processing to insure correct positions for the stock exchanges. At Vanguard, the business solutions I created processed ETF Funds and Money Market transactions using VBA / SQL logic and procedures within MS Access and Excel, as a component of their 7 trillion-dollar Assets Under Management portfolio. Application development is an art as much as it is a science. The importance of programming for efficiency and future ease of maintenance remains as a top-priority. I have learned and continue to follow the roadmap to successful development:
o Always operate in the vision of Executive Management
o Reduce risk and enable security at every opportunity
o Procure a realistic understanding of your human and technological resources
o Stay within scope to complete comprehensive and accurate projects on time and on budget
o Maintain integrity and humility as you seek to exceed client expectations
o Prepare intuitive documentation and deliver exceptional training presentations
o Assist clients to understand and maximize the usage of complex computer applications
See more
About the lesson
- Primary
- Secondary
- SPM
- +10
levels :
Primary
Secondary
SPM
Form 6
STPM
Adult education
Masters
Doctorate
Beginner
Intermediate
Advanced
Professional
Kids
- English
All languages in which the lesson is available :
English
Students will learn all aspects of the EXCEL Interactive Development Environment (IDE) as they build spreadsheets from the ground up. This includes utilizing Keyboard Shortcuts, customizing the Ribbon and Quick Access Toolbar (QAT). Using the 3-Tiered approach of Concepts, Terminology and Technique, workbooks will be created such as Amortization, Schedule. Trade Discount, School Budget, Payroll and Sales Analysis. All of the major Excel skills will be taught which include Formulas, Functions, Formatting, Data Validation, Pivot Tables and Charts, Conditional Formatting, Auto Fill, Absolute and Relative Cell Reference, VLOOKUP, Transpose and much, much more! Some of the more advanced features that students will learn include working with Macros and Visual Basic for Applications (VBA). My 35-year experience as a Computer Programmer allows me to build sound development structure into my lesson plans. All of the spreadsheets were created by me to incorporate pertinent Excel skills.
See more
Rates
Rate
- RM101
Pack rates
- 5h: RM505
- 10h: RM1010
online
- RM101/h
Similar Microsoft Excel tutors in Girard
Asil
Petaling Jaya & online
- RM150/h
Tan
Puchong & online
- RM80/h
- 1st lesson belanja
Ziad
Subang Jaya & online
- RM79/h
- 1st lesson belanja
Carlos
Petaling Jaya & online
- RM80/h
- 1st lesson belanja
Fakir
Seri Kembangan & online
- RM60/h
- 1st lesson belanja
Mohd
George Town & online
- RM45/h
- 1st lesson belanja
Wani
Bayan Lepas & online
- RM40/h
- 1st lesson belanja
Pavithira
Kajang & online
- RM50/h
- 1st lesson belanja
Ben
Petaling Jaya & online
- RM80/h
- 1st lesson belanja
Hareth
Ampang
- RM70/h
- 1st lesson belanja
Akmal
Johor Bahru & online
- RM80/h
- 1st lesson belanja
Mohd
Shah Alam & online
- RM150/h
Abhimanyu
Petaling Jaya & online
- RM40/h
- 1st lesson belanja
Abdul
Johor Bahru & online
- RM90/h
- 1st lesson belanja
Adib
Kuala Lumpur & online
- RM29/h
- 1st lesson belanja
Tan
Bayan Lepas & online
- RM70/h
- 1st lesson belanja
Nian Hee
Sibu & online
- RM85/h
- 1st lesson belanja
Mohd Khomaini Bin
Kepala Batas & online
- RM114/h
- 1st lesson belanja
Arfan
Kuala Lumpur & online
- RM75/h
- 1st lesson belanja
Rebecca
Ipoh & online
- RM50/h
- 1st lesson belanja
-
See Microsoft Excel tutors
