Course Synopsis:
Microsoft Excel is one of the most widely used tool for Digital Data Management tasks. Its very useful application to store and manage data like Customer data, Employee info, Product Inventory data etc. It helps to do calculations, analyze and present data in a user friendly manner via its features like rich library of functions, charts and Pivot Table. Microsoft Excel also can automate repetitive and labor intensive data management tasks using macros.
SSDN Innovations provide Basic and Advanced Microsoft Excel Courses in an interactive and fun way with lots of Hands on practice.
Course Pre-requisite:
Basic knowledge of operating computer
Educational Background:
O or N level (and its equivalent)
Course Duration:
Basic MS Excel : 7 Hours (One day)
Advanced MS Excel : 7 Hours (One day)
Course Contents:
Basic MS Excel Course Contents:
Getting Familiar with Microsoft Excel Interface
Worksheet Editing and Formatting
Calculations Using Formulas and Functions
Using Charts
Page setup and Printing
Advanced MS Excel Course Contents:
Using Range Names in Formulas & Functions
Using Advanced Formulas and Functions
Data Analysis
Using Pivot Tables and Charts
Automating tasks using Macros