Prabhas Panda

Experienced Tutor for Advanced Excel, Computer Fundamentals, Excel VBA and Macros, Finance, MS - Powerpoint, MS -Excel, MS-Office, MS-Word and VBA Macros

English,Hindi,Odia,Tamil

Pune, Maharashtra, India

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

Advanced ExcelComputer FundamentalsExcel VBA and MacrosFinanceMS - PowerpointMS -ExcelMS-OfficeMS-WordVBA Macros

About

Having 15 years of teaching experience in Advanced Excel, Computer Fundamentals, Excel VBA and Macros, Finance, MS - Powerpoint, MS -Excel, MS-Office, MS-Word and VBA Macros. Completed CA and Master of Business Administration.

Expertise

Advanced Excel - 15 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.

Computer Fundamentals - 15 years experience 500 INR / Hour

Basic Computer Learning MS Office Internet

I can teach basics of windows operating system, over view of Microsoft Office and how to use internet for emailing and working with social websites.

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.

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

Reviews

No Reviews Yet!
Advertisements
E-Books Store