Softlogic Systems - Placement and Training Institute in Chennai

Easy way to IT Job

Advanced Excel Course Syllabus

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.

Request to Download Syllabus
DURATION
Real-Time Location Services
2 Months
JOB READY
Syllabus
CERTIFIED
Courses

Let's take the first step to becoming an expert in Advanced Excel

Click Here to Get Started

100% Placement
Assurance

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

Advanced Excel Course Syllabus

Download Syllabus
Excel 2007 & 2010, 2013, 2016 Quick Overview
  • Difference between Excel 2003, 2007 and 2010,2013,2016
  • 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 – Advance
  • If 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

Want more details about the Advanced Excel Course Syllabus?

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.

Course Schedules

PDF Course Syllabus

Course Fees

CRM System Testing

or any other questions...

Breakdown of Advanced Excel Course Fee and Batches

Hands On Training
3-5 Real Time Projects
60-100 Practical Assignments
3+ Assessments / Mock Interviews
January 2025
Week days
(Mon-Fri)
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)

Course Fee
January 2025
Week ends
(Sat-Sun)
Online/Offline

4 Hours Real Time Interactive Technical Training

(Suitable for working IT Professionals)

Course Fee

Save up to 20% in your Course Fee on our Job Seeker Course Series

Learn More

The SLA way to Become
a Advanced Excel Expert

Enrollment

Technology Training

Coding Practices
Realtime Projects

Placement Training

Aptitude Training
Interview Skills
CRM System Testing

Panel Mock
Interview

Unlimited
Interviews

Interview
Feedback

100%
IT Career

Google Reviews

Rating
4.8
1,053 Google reviews

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…
Click here for Full Review

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…
Click here for Full Review

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…
Click here for Full Review

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,…
Click here for Full Review

Discover What Our Students Have To Say

See More Reviews

Related Blogs for
The Advanced Excel Course

Our counselors will share the Syllabus PDF with you via Email / Whatsapp

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.