Advanced Excel

Course Description

Best ADVANCED EXCEL Training at Elan Techlab

We Offer Best ADVANCED EXCEL Training in Bangalore and are taught by ADVANCED EXCEL Certified Professionals. Our ADVANCED EXCEL Training focused on Job Oriented with full of Practical Sessions rather than boring theory. Our ADVANCED EXCEL Syllabus designed by ADVANCED EXCEL experts from Elan Techlab which will be Suitable for Students, freshers, and Working Professionals. Get Hands-on training on Basic & Advance level Concepts .

Enroll and get started your dream ADVANCED EXCEL Developer Career in the IT industry.

About Elan Techlab

Elan Techlab Bangalore, recognized among the top ten ADVANCED EXCEL training institute in Bangalore, has training module for beginners, intermediates, and experts. The best ADVANCED EXCEL training institute in Bangalore offers best training environment, veteran ADVANCED EXCEL trainers, and flexible training schedules for entire modules. Also, the best training institute for ADVANCED EXCEL training in Bangalore asks for a value to money fee from the students. The pocket-friendly ADVANCED EXCEL course fee structure can be afford by students coming from all walks of life.

Description

MODULE 1:  Grouping & Outlining and Subtotals

Learning outcomes: Useful Excel functions to summarise a spreadsheet making the data easier to identify and explain.

Topics covered:

• Outlining and Grouping Data
• Using the Subtotals Tool

MODULE 2:  What-If Analysis

Learning outcomes:  Tools designed to help with forecasting and finding solutions to  complicated problems involving your spreadsheet’s data and formulas.

Topics covered:

• Exploring Scenarios
• Goal Seek and Data Tables
• Using Solver

MODULE 3:  PivotTables

Learning outcomes:  Creating Pivot Tables in order to display and summarise large quantities of data effectively.

Topics covered:

• Getting Started with PivotTables
• Displaying Data in a PivotTable
• Formatting a PivotTable
• Using the Classic PivotTable Layout
• Slicers

MODULE 4:  Charting Pivoted Data

Learning outcomes: Introducing Pivot Charts, adding specialist pivot charts to the already excellent Pivot Table feature.

Topics covered:

• Getting Started with PivotCharts
• Using the PivotChart Tools Tabs
• Formatting a PivotChart

MODULE 5:  Advanced Excel Tasks

Learning outcomes:  Here we will look at sharing Excel files along with adding hyperlinks and Custom AutoFill Lists.

Topics covered:

• Excel and Hyperlinks
• Using Custom AutoFill Lists
• Sharing Workbooks

MODULE 6:  Creating HLOOKUP and VLOOKUP Functions

Learning outcomes:  Exploring the different Lookup functions, and how to add further functionality to a spreadsheet to reference particular data quickly and  effectively.

Topics covered:

• Using the VLOOKUP Function
• Using the LOOKUP Function

MODULE 7:  Introduction to Macros in Excel

Learning outcomes:  Explore how to create your own Macros and introducing Visual Basic  for Applications, the application Macros are created in.

Topics covered:

• Recording and Playing Macros
• Copying and Deleting Macros
• Visual Basic and Macros

Who this course is for:

• Users with a good understanding of Microsoft Excel 2007, 2010, 2013 or 2016 who want to expand on their capabilities in a short space of time.