Admission Enquiry:
+91 9928556083 | +91 8529171155
Toll Free: 18005729697
Franchise | Master Franchise :
+91 9829140090 | +91 7742420102

Give a HEAD START to your career with our Job Oriented Programs in Accounting / Digital Marketing
Web Development / Data Science
or Salesforce

Advance Excel Training

durationDuration :
3 Months
Study TypeStudy Type :
Full Time
Tuition feesClasses :
On Projector
assignments-img 100% placement
assignments-img Job Oriented
assignments-img Step by step
assignments-img Daily

Introduction to Excel

  • Introduction To Excel Interface
  • Understanding Rows And Columns, Naming Cells
  • Working With Excel Workbook And Sheets

Formatting Excel Work Book

  • New, Open, Close, Save, Save As
  • Formatting Text: Font Size, Font Style
  • Font Color, Use The Bold, Italic, And Underline
  • Wrap Text, Merge And Centre
  • Currency, Accounting And Other Formats
  • Modifying Columns, Rows & Cells
  • >

Perform Calculations with Basic Functions

Sort and Filter Data with Excel

  • Sort And Filtering Data
  • Using Number Filter, Text Filter
  • Custom Filtering
  • Removing Filters From Columns
  • Conditional Formatting

Create Effective Charts to Present Data Visually

  • Inserting Column, Pie Chart Etc.
  • Create An Effective Chart With Chart Tool
  • Design, Format, And Layout Options
  • Adding Chart Title
  • Changing Layouts
  • Chart Styles
  • Editing Chart Data Range
  • Editing Data Series
  • Changing Chart

Proofing and Printing

  • Page Setup, Setting Print Area, Print Titles
  • Inserting Custom Header And Footer
  • Inserting Objects In The Header And Footer
  • Page Setup, Setting Margins, Print Preview, Print
  • Enable Back Ground Error Checking
  • Setting Autocorrect Options.

Analyze Data Using Pivot tables and Pivot Charts

  • Understand Pivot tables, Create A Pivot table
  • Framework Using The Pivot table And Pivot chart
  • Create Pivot Chart From Pivot Table.
  • Inserting Slicer
  • Creating Calculated Fields

Proofing a Protecting and Sharing Workbook

  • Protecting A Workbook With A Password
  • Allow User To Edit Ranges
  • Track Changes
  • Working With Comments
  • Insert Excel Objects And Charts In Word
  • Document and Power Point Presentation.

Use Macros to Automate Tasks

  • Creating and Recording Macros
  • Assigning Macros To The Work Sheets
  • Saving Macro Enabled Workbook

Advance Formulas

  • TEXT Function
  • Date & Time Function
  • Logical Function
  • Financial Function
  • Formula Auditing

Finding Your Right Courses

Request A Call


  • 24+ Years of Excellence in Education, Trainings & Placement
  • Technoglobe has been awarded more then 20 times for its quality Education & Placement.
  • 100% Assured Placements.Technoglobe having tie ups with 100+ Companies.
  • Technoglobe is Authorised by Ministry of MSME for Skill Development Programs.
  • More Than 45000+ Students Placed.
  • Soft Skills & GDPI Classes for Interview Preparation.
  • In depth training of Technology with Live/Real Time Projects by Expert Trainers.
  • International Certification for students from our Authorised Partners HPE, IBM, Microsoft,ADOBI & Tally.
  • Technoglobe is recommended by Rajasthan Technical University for Intership & Training.
  • Team Technoglobe consists of highly qualified professionals with PhD, M.Tech, B.Tech, MCA, BCA, MBA, and many other streams.

Head Office

405, Bhandari Hospital Corner,Gopalpura Bypass, Jaipur. Rajasthan (INDIA)

Corporate Office

Basement, Shiv Shakti tower, near triveni flyover, Gopalpura, Jaipur. Rajasthan (INDIA)

Call Us

+91 9928556083

Email Us

Need Help?

Send Us A Message

Get In Touch

(Head Office) : 405, Bhandari Hospital Corner,Gopalpura Bypass, Jaipur. Rajasthan (INDIA)

(Corporate Office) : Basement, Shiv Shakti tower, near triveni flyover, Gopalpura, Jaipur. Rajasthan (INDIA)

(Reg. Office) : A-46, Murti Kala Colony, Gopalpura Byepass, Gopalpura, Jaipur - 302018. Rajasthan (INDIA)


+91 9928556083

© TECHNOGLOBE. All Rights Reserved.

The certification names and logos are the trademarks of their respective owners.