Online Certificate Courses

Virtual Internship

× Get 40% discount on Industry Projects. Special Offer valid till 30th June 2020. Click Here



Excel and Advanced Excel
Categories:
Management
Best Seller
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

Moule1: Introduction to Excel

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

Moule2: Advanced Excel 1

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

Moule3: Advanced Excel 2

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

Moule4: Excel Functions

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

Moule5: More on Excel

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

Learning Outcomes

  • 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

Who Should Attend?

  • Management Students
  • Graduates with Management background

Job Prospects

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

Faculty Profiles
Frequently Asked Questions