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.
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
- 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)
- 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
- Module 4: Working with Templates
Designing the structure of a template
Using templates for standardization of worksheets
- Module 5: Sorting and Filtering Data
Using multiple-level sorting
Using custom sorting
Filtering data for selected view (AutoFilter)
Using advanced filter options
- Module 6: Working with Reports
Creating Pivot tables
Formatting and customizing Pivot tables
Using advanced options of Pivot tables
Consolidating data from multiple sheets and files using Pivot tables
Using external data sources
Using data consolidation feature to consolidate data
- Module 7 : More Functions
Date and time functions
- Module 8 : What-If Analysis
Using goal seek
Using data tables
Creating and editing scenarios
- Module 9: Dashboard
Applying Charts with Different Data base
Applying Slicers & Playing around with Pivots
- Module 10: Data Forms
Using forms to simplify data manipulation
Specifying criteria for finding records
- Module 11: Workbook Sharing and Auditing
Tracing precedents and dependents
- Module 12: Working with External Data
Querying external databases
Saving, editing and reusing external data queries
Importing text files
- 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
- Module 14: Creation of Dashboards
Working with Chart
Working with Power Pivot Tables
- Module 15: Working with Statistical Functions and Tips & Tricks of Microsoft Excel
Discussion on 30-50 different tricks by using Excel
Meet Our Team
They're all professional in knowledge and enthusiastic.
What People Say
How real people said about NICT
I jst have 2 things to tell... Thnx a lot to NICT... Thank uuu Sooo much rakshith sir...
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.
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.
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.
Eight Reasons Why STUDENTS Will love NICT
Marketing is Advancing with Microsoft Excel
Student Becomes A Microsoft Certified Professional
Learn from Industry Experts
Learn A-Z of Microsoft Excel
Free Doubt Sessions
Group & Individual Assignments
Comprehensive Practical Training
Nict Computer Education Training Centers in Bangalore
Our Training Centers is Located in Heart of the City
Trusted by over 6000+ students
Join our community of students around the world helping you succeed.