Advanced Excel

Excel Prodigy
In Chennai

Rs 4,000
You can also call the Study Centre
72991... More
Compare this course with other similar courses
See all

Important information

  • Training
  • Intermediate
  • Inhouse
  • Chennai
  • 16 hours of class
  • Duration:
    2 Days
Description

The course is for the professionals using excel in their workplace and keen to learn more advanced concepts, functions and features in excel to increase the productivity in the workplace. Excel basic, intermediate and advanced Level. Basic knowledge in excel is enough. Completely practice based training. Training takeaways : Extensive skills in excel reporting, certificate, eManual.

Important information
Venues

Where and when

Starts Location
On request
Chennai
14/108A, Poothapedu Main Road, Ramapuram (1.5kms from DLF IT Park - towards Porur), 600089, Tamil Nadu, India
See map

What you'll learn on the course

Advanced Excel
Intermediate Excel
Basic excel

Teachers and trainers (1)

Mohammed Yousuf
Mohammed Yousuf
Microsoft Certified Trainer

Corporate Microsoft Certified Trainer, 10+ years of real-time excel teaching experience, conducted 200+ Corporate Training, trained more than 10,000 professionals as excel experts, Conducting training in abroad(Muscat, UAE)also

Course programme

Excel 2007 & 2010 Quick Overview
Difference between Excel 2003, 2007 and 2010, Use of Excel, its boundaries & features

Basic Formula
Formulae that Add/Subtract/Multiply/Divide • BODMAS/Formula Error Checking • The Sum Function

Absolute Referencing
Problems with Absolute/Relative Cell Referencing, Creating Absolute/Mixed References

LOOKUP Functions
The VLOOKUP/HLOOKUP Functions

PivotTables
Creating, Formatting Simple PivotTables • Page Field in a PivotTable • Formatting a PivotTable • Creating/Modifying a PivotChart

Logical Functions
IFs and Nested IF Functions • Using AND/OR/NOT Functions

Statistical Functions Using The SUMIF/COUNTIF Functions • Using The AVERAGE/COUNT/LARGER/SMALLER Functions

Pivot Tables – Advance
Adding new calculated Fields / Items • Changing the Summary Function • Consolidate Pivot table

LOOKUP Functions – Advance
MATCH with VLOOKUP Functions • INDEX & MATCH Functions • OFFSET/ INDIRECT functions

Logical Functions - AdvanceIf Loop and Nested IF Loop Functions • Using IF/ISERROR Functions

Chart Data Techniques
The Chart Wizard • Chart Types • Adding Title/Legends/Lables • Printing Charts • Adding Data to a Chart • Formatting/Renaming/Deleting Data Series • Changing the Order of Data Series

Date/Time Functions
Using The Today • Now & Date Functions • Using The Datedif/ Networkdays/ Eomonth Functions • Using The Weeknum Functions • Using The Edate/ Networkdays.Intl/ Weekdays.Intl Functions.

Text Functions Using
The Mid/ Search/ Left/ Right Functions • Using The Trim/ Clean/ Upper/ Lower Functions • Using The Subsitute/ Text Functions • Using The Trim/ Clean/ Proper/ Dollar Function

Validations
Input Messages / Error Alerts/ Drop-Down Lists • Conditional Formatting

Advanced Filters
Extracting Records with Advanced Filter • Using Formulas In Criteria

Advanced Sorting
Sorting by Top to Bottom / Left to Right • Creating / Deleting Custom List • Sort by using Custom List

Hyper / Data Linking
Hyper linking data, within sheet / workbook • Linking & Updating links between workbooks & application

Math & Trigonometry Functions
Using SUMPRODUCT Functions • Using FLOOR/ CEILING/ MROUND/ MOD/ QUOTIENT Functions

Summarizing Data
Creating Subtotals/Nested Subtotals • SUBTOTALS Formula

Outlining
Creating/Working with an Automatic/Manual Outline • Grouping / Ungrouping

Consolidation
Consolidating Data with Identical/Different Layout

Using Auditing Tools
Displaying/Removing Dependent & Precedent Arrows • Evaluate Formula - Step IN/ Step Out

Custom Views
Creating Custom Views • Displaying Custom Views • Deleting Custom Views

Sharing and Protecting Workbooks
Sharing Workbooks & Tracking Changes • Protecting sheets / workbooks / Files

Importing & Exporting Data
Importing Data from Database/ Text Files/ Web • Exporting Data • Changing External Data Range

Additional information

Excel Prodigy is a premier corporate training company in India craving to build expertise through our training solutions. We work with businesses and individuals who need effective Microsoft Office training at unique & affordable pricing as per your budget. We provide a tailored training session for corporate clients as per their need.

Compare this course with other similar courses
See all