LearnPick Navigation
Close

Study Notes. Presentations. Videos.

Collection of Study Notes, PowerPoint Presentations, and Videos

Video Lessons for Basic Computer

  • New chart types in Excel 2019/Office 365 || Map Chart || Funnel Chart (हिंदी में)

    In this video, we will talk about the new chart types in excel 2019/office 365 i.e. map chart & funnel chart. let’s have a look at each of the new chart types which are now been updated in excel 2019 or office 365: 1) map charts: a chart type which shows show categories across geographical regions. it uses microsoft bing search engine and fetches the visual presentation of each respective data point on a chart. example: let’s take an example of indian population by state and plot it on a map. select the data - insert - map and select the predefined map. this will create an indian geographical region. 2) funnel chart: it shows values across multiple categories and forms the shape of a funnel (in descending order). example: here we have a number of customers categorized by age groups who are using our company mobile application to pay bills. to create a funnel chart go to insert tab - charts group - insert funnel select the funnel chart.
    Advanced Excel, Basic Computer, MS Office
    179 views
  • Precision Selection in Excel 2019 or Office 365 (हिंदी में)

    In this video, we will talk about precision selection in excel 2019/office 365. let’s understand what is precision selection: a precision selection means accurate selection. in earlier versions of excel, if we end up selecting a cell which we wanted to ignore, we were not given any option of deselecting those un-wanted cells. but now in excel 2019 or office 365, we can deselect any unwanted selection by using a control key.
    Advanced Excel, Basic Computer, MS Office
    197 views
  • Dependent Drop Down list in Excel (हिंदी में)

    In this video, we will talk about how to create a dependent dropdown list in excel. to create a dependent dropdown list we need to use the data validation feature of excel along with indirect function and naming convention concept. first, we need to assign a name to a range of all the cell having the content of subcategory and use the indirect function to link the same in data validation dialogue box.
    Advanced Excel, Basic Computer, MS Office
    195 views
  • Problem of unwanted names when we create a copy of the sheet in Excel (हिंदी में)

    In this video, we will talk about “the name "abc" already exists. click yes to use that version of the name, or click no to rename the version of "abc" you're moving or copying” error in excel. sometimes when we move and copy one or multiple worksheets from one excel workbook to another, excel tries to move the names along with it too, this causes “the name "abc" already exists. click yes to use that version of the name, or click no to rename the version of "abc" you're moving or copying” error in excel. to get rid of the same, we need to go to the “formula” tab – name manager and then delete all the unwanted names.
    Advanced Excel, Basic Computer, MS Office
    182 views
  • How & when to freeze cell reference in Excel (हिंदी में)

    In this video, we will talk about how to freeze cell reference in excel (in hindi). the beauty of excel is that we just need to apply a function for only one record in the entire data base and the moment we copy and paste it down it applies to the complete data. sometimes we need to change this property of excel, as we can’t, so excel has given us an option of freezing any cell reference by adding a “$” before the cell reference. for any excel user, its very important to know where to put the “$” sign. excel facilitate 3 types of cell references. let’s understand them one by one. 1). relative reference: this is a default reference in excel. whenever we refer to a cell and copy the same reference and paste it in any other cell, the cell reference changes accordingly. this is the heart of excel. 2). absolute reference: putting “$” sign before column and row is known as an absolute reference e.g. “$a$1”. at times we would like to keep a cell reference or a range static, there we use such reference. 3). mixed reference: putting “$” sign either before column or before row termed as mixed reference. when we would like to deliberately want the reference to be changed either side then this reference is to be used.
    Advanced Excel, Basic Computer, MS Office
    135 views
  • What is a polygon

    Concave polygon - each interior angle is less than 180 degrees. convex polygon - at least one interior angle measure is greater than 180 degrees types of polygons - depending on no. of sides diagonal - a line joining the non-adjacent vertices of a polygon
    Basic Computer, Mathematics, MS Office
    123 views
  • Introduction to Operating System

    Introduction to operating system in hindi.
    Basic Computer, Computer Science
    297 views
  • Roots of Quadratic equations

    How to calculate roots of quadratics equation by very short tricks
    Accountancy, Accounts, Aeronautical, AIEEE, Banking & Finance, Basic Computer, C, C++, Commerce Subjects, Computer Science, Electrical, Electronics, GMAT, GRE, IBPS, IIT JEE Mains, Management Subjects, Mathematics, MBA, Mechanical, Mental Mathematics, School level computer, Statistics
    733 views
  • Partial Differentiation: Eulers Theorem 1

    This video talks about the euler's theorem which is one of the very much helpful tool in solving the partial differential equations.
    Basic Computer, Mathematics, Physics
    402 views

Query submitted.

Thank you!

Drop Us a Query:

Drop Us a Query