Excel and Advanced Excel

Content Provider

iNURTURE

Course Level

Intermediate

Mode Of Delivery

Self-Paced

Duration

40 hrs

Certification By

iNURTURE

Course Validity

Valid for 6 months post activation
  • 1,800/- 1599/-
Speak with our Expert Team Today Ask Now
Description

This course introduces to the basic features of MS Excel for a business and also for personal purpose. It starts with absolute basics, creating and saving workbooks. It steps further into the process of entering data in cells, basic calculations, applying basic mathematical calculations, formatting worksheets, setting up pages for print and protecting workbooks. It provides learners with the core understanding of how to effectively operate and use the Excel spreadsheet software at basic and advance level. This course helps a learner to create workbooks, maintain the records of past, present and future with built-up formulae and get final charts in graphical form.


Curriculum

Module 1: Introduction to Excel



Excel 2016, Creating and Copying Formulae, Creating Functions, Printing, Charts, Basic Tables



Module 2: Advanced Excel 1



Create Range Name to Cell, Number Formatting, Date and Time Functions, Other Excel Functions



Module 3: Advanced Excel 2



Conditional Formatting, Validation and Protection, Range Names and Absolute References, Charts



Module 4: Excel Functions



Mathematical Functions, Text Functions, Logical & Reference Functions, Date & Time Functions, Financial Functions, Information Functions



Module 5: More on Excel



IF Functions, Nested IF Functions, LOOKUP TABLES, Basic Tables, Advanced Tables, Pivot Tables, Consolidation, Macros


Key Features


  • Describe the main points covered in Excel

  • Select the options to print the data in Excel by applying all the techniques under print settings

  • Create a named range that refers to a range of cells, constant value or a formula

  • Create formulae by applying suitable Excel function tab on the ribbon

  • Design a spreadsheet by applying options in data validation and protection to get a secured and error-free data

  • Analyse the data and find solutions for various business problems


Career Opportunities


  • Associate Support Technology Analyst

  • Excel Analyst, Operations

  • Information Security Analyst

  • Technical Support Analyst

  • Associate Information Security Analyst


Certification

After completing this course and successfully passing the certification examination, the student will be awarded the “Excel and Advanced Excel”  certification.



If a learner chooses not to take up the examination, they will still get a 'Participation Certificate'.




Who Should Attend


  • Management Students

  • Graduates with Management background


Frequently Asked Questions

Where can I find courses on the Platform?

After login to KRACKiN(www.krackin.com), you can find courses on the dashboard which are segregated as skill courses, career tracks and also Annual Membership.consisting of 75000 + courses. You can enrol to any of the courses available by selecting the ‘Buy Now’ button.
Can I search courses domain wise on the platform?

Yes, Skill courses and Annual Membership plans are segregated domain wise. You can enter your domain and search for the desired courses.
Is online classes available for all the courses on KRACKiN?

No, online classes are not available for all courses on KRACKiN. Courses are designed as self- paced learning courses supported by videos, PPTs and practice quizzes etc. are provided for easy understanding of the students.
Are the course certificates valid?

Yes, the certificates are valid across all the sectors in the Industry.
Can I access your courses on Mobile device?

Yes, you can access the courses on your mobile browser.
Can my course access be extended?

We recommend you complete your assigned courses within the stipulated time as we do not have the provision to extend the course validity.
How to get my certificate after completing the course?

After the completion of all the given modules, the certificate will be auto generated by the system.

Content & Certification Partners


About KRACKiN