Overview

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.TEXT FUNCTIONCLEAN 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 stringLOGICAL FUNCTIONSAND: 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.DATE AND TIME FUNCTIONSDATE: 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 FunctionsHLOOKUP: 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_valueThe value that you want to look for, in the first row of the supplied data arrayTable_arrayThe data array or table, that you want to search the first row of, for the supplied lookup_valueRow_index_numThe 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_valueThe value that you want to look for, in the left hand column of the supplied data arrayTable_arrayThe data array or table, that you want to search the left hand column of, for the supplied lookup_valuecol_index_numThe 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 valueFALSE 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 FUNCTIONSSUM: The Excel SUM function adds together a supplied set of numbers and returns the sum of these valuesPRODUCT: 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 powerSQRT: 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 FunctionsMAX: 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 FunctionsPMT: 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])rateThe interest rate, per periodnperThe number of periods over which the loan or investment is to be paidpvThe present value of the loan / investment[fv]An optional argument that species the future value of the loan/ investment, at the end of nper paymentsIf 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 periodThe type argument can have the value 0 or 1, meaning:The payment is made at the end of the periodThe payment is made at the beginning of the periodIf 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 formulasCollaborate: Work with others in real-time, and track edits with a revision historyShare: Share files and folders with others, and choose whether they can view, edit, or comment on themMicrosoft Excel for the web is a cloud-based online spreadsheet program that allows users to create, edit, and view workbooks in a browser:FeaturesUsers 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 fileChatGPT 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 analysisChatGPT 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 frequentlySocial 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 usersBuild a community: Interact with your audience by responding to comments, shares, and likes, and following and engaging with influencersMaintain and optimize: Maintain and optimize your profiles, and monitor your reputationSocial 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 objectivesChoose your platformsIdentify your audienceConnect with your audienceOptimize and adjust, then repeatblog 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 GoogleSEO optimization: Optimize content for search engine optimization (SEO)Brand authority: Build brand authority to attract more prospects and grow your audienceMonetization: Use ads, affiliate marketing, or sell products to monetize your blogSome other aspects of blog marketing include:Recommendations and reviews: Use recommendations and reviews from the bloggerThird-party blogs: Promote your content on third-party blogsCross-syndication: Cross-syndicate information across multiple blogsViral marketing: Use viral marketing methods to build an interest group around your blogAffiliate 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 transparentlyHelping audiences discover reviewsMaking decisions easyWriting high quality, transparent reviewsGoogle Ads is an online advertising platform that allows businesses to create and display ads to reach potential customers:How it worksAdvertisers 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.BenefitsGoogle Ads can help businesses:Attract new customersPromote products and servicesIncrease website trafficRaise awarenessFeaturesAdvertisers can:Create and manage ad campaigns onlineSet their own budgetChoose where their ads appearMeasure the impact of their adsRankingAds 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 researchKeyword research can help advertisers target relevant search queries and create quality ads.Quality ScoreAdvertisers 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 awarenessIncrease visibilityGet new leadsConvert leads into customersMeasure 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.

Skills

Reviews