Advanced Excel Training
550+
10+
60 HrsLearn Advanced excel training in Chennai at Credo Systemz to understand the powerful spreadsheet application which is developed by Microsoft.
Our Advanced Excel training is framed to cover all the advanced features of excel application which help to enhance and improve your analyzing and reporting skills.
Our Advanced Excel training topics suits for the candidate who has a basic knowledge of Microsoft Excel.
Key Features
Training from
Industrial Experts
24 x 7
Expert Support
Hands on
Practicals/ Projects
Certification
of Completion
100% Placement
Assistance
Free
Live Demo
EMPTY
Course Features
- Duration60 hours
- Skill levelAll level
- Batch Strength15
- AssessmentsYes
- Mock InterviewsYes
- Resume BuildingYes
- PlacementsYes
- Flexible TimingYes
- Fee InstallmentsYes
- LanguageTamil/English
Section 1: Formatting
- Freeze Titles
- Conditional Formatting
- Autoformat
- Paste Special
Section 2: Protection
- Protection
- Worksheet And Cell Protection
- Hiding Rows And Columns
- Workbook Protection
- Hiding Worksheets & Workbooks
Section 3: Cell Comments
- Cell Comments
- Display Comments
- Create, Edit & Delete Comments
Section 4: Names
- Names
- Using Names In Formulas
- Using To With Names
Section 5: Templates
- Creating A Template
- Using A Template
- Editing A Template
- Deleting A Template
Section 6: Formulas
- Display Formulas
- Formulas That Produce Errors
- Custom Number Formats
Section 7: Scenarios
- Creating Scenarios
- Using And Editing Scenarios
- Scenario Summary Report
Section 8: Linking
- Linking
- Creating Links
- Linking Between Workbooks
- Linking To A Word Document
Impressed with our Course Content?
Attend a Free Demo Session to Experience our Quality!
Get Free SessionSection 9: Sorting
- Sorting
- Multiple Column Sorts
- Custom Sorts
Section 10: Lists
- Lists
- Creating A List
- Filtering Lists
- Autofilter
- Custom Autofilter
- Advanced Filtering
- Extracting Filtered Data
- Adding Subtotals
Section 11: Pivot Tables
- Pivot Tables
- Grouping Data In Pivot Tables
Section 12: Functions
- Functions
- Logical Functions
- Date And Time Functions
- Lookup Functions
- Maths And Statistical Functions
- Text Functions
- Financial Functions
- Database Functions
- Nested Functions
Section 13: Charts
- Formatting Chartsmodifying Charts
- Insert Image In 2d Chart
Section 14: Data Tables
- One Input Data Table
- Two Input Data Table
Section 15: Macros
- Macros
- Recording Macro
- Running A Macro
- Assigning A Macro To A Toolbar Button
Section 16: Auditing
- Auditing
- Trace Precedents
- Trace Dependents
- Tracing Errors
Section 17: Importing Data
- Import Delimited Text
You will be going through detailed 2 to 3 months of Excel Hands-on training
- Detailed instructor led sessions to help you become a proficient Expert in Excel.
- Build a Excel professional portfolio by working on hands on assignments and projects.
- Personalised mentorship from professionals working in leading companies.
- Lifetime access to downloadable Excel course materials, interview questions and project resources.
Credo Systemz - Velachery, Chennai
Call Us +91 9884412301
Credo Systemz - OMR, Chennai
Call Us +91 9600112302
Check here for candidates feedback on Excel Training through
