EXCEL & ADVANCE EXCEL

Excel is a part of Microsoft Office. It is an electronic spreadsheet program. It is mainly used for manipulating, storing and organizing data. Features of Excel spreadsheet are speed calculation; creating various types of business reports, pivot tables, etc. It is also capable of running a macro programming language known as Visual Basic. Excel sheets have numerous applications in business and finance. It can also be used for educational purpose. Below is the revised course content for Basic Excel and Advanced Excel.

BASIC MS EXCEL - COURSE CONTENT

·         Introduction to Excel Window

·         Select cells, columns and rows

·         Adjust and Hide columns

·         Align data in a cell

·         Clear cell contents

·         Copy cell contents

·         Delete cells, columns or rows

·         Edit cell data

·         Enter cell data

·         Format numbers

·         Move cell contents

·         Sheet tabs

·         Create simple formulas

·         Create functions

·         Print workbook data

·         Create a chart

ADVANCED MS EXCEL - COURSE CONTENT

·         Formulae and functions

·         Filtering of data

·         Sorting table

·         Pasting in special ways

·         Importing of data

·         Working with charts and tables

·         Advanced conditional formatting

·         Data validation

·         Shortcut keys

Back To Top