Contact for queries :
Course Search:

The ‘The Complete Excel’ program is designed to train you in the latest accounting and spread sheet techniques. Microsoft Excel is one of the most popular, powerful and easiest programs for managing information. Whether you need a simple spread sheet or a complex interactive database and to calculate financial, statistical and engineering information.

Course duration:

The Complete Excelis 45 Days course. The training programs are in e-learning video sessions that can be access at anywhere.

Eligibility:

10th/+2/ Graduates/ Working professionals

Requirements

  • PC capable of Running Excel
  • No other knowledge is required, as each step is explained fully in the course.

Job opportunities:

On successfully completing the ‘The Complete Excel” course, you will be ready to join top companies as:

  • Financial Analysts.
  • Retail Store Managers.
  • Project Managers.
  • Business Analysts.
  • Data Journalists.
  • Accountants.

Course Preview

Course Curriculum

INTRODUCTION
Introduction 00:15:00
ENTERING CLIPBORD AND FONT RIBONS
Chapter- 1 Clipboard and Font Ribbons 00:10:00
Chapter-2 Save and Save as 00:07:00
TEXT ALIGNMENT
Chapter- 1 Text Alignment 00:08:00
CONDITIONAL FORMATING
Chapter-1 Conditional Formatting 00:10:00
Chapter-2 Number Formatting 00:07:00
TABLE FORMATING AND CELL STYLES
Chapter-1 Table Formatting and Cell Styles 00:07:00
MANAGING CELL FORMATING AND TEXT EDITING
Chapter-1 Cell Formatting 00:08:00
Chapter-2 Text Editing. (Part.1) 00:08:00
Chapter-2 Text Editing.(Part.2) 00:08:00
PIVOT TABLES AND PIVOT CHARTS
Chapter-1 Table, Pivot Tables and Pivot Charts 00:14:00
ADDING GRAPHICS TO SPREDSHEETS
Chapter-1 Clipart and Shape. (Part.1) 00:09:00
Chapter-1 Clipart and Shape. (Part.2) 00:06:00
Chapter-2 Insert Picture 00:12:00
Chapter-3 Smart art Creation 00:08:00
CHART CREATION AND FORMATING CHARTS
Chapter-1 Chart Creation 00:09:00
Chapter-2 Formatting Charts 00:08:00
TEXT FORMULAS
Chapter-1 Header and Footer 00:12:00
Chapter-2 Text Ribbon. (Part.1) 00:07:00
Chapter-2 Text Ribbon. (Part.2) 00:13:00
PAGELAYOUT MENU
Chapter-1 Page Layout. (Part.1) 00:08:00
Chapter-1 Page Layout. (Part.2) 00:05:00
Chapter-2 Print Titles 00:16:00
VIEW MENU
Chapter-1 Freeze Pane. 00:05:00
Chapter-2 View Menu.(Part.1) 00:09:00
LOOKUPS VALUES
Chapter-1 V lookup Function.(Part.1) 00:06:00
Chapter-1 V lookup Function.(Part.2) 00:08:00
SORT FILTTER AND REMOVE DUPLICATES
Chapter-1 Advanced Filter. 00:07:00
Chapter-2 Data Sorting. 00:09:00
Chapter-3 Data Validation. 00:10:00
Chapter-4 Filter. 00:05:00
Chapter-5 Remove Duplicates. 00:05:00
Chapter-6 Text to Columns. 00:05:00
PROTECTING DATA
Chapter-1 Protect WorkBook and Work Sheet. 00:05:00
SAVING A WORKBOOK
Chapter-1 Save and Save as. 00:07:00
MACROS
Chapter-1 Macros.(Part.1) 00:08:00
Chapter-1 Macros.(Part.2) 00:06:00
MODIFYING ROWS AND COLUMNS
Chapter-1 Modifying Rows And Columns 00:06:00
UNDERSTANDING FORMULAS (ADVANCED EXCEL)
Chapter-1 ABS Function. 00:07:00
Chapter-2 AND Function. 00:06:00
Chapter-3 Basic Formulas. 00:11:00
Chapter-4 Cancel Duplicate Entry. 00:05:00
Chapter-5 Cell Function. 00:04:00
Chapter-6 Choose Function. 00:06:00
Chapter-7 Closing Stock. 00:04:00
Chapter-8 Code Function 00:08:00
Chapter-9 Concantinate Function. 00:07:00
Chapter-10 Count Function 00:07:00
Chapter-11 Date Function. 00:11:00
Chapter-12 Even and Exact Function 00:05:00
Chapter-13 Fees Details.(Part.1) 00:06:00
Chapter-13 Fees Details.(Part.2) 00:10:00
Chapter-14 Fees Details.(Part.3) 00:10:00
Chapter-15 Form Function. 00:05:00
Chapter-16 H look up Function. 00:06:00
Chapter-17 Interest Calculator. 00:04:00
Chapter-18 Create Print Button. 00:05:00
Chapter-19 Profit Calculation 00:09:00
Chapter-20 Sales Reports. 00:05:00
Chapter-21 Stock Management Application 00:13:00
Chapter-22 Students Mark list 00:10:00
Chapter-23 Sub Total 00:06:00
Chapter-24 Calculate Stock 00:11:00
Chapter-25 Payroll or Salary Details 00:10:00
DEVELOPER TAB (ADVANCED EXCEL)
Chapter-1 VBA Advanced Filter. 00:10:00
FILE PRINTING
Chapter-1 File Printing. 00:00:00
GST BILL IN EXCEL
Chapter-1 How to Create GST Bill in Excel.(Part.1) 00:00:00
Chapter-1 How to Create GST Bill in Excel.(Part.2) 00:00:00
Chapter-1 How to Create GST Bill in Excel.(Part.3) 00:00:00
Final Examination
Excel Quiz 00:30:00

Course Reviews

4.8

4.8
5 ratings
  • 5 stars4
  • 4 stars1
  • 3 stars0
  • 2 stars0
  • 1 stars0
  1. The Complete MS Excel

    5

    Excellent, All the classes of video tutorials are very deeply done which was very simple and easy to learn.

  2. Excel

    4

    It will be good if some excel assignments are also given

  3. GREAT

    5

    Well organised excel modules.. happy learning

  4. fantastic experience

    5

    thanks KCSM

TAKE THIS COURSE
822 STUDENTS ENROLLED

Education for Anyone, Anywhere

About Study Bird

Studybird.in, an Kerala Computer Saksharatha Mission™ initiative, offers job oriented e-learning programs in Media Production, Interior Designing, Architecture Designing, Film & Television Editing, Animation, Indian/International Accounting+ GST and Information Technology.

Contact info

Kerala Computer Saksharatha Mission
No. XVII/897, Opp. Court, Adoor,
Pathanamthitta Dist, Kerala-691 523

Tel :  04734220109

Email:  kcsm@rediffmail.com

About KCSM

Kerala Computer Saksharatha Mission® is one of the largest Multimedia/I.T. Education network with 300+ training centers in all over kerala, and have offered ISO 9001:2015 standard Job oriented

Film-Television Editing, Interior Designing, Architecture Designing, Visual Effects, Animation, Indian/International Accounting+ GST and Information Technology training with low fees. KCSM completed its glorious twenty years. In its short-term performance the institution has been able to curve a niche for itself and even for a reputation for quality and reliability.

CONTACT INFORMATION

Kerala Computer Saksharatha Mission ©️
No. V/974,M.G. Road, Adoor,
Pathanamthitta Dist, Kerala-691 523

Tel : 04734220109

email: kcsm@rediffmail.com

Interested Candidate Send your <NAME> to 8157062637

top
Copyright | All rights reserved. | Privacy Policy
X