![\"\"](\"https:\/\/wordpress-projects.wolfware.ncsu.edu\/ncsuereseng\/wp-content\/uploads\/sites\/389\/2025\/06\/e-REF-Logo-V-2-11.png\"){kind=logo}
<\/figure>\n\n\n\nOverview<\/h1>\n<\/div>\n\n\n\n<\/div>\n\n\n\n\nNavigation<\/strong><\/p>\n\n\n\n\n- Spreadsheet Software Comparison<\/a><\/li>\n\n\n\n
- Spreadsheet Formulas<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n\n\n\n
\n\n\n\nSummary<\/h2>\n\n\n\n
Spreadsheet softwares like Microsoft Excel<\/strong> and Google Sheets<\/strong> are powerful tools for organizing, analyzing, and presenting data in a tabular format, widely used in engineering for efficiency. Engineers leverage these tools for data analysis, simulations, and statistical modeling, enabling accurate and fast calculations. They are also integral to design documentation, serving as repositories for tracking parameters. In project management, spreadsheets help create schedules, allocate resources, and manage budgets. Additionally, they integrate with engineering softwares such as CAD, streamlining workflows. Overall, spreadsheets are vital for engineering documentation, ensuring standardization, traceability, and clarity in complex projects.<\/p>\n\n\n\n<\/div>\n\n\n\nLearning Outcomes<\/h1>\n\n\n\n\n- Recognize the main capabilities of spreadsheet software<\/strong> for engineering applications <\/li>\n\n\n\n
- Manipulate common formulas<\/strong> employed in engineering applications<\/li>\n\n\n\n
- Produce graphical representations<\/strong> from data in spreadsheet software<\/li>\n<\/ul>\n\n\n\n<\/div>\n\n\n\n
Spreadsheet Software Comparison<\/h2>\n\n\n\n<\/div>\n\n\n\n
\n\n\n\nSheets vs Excel<\/h2>\n\n\n\n
Both Excel and Google Sheets offer similar features, however there are a few differences to consider when choosing between the platforms. Excel<\/strong> is known for assisting in more complex data sets, offering a much wider range of functions and features. Consequently, Excel is much less intuitive and may require more proficiency to utilize its full capabilities. Google Sheets<\/strong> is designed with simplicity in mind, offering a much more user friendly interface. Additionally, Google Sheets provides users with more collaborative features, better suited for working with large teams. However, Google Sheets has a less extensive library of functions, leaving out statistical and other data analysis tools. Overall, both platforms can be utilized for different needs. Excel is considerably more powerful and extensive in analyzing data, while Google Sheets offers a more simplistic design and fosters collaboration.<\/p>\n\n\n\n<\/div>\n\n\n\n\n\nExcel<\/strong><\/h2>\n\n\n\n![\"\"](\"https:\/\/wordpress-projects.wolfware.ncsu.edu\/ncsuereseng\/wp-content\/uploads\/sites\/389\/2025\/01\/Excel-Reference-Guide-edited.png\")
<\/figure>\n<\/div>\n\n\n\n\nGoogle Sheets<\/strong><\/h2>\n\n\n\n![\"\"](\"https:\/\/wordpress-projects.wolfware.ncsu.edu\/ncsuereseng\/wp-content\/uploads\/sites\/389\/2025\/01\/Sheets-Reference-Guide2-edited.png\")
<\/figure>\n<\/div>\n<\/div>\n\n\n\n<\/div>\n\n\n\nSpreadsheet Formulas<\/h2>\n\n\n\n<\/div>\n\n\n\n
\n\n\n\nSummary<\/h2>\n\n\n\n
Formulas in spreadsheet software are expressions used to perform calculations and data manipulation. They typically begin with an equals sign (=<\/code>) and can include arithmetic operators like +<\/code>, -<\/code>, *<\/code>, and \/<\/code> for basic calculations, as well as built-in functions for more advanced operations, such as SUM<\/code> for summing values. Formulas also utilize cell references to dynamically incorporate data from other cells, enabling updates when the source data changes.<\/p>\n\n\n\n<\/div>\n\n\n\nFunction<\/strong><\/td>Excel<\/strong><\/td>Google Sheets<\/strong><\/td><\/tr>Average<\/strong><\/td>=MEAN()<\/td> =average()<\/td><\/tr> Maximum<\/strong><\/td>=MAX()<\/td> =max()<\/td><\/tr> Minimum<\/strong><\/td>=MIN()<\/td> =min()<\/td><\/tr> Count Cells<\/strong><\/td>=COUNT() <\/td> =count()<\/td><\/tr> Conditional<\/strong><\/td>=IF() AND OR<\/td> =if() and or<\/td><\/tr> Add Values<\/strong><\/td>=SUM()<\/td> =sum()<\/td><\/tr> Arithmetic<\/strong><\/td>+ – * \/ ^<\/td> + – * \/ ^<\/td><\/tr> Remove Data<\/strong><\/td>=DROP()<\/td> N\/A<\/td><\/tr> Look Up Data<\/strong><\/td>=VLOOKUP()<\/td> =vlookup<\/td><\/tr> Expand Array<\/strong><\/td>=EXPAND()<\/td> N\/A<\/td><\/tr> Standard Deviation<\/strong><\/td>=STDEV()<\/td> =stdev()<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nFor full list of functions in Excel visit Excel Function List<\/a><\/p>\n\n\n\n
Navigation<\/strong><\/p>\n\n\n\n Spreadsheet softwares like Microsoft Excel<\/strong> and Google Sheets<\/strong> are powerful tools for organizing, analyzing, and presenting data in a tabular format, widely used in engineering for efficiency. Engineers leverage these tools for data analysis, simulations, and statistical modeling, enabling accurate and fast calculations. They are also integral to design documentation, serving as repositories for tracking parameters. In project management, spreadsheets help create schedules, allocate resources, and manage budgets. Additionally, they integrate with engineering softwares such as CAD, streamlining workflows. Overall, spreadsheets are vital for engineering documentation, ensuring standardization, traceability, and clarity in complex projects.<\/p>\n\n\n\n Both Excel and Google Sheets offer similar features, however there are a few differences to consider when choosing between the platforms. Excel<\/strong> is known for assisting in more complex data sets, offering a much wider range of functions and features. Consequently, Excel is much less intuitive and may require more proficiency to utilize its full capabilities. Google Sheets<\/strong> is designed with simplicity in mind, offering a much more user friendly interface. Additionally, Google Sheets provides users with more collaborative features, better suited for working with large teams. However, Google Sheets has a less extensive library of functions, leaving out statistical and other data analysis tools. Overall, both platforms can be utilized for different needs. Excel is considerably more powerful and extensive in analyzing data, while Google Sheets offers a more simplistic design and fosters collaboration.<\/p>\n\n\n\n Formulas in spreadsheet software are expressions used to perform calculations and data manipulation. They typically begin with an equals sign ( For full list of functions in Excel visit Excel Function List<\/a><\/p>\n\n\n\n\n
\n\n\n\nSummary<\/h2>\n\n\n\n
Learning Outcomes<\/h1>\n\n\n\n
\n
Spreadsheet Software Comparison<\/h2>\n\n\n\n
\n\n\n\nSheets vs Excel<\/h2>\n\n\n\n
Excel<\/strong><\/h2>\n\n\n\n
<\/figure>\n<\/div>\n\n\n\nGoogle Sheets<\/strong><\/h2>\n\n\n\n
<\/figure>\n<\/div>\n<\/div>\n\n\n\nSpreadsheet Formulas<\/h2>\n\n\n\n
\n\n\n\nSummary<\/h2>\n\n\n\n
=<\/code>) and can include arithmetic operators like +<\/code>, -<\/code>, *<\/code>, and \/<\/code> for basic calculations, as well as built-in functions for more advanced operations, such as SUM<\/code> for summing values. Formulas also utilize cell references to dynamically incorporate data from other cells, enabling updates when the source data changes.<\/p>\n\n\n\nFunction<\/strong><\/td> Excel<\/strong><\/td> Google Sheets<\/strong><\/td><\/tr> Average<\/strong><\/td> =MEAN()<\/td> =average()<\/td><\/tr> Maximum<\/strong><\/td> =MAX()<\/td> =max()<\/td><\/tr> Minimum<\/strong><\/td> =MIN()<\/td> =min()<\/td><\/tr> Count Cells<\/strong><\/td> =COUNT() <\/td> =count()<\/td><\/tr> Conditional<\/strong><\/td> =IF() AND OR<\/td> =if() and or<\/td><\/tr> Add Values<\/strong><\/td> =SUM()<\/td> =sum()<\/td><\/tr> Arithmetic<\/strong><\/td> + – * \/ ^<\/td> + – * \/ ^<\/td><\/tr> Remove Data<\/strong><\/td> =DROP()<\/td> N\/A<\/td><\/tr> Look Up Data<\/strong><\/td> =VLOOKUP()<\/td> =vlookup<\/td><\/tr> Expand Array<\/strong><\/td> =EXPAND()<\/td> N\/A<\/td><\/tr> Standard Deviation<\/strong><\/td> =STDEV()<\/td> =stdev()<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n