4.80
(1425)

Our Advanced Excel Course Syllabus is designed to help you improve your Excel skills. You’ll learn advanced functions, data analysis, macros for automation, and creating interactive dashboards. The course will teach you how to manage and analyze large datasets, perform complex calculations, and visualize data effectively. With practical exercises and real-world examples, you’ll become proficient in using Excel for advanced data analysis and reporting. So, make use of this opportunity by enrolling in our Advanced Excel Training Institute in Chennai.

### What Learning at SLA gives you

• Technology Training
• Aptitude Training
• Learn to Code (Codeathon)
• Real Time Projects
• Learn to Crack Interviews
• Panel Mock Interview
• Unlimited Interviews
• Life Long Placement Support

## Breakdown of Advanced Excel Course Fee and Batches

##### Online/Offline

2 Hours Real Time Interactive Technical Training

1 Hour Aptitude

1 Hour Communication & Soft Skills

(Suitable for Fresh Jobseekers / Non IT to IT transition)

##### Online/Offline

4 Hours Real Time Interactive Technical Training

(Suitable for working IT Professionals)

## Syllabus for The Advanced Excel Course

### 1

• Difference between Excel 2003, 2007 and 2010,2013,2016
• Use of Excel, its boundaries & features

### 2

• BODMAS/Formula Error Checking
• The Sum Function

### 3

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

### 4

• The VLOOKUP/HLOOKUP Functions

### 5

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

### 6

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

### 7

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

### 8

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

### 9

• MATCH with VLOOKUP Functions
• INDEX & MATCH Functions
• OFFSET/ INDIRECT functions

### 10

• If Loop and Nested IF Loop Functions
• Using IF/ISERROR Functions

### 11

• 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

### 12

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

### 13

• 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

### 14

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

### 15

• Extracting Records with Advanced Filter
• Using Formulas In Criteria

### 16

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

### 17

• Hyper linking data, within sheet / workbook

### 18

• Using SUMPRODUCT Functions
• Using FLOOR/ CEILING/ MROUND/ MOD/ QUOTIENT Functions

### 19

• Creating Subtotals/Nested Subtotals
• SUBTOTALS Formula

### 20

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

Fill out the form, and our counsellors will get in touch with you at your preferred time. You can have all your queries answered. Once you decide that SLA is the perfect fit for your training needs, our counselors will guide you through the process every step of the way.

## The SLA way to Becomea Advanced Excel Expert

### Technology Training

Coding Practices
Realtime Projects

### Placement Training

Aptitude Training
Interview Skills

### 100%IT Career

Rating
4.8

#### Venkatesh

I joined SLA for python course one year back, and i got selected as software developer with decent salary, with after one year of experience,…

#### Ganesan Vasu

I'm from non-IT background, but always wanted to be in IT, SLA make my dream true and I don't know how many will see this…

#### Aswin Pandiyan

It's my genuine review i searched many institutes to do software testing course and finally landed in SLA. My counselor Bala backed me and my…

#### Hari Krishnan

I am from Mechanical background. I have no command over programming before joining SLA Such a wonderful place to learn and achieve your goals.Having wonderful…

## Related Blogs for The Advanced Excel Course

### Just a minute!

If you have any questions that you did not find answers for, our counsellors are here to answer them. You can get all your queries answered before deciding to join SLA and move your career forward.

### We are excited to get started with you

Give us your information and we will arange for a free call (at your convenience) with one of our counsellors. You can get all your queries answered before deciding to join SLA and move your career forward.