Data Entry Skills via Google Sheets : A Practical Course

Explore the data entry skill and Google Sheets, a web-based spreadsheet, for accurate data entry and online collaboration. Learn four advantages—free, web-based, real-time saving, and real-time collaboration—over Excel.

Learn how to download Google Sheets to your computer and use offline mode, enabling offline editing and seamless syncing with Google Drive.

Learn three ways to access and create a new blank Google Sheets, including the blank spreadsheet option, typing sheets dot new, and using Google Drive's new to Google Sheets flow.

Learn the Google Sheets interface, from opening a blank spreadsheet and naming files to using menus, cells, columns, rows, sharing, moving, undoing, and zooming.

Master data entry in Google Sheets by entering data, adjusting columns and rows, and applying basic formatting and autofill for years, months, and salaries.

Master Google Sheets basics by renaming, coloring, duplicating, hiding, and deleting sheets, and by copying data to a new spreadsheet with cloud autosave and quick statistics.

Export and import files between Microsoft Excel, CSV, and Google Sheets, using upload or file picker, and download in formats like Excel, PDF, or CSV.

Learn to auto sync Google Sheets with MS Excel using Power Query. Publish the sheet to web, connect via a link, and enable auto update to refresh data in Excel.

Learn to use arithmetic and mathematical functions in Google Sheets to compute total and average marks, analyze subject-wise performance, and evaluate teacher performance.

Explore how to use the sum function in Google Sheets, including syntax, range selection, and a practical example calculating quarterly totals for fruit sales.

Learn to calculate the average in Google Sheets using the average function across a range, with syntax =AVERAGE(range) and adjusting decimals for clear reporting.

Use the max function in Google Sheets to find the largest value in a range. Calculate monthly maximum values from the dataset, such as January, February, and March.

Use the min function in Google Sheets to find the smallest value in a range, by entering an equal sign and selecting the range, shown with monthly sales data.

Learn how to use the round function in Google Sheets to round numbers to a chosen number of digits, using the syntax =ROUND(number, digits) with practical examples.

Learn to use the sum if function in Google Sheets to sum values by a single criterion, using a range and double-quoted criteria, with January sales over 26,000 totaling 143,451.

Learn how to use the Excel count function to tally numeric values in a range, using =count(selected range) to count how many fruits appear in January, totaling ten.

Master the counta function to count text and string values in Google Sheets, compare it with the count function for numbers, and apply a fruits exercise showing ten fruits.

Master the countif function in google sheets to count cells meeting a criterion, using a range and criteria, with a practical example counting january sales above 26,000 for fruits.

Master the rank function in Google Sheets: use the third parameter to choose descending (0) or ascending (1) order, compute totals with sum, and lock ranges (F4) for consistent ranking.

Learn to use the left function in Google Sheets to extract characters from the left, apply it to QR code values to obtain the year, and autofill results.

Learn the right function in Google Sheets to extract characters from the end of a text string, with syntax =right(text, num_chars) and practical QR code examples.

Explore the mid function in spreadsheets to extract a chosen number of characters from the middle of text, using =MID(text, start_num, num_chars) with fruit-name examples.

Master the concatenate function in Google Sheets to join text from multiple cells into one, using the equals sign, bracket, and commas, with examples like apple price is $10.

Learn how to use the upper function in Google Sheets to convert text to uppercase, including the equal sign, function call, and autofill to apply it to product names.

Convert text to lowercase in Google Sheets with the lower function, a built-in string function, using the syntax =lower(text); apply to product names and drag to autofill.

Apply the proper function to capitalize first character of each word and lowercase the rest, using equals sign, select the text or cell, then close the bracket and press enter.

Use the trim function in Google Sheets to remove leading, trailing, and extra spaces. Practice =trim(text) to clean product names and ensure single spaces between words.

Master the repeat function in Google Sheets, a data and related text function, to repeat text a specified number of times, using the syntax =repeat(text, times) with practical examples.

Explore the exact function in Google Sheets for case-sensitive string comparisons, returning true when texts match and false when they do not. Understand the syntax and see practical examples.

Introduce date and time functions in Google Sheets, show uploading chapter eight files via the home page file picker, and note ten major date and time functions available.

Learn to insert the current date and time in Google Sheets using the now function, including the correct syntax with equals sign and parentheses for real‑time data entries.

Master the today function in Google Sheets to insert the current date with =today() and format it using the number format or the custom date and time option.

Learn to extract the year from a date in Google Sheets using the year function, by entering =year(date) and applying it across a date column.

Learn to extract a month number from a date in Google Sheets with the month function, using =MONTH(date) and examples like 1 for January and 5 for May.

Use the day function to extract the day from a date in Google Sheets, returning 1–31 with =day(date). Practice with an order date and arrange dates with the date function.

Use the hour function to extract the hour component from a time, returning a number 0–23. For example, 9:30 a.m. yields 9 by entering =hour(time) after selecting the time.

Learn how to use the minute function in Google Sheets to extract the minute component from a time, returning a value from 0 to 59, demonstrated with 9:45 a.m.

Learn to use time function in Google Sheets to create a time from hours and minutes, extract hours and minutes, and insert it into formulas, including 24-hour to 12-hour display.

Use the edate function to return a date on the same day of the month in past or future, enabling expiration or due date calculations with =edate(start_date, months).

Learn to use the datediff function in Google Sheets to calculate date differences by year or month, using today as the end date to compute age in years or months.

Explore practical conditional formatting in Google Sheets by applying rules to highlight empty cells, scores above or below thresholds, total and average marks, rankings, and gender-based highlights.