UrbanPro
true

Advanced Excel VBA Course.

LIVE
Ongoing

Course offered by Advanced Excel

0 review
Advanced Excel is individual proprietorship establishment which is originated by Pankaj Kumar Gupta (Excel and VBA Professionalist).We are the leading professional Institute with the specialization in Advanced Excel and VBA Macros.Our institute portfolio encompasses the Advanced Excel and VBA training for Individual, Group and Corporate Interventions. We are truly devoted to our students to groom their knowledge in Excel and VBA and help them to reach on the top of the ladder.

Topics Covered

Introduction and Basic Brush-up of MS Excel: Start-up with MS Excel, Quick review on MS Excel Customize Ribbon, Quick Access Toolbar, Mini Toolbar. Difference between Excel 2003and 2007and 2010. Saving of Old version MS Excel 1999 and 2003 files to new excel version MS excel 2007 and 2010. Conversion of Excel files to PDF. Introduction of Excel shortcut keys: Chart will be provided by Advanced Excel. Introduction to Excel Worksheet, Row, Column, Cells etc. Use of Basic Operators Like: + – / * ^ %. Introduction to the Data and Data Formats. Copy, Cut, Paste, Hide, Unhide, Link the Data in Rows, Columns and Sheet. Inserting, Deleting, Moving, and linking the data in between the multiple sheets. Introduction to the Paste Special all Option. (Formulas, Values, Formats, Comments, Validation, All using source themes, All except Borders, Column Widths, Formula and Number formats, Values and Number Formats, None, Add, Subtract, Multiply, Divide, Skip Blanks and Transpose) Format Cells, Rows, Columns and Sheets. Protection of Cells, Rows, Columns and Sheets. Printer Properties and Page Setup (Page, Margin, Header/Footer and Sheet) for Printing. Start-up With Formulas: Part-I AND Working With Name Ranges: Text Functions: Concatenate, Dollar, Left, Mid, Right, Lower, Upper, Proper, Replace, Rept, Find, Search, Substitute, Trim, Trunc Date and Time Functions: Date, Datevalue, Day, Day360, Minutes, Hours, Now, Today, Month, Year, Yearfrac, Time, Weekday, Workday, Networkdays. Logical Functions: If, Nested If (For Multiple Conditions), OR, And, Not, True, False. Introduction to Name Manager: Discussion on Name Ranges and Apply the Name Ranges on Cell and the combination of Cells. Use of Name Manager: Creating, Editing, and Deleting of Names. Create Name Ranges Automatically. Start-up With Formulas: Part-II And Use of Tool Find &Select, (Go To Special): Math & Trig Functions: ABS, Aggregate, Power, Product, Rand, Randbetween, Round, Rounddown, Roundup, Subtotal, Sum, Sumif, Sumifs, Sumproduct, Trunc. Use of Sumproduct as lookup and in various activities. Statistical Functions: Average, AverageA, Averageif, Averageifs, Count, CountA, Countblack, Countif, Countifs, MAX, MAXA, MIN, MINA, Small, Large. Informative AND Other Functions: Cell, Info, ISBLANK, ISERROR, ISEVEN, ISODD, DCOUNT, DSUM, DMAX, DMIN, DPRODUCT, Rank, Use of &. Use of Tool Find & Select: Discussion on Excel’s very important tool “Find & Select” (Go To Special) including all options: (Comments, Constants, Formulas, Blanks, Current region, Current array, Objects, Row differences, Column differences, Precedents, Dependents, Last cell, Visible cells only, Conditional formats, Data validation). Start-up With Formulas: Part-III: Lookup Functions: Lookup Functions: Discussion on Lookup Functions, Use of Lookup, Vlookup, Hlookup, Index, Indirect Match, Offset. Vlookup with Match, Vlookup with offset, Vlookup with Indirect, Hlookup with Match, Hlookup with offset, Hlookup with Indirect. Vlookup with If condition. Vlookup and Hlookup with Name Manager. Detail Discussion on use Of Name Manager In Vlookup and Hlookup functions. Creation of Hyperlink. Extraction of Data from Pivot Table by Using function GETPIVOTDATA. Structuring Of The Data & What If Analysis: Use of Sorting to arrange the data in ascending and descending order. Addition and deletion of levels to sort the data on multiple parameters. Use of Filter to extract the unique and desired data. Use of Custom Filter to fulfil the desired conditions. Use of Advance Filter to fulfil the multiple desired conditions. Import the data from the multiple applications to Excel. Use of Text to Columns for Rearrangement of Data. Remove Duplicates from Data. Data of Grouping, Ungrouping and Subtotal. What if Analysis: Detailed Discussion On What if Analysis. Analysis of Data by using Scenario Manager and Data Table and Goad Seek. Conditional Formatting And Working With Charts: Conditional Formatting: Detailed discussion on conditional formatting. Conditional Formatting with multiple cell rules and Top/Bottom Rules. Conditional Formatting with Data Bars. Colour Scales and Icon Sets. Conditional Formatting on Desired Output, Create New rules, Manage the rules. Apply any formula to Conditional formatting. Choose Formatting as Table and different Cell Style. Working With Charts: Detailed discussion on graphically presentation of Data by using Charts. Presentation with different kind to charts like Column Charts, Line Charts, Pie Charts, Bar Charts, Scatter Charts Preparation of Gnatt Chart, Bubble Chart, Speedo Meter Chart. How To Use Switches to Offset function effectively in Charts. Working with 2axis and 3axis charts. Use of Watch Window in Excel. Pivot Table and Pivot Charts with Slicer and Handling of Errors In Excel : Start With Pivot Table, Do the Multiple Field Setting in Pivot Table. Do the Juggling of Data in Pivot Table and Work on layout of Pivot Table. Creating Groups, Insert additional Calculated Field in Pivot Table. Perform the % calculation on the basis of multiple fields. Start-up with Pivot charts. Insert slicer in Pivot Table and Pivot charts. Use of Tool “Error Checking”. Removing Duplicates. Trace Precedents, Trace Dependents. Discussion of Errors and handling of multiple errors like. #DIV/0! , #N/A, # REF, #NAME, #VALUE, # NULL, #NUM and ########Error. What is Circular References error? How to rectify Circular Reference? Start With VBA Macro Programming : Introduction of VBA: Detailed Introduction of VBA Macro Programming. Discussion on need of VBA Macros. Where to apply the VBA Macro. Benefit and limitation of VBA Macro. Type of VBA Macro. Display of Developers Tab and VB Editor. Macro Security. How to record a VBA Macro. Execution of recorded Macro. Editing the recorded Macro. Various Key Board Short Cuts related to VBA Macros. Working on Various Examples of Macro recorder. Introduction to the writing of basic VBA codes. Saving Off Your Macro VBA Macro Programming : Day 2 Defining Variables to Macro. Discussion on different Types of Variables. Introduction of Message Box in Macro. Introduction of Input Box In Macro. Use of decision making statements in Macro by using: If and Else conditions, And /OR conditions. Introduction of the Loops in Macro. Use of Different type of loops like, For & Next LOOP, For & Each Loop, Do & Until LOOP While and While and Wend Loop. Working with Ranges: Selecting, Coping and Pasting the Ranges and extract the data on same Worksheet level. Selecting, Coping and Pasting the Ranges and extract the data on different Worksheet level in the same Workbook. Selecting, Coping and Pasting the Ranges and extract the data on different Workbook Level. VBA Macro Programming : Day 3 User Define Function (UDF): Detailed discussion on User Defined Function: What is User Defined Function, Use of User Defined Function and How to create any Function OR Formula which is not available in Excel and you want it to work for you by the help of Macro. ADD-IN: Discussion on ADD-IN: What is ADD-IN, Use of ADD-IN and How to create ADD-IN. Working With VBA Events: Discussion on VBA Events, What are Events, How and when to use the VBA Events. VBA User Forms: Discussion on VBA User Forms, What are User Forms, Why to create User Forms and How to create User Forms.

Who should attend

Working Professionals, Finance Professionals, MIS, Reporting Profile Holders, Students and others.

Pre-requisites

Classes on Weekends Only.

What you need to bring

Laptops.

Key Takeaways

Student will feel enhancement in their Excel and VBA Knowladge, and they wil learn lot's of new things.

About the Trainer

Avg Rating

0 Reviews

0 Students

1 Courses

Advanced Excel

Microsoft Certified Excel Trainer.

Total 10 Years of Experience in TOP MNC's.
More Then 5 years for Experience as Excel Tutor.

Students also enrolled in these courses

LIVE
10 Hours

Course offered by Sailesh Mutreja

0 review
LIVE
30 Hours

Course offered by Shishir Kumar

0 review
LIVE
10 Hours

Course offered by Bikram Jeet

0 review
LIVE
11 Hours

Course offered by Gagan Jain

0 review

Tutor has not setup batch timings yet. Book a Demo to talk to the Tutor.

Different batches available for this Course

No Reviews yet!

Reply to 's review

Enter your reply*

1500/1500

Please enter your reply

Your reply should contain a minimum of 10 characters

Your reply has been successfully submitted.

Certified

The Certified badge indicates that the Tutor has received good amount of positive feedback from Students.

Different batches available for this Course

tickYou have successfully registered

Advanced Excel VBA Course. by Advanced Excel

Pankaj Kumar Gupta picture
LIVE

Class
starts in

01

Hour

01

Min

01

Sec

Select One

Register Now

Do you want to Register for this Free class?

Yes, Register No, not right now

Tell us a little more about yourself

Advanced Excel VBA Course. by Advanced Excel

Pankaj Kumar Gupta picture
LIVE

Class
starts in

01

Hour

01

Min

01

Sec

Please enter Student name

Please enter your email address.

Please enter phone number.

Verify Your Mobile Number

Please verify your Mobile Number to book this free class.

Update

Please enter 10 digit phone number.

Please enter your phone number.

Please Enter a valid Mobile Number

This number is already in use.

Resend

Please enter OTP.

Or, give a missed call and get your number verified

080-66-0844-42

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more