Micosoft Excel is the most used business software in the present-day market. It is commonly used to perform simple calculations, data storage, data analysis, report generation and complex statistical computations. Most of the companies and organizations use Excel for data analysis. The present day managerial job requires lots of analysis related work that requires managers to work with data. Microsoft Excel is one the most powerful yet very easy tools to use for performing dynamic analysis and sophisticated operations. Understanding the features and knowing how to use all its functions is key to work efficiency. This training course has been designed to give attendees a solid understanding of more advanced tools and concepts used in Excel 2013, 2016 or office365 in order to increase their knowledge and productivity for performing complex business operations and overall management functions.

WHO SHOULD ATTEND

Share With Friends

Binaya Karmacharya

(Certified Trainer)

Resource Person

Over 15 years of experience in Accounting and Finance, Internal Audit, HR, Resource Management in different industries including Hospitality, Automobile, Education/Project, Telecom and Banking Training Institute. Over 9 years of experience in Senior Management Position in Multinational Companies.

Provided Advance Excel training to various industries including I/NGO’s (Unicef, UNDP, OXFAM International, FHI 360 Nepal, Winrock International, Handicap International, Green Tara Nepal), Insurance (Siddhartha Insurance Ltd.), Commercial and Development Banks (Nabil Bank, NCC Bank, NB Bank, Janata Bank, MBL, Agricultural Development Bank & Deva Bikas Bank Ltd., Telecoms (Nepal Telecom), HR Consulting firm (Real Solutions, Askme Management and CMS Pvt. Ltd.), Institute of Chartered Accountants of Nepal (ICAN), Prabhu Capital Ltd., New Talent Home training service provider, Dabur Nepal Pvt. Ltd.

Delivered advance excel training (including concept of Dashboard, Data Analysis, introduction of Macros and VBA) for Unicef Janakpur, Bhairahawa and Nepalgunj field office During professional career, on Excel platform, developed the local stock management system for automobile business, Inventory/fixed assets management system for telecom industries and designed more than 100 of professional templates for accounting, admin and HR functions.

Key Takeaways

Understanding key formulas and functions essential to excel users along with features to help manage formulas, functions and ranges
Exploring the different Lookup functions, ideal add further functionality to a spreadsheet to reference particular data quickly and effectively
Learning how to manage spreadsheet data making it a less daunting and redundant to manage the data
Creating Pivot Tables in order to display and summaries large quantities of data effectively
Developing your ability to effectively create charts and format them specific to the reader

Other Trainings