ADVANCE EXCEL TRAINING

Course Objective

To empower you with ultimate Excel Skills that are required to transform you into an Excel Guru

COURSE FEATURES

Comprehensive Course Coverage
Certified Expert Trainers
30 days access to our 650+ video lessons on Excel - View Demo
Microsoft Certification (Optional)
Excel Tips, Tricks and Best Practices
30 days Post Training Support (E-mail)

Advanced Excel Training Service focuses upon the basic to advance excel training and also facilitates the candidate to understand the application of excel in their domain area.

It is drilled down to 3 levels (Basic, Intermediate and Advanced)

BASIC EXCEL TRAINING (Level 1):

Our "hands-on" basic Excel training teaches you not only basics of Microsoft Excel but also the application of it to your everyday problems. We evaluate candidate's knowledge level, their problems and adjust our training to their specific needs.

INTERMEDIATE EXCEL TRAINING (Level 2):

Our "hands-on" intermediate Excel training focuses on useful formula design for data processing, using Excel's built-in features like Data Validation, VLookup, Hlookup, Sumif, Countif, Name ranges, Match, Index etc. It also guides you on data presentation using Conditional formatting, Excel-charts etc. We teach you how to develop analysis and data processing problems on the worksheet then how to determine the proper Excel tools to create a unique solution.

ADVANCED EXCEL TRAINING (Level 3):

Our "hands-on" advanced Excel training focuses on creating sophisticated Excel solutions using advanced formulas, dashboards, pivot tables, pivot charts, goal seek. We also teach you how to develop these advanced solutions on the worksheet and to assemble the proper Excel tools in ways you have never thought of before.

Course Content

Excel Introduction : Duration 5 hours

Excel Overview

• A overview of the screen, navigation and basic spreadsheet concepts
• Understanding workbooks, worksheets, rows, columns, cells
• Various selection techniques

Entering Data

• Entering, Editing and Deleting Text, Numbers, Dates
• Using Auto Lists
• Moving and Copying data
• Inserting, Deleting and Hiding Rows & Columns
• Inserting, Deleting, Moving and Copying Sheets
• Using navigation techniques

Creating and Editing Formulae

• Concept of Formulae
• Creating Formulae, Editing Formulae
• Bodmas : Mathematical Order
• Copying Formulae
• Using Functions - Sum, Average, Max,Min, Count, Counta
• Applying Absolute (Fixed) Referencing

Formatting and Proofing

• Formatting Cells with Number formats, Font formats, Alignment, Borders, etc
• Basic conditional formatting
• Copying and Clearing Formats
• Working with Styles
• Spell Check, Find & Replace and AutoCorrect

Excel Intermediate Training : Duration 5 hours

Range Names

• Concept and Purpose
• Naming individual or range cells
• Deleting and amending named ranges
• Using named cells/ranges in formulae

Conditional Functions & Formats and Date Calculations

• Benefits and purpose
• If Statements , Nested If
• And, Or, Not
• Combining If, And, Or, Not
• Sumif , Countif
• Conditional Formatting
• Entering Dates and Times
• Different date/time formats
• How dates are stored
• Calculating working days
• Using the DAY(),MONTH(),YEAR() functions

Formulae Auditing

• Formula Auditing Tools
• Revealing Formulae
• Tracing Precedents/Dependents
• Goto Special

Worksheet Management & Linking

• Linking sheets in the same file
• Linking different Excel files
• Using Edit, Links
• Viewing different files at once
• Saving a workspace
• Viewing different sheets at once
• Window Split
• Data consolidation

Basic List Management

• Sorting Data
• Adding Subtotals
• Autofilter
• Freeze Panes
• Group and Outline
• Data Form

Excel Charts / Graphs

• Using the Chart Wizard
• Editing and Formatting charts
• Saving custom chart types
• Setting a default chart type

Excel Advanced Training : Duration 5 hours

Lookup & Information Functions

• Vertical Lookup (Vlookup)
• Horizontal Lookup (Hlookup)
• Match and Index
• IsText, IsValue, IsDate , IsNull , IsErr, Is Error, IsNa

Advanced List Management

• Advanced Filters
• Using List Features
• Dynamic Lists

Pivot Tables

• Using the Pivot Table Wizard
• Changing the pivot table layout
• Formatting
• Grouping items
• Inserting calculated fields
• Pivot Table Options
• Display and hide data in fields
• Lay out reports directly on worksheet
• Pivot Chart

What If Analysis

• Scenarios
• Goal Seek
• Solver

Protecting & Sharing Files

• Sharing a file
• Tracking changes
• Accepting or rejecting changes
• Applying Data validation rules
• Inserting comments

Introduction to Macros

• Purpose of Macros
• Recording macros
• Where to save macros
• Running macros:
• Custom buttons, menu items, keyboard shortcuts

Pricing

Online Instructor Led Training on Excel - How it works ?

You can listen to our instructor, interact with him on a one-to-one basis, access his computer screen from your desktop, make changes on his excel sheet, and get your doubts clarified instantly.

Level 1- US$ 75
Level 2 - US$ 125
Level 3 - US$ 150
Complete Excel - US$ 250

Group Training

Encouraging the live interactions with the trainer as well as the understanding of Excel applications in various domains, Group Training on Advance Excel is scheduled on Weekends (Saturday & Sunday) at our premises.

Batch Size:12

Please call +91 91766 33246 / 91766 33247 for further details.

Individual Training

If you need self spaced training, Excelgoodies provides you with an option of Inividual Training which can be scheduled on any of the weekdays (Monday - Friday) at our premises.

Please Call +91766 33246 for further details.

For Corporate

We offer private hands-on training courses that can be held at your company's site. Our Onsite Corporate Training Packages go beyond the standard excel training and can be tailored according to the needs of the organisation and knowledge level of the employees.

Minimum Batch Size : 10

Click Here to request for quote

For Colleges and Universities

Our Services are now available on demand at Colleges and Universities

Minimum Batch Size : 25

Click Here to request for quote

System Requirements

Windows OS
Internet Speed of 512 kbps or higher
Internet Explorer
Headsets With Mic
JavaScript Enabled

Other Excel Courses

Excel Certifications Provided

Online Excel Help

Testimonials

FAQs