Help us to Give you More Information.

What is Microsoft Excel

Achieve valuable insights with powerful analysis tools

Microsoft Excel is a spreadsheet program which allows one to enter numerical values or data into the rows or columns of a spreadsheet, and to use these numerical entries for such things as calculations, graphs, and statistical analysis.

Microsoft Excel provides a grid interface to organize nearly any type of information. The power of Excel lies in it's flexibility to define the layout and structure of the information you want to manage.

Some advantages of Learning Excel: Gain Valuable Microsoft Excel Computing Skills. Achieve industry-recognized certification. Assure employers of your qualifications. Boost your workforce resume. Differentiate yourself from other applicants. Advance your career.

Microsoft Excel Certification gives you the tools to achieve more.

Apply Now

Learn

Learn

Learn how to use Microsoft Excel using content-rich materials including textbooks, online eCourseware, and video resources.

Practice

Practice

Practice using interactive exam preparation tools and practice exams.
Certify

Certify

Certify and validate skills taking Certiport performance- based exams

Curriculum

Learn - Practice - Certify

Basic & Advanced Excel Concepts

  • Module 1: Overview of the Basics

    Customizing common options in Excel
    Absolute and relative cells
    Protecting and un-protecting worksheets and cells

    lots more.

  • Module 2: Working with Functions

    Writing conditional expressions (using IF, IFS , OR AND ETC.)
    Using logical functions (AND, OR, NOT)
    Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX, INDIRECT)

    lots more.

  • Module 3: Data Validations

    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

    lots more.

  • Module 4: Working with Templates

    Designing the structure of a template
    Using templates for standardization of worksheets

    lots more.

  • Module 5: Sorting and Filtering Data

    Sorting tables
    Using multiple-level sorting
    Using custom sorting
    Filtering data for selected view (AutoFilter)
    Using advanced filter options

    lots more.

  • Module 6: Working with Reports

    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

    lots more.

  • Module 7 : More Functions

    Date and time functions
    Text functions
    Database functions

    lots more.

  • Module 8 : What-If Analysis

    Using goal seek
    Using data tables
    Creating and editing scenarios

    lots more.

  • Module 9: Dashboard

    Applying Charts with Different Data base
    Applying Slicers & Playing around with Pivots

    lots more.

  • Module 10: Data Forms

    Using forms to simplify data manipulation
    Specifying criteria for finding records

    lots more.

  • Module 11: Workbook Sharing and Auditing

    Tracking changes
    Merging workbooks
    Tracing precedents and dependents
    Tracing errors

    lots more.

  • Module 12: Working with External Data

    Querying external databases
    Saving, editing and reusing external data queries
    Importing text files
    Refreshing data

    lots more.

  • Module 13: Using Macros

    Recording and executing macros
    Understanding different types of references in macros
    Assigning macros to toolbars or menu items
    Editing macros using VBA Editor
    Writing function using VBA Editor

    lots more.

  • Module 14: Creation of Dashboards

    Working with Chart
    Working with Power Pivot Tables

    lots more.

  • Module 15: Working with Statistical Functions and Tips & Tricks of Microsoft Excel

    Discussion on 30-50 different tricks by using Excel

    lots more.

Help us to Give you Course Details

What are you waiting for.

Meet Our Team

They're all professional in knowledge and enthusiastic.

Kiran Kumar

Kiran Kumar

Founder
Shiva Kumar

Shiva Kumar

Director
Supreeth Garla

Supreeth Garla

Senior Trainer
Rakshith Suresh

Rakshith Suresh

Corporate Trainer

What People Say

How real people said about NICT

Lalith

Lalith

I jst have 2 things to tell... Thnx a lot to NICT... Thank uuu Sooo much rakshith sir...
Priyanka

Priyanka Gowda

The training we got ws best as I feel..... And as it my first value added course I hd a great start up. Tqq for NICT center n tqq to our trainer Rakshit Sir... It was the best classes than our regular ones.. We leant lot abt Excel, tally along with GST introduction.... Tqq sir so the personality development subject is going good. Thanks to all who are making this institution an interesting place to switch on.
Anand

Anand Kumar

Its been a pleasure to be here.Friendly and well teaching, kind faculties. I am happy that I was suggested to take up this course, for I am thrilled at learning all that is taught to me here. Student-friendly institution, encouraging and imparting sound knowledge on computer.My favorite is the English where I enjoy learning new style of communication and also the personality development subject is going good. Thanks to all who are making this institution an interesting place to switch on.
Giriraj

Giriraj

I Joined NMAS (Animation) in this NICT Ramamurthynagar center, i learnt 3Ds max, Maya, Designing etc. It was a wonderful experience to me they taught each and everything in software and gave a assignments too and placed me in a good company. and institute environment, the way of treating a student is extremely good.Whatever they promised to me while joining, all fullfilled. This is nice place to learn tally as per my experience. Now I am placed in a good company. And m earning well.

Hurry Up Limited Seats only

Register Now

Help us to Give you More Information.

Eight Reasons Why STUDENTS Will love NICT

Marketing is Advancing with Microsoft Excel

Google-Certification
Student Becomes A Microsoft Certified Professional

Learn from industry Experts
Learn from Industry Experts

Learn A-Z of Digital Marketing
Learn A-Z of Microsoft Excel

Free Doubt Sessions
Free Doubt Sessions

Group & Individual Assignments
Group & Individual Assignments

Comprehensive-Practical-Training
Comprehensive Practical Training

Feedback
Feedback

Our Completed Trainings in Bangalore

1558+ Batches Completed in 10 years

Nict Computer Education Training Centers in Bangalore

Our Training Centers is Located in Heart of the City

NICT Ramamurthynagar Branch.

#183 1st Main Road Ramamurthynagar Bangalore – 560016.
Land Mark:-  Opp to Ramamurthynagar old Police Station.
Phone :- 41679695 / 9964194324.
Email :- br@nicteducation.com.

NICT Mission Road Branch

#43, 4th Main Road Sampangi Rama Nagar Bangalore – 560027
Land Mark : Opp to S R Nagar Police Station.
Phone :- 22110065 / 9620222392.
Email :- br@nicteducation.com.

NICT Malleshwaram Branch

##535, 2nd Floor, Sampige Road,
Between 15th & 16th Cross,
Melleshwaram, Bangalore – 560003.
Land Mark – Next to Tanishq Jewelers.
Contact: – 080-41281780 / 9964194324.
Email: – br@niteducation.com

Trusted by over 6000+ students

Join our community of students around the world helping you succeed.