Beginner to Pro FREE Excel Data Analysis Course

Excel is a powerful tool that is used by businesses and individuals to analyze data. Whether you're just starting out or you're an experienced data analyst, Excel has a wide range of features that can help you make sense of complex data sets. Here are 15 of the most commonly used Excel tools:

1. SUM:The SUM function in Excel is used to calculate the sum of a range of cells. It is a very basic and commonly used function, which takes a range of cells as an argument and returns their sum. The syntax of the function is very simple, and it can be written as "=SUM(range)" where "range" refers to the range of cells that need to be added. For example, if you want to calculate the sum of cells A1 to A5, you would write "=SUM(A1:A5)". This would return the sum of the values in those cells. The SUM function can also be used with other functions and formulas to perform more complex calculations. For instance, you could use the SUM function to calculate the total revenue from a set of sales data. Overall, the SUM function is a fundamental tool in Excel that can be used in a wide range of applications.
2. AVERAGE: The AVERAGE function in Excel is used to calculate the arithmetic mean of a range of cells. It is another basic and commonly used function, which takes a range of cells as an argument and returns their average. The syntax of the function is very similar to the SUM function, and it can be written as "=AVERAGE(range)" where "range" refers to the range of cells that need to be averaged. For example, if you want to calculate the average of cells A1 to A5, you would write "=AVERAGE(A1:A5)". This would return the average value of the values in those cells. The AVERAGE function can also be used with other functions and formulas to perform more complex calculations. For instance, you could use the AVERAGE function to calculate the average test score for a set of student data. It is important to note that the AVERAGE function does not include any cells that contain text or are empty, and it can handle negative numbers as well. Overall, the AVERAGE function is a powerful tool in Excel that is useful for a variety of purposes.
3. COUNT: Counts the number of cells in a range that contain numbers.
4. MAX: Returns the highest value in a range of cells.
5. MIN: Returns the lowest value in a range of cells.
6. IF: Returns one value if a condition is true and another value if it is false.
7. VLOOKUP: Searches for a value in the first column of a table and returns a value in the same row from a specified column.
8. INDEX: Returns the value of a cell in a specified row and column of a table or range.
9. MATCH: Searches for a value in a range of cells and returns the relative position of that value.
10. CHARTS: Creates a visual representation of data in the form of a chart or graph.
11. PIVOT TABLES: Summarizes large amounts of data by grouping it into categories and displaying the results in a table format.
12. CONDITIONAL FORMATTING: Applies formatting to cells based on certain conditions, such as cell values or formulas.
13. SORT AND FILTER: Organizes data in ascending or descending order and filters out unwanted data based on specific criteria.
14. DATA VALIDATION: Restricts the type of data that can be entered into a cell, such as numbers or dates.
15. FORMULAS: Performs calculations using mathematical operators, functions, and cell references.

In conclusion, Excel data analysis is a valuable skill that can help you make sense of complex data sets and communicate your findings to others.

 NIT Arunachal Pradesh, Govt. of India

National Institute of Technology Arunachal Pradesh is a public technical and research institute near Itanagar, the capital of Arunachal Pradesh.

 Visit: NIT Arunachal Pradesh

What is DO-Follow and No-Follow links  Difference between Do-Follow and No-Follow

In HTML, a "dofollow" link is a link that passes on "link juice" to the linked webpage. In other words, a dofollow link helps to improve the ranking of the linked webpage in search engines like Google. On the other hand, a "nofollow" link is a link that does not pass on link juice to the linked webpage. Nofollow links are often used to link to untrusted content or to tell search engines not to follow a particular link.

In general, it is good practice to use dofollow links when linking to high-quality, trusted websites, and to use nofollow links when linking to untrusted or low-quality websites. This helps to improve the overall quality of the web and make it easier for search engines to understand the content and context of the pages on the web.

Dofollow links play a crucial role in enhancing the visibility and search engine ranking of the linked webpage. By passing on valuable "link juice," these links contribute to the authority and reputation of the receiving webpage. As search engines like Google crawl and index the web, they consider dofollow links as signals of trust and relevance. Consequently, websites that receive a substantial number of dofollow links tend to enjoy higher rankings in search engine results pages (SERPs).

When utilizing dofollow links, it is essential to prioritize reputable and high-quality websites. By linking to authoritative sources, you establish a connection between your content and trusted information, which positively influences the perceived value and credibility of your webpage. Furthermore, when reputable websites link back to your content through dofollow links, it can significantly improve your own website's search engine visibility and organic traffic.

On the other hand, nofollow links serve a different purpose. These links are typically employed in scenarios where you want to link to content that may not be entirely trustworthy or reliable. Nofollow links indicate to search engines that they should not pass on link juice to the linked webpage. This approach helps prevent the unintentional endorsement or association with potentially harmful or low-quality websites.

By implementing a strategic combination of dofollow and nofollow links, webmasters and SEO practitioners can guide search engines in understanding the overall quality and relevance of their web content. The judicious use of dofollow and nofollow links fosters a healthier online ecosystem, making it easier for search engines to decipher the context, relationships, and significance of various web pages. Ultimately, this contributes to more accurate search results, enhanced user experiences, and a more reliable web environment.

Author: Digital Sam Media

 

 

Another Source, Click here to view video

Right way to Back-linking, Click here to view video.

 

SWAYAM

SWAYAM is a programme initiated by Government of India and designed to achieve the three cardinal principles of Education Policy viz., access, equity and quality. The objective of this effort is to take the best teaching learning resources to all, including the most disadvantaged. SWAYAM seeks to bridge the digital divide for students who have hitherto remained untouched by the digital revolution and have not been able to join the mainstream of the knowledge economy.

 VISIT  SWAYAM WEBSITE

 

Meta Certified Digital Marketing Associate

Meta Certified Digital Marketing Associates understand the value that advertising on Meta technologies can deliver for businesses and they can use foundational tools to build campaigns. 

Meta Certified Digital Marketing Associate Course

Video specs required for different social media platforms

Facebook feed/watch

• Recommended aspect ratios: Landscape or portrait

• File formats: MP4 or MOV recommended

Instagram feed

• Maximum width: 500 px

• Recommended aspect ratio: Landscape or square

• File formats: MP4 or MOV

Instagram Stories:

• Resolution: 1080 x 1920 px

• Recommended aspect ratio: Portrait (9x16)

• File formats: MP4 or MOV

IGTV:

• Minimum resolution: 720 px

• Recommended aspect ratio: 16:9 or 9:16

• vFile formats: MP4

YouTube

• Maximum resolution: 3840 x 2160 px

• Recommended aspect ratio: 16:9

• File formats: MOV, MPEG4, MP4, AVI, .WMV, MPEGPS, FLV, 3GPP, WebM

Twitter:

• Recommended resolution: 1200 x 1200 pixels (600 x 600 px minimum)

• Recommended aspect ratio: Square, horizontal or portrait

• File formats: MOV or MP4

 

NEW Sony Vlogging Camera ZV-1F Unboxing and review

 

 DJI - Introducing DJI Action 2

 

 

 GoPro Hero 11: The Action Camera for Everyone

 

How Zencastr works | A step by step recording guide using Zencastr

 

Garageband Tutorial - Learn Under 10 Minutes

 

Infosys Springboard .Flagship Platform to accelerate 21st Century Digital Learning

Infosys Springboard

Flagship Platform to accelerate 21st Century Digital Learning

 In alignment with the Infosys ESG Vision 2030 to enable digital skills at scale, Infosys Springboard has been identified as a flagship digital learning platform to empower people, communities, and society with skills to be successful in the 21st Century. 

 

Click here to visit Infosys Springboard

 

 How to Set Up Facetime

How to Use Microsoft Teams Effectively | Your COMPLETE Guide

 How To Use Google Hangouts

 

 How to Use the Zoom Meeting App

How To Use Skype

 

Job Openings - Indian Institute of Management Kozhikode - IIMK

Indian Institute of Management Kozhikode - IIMK

 Click link below to visit the Career page of IIMK

Job Openings

INSTITUTE OF HUMAN BEHAVIOUR AND ALLIED SCIENCES

1. Institute of Human Behaviour & Allied Sciences (IHBAS) was established in compliance with the directives of the Hon'ble Supreme Court in response to a public interest litigation in 1993. 
2.  The Institute is an autonomous body registered under the Societies Act 1860, funded jointly by Ministry of Health and Family Welfare, Government of India and Government of NCT of Delhi. 
3. As an autonomous body, the institute has its Memorandum of Association and Rules and Regulations duly approved under the Societies Act. Minister for Health, Govt. of NCT of Delhi is the President and Chief Secretary, Govt. of NCT of Delhi is the Chairman of the Executive Council of the institute.

VISIT INSTITUTE

 

 Planning Sunrise and Sunset Photos with SunCalc