Certified Microsoft Excel Specialist (Advanced)

Certification Name:

Certified Microsoft Excel Specialist

Pre-requisite: No

Duration: 6 hours

Introduction
  • 1. Introduction to Microsoft Excel
  • 2. Basic of Excel
  • 3. Component of Excel Screen
  • 4. Concept of Row & Column
  • 5. Concept of Excel Cell
  • 6. Concept of Workbook & Worksheet
Working with Excel
  • 1. Inserting, Deleting, Hiding Row & Columnl
  • 2. Cell addressing
  • 3. Inserting, Renaming, Deleting, Moving, Hiding, Coloring worksheets
  • 4. Workbook Save - Save as & Save
Basic Formatting
  • 1. Data entry in Excel
  • 2. Different type of formatting tools
  • 3. Text Alignment
  • 4. Number Alignment
  • 5. Working with Borders
  • 6. Working with Font
  • 7. Working with Color
  • 8. Working with Text Style
  • 9. Adjusting Row and Column hight & width
  • 10. Merge and Center
  • 11. Format Painter
Basic Formula
  • 1. Concept of Formula
  • 2. Basic of Formula
  • 3. Formula Symbols
Data Sorting
  • 1. Basic Sorting, Single Sorting
  • 2. Custom Sorting, Double Sorting
  • 3. Multiple Sorting

Pre-requisite: Knowledge of Basic Excel

Duration: 6 hours

Advanced Formatting
  • 1. Conditional Formatting
  • 2. Advanced Conditional Formatting
Excel Protection
  • 1. Protecting Excel file with Password
  • 2. Protecting Specific Cell
  • 3. Data Protection Excel Data
Data Filtering
  • 1. Custom Filtering
  • 2. Advanced Filtering
  • 3. Text Filtering, Number Filtering, Logical Filtering
Data Validation & Data Restoration
  • 1. Restricted Data Entry
  • 2. Data Validation
  • 3. Creation of List box while data entry
  • 4. Input Message
  • 5. Error Message
  • 6. Text to Column
Function and Formula
  • 1. Difference between Function and Formula
  • 2. Different Type of Functions
Numerical Functions
  • 1. Sum(), Product(), MOD(), Round(), Roundup(), Rounddown(), Average(), Min(), Max()
Count Functions
  • 1. Count(), Counta(), Countblank()
Date & Time Functions
  • 1. Date Format
  • 2. Now(), days360()
  • 3. Day(), Month(), Year()
  • 4. Hour(), Minutes(), Second()
  • 5. Working with Date and Time
Text Functions
  • 1. Lower(), Upper(), Proper()
  • 2. Len(), Left(), Right(), Mid()
  • 3. Concatenate()
  • 4. Find(), Search(), Substitute()
  • 5. Trim(), Rept()
Working with Multiple Files & External Files
  • 1. Hyperlink
  • 2. Bookmark
  • 3. Mailto
  • 4. Inserting Object
  • 5. Inserting Comment
  • 6. Arranging Window
Handling Excel Window
  • 1. Pane Management
  • 2. Freezing window
  • 3. Splitting window
Excel Printing
  • 1. Page Layout
  • 2. Adjusting Border
  • 3. Adjusting Printing Size
  • 4. Printing Options
  • 5. Header & Footer

Pre-requisite: Knowledge of Basic & Intermediate Excel

Duration: 6 hours

Advanced Formula Pre-Requisite
  • 1. Advanced Cell Addressing
  • 2. Absolute Cell Referencing
  • 3. Relative Cell Referencing
  • 4. Define Name Range
  • 5. Formula Calculation Type - Auto and Manual
  • 6. Watch Window
Advanced Excel Formula
  • 1. Sumif(), Sumifs()
  • 2. Averageif(), Averageifs()
  • 3. Countif(), Countifs()
  • 4. If() formula with and/or
  • 5. Nested if() formula
  • 6. Iferror()
  • 7. Vlookup() formula
  • 8. Hlookp() formula
Pivot Table
  • 1. Concept of Pivot Table
  • 2. Data Management for Pivot Table
  • 3. Designing Pivot Table
  • 4. Working with Multiple Pivot Table
  • 5. Pivot Table Slicer
Excel Chart
  • 1. Concept & Importance of Excel Chart
  • 2. Creating Excel Charts
  • 3. Different Chart Type
  • 4. Formatting Chart
  • 5. Design & Layout of Chart
Other Advanced Tools
  • 1. Goal Seek
  • 2. Scenario Manager
Macro
  • 1. Concept of Macro
  • 2. Utility of a Macro
  • 3. Recording a Macro
  • 4. Running a Macro
Training Subject :

Microsoft Excel


Levels of Training :

Excel Basic, Excel Intermediate, Excel Advance


Mode of Training :

Presentation, Lecture, Real Life Example, Practical, Corporate Practice and Assignment


Time :

11 am – 6 pm


Number of Seats :

15 (Maximum for each date) - No request will be accepted once the batch is full


Training Batches :

Batch # 107

Topic Date
Basic: 17-Nov-19 (Sunday)
Intermediate: 24-Nov-19 (Sunday)
Advance: 1-Dec-19 (Sunday)

Batch # 108

Topic Date
Basic: 8-Dec-19 (Sunday)
Intermediate: 15-Dec-19 (Sunday)
Advance: 22-Dec-19 (Sunday)

Training Support for 6 months :

Free Unlimited Technical support (personal, telephonic, mail, Anydesk) and Unlimited Practice for 6 months, Soft copy of Course Material, Assignment and Practice Database


Training Location :

Interactive HR Spot Pvt. Ltd. 61 Russa Road (East), 2nd Floor, Near Rabindra Sarobar Metro Station (Gate 6), Opposite to Bhavani Cinema

Training Fees:
Topic Discounted Fee
Only Basic Excel ₹ 599
Only Intermediate Excel ₹ 699
Only Advance Excel ₹ 799
Basic + Intermediate ₹ 999
Intermediate + Advance ₹ 1,199
Basic + Intermediate + Advance ₹ 1,499

Payment Procedure:

1. Cash/Card - Any candidate may visit HR Spot office (address as mentioned in Training Detials tab) and can make the payment in cash or card

2. Bank Transfer - Please find below the bank account details to make payment via NEFT/IMPS/UPI/Transfer

Account Name : HR SPOT
Account Number : 50200005725940
Bank : HDFC Bank
Branch : Prince Anwar Shah
IFSC Code : HDFC0001219

3. Paytm - Any candidate may make the payment via Paytm no. 8479908067 / 8335844414

4. Online Payment - To make online payment please contact our representative. We will send the link to make online payment via card/net banking or any other gateway

Please capture the screenshot/photo of the successful transaction and share the same with our representative once the payment is made.

About the Company & Trainer

Interactive HR Spot Private Limited is an ISO 9001:2015 certified company under MSME and MCA, Govt. of India with certificate number WB10D0011732. The company has won more than 6 national awards for its excellent training and quality services.

The trainer is having more than 25 years of experience in various corporate sectors with varieties of training exposure.

Students Recruited by

Get the Coaching Training Today!

To Become a Competent and Confident HR Professionals