We are in process of building the inventory of good professionals in this categoryGot it!
Connect With Venu Gopal
You have reached a limit!
We only allow 20 Tutor contacts under a category. Please send us an email at email@example.com for contacting more Tutors.
Further Information Received
Thank you for providing more information about your requirement. You will hear back soon from the trainer
S R Nagar, Hyderabad
Hi, I am Venu Gopal Komaragiri, hereby I would like to introduce myself as a Advanced Excel and VBA(Macros) faculty, I am working for one of the top MNC in Hyderabad as a VBA Developer, I am holding 6 years of experience in MIS Reporting, Data Analysis, Dashboard Development, Database Maintenance and VBA(Excel, PowerPoint, Access) Development. Course duration will be 45 days for both the Advanced Excel and VBA, after course completion I will be provide some useful content to students like Overview on Reports, Report types, MIS and Reporting and Dashboard preparation with real time examples. Apart from this Excel formulas with examples and Short Cut keys, Q&A's, Resume Tips and Sample Resumes will be provided.
Introduction What is an Excel? Histroy, Versions Opportunities & Career Growth Cell Formatting Format Painter Paste Links Paste Special Cell Alignment Indent Increase/Decrease Wrap Text Merge & Center Number Format Conditional Formatting Convert to Table Cells Insert/Delete Row Height, Column Width Find, Replace & GoTo Tables Create Tables Tables Formatting Convert Tables to Ranges Filters & Adv.Filters PivotTables Pivot Charts Insert Slicers Change Data Source Copy and Move Caluculated Fields Sub Totals, Grand Totals Report Layouts Pivot Styles Charts Pie Chart Line Charts Bar Charts Interactive Charts Sparklines Formulas Logical IF, And, Or, IFError ISBlank, ISError ISNumber,ISText ISFormula,ISNA Text Clean Concatenate Find Left Len Mid Lower Proper Replace Repeat Right Substitute Text Trim Upper Date & Time Day Now Today WeekDay WeekNum Lookup & Reference Lookup Vlookup Hlookup Choose Row Column Match Index Offset Transpose Hyperlink Conditional Sum SumIf Sumifs Count CountA CountIf CountIfs CountBlank Average AverageIf Defined Names Name Manager Define Name Using Names in Formulas & Pivot Tables Data Importing & Exporting Data Creating Connections with other Applications Text to Columns Remove Duplicates Data Validation Scinario Manager Goal Seek Data Table Grouping, Ungrouping, Sub Totals Flash Fill View Removing/Adding Formula Bar Removing/Adding Gridlines Removing/Adding Row Headers Removing/Adding Column Headers Zoom New Window Arange All Freeze Panes Split Text Text Box Word Art Object Shapes & Hyperlinks Advanced Features Hide/Unhide Sheets Hide/Unhide Workbooks Protect/Unprotect Sheets Protect/Unprotect Workbooks Hide/Unhide ScrollBars Hide/Unhide Status Bar Quick Access Tool Bar Customize Ribbon Collapse the Ribbon Creating Symbols with Fonts Watch Window Calculation Options Formula Auditing Short Cuts Introduction What is VBA? How is it Useful? Histroy, Versions Opportunities & Career Growth Recording a Macro Recording Options Absolute References Relative References Different workbooks to store macro What is a Personal Macro Workbook? Viewing,Deleting Working with the Personal Macro Workbook ? Different ways to run a Macro Changing Options Public & Private Procedures Visual Basic Editor (VBA IDE) Project Explorer Excel Objects VBA Objects Userforms Modules Class Modules Object Browser Properties Window Code Window Immediate Window Locals Window Watch Window The VBA Language Data Types Operators Variable Declaration Basic Input & Output Functoins The Active Properties Decision Making Iif, if (single line & multiline),if...elseif ladder, Selectcase Looping For, While & Do While Until Debugging Techniques Excel Object Model Cells Property Bulit-in Functions in VBA Using Ranges (Programmatically) Activate & Select Working with Font Properties Working with color indexs & customized colors Comments : Add, Change, Delete, Count Ranges with cells Single Parameter Reference Offset Property Next & Previous Ranges on Inactive Worksheets Cut & Paste : to same sheet, other sheet & other workbook Copy &Paste Paste Special (Operation, Transpose, Skip Blanks, Type etc,) Resize Range Property of a Range Merge & Unmerge Union & Intesect Current Region Property End Property Calling Worksheet Functions Using Formula Empty Cells Special Cells Last Cell Comments Blanks Conditional Formats Validations Constants (Text values, Numbers, Dates) Visible Cells Rows & Cloumns Properties Insert/Delete rows/columns conditionally Sort (numbers/ numbers stored as text) AutoFilter Advanced Filter Conditional Formatting Arrays : Single, Multi, Dynamic, Variant Working with object variables Working with File System Objects Interacting with Drives Working with Folders & Files Create, Copy & Delete Create & Open text files Write into text files Import data from text files FileDialog FileDialog Filters (Add & Clear) FileDialog Selected Items Working with UsedRange Comparing Worksheets Consolidating Sheets & Workbooks User-Defined Functions & Procedures Creating UDFs What UDFs Cannot Do Calling Procedures Parentheses and Argument Lists Using Names Naming Ranges Working with Names Collection Storing values in Names Hiding Names Searching for a Name Searching for the Name of a Range Getting the Range of a Name Pagesetup & Print Options PrintArea, Margins, FitTo, PrintTitles, Preview, Print etc. The Application Object DisplayAlerts ScreenUpdating InputBox StatusBar SendKeys OnTime OnKey Linking with Scheduled Tasks Auto Open Auto Close Workbooks List of open workbooks Open, Create, Save & Delete Workbooks Overwriting an existing workbook Password & WriteReserve Worksheets List of sheets in a workbook Add, Delete, Hide & Very Hide Copy & Move Grouping (Array & Across) Protect & Unprotect The Window Object Pivottable PivotCache PivotFields Pivot From External Data UserForms Creating Userforms Call Userforms From Procedures Call Procedures From User Forms Label TextBox ListBox ComboBox OptionButton CheckBox Frame ToggleButton Multipage ScrollBar SpinButton RefEdit Calendar Workbook Events Open, Close, Save etc Worksheet Events Selection_change, Change Before_Double_Click etc Automation through other applications Late Binding Early Binding Creating a WORD DOCUMENT, writting & Saving Creating a PRESENTATION Sending a graph fromExcel & Saving A Function to send mails through OUTLOOK Working with Windows API An Overview of ODBC Connections, MS-Query An Overview of ADO The Connections Object The Recordset Object Select, Insert, Update, Delete From : Access & Sql Server MIS and Reporting Overview of MIS and Reporting Report Types Preparing Real Time Reports Why Dashboards required in Operations? Creating Dashboards Creating Data Entry Forms Using UserForms Some Useful Content for Students Excel Formulas File with Real Time Examples Excel Short Cuts Interview Tips Top Interview Q&A Sample Resume's
Who is already working with Excel.
No prior programming knowledge is required.
Single Note book and Pen
Excel Formulas examples Short Cut Keys Overview on MIS and Reporting Top interview Q & A's Sample Resumes
Recommendations & reviews from previous Customers:
Not decided yet.
7 years of Experince in VBA Development & Data Analysis
Students Interested 4