Advanced Excel
Make spreadsheets work harder with formulas and clear reports.
learningStructured
lessonsCareer
guidance
Duration3 months
Content3 core topics
ModeIn-centre
Skills you can put to work.
Explore the core areas of Excel.
- Formulas
- Reporting
- Data management
Your course. Every step.
Build your skills one topic at a time, with room to practise.
- Introduction to Excel interface and tools
- Basic spreadsheet operations (data entry, cell formatting, etc.)
- Basic formulas and functions (SUM, AVERAGE, COUNT)
- Data validation and conditional formatting
- Sorting and filtering data
- Using text functions (LEFT, RIGHT, MID, CONCATENATE, etc.)
- Lookup functions (VLOOKUP, HLOOKUP, XLOOKUP)
- Logical functions (IF, AND, OR, NOT)
- Nested functions and formula auditing
- Working with dates and times in Excel
- Date and time functions (DATE, TIME, DATEDIF, NETWORKDAYS, etc.)
- Creating dynamic date and time formulas
- Creating and managing PivotTables
- Analyzing data using PivotTables
- Creating and customizing PivotCharts
- Using data analysis tools (Goal Seek, Solver, Data Tables)
- Introduction to Power Query for data transformation
- Cleaning and preparing data with Power Query
- Using statistical functions (STDEV, VAR, CORREL, etc.)
- Scenario Manager and What-If Analysis
- Introduction to Power Pivot and Data Model
- Creating and customizing various chart types (line, bar, pie, scatter, etc.)
- Using sparklines for data visualization
- Advanced chart techniques (combo charts, secondary axes)
- Recording and running macros
- Introduction to VBA (Visual Basic for Applications)
- Writing simple VBA scripts to automate tasks
- Working with large datasets
- Advanced sorting and filtering techniques
- Using Excel Tables and structured references
- Sharing and collaborating on Excel workbooks
- Protecting and securing Excel files
- Managing multiple worksheets and workbooks
- Review of key concepts and skills
- Hands-on final project (complex data analysis and reporting)
- Preparation for final assessment and certification exam
Source-based curriculumAdapted from the course-page syllabus supplied by CT Training Centre. Confirm the teaching schedule for your batch.
A person to learn with.
Get to know the trainer for your batch.
Meet your course trainer
Your instructor is assigned by batch. Contact the centre to meet your trainer and discuss how the course is taught.
A skill for your
next step.
Students
Add practical digital skills to your studies.
Job seekers
Explore skills that connect with your career plans.
Working professionals
Build on the tools you use in everyday work.
New to this subject? Ask us about the right starting level and eligibility for Excel.
Check course requirementsA little clarity before you start.
The published duration is 3 months. Confirm the current schedule for your batch with the centre.
Fees and eligibility depend on the course. Ask the centre for current details before enrolling.
Confirm the teaching language for your preferred batch with the centre.
Ask the centre about the certificate, issuing body and completion requirements for this course.
This page is for classroom learning at CT Training Centre in Pakur. Contact the centre about any other available formats.
No. Career support includes resume guidance and interview preparation, but does not guarantee employment.
Keep your curiosity going.
More skills to explore at CT.
