Spreadsheet definition
An online spreadsheet is a software application used for storing, organizing, and manipulating data. It’s designed to let users perform complex calculations, create charts, and manage data efficiently.
What is a spreadsheet?
A spreadsheet is a digital document designed to organize, calculate, and analyze data in rows and columns.
- Spreadsheets are versatile tools for data organization, analysis, and management.
- Key features include data input, formulas, charting, and collaboration.
- Various spreadsheet applications are available, including desktop and online tools.
- AI enhancements allow for faster data analysis and visualization.
Spreadsheet software overview
Spreadsheets are powerful digital tools that have revolutionized the way we organize, calculate, and analyze data. They’re widely used across various industries for tasks ranging from simple data entry to complex financial modeling. The versatility of spreadsheets lies in their ability to handle vast amounts of data, perform intricate calculations, and how they can visually present information:
In education, spreadsheets are used to organize student data, track grades, and analyze educational outcomes. Teachers and administrators rely on them to manage classroom activities and monitor student progress.
For personal financial planning, spreadsheets are invaluable for budgeting, expense tracking, and financial forecasting. Individuals use them to manage their finances, plan for future expenses, and ensure financial stability.
- Data entry. Input data such as text, numbers, dates, or formulas into organized cells with formatting options like currency, percentages, or dates.
- Formulas and functions. Use formulas for calculations and predefined functions like SUM, AVERAGE, or VLOOKUP to automate tasks.
- Data analysis. Analyze data with sorting, filtering, charts, pivot tables, and conditional formatting to highlight key trends and points.
In education, spreadsheets are used to organize student data, track grades, and analyze educational outcomes. Teachers and administrators rely on them to manage classroom activities and monitor student progress.
For personal financial planning, spreadsheets are invaluable for budgeting, expense tracking, and financial forecasting. Individuals use them to manage their finances, plan for future expenses, and ensure financial stability.
Components
Let’s explore the basic layout of a spreadsheet:
Cells
Cells are the individual boxes in a spreadsheet where data is entered. Each cell can contain text, numbers, dates, or formulas. Cells are identified by their location, using a combination of column letters and row numbers (e.g., A1, B2).
Rows
Rows run horizontally across the spreadsheet and are numbered sequentially. Each row contains multiple cells, and data is organized in rows to represent different records or entries.
Columns
Columns run vertically and are labeled with letters (A, B, C, etc.). Each column contains multiple cells, and data is organized in columns to represent different categories or fields.
Sheets
A spreadsheet can contain multiple sheets, each with its own grid of cells, rows, and columns. Sheets are like individual pages within a spreadsheet file, allowing users to organize and manage different sets of data separately.
Cells
Cells are the individual boxes in a spreadsheet where data is entered. Each cell can contain text, numbers, dates, or formulas. Cells are identified by their location, using a combination of column letters and row numbers (e.g., A1, B2).
Rows
Rows run horizontally across the spreadsheet and are numbered sequentially. Each row contains multiple cells, and data is organized in rows to represent different records or entries.
Columns
Columns run vertically and are labeled with letters (A, B, C, etc.). Each column contains multiple cells, and data is organized in columns to represent different categories or fields.
Sheets
A spreadsheet can contain multiple sheets, each with its own grid of cells, rows, and columns. Sheets are like individual pages within a spreadsheet file, allowing users to organize and manage different sets of data separately.
Sub Section
Our mission is to empower every person and every organization on the planet to achieve more.
Basic tasks and functions
Navigating through a spreadsheet involves moving between cells, rows, columns, and sheets. Here are some common methods:
Simply select a cell and type the desired information, which can include text, numbers, dates, or formulas. You can also copy and paste data into the spreadsheet.
Formatting cells
This allows you to change the appearance of the data within a cell. You can adjust the font size, style, and color, as well as apply borders, shading, and number formats (e.g., currency, percentage). You can also use conditional formatting to highlight specific data based on certain criteria.
Adjusting rows and columns
You can change the width and height of the cells to fit the data better. Manually drag the edges of rows and columns to resize them or use the AutoFit feature to automatically adjust the size based on the content. You can insert or delete rows and columns.
- Use the arrow keys on your keyboard to move up, down, left, or right between cells.
- Click on a cell to select it. Click and drag to select multiple cells.
- The Tab key moves to the next cell to the right. Shift + Tab moves to the previous cell.
- Press Enter to move to the cell below. Shift + Enter moves to the cell above.
- The sheet tabs at the bottom of the spreadsheet let you switch between sheets.
- Some spreadsheet applications have a navigation pane that allows you to quickly jump to different sections or sheets.
Simply select a cell and type the desired information, which can include text, numbers, dates, or formulas. You can also copy and paste data into the spreadsheet.
Formatting cells
This allows you to change the appearance of the data within a cell. You can adjust the font size, style, and color, as well as apply borders, shading, and number formats (e.g., currency, percentage). You can also use conditional formatting to highlight specific data based on certain criteria.
Adjusting rows and columns
You can change the width and height of the cells to fit the data better. Manually drag the edges of rows and columns to resize them or use the AutoFit feature to automatically adjust the size based on the content. You can insert or delete rows and columns.
Features of a spreadsheet
Online spreadsheets like Microsoft Excel automatically save your work to the cloud and allow you to continue to work in the desktop application if internet access is not available. Excel offers a range of features and tools:
Input and manage data
Enter text, numbers, dates, and formulas into cells. Data validation ensures that the entered data meets specific criteria, and features like sorting and filtering help organize and manage large datasets.
Calculate with functions and formulas
Spreadsheets offer a wide range of calculation functions and formulas to perform complex calculations. Formulas can be used to perform mathematical operations and logic tests. Functions automate tasks and enhance data manipulation. Some popular functions include:
Chart data with visualization tools
Spreadsheets provide powerful tools to help users understand and present data. You can create various types of charts—bar charts, line charts, and pie charts—to visualize trends and patterns.
Filter and sort data
These features are essential for data analysis. Filtering allows users to display only the data that meets specific criteria, while sorting arranges data in a particular order. Users can analyze and find specific information within large datasets.
Collaborate
Online spreadsheets allow multiple users to work on the same document simultaneously. Features like comments, track changes, and sharing options facilitate teamwork and communication. These spreadsheets further enhance collaboration by providing real-time updates and accessibility from anywhere.
Input and manage data
Enter text, numbers, dates, and formulas into cells. Data validation ensures that the entered data meets specific criteria, and features like sorting and filtering help organize and manage large datasets.
Calculate with functions and formulas
Spreadsheets offer a wide range of calculation functions and formulas to perform complex calculations. Formulas can be used to perform mathematical operations and logic tests. Functions automate tasks and enhance data manipulation. Some popular functions include:
- SUM—automatically add together selected cells.
- AVERAGE—take the average of selected cells.
- VLOOKUP—identify specific data points within a range or row.
- MAX and MIN—return the largest or smallest point in a set of values.
- IF—make logical comparisons between a value and what you expect.
- CONCATENATE—join several text strings into one.
- VALUE—convert data from text format to number format.
- SUMPRODUCT—multiply ranges of cells and sums the products.
Chart data with visualization tools
Spreadsheets provide powerful tools to help users understand and present data. You can create various types of charts—bar charts, line charts, and pie charts—to visualize trends and patterns.
Filter and sort data
These features are essential for data analysis. Filtering allows users to display only the data that meets specific criteria, while sorting arranges data in a particular order. Users can analyze and find specific information within large datasets.
Collaborate
Online spreadsheets allow multiple users to work on the same document simultaneously. Features like comments, track changes, and sharing options facilitate teamwork and communication. These spreadsheets further enhance collaboration by providing real-time updates and accessibility from anywhere.
Advanced features
Macros
Macros are automated sequences of actions that can be recorded and executed to perform repetitive tasks. They’re created using scripting languages like Visual Basic for Applications (VBA) in Excel. Macros can save time and reduce errors by automating complex processes.
Scripting
Scripting involves writing code to automate tasks and enhance spreadsheet functionality. VBA is commonly used for scripting in Excel, allowing users to create custom functions, automate data manipulation, and interact with other applications. Python is also becoming popular for scripting in Excel, offering powerful data analysis and visualization capabilities.
Pivot tables
Pivot tables are powerful tools that help you summarize and analyze large datasets. You can group, filter, and aggregate data to identify trends and patterns. Pivot tables can be customized to display data in various formats, making it easier to interpret and present information.
Add-ins and plugins
Add-ins and plugins extend the functionality of spreadsheets by integrating external tools and features. Microsoft Office Add-ins, for example, can bring external data into Excel, automate documents, and provide interactive visualizations. They’re built using web code like HTML, CSS, and JavaScript.
Custom templates
Custom templates provide predesigned spreadsheet layouts that can be reused for specific tasks. They help maintain consistency and save time by providing a structured format for data entry and analysis. Users can create their own templates or use templates provided by spreadsheet applications.
Conditional formatting
Conditional formatting allows users to apply formatting to cells based on specific criteria. This feature helps highlight important data points, identify trends, and visualize patterns. Users can set rules to change the appearance of cells based on their values, making it easier to analyze and interpret data.
Accessibility
Keyboard shortcuts enhance navigation and efficiency and allow users to perform tasks quickly without relying on a mouse. Excel is also compatible with screen readers, which help visually impaired users navigate and understand the content. Features like alt text for images and the Accessibility Checker ensure that spreadsheets are accessible to everyone.
Security
Users can encrypt their spreadsheets to protect sensitive information and ensure that only authorized individuals can access the data. They can also set passwords for their spreadsheets to prevent unauthorized access.
Macros are automated sequences of actions that can be recorded and executed to perform repetitive tasks. They’re created using scripting languages like Visual Basic for Applications (VBA) in Excel. Macros can save time and reduce errors by automating complex processes.
Scripting
Scripting involves writing code to automate tasks and enhance spreadsheet functionality. VBA is commonly used for scripting in Excel, allowing users to create custom functions, automate data manipulation, and interact with other applications. Python is also becoming popular for scripting in Excel, offering powerful data analysis and visualization capabilities.
Pivot tables
Pivot tables are powerful tools that help you summarize and analyze large datasets. You can group, filter, and aggregate data to identify trends and patterns. Pivot tables can be customized to display data in various formats, making it easier to interpret and present information.
Add-ins and plugins
Add-ins and plugins extend the functionality of spreadsheets by integrating external tools and features. Microsoft Office Add-ins, for example, can bring external data into Excel, automate documents, and provide interactive visualizations. They’re built using web code like HTML, CSS, and JavaScript.
Custom templates
Custom templates provide predesigned spreadsheet layouts that can be reused for specific tasks. They help maintain consistency and save time by providing a structured format for data entry and analysis. Users can create their own templates or use templates provided by spreadsheet applications.
Conditional formatting
Conditional formatting allows users to apply formatting to cells based on specific criteria. This feature helps highlight important data points, identify trends, and visualize patterns. Users can set rules to change the appearance of cells based on their values, making it easier to analyze and interpret data.
Accessibility
Keyboard shortcuts enhance navigation and efficiency and allow users to perform tasks quickly without relying on a mouse. Excel is also compatible with screen readers, which help visually impaired users navigate and understand the content. Features like alt text for images and the Accessibility Checker ensure that spreadsheets are accessible to everyone.
Security
Users can encrypt their spreadsheets to protect sensitive information and ensure that only authorized individuals can access the data. They can also set passwords for their spreadsheets to prevent unauthorized access.
Integration capabilities
Integrating spreadsheets with other applications like customer relationship management (CRM) and enterprise resource planning (ERP) systems can optimize their operations, improve data management, and enhance overall productivity.
By linking spreadsheets with CRM tools, users can:
By linking spreadsheets with CRM tools, users can:
- Easily import and export customer data between spreadsheets and CRM systems, ensuring data consistency and reducing manual entry.
- Automatically update customer information in the CRM system based on changes made in the spreadsheet.
- Create detailed reports and dashboards by combining CRM data with spreadsheet analysis tools.
- Ensure that financial, inventory, and operational data are consistently synchronized across both spreadsheets and ERP systems.
- Use spreadsheet functions to perform advanced analysis of ERP data, identify trends, and make informed decisions.
- Streamline workflows by automating data transfers and updates between spreadsheets and ERP systems.
Type of spreadsheet applications
Desktop-based spreadsheets
The most popular desktop-based spreadsheet software is Excel, which provides a range of functionalities, including data input, formulas, charting, and collaboration. It’s widely used in business, education, and personal financial planning for tasks such as budgeting, financial analysis, and project management.
Online spreadsheets
Online tools allow users to access and edit spreadsheets from any device with an internet connection. Google Sheets is a prominent example, which offers real-time collaboration, automatic saving to the cloud, and integration with other Google Workspace applications.
Mobile apps
Microsoft Excel Mobile and Google Sheets Mobile are popular mobile spreadsheet apps, which can be accessed on phones and tablets. These apps offer many of the same features as their desktop and online counterparts, including data input, formulas, and charting. Mobile apps are convenient for quick data entry and analysis while away from a computer.
Open-source alternatives
These free spreadsheets can be modified by users to suit their needs. LibreOffice Calc and Apache OpenOffice Calc are well-known software that provide similar functionalities to Excel, including data input, formulas, and charting. Open-source tools are a cost-effective option for individuals and organizations looking for customizable spreadsheet solutions.
From an accessibility standpoint, desktop spreadsheets offer robust user-friendliness and security features, while online tools are best for collaboration and are accessible from anywhere. Both solutions provide valuable integration capabilities to enhance productivity.
The most popular desktop-based spreadsheet software is Excel, which provides a range of functionalities, including data input, formulas, charting, and collaboration. It’s widely used in business, education, and personal financial planning for tasks such as budgeting, financial analysis, and project management.
Online spreadsheets
Online tools allow users to access and edit spreadsheets from any device with an internet connection. Google Sheets is a prominent example, which offers real-time collaboration, automatic saving to the cloud, and integration with other Google Workspace applications.
Mobile apps
Microsoft Excel Mobile and Google Sheets Mobile are popular mobile spreadsheet apps, which can be accessed on phones and tablets. These apps offer many of the same features as their desktop and online counterparts, including data input, formulas, and charting. Mobile apps are convenient for quick data entry and analysis while away from a computer.
Open-source alternatives
These free spreadsheets can be modified by users to suit their needs. LibreOffice Calc and Apache OpenOffice Calc are well-known software that provide similar functionalities to Excel, including data input, formulas, and charting. Open-source tools are a cost-effective option for individuals and organizations looking for customizable spreadsheet solutions.
From an accessibility standpoint, desktop spreadsheets offer robust user-friendliness and security features, while online tools are best for collaboration and are accessible from anywhere. Both solutions provide valuable integration capabilities to enhance productivity.
Spreadsheet benefits
Spreadsheets offer numerous benefits, particularly for collaborative work. They allow multiple users to work on the same document simultaneously, enhancing teamwork and ensuring that everyone is on the same page. Online spreadsheets also automatically save your work to the cloud, providing accessibility from any device with an internet connection.
Other key benefits include:
Other key benefits include:
- Streamlining data organization and analysis—you can input, sort, filter, and visualize data efficiently to identify trends, make informed decisions, and present data in a structured manner.
- Automating calculations and complex processes—functions, formulas, and macros help reduce manual effort and minimize errors, simplifying tasks like budgeting, forecasting, and financial analysis.
- Data versatility—spreadsheets can handle various types of data, including text, numbers, dates, and formulas. They can be used for a wide range of tasks, making them valuable in different fields.
Challenges
As with any tool or software, issues can arise. Here are some things to look out for when using spreadsheets:
- Human error—one of the most common reasons something isn’t working. Errors can occur due to manual data input, incorrect formula references, or accidental overwriting. These mistakes can be difficult to detect and may require extensive review to identify and correct.
- Learning curve for advanced functions—macros, scripting, and pivot tables can have a steep learning curve. You may need to invest significant time and effort to master these features, which can be a barrier to productivity.
- Scalability issues with large datasets—as data volume increases, performance can degrade, leading to slower processing times and potential crashes. Managing and analyzing large datasets can become cumbersome, and the spreadsheets may not be able to efficiently handle complex calculations or data manipulations.
- Potential security vulnerabilities—sharing spreadsheets can introduce security vulnerabilities, especially if sensitive information is involved. Unauthorized access, data breaches, and accidental sharing of confidential data are potential risks.
Best practices
While those issues can hamper productivity, they can be avoided with a little extra attention. Here are some tips for maintaining organized and error-free spreadsheets:
Consistent formatting
Using consistent formatting helps ensure that your spreadsheet is easy to read and understand. Apply uniform styles for fonts, colors, and borders across your spreadsheet. Conditional formatting can highlight important points based on specific criteria. This helps maintain a clean and professional appearance.
Naming conventions
Adopting clear and consistent naming conventions for your cells, ranges, and sheets can significantly improve the organization of your spreadsheet. Use descriptive names that reflect the content or purpose of the data. For example, instead of using generic names like Sheet1 or Data1, use names like SalesData or MonthlyBudget.
Avoid hardcoded values in formulas
Hardcoding values in formulas can lead to errors and make your spreadsheet difficult to maintain. Instead, use cell references and named ranges to create dynamic formulas. This ensures that your calculations are automatically updated when the data changes. For example, instead of writing =A1 + 100, use =A1 + B1 where B1 contains the value 100. This approach reduces the risk of errors and makes your formulas more flexible.
Break data into separate sheets
An effective strategy for large datasets is to break your data into separate sheets within the same spreadsheet file. This approach helps in organizing data logically and reduces the complexity of handling large volumes of information. You can create different sheets for various categories or time periods, making it easier to navigate and analyze specific subsets of data.
Use filters
Filters are powerful tools for managing large datasets. They allow you to display only the data that meets specific criteria, making it easier to focus on relevant information. By applying filters, you can quickly find and analyze specific data points and identify patterns without having to sift through the entire dataset.
Use pivot tables
Pivot tables are invaluable for when you need to summarize and analyze large datasets. They allow you to group, filter, and aggregate data to identify trends and patterns. They can also be customized to display data in various formats, making it easier to interpret and present information. By using pivot tables, you can efficiently manage and analyze large volumes of data, transforming complex datasets into meaningful insights.
Additional tips
Consistent formatting
Using consistent formatting helps ensure that your spreadsheet is easy to read and understand. Apply uniform styles for fonts, colors, and borders across your spreadsheet. Conditional formatting can highlight important points based on specific criteria. This helps maintain a clean and professional appearance.
Naming conventions
Adopting clear and consistent naming conventions for your cells, ranges, and sheets can significantly improve the organization of your spreadsheet. Use descriptive names that reflect the content or purpose of the data. For example, instead of using generic names like Sheet1 or Data1, use names like SalesData or MonthlyBudget.
Avoid hardcoded values in formulas
Hardcoding values in formulas can lead to errors and make your spreadsheet difficult to maintain. Instead, use cell references and named ranges to create dynamic formulas. This ensures that your calculations are automatically updated when the data changes. For example, instead of writing =A1 + 100, use =A1 + B1 where B1 contains the value 100. This approach reduces the risk of errors and makes your formulas more flexible.
Break data into separate sheets
An effective strategy for large datasets is to break your data into separate sheets within the same spreadsheet file. This approach helps in organizing data logically and reduces the complexity of handling large volumes of information. You can create different sheets for various categories or time periods, making it easier to navigate and analyze specific subsets of data.
Use filters
Filters are powerful tools for managing large datasets. They allow you to display only the data that meets specific criteria, making it easier to focus on relevant information. By applying filters, you can quickly find and analyze specific data points and identify patterns without having to sift through the entire dataset.
Use pivot tables
Pivot tables are invaluable for when you need to summarize and analyze large datasets. They allow you to group, filter, and aggregate data to identify trends and patterns. They can also be customized to display data in various formats, making it easier to interpret and present information. By using pivot tables, you can efficiently manage and analyze large volumes of data, transforming complex datasets into meaningful insights.
Additional tips
- Data Validation. Ensure that the entered data meets specific criteria. This helps prevent errors and maintain data integrity.
- Documentation. Include comments and documentation within your spreadsheet to explain complex formulas and data sources. This makes it easier for others to understand and use your spreadsheet.
- Regular Reviews. Audit your spreadsheet regularly to identify and correct any errors. This helps maintain accuracy and reliability.
Future trends in spreadsheets
The future of spreadsheets is poised for significant transformation, driven by advancements in technology and evolving user needs.
AI for data analysis
AI is improving data analysis by providing more accurate and efficient insights. AI-powered tools can process vast amounts of data quickly, identify patterns, and make predictions. The future of AI in data analysis includes more advanced algorithms, machine learning models, and automated analytics, which will further improve the accuracy and speed of data processing.
Enhanced collaboration features
Tools like Microsoft Teams offer real-time collaboration, allowing multiple users to work on the same document simultaneously. These features improve communication, streamline workflows, and increase productivity. Future trends in collaboration include AI-powered assistants that can automate tasks and provide recommendations.
Cloud-based solutions offer increased accessibility
The cloud is revolutionizing the way businesses operate by providing increased accessibility and flexibility. These solutions allow users to access data and applications from anywhere, at any time and on any device. Cloud-based tools also include more robust security measures, improved scalability, and enhanced integration with other applications.
Improved visualization
Visualization tools are essential for understanding and presenting data effectively. Advanced visualization tools like Power BI offer interactive dashboards, charts, and graphs that help users interpret complex data. AI-powered tools can also automatically generate and provide more intuitive and customizable visualizations, making it easier for users to gain insights and make data-driven decisions.
AI for data analysis
AI is improving data analysis by providing more accurate and efficient insights. AI-powered tools can process vast amounts of data quickly, identify patterns, and make predictions. The future of AI in data analysis includes more advanced algorithms, machine learning models, and automated analytics, which will further improve the accuracy and speed of data processing.
Enhanced collaboration features
Tools like Microsoft Teams offer real-time collaboration, allowing multiple users to work on the same document simultaneously. These features improve communication, streamline workflows, and increase productivity. Future trends in collaboration include AI-powered assistants that can automate tasks and provide recommendations.
Cloud-based solutions offer increased accessibility
The cloud is revolutionizing the way businesses operate by providing increased accessibility and flexibility. These solutions allow users to access data and applications from anywhere, at any time and on any device. Cloud-based tools also include more robust security measures, improved scalability, and enhanced integration with other applications.
Improved visualization
Visualization tools are essential for understanding and presenting data effectively. Advanced visualization tools like Power BI offer interactive dashboards, charts, and graphs that help users interpret complex data. AI-powered tools can also automatically generate and provide more intuitive and customizable visualizations, making it easier for users to gain insights and make data-driven decisions.
Microsoft and spreadsheet solutions
Spreadsheets are indispensable tools for organizing, calculating, and analyzing data across various industries. Their versatility allows users to perform complex calculations, create charts, and manage data efficiently. As we look to the future, advancements in AI, enhanced collaboration features, cloud-based solutions, and improved visualization tools will continue to elevate the capabilities of spreadsheets.
For those seeking a comprehensive and powerful spreadsheet solution, Excel offers a wide range of features, including data input and management, calculation functions and formulas, and charting and data visualization tools. With its robust functionality and integration capabilities, Excel is well-equipped to meet the diverse needs of users in business, education, and personal financial planning.
Explore Excel to experience the full potential of spreadsheet technology and enhance your productivity and data management capabilities.
For those seeking a comprehensive and powerful spreadsheet solution, Excel offers a wide range of features, including data input and management, calculation functions and formulas, and charting and data visualization tools. With its robust functionality and integration capabilities, Excel is well-equipped to meet the diverse needs of users in business, education, and personal financial planning.
Explore Excel to experience the full potential of spreadsheet technology and enhance your productivity and data management capabilities.
FAQ
FAQ
- A spreadsheet is a digital document designed to organize, calculate, and analyze data in rows and columns. It lets you perform complex calculations, create charts, and manage data efficiently. Spreadsheets are commonly used for budgeting, data analysis, and project management. They can handle various types of data, including text, numbers, dates, and formulas, making them versatile tools for different tasks.
- Spreadsheets perform various functions, including data input and management, calculation functions and formulas, charting and data visualization tools, filtering and sorting for data analysis, and collaboration features. They automate calculations, enhance data manipulation, and provide powerful tools for organizing, analyzing, and presenting data.
- Common spreadsheet features include data input and management, calculation functions and formulas, charting and visualization tools, filtering and sorting for data analysis, and collaboration features. Advanced functionalities include macros, scripting, pivot tables, add-ins, plugins, custom templates, and conditional formatting.
- To make a spreadsheet, open a spreadsheet application like Excel or Google Sheets. Create a new document and enter data into cells organized in rows and columns. Use formulas to perform calculations, format cells for better readability, and create charts for data visualization. Save your spreadsheet to keep your work.
- Businesses use spreadsheets to track inventory levels, costs, and sales prices. This helps in managing stock and calculating the total value of inventory. They’re also commonly used for budgeting, allowing individuals and businesses to track income and expenses, and create data-driven budgets.
Follow Microsoft 365