Learn MS Excel (Basic to Advanced) Complete Course in hindi

About Learn MS Excel (Basic to Advanced) Complete Course in hindi

FUNCTION-A function is a special prewritten formula that takes a value or values, performs an operation and returns a value or values. Simplifies and shortens formulas in your worksheets, especially those that perform lenghty or complex calculations. 1. TEXT FUNCTION

CLEAN Function- The Excel CLEAN functions takes a supplied text spring and removes all non printable characters. The Function is designed to remove the non printable characters.

TRIM Function -The Excel TRIM function removes duplicate spaces, and spaces at the start and of a text string.

LOWER Function: The Excel LOWER function converts in a supplied text string to lower case.

PROPER Function: The Excel PROPER function converts all characters in a supplied text string to proper case(i.e the first character in each word is upper case and all other characters are lower case)

UPPER: The Excel UPPER function Converts all characters in a supplied text string to upper case.

CONCATENATE: The Excel CONCATENATE function joins together two or more text strings.

LEN: The Excel LEN function returns the length of a supplied text string 1. LOGICAL FUNCTIONS

AND: The Excel AND function tests a number of user defined conditions and returns TRUE if ALL of the conditions evaluate to TRUE, or FALSE otherwise.

OR: The Excel OR function tests a number of user defined conditions and returns TRUE if ANY of the conditions evaluate to TRUE, or FALSE otherwise. NOT: The Excel NOT function returns a logical value that is the opposite of a user supplied logical value or expression (i.e. returns FALSE is the supplied arguments is TRUE and returns TRUE if the supplied argument is FALSE).

IF: The Excel IF function tests a user defined condition and returns one result if the condition is TRUE , and another result if the condition is FALSE. 1. DATE AND TIME FUNCTIONS

DATE: The Excel DATE function, when supplied with integers representing a year, month and day returns an Excel date.

TIME: The Excel Time function accepts three integer arguments representing hours, minutes and seconds, and returns an Excel time.

NOW: The Excel Now function returns the current date and time.

TODAY: The Excel Today function returns the current date.

DAY: The Excel DAY function, when supplied with a date, returns an integer representing the day of the month( From 1- 31).

MONTH: The Excel MONTH function when supplied with a date, returns an integer representing the month of the Year ( from 1-12).

YEAR: The Excel YEAR returns the Year from a user supplied date.

Lookup and Reference Functions

HLOOKUP: The Excel HLOOKUP function ‘looks up’ a given value in the top row of a data array (or table), and returns the corresponding value from another row of the array. The syntax of the function is: HLOOKUP ( lookup_value, table_array, row_index_num, [range_lookup]) Lookup_value The value that you want to look for, in the first row of the supplied data array Table_array The data array or table, that you want to search the first row of, for the supplied lookup_value Row_index_num The row number, within the supplied array, that you want the corresponding value to be returned from [range_lookup] An optional logical argument , which can be set to TRUE or FALSE, meaning: TRUE if the function cannot find an exact match to the supplied_ lookup, it should use the closest match below the supplied value (Note: If range_lookup is set to TRUE, the top row of the table_array must be in ascending order) FALSE if the function cannot find an exact match to the supplied lookup_value, it should return an error.

VLOOKUP: The Excel VLOOKUP function ‘looks up’ a given value in the left hand column of a data array (or table), and returns the corresponding value from another column of the array. The syntax of the function is: VLOOKUP ( lookup_value, table_array, col_index_num, [range_lookup]) Lookup_value The value that you want to look for, in the left hand column of the supplied data array Table_array The data array or table, that you want to search the left hand column of, for the supplied lookup_value col_index_num The column number, within the supplied array, that you want the corresponding value to be returned from [range_lookup] An optional logical argument , which can be set to TRUE or FALSE, meaning: TRUE if the function cannot find an exact match to the supplied_ lookup, it should use the closest match below the supplied value FALSE if the function cannot find an exact match to the supplied lookup_value, it should return an error.

LOOKUP: The Excel LOOKUP function ‘looks up’ a supplied value within a data set and returns the corresponding value from a second data set. If the function fails to find an exact match to the supplied ‘lookup’ value, it uses the largest value that is less than or equal to the supplied ‘lookup’ value. The format of the function is: LOOKUP(lookup_value, lookup_vector, result_vector) 5)MATH AND TRIG FUNCTIONS

SUM: The Excel SUM function adds together a supplied set of numbers and returns the sum of these values

PRODUCT: The Excel PRODUCT function returns the product(multiplication) of a supplied list of numbers.

POWER: The Excel power function calculates a given number, raised to a supplied power

SQRT: The Excel SQRT function calculates the positive square root of a supplied number.

CEILING: The Excel CEILING function rounds a supplied number up, away from zero to the nearest multiple of a specified significance.

The format of the function is: CEILING (number, significance)

SIN: The Excel SIN function calculates the sine of a given angle (which is supplied in radians) 6)Excel Statistical Functions

MAX: The Excel MAX function returns the largest value from a supplied set of numerical values.

MIN: The Excel MIN function returns the smallest value from a supplied set of numerical values.

MEDIAN: The Excel MEDIAN function returns the statistical median ( the middle value) of a list of supplied numbers.

AVERAGE: The Excel AVERAGE function returns the arithmetic mean of a list of supplied numbers. 7) Excel Financial Functions

PMT: The Excel PMT function calculates the constant periodic payment required to pay off (or partially pay off) a loan or investment, with a constant interest rate, over a specified period. The format of the function is PMT( rate, nper, pv, [fv], [type]) rate The interest rate, per period nper The number of periods over which the loan or investment is to be paid pv The present value of the loan / investment [fv] An optional argument that species the future value of the loan/ investment, at the end of nper payments If omitted, [fv] takes on the default value of [type] An optional argument that defines whether the payment is made at the start or the end of the period The type argument can have the value 0 or 1, meaning: 1. The payment is made at the end of the period 1. The payment is made at the beginning of the period If the [type] argument is omitted, it takes on the default value of 0. ( denoting payments made at the end of the period). Google Sheets is

a free, web-based spreadsheet application that allows users to create, edit, and format spreadsheets

:

Create and format: Add, edit, or format text, numbers, or formulas

Collaborate: Work with others in real-time, and track edits with a revision history

Share: Share files and folders with others, and choose whether they can view, edit, or comment on them Microsoft Excel for the web is

a cloud-based online spreadsheet program that allows users to create, edit, and view workbooks in a browser

:

Features

Users can create multiple spreadsheets, or worksheets, within one workbook. They can also save changes automatically, and colleagues can always work on the latest version of the file

ChatGPT is an AI tool that can be used with Microsoft Excel to help with tasks like data analysis, formula generation, and automating repetitive tasks

:

Data analysis

ChatGPT can help analyze data trends, identify outliers, and generate charts or graphs. For example, you can use ChatGPT to analyze customer support data to see what issues are being discussed most frequently Social media marketing (SMM) is

a digital marketing strategy that uses social media platforms to promote a brand, increase sales, and drive traffic to a website

:

Create content: Create and post content like text, images, videos, and stories that represent your brand and engage users

Build a community: Interact with your audience by responding to comments, shares, and likes, and following and engaging with influencers

Maintain and optimize: Maintain and optimize your profiles, and monitor your reputation Social media marketing is a constantly evolving field, with new features and platforms emerging regularly. Your strategy will differ based on which social networks your audience spends the most time on. For example, TikTok is a good platform for small businesses because of its algorithm, which recommends videos to users based on their previous activity. LinkedIn is a good platform for B2B marketing, with features like LinkedIn Pulse for publishing articles, LinkedIn Ads for targeted campaigns, and LinkedIn Learning for educational content.

Here are some tips for developing a social media marketing strategy:

Define your goals and objectives

Choose your platforms

Identify your audience

Connect with your audience

Optimize and adjust, then repeat

blog marketing is

a content marketing strategy that uses blogs to promote a business, brand, or service

:

Content creation

: Create and publish high-quality, relevant content regularly to attract organic traffic from Google

SEO optimization

: Optimize content for search engine optimization (SEO)

Brand authority

: Build brand authority to attract more prospects and grow your audience

Monetization

: Use ads, affiliate marketing, or sell products to monetize your blog

Some other aspects of blog marketing include:

Recommendations and reviews

: Use recommendations and reviews from the blogger

Third-party blogs

: Promote your content on third-party blogs

Cross-syndication

: Cross-syndicate information across multiple blogs

Viral marketing

: Use viral marketing methods to build an interest group around your blog

Affiliate Network is a program that allows affiliates to earn a commission for referring customers to a business. Affiliate marketing is

a revenue-sharing model where a third-party, like a blogger or influencer, promotes a business's products or services to help the business meet its sales or marketing goals

. In return, the affiliate receives a percentage of the sales or customer traffic generated by their marketing efforts. Here are some benefits of affiliate marketing: Increase sales, Attract more web traffic, Improve brand awareness, and Connect with the affiliate's audience. Google Analytics 4 can be used to measure affiliate marketing. Some best practices for affiliate marketing include:

Sharing reviews transparently

Helping audiences discover reviews

Making decisions easy

Writing high quality, transparent reviews

Google Ads is

an online advertising platform that allows businesses to create and display ads to reach potential customers

:

How it works

Advertisers bid on keywords and pay only when someone clicks on their ad. Ads can appear in Google search results, mobile apps, videos, and on other websites.

Benefits

Google Ads can help businesses:

Attract new customers

Promote products and services

Increase website traffic

Raise awareness

Features

Advertisers can:

Create and manage ad campaigns online

Set their own budget

Choose where their ads appear

Measure the impact of their ads

Ranking

Ads are ranked based on a combination of factors, including the ad's relevance to the search query, the ad's Quality Score, and the bid amount.

Keyword research

Keyword research can help advertisers target relevant search queries and create quality ads.

Quality Score

Advertisers with high Quality Scores receive rewards, such as lower cost per click (CPC) and better ad placement.

Facebook ads are

paid messages that appear on Facebook, Messenger, and other apps and websites

. They can be a powerful marketing tool that can help businesses:

Build brand awareness

Increase visibility

Get new leads

Convert leads into customers

Measure performance: Facebook ads can be customized based on a variety of factors, including: Gender, Age, Marital status, Career field, Interests, Location, and Pain points. Facebook ads can appear in the following places: Feed on desktop, Feed on mobile, and Right column of Facebook on desktop. Facebook ads can be created and run using self-serve tools, and their performance can be tracked with reports.