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

Lorem ipsum, dolor sit amet consectetur adipisicing elit. Nisi fugiat error ipsam, quibusdam mollitia accusantium dolore amet reprehenderit nam tempore eius fugit, possimus velit et minima! Asperiores quae impedit odio!

Advance Excel Training Institute In Jaipur

Tally Training in Jaipur


Module 1: Introduction to Excel

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

Module 2: 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

Module 3: Perform Calculations with Basic Functions

Module 4: Sort and Filter Data with Excel

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

Module 5: 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

Module 6: 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.

Advance Excel (Optional)

Module 7: 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

Module 8: 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.

Module 9: Use Macros to Automate Tasks

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

Module 10: Advance Formulas

  • TEXT Function
  • Date & Time Function
  • Logical Function
  • Financial Function
  • Formula Auditing
Technoglobe - Technoglobe Computer Classes - 35 Branches Worldwide and Growing


  • 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)

+91 9928556083


Our Courses

Apply For Job

Ready to relocate :  Yes   No

Copyright © All Rights Reserved.

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