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:06:00
GST BILL IN EXCEL
Chapter-1 How to Create GST Bill in Excel.(Part.1) 00:16:00
Chapter-1 How to Create GST Bill in Excel.(Part.2) 00:23:00
Chapter-1 How to Create GST Bill in Excel.(Part.3) 00:10:00
Office 365 with Gulf VAT
Chapter-1 How to Access Office 365 00:14:00
Chapter-2 Introduce Main Page 00:09:00
Chapter-3 Edit Profile Page 00:10:00
Chapter-4 Flash Fill Function in Excel 00:07:00
Chapter-5 Sum Function in Excel 00:10:00
Chapter-6 Remove enter Space using Trim Function in Excel 00:04:00
Chapter-7 Find the Difference between Two Date in Excel 00:09:00
Chapter-8 How to Calculate Age in Excel 00:06:18
Chapter-9 DGET Function In Excel 00:10:00
Chapter-10 Shortcut Repeat Last Action In Excel 00:05:00
Chapter-11 Add Serial Numbers to Data set with Blank Rows 00:08:16
Chapter-12 Remove Data before or after a Specific Character in Excel 00:07:00
Chapter-13 Copy File Names Into An Excel Worksheet 00:05:00
Chapter-14 Highlight Rows that contain a Specific Text in Excel 00:06:00
Chapter-15 Excel Shortcut To Add Bullets Point 00:03:00
Chapter-16 Automatic Serial Number In Excel 00:05:00
Chapter-17 Highlight Blank Cells In Excel 00:03:00
Chapter-18 Method To Edit Cell Values In Excel 00:04:00
Chapter-19 Even Function In Excel 00:04:00
Chapter-20 Find The Square Root Function In Excel 00:04:00
Chapter-21 How to Find Highest and Lowest Salary of Employees 00:07:00
Chapter-22 How To Add Input Messages In Cells 00:06:00
Chapter-23 Copying Millions of Copies in just One Drag 00:05:00
Chapter-24 Just One Click And Get Multiple Functions 00:09:00
Chapter-25 How To Build A Search Box In Excel 00:10:00
Chapter-26 Track Changes And Comments In Excel 00:10:00
Chapter-27 How to calculate GULF Payroll(Salary Calculation) 00:15:00
Chapter-28 Draw Menu 00:06:00
Chapter-29 How To Create Barcode In Excel 00:06:00
Chapter-30 Hide And Unhide Cell Content 00:07:00
Chapter-31 How To Calculate Net Price 00:06:00
Chapter-32 How to calculate VAT Amount and Selling Price 00:04:00
Chapter-33 How to calculate GULF VAT in Excel 00:10:00
Final Examination
Excel Quiz 00:30:00

Course Reviews

4.8

4.8
4 ratings
  • 5 stars3
  • 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

Purchase this course
  • 5,000.00 2,500.00
  • 45 Days
632 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