- 155
- 111 312
MBA Today- by Dr. Chandrakanta Sahoo
เข้าร่วมเมื่อ 24 เม.ย. 2008
knowledge shared is knowledge multiplied.There are enormous trends impacting business and management education at the present time. AI, VR, AR, machine learning, big data, business automation were buzz words long ago are now impacting business to a large extent. The managers today and tomorrow have no choice, but to learn all these technologies and update themselves accordingly from time to time to solder present and future responsibility. Business will continue to be VOLATILE, UNCERTAIN, COMPLEX AND AMBIGUOUS.
I believe, as a faculty member, I should share my knowledge and expertise with the students and business community. I have uploaded some videos on Human Resource, SAP- HR, Data Visualization in Google Data Studio and Microsoft Power BI and Hypothesis with an intention to serve the business and educational fraternity.
I hope, these will be beneficial to you.
Thank You
Dr Chandrakanta Sahoo
(email: chandrakanta2008@gmail.com)
I believe, as a faculty member, I should share my knowledge and expertise with the students and business community. I have uploaded some videos on Human Resource, SAP- HR, Data Visualization in Google Data Studio and Microsoft Power BI and Hypothesis with an intention to serve the business and educational fraternity.
I hope, these will be beneficial to you.
Thank You
Dr Chandrakanta Sahoo
(email: chandrakanta2008@gmail.com)
25 MS EXCEL-Date and Time Formula
Excel offers a variety of date and time functions that allow you to manipulate and calculate dates and times for a wide range of tasks. Here are some of the most commonly used date and time formulas
มุมมอง: 1
วีดีโอ
23 MS Excel- Index and Match
มุมมอง 1ชั่วโมงที่ผ่านมา
The combination of INDEX and MATCH functions in Excel is a powerful alternative to VLOOKUP and HLOOKUP. Unlike VLOOKUP and HLOOKUP, INDEX and MATCH allows for more flexibility, such as searching in any direction (both vertical and horizontal) and working with unsorted data. The INDEX function returns the value of a cell in a given table or range, based on its row and column number. The MATCH fu...
22 H LOOK UP
มุมมอง 42 ชั่วโมงที่ผ่านมา
The HLOOKUP (Horizontal Lookup) function in Excel is used to search for a value in the first row of a table and return a value in the same column from a specified row. It is ideal for data arranged horizontally across rows rather than vertically. lookup_value: The value you want to search for in the first row of the table. table_array: The range of cells that contains the data. This includes th...
21 MS Excel- V Look Up
2 ชั่วโมงที่ผ่านมา
The VLOOKUP (Vertical Lookup) function in Excel is used to search for a value in the first column of a table and return a value in the same row from a specified column. It is particularly useful for looking up and retrieving data from large tables. lookup_value: The value you want to search for in the first column of the table. table_array: The range of cells that contains the data. This includ...
20 MS Excel- Basic Statistical Formula
มุมมอง 114 ชั่วโมงที่ผ่านมา
Excel provides several built-in functions for performing basic statistical calculations. These are widely used for analyzing and interpreting data. AVERAGE: Calculates the arithmetic mean of a range of numbers. For example, AVERAGE(A1:A10) calculates the average of values in cells A1 to A10. COUNT: Counts the number of cells in a range that contain a numeric entry. COUNTA: Counts everything, in...
19 MS Excel- Count IFS and Average IFS
มุมมอง 64 ชั่วโมงที่ผ่านมา
COUNTIFS and AVERAGEIFS are advanced versions of the COUNTIF and AVERAGEIF functions. They allow you to apply multiple criteria to different ranges when counting or averaging values. These functions are particularly useful when you need to consider multiple conditions.
18 MS Excel- Sum IF
มุมมอง 84 ชั่วโมงที่ผ่านมา
The SUMIF function in Excel is used to sum the values in a range that meet a specified condition. It’s a powerful tool for conditional summing, allowing you to add up values that match a certain criterion.
17 MS Excel- Average If
มุมมอง 54 ชั่วโมงที่ผ่านมา
The AVERAGEIF function in Excel calculates the average (arithmetic mean) of cells that meet a specified condition. It’s particularly useful when you want to find the average of a subset of values based on a certain criterion.
16 MS Excel- Count IF
มุมมอง 74 ชั่วโมงที่ผ่านมา
The COUNTIF function in Excel is used to count the number of cells within a range that meet a specified condition. It’s a great tool for analyzing data by filtering and counting values based on criteria you set.
15 MS Excel- If + Not Formula
มุมมอง 187 ชั่วโมงที่ผ่านมา
The NOT function combined with an IF formula in Excel allows you to reverse the logical outcome of a condition. It returns TRUE if the condition is false and FALSE if the condition is true.
14 MS Excel- If + OR Formula
มุมมอง 47 ชั่วโมงที่ผ่านมา
The OR function combined with an IF formula in Excel allows you to test multiple conditions and return a result if any condition is true. -OR(condition1, condition2, ...): Checks if at least one condition is true. -value_if_true: The result if any condition is true. -value_if_false: The result if all conditions are false. This combination is useful when you want to return a result based on mult...
13 MS Excel- And + If Formula
มุมมอง 139 ชั่วโมงที่ผ่านมา
The AND function combined with an IF formula in Excel allows you to test multiple conditions and return specific results based on whether all conditions are true. -AND(condition1, condition2, ...): Checks if all conditions are true. -value_if_true: The result if all conditions are true. -value_if_false: The result if any condition is false.
12 MS Excel- And Or Formula
มุมมอง 149 ชั่วโมงที่ผ่านมา
The AND and OR formulas in Excel are logical functions used to test multiple conditions within a formula. They are often combined with the IF function to make decisions based on several criteria. AND Formula The AND function checks if all specified conditions are true. OR Formula The OR function checks if at least one of the specified conditions is true.
11 MS Excel- Nested If Formula
มุมมอง 159 ชั่วโมงที่ผ่านมา
A nested IF formula in Excel is when you use multiple IF functions inside each other to test multiple conditions. This allows for more complex decision-making with multiple outcomes.
7 MS Excel- Understanding Cell References I
มุมมอง 159 ชั่วโมงที่ผ่านมา
7 MS Excel- Understanding Cell References I
5- MS Excel- Sort and Filter functionality in MS Excel
มุมมอง 189 ชั่วโมงที่ผ่านมา
5- MS Excel- Sort and Filter functionality in MS Excel
4 MS Excel- Navigation, indexing and autofill Functions
มุมมอง 209 ชั่วโมงที่ผ่านมา
4 MS Excel- Navigation, indexing and autofill Functions
3 MS Excel- Number Formatting in MS Excel
มุมมอง 229 ชั่วโมงที่ผ่านมา
3 MS Excel- Number Formatting in MS Excel
2 MS Excel- Home - Font and Alignment functionality
มุมมอง 269 ชั่วโมงที่ผ่านมา
2 MS Excel- Home - Font and Alignment functionality
1 MS Excel- Understanding its Interface
มุมมอง 449 ชั่วโมงที่ผ่านมา
1 MS Excel- Understanding its Interface
Tq sir
Hello sir I am Ahsan from Pakistan I have learned sap hcm from your channel , I request you to make more details video related to sap hcm
How the number series is decided here ?what if we want to change the number series
Sir, I want to ask, that is the content of 28 vds that you uploaded in youtube, is that enough and covers all configuration/implementation parts, and if we look these, we are completly ready for interviews? pls tell.
Dear Mr Sahoo, Excellent
How to download sap can you make vedio on it please
Sir, in 24:20 you put a tickmark for "No planned working hours". I dont understand why you make a tick mark because you make a daily work schedule from 9 to 18. I am confused, why it is "no planned working hours "
Mr Chandrakanta, thanks for all the sessions you made and for all of the effort to educate us. The sessions were all very helpful. Wish you the best.
587 is not explained
Sir, you said that we have created Roster. I am not sure. What is roster and which video is that?
Hello Sir, i have the same question like the person below. Is there any part III of this session?
Should in 9:47 not the Position be described by the Job? Because you said "The job is described by the position" and i think this is wrong interpretation. Additionally i want say the part between 4:15 and 5:35 it was so confusing. Because you tried to create relationship to the position, but confused with choosing "Role" or whatever. You find out, that it was not the right way. Thats why I would suggest to cut all this part in this video.
First of all many thanks for the great tutorials. I have questions in this tutorial. Can you say me what relationsships are listed for the CEO? I think its clear, that he belongs to (A003) to Org Unit Corporate. But is he reporting to someone, because there is no other position above him? Second question, is he the line su of all three presidents? Because they are in another org unit. Unfortunately you didnt open the relationsship view of the CEO :D Thats why this questions.
Can you please share the excel sheet for reference?
18:43
Hi, would like to appreciate your efforts to provide this valuable content. Is there any simulation images of SAP s4 /Hana to practise?
Thank you so much sir
Can you give your number sir I want to connect you
Which software is this?
SAP
Thank u soo much sir i have search so many video but did not understand the work of hcm department but i saw your video and understood in one attempt that what we have to do
Sir, My system is allowing me to enter only one digit in DWS Grouping, where we link PS Grouping and DWS Grouping. Can you please help me in that.
21 Question you have mention the ans as a, d, e but e option is not mentioned.
Pl. ignore e.
Voice is too low
If we maintain the employee group * the system will accept or not. I hav an error when I maintain the feature PINCH. (Unforeseeable errors while generating. Plz read the long text.)
audio is too low
I want to learn HCM SAP module for Functional consultant
Hi
Its very clear that u r a traniner ..and u never worked in real world
Thank you sir your videos are very very useful and helfull, thank you very much sir for these help to many perople and me, Ishwar may help you....
Thank you. Keep watching.
Thank you very much sir. This is so helpful
Thank you. Keep watching
Hi Sir, Very good explanation of the concepts... Its very easy to understand and learn.. Thanks for making this video very simple and in detail.. I Would request you to share the PPT & the Excel files for reference.. It will really help me.. Thanks..
Write me an email with a request. chandrakanta2008@gmail.com
The audio is tooo low! ;(
and meal coupon configuration also
can you please share OVERTIME AND SUBSTITUTION Configuration
Nice explaination
Thank you Sir , informative video.
Most welcome
Hi can I get ur contact details
Please make a video on additional charge position in sap
If single person have more than one charge of same department
Hi Sir.... Thanks for the informative video... Request you to share the Excel copy as well
Thank u so much sir. U explained it very well
𝓟Ř𝔬𝓂𝔬𝐒ϻ
Google data studio is new to me, many thanks for such an exciting introduction ...
A Productive and Informative Session
Good afternoon sir 🙏🏻🙏🏻🙏🏻
Thank u sir
Thanks
HI, Sir The sessions are are very clear and easy to understand. Is there any part III session for this, as it stopped in the mid
very well explained
Plz could you share the contact details