Youtube
Guest User Preview (Coll-1)
Guest User Preview (Coll-1)!
My Referral
Change Course
My Account
My Contest
Visited Videos
Downloads
Buy Now
Courses
My Tickets
Change Password
Logout
Any Help?
(+91)850 850 2000
support@collectiva.in
Mon - Sat, 10AM to 7PM
Guest User Preview (Coll-1)
!
My Referral
Change Course(s)
My Account
My Contest
Visited Videos
Downloads
Change Password
Logout
Need Assistance?
(+91)850 850 2000
support@collectiva.in
Mon - Sat, 10AM to 7PM
Call / Whatsapp
(+91)850 850 2000
Email Us
support@collectiva.in
We'are Open
Mon - Sat, 10AM to 7PM
(+91)850 850 2000
support@collectiva.in
Home
Categories
Top Categories
Combo Offers
Personality Development
Computer Fundamental Courses
Software Development Fundamentals
Development Categories
.Net Fundamentals
Web Development
Mobile Development
Designing, Animation and Video Editing
General Categories
Creativity Development Skills
Life Skills
Guidelines For Parents
Courses
Most Popular Courses
Software Development Fundamentals
C Programming
Java Programming
Python Programming
C++ Programming
Click here for all courses
Personality Development
Spoken English
English Fluency Development
Spoken Hindi (Prathmic)
Computer Fundamentals
Click here for all courses
Creativity Development Skills
Chess from Beginner to Master
Solving Rubiks Cube
Time Management for Students
Solving Sudoku Puzzles
Click here for all courses
Combo Offers
Software & .Net Development Courses
Diploma in Effortless Programming
Diploma in Python Foundation
Diploma in .Net Web Development
Diploma in .Net Windows Development
Diploma in PHP Web Development
Post Graduate Diploma In Software Development
Foundation Courses
Spoken English & Fluency Development
Spoken Hindi & Fluency Development
Diploma in Computer Applications
Diploma in Tally Accounting
Diploma in Designing
Student Intelligence Package
Diploma in Business Management
Sharepoint & Mobile Development Courses
Diploma in Java & Android Development
Diploma in Sharepoint Development
Free Courses
Computer Courses
கற்க மறந்த பாடங்கள்
Blog
About Author
Contest
More...
Franchise
Who are studying our Courses
How to Win IT Jobs
FAQ
Expert Advisor
Contact Us
Shopping Cart
View Cart
Search Courses here
Microsft Excel
Search Courses
Select Course...
Computer Fundamentals & Internet
Command Window & Batch Processing
Learn English typing
Microsoft Word
Microsoft Excel
Microsoft Powerpoint
Tally ERP + GST
Computer Fundamentals & MS Office
Student Intelligence Package
Tally ERP + GST & MS Office
C Programming
Data Structures using C
Logical Thinking - A Drilldown
C++ Programming
Java Programming
Python Programming
Logical Thinking in Python
C, C++ & Logical Thinking
C, C++, Java Programming & Data Structures
C, C++, Python & Data Structures
Python Programming with Projects
VB.NET Programming
SQL Server & Principles of Database Designing
C# Programming
C# Mini Project
LINQ and Entity Framework
Windows Communication Foundation
.NET Windows Development Package
HTML
Cascading Style Sheet (CSS)
Javascript and JQuery
Responsive website using Bootstrap
AngularJS Web Development
ASP.NET Web Development
ASP.NET MVC Web Development
PHP Web Development
Wordpress and Theme Devlopment
.NET Web Development Package
PHP Web Development Package
Post Graduate Diploma in Software Development
Android Application Development - Foundation
Android Application Development - Project
Professional Flutter Developer
Java & Android Development Package
Photoshop Foundation
Photoshop Projects
Photoshop Foundation with Projects
English Fluency Development
Spoken Hindi (Madhyama)
English Handwriting
Conversational Hindi
Effective Time Management
Rapid Reading for Students
Spoken English
Spoken Hindi Foundation (Prathmic)
Spoken English & Fluency Development
Spoken Hindi & Fluency Development
தொழில் வளர்ப்போம்
பணம் வளர்ப்போம் (BBA Money)
Solving Rubiks Cube
Time Management For Students
Solving Sudoku Puzzles
Rapid Reading for Kids
Chess from Beginner to Master
Diploma in Skill Development
சும்மா பேசலாம் வாங்க
இசையோடு இசையாய்
மனித வாழ்வும் விஞ்ஞானமும்
ஜோதிடம் நம்பத்தகுந்ததா
ஒரு நொடி கவனம்
இது தப்பா? (Sex and Sin)
இலவசம் (Side effects)
உடல், தமிழ், கணிதம்
உயிர், சக்தி, கர்மா
உயிர் விளக்கங்கள்
காதல்
சும்மா இரு
கற்க மறந்த பாடங்கள்
ஜோதிடத் தொழில் பழகு (Astrology)
Diploma in Business Management
Beginning Mathematics for Kids
Click here
for Course Detail
Buy Now
Special Offers
Previous
Next
1
0
Setting up a Workbook
Creating a Workbook
Creating a Workbook
2073 views
Required!
Cancel
Save
Click here to upload file
Required!
Save
Cancel
Click here to upload file
No Comments..!
Total Duration:
02:15:49
Introduction
00:07:19
Introduction
00:38
Tabular Data
06:41
Setting up a Workbook
00:15:03
Creating a Workbook
04:18
Setting up Work book
05:37
Copying Worksheet
05:08
Working with Data
00:24:12
Entering Data
05:56
Add or Remove Rows or Columns
01:40
Entry Features
07:14
Pick from Dropdown list
01:48
Moving Data
02:51
Excel Table
04:43
Calculations
00:21:52
Calculations
03:30
Formula
04:35
Copying Formula
02:51
Functions
04:11
Sales Bill
03:26
Sales Bill - Footer
03:19
Formatting
00:11:15
Formatting Cells
03:03
Changing Workbook Theme
01:16
Data Formatting
03:25
Conditional Highlighting
03:31
Sorting & Filtering
00:05:12
Filtering
03:07
Sorting
02:05
Charts
00:09:15
Pie Chart
05:39
Line Chart
03:36
Mini Projects
00:38:29
Cash Register
06:52
EMI Calculator
11:46
Grade Calculation
03:13
Monthly Budgeting
14:59
Address Book
01:39
Conclusion
00:03:12
What's next?
03:12
Buy Course/Package
×
Buy Now
Special Offers
Our courses are being used by the leading College and Polytechnic students.
Login to your Account
×
*
Email/Roll number:
Required!
*
Password:
Required!
Forgot Password?
Login
New User?
Sign up
Sign up For New Account
×
*
Name:
Required!
*
Mobile No.:
Required!
*
E-Mail Id:
Required!
*
Password:
Required!
*
Confirm Password:
Required!
Register
Already have an account?
Login
Forgot Password?
×
*
E-Mail Id:
Required!
Get Password
or
Login
Change Password
×
*
Current Password:
Required!
*
New Password:
Required!
*
Confirm Password:
Required!
Change
