CS101 Final Term Preparation – Short Lectures and Short Notes – MS EXCEL Topic 220-224 are explained in these lectures. in very easy way using #urdu online video lectures short videos. We are offering you the best ways for cs101 final term preparation. We have recorded short video lectures of Microsoft word, Microsoft Excel, Microsoft PowerPoint and Microsoft Access. These videos are free to watch on our official YouTube Channel “TheITeducation.com”. These videos are not recorded for this course CS101 introduction to Computing, but the as per new Scheme and course outline of CS101 Introduction to Computing, but these watch these videos one can get cs101 final term preparation in best way. These CS101 Short videos can be been seen here. Soon we will Publish CS101 Short Notes for download in pdf format. It will be highlighted version and past paper pattern with solved MCqs will be shared soon before VU Final Term exam starting in Feb 2021.
CS101 final term syllabus starts from topic number 160 to onward. The most part of final term syllabus and preparation is the Microsoft Office tools like Microsoft Word Microsoft Excel Microsoft PowerPoint and Microsoft Access. Final term syllabus of CS101 introduction to computing also include the basic concepts of databases and web page development through Dreamweaver application. But more than 80% syllabus of CS101 final term is about the the latest application the data word processing spreadsheet presentations and databases.
CS101 Final Term Preparation – Topic 220-224 – MS Excel Introduction
|opic-220. MS Excel: Introduction||220||Handouts||353|
|Topic-221. MS excel: functions||221||Handouts||355|
|Topic-222. MS Excel: Application Scenarios – I||222||Handouts||358|
|Topic-223. MS Excel: Application Scenarios – II||223||Handouts||359|
|Topic-224. MS Excel: Sorting and Filter||224||Handouts||361|
#theITeducation presents an easy lecture on MS #Excel Formula in #urdu hindi. Working with excel Formulas and functions is considered tough for all students and learners of Microsoft Office. I taught working with formula in my first session of #MSExcel in my Classes. It never happened to my class that students asked me that working with Excel Formula is hard to understand. It is very simple steps in MS Excel how to type Formula in Excel Sheet. How to use Reference / cell address in typing formula in excel. This videos is recorded in my class session of teaching Excel Formula to my students. This will let you know in URDU and Hindi how you can type formula and how easy is working with Excel Formula. Most of the students of non computer classes like BBA, BCOM and Office automation find Excel 2013,2016, 365 Formula working difficult. How to work with Excel, How to to type Excel formula, what are rules of typing formula in Excel . all is explained in urdu/hindi in these two lectures. Excel Formula starts with equal = sign and cell reference is used in stated of cell value. These two excel formula rules are so simple… in this demonstration, I have explained Excel Formula with examples of worksheet. like Income and expenses example. Sales and commission examples.
MS Excel and Features with USED of EXCEL – CS101
MS Excel is a spreadsheet software application. MS Excel is developed by Microsoft and it is part of MS office. When MS Office is installed MS Excel is automatic installed. It is used to create Worksheet. (Ledgers, Bills, merit Lists, mathematical data analysis etc. #MSEXCEL #BCOM #PU https://www.youtube.com/playlist?list=PLeWXTh8yOiXcVU9fOoQTM1tdah2zGLaD5 This is our second video lecture for online classes of BCom and ADP commerce from university of the Punjab Lahore. Computer application for business(CAB) the compulsory subject in Bcom part 1 and ADP Commerce part 1. Today we will discuss and important question computer application in business book for Bcom part 1 classes in online video lecture. What is Microsoft Excel and what are salient features of Microsoft Excel. Microsoft Excel is a spreadsheet software application which is developed by Microsoft and is the part of Microsoft Office Package. When we install Microsoft Office in our computer RPC Microsoft Excel is automatically installed as a worksheet and spreadsheet software in which you can create ledgers bills merit list mathematical data analysis charts and graphs easily. Here is the list of Microsoft Excel features that are commonly used by a student of BCom part 1 and ADP commerce. Creating new workbook Editing workbook Open / Save workbook Securing workbook Copy/Paster Printing worksheet Spelling and Grammar Check clipart Autocorrect Inserting Images, Drawings and Shapes Data Sorting Data filtering Formula and Function Data validation Auto Filling Charts USES of MS EXCel Preparing budget Preparing account ledgers Preparing student merit lists Preparing economics data Research and development Data analysis Using graphs
Using Excel IF Function with Numbers and Text Values
Today Series of Working with excel Formulas and Function. especially IF Function in EXCEL is considered tough for all students and learners of Microsoft Excel. In my previous video I taught about IF Function and its use in result calculation and grade calculation. I have just taught working with Excel formulas and Functions in my first session of #MSExcel in my Classes. Today I will teach you about Use of EXCEL IF Function with Text and Numbers Urdu and Hindi. Here are list of Excel Videos:- It is very simple steps in MS Excel how to type Formula and function in Excel Sheet. How to use Reference / cell address in typing formula and function in excel. These videos were recorded in my class session of teaching Excel Formula and functions to my students. This will let you know in URDU and Hindi how you can type formula and how easy is working with Excel Formula. Just watch and it will become easy for you… I assure you that it would help you and you will enjoy this short trick and video.. Keep supporting theITeducation by sharing its videos and subscribing it.
Thanks Excel Formulas and functions URDU/Hindi | how to work
Excel countif Example in Sales – Excel Formulas and Functions in URDU/ Hindi | working with CountIF
COUNTIF Examples in URDU HINDI Excel Formulas and Functions in URDU HINDI