Excel and Advanced Excel

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.

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