Certificate in Information Technology

Expert

Last Update November 24, 2022

0 already enrolled

About This Course

CIT – Certificate in Information Technology is one most important course for students, completed their Secondary or Higher Secondary education. Get in depth knowledge about computer operation which will give extra benefit in professional life.

Learning Objectives

CIT is for beginners to advance

Learn complete office management

Advance Excel included

Cloud for office productivity

Material Includes

Full Lifetime Access
Lifetime upgradation
Downloadable Exercise Files
Certificate of Completion

Target Audience

Best for School students
Job seekers
Professionals

Curriculum

74 Lessons

Fundamentals of Computer

History of Computer4:14

Computer Generations8:30

Understanding Types of Computer8:01

Understand Computer & Components11:12

Understanding System & Application software9:16

Understanding Programing Languages00:03:09

Start & Manage Computer System

Understanding Common Applications

Speed Typing Technique

Microsoft Advanced Word

Microsoft Advanced Excel

Excel introduction (Copy 1)

Understanding Excel Tabs and ribbons (Copy 1)

Excel Backstage View (Copy 1)

Excel organize workbook, sheet, row & column (Copy 1)

Excel Table (Copy 1)

Excel data entry technique (Copy 1)

Excel Keyboard Shortcuts (Copy 1)

Excel Security Implementation (Copy 1)

Excel Formula & Function anatomy (Copy 1)

Excel Basic Formula- Add, Subtract, Multiple, Divide And Percentage (Copy 1)

Excel Function- SUM, SUMIF, SUMIFS (Copy 1)

Excel Function- Count, Counta, Countblank, Countif, Countifs (Copy 1)

Excel Function- Average, Averageif, Averageifs (Copy 1)

Excel Function- LEN, TRIM, LEFT, MID, RIGHT, CONCATENATE (Copy 1)

Excel Function- AND & OR (Copy 1)00:00:00

Excel Function- DATE, DATEDIF, NOW, TIME (Copy 1)

Excel Function- VLOOKUP (Copy 1)

Excel Function- HLOOKUP (Copy 1)

Excel Function- INDEX MATCH (Copy 1)

VLOOKUP with Index Match (Copy 1)

Excel Function- HLOOKUP with Index Match (Copy 1)

Excel Function- PMT, IPMT, PPMT (Copy 1)

Excel Function- PIVOT TABLE (Copy 1)

Data Visualization usingCharts (Copy 1)

Microsoft Advanced PowerPoint

Introduction to Ms Access

Understanding Internet Technology

Email Technology

Google Productivity & Cloud Tools

Basic concept of HTML

₹800.00

Level

Beginner

Lectures

74 lectures

Subject

Certificate

Material Includes

Full Lifetime Access
Lifetime upgradation
Downloadable Exercise Files
Certificate of Completion

Certificate in Information Technology

About This Course

Learning Objectives

Material Includes

Target Audience

Curriculum

Fundamentals of Computer

History of Computer4:14

Computer Generations8:30

Understanding Types of Computer8:01

Understand Computer & Components11:12

Understanding System & Application software9:16

Understanding Programing Languages00:03:09

Start & Manage Computer System

Setting up a Computer System00:03:00

Understanding Keyboard & Mouse operation00:12:34

Windows Operating System20:06

Organize your files & folder11:52

Understanding Common Applications

Basics of Paint00:24:13

NotePad introduction to word processor00:17:42

WordPad basics28:43

Speed Typing Technique

Understanding Keyboard Layout & Speed Typing

Typing Workout00:00:00

Microsoft Advanced Word

Introduction to word (Copy 1)

Understanding Word Application (Copy 1)

Word Back Stage View (Copy 1)00:00:00

Explaining Home tab- Editing, Formatting Text & Paragraph (Copy 1)00:00:00

Understanding Insert tab & functionality (Copy 1)00:00:00

Understanding Design tab functionality (Copy 1)00:00:00

Working with page layout (Copy 1)00:00:00

Understanding Mail Merge (Copy 1)00:00:00

Microsoft Advanced Excel

Excel introduction (Copy 1)

Understanding Excel Tabs and ribbons (Copy 1)

Excel Backstage View (Copy 1)

Excel organize workbook, sheet, row & column (Copy 1)

Excel Table (Copy 1)

Excel data entry technique (Copy 1)

Excel Keyboard Shortcuts (Copy 1)

Excel Security Implementation (Copy 1)

Excel Formula & Function anatomy (Copy 1)

Excel Basic Formula- Add, Subtract, Multiple, Divide And Percentage (Copy 1)

Excel Function- SUM, SUMIF, SUMIFS (Copy 1)

Excel Function- Count, Counta, Countblank, Countif, Countifs (Copy 1)

Excel Function- Average, Averageif, Averageifs (Copy 1)

Excel Function- LEN, TRIM, LEFT, MID, RIGHT, CONCATENATE (Copy 1)

Excel Function- AND & OR (Copy 1)00:00:00

Excel Function- DATE, DATEDIF, NOW, TIME (Copy 1)

Excel Function- VLOOKUP (Copy 1)

Excel Function- HLOOKUP (Copy 1)

Excel Function- INDEX MATCH (Copy 1)

VLOOKUP with Index Match (Copy 1)

Excel Function- HLOOKUP with Index Match (Copy 1)

Excel Function- PMT, IPMT, PPMT (Copy 1)

Excel Function- PIVOT TABLE (Copy 1)

Data Visualization usingCharts (Copy 1)

Microsoft Advanced PowerPoint

Introduction to PowerPoint (Copy 1)

Understand PowerPoint Application (Copy 1)

Create and Open a Presentation (Copy 1)

Saving option in PowerPoint (Copy 1)

Create & Manage Slides (Copy 1)

Apply and Manage Theme (Copy 1)

Insert objects including Text, Video, Audio, Shapes (Copy 1)

Apply Transitions on Slides (Copy 1)

Apply Object Animation (Advance) (Copy 1)

Slide Master Introduction (Copy 1)

Slide Show Presentation (Copy 1)

Introduction to Ms Access

Understanding Internet Technology

Basics of Internet (Copy 1)

Understand URL and Hyperlink (Copy 1)

Customize Web Browser (Copy 1)

Online Safety (Copy 1)

Email Technology

Email Basics (Copy 1)

Sending Emails (Copy 1)