CERTIFICATE IN ADVANCE EXCEL ( S-IT-05 )

MS Excel Beginner Syllabus

This syllabus involves covering the essential skills and knowledge that a beginner or intermediate user would need to be proficient in the software.

Introduction to Excel

·       Understanding the Excel interface

·       Navigating the Ribbon and Tabs

·       Creating a new workbook

·       Saving and opening workbooks

Basic Operations

·       Entering and editing data

·       Formatting cells (number format, alignment, font)

·       Basic cell operations (cut, copy, paste, drag-fill)

·       Using AutoSum for quick calculations

Formulas and Functions

·       Understanding formulas and functions

·       Basic arithmetic functions (SUM, AVERAGE, COUNT)

·       Relative and absolute cell references

Working with Data

·       Sorting and filtering data

·       Inserting and deleting rows and columns

·       Basic data organization techniques

Charts and Graphs

·       Creating simple charts (column, line, pie)

·       Formatting chart elements

·       Inserting and modifying chart titles and labels

Printing and View Options

·       Adjusting page setup for printing

·       Using print preview

·       Setting print areas and printing selected ranges

Introduction to Tables

·       Creating and managing tables

·       Using table styles

·       Basic table operations (sorting, filtering within tables)

MS Excel Advance Syllabus

Advanced Formulas and Functions

·       Using more complex functions (VLOOKUP, IF, SUMIF, COUNTIF)

·       Nesting functions

·       Introduction to array formulas

Data Analysis

·       Advanced sorting and filtering

·       Using conditional formatting

·       Creating and using PivotTables

Charting and Graphing

·       Creating advanced charts (combo, scatter, stock)

·       Using chart templates

·       Advanced chart formatting and customization

Working with Multiple Sheets

·       Referencing data across sheets

·       Consolidating data from multiple sheets

·       Using 3D references in formulas

Macros and Automation

·       Recording and running macros

·       Assigning macros to buttons and shapes

Data Validation and Protection

·       Setting data validation rules

·       Protecting sheets and workbooks

·       Using password protection

Advanced Table Features

·       Advanced table formatting and design

·       Using structured references in tables

·       Table slicers and timelines