UKN Eduzone

Creating and formatting charts Creating and formatting charts in Excel means turning raw spreadsheet numbers into a visual picture and then styling that picture so it is easy to read and understand. • Visualizing Data : It converts plain tables of data into shapes, bars, lines, or slices. • Spotting Patterns : It helps you quickly see trends, high points, low points, and comparisons that are hard to find in a list of numbers. • Better Communication : It makes reports and presentations easy for others to understand at a glance. Types of Excel Charts • Column / Bar Charts : Best for comparing different items or values side-by-side. • Line Charts : Best for showing changes or trends over time. • Pie Charts : Best for showing parts or percentages of a whole. • Scatter / Combo Charts : Best for showing relationships between numbers or mixing two chart styles. STEPS ( CHART CREATION) 1. Select  data:  Highlight the cells containing the data you want to display, including the table h...

🔽 PUBLICITY AND PROPAGANDA 🔽 🔽CO OPERATIVE JOURNAL Publicity and propaganda wings in state cooperative unions use dedicated journals and monthly magazines to spread cooperative ideals, educate members, and share sectoral news Cooperative journals are academic and professional publications that focus on the research, management, and activities of cooperative organizations. Key Cooperative Journals Kerala Cooperative Journal :  An Anglo-Malayalam monthly published by the State Co-operative Union Kerala to promote cooperative activities. Published by the State Co-operative Union, this flagship journal focuses on cooperative activities, updates, legal frameworks, and the socio-economic impact of cooperatives across Kerala's various sectors. The Cooperator :  An illustrated monthly distributed by the National Cooperative Union of India covering national and international cooperative views. Cooperative Perspective Journal :  A publication by the Vaikunth Mehta National Insti...

Module 2 BALANCE NOTES. 🔽CELL REFERENCE  🔽 A cell reference in Excel identifies the location of a cell or range of cells on a worksheet using its column letter and row number, such as A1 or B2.  Absolute cell reference An absolute cell reference is a locked formula address that does not change when copy or fill it into other cells. Syntax :  Add a dollar sign ($) before the column letter and row number (like $A$1) to lock both completely Shortcuts Press F4 while editing a cell reference to cycle through absolute and mixed options. Common Uses 1• Applying Fixed Tax Rates:  Multiply different item prices in a column by a single tax rate stored in one constant cell. 2• Calculating Bonuses or Commissions:  Apply a single set bonus percentage to a list of different employee salaries. 3• Using Conversion Factors:  Convert multiple values (such as feet to meters or currencies) using a single exchange rate cell. 4• Locking Totals or Limits:  Reference a glob...

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...