Welcome to NATIONAL COMPUTER INSTITUTE OF TECHNOLOGY

WELCOME TO NATIONAL COMPUTER INSTITUTE OF TECHNOLOGY     "कंप्यूटर सीखना हुआ और भी आसान अब हर घर कंप्यूटर सीखेगा"   WhatsApp/Call: 8210677550

CERTIFICATE IN ADVANCE MS-EXCEL ( S-CAE-002 )

BASIC INFORMATION

  • Course Fees : 1500.00 3000.00/-
  • Course Duration : 3 MONTH
  • Minimum Amount To Pay : Rs.500.00

Syllabus:

1.     Computer Fundamental

2.     Windows OS

3.     MS-Office Information

4.     Excel Introductions

5.     Excel Uses in different fields

6.     Customizing Excel

7.     Using Basic Functions

8.     Use of All Commands of All Tabs

9.     How to make Official Project Work

10.                        Graphics Work related to Office

11.                        Formatting and Proofing

12.                        Mathematical Functions

13.                        Protecting Excel

14.                        How to use Picture Format, Customize Shapes and Charts

15.                        Text Functions

16.                        Date and Time Functions

17.                        Advanced Paste Special Techniques

18.                        Using Sorting and Filtering

19.                        Printing Workbooks

20.                        Logical Functions

21.                        Data Validation

22.                        Lookup Functions

23.                        Pivot Tables

24.                        Charts and Slicers

25.                        Excel Dashboard

26.                        Using Macro

27.                        Using Spark lines

28.                        Using 250+ Formula

29.                        Excel Shortcuts and Important Questions

30.                        Official Work with Projects

31.           Excel Analysis

32.           Vlookup

33.          Index Match

34.          Graphs and Chart

35.          Dashboard and Functions