Prabhas Panda

Trainer for Advanced Excel, Excel VBA and Macros, Finance, MS - Powerpoint, MS -Excel, MS-Office, MS-Word, Tableau, VBA Macros and Power BI

English,Hindi,Odia,Tamil

Pune, Maharashtra, India

Available for : Online Teaching | Tuition at my place | Tuition at your place

Advanced ExcelExcel VBA and MacrosFinanceMS - PowerpointMS -ExcelMS-OfficeMS-WordTableauVBA MacrosPower BI

About

Having 17 years of experience in providing corporate training on Advanced Excel, Excel VBA and Macros, Finance, MS - Powerpoint, MS -Excel, MS-Office, MS-Word, Tableau, VBA Macros and Power BI. Conduct Tailor-made Advanced Excel Training for B-schools, MBA Colleges and technical Universities PAN India. Also a visiting faculty for SITM, MITSOM and The school of Logistics. Completed MBA.

Expertise

Advanced Excel - 17 years experience 1000 INR / Hour

Advanced Excel training

Expert in catering advanced excel training to corporate meeting their needs and flexible in designing the contents in line with their business activity. I also offer Pre and Post Training assessment for the L&D team to map the learning curve and assess the effectiveness of the program.

I am specialised in catering Excel for HR, Excel for Finance, Excel for Hospital employees, Excel for Engineers. Excel for sales or marketing.

Excel VBA and Macros - 15 years experience 1500 INR / Hour

MS Excel VBA and Macro Training

  • Create a File Explorer using excel
  • Consolidated 1000 Text files in 30 seconds
  • Collate Data from Mutiple sheets/workbooks in seconds
  • Create a Task Manager using Excel
  • Create an MP3 player using Excel
  • Create a File Management tool in Excel
  • Create a Screen Capture Tool in Excel
  • Create a Data Search Engine using Excel
  • Make Excel Speak like a Human
  • MIS Automation
  • Dashboard Report automation
  • Create a foolproof Training/Survey/Feedback Form

Finance - 15 years experience 1500 INR / Hour

Finance for Non-Finance

Finance is the most important aspect of any business. Understanding finance is not only required by financeteam but for each & every person in the company. Understanding of financial aspects is very important even for non-finance person as the decision taken by non-finance professional may favourably or adversely affect the financial position of the company. Also understanding the financial aspects enhances the capability of taking sound strategic decisions. Our training program on financefor non-finance professional aims at providing working knowledge of finance fundamentals which will empower them to take appropriate decisions taking in toaccount financial aspects. This will result in overall growth of a business organisation.

MS - Powerpoint - 15 years experience 1000 INR / Hour

Full course

PowerPoint Advanced is for the people who can already create simple presentations, and want to add more sophistication. This one-day course shows you how to create a better, effective and meaningful presentation in PowerPoint.

What you will Learn:

  • We understand that presentations are not just about the slides. The training program covers the entire process of presentation creation:
  • Setting Clear Objectives
  • Generating insights with mind mining
  • Creating an outline (or story)
  • Designing Visual Slides
  • Creative ways to simplify complex ideas
  • Creating an engaging opening
  • Factors for Confident Delivery including presenter and audience body language
Key features:
  • Difference between MS- PPT 2010 and other versions
  • Effective Presentation (professional and Meaningful)
  • Comprehensive list of shortcut keys
  • Inserting Sounds and movies.
  • Hidden features of PowerPoint
  • Backstage View
  • Working with your own Tab and Menus.

MS -Excel - 15 years experience 700 INR / Hour

Full course

  • Advanced Ribbon Feature of Excel
  • Capabilities of Pivot Table and Pivot Chart
  • Charts and Graphs Including Smart Art Features
  • Creation of Custom and Dynamic List
  • Condition based formatting , Finding and removing duplicate values
  • Prevention of data Errors and User defined Restrictions
  • Consolidation of 1000 text files using Shell Command, Worksheet and Workbook consolidation
  • Multi-criteria V-Look up and H-lookup and other important Functions
  • Functions( Financial, Text, logical, if and nested ifs, etc.)
  • Create bar chart and organization chart using excel function and Text Box
  • Sorting , Filter and Advanced Filter (Creation a search engine in excel) 
  • Grouping , Outlining along with Subtotals.
  • Creation of Hyperlink(Sheet , work book, email)
  • Protection techniques
  • To work with Multiple workbooks in a single Window.
  • Extensive Keyboard Shortcuts
  • Hidden Features and Functions in Excel
  • Print techniques and management
  • Importing and exporting data from and to various file formats.
  • Workbook sharing and merging various to a single work book.
  • Track changes
  • Working with back stage view and Creation of Own Ribbon Tab
  • How to create macro and usage of them. (In Brief)

MS-Office - 15 years experience 700 INR / Hour

Full course

I can teach all topics in MS-Office.

MS-Word - 15 years experience 700 INR / Hour

Full course

I can teach all topics in MS-Word.

Tableau - 5 years experience 5000 INR / Hour

Full Course

10+ years of experience into Business Intelligence blended with Data Analytics and real time BI implementations of Banking,Retail and Pharma domain which implement BI on a very high scale. Along with the industrial experience, I carry a suite of different use cases in the industry and their solutions as a part of the training. The past candidates have successfully been able to grasp the tool after being taught and keep receiving solutions for existing problems in the Real time experience and bond shared by the trainer.

VBA Macros - 15 years experience 1500 INR / Hour

Full course

  • Create a File Explorer using excel
  • Consolidated 1000 Text files in 30 seconds
  • Collate Data from Mutiple sheets/workbooks in seconds
  • Create a Task Manager using Excel
  • Create an MP3 player using Excel
  • Create a File Management tool in Excel
  • Create a Screen Capture Tool in Excel
  • Create a Data Search Engine using Excel
  • Make Excel Speak like a Human
  • MIS Automation
  • Dashboard Report automation
  • Create a foolproof Training/Survey/Feedback Form

Power BI - 5 years experience 2500 INR / Hour

Aim to provide interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards

  • Why is Power BI important?
  • What is Power BI?
  • Processes in Power BI
  • Do you want to be a Power BI Crackerjack?
  • Companies using Power BI

Reviews

No Reviews Yet!
Advertisements