Certificate in Advance Excel [CAE]
Original price was: ₹7,500.00.₹5,000.00Current price is: ₹5,000.00.
| Course Duration | 3 Months |
| Days in a week | 2 Days |
| Time Duration Per Class | 1.5 hrs per Class |
| Available Class Time | Morning: 7:30 AM to Night: 9:00 PM (in Between) |
| Centre Operation Class Days | Monday to Sunday (Everyday) |
| Mode of Class | Offline [Classroom] |
| Certification by | ALL INDIA INFORMATION TECHNOLOGY ASSOCIATION [AIITA] |
| Certification Body | An Autonomous Body Reg. Under Govt. of India |
| Mode of Payment | One Time / Installments (EMI) |
Syllabus of Microsoft Advanced Excel Course in Kolkata
Module 1: Overview of the Basics of Excel
- Customizing common options in Excel
- Absolute and relative cells
- Protecting and un-protecting worksheets and cells
- Writing conditional expressions (using IF)
- Using logical functions (AND, OR, NOT)
- Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX)
- VlookUP with Exact Match, Approximate Match
- Nested VlookUP with Exact Match
- VlookUP with Tables, Dynamic Ranges
- Nested VlookUP with Exact Match
- Using VLookUP to consolidate Data from Multiple Sheets
- Specifying a valid range of values for a cell
- Specifying a list of valid values for a cell
- Specifying custom validations based on formula for a cell
- Designing the structure of a template
- Using templates for standardization of worksheets
- Sorting tables
- Using multiple-level sorting
- Using custom sorting
- Filtering data for selected view (AutoFilter)
- Using advanced filter options
- Creating subtotals
- Multiple-level subtotals
- Creating Pivot tables
- Formatting and customizing Pivot tables
- Using advanced options of Pivot tables
- Pivot charts
- Consolidating data from multiple sheets and files using Pivot tables
- Using external data sources
- Using data consolidation feature to consolidate data
- Show Value As ( % of Row, % of Column, Running Total, Compare with Specific Field)
- Viewing Subtotal under Pivot
- Creating Slicers ( Version 2010 & Above)
- Date and time functions
- Text functions
- Database functions
- Power Functions (CountIf, CountIFS, SumIF, SumIfS)
- Using auto formatting option for worksheets
- Using conditional formatting option for rows, columns and cells
- Goal Seek
- Data Tables
- Scenario Manager
- Using Charts
- Formatting Charts
- Using 3D Graphs
- Using Bar and Line Chart together
- Using Secondary Axis in Graphs
- Sharing Charts with PowerPoint / MS Word, Dynamically
- (Data Modified in Excel, Chart would automatically get updated)
- Sparklines, Inline Charts, data Charts
- Overview of all the new features
Microsoft Excel is a spreadsheet program with many other relevant tools. Most businesses and organizations use Excel for its useful tools and features. Learning advanced Excel would also help you become an expert in Visual Basic for applications and macros and develop customized programs to perform Excel operations quickly. Thus AIITA can add some amazing benefits to your career by providing Microsoft Advance Excel training programs and much more. Enroll Now with us AIITA Microsoft Advanced Excel Classroom Training Course.
Minimum Eligibility Required?
10+ Standards
Who is This Course Suitable For?
Freshers, Working Professionals, School and College Students, House Wife, Working Women
Job Opportunities
Computer Operator, Data Entry Executive, Front Office Executive, Back-office Staff, Telecaller, Sales Staff,
Top Skills You will Learn with AIITA’s Computer Basic Course
Excel, Word, Powerpoint, Typing, Internet
Admission Process
Please find below the detailed steps to be followed as a part of the admission process.
Step 1
Fill the Application Form
Apply by filling a simple application form.
Step 2
Get Shortlisted
Candidates will be shortlisted based on application submitted
Step 3
Pay & Start Learning
Secure your seat by paying the admission fee.
Top 3 reasons why you should choose to do a Computer Basic Course from AIITA?
Best-in-Class: AIITA’s Computer basic course is rated as one of the best certification courses for IT Training in the country. This course is designed to equip you with the skills and knowledge needed to excel in this fast-paced and ever-evolving field. Whether you’re a recent graduate, or an experienced professional looking to upskill, this program caters to learners of all levels.
Legacy & Reputation: A Trusted Name in Computer Education – AIITA is known for grooming IT professionals through a world-class learning experience. AIITA’s legacy in Training, Placement and Support ensures that you receive the most up-to-date and industry-relevant knowledge, delivered by experts with years of experience.
Industry-Relevant Content: The course content is thoughtfully curated to cover every essential aspect of IT Training ensuring you stay ahead of the competition.
Related products
Certificate Course
Financial Accounting Courses
Financial Accounting Courses
Certificate Course
Financial Accounting Courses
Certificate Course