CTC Computers, A Educational Institute
CTC Computers
A unit of IT Education

New Batches

10:30 pm

Adv. Excel Online 1 May 2020

9: 00 am

Tally GST Online 10 May 2020

11:00 am

Designing : 4 May. 2020

4.00 pm

Corel Draw : 12 May 2020

8:00 am

Office Automation Online : 4 May. 2020

12.00 pm

RSCIT : 14 May. 2020

6:00 pm

Python Online : 15 May. 2020

10:00 pm

Tally GST : 20 Jan. 2020

7:00 pm

Python : 20 Jan. 2020

Advanced Excel

Duration 25 Days 25 Hrs
Syllabus
  • Advanced Marksheet
  • Advanced Salary System with Attendance Calculations
  • Advanced Filter Multiconditional
  • Pivot Table Advance Report Multilevel
  • Multilevel Pulldown Data Chain
  • Auto Billing Excel Softwate(Save Old Bills)
  • Macros
  • Graphs Mixed Type
  • Decode Corporat Item-Code in Excel
  • Custom Formats Text/ Number/ Date
  • Financial Functions : FV, Rate, Nper, PMT,FVSchedule, XIRR etc
  • Logical Functions : If, Iferror, And, Or, Not
  • Text Functions : Char, Code, Concatenate, Find, Search, etc.
  • Date Functions : Date, Day, Month, Year, Now, Today, etc.
  • Lookup Functions : Lookup, Vlookup, Transpose, Rows, Cols etc.
  • Maths Functions : Abs, Radians, Sin, Cos, Tan, Even, Odd, Sum, Sumif, Sumifs etc.
  • Statical Functions : Average, Averageif, Averageifs, Count, Counta, Countblanl etc.
  • Information Functions : Iserror, Isna, Islogical, Isodd, Iseven, Istext etc.
  • and many more Real life Applications in Excel

     

Links Social Networks Business Asociates Contacts
Courses
InfraStructure
Image Gallery
New Batches
Blogger
FaceBook
Twitter
Linkedin
ACME
CNC Infotech
RKCL
Best SAP Training
CTC Computers
56/4, Madhyam Marg,
Near SBI Bank Rajat Path,
Mansarovar, Jaipur, Raj.(India)
ctccomputers@homail.com
info@ctccomputers.co.in
91 9414241675
91 9414180928