GOOGLE SHEET

EMPOWER LIMITLESS STATISTICS

In Google Doc We Trust!

Transform Your Academic Workflow, Research and Analysis with Google Sheets

Google Sheets, a powerful spreadsheet application within Google Workspace for Education, is a game-changer for researchers, statisticians, and students at the University of Duhok (UOD). By leveraging Google Sheets, you can streamline data collection, analysis, and collaboration, unlocking a world of possibilities for your academic endeavours.

Why Google Sheets?

Effortless Data Collection and Organization: Create and customize spreadsheets to capture, organize, and analyse data with ease.
Robust Data Analysis: Leverage built-in functions and formulas to perform complex calculations, generate reports, and extract valuable insights from your data.
Real-time Collaboration: Work seamlessly with colleagues on the same spreadsheet, making it ideal for collaborative research projects and data sharing.
Visualize Data Effectively: Create charts, graphs, and other visualizations to present your findings in a clear and engaging manner.
Secure and Accessible: Your data is stored securely in the cloud, accessible from any device with an internet connection.
Integration with Google Workspace: Seamlessly integrate Google Sheets with other Google Workspace tools like Docs, Slides, and Forms, streamlining your workflow.

Say Goodbye to Unlicensed Applications

Leave behind the limitations and risks associated with unlicensed software. Google Sheets offers a reliable, secure, and feature-rich alternative that aligns with UOD's commitment to academic excellence.

Enhanced Security: Google Sheets prioritizes data security, protecting your sensitive information with robust encryption and access controls.
Cost-Effective: Google Workspace offers a cost-effective solution compared to expensive, proprietary software.
Regular Updates and Improvements: Google continuously updates and improves Google Sheets, ensuring you have access to the latest features and functionalities.
Seamless Integration: Google Sheets seamlessly integrates with other Google Workspace tools, creating a cohesive and efficient working environment.

Unlock the Potential of Google Sheets for Your Academic Research

Whether you're conducting in-depth data analysis, creating simple surveys, or managing research projects, Google Sheets is the ideal tool to streamline your workflow and achieve your academic goals.

Training and Support: DOIS provides comprehensive training and online resources to help you master Google Sheets and its capabilities. Our dedicated team is ready to assist you with any questions or challenges you may encounter.
Cultivating Collaboration: Embrace the power of collaboration within the UOD community. Use Google Sheets to share data, work together on projects, and foster a spirit of teamwork.

Get Started Today!

Explore Google Sheets: Visit the Google Sheets Help Center for tutorials and resources:
UOD Google Workspace Training: (Click to Access)

DOIS is committed to supporting your academic success. Let's harness the power of Google Sheets together!

Get started with Sheets

Switch from Microsoft Excel to Sheets

Tips to format & clean up data

Add your logo or checkboxes
Color-code tabs & data entries
Space, split, or swap rows & columns
Format currencies & validate email addresses

UOD DIGITAL SKILLS SPACE

How can I use my old MS Excel files in Google Sheets?

ou can easily open your Excel files in Google Sheets. Simply upload your Excel file (.xlsx) to Google Drive, then right-click the file, select Open with, and choose Google Sheets. Your file will automatically convert to a Google Sheets format, allowing you to edit and collaborate with others in real time.

You can easily import your Excel files into Google Sheets by following these steps:

Open or create a spreadsheet in Google Sheets
Click File
Click Import
Select the Excel file and click Select
Choose an import option:
- Create new spreadsheet: Creates a new Google Sheets document with the imported Excel data
- Insert new sheet(s): Adds the Excel data as a new sheet or sheets within your existing Google Sheets document
- Replace spreadsheet: Overwrites the data in your current Google Sheets document with the data from the Excel file
- Append rows to current sheet: Adds the Excel data to the end of your existing sheet, preserving your current data
Click Import data
If prompted, click Open now

Are there any limitations to using Google Sheets compared to Excel?

While Google Sheets offers many of the same features as Excel, there may be some minor differences in functionality or advanced features. However, Google Sheets is constantly being updated with new features, and its capabilities are continually expanding.

Can I collaborate with others on my Excel files using Google Sheets?

Absolutely! When you open your Excel file in Google Sheets, you can share it with others using Share in the top-right corner. Google Sheets allows multiple users to edit the document simultaneously, making it easier for teams to collaborate in real time.

Google Sheets is designed for collaboration. Simply share your spreadsheet with others, and they can view, edit, and comment on it simultaneously. You can also set different permissions for different users.

Can I use custom functions and formulas in Google Sheets?

Yes, you can use custom functions and formulas in Google Sheets just like you would in Excel. Google Sheets also offers a variety of built-in functions that can be used to perform calculations and analysis.

How can I access my Google Sheets from anywhere?

Google Sheets is a cloud-based application, so you can access your spreadsheets from any device with an internet connection. This means you can work on your spreadsheets from your computer, tablet, or smartphone. Simply log into your University Google Workspace and access your Google Drive including Google Sheets from anywhere, on any device with Internet access.

Can I save or export Google Sheets files back to Excel format?

Yes, you can easily download your Google Sheets document as an Excel file. Go to File > Download and choose Microsoft Excel (.xlsx). This will convert your Google Sheet back into an Excel file format.

Will my Excel formulas work in Google Sheets?

Most Excel formulas will work in Google Sheets without any modifications. Common functions like SUM, AVERAGE, IF, and VLOOKUP are fully supported. However, some advanced or Excel-specific functions might need to be adjusted. Google Sheets offers alternatives and even some unique functions, like GOOGLEFINANCE and IMPORTRANGE.