Using Excel as Database

-

Click on the links below to watch videos of the same topic:

 1.        Database Concepts
 2.          Using Forms
 3.     Form Operations
 4. Filtering Data
 5. Advance Filter
 6. Sorting Data
 7.
 Conditional Formatting
 8.
 Data Validation
 9.
 Adding Subtotal
 10.
 Pivot Table

Here are the links for questions/answers, exercises and worksheet with answer keys:

Comments

Post a Comment

Popular posts from this blog

Shortcuts keys of Ms-Excel & Ms-Word

-
Using shortcut keys with Ms-Excel & Ms-Word A very important aspect of using computers.While working on computers,  many times we feel to get our work done quickly. When we know or remember the shortcuts, it means less use of mouse and more use of the keyboard, and the thing gets done quickly. A professional does work faster as compared to an ordinary user of a computer. The one and the only reason is the use of shortcut keys. He leans and practices the shortcuts in such an excellent manner that the desired work gets completed in very little time. So, watch the full videos of the most useful Microsoft-Word  & Microsoft Excel shortcut keys and enjoy learning and experiencing the easy and important key shortcuts. The links to watch videos for  Ms-Word shortcut keys                Ms-Excel shortcut keys
Read more

Making Stylus for FREE

-
Image
Making a stylus or touch screen pen home without spending even a single penny is actually a big help for many people. The need of a teacher facing problems these days at home while teaching is the foundation of this idea being shared with you. Enjoy learning and don't forget to share with as many as possible facing the same problem must get the solution in easy way and should enjoy learning and teaching while staying at home or in field. Click on the link to watch the video: Stylus
Read more