Advanced Excel Course Syllabus
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
Syllabus for The Advanced Excel Course
Download Syllabus
Excel 2007 & 2010, 2013, 2016 Quick Overview
1
- Difference between Excel 2003, 2007 and 2010,2013,2016
- Use of Excel, its boundaries & features
Basic Formula
2
- Formulae that Add/Subtract/Multiply/Divide
- BODMAS/Formula Error Checking
- The Sum Function
Absolute Referencing
3
- Problems with Absolute/Relative Cell Referencing
- Creating Absolute/Mixed References
LOOKUP Functions
4
- The VLOOKUP/HLOOKUP Functions
PivotTables
5
- Creating, Formatting Simple PivotTables
- Page Field in a PivotTable
- Formatting a PivotTable
- Creating/Modifying a PivotChart
Logical Functions
6
- IFs and Nested IF Functions
- Using AND/OR/NOT Functions
Statistical Functions
7
- Using The SUMIF/COUNTIF Functions
- Using The AVERAGE/COUNT/LARGER/SMALLER Functions
Pivot Tables – Advance
8
- Adding new calculated Fields / Items
- Changing the Summary Function
- Consolidate Pivot table
LOOKUP Functions – Advance
9
- MATCH with VLOOKUP Functions
- INDEX & MATCH Functions
- OFFSET/ INDIRECT functions
Logical Functions – Advance
10
- If Loop and Nested IF Loop Functions
- Using IF/ISERROR Functions
Chart Data Techniques
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
Date/Time Functions
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
Text Functions Using
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
Validations
14
- Input Messages / Error Alerts/ Drop-Down Lists
- Conditional Formatting
Advanced Filters
15
- Extracting Records with Advanced Filter
- Using Formulas In Criteria
Advanced Sorting
16
- Sorting by Top to Bottom / Left to Right
- Creating / Deleting Custom List
- Sort by using Custom List
Hyper / Data Linking
17
- Hyper linking data, within sheet / workbook
- Linking & Updating links between workbooks & application
Math & Trigonometry Functions
18
- Using SUMPRODUCT Functions
- Using FLOOR/ CEILING/ MROUND/ MOD/ QUOTIENT Functions
Summarizing Data
19
- Creating Subtotals/Nested Subtotals
- SUBTOTALS Formula
Outlining
20
- Creating/Working with an Automatic/Manual Outline
- Grouping / Ungrouping
Want more details about the Advanced Excel 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
or any other questions...
The SLA way to Become
a Advanced Excel Expert
Enrollment
Technology Training
Coding Practices
Realtime Projects
Realtime Projects
Placement Training
Aptitude Training
Interview Skills
Interview Skills
Panel Mock
Interview
Unlimited
Interviews
Interview
Feedback
100%
IT Career
Google Reviews
Rating
4.8
1,053 Google reviews