UKN Eduzone

MODULE 2 NOTES BUSINESS WORKSHEET( MS EXCEL) WORK SHEET FUNDAMENTALS 🔽WORK SHEET  A worksheet in Excel is a single digital page or spreadsheet made of rows and columns where enter, organize, and calculate data. 🔽CREATION OF WORKSHEET  ♦️Open Excel: Launch Microsoft Excel on your computer. ♦️New File: Click File then select New. ♦️Blank Document: Choose Blank Workbook to open a new spreadsheet grid. ♦️Add Sheets: Click the New Sheet (+) plus icon at the bottom tab area to insert additional worksheets. CELL ENTRY IN EXCEL To enter data in a cell in Microsoft Excel, click the cell once, type your content, and press Enter or Tab to save it. Basic Data Entry Steps • Select a cell: Click any cell on the grid to make it active. • Type data: Enter numbers, text, or dates using your keyboard. • Confirm entry: Press Enter to save and move down, or press Tab to save and move right. • Cancel entry: Press the Esc key while typing to clear the cell without saving. CELL REFERENCE  A c...

The Cooperative Planning Committee / Saraiya Committee. The Cooperative Planning Committee was appointed by the Government of India in January 1945 under the chairmanship of Shri R.G. Saraiya to draw up a formal blueprint for the future development of the cooperative movement. Main Objectives and Targets 1.Coverage Targets:  Fixed a major target to bring 50% of all villages and 30% of the rural population under the scope and fold of the cooperative movement within a period of 10 years. 2.Multi-Purpose Societies (MPCSs):  Recommended that village primary credit societies expand their functions beyond just issuing credit to cover all aspects of daily life and business for farmers and artisans—effectively turning them into multi-purpose societies. 3.Broadening Sectors:  Proposed organizing specialized cooperatives for various economic activities, including agricultural marketing and processing, animal husbandry, fisheries, land reclamation, small and subsidiary industries, l...

SPEADSHEET APPLICATION IN FINANCIAL ANALYSIS  🔽BASICS TO INTERMEDIATE FUNCTIONS 1.SUM The SUM function in Microsoft Excel  adds numerical values, cell references, or entire ranges together. Basic Syntax=SUM(number1, [number2], ...) A range uses a colon, like =SUM(A2:A10) Separate individual cells or distinct ranges with commas, like =SUM(A2:A5, C2:C5) 2.AVERAGE AVERAGE function in Excel calculates the arithmetic mean of a range of numbers by adding them together and dividing by the count of numeric entries. Syntax The basic syntax for the function is:=AVERAGE(number1, [number2], ...) Common Uses 1.Find a Mean Value:  Quickly compute the average score, temperature, or sales figure across a row, column, or custom cell range. 2.Analyze Financial Data:  Determine average monthly expenses, mean quarterly revenues, or average unit pricing. 3.Track Performance Metrics:  Calculate average employee hours, student test scores, or sports statistics. 3.COUNT FUNCTION ...

Informatics Tools notes MODULE 1 (BALANCE NOTES) PAGE SET UP HEADER A header in Microsoft Word is a dedicated space at the top margin of a page that repeats automatically on every page in  document. Steps to Insert a Header 1.Open your document in Microsoft Word. 2.Click the Insert tab at the top of the screen. 3.Click Header in the Header & Footer group. 4.Choose a built-in style from the menu or select Edit Header to type  text. 5.Type  desired text, page numbers, or date into the header area. 6.Click Close Header and Footer on the ribbon (or press Esc) when  finished. Short cut method   Double-click directly on the top margin (the very top white space) of any page to instantly open and edit the header. FOOTERS IN MS WORD  A footer in Microsoft Word is a dedicated section of space located at the bottom margin of a page that repeats information across multiple pages. STEPS  1.Open  document in Microsoft Word. 2.Click the Insert tab at the top...

🔽MARKETING MIX The term "Marketing mix" was introduced by Prof. Neil H. Borden of the Harvard Business School. Marketing mix is one of the most fundamental concepts in marketing Management. These are: product, pricing, distributive channels (place) and sales promotion techniques. 🔽Definition of Marketing Mix: According to Philip Kotler, "Marketing mix the mixture of controllable marketing variables that the firm uses to pursue the sought level of sales in the target market." 📍Marketing Mix is a set of elements that need to be determined by a company to promote its brand or product effectively. Often called 4 Ps of marketing. (product,price,place, & promotion) 1.PRODUCT   The product in a marketing mix refers to the tangible good, intangible service, or digital offering that a business provides to satisfy customer needs and wants. A product is a commodity, produced or built to satisfy the need of an individual or a group. The product can be intangible or tang...

🔽Bank reconciliation🔽 Bank reconciliation explains the difference between the bank balance shown in an organization's bank statement and the corresponding amount shown in the organization's accounting records, on a particular date. To reconcile the bank statement Go to 'Gateway of Tally > Banking > Bank Reconciliation' Select the name of the required bank The 'Bank Reconciliation' screen appears: Match every transaction with the bank statement and record the transaction date in the 'Bank Date' field. Accept the screen to reconcile the bank ledgers as per the corresponding banking statement. 🔽TRAIL BALANCE 🔽PROFIT AND LOSS ACCOUNT BALANCE SHEET 🔽COST CATEGORY IN TALLY