inbound8892906594451662013.pptx informatics

It's a question with multiple choices for somatic cells and reproductive system for somatic cells in the body of water separates the best advocates for somatic cell genetic engineering and technology and reproductive system and proteins are made of water separates the thoracic cavity filling up the week

1. Lesson:3 INTRODUCTION TO SPREADSHEET PROGRAM (MICROSOFT EXCEL AND GOOGLE SHEETS) GROUP 3 Reporter’s: DEJARLO, RENA JOY BARCALA, JULY GABANE, REAH JANE GRATUITO,JANE TAGANNA, NInA CAUBALEJO, JESSEL instructor: john Carlo f.rotilles

2. T0PIC: 1 OVERVIEW OF SPREADSHEET PROGRAMS

3. DEFINATION SPREADSHEET PROGRAMS S preadsheet was and is a large sheet of paper with columns and rows that organizes data about transactions for a business person to examine. It spreads or shows all of the costs, income, taxes, and other related data on a single sheet of paper for a manager to examine when making a decision. An electronic spreadsheet organizes information into software defined columns and rows. The data can then be "added up" by a formula to give a total or sum.

4. The purpose of spreadsheet programs includes: Data storage and organization Data manipulation and analysis Calculation and computation Visualization Forecasting and budgeting Automation

5. History and evolution of spreadsheet software

6. The first spreadsheets were designed on paper, replaced by electronic spreadsheets in the late 20 th century.

7. 1961-Idea of spreadsheet belongs to the American scientist Richard Mattesich published his study “Budgeting Models and System Simulation”. 1969 – LANPAR (Language for Programming Arrays at Random, Canadians Rene Pardo and Remy Landau developed the first commercial electronic spreadsheet.

8. VisiCalc (Apple) | 1979 The first spreadsheet software was developed for the Apple II Computer by Dan Bricklin and Bob Frankston . It’s considered to be the Apple II’s killer app.

9. 1982 - Multiplan   was a spreadsheet program developed by Microsoft as a competitor to VisiCalc. It was one of the first spreadsheet programs and was used on CP/M machines before the IBM PC.   1980- SuperCalc is a spreadsheet application developed and introduced by Sorcim .

10. 1985 - BOEING Calc was a spreadsheet package released i t was written by Boeing Computer Services . It supported a maximum spreadsheet size of 16,000 columns by 16,000 rows, and was notable for introducing the concept of 3D spreadsheets. 1983 - Lotus 1- 2- 3 It was developed by Lotus Development Corporation , founded by Mitchell kapor ,, also the first innovative spreadsheet for the PC and was launched with a huge marketing campaign.

11. 1985 - MICROSOFT EXCEL Microsoft released the first version of Excel  for Apple Inc.'s Macintosh computer. 1988 – QUATTRO PRO - First released it was originally developed by Borland Software and is now part of the WordPerfect Office suite . 

12. Modern spreadsheet 2006 - GOOGLE SHEET-   It was developed from XL2Web, a web-based spreadsheet application that Google acquired. 

13. 2007 - APPLE NUMBERS - Apple announced the first version of Numbers for Mac OS Numbers is a spreadsheet application that is part of Apple's iWork productivity suite.  MICROSOFT EXCEL 2016 AND 365 : Charles Simonyi is the man behind some of the company most successful software. Bills Gates and Paul Allen who created 365.

14. MICROSOFT EXCEL 2016 MICROSOFT EXCEL 365

15. Importance of spreadsheet programs in various fields Spreadsheet programs have significant importance across many industries and professions due to their versality and ability to manage data efficiently. 1. Accounting and Marketing 2. Business and Finance 3. Education 4. Healthcare 5. Project Management 6. Engineering and Science

16. Topic 2: getting started with Microsoft excel What is MS Excel Excel  is a part of the Microsoft Office suite software. It is an electronic spreadsheet program that features a grid of rows and columns, making it easy to input and organize data. With  1,048,576 rows  and  16,384 columns  in Excel 2007 and newer versions, it can handle vast datasets without hassle. Each intersection of a row and column forms a  cell , identified by a  cell reference  like A1 or D2. These references help users store data, perform calculations, and link information effortlessly.

17. Interface of Microsoft Excel

18. The  Ribbon  and  Quick Access Toolbar   are where you will find the commands to perform common tasks in Excel. The   Backstage view   gives you various options for saving, opening a file, printing, and sharing your document. Working with the Excel environment

19. Interface Element Description Ribbon Tabs Ribbon Tab is a tab that organizes commands by topic The Ribbon Commands underneath the Tabs Ribbon Groups Grouping of related commands Dialog Box Launcher Opens a dialog box that includes additional commands Quick Access Toolbar One click access to any frequently used command

20. Name Box Displays cell location and can be used to navigate to a cell location Select All Button Selects all the cells in a worksheet Formula Bar View, enter, or edit cell contents Insert Function Button Displays Insert Function dialog box Scroll Bars Used to navigate up, down, left & right

21. Zoom Slider Zoom into an area of the worksheet View Buttons Switch between Normal, Page Layout and Page Break Preview views Worksheet tabs Tabs used to select individual worksheets The Workspace The area inside of the columns and rows used in Excel Columns Columns use letters Rows Rows use numbers

22. Ribbon Overview Home - Most commonly used buttons and includes common functions, sorting, etc. Insert - For inserting Tables, Illustrations, Charts, Links and Text Objects Page Layout - For Themes, Page Setup, Scaling, Sheet Options and Arrangement of drawing objects View - For Workbook Views, Show/Hide, Zoom, Window options, and Macros

23. Formulas - For inserting Functions, Range Names, Formula Auditing, and Calculations Options Data - For Database Options (Filter/Sort, Data Tools, and Outlining) Review - For Proofing, Comments, Protection, and Track Changes View - For Workbook Views, Show/Hide, Zoom, Window options, and Macros

24. MICROSOFT EXCEL COMPONENTS Before you start using it, it’s really important to understand what’s where in its window. So ahead we have all the major components which you need to know before entering the world of Microsoft Excel.

25. The three most important components of Excel you need to understand first: Cell A cell is the smallest but most powerful part of a spreadsheet. You can enter your data into a cell either by typing or by copy-paste. Data can be a text, a number, or a date. You can also customize it by changing its size, font color, background color, borders, etc. Every cell is identified by its cell address, cell address contains its column number and row number (If a cell is on the 11th row and on column AB, then its address will be AB11).

26. 2.) Worksheet A worksheet is made up of individual cells which can contain a value, a formula, or text. It also has an invisible draw layer, which holds charts, images, and diagrams. Each worksheet in a workbook is accessible by clicking the tab at the bottom of the workbook window. In addition, a workbook can store chart sheets; a chart sheet displays a single chart and is accessible by clicking a tab.

27. 3.) Workbook In Excel, a workbook is a file that stores data in multiple sheets. Each workbook is a separate entity. Below are some of the features of an Excel workbook. Each workbook has its name. Each workbook has a specific format. Each workbook needs to be saved in a specific location.

28. Creating Workbook in Excel Open Excel Application. Go to the Home (By default, it is open already). Click on the “Blank Workbook” Icon. It will open a new workbook with the name Book1 .

29. Create a New Workbook from Right-Click If you are using Excel in Windows, you can insert a new workbook from the right-click menu or the new option. If you are on the desktop, right-click, click the new “New”, and then click on the “Microsoft Excel Workbook”.

30. And if you are in a folder, click on the “New” dropdown and then click on the “Microsoft Excel Workbook”.

31. Keyboard Shortcut to Insert a New Workbook: If you have an Excel workbook is already open, and you want to add a new workbook, you can use the keyboard shortcut: Ctrl + N When you use the shortcut, it creates a new workbook with the name Book and a number.

32. Save a Workbook Once you insert a new workbook, you need to save that workbook, and for this, you need to go to the File Tab > Save As.

33. Once you click “Save As”, click “Browse”. After that, select the location where you want to save the workbook, enter the name you want to give to the workbook and click “Save” at the end.

34. How To Share An Excel File? With the workbook open, perform the following steps to share it: 1. On the Review tab, in the Changes group, click the Share Workbook button.

35. 2. The Share Workbook dialog box will appear, and you select the Allow changes by more than one user at the same time. This also allows workbook merging check box on the Editing tab.

36. 3. Optionally, switch to the Advanced tab, select the desired settings for tracking changes, and click OK . For example, you may want to have changes updated automatically every n number of minutes (all the other settings on the screenshot below are the default ones).

37. 4. Save you Excel file to a network location where other people can access it (the fastest way is by using the Ctrl + S shortcut).

38. BASIC CELL FROMATTING AND DATA ENTRY

39. Data Entry The easiest way to enter data into a worksheet is to type it directly into the active cell, or into the formula bar. Once data has been entered, the action may be completed in a variety of different ways. Suppose we have just entered data into cell C8. Then:

40. Enter moves to the next cell in the same column, i.e. C9. Shift Enter moves to the previous cell in the same column, i.e. C7. Tab moves to the next cell in the same row, i.e. D8. Shift Tab moves to the previous cell in the same row, i.e. B8. The cursor keys move in the direction indicated. The tick icon next to the formula bar completes the formula but does not move to a new cell. Esc does not move and cancels all modifications since the last completion of type (1–6) above. The cross icon next to the formula bar has the same effect as Esc, as does the undo icon in the quick access toolbar.

41. Topic 3: advanced features in Microsoft excel MICROSOFT EXCEL- Is a spreadsheet program where one can record data in form of tablets.

42. The Basics of Excel formulas Formula  is an expression that calculates values in a cell or in a range of cells. For example: = A2+A2+A3+A4 is a formula that adds up the value in cells A2 through A4.

43. Function   is a predefined formula already available in Excel. Functions perform specific calculations in a particular order based on the specified values, called arguments, or parameters. For example : instead of specifying each value to be summed like in the above formula, you can use  the SUM function to add up a range of cells:  =SUM(A2:A4)

44. You can find all available Excel functions in the  Function Library  on the  Formulas  tab:

45. 10 Excel Basic F unctions SUM The first Excel function you should be familiar with is the one that performs the basic arithmetic operation of addition: SUM( number1 , [number2], …)

46. Tip.  The fastest way to  sum a column   or  row of numbers   is to select a cell next to the numbers you want to sum (the cell immediately below the last value in the column or to the right of the last number in the row), and click the  AutoSum   button on the  Home  tab, in the  Formats  group . Excel will insert a SUM formula for you automatically.

47. Excel Sum formula examples  - formulas to total a column, rows, only filtered (visible) cells, or sum across sheets. Excel AutoSum   - the fastest way to sum a column or row of numbers. SUMIF in Excel   - formula examples to conditionally sum cells. SUMIFS in Excel   - formula examples to sum cells based on multiple criteria.

48. AVERAGE The Excel AVERAGE function does exactly what its name suggests, i.e. finds an average, or arithmetic mean, of numbers. Its syntax is similar to SUM’s: AVERAGE(number1, [number2], …)

49. Useful Resources: Excel AVERAGE   - average cells with numbers. Excel AVERAGEA   - find an average of cells with any data (numbers, Boolean and text values). Excel AVERAGEIF   - average cells based on one criterion. Excel AVERAGEIFS   - average cells based on multiple criteria. How to calculate weighted average in Excel How to find moving average in Excel

50. MAX & MIN The MAX and MIN formulas in Excel get the largest and smallest value in a set of numbers, respectively. For our sample data set, the formulas will be as simple as: =MAX(B2:B6) =MIN(B2:B6)

51. Useful Resources: MAX function   - find the highest value. MAX IF formula   - get the highest number with conditions. MAXIFS function   - get the largest value based on multiple criteria. MIN function   - return the smallest value in a data set. MINIFS function   - find the smallest number based on one or several conditions.

52. COUNT & COUNTA If you are curious to know how many cells in a given range contain  numeric values   (numbers or dates), don't waste your time counting them by hand. The Excel COUNT function will bring you the count in a heartbeat: COUNT(value1, [value2], …)

53. For example, to find out how many cells in column B contain numbers, use this formula: =COUNT(B:B) To count all non-empty cells in column B, go with this one: =COUNTA(B:B)

54. In both formulas, you use the so-called "whole column reference" (B:B) that refers to all the cells within column B. The following screenshot shows the difference: while COUNT processes only numbers, COUNTA outputs the total number of non-blank cells in column B, including the the text value in the column header.

55. Useful Resources: Excel COUNT function   - a quick way to count cells with numbers. Excel COUNTA function   - count cells with any values (non-empty cells). Excel COUNTIF function   - count cells that meet one condition. Excel COUNTIFS function   - count cells with several criteria.

56. IF Judging by the number of IF-related comments on our blog, it's the most popular function in Excel. In simple terms, you use an IF formula to ask Excel to test a certain condition and return one value or perform one calculation if the condition is met, and another value or calculation if the condition is not met: IF( logical_test , [ value_if_true ], [ value_if_false ])

57. For example, the following IF statement checks if the order is completed (i.e. there is a value in column C) or not. To test if a cell is not blank, you use the "not equal to" operator ( <>) in combination with an empty string (""). As the result, if cell C2 is not empty, the formula returns "Yes", otherwise "No": =IF(C2<>"", "Yes", "No")

58. Useful Resources: IF function in Excel with formula examples How to use nested IFs in Excel IF formulas with multiple AND/OR conditions

59. TRIM If your obviously correct Excel formulas return just a bunch of errors, one of the first things to check is extra spaces in the referenced cells. There are several ways to remove unwanted spaces in Excel, with the TRIM function being the easiest one: TRIM(text)

60. For example, to trim extra spaces in column A, enter the following formula in cell A1, and then copy it down the column: =TRIM(A1) It will eliminate all extra spaces in cells but a single space character between words:

61. Useful Resources: Excel TRIM function with formula examples How to delete line breaks and non-printing characters How to remove non-breaking spaces (& nbsp ;) How to delete a specific non-printing character

62. LEN Whenever you want to know the number of characters in a certain cell, LEN is the function to use: LEN(text) Wish to find out how many characters are in cell A2? Just type the below formula into another cell: =LEN(A2)

63. Please keep in mind that the Excel LEN function counts absolutely all characters  including spaces :

64. Want to get the total count of characters in a range or cells or count only specific characters? Please check out the following resources. Useful resources: Excel LEN formulas to count characters in a cell Count the number of characters in cells and ranges

65. AND & OR These are the two most popular logical functions to check multiple criteria. The difference is how they do this: AND returns TRUE if  all conditions  are met, FALSE otherwise. OR returns TRUE if  any condition  is met, FALSE otherwise.

66. While rarely used on their own, these functions come in very handy as part of bigger formulas. For example, to check the test results in columns B and C and return "Pass" if both are greater than 60, "Fail" otherwise, use the following IF formula with an embedded AND statement:

67. =IF(AND(B2>60, B2>60), "Pass", "Fail") If it's sufficient to have just one test score greater than 60 (either test 1 or test 2), embed the OR statement: =IF(OR(B2>60, B2>60), "Pass", "Fail")

68. Useful Resources: Excel AND function with formula examples Excel OR function with formula examples

69. CONCATENATE In case you want to take values from two or more cells and combine them into one cell, use the concatenate operator (&) or the CONCATENATE function: CONCATENATE(text1, [text2], …)

70. For example, to combine the values from cells A2 and B2, just enter the following formula in a different cell =CONCATENATE(A2, B2) To separate the combined values with a space, type the space character (" ") in the arguments list: =CONCATENATE(A2, " ", B2)

71. Useful Resources: How to concatenate in Excel   - formula examples to combine text strings, cells and columns. CONCAT function   - newer and improved function to combine the contents of multiple cells into one cell.

72. TODAY & NOW To see the current date and time whenever you open your worksheet without having to manually update it on a daily basis, use either:

73. =TODAY()  to insert the today's date in a cell =NOW()  to insert the current date and time in a cell. The beauty of these functions is that they don't require any arguments at all, you type the formulas exactly as written above.

74. Useful Resources: Excel NOW function   - how to insert the current date and time as a dynamic value.

75. How to insert today's date in Excel   - different ways to enter the current date in Excel: as an unchangeable time stamp or automatically updatable date and time. Excel date functions with formula examples  - formulas to convert date to text and vice versa, extract a day, month or year from a date, calculate the difference between two dates, and a lot more.

76. DATA VISUALIZATION WITH CHARTS AND GRAPHS

77. What is a PivotTable? A PivotTable allows you to take an extensive data set with multiple columns and rows and summarize that data in a compact, easy-to-read table. You can create multiple PivotTables from the same data set, each highlighting different aspects of the data. And PivotTables are interactive — you can easily manipulate them to filter or rearrange the data shown in one.

78. What is a PivotChart? A PivotChart is a chart visualization based on the summarized information in a PivotTable. You can choose from a wide variety of chart types to best display a PivotTable’s data. The combinations you can create using these tools are countless.

79. DATA ANALYSIS TOOLS:

80. Topic 4:INTRODUCTION TO GOOGLE SHEETS

81. OVERVIEW OF GOOGLE SHEET INTERFACE,PARTS,AND ENVIRONMENTS GOOGLE SHEETS- is a free. Web-based spreadsheet application that is provided by Google within Google Drive service. Allows users to edit, organize, and analyze different types of information. Google Sheets user interface is designed to be intuitive and user-friendly, making it easy to navigate and use its features. Key Components: Menu Bar: Contains drop-down menus for File, Edit, View, Insert, Format, Data, Tools . Adds - ones , and Help.

82. Creating and sharing spreadsheets in google sheets OPEN GOOGLE SHEETS : Go to sheets.google.com and log in to your google account. CREATE A NEW SPREADSHEET : Click “NEW” to start a blank spreadsheet. ADD CONTENT : Input your data and format the cells as needed. CLICK “ SHARE ” : Find the “SHARE” button in top right corner of your spreadsheet. ENTER EMAIL ADDRESSES : Type the email addresses of the people you want to share with. SET ACCESS LEVEL : Select the level of access you want to give each person ( Viewer, Commenter ,or Editor ). SEND THE SHARE INVITATION : Click “Send” to share the spreadsheet.

83. real-time COLLABORATION IN GOOGLE SHEETS TO SHARE A FILE FOR COLLABORATION: Open the file you want to share. Click Share in the upper right corner. Enter the email addresses of the people you want to share with Choose the type of access you want to give each person Click send

84. Basic cell formatting and data entry in google sheets KEYS STEPS : SELECT A CELL : Click on the cell where you want to enter data. Enter DATA : Type your text,numbers,or dates directly into the selected cell. BASIC FORMATTING OPTIONS : TEXT FORMATTING : BOLD,ITALIC, UNDERLINE : Use the icons on the toolbar to apply bold, italic, or underline styles to your text. TEXT ALIGNMENT : Click the alignment icons to left-align, center , or right-align text. FONT SIZE AND COLOR : Adjust the font size and select a color from the dropdown menu.

85. NUMBER FORMATTING : DECIMAL PLACES : Select the desired number of decimal places to display. CURRENCY FORMAT :Apply currency symbols like “$” or DATE FORMATTING : Chose a date display format. CELL FORMATTING : BACKGROUND COLOR : Select a fill color for the cell. BORDERS : Add borders around the cell.

86. Google Sheets is a powerful and versatile online spreadsheet application that offers a wide range of features for both novice and advanced users. While its basic functionality might seem similar to Microsoft Excel, Google Sheets boasts several advanced features that can significantly enhance productivity, data analysis, and collaboration. This response will explore some of the most notable advanced features in Google Sheets, highlighting their benefits and practical applications. Topic 5: Advanced Features in Google sheets

87. Google Sheets offers a wide range of formulas and functions, some of which are considered advanced and can significantly enhance your data analysis and manipulation capabilities. These advanced features go beyond basic calculations and provide powerful tools for complex tasks, data insights, and automation. Formulas and Functions:

88. D ata visualization is “ visual communication ” representing data visually. The theme of data visualization is to convey information clearly, efficiently to users by using graphics, and it helps to have an inner view of data. Data visualization mesmerizes users by changing tedious data into a visually colorful tale. For this, we need data visualization tools that are popular in understanding data easily and visually. When analyzing data, data visualization is one of the steps that aroused to present the data to the users .  Data Visualization with Charts and Graphs

89. Using Add-ons for Enhanced Functionality is a powerful tool for data management, analysis, and collaboration. However, its capabilities can be further enhanced with the use of  add-ons , which are third-party extensions that provide additional features and functionalities. These add-ons can streamline workflows, automate tasks, and unlock advanced features, making Google Sheets even more versatile and efficient.

90. Integration with other Google Workspace Apps offers powerful integration capabilities with other Workspace apps, enabling users to leverage a comprehensive suite of tools for enhanced productivity and collaboration. This integration allows for seamless data sharing, automation of tasks, and streamlined workflows, ultimately boosting efficiency and unlocking advanced features .

91. Topic 6: comparison of the advantages of Microsoft excel and google sheets STRENGTHS AND WEAKNESSES OF EACH PLATFORM :

92. Strengths of Microsoft excel EASY TO USE - The interface is simple, making it easy to organize data. POWERFUL DATA ANALYSIS - It has built-in formulas and tools like PivotTables for data analysis. AUTOMATION WITH MACROS - Repetitive tasks can be automated using Macros and VBA. DATA VISUALIZALITION -Allows the creation of charts and graphs to present data clearly.

93. 5. WIDELY USED & COMPATIBLE - Used across industries and works well with Microsoft Office tools. 6. CLOUD INTEGRATION & COLLABORATION – Easy to collaborate with OneDrive and Microsoft 365, 7. LARGE DATA HANDALING – Efficiently manages large datasets and offers tools to organize them quickly.

94. Weaknesses of Microsoft excel PRONE TO HUMAN ERRORS – Relies on manual data entry, leading to mistakes in formulas and typos. NOT IDEAL FOR LARGE DATA SETS – Struggles with massive datasets, especially millions of rows. LIMITED AUTOMATION – Complicated for non-programmers, and other tools are better for large-scale automation. SECURITY ISSUES – Files are easy to share but not as secure as database systems.

95. 5. COLLABORATION CHALLENGES – Can cause version conflicts and is difficult to track changes in complex spreadsheets. 6. NOT A DATABASE – Lacks advanced data management features like relational linking and scalability. 7.CAN BE EXPENSIVE – Requires a Microsoft 365 subscription, while free alternatives like Google Sheets are available.

96. Strengths of google sheets FREE TO USE – Completely free with just a Google account. REAL-TIME COLLABORATION – Multiple people can work on the same file at once. CLOUD-BASED ACCESS – Access files from any device with internet connection. EASY SHARING & PERMISSIONS – Share files with a link and control access.

97. 5. INTEGRATION WITH GOOGLE APPS – Works seamlessly with Google Docs ,Drive, Forms, and Gmail. 6. BUILT-IN AI FEATURES – Automatically suggests charts ,data analysis, and functions. 7. WORKS ON ANY DEVICE – Accessible on Windows ,Mac, Linux , and mobile without installation. 8. AUTOMATIC VERSION HISTORY – Keeps track of changes and lets you revert to previous versions.

98. Weaknesses of google sheets LIMITED DATA CAPACITY – Can handle fewer cells than Excel, which can affect performance. FEWER ADVANCED FEATURES – Lacks Excel’s advanced tools like Power Query and VBA. REQUIRES INTERNET – Features work best with internet connection. SLOWER PERFORMANCE WITH LARGE DATA – Struggles with large data sets and complex formulas.

99. 5.LIMITED CUSTOMIZATION – Fewer automation options and customization compared to Excel. 6.SECURITY & PRIVACY CONCERNS – Data is stored on Google servers, raising privacy issues. 7.FEWER FORMATING OPTIONS – Basic design and charting options compared to Excel.

100. Use cases for Microsoft excel DATA ORGANIZATION – Organize data into tables, such as inventory tracking or managing grades. FINANCIAL ANALYSIS – Create budgets and financial reports using formulas and functions. DATA VISUALIZATION – Generate charts and graphs for easy-to-understand data presentation. PROJECT MANAGEMENT – Track tasks ,timeline ,and resources with Gantt charts and to-do-lists. STATISCAL ANALYSIS – Perform calculations and analysis like averages and regression.

101. 6 . INVENTORY MANAGEMENT – Track stock levels and orders in real time. 7. DATA CLEANING AND TRANSFORMATION – Clean and filter raw data to make it usable. 8. SCHEDULING AND TIME TRACKING – Plan schedules and track time worked. 9. CRM ( CUSTOMER RELATIONSHIP MANAGEMENT ) – Track customer details and monitor sales leads. 10. SURVEY DATA ANALYSIS – Analyze survey data and identify trends using pivot tables and charts.

102. Use cases for google sheets COLLABORATION – Multiple users can work on the same document in real time, ideal for team projects and shared data management. DATA ORGANIZATION – Organize data like inventory list ,contact databases, or event planning in a shared spreadsheet. FINANCIAL TRACKING – Track budgets, expenses , and personal finances, with real-time updates accessible from anywhere. PROJECT MANAGEMENT - Use Google Sheets to manage tasks ,deadlines , and reasources , with results automatically populated in sheets. SURVEY DATA ANALYSIS – Collect and analyze survey responses using Google forms, with results automatically populated in sheets. DATA VISUALIZATION – Create charts and graphs to present data clearly and visually. TIME TRACKING – Track work hours, employee schedules, or project timelines in a shared and editable format. CUSTOMER RELATIONSHIP MANAGEMENT (CRM ) – Manage customer details and sales leads in collaborative environment.

103. 9 . EVENT PLANNING – Organize guest lists, budgets, and schedules for events with real-time updates and collaboration. 10 . SIMPLE DATABASE MANAGEMENT – Create simple databases for small-scale tracking or managing small inventories. INTEROPERABILITY BETWEEN MICROSOFT EXCEL AND GOOGLE SHEET -Refers to the ability to share and work with data across both platforms, enabling users To transfer ,edit , and collaborative on files seamlessly, with some challenges.

104. LINKED DATA : Google Sheets API and Excel’s Power Query enable users to pull data from one platform to another, especially for advanced users. COLLABORATION : Both support real-time collaboration, though working between the two require file conversion or syncing.

105. IMPORT AND EXPORT : You can upload Excel files to Google Sheets and vice versa, but some formatting ,formulas , or advanced features may not be preserved. CLOUD INTEGRATION : Google Sheets uses Google Drive and Excel integrates with OneDrive, allowing users to store and access files across both platforms. LINKED DATA : Google Sheets API and Excel’s Power Query enable users to pull data from one platform to another, especially for advanced users. COLLABORATION : Both support real-time collaboration, though working between the two require file conversion or syncing.

106. THANK YOU ! ! FOR LISTENING WITH OUR PRESENTATION