Franchise Registration

Advance Certificate in Computer Application and Programming (ACCAP)

Download Brochure

DURATION:
1 week
CREDIT:
3

Certificate In Microsoft Excel With Advance Excel Functions & MIS

Importance Excel Training Course

Microsoft Excel is one of the greatest, most powerful, most important software applications of all time. It provides enormous capacity to do quantitative analysis, letting you do anything from statistical analyses of databases with hundreds of thousands of records to complex estimation tools with user-friendly front ends. As a consequence, Excel is everywhere you look in the business world—especially in areas where people are adding up numbers a lot, like marketing, business development, sales, and, yes, finance.

Excel Training Program Developed by

TIWARI CLASSES is providing Computer Education since      and is one of the oldest computer institute in East-Delhi, This Certification Computer Course is for Two Months. This Certification Computer Course is for beginners, Job Seekers, Housewives and even for School Students who want to learn excel. However those who wish to become Backend Excel operator or data entry operator can also join this course, this is a job oriented practical course, every student is provided individual computer and Individual coaching. Extra practice hours are provided to each student after the classes.

Key Features & Benefits:-

Learner Becomes computer Literate
Learning Day To Operations on Excel.
Focus On Practical Professional Knowledge Of Excel.
All Industry Need features of MS-Excel.

Why to Join “GRACE” ? Who can Join ?
Oldest Institute Since 1993
Affordable Fee With Quality Education
Full Course Coverage
Experienced Faculty
Fully Air-condition Class Rooms
Individual Coaching System
Daily Practical Classes
Study Material 12 th Pass student
Under Graduate
Graduate
House Wife
Kids
Working People
Elderly People
DURATION OF COURSE : TWO MONTHS

KEY FEATURES OF THE CLASSES
Classes by 22+ Yrs Experience Faculty
1:1 Classes to Each Students
Industry based Practical Assignments
Extra Practice Hours without any additional Charges
100% Fee Refund Guarantee if Not satisfied with our coaching*
*Condition Apply

COURSE CONTENTS

Module-1

MS-EXCEL 2007
Introduction to Excel & Excel Worksheets Different Type of Chart Creations
Creation of Excel Data Sheet (New, Open, Save, Save As) Smart Art (Organization , Process Chart, etc)
Customizing Quick Access Toolbar (QAT) Working with Formulas in Table
Cut, Copy, Paste Sorting of Table, Repeat Header Row
Past Special Functions (Transpose, Paste As Picture etc.) Managing Styles, Creation of Style
Insertion of Table, Row, Column, Worksheet Format Painter
Deletion of Table, Row, Column, Worksheet Auto fill of Data (Linear, Growth, Date, Year)
Working with Page Setup, Margins, Orientation Row, Column, Worksheet Hide/Unhide
Working with Header, Footer, Page Number, Page Break Row, Column, Worksheet Hide/Unhide
Simple functions in Excel (Sum, Average, Max, Min) Range Name, Use of Range in Sum
Merge Cell, Split Cells Wrap Text, Shrink to Fit
Working with Hyperlink Auditing, (Trace Precedents, Trace Dependents)
Printing of Documents Freeze Panes, Split Window
Goal Seek Bookmark
Scenario Management Data Table
Equation & Symbol Use of Data Filter
Print Area Insertion of Text Box
Conditional Formatting Data Validations
Data Consolidation Move, Copy of Worksheet in Same Workbook
Move, Copy of Worksheet in New Workbook Real Life Assignment Work

Module-2

ADVANCE EXCEL COMMANDS
Advanced Data Sorting Filter & Advance Filter
Multi-level sorting Sort by icons, Sort by colours
Restoring data to original order after performing sorting Vertical Lookup ( VLOOKUP)
Printing Raw/ Column Heading On Each Page Horizontal Lookup (HLOOKUP)
Editing Data With The Help Of Form Pivot Table, Pivot Chart
Group & Outline Generating MIS Report In Excel
Subtotal, Multi-Level Subtotal Advance Use Of Data Tables
Consolidation With Several Worksheets Specified Range Protection
Workbook /Worksheet Protection Macro – Keyboard Macro & QAT Macro
MATH FUNCTIONS
SUM LCM
MOD ROUND
INT ABS
POWER SQRT
PRODUCT COUNTA
COUNTA BLANK SUMIF
COUNTIF VALUE(TRIM)
TEXT FUNCTION
UPPER DOLLAR
PROPER LEFT
LOWER RIGHT
CONCATENATE TRIM
LEN EXACT
DATABASE FUNCTION
DCOUNTA DMAX
DMIN DSUM
DGET DAVERAGE
DATE & TIME FUNCTIONS
DATEVALUE DATE
YEAR DAY
MONTH DATEDIF
EDATE WEEKSUM
WEEKDAY TIME
TODAY LARGE
STATISTICAL FUNCTIONS
MAX AVERAGE
MIN SMALL
CONVERT AVERAGE(LARGE)
AVERAGE(SMALL) RANK
LOGICAL FUNCTION
IF AND
OR NESTED IF
IF(AND) IF(AND(OR)
IF(OR) IF(NOT)
FINANCIAL FUNCTIONS
PMT PV
PPMT FV
IPMT NPER
RATE PER
FUCTIONS FOR CALCULATING DEPRECIATION
SLN DB