Generated by All in One SEO v5.0.0.1, this is an llms.txt file, used by LLMs to index the site.

# Learn Google Workspace & Apps Script

How to use Sheets, Drive, Docs, Forms, Meet, Sites, Slides & Apps Script

## Sitemaps

- [XML Sitemap](https://bazroberts.com/sitemap.xml): Contains all public & indexable URLs for this website.

## Posts

- [Google Workspace Tutorials](https://bazroberts.com/tutorials/) - Home page for step-by-step tutorials on Google Workspace (e.g. apps like Google Sheets, Google Docs, etc) and Google Apps Script which can automate these.
- [Google Sheets  - How to use Sparklines (mini-graphs)](https://bazroberts.com/2016/03/26/google-sheets-sparklines-mini-graphs/) - Step-by-step tutorial on how to use the SPARKLINE function in Google Sheets, along with practical examples showing how to use sparklines.
- [Create Timelines in Google Sheets with Ease](https://bazroberts.com/2025/11/24/create-timelines-in-google-sheets-with-ease/) - Learn to automatically create timelines in Google Sheets for event planning, task management, and more. Quick setup, customisation tips, and visual clarity.
- [Quickly turn Images into Dynamic Videos with Gemini & Veo 3](https://bazroberts.com/2025/11/12/quickly-turn-images-into-dynamic-videos-with-gemini-veo-3/) - Learn how to quickly convert a still image into a dynamic, short video using Gemini & Veo 3. I show you an example, where I tweak the prompt to get what I want.
- [Quick Image Editing with Nano Banana in Gemini](https://bazroberts.com/2025/11/04/quick-image-editing-with-nano-banana-in-gemini/) - Revolutionize business visuals with AI. Learn how Nano Banana in Gemini offers quick image creation & editing for e-commerce, marketing & more. 8 great business uses!
- [Become a Master Baker with Gemini's Guided Learning!](https://bazroberts.com/2025/10/21/become-a-master-baker-with-geminis-guided-learning/) - Have you ever followed a recipe to the letter only to find your results were... less than perfect? Gemini's Guided Learning feature is here to change that, transforming the way you approach new skills and complex tasks. It acts as your step-by-step personal tutor for any topic, moving you beyond just reading instructions to truly
- [Transform Your Learning with Gemini Canvas Quizzes](https://bazroberts.com/2025/10/13/quickly-make-quizzes-with-gemini-canvas/) - Use Gemini Canvas to instantly create interactive quizzes from notes, PDFs, or research. Learn how easy it is to use, with 3 practical examples!
- [Gemini AI in your Google Sheets cells](https://bazroberts.com/2025/09/23/gemini-ai-in-your-google-sheets-cells/) - Boost your productivity with Google Sheets' new AI function. Learn how to use it for student feedback, sales outreach emails, and HR feedback analysis.
- [Try out NotebookLM’s Video Overviews](https://bazroberts.com/2025/09/18/try-out-notebooklms-video-overviews/) - Learn how to create video overviews in minutes from your source material using Google's NotebookLM, your free AI-powered research and writing assistant.
- [Quickly create illustrated storybooks with Gemini](https://bazroberts.com/2025/09/08/quickly-create-illustrated-storybooks-with-gemini/) - An example of how to use Gemini's Storybook and to create illustrated storybooks in minutes. Plus, a list of possible ideas of what to use it for.
- [Easily Create and Customise Drop-Down Menus in Google Sheets](https://bazroberts.com/2025/09/02/easily-create-and-customise-drop-down-menus-in-google-sheets/) - Learn how to add and edit drop-down menus in Google Sheets to streamline data input. Explore manual options, dynamic lists, and advanced features in this quick guide.
- [Transform Your Spreadsheets with Google Sheets Tables](https://bazroberts.com/2025/05/19/transform-your-spreadsheets-with-google-sheets-tables/) - Learn how to use the new Google Tables in Google Sheets. Easily organise and manipulate your data, including how to filter and group data with ease.
- [How to Share, Download & Email Files in Google Sheets](https://bazroberts.com/2025/04/06/how-to-share-download-email-files-in-google-sheets/) - Learn how to share Google Sheets with others, download spreadsheets in different formats, and email collaborators or send the file to others with ease.
- [How to use Cell & Version History in Google Sheets](https://bazroberts.com/2025/03/30/how-to-use-cell-version-history-in-google-sheets/) - Learn how to track changes in Google Sheets with Version History and Cell Edit History. Restore versions, name them, and view cell edit history easily.
- [How to merge cells in Google Sheets for clearer data](https://bazroberts.com/2025/02/16/how-to-merge-cells-in-google-sheets-for-clearer-data/) - Learn how to merge cells in Google Sheets for better data organisation. Follow step-by-step instructions to merge all cells, or just vertically or horizontally.
- [How to use Notes & Comments in Google Sheets](https://bazroberts.com/2025/01/28/how-to-use-notes-comments-in-google-sheets/) - Learn how to use Notes & Comments in Google Sheets to add information, collaborate, and assign tasks. Boost productivity with these tools in your spreadsheets!
- [How to show multiple series on charts in Google Sheets](https://bazroberts.com/2025/01/21/how-to-show-multiple-series-on-charts-in-google-sheets/) - Learn how to create Google Sheets charts with multiple series. Including how to add data series, use dual axes, and format lines for professional results.
- [Create charts in Google Sheets with ease](https://bazroberts.com/2025/01/09/quickly-create-charts-in-google-sheets-with-ease/) - Learn how to create, edit, and customise charts in Google Sheets. From chart types to gridlines, discover ways to turn data into impactful visuals.
- [Chart your data with Sparklines in Google Sheets](https://bazroberts.com/2025/01/06/chart-your-data-with-sparklines-in-google-sheets/) - Learn how to create and customise sparklines in Google Sheets. Visualise trends, compare data, and enhance your dashboards with these mini-graphs.
- [Google Workspace 2024 Recap (Pt 2)](https://bazroberts.com/2025/01/03/google-workspace-2024-recap-pt-2/) - Recap of the new features that came out in 2024 in Google Workspace. Covers: Google Forms, Docs, & Slides. Plus, two new products: Google Vids & Notebook LM!
- [Google Workspace - 2024 Recap (Pt 1)](https://bazroberts.com/2024/12/29/google-workspace-2024-recap-pt-1/) - A summary of the new features that came out in Google Workspace in 2024. This is part 1 and covers Chat, Drive, Sheets, Meet, and Forms.
- [Master Conditional Formatting in Google Sheets in Minutes](https://bazroberts.com/2024/12/25/master-conditional-formatting-in-google-sheets-in-minutes/) - Learn how to use conditional formatting in Google Sheets to highlight key data automatically. Includes using colour scales and custom formulas.
- [Summary of Google Workspace 2023 new features (Pt 1)](https://bazroberts.com/2024/01/03/summary-of-google-workspace-2023-new-features-pt-1/) - Summary of the best improvements that came to Google Workspace in 2023 and in particular to Google Sheets, Docs, and Drive and Bard.
- [Google Slides - Layers, arrange & groups](https://bazroberts.com/2016/05/29/google-slides-layers-arrange-groups/) - Google Slides step-by-step tutorial on how to use layers, how to arrange objects on the slide, and how to group objects. Following a practical example.
- [Google Sheets - Grouping rows and columns](https://bazroberts.com/2021/05/19/google-sheets-grouping-rows-and-columns/) - A step-by-step tutorial on how to group and ungroup rows and columns to hide multiple ones in Google Sheets using the grouping option.
- [How to quickly sort data in Google Sheets](https://bazroberts.com/2024/12/16/how-to-quickly-sort-data-in-google-sheets/) - In this quick tutorial, learn how to sort data in Google Sheets, from A-Z or Z-A, with or without headers, with multiple criteria, and even randomise data.
- [How to sort in Google Sheets](https://bazroberts.com/2024/03/18/how-to-sort-in-google-sheets/) - A step-by-step tutorial on how to sort in Google Sheets. This includes sorting data in a single column and across multiple columns.
- [Apps Script Basics - Variables and getting & setting values](https://bazroberts.com/2017/03/31/apps-script-basics-variables-and-getting-setting-values/) - Step-by-step tutorial on how to work with variables in Google Apps Script, and to get and set values in a Google Sheet.
- [Sheets Functions - WEEKDAY, WORKDAY, NETWORKDAYS, EDATE, EOMONTH](https://bazroberts.com/2016/11/23/google-sheets-functions-weekday-workday-networkdays-edate-eomonth/) - Step-by-step tutorial on how to use the Google Sheets functions WEEKDAY, WORKDAY, NETWORKDAYS, EDATE, EOMONTH. With 7 practical examples.
- [Google’s AirTable rival, Tables, moves from beta test to become a Google Cloud product](https://bazroberts.com/2021/06/15/googles-airtable-rival-tables-graduates-from-beta-test-to-become-a-google-cloud-product-techcrunch/) - Google’s AirTable rival, Tables, graduates from beta test to become a Google Cloud product – TechCrunch — Read on techcrunch.com/2021/06/14/googles-airtable-rival-tables-graduates-from-beta-test-to-become-a-google-cloud-product/amp/
- [Create a Placement Test with Google Forms & Sheets](https://bazroberts.com/2017/03/13/placement-test/) - Step-by-step tutorial on how to create an English placement test which automatically works out the score and level using Google Forms and Sheets.
- [Create a Book inventory with Google Sheets & Apps Script](https://bazroberts.com/2017/02/10/book-inventory/) - Step-by-step tutorial on how to make a book inventory system using Google Sheets and Google Apps Script. Record the details of the books & the location of them.
- [Mastering Filters and Filter Views in Google Sheets](https://bazroberts.com/2024/12/12/mastering-filters-and-filter-views-in-google-sheets/) - Learn how to filter data in Google Sheets by value, condition, and colour. Create Filter Views for shareable data views, which don't affect others' displays.
- [Manage Sheets rows & columns like a pro](https://bazroberts.com/2024/11/18/manage-sheets-rows-columns-like-a-pro/) - Learn how to select, delete, hide, freeze, and group rows and columns in Google Sheets for a cleaner, more organized spreadsheet layout.
- [Enhance your Google Sheets: Cell Formatting](https://bazroberts.com/2024/09/25/enhance-your-google-sheets-cell-formatting/) - A summary of cell formatting tools which make your spreadsheet data easier to understand - Borders, fill colour, alignment, fonts, text wrap, and text rotation.
- [Working with Multiple Sheets in Google Sheets](https://bazroberts.com/2024/12/02/working-with-multiple-sheets-in-google-sheets/) - Learn to rename, colour, move, hide, & reference multiple sheets in Google Sheets. A guide to mastering tabs and interconnecting sheets for better organisation.
- [Using Google Meet directly from Sheets Docs & Slides](https://bazroberts.com/2022/05/05/using-google-meet-directly-from-sheets-docs-slides/) - A step-by-step tutorial on how to use Google Meet in the sidebar directly from Google Sheets, Google Docs & Google Slides
- [Importing Amazon royalty data from Excel to Google Sheet](https://bazroberts.com/2022/04/24/importing-amazon-royalty-data-from-excel-to-google-sheet/) - A step-by-step tutorial on how to import Amazon royalty data in an Excel to a Google Sheet using Apps Script.
- [Google Sheets: Moving, Copying & Pasting Data](https://bazroberts.com/2024/11/27/google-sheets-moving-copying-pasting-data-2/) - Discover time-saving tips for moving, copying, and pasting data in Google Sheets. Master paste special options, like paste values, plus, sequential numbers.
- [Alternating Row colours in Google Sheets](https://bazroberts.com/2024/11/25/alternating-row-colours-in-google-sheets/) - Learn how to use alternating colours in Google Sheets to make your tables visually appealing and easier to read. Quick steps with customisation tips included.
- [How to automate Google Sheets tasks with Macros](https://bazroberts.com/2022/01/17/how-to-automate-google-sheets-tasks-with-macros/) - A step-by-step tutorial on how to automate Google Sheets with Macros. This contains some practical examples showing how they are used.
- [JavaScript - Template Literals](https://bazroberts.com/2022/09/14/javascript-template-literals/) - Tutorial on how to use template literals in JavaScript & Apps Script, including mixing strings, variables and variables.
- [How to make an automatic team maker app using Apps Script](https://bazroberts.com/2022/09/28/automatic-team-maker-apps-script/) - A step-by-step tutorial on making an automatic team maker which will create two evenly-matched teams based on players' rating, using Apps Script.
- [Learn how to make a World Cup  game using Apps Script](https://bazroberts.com/2022/11/10/world-cup-game-using-apps-script/) - A step-by-step tutorial on how to make a World Cup game using Google Sheets, Google Sites, and Google Apps Script.
- [How to easily create a timeline in Google Sheets](https://bazroberts.com/2022/11/28/google-sheets-timeline/) - A step-by-step tutorial on how to make a timeline in Google Sheets, which is a simple yet powerful way to view your date-related data.
- [How to set up data validation in Google Sheets](https://bazroberts.com/2023/02/19/how-to-set-up-data-validation-in-google-sheets/) - Step-step tutorial on how to set up data validation in Google Sheets. This controls what type of data can be entered into the cells.
- [Google Forms - How to add titles and sections](https://bazroberts.com/2024/02/28/google-forms-adding-titles-sections/) - A step-by-step tutorial on how to add titles and sections in Google Forms. Plus, how to reorder them. Also how to preview your form.
- [Google Drive (6) - How to manage files and folders](https://bazroberts.com/2016/01/06/google-drive-how-to-manage-files-and-folders/) - You've got into Google Drive, now you need some files and folders to store in it. Let's go through the most common actions you do with files and folders: creating, naming, copying, and deleting. 'Moving' I will cover in a different post as there are different ways to do this. Creating a file As an
- [Google Drive (5) - How does it work?](https://bazroberts.com/2016/01/05/google-drive-how-does-it-work/) - An overview of how Google Drive works.
- [Google Drive - The menus (part 3)](https://bazroberts.com/2016/01/04/google-drive-the-menus-part-3/) - Part 3 of a 3-part tour of the menus in Google Drive. In this part we look at the search bar and account details.
- [Google Drive - The menus (part 2)](https://bazroberts.com/2016/01/04/google-drive-the-menus-part-2/) - Part 2 of a 3-part tutorial on the menus in Google Drive. This one focusses on hte bar above the file and folder area.
- [Google Drive - The menus (part 1)](https://bazroberts.com/2016/01/04/google-drive-how-to-navigate-around-part-1/) - Part 1 of a 3-part tutorial that goes through the different parts of Google Drive, and in particular the menus.
- [How to set up a Google Account](https://bazroberts.com/2015/12/08/how-to-set-up-a-google-account-to-access-google-apps/) - You'll need a Google account to access the Google Apps. Below are step-by-step instructions on how set one up. Go to the Google account set up page. Fill in the form with your details: name your new email address (username+@gmail.com) password your birthday gender phone number (security code may get sent to here) your current
- [Google Drive - How to access it](https://bazroberts.com/2015/12/08/google-drive-the-basics/) - A quick step-by-step tutorial on how to access Google Drive.
- [Google Forms - Changing the theme](https://bazroberts.com/2016/02/14/google-forms-changing-the-background/) - Step-by-step tutorial on how to change the theme in Google Forms, including the header image (using a default one or your own one), colours, and font.
- [Google Sheets Functions - UNIQUE, COUNTUNIQUE, SORT](https://bazroberts.com/2016/11/07/google-sheets-functions-unique-countunique-sort/) - Step-by-step tutorial on using the UNIQUE, COUNTUNIQUE, and SORT functions in Google Sheets, which includes several practical examples.
- [Google Sheets Cell References - Absolute & Relative](https://bazroberts.com/2024/11/20/sheets-cell-references-absolute-relative/) - Quickly master cell references in Google Sheets to simplify calculations & boost productivity. Learn relative, absolute, & mixed references in just a few steps.
- [How to easily wrap text in Google Sheets](https://bazroberts.com/2024/05/14/how-to-wrap-text-in-google-sheets/) - A quick step-by-step tutorial on how to wrap text in Google Sheets, how to clip text, and how to let the text overflow into other cells.
- [Mastering Rows and Columns in Google Sheets](https://bazroberts.com/2024/11/11/mastering-rows-and-columns-in-google-sheets/) - Learn tips for organizing Google Sheets rows and columns. Master resizing, selecting, inserting, deleting, and splitting text for a cleaner, optimized layout.
- [Intro to Formulas and Functions in Google Sheets](https://bazroberts.com/2024/11/01/intro-to-formulas-and-functions/) - Learn the basics of Google Sheets formulas and functions to streamline calculations, save time, and make dynamic, data-driven spreadsheets effortlessly.
- [How to format data in Google Sheets](https://bazroberts.com/2024/10/19/how-to-format-data-in-google-sheets/) - A quick overview on how to format data in Google Sheets. It covers formats like currencies, percentages, and dates and times. Plus how to change decimal places.
- [Google Sheets - The Basics](https://bazroberts.com/2024/09/21/google-sheets-the-basics-2/) - Introduction to Google Sheets; How to create a Google Sheet; What's on the screen; How to enter data; How to enter a formula
- [How to quickly group data in Sheets](https://bazroberts.com/2024/07/02/how-to-quickly-group-data-in-sheets/) - A step-by-step tutorial on how to quickly group data in Google Sheets using Group by view and tables. Plus, how to easily add drop-downs to enter your data.
- [How to send automatic notifications from Sheets](https://bazroberts.com/2024/06/23/how-to-send-automatic-notifications-from-sheets/) - A tutorial on how to use the Conditional notifications feature in Sheets which allows you to send automatic email notifications when data is changed in Sheets.
- [Google Slides - Lines, connectors, scribble](https://bazroberts.com/2016/05/21/google-slides-lines-connectors-scribble/) - Learn how to use lines, connectors, & drawing tools in Google Slides to create engaging visuals. Customize styles, add flow to diagrams & draw freehand shapes.
- [How to add alternating row colours to Google Sheets](https://bazroberts.com/2016/10/14/google-sheets-alternating-colours/) - Step-by-step tutorial on how to quickly add alternating row colors to Google Sheets. Plus, how to set up your own styles.
- [Google Forms - How do they work?](https://bazroberts.com/2016/02/05/google-forms-how-do-they-work/) - Google Forms is one of the simplest tools to use to collect data and information but as they are connected to a spreadsheet (Google Sheet) they can be very powerful in terms of data analysis. There are numerous uses for Google Forms but common ones are: Collecting feedback - questionnaire Signing up to an event Data entry
- [Google Sheets - Controlling rows & columns (Part 2)](https://bazroberts.com/2016/03/13/google-sheets-controlling-rows-columns-part-2/) - Learn how to select multiple rows/columns, delete unwanted rows & columns, hide rows and columns, freeze rows and columns, group rows and columns
- [Questionnaires - Automatically send feedback to individuals](https://bazroberts.com/2017/03/27/questionnaires-automatically-send-feedback-to-individuals/) - Tutorial on how to set up personalized questionnaires and then for individuals to receive the feedback related to them
- [Google Forms - Questions: What else can you do?](https://bazroberts.com/2016/02/07/google-forms-question-type-what-else-can-you-do/) - A summary of what else you can do with questions in Google Forms, such as, changing the order, and making questions obligatory.
- [Google Sheets - The cell references: Relative & Absolute](https://bazroberts.com/2016/03/14/google-sheets-the-cell-reference-brothers-relative-absolute/) - Here we're going to look at how references to cells will allow you to do multiple calculations really quickly. We'll look at: How to reference cells with each other How to quickly copy formulas across other cells How cell references change when they are moved around the sheet (relative cell references) How you can fix
- [Google Drive - Downloading your files & folders](https://bazroberts.com/2016/01/26/google-drive-downloading-your-files-folders/) - A step-by-step tutorial on how to download files and folders in Google Drive.
- [Google Docs - Extra useful tools](https://bazroberts.com/2016/04/27/google-docs-extra-useful-tools/) - Here's a collection of small but useful tools in Docs, which I think can make life that little bit easier. The majority are related to the document as a whole and allow you to do things without having to go back to Google Drive. We'll look at: Opening files from within Docs Creating new files
- [Google Slides - Tables](https://bazroberts.com/2016/06/08/google-slides-tables/) - A step-by-step tutorial on how to use tables in Google Slides.
- [Google Slides - Word art & Gradient fill](https://bazroberts.com/2016/06/21/google-slides-word-art/) - A step-by-step tutorial on how to use word art and gradient fill in Google Slides.
- [Forms & Sheets - Attendance System](https://bazroberts.com/2021/07/06/forms-sheets-attendance-system/) - Step-by-step tutorial on how to create an attendance system using Google Forms and Google Sheets. It includes a link to make a copy of a ready-made sheet.
- [Google Slides - Animations & transitions](https://bazroberts.com/2016/06/02/google-slides-animations-transitions/) - Step-by-step tutorial on how to use both and animations and transitions in Google Slides. It includes practical examples of how to use them.
- [Google Forms - Types of questions](https://bazroberts.com/2016/02/08/google-forms-types-of-questions/) - A summary of the different types of questions available in Google Forms. E.g. Short answer, multiple-choice, drop-downs. Includes examples of how to use them.
- [Google Sheets Functions - NOW, TODAY, DAY, MONTH, YEAR](https://bazroberts.com/2016/11/14/google-sheets-functions-now-today-day-month-year/) - Step-by-step tutorial on how to use the functions now, today, day, month, and year to work with times and dates.
- [Google Sheets - Cell formatting](https://bazroberts.com/2017/09/08/how-to-use-google-sheets-cell-formatting/) - Step-by-step tutorial on how to format cells in Google Sheets, including cell borders, fill colour, justification, text wrap, and text rotation
- [Google Drive - Quick access to your files](https://bazroberts.com/2017/09/18/quick-access-to-your-files/) - Find your files quickly in Google Drive - Short tutorial on starring files and folders and quick access.
- [How to search in Google Sheets](https://bazroberts.com/2024/04/14/how-to-search-in-google-sheets/) - A step-by-step tutorial on how to search in Google Sheets with a quick keyboard shortcut, and how to replace text or numbers in Sheets with Find and Replace
- [Google Slides - Master slides and themes](https://bazroberts.com/2016/06/22/google-slides-master-slides-and-themes/) - Step-by-step tutorial on how to create master slides and themes in Google Slides. Including how to edit existing ones or import new ones.
- [Apps Script Basics (7) - SpreadsheetApp & for in loop](https://bazroberts.com/2017/05/18/apps-script-basics-spreadsheetapp-for-in-loop/) - In this post, we're going to look at the G Suite services, the Google documentation that's available to help you, and then focus on one particular area, SpreadsheetApp to then create some spreadsheets. We're also going to see the really useful for in loop in action. It's important to have an understanding of how the
- [How to randomize a list in Google Sheets](https://bazroberts.com/2024/03/18/how-to-randomize-a-list-in-google-sheets/) - Quick tutorial on how to randomize a list of data in Google Sheets. I'll show you how to do it in a couple of clicks.
- [How to merge cells in Google Sheets](https://bazroberts.com/2024/03/17/how-to-merge-cells-in-google-sheets/) - Step-by-step tutorial on how to merge cells in Google Sheets both vertically and horizontally. Also, learn how to split cells (unmerge cells).
- [How to filter duplicate rows in Google Sheets](https://bazroberts.com/2024/03/03/how-to-filter-duplicate-rows-in-google-sheets/) - How to filter duplicate rows in Google Sheets and create a separate list. Plus, how to extract a separate list of unique rows, all with just one formula.
- [Remove and separate duplicates in Google Sheets](https://bazroberts.com/2022/02/07/remove-and-separate-duplicates-in-google-sheets/) - Step-by-step tutorial on how to remove duplicates from list in Google Sheets and also store the duplicate rows in another sheet.
- [Apps Script - How to deploy a library](https://bazroberts.com/2022/01/05/apps-script-deploying-a-library/) - Step-by-step tutorial on how to deploy a library in a Google Apps Script project and when to use one.
- [Google Workspace 2021 Recap (2)](https://bazroberts.com/2022/01/02/google-workspace-2021-recap-2/) - Second part of a summary of the improvements to Google Workspace in 2021. This part covers Google Meet, Forms, Calendar, and Sites.
- [Google Workspace - 2021 Recap (1)](https://bazroberts.com/2022/01/02/google-workspace-2021-recap-1/) - A summary of the improvements to Google Workspace during 2021. Links to the original announcements included.
- [How to quickly make short pre-filled URLs](https://bazroberts.com/2022/01/01/how-to-quickly-make-short-pre-filled-urls/) - Step-by-step tutorial on how to quickly make short URLs for pre-filled Google Forms using Google Sheets and a bit of Apps Script.
- [How to use Shared Drives](https://bazroberts.com/2022/01/29/how-to-use-shared-drives/) - A tutorial on how Shared Drives work in Google Workspace. It covers setting them up, access rights, and a comparison with My Drive.
- [How to use the Google Calendar Appointment System](https://bazroberts.com/2022/04/12/how-to-use-the-google-calendar-appointment-system/) - Step-by-step tutorial on how to use the Google Calendar appointment system. Including setting up appointments for parent-teacher meetings.
- [Style your Google Site with themes](https://bazroberts.com/2022/06/11/style-your-google-site-with-themes/) - A step-by-step tutorial on how to use themes in Google Sites to improve the look of them and to share those themes with over sites.
- [Quickly format multiple Google Sheets with Apps Script](https://bazroberts.com/2022/07/04/quickly-format-multiple-google-sheets-with-apps-script/) - A step-by-step tutorial on how to quickly format multiple Google Sheets, as an example of how Apps Script can save you time
- [Automatically format rows for Google Form responses](https://bazroberts.com/2022/07/17/sheets-apps-script-automatically-format-rows-for-form-responses/) - A step-by-step tutorial showing you how to automatically format rows in Google Sheets when Google Forms responses are submitted. Code and example file included.
- [How to create video presentations in Slides](https://bazroberts.com/2024/02/18/how-to-create-video-presentations-in-slides/) - Tutorial on how to create video presentations in Google Slides which you can then share via a link. Plus where they are stored and how to access them.
- [How to remove duplicates in Google Sheets](https://bazroberts.com/2024/02/26/how-to-remove-duplicates-in-google-sheets/) - A quick tutorial on how to remove duplicates rows from a list in Google Sheets using the Remove Duplicates from the menu.
- [What's the difference between a Google Workspace and a free Gmail account?](https://bazroberts.com/2022/01/23/google-workspace-vs-a-free-gmail-account/) - An article highlighting the differences in Google Workspace vs a free Gmail account and the benefits of having a paid Workspace account.
- [How to move a folder to a Shared Drive](https://bazroberts.com/2024/02/21/how-to-move-a-folder-to-a-shared-drive/) - A quick tutorial on how to move a folder to a Shared Drive in Google Drive. It shows you what is and isn't possible to do.
- [How to add a calendar in a cell - Sheets](https://bazroberts.com/2024/02/13/how-to-add-a-calendar-in-a-cell-sheets/) - A step-by-step tutorial on how to add a calendar in a cell in Google Sheets. Both via the @ smart chip and data validation.
- [How to arrange a meeting from Gmail](https://bazroberts.com/2024/02/07/how-to-arrange-a-meeting-from-gmail/) - A tutorial on how to quickly arrange a meeting right from Gmail by selecting possible dates and times and emailing those for other to choose from.
- [How to scan with the Drive app on your phone](https://bazroberts.com/2024/01/28/how-to-scan-with-the-drive-app-on-your-phone/) - Tutorial on how to use the Google Drive scanner on your phone. It shows you how to scan, how to edit the scan, and how to save the scans on your Drive.
- [The new Home in Google Drive](https://bazroberts.com/2024/02/05/the-new-home-in-google-drive/) - A quick tutorial on the new Home page in Google Drive. This opens by default instead of My Drive, although it's possible to change this.
- [How to annotate Google Slides](https://bazroberts.com/2024/01/31/how-to-annotate-google-slides/) - A quick tutorial on how to use the pen tool in Google Slides to annotate slides while presenting them. Plus, how to change the colour and to erase them.
- [All you need to know about Google Tasks](https://bazroberts.com/2024/01/22/all-you-need-to-know-about-google-tasks/) - Tutorial on how to use Google Tasks and the new full screen tasks page in Google Calendar. Learn how to create tasks, task lists, and view tasks in Calendar.
- [Summary of Google Workspace 2023 improvements (Part 3)](https://bazroberts.com/2024/01/05/summary-of-google-workspace-2023-improvements-part-3/) - A summary of the improvements to Google Workspace in 2023, focussing on Duet AI, AppSheet, and Apps Script.
- [Summary of Google Workspace 2023 improvements (Part 2)](https://bazroberts.com/2024/01/05/summary-of-google-workspace-2023-improvements-part-2/) - A summary of some of the best improvements to Google Workspace that came out in 2023. In this part it focuses on Slides, Chat, Meet, Calendar, and Classroom.
- [Calculate hours worked from Google Calendar](https://bazroberts.com/2022/03/28/calculate-hours-worked-from-google-calendar/) - Step-by-step tutorial on how to calculate hours worked from Google Calendar events using a little bit of Apps Script and a Google Sheet.
- [Google Sheets - INDEX and MATCH (VLOOKUP alt.)](https://bazroberts.com/2017/01/02/google-sheets-functions-index-and-match-vlookup-alternative/) - Step-by-step tutorial on how to use the Sheet functions INDEX and MATCH, which can be more powerful than VLOOKUP to look up data in a table
- [How to use Mail Merge in Gmail to email multiple people](https://bazroberts.com/2023/09/25/how-to-use-mail-merge-in-gmail-to-email-multiple-people/) - Post to show how easy it is to set up a mail merge in Gmail and Google Sheets to be able to send personalised emails to multiple people.
- [Step-by-Step Guide to Mastering the new XLOOKUP Function](https://bazroberts.com/2023/08/21/step-by-step-guide-to-mastering-the-new-xlookup-function/) - Explore XLOOKUP's power in this guide. Master its syntax, discover use cases, and optimize its potential from basics to advanced applications in Google Sheets.
- [How to use CHOOSECOLS and CHOOSEROWS](https://bazroberts.com/2023/03/19/how-to-use-choosecols-and-chooserows/) - A step-by-step tutorial on how to use the function CHOOSEROWS and CHOOSECOLS to display certain rows or columns of a set of data
- [How to easily add drop-down menus in Google Sheets](https://bazroberts.com/2023/01/12/how-to-easily-add-drop-down-menus-in-google-sheets/) - Step-by-step tutorial on how to add drop-down menus in Google Sheets. Looking at how they can control data being entered and make it easier to do so.
- [How to combine arrays of data into 1 sheet](https://bazroberts.com/2023/02/05/how-to-combine-arrays-of-data-into-1-sheet/) - Step-by-step tutorial on how to combine data stored on different sheets and add it to a single sheet using Apps Script and the spread operator.
- [How to split Google Slides automatically](https://bazroberts.com/2022/10/08/google-slides-splitter/) - A step-by-step tutorial on how to quickly split Google Slides automatically into separate files for individual people using Apps Script.
- [Learn useful Google URL tricks to make your online easier](https://bazroberts.com/2022/10/17/google-url-tricks/) - Lots of useful Google URL tricks, such as, .new to quickly create a new document, /export?format=pdf to download as a pdf, and many more!
- [Google Docs (3) - Setting up the page](https://bazroberts.com/2016/04/10/google-docs-setting-up-the-page/) - A step-by-step tutorial on page setup in Google Docs
- [Google Drive (7) - Moving files around](https://bazroberts.com/2016/01/08/google-drive-moving-files-around/) - Tutorial on how to move files and folders around on Google Drive.
- [Apps Script Basics - Loops](https://bazroberts.com/2017/04/13/apps-script-basics-loops/) - Step-by-step tutorial on how to use loops in Google Sheets and Apps Script.
- [Google Sheets - Filtering your data](https://bazroberts.com/2016/03/21/google-sheets-filtering-your-data/) - Step-by-step tutorial on using filters and filter views in Google Sheets.
- [Google Sheets Functions - ROUND, ROUNDUP, ROUNDDOWN](https://bazroberts.com/2016/12/12/google-sheets-functions-round-roundup-rounddown/) - Step-by-step tutorial on how to round numbers in Google Sheets using the functions ROUND, ROUNDUP, and ROUNDDOWN.
- [Google Sheets - Formatting your data](https://bazroberts.com/2017/09/08/google-sheets-formatting-your-data/) - Step-by-step tutorial showing you how to format data in Google Sheets - currency, percentages, dates, times, accounting.
- [Google Sheets Functions - QUERY](https://bazroberts.com/2017/01/11/google-sheets-functions-query/) - A step-by-step tutorial on the QUERY function in Google Sheets, which includes lots of examples of how to use it.
- [How to authorize an Apps Script project](https://bazroberts.com/2021/12/30/how-to-authorize-an-apps-script-project/) - Step-by-step guide on how to authorize a Google Apps Script project in Google Workspace.
- [Google Slides - Line spacing & Text indenting](https://bazroberts.com/2016/06/14/google-slides-line-spacing-text-indent/) - A step-by-step tutorial on how to use line spacing and indents in Google Slides to improve the look of your slides.
- [Google Sheets Functions - VLOOKUP](https://bazroberts.com/2016/10/09/google-sheets-functions-vlookup/) - A step-by-step tutorial on how to use VLOOKUP in Google Sheets with examples of different ways to use it.
- [Google Sheets Functions - COUNTIF(S) & SUMIF(S)](https://bazroberts.com/2016/10/18/google-sheets-functions-countif-sumif/) - A step-by-step tutorial on how to use COUNTIF and SUMIF to count and sum cells based on conditionals
- [Google Sheets Functions - GOOGLETRANSLATE, DETECTLANGUAGE](https://bazroberts.com/2016/11/23/google-sheets-functions-googletranslate-detectlanguage/) - Step-by-step tutorial on how to use Google Translate in Google Sheets
- [Google Sheets - Moving, copying & pasting data](https://bazroberts.com/2016/03/16/google-sheets-moving-copying-pasting-data/) - Tutorial on moving, copying and pasting data in Google Sheets. Including how to use Paste special to paste data in different ways.
- [Google Sheets - Conditional Formatting & custom formulas](https://bazroberts.com/2016/03/21/google-sheets-conditional-formatting-custom-formulas/) - Step-by-step tutorial on how to use conditional formatting in Google Sheets and also custom formulas.
- [Google Sheets - What's the difference between notes & comments?](https://bazroberts.com/2016/03/24/google-sheets-whats-the-difference-between-notes-comments/) - Tutorial on how to use notes, comments, and action items in Google Sheets
- [Google Sheets - Controlling Rows & Columns (Part 1)](https://bazroberts.com/2017/09/09/google-sheets-controlling-rows-columns-part-1/) - Step-by-step tutorial on how to control rows and columns in Google Sheets (part 1)
- [Meet - How to present and see the attendees](https://bazroberts.com/2021/06/27/meet-how-to-present-and-see-the-attendees/) - Step-by-step tutorial on to present a tab in Google Meet and also see attendees tiles
- [Google Forms - Managing your form's responses](https://bazroberts.com/2016/02/13/google-forms-managing-your-forms-responses/) - Tutorial on how to manage Google form responses and how to summary data in your form per individual or per question.
- [Google Forms - Creating personalized forms automatically](https://bazroberts.com/2016/02/20/google-forms-personalized-forms-pre-filling-forms/) - Tutorial on how to automatically pre-fill and personalize Google Forms using formulas in Google Sheets.
- [Google Forms - Quizzes](https://bazroberts.com/2016/11/10/google-forms-quizzes/) - Tutorial on how to make quizzes in Google Forms, including how to set up the quiz, setting up questions, and adding feedback to answers.
- [Google Drive - Sharing files and folders](https://bazroberts.com/2016/01/16/google-drive-sharing-files-and-folders/) - A step-by-step tutorial on how to share Google files and folders
- [Google Drive - Folders: 50 shades of grey](https://bazroberts.com/2016/01/23/google-drive-folders-50-shades-of-grey/) - Tutorial on how to change the colour of your Google Drive folders
- [Google Drive - Getting the link to your file so you can share it](https://bazroberts.com/2016/01/30/google-drive-getting-the-link-to-your-file-so-you-can-share-it/) - Tutorial on how to get Google Drive link to share a file with anyone.
- [Google Docs - Getting to grips with tables (part 1)](https://bazroberts.com/2016/04/14/google-docs-getting-to-grips-with-tables/) - A step-by-step tutorial on how to use tables in Google Docs - Inserting & deleting rows and alignment.
- [Google Docs - Making bulleted & numbered lists](https://bazroberts.com/2016/04/15/google-docs-making-bulleted-and-numbered-lists/) - A step-by-step tutorial on how to work with bulleted and numbered lists in Google Docs.
- [Google Docs - Working with images (part 1)](https://bazroberts.com/2016/04/16/google-docs-working-with-images/) - A step-by-step tutorial on inserting images into Google Docs via different methods.
- [Google Docs - Paragraph styles (Headings)](https://bazroberts.com/2016/04/19/google-docs-paragraph-styles-headings/) - A step-by-step tutorial on how to set paragraph styles, use Borders and shading, use Outline, and set up a Table of Contents
- [Google Docs - Adding special characters](https://bazroberts.com/2016/04/24/google-docs-adding-special-characters/) - A step-by-step tutorial on adding special characters and equations in Google Docs
- [Google Docs - Getting to grips with tables (part 2)](https://bazroberts.com/2021/05/15/google-docs-getting-to-grips-with-tables-part-2/) - A step-by-step tutorial on how to use Google Docs tables - borders, merging and padding
- [Google Docs - Working with images (part 2)](https://bazroberts.com/2021/05/16/google-docs-working-with-images-part-2/) - Step-by-step tutorial on Google Docs images - Resizing an image, Adding a border, Cropping an image, Rotating and positioning an image
- [Multiple FILE Maker](https://bazroberts.com/2021/07/10/multiple-file-maker/) - A step-by-step tutorial on how to make multiple Google Drive files quickly and easily with Google Apps Script.
- [Google Slides - Inserting & editing shapes](https://bazroberts.com/2016/05/19/google-slides-inserting-editing-shapes/) - Tutorial on inserting and editing shapes in Google Slides. Including how to rotate and flip shapes, add guides, and control line properties.
- [Apps Script: How to automate a script](https://bazroberts.com/2021/12/31/apps-script-how-to-automate-a-script/) - Tutorial on how to set up a trigger in Apps Script allowing you to automate a script and some of the options available to us.
- [Mail merge using draft emails](https://bazroberts.com/2021/11/03/mail-merge-using-draft-emails/) - Tutorial on how to use Google Sheets to send multiple emails using draft emails and a little Google Apps Script.
- [Ladder card game using Google Sheets](https://bazroberts.com/2020/05/03/ladder-card-game-using-google-sheets/) - Tutorial on using a ladder game created by Google Sheets and Apps Script.
- [How to make a ladder card game with Apps Script](https://bazroberts.com/2020/05/03/how-to-make-a-ladder-card-game-with-apps-script/) - Tutorial on how to make a ladder card game using Google Sheets, Apps Script to make a web app.
- [Parents Evening Appointment System - Part 3](https://bazroberts.com/2018/02/24/parents-evening-appointment-system-part-3/) - Third and final part of a tutorial on how to make a parents evening appointment system using Google Forms, Sheets, and Apps Script.
- [Parents Evening Appointment System - Part 2](https://bazroberts.com/2018/02/24/parents-evening-appointment-system-part-2/) - Part 2 of a tutorial on making a parents evening appointment system using Google Forms, Sheets, and Apps Script.
- [Parents Evening Appointment System - Part 1](https://bazroberts.com/2018/02/24/parents-evening-appointment-system-part-1/) - Tutorial on how to create a parents evening appointment system using Google Forms, Sheets, and some Apps Script.
- [Apps Script Basics - Making quizzes in Google Forms](https://bazroberts.com/2017/11/21/apps-script-basics-17-making-quizzes-in-google-forms/) - Step-by-step tutorial on how to automatically make a quiz in Google Forms using Google Apps Script.
- [Apps Script Basics - Using Form Responses](https://bazroberts.com/2017/10/22/apps-script-basics-14-using-form-responses/) - Step-by-step tutorial on how to automatically use responses from a Google Form using Google Apps Script.
- [Apps Script Basics - if, prompt, menu, & onOpen trigger](https://bazroberts.com/2017/05/07/apps-script-basics-if-prompt-menu-onopen-trigger/) - In this post, we're going to look at how we can get the computer to react to data in a spreadsheet and to user input. We're going to look at the following: If, else if, and else statements - to allow the program to make decisionsCreate your own menu in the spreadsheet to run your
- [Online exam maker using Apps Script](https://bazroberts.com/2020/05/12/online-exam-maker-using-apps-script/) - Step-by-step tutorial on how to make a online exam maker using Google Sheets, Google Forms, and Apps Script.
- [Apps Script Basics - Arrays, Execution log](https://bazroberts.com/2017/04/20/apps-script-basics-arrays-logger-execution-transcript/) - Step-by-step tutorial on how to use arrays in Google Apps Script.
- [Multiple FOLDER maker](https://bazroberts.com/2021/07/10/multiple-folder-maker/) - Step-by-step tutorial on how to make multiple Google Drive folders quickly with Google Apps Script
- [Apps Script Basics - Adding different types of questions to a Form](https://bazroberts.com/2017/10/15/apps-script-basics-13-adding-different-types-of-questions-to-a-form/) - Step-by-step tutorial on how to create different types of questions automatically in Google Forms using Google Apps Script.
- [Card sorting game using Google Sheets & Apps Script](https://bazroberts.com/2021/07/07/moving-card-game-using-google-sheets-apps-script/) - Tutorial on how to create a card sorting game using Google Sheets, Apps Script, HTML, CSS, and a little JQuery.
- [Apps Script Basics - Range class & triggers (pt 2)](https://bazroberts.com/2021/05/22/apps-script-basics-range-class-triggers-pt-2/) - Second part of a tutorial on how to use the Range class in Apps Script and also how to use the onEdit trigger.
- [Apps Script Basics - Range Class & Triggers (pt 1)](https://bazroberts.com/2017/06/28/apps-script-basics-10-range-class-triggers/) - Tutorial on how to use the Range class, inc activating cells, adding formulas, changing cell format, etc. Also how to use the onEdit trigger.
- [Apps Script Basics - Creating & updating a multiple question form](https://bazroberts.com/2017/10/07/apps-script-basics-12-creating-updating-a-multiple-question-form/) - A step-by-step tutorial on how to create and update Google forms with different question types.
- [Issues reporting with translation](https://bazroberts.com/2021/10/19/issues-reporting-with-translation/) - Report classroom issues using a Google Form and get it automatically translated and emailed to the relevant people
- [Apps Script Basics - Form validation](https://bazroberts.com/2017/11/04/apps-script-basics-15-form-validation/) - Step-by-step tutorial on how to automatically set up form validation in Google Forms using Google Apps Script.
- [Make & Send Kids Reports](https://bazroberts.com/2017/04/24/make-send-kids-reports/) - Step-by-step tutorial on how to make a kids reports system that makes and send reports using Google Sheets and Apps Script.
- [Apps Script Basics - Form page navigation](https://bazroberts.com/2017/11/09/apps-script-basics-16-form-page-navigation/) - Step-by-step tutorial on how to set up Google Form page navigation with Apps Script using a Clocking in system as an example.
- [Request form - Sending automatic emails](https://bazroberts.com/2017/01/29/request-form-sending-automatic-emails/) - Step-by-step tutorial on how to send automatic emails when a Google Form is submitted using Google Sheets and Apps Script.
- [Automatically emailing info from a form submission](https://bazroberts.com/2017/02/03/automatically-emailing-info-from-a-form-submission/) - Step-by-step tutorial on how to automatically email info from a Google Form submission.
- [Apps Script - Clocking in & out system](https://bazroberts.com/2017/03/06/apps-script-clocking-in-out-system/) - Step-by-step tutorial on how to set up a clocking in and out system using Google Forms, Google Sheets, and Apps Script.
- [Apps Script - Issues reporting form, log & email](https://bazroberts.com/2017/04/17/apps-script-issues-reporting-form-log-email/) - Create an issues log which allows the user to record issues on a Google Form and then it translates the issue and email the relevant people
- [Apps Script - Creating & sharing Class folders in Drive](https://bazroberts.com/2017/03/20/apps-script-creating-sharing-class-folders-in-drive/) - Tutorial on how to make multiple class Drive folders and individual student folders shared only with them - all done in seconds!
- [Google Drive - Moving multiple files & folders](https://bazroberts.com/2016/01/11/google-drive-moving-multiple-files-folders/) - Tutorial on how to move multiple Google Drive files and folders.
- [Google Sheets Functions - PROPER, UPPER, LOWER, TRIM](https://bazroberts.com/2016/10/28/google-sheets-functions-proper-upper-lower-trim/) - Tutorial on how to use the Google Sheets functions PROPER, UPPER, LOWER, and TRIM
- [Enabling hybrid work with Google Workspace | Google Cloud Blog](https://bazroberts.com/2021/09/09/enabling-hybrid-work-with-google-workspace-google-cloud-blog/) - We’re bridging the gaps in hybrid work with enhancements to Google Meet and the introduction of Spaces. — Read on cloud.google.com/blog/
- [Google Meet is more secure, easy to use and engaging](https://bazroberts.com/2021/06/23/google-meet-is-more-secure-easy-to-use-and-engaging/) - Learn about new updates in Google Meet which make it more secure, easier to use and more engaging. — Read on blog.google/outreach-initiatives/education/google-meet-back-to-school-improvements-2021/amp/
- [APPS SCRIPT BASICS – Creating & updating a Google form](https://bazroberts.com/2017/10/01/apps-script-basics-11-creating-updating-a-form/) - Learn how to create and update a Google Form automatically with Apps Script
- [Examples of Apps Script & 2018 plans](https://bazroberts.com/2018/08/18/examples-of-apps-script-2018-plans/) - Google Apps script presentation: http://youtu.be/MGkcbP5Gd1o
- [Apps Script Basics - Authorising a script](https://bazroberts.com/2019/05/04/apps-script-basics-authorising-a-script/) - [et_pb_section fb_built="1" admin_label="section" _builder_version="3.21.1" custom_margin="0px||" custom_padding="0px||"][et_pb_row custom_padding="0px||" admin_label="row" _builder_version="3.21.1" background_size="initial" background_position="top_left" background_repeat="repeat"][et_pb_column type="4_4" _builder_version="3.0.47"][et_pb_text admin_label="Text" _builder_version="3.21.1" background_size="initial" background_position="top_left" background_repeat="repeat" custom_padding="0px||"]To allow your scripts to run, you will need to authorise them. Below are the steps which show you how to do this: Click the play button on the toolbar. 2. A dialogue box will open
- [Google Developers Blog: Total Eclipse of the Apps Script](https://bazroberts.com/2019/09/16/google-developers-blog-total-eclipse-of-the-apps-script/) - Google Developers Blog: Total Eclipse of the Apps Script — Read on developers.googleblog.com/2013/10/total-eclipse-of-apps-script.html
- [How to access and organize files faster in G Suite using Priority and Workspaces - TechRepublic](https://bazroberts.com/2019/04/24/how-to-access-and-organize-files-faster-in-g-suite-using-priority-and-workspaces-techrepublic/) - Google Drive Priority suggests a short list of files you might find useful, while Workspaces lets you gather files from across Drive for fast access. — Read on www.techrepublic.com/article/priority-and-workspaces-two-ways-to-access-and-organize-files-in-g-suite/
- [Google Docs (14) - Translating a document](https://bazroberts.com/2016/04/24/google-docs-translating-a-document/) - [et_pb_section fb_built="1" admin_label="section" _builder_version="3.22"][et_pb_row admin_label="row" _builder_version="3.25" background_size="initial" background_position="top_left" background_repeat="repeat"][et_pb_column type="4_4" _builder_version="3.25" custom_padding="|||" custom_padding__hover="|||"][et_pb_text admin_label="Text" _builder_version="4.5.3" background_size="initial" background_position="top_left" background_repeat="repeat" custom_margin="-100px|||" border_style="solid"]Many people work in different languages and it's useful to be able to translate texts quickly and also to be able to work in another language if you speak more than one. Here we'll look at
- [Create useful websites for your business with updates in new Google Sites](https://bazroberts.com/2019/12/20/create-useful-websites-for-your-business-with-updates-in-new-google-sites/) - New Google Sites update — Read on cloudblog.withgoogle.com/products/g-suite/create-useful-websites-for-your-business-with-updates-in-new-google-sites/amp/
- [Creating multiple short URLs in seconds](https://bazroberts.com/2016/02/28/creating-multiple-short-urls-in-seconds/) - [et_pb_section fb_built="1" admin_label="section" _builder_version="3.0.47" custom_padding="4px|0px|37.9062px|0px|false|false"][et_pb_row admin_label="row" _builder_version="3.0.48" background_size="initial" background_position="top_left" background_repeat="repeat"][et_pb_column type="4_4" _builder_version="3.0.47"][et_pb_text admin_label="Text" _builder_version="3.21.1" background_size="initial" background_position="top_left" background_repeat="repeat" use_border_color="off" border_color="#ffffff" border_style="solid"]The Google Url Shortener has closed down. Wouldn't it be better if instead of sharing a long link like the one below, you could get a shorten version of it? Well, you can and Google provides a
- [What's new in Classroom - June 2019](https://bazroberts.com/2019/06/22/whats-new-in-classroom-june-2019/) - What's new in Classroom - Better assignments page, grade book for all users — Leer en support.google.com/edu/classroom/answer/6149237
- [Apps Script Basics (1) - First Script](https://bazroberts.com/2017/03/15/apps-script-basics-first-script/) - Here I want to show you how easy it is to write some code using Apps Script. This is the code that sits in the background of some of the Google Apps. This post is for those taking their first steps into writing code, so I will explain everything step-by-step. First Google Sheets Script First, you'll
- [What’s new in G Suite? - G Suite Admin Help](https://bazroberts.com/2019/04/26/whats-new-in-g-suite-g-suite-admin-help/) - What’s new in G Suite? - G Suite Admin Help — Read on support.google.com/a/table/7314896
- [Helping businesses work faster, smarter and more collaboratively in G Suite | Google Cloud Blog](https://bazroberts.com/2019/04/10/helping-businesses-work-faster-smarter-and-more-collaboratively-in-g-suite-google-cloud-blog/) - Today we announced updates to our set of intelligent productivity and collaboration apps at Cloud Next '19. — Leer en cloud.google.com/blog/
- [25 incredibly useful Google Docs tips and tricks](https://bazroberts.com/2018/08/29/25-incredibly-useful-google-docs-tips-and-tricks/) - Whether you’re a Google Docs newbie or an old pro, you’ll learn something–or several somethings–from this how-to extravaganza. — Leer en www.fastcompany.com/90221069/25-incredibly-useful-things-you-didnt-know-google-docs-could-do
- [Time for a refresh: Meet the new Google Classroom](https://bazroberts.com/2018/08/07/time-for-a-refresh-meet-the-new-google-classroom/) - Classroom updates—just in time for back to school. — Read: blog.google/outreach-initiatives/education/time-refresh-meet-new-google-classroom/
- [Automate tasks in G Suite - No-code apps](https://bazroberts.com/2018/08/06/automate-tasks-in-g-suite-no-code-apps/) - I'm excited by this: No details yet but sounds great. As soon as it's confirmed I'll post the details here.
- [Google Docs (2) - Making your text look better](https://bazroberts.com/2016/04/09/google-docs-making-your-text-look-better/) - [et_pb_section bb_built="1" admin_label="section"][et_pb_row admin_label="row" background_position="top_left" background_repeat="repeat" background_size="initial"][et_pb_column type="4_4"][et_pb_text background_layout="light" text_orientation="left" border_style="solid" background_position="top_left" background_repeat="repeat" background_size="initial" _builder_version="3.0.51" custom_margin="-100px|||"] The most basic way to use Google Docs, is to create a new document and then just start typing. Which is fine, but often you want to make it look more professional, or you want to make certain areas stand
- [Apps Script Basics (8) - Spreadsheet Class](https://bazroberts.com/2017/05/25/apps-script-basics-8-spreadsheet-class/) - [et_pb_section fb_built="1" admin_label="section" _builder_version="3.0.47"][et_pb_row admin_label="row" _builder_version="3.0.47" background_size="initial" background_position="top_left" background_repeat="repeat"][et_pb_column type="4_4" _builder_version="3.0.47" parallax="off" parallax_method="on"][et_pb_text admin_label="Text" _builder_version="3.0.47" background_size="initial" background_position="top_left" background_repeat="repeat" custom_margin="-100px|||" use_border_color="off" border_color="#ffffff" border_style="solid"]In the my last post, we looked at the SpreadsheetApp class. Now, let's look at the next group related to spreadsheets, which is the Spreadsheet class. This class allows us to: copy spreadsheets work with
- [Apps Script Basics (9) - Sheet Class](https://bazroberts.com/2017/06/04/apps-script-basics-9-sheet-class/) - [et_pb_section fb_built="1" admin_label="section" _builder_version="3.0.47"][et_pb_row admin_label="row" _builder_version="3.0.47" background_size="initial" background_position="top_left" background_repeat="repeat"][et_pb_column type="4_4" _builder_version="3.0.47" parallax="off" parallax_method="on"][et_pb_text admin_label="Text" _builder_version="3.0.47" background_size="initial" background_position="top_left" background_repeat="repeat" custom_margin="-100px|||"]In previous posts, we've looked at the SpreadsheetApp and Spreadsheet classes. Now let's look at the next level down, which is the Sheet class. Here, we'll look at how we can work with sheets in a spreadsheet,
- [Google Docs (1) - The basics](https://bazroberts.com/2016/04/08/google-docs-the-basics/) - [et_pb_section bb_built="1" admin_label="section"][et_pb_row admin_label="row" background_position="top_left" background_repeat="repeat" background_size="initial"][et_pb_column type="4_4"][et_pb_text admin_label="Text" background_layout="light" text_orientation="left" border_style="solid" custom_margin="-100px|||" background_position="top_left" background_repeat="repeat" background_size="initial" _builder_version="3.0.51"] You may have heard of Google Docs, but what are they exactly? Google Docs is part of the Google Apps family and is a word-processing program similar to Microsoft Word. It's largely used for writing texts but things like images, tables,
- [Google Docs (13) - Adding comments & suggesting](https://bazroberts.com/2016/04/24/google-docs-adding-comments-suggesting/) - [et_pb_section fb_built="1" admin_label="section" _builder_version="3.0.47"][et_pb_row admin_label="row" _builder_version="3.0.47" background_size="initial" background_position="top_left" background_repeat="repeat"][et_pb_column type="4_4" _builder_version="3.0.47" parallax="off" parallax_method="on"][et_pb_text admin_label="Text" _builder_version="3.0.51" background_size="initial" background_position="top_left" background_repeat="repeat" custom_margin="-100px|||"]One of the great things about Google Docs is the ability to work on a document collaboratively. To aid that, collaborators can leave comments on the document, for others to action, either by just responding to the comment
- [Google Docs (17) - Version History (all is not lost!)](https://bazroberts.com/2016/04/25/google-docs-revision-history/) - [et_pb_section bb_built="1" admin_label="section" _builder_version="3.0.47"][et_pb_row admin_label="row" _builder_version="3.0.47" background_size="initial" background_position="top_left" background_repeat="repeat"][et_pb_column type="4_4"][et_pb_text admin_label="Text" _builder_version="3.0.51" background_size="initial" background_position="top_left" background_repeat="repeat" custom_margin="-100px|||" background_layout="light" text_orientation="left" border_style="solid"] One of my favourite things about the Google Apps suite is that it remembers every change that you have ever done to a file. That's one of the beauties of not having to manually save the file.
- [Google Docs (19) - Explore and Define](https://bazroberts.com/2016/04/27/google-docs-research-and-define/) - [et_pb_section bb_built="1" admin_label="section"][et_pb_row admin_label="row" background_position="top_left" background_repeat="repeat" background_size="initial"][et_pb_column type="4_4"][et_pb_text admin_label="Text" background_layout="light" text_orientation="left" border_style="solid" background_position="top_left" background_repeat="repeat" background_size="initial" _builder_version="3.0.51" custom_margin="-100px|||"] The "Explore" tool has replaced the Research tool and is mainly aimed at those writing academic papers, essays, etc, but it can be useful for anyone. It allows you to search for things on Google without having to
- [Google Slides (19) - Version History](https://bazroberts.com/2016/06/12/google-slides-revision-history/) - [et_pb_section fb_built="1" admin_label="section" _builder_version="3.0.47"][et_pb_row admin_label="row" _builder_version="3.0.47" background_size="initial" background_position="top_left" background_repeat="repeat"][et_pb_column type="4_4" _builder_version="3.0.47" parallax="off" parallax_method="on"][et_pb_text admin_label="Text" _builder_version="3.0.51" background_size="initial" background_position="top_left" background_repeat="repeat" custom_margin="-100px|||"]Updated - Includes the new version of Version history and naming revisions One of the best features of the Google Apps is the revision history, which stores every change to your document, allowing you to go back
- [Google Forms (7) - More ways you can create better forms](https://bazroberts.com/2016/02/14/google-forms-more-ways-you-can-create-better-forms/) - [et_pb_section bb_built="1" admin_label="section"][et_pb_row admin_label="row" background_position="top_left" background_repeat="repeat" background_size="initial"][et_pb_column type="4_4"][et_pb_text admin_label="Text" background_layout="light" text_orientation="left" border_style="solid" background_position="top_left" background_repeat="repeat" background_size="initial" _builder_version="3.0.51" custom_margin="-100px|||"] Updated - Info on default settings added Once you've got to grips with the basics, it's time to look at other ways you can make you form better. Here's a selection of options Google Forms provides which are very
- [Google Slides (24) - Adding video](https://bazroberts.com/2016/06/20/google-slides-adding-video/) - [et_pb_section bb_built="1" admin_label="section"][et_pb_row admin_label="row" background_position="top_left" background_repeat="repeat" background_size="initial"][et_pb_column type="4_4"][et_pb_text admin_label="Text" background_layout="light" text_orientation="left" border_style="solid" background_position="top_left" background_repeat="repeat" background_size="initial" _builder_version="3.0.51" custom_margin="-100px|||"] Updated - Now includes adding videos from your Drive. Video can brighten up any presentation and it's easy to add YouTube videos and videos stored on Google Drive into your slides. Here's how: Inserting a YouTube video Go
- [Google Slides (10) - Presenting your slides](https://bazroberts.com/2016/05/22/google-slides-presenting-your-slides/) - [et_pb_section bb_built="1" admin_label="section"][et_pb_row admin_label="row" background_position="top_left" background_repeat="repeat" background_size="initial"][et_pb_column type="4_4"][et_pb_text admin_label="Text" background_layout="light" text_orientation="left" border_style="solid" background_position="top_left" background_repeat="repeat" background_size="initial" _builder_version="3.0.51" custom_margin="-100px|||"] Updated - Voice type speaker notes You've made your presentation, now you want to present it. Here let's look at how to present your slides and some of the tools which will help you give a better presentation.
- [Google Slides (3) - Setting up your slides](https://bazroberts.com/2016/05/07/google-slides-setting-up-your-slides/) - [et_pb_section bb_built="1" admin_label="section"][et_pb_row admin_label="row" background_position="top_left" background_repeat="repeat" background_size="initial"][et_pb_column type="4_4"][et_pb_text admin_label="Text" background_layout="light" text_orientation="left" border_style="solid" background_position="top_left" background_repeat="repeat" background_size="initial" _builder_version="3.0.51" custom_margin="-100px|||"] Updated - Using Explore to improve your slides Before we jump into the details of making your slides, you'll probably want to set up the overall look of the slides. We can change the size of them, the
- [Google Slides (25) - Importing slides](https://bazroberts.com/2016/06/21/google-slides-importing-slides/) - [et_pb_section bb_built="1" admin_label="section"][et_pb_row admin_label="row" background_position="top_left" background_repeat="repeat" background_size="initial"][et_pb_column type="4_4"][et_pb_text admin_label="Text" background_layout="light" text_orientation="left" border_style="solid" background_position="top_left" background_repeat="repeat" background_size="initial" _builder_version="3.0.51" custom_margin="-100px|||"] There are times when you want to import a few slides from a presentation that you or someone else has previously made. You could make a copy of the presentation and delete the slides you didn't want but a
- [Google Slides (23) - Leaving & replying to Comments](https://bazroberts.com/2016/06/19/google-slides-leaving-replying-to-comments/) - [et_pb_section bb_built="1" admin_label="section"][et_pb_row admin_label="row" background_position="top_left" background_repeat="repeat" background_size="initial"][et_pb_column type="4_4"][et_pb_text admin_label="Text" background_layout="light" text_orientation="left" border_style="solid" background_position="top_left" background_repeat="repeat" background_size="initial" _builder_version="3.0.51" custom_margin="-100px|||"] One of the great things that Slides allows you to do is collaborate together on a set of Slides. Quite often you want to leave comments to your collaborators to make comments on what they've done or ask
- [Google Slides (22) - Audience Q&A](https://bazroberts.com/2016/06/17/google-slides-audience-qa/) - [et_pb_section bb_built="1" admin_label="section"][et_pb_row admin_label="row" background_position="top_left" background_repeat="repeat" background_size="initial"][et_pb_column type="4_4"][et_pb_text admin_label="Text" background_layout="light" text_orientation="left" border_style="solid" background_position="top_left" background_repeat="repeat" background_size="initial" _builder_version="3.0.51" custom_margin="-100px|||"] One of the most recent updates to Slides has been the addition of "audience Q&A", which allows those watching some kind a presentation ask questions to the speaker. It's really easy to use and can make presentations and
- [Google Slides (18) - Using templates](https://bazroberts.com/2016/06/10/google-slides-using-templates/) - [et_pb_section bb_built="1" admin_label="section"][et_pb_row admin_label="row" background_position="top_left" background_repeat="repeat" background_size="initial"][et_pb_column type="4_4"][et_pb_text admin_label="Text" background_layout="light" text_orientation="left" border_style="solid" background_position="top_left" background_repeat="repeat" background_size="initial" _builder_version="3.0.51" custom_margin="-100px|||"] Slides has a small set of professional-looking templates which can be used to get you started. They are three categories: Education, Work, Personal. They cover areas like CVs, lesson plans, different types of presentations, recipe books, etc. They
- [Google Slides (15) - Inserting static & dynamic charts](https://bazroberts.com/2016/05/29/google-slides-inserting-static-dynamic-charts/) - [et_pb_section bb_built="1" admin_label="section"][et_pb_row admin_label="row" background_position="top_left" background_repeat="repeat" background_size="initial"][et_pb_column type="4_4"][et_pb_text admin_label="Text" background_layout="light" text_orientation="left" border_style="solid" background_position="top_left" background_repeat="repeat" background_size="initial" _builder_version="3.0.51" custom_margin="-100px|||"] It's common to see some kind of chart showing figures or statistics in presentations. Slides provides easy ways to insert charts, either as a static one (the figures are fixed) or as a dynamic one (the figures can be
- [Google Slides (14) - Using links to create quizzes, stories & games](https://bazroberts.com/2016/05/29/google-slides-using-links-to-create-quizzes-stories-games/) - [et_pb_section bb_built="1" admin_label="section"][et_pb_row admin_label="row" background_position="top_left" background_repeat="repeat" background_size="initial"][et_pb_column type="4_4"][et_pb_text admin_label="Text" background_layout="light" text_orientation="left" border_style="solid" background_position="top_left" background_repeat="repeat" background_size="initial" _builder_version="3.0.51" custom_margin="-100px|||"] Here we'll look at the power of links and how something so simple can allow you to make your slides more interactive. We'll cover: Inserting a link to a webpage From a text box From an image Inserting links
- [Google Slides (12) - Sharing, emailing & downloading](https://bazroberts.com/2016/05/27/google-slides-sharing-emailing-downloading/) - [et_pb_section bb_built="1" admin_label="section"][et_pb_row admin_label="row" background_position="top_left" background_repeat="repeat" background_size="initial"][et_pb_column type="4_4"][et_pb_text admin_label="Text" background_layout="light" text_orientation="left" border_style="solid" background_position="top_left" background_repeat="repeat" background_size="initial" _builder_version="3.0.51" custom_margin="-100px|||"] As with other Google Apps like Docs and Sheets, in Slides you have the ability to share your document with others, either by giving them access to your document or by emailing it to them. You can also
- [Google Slides (11) - Printing your slides](https://bazroberts.com/2016/05/25/google-slides-printing-your-slides/) - [et_pb_section bb_built="1" admin_label="section"][et_pb_row admin_label="row" background_position="top_left" background_repeat="repeat" background_size="initial"][et_pb_column type="4_4"][et_pb_text admin_label="Text" background_layout="light" text_orientation="left" border_style="solid" background_position="top_left" background_repeat="repeat" background_size="initial" _builder_version="3.0.51" custom_margin="-100px|||"] Even in this digital age, we still often print out our slides. On Slides this is easy to do and you have the option of printing them out in different formats. Here we'll look at: Printing and the
- [Google Slides (7) - Working with images (part 2)](https://bazroberts.com/2016/05/17/google-slides-working-with-images-part-2/) - [et_pb_section bb_built="1" admin_label="section"][et_pb_row admin_label="row" background_position="top_left" background_repeat="repeat" background_size="initial"][et_pb_column type="4_4"][et_pb_text admin_label="Text" background_layout="light" text_orientation="left" border_style="solid" background_position="top_left" background_repeat="repeat" background_size="initial" _builder_version="3.0.51" custom_margin="-100px|||"] Following on from the first part on working with images, here we'll cover: Inserting an image From your computer From a URL From Google Drive From a search Resizing an image Deleting a slide Inserting an image from your
- [Google Slides (6) - Working with images (part 1)](https://bazroberts.com/2016/05/17/google-slides-working-with-images-part-1/) - [et_pb_section bb_built="1" admin_label="section"][et_pb_row admin_label="row" background_position="top_left" background_repeat="repeat" background_size="initial"][et_pb_column type="4_4"][et_pb_text admin_label="Text" background_layout="light" text_orientation="left" border_style="solid" background_position="top_left" background_repeat="repeat" background_size="initial" _builder_version="3.0.51" custom_margin="-100px|||"] Using images is probably one of the most common things you'll do with Slides. Here we'll look at how we get images into Slides and some basic editing that can be done. We'll also touch on a couple of
- [Google Slides (5) - Creating lists & line spacing](https://bazroberts.com/2016/05/14/google-slides-creating-lists-line-spacing/) - [et_pb_section bb_built="1" admin_label="section"][et_pb_row admin_label="row" background_position="top_left" background_repeat="repeat" background_size="initial"][et_pb_column type="4_4"][et_pb_text admin_label="Text" background_layout="light" text_orientation="left" border_style="solid" background_position="top_left" background_repeat="repeat" background_size="initial" _builder_version="3.0.51" custom_margin="-100px|||"] One popular aspect of presentations is to have a list of key points. In Slides you have the choice of adding bulleted or numbered lists and also the option of choosing the style of the points (as you
- [Google Slides (4) - Working with text](https://bazroberts.com/2016/05/10/google-slides-working-with-text/) - [et_pb_section bb_built="1" admin_label="section"][et_pb_row admin_label="row" background_position="top_left" background_repeat="repeat" background_size="initial"][et_pb_column type="4_4"][et_pb_text admin_label="Text" background_layout="light" text_orientation="left" border_style="solid" background_position="top_left" background_repeat="repeat" background_size="initial" _builder_version="3.0.51" custom_margin="-100px|||"] In this post, I'm going to focus on working with text in your slides. If you're already familiar with Google Docs, a lot of the editing controls here are the same, but don't worry if you're not, I'm going to
- [Google Slides (1) - The basics](https://bazroberts.com/2016/05/06/google-slides-the-basics/) - [et_pb_section bb_built="1" admin_label="section"][et_pb_row admin_label="row" background_position="top_left" background_repeat="repeat" background_size="initial"][et_pb_column type="4_4"][et_pb_text admin_label="Text" background_layout="light" text_orientation="left" border_style="solid" background_position="top_left" background_repeat="repeat" background_size="initial" _builder_version="3.0.51" custom_margin="-100px|||"] This is the first of a new set of posts, this time looking at Google's presentation tool, Google Slides. It takes its cue from the classic Microsoft presentation software, Powerpoint, but as with the other Google Apps, it's far
- [Google Sheets (1) - The basics](https://bazroberts.com/2016/03/06/google-sheets-the-basics/) - [et_pb_section bb_built="1" admin_label="section"][et_pb_row admin_label="row" background_position="top_left" background_repeat="repeat" background_size="initial"][et_pb_column type="4_4"][et_pb_text admin_label="Text" background_layout="light" text_orientation="left" border_style="solid" background_position="top_left" background_repeat="repeat" background_size="initial" _builder_version="3.0.51" custom_margin="-100px|||"] Google Sheets is a wonderful spreadsheet program which can make your working life so much easier. So, what can it be used for? Calculations The number one use is manipulating data. Data is entered and the program can then be
- [Google Forms (8) - Adding images and videos](https://bazroberts.com/2016/02/14/google-forms-adding-images-and-videos/) - [et_pb_section bb_built="1" admin_label="section"][et_pb_row admin_label="row" background_position="top_left" background_repeat="repeat" background_size="initial"][et_pb_column type="4_4"][et_pb_text admin_label="Text" background_layout="light" text_orientation="left" border_style="solid" background_position="top_left" background_repeat="repeat" background_size="initial" _builder_version="3.0.51" custom_margin="-100px|||"] In Google Forms, apart from text, we can add images and videos to enrich the form, and as always this is simple to do. Adding an image to a form You can add images to your form. On the
- [Google Drive (12) - Uploading files and folders](https://bazroberts.com/2016/01/24/google-drive-uploading-files-and-folders/) - [et_pb_section bb_built="1" admin_label="section"][et_pb_row admin_label="row" background_position="top_left" background_repeat="repeat" background_size="initial"][et_pb_column type="4_4"][et_pb_text admin_label="Text" background_layout="light" text_orientation="left" border_style="solid" background_position="top_left" background_repeat="repeat" background_size="initial" _builder_version="3.0.51" custom_margin="-100px|||"] Google Drive is not just a place to store your Google Docs, Sheets, Slides, etc but you can use it to store pretty much whatever file you want. Uploading files is a piece of cake: 1) Click on
- [Google Docs (16) - Voice typing & voice control](https://bazroberts.com/2016/04/25/google-docs-voice-typing-voice-control/) - [et_pb_section bb_built="1" admin_label="section"][et_pb_row admin_label="row" background_position="top_left" background_repeat="repeat" background_size="initial"][et_pb_column type="4_4"][et_pb_text admin_label="Text" background_layout="light" text_orientation="left" border_style="solid" background_position="top_left" background_repeat="repeat" background_size="initial" _builder_version="3.0.51" custom_margin="-100px|||"] More and more we’re seeing devices controlled by your voice and Google Docs is no exception. It gives you the opportunity to input text via your voice instead of via the keyboard. It also allows you to control,
- [Google Docs (12) - Sharing, emailing & downloading](https://bazroberts.com/2016/04/22/google-docs-sharing-emailing-downloading/) - [et_pb_section bb_built="1" admin_label="section"][et_pb_row admin_label="row" background_position="top_left" background_repeat="repeat" background_size="initial"][et_pb_column type="4_4"][et_pb_text admin_label="Text" background_layout="light" text_orientation="left" border_style="solid" background_position="top_left" background_repeat="repeat" background_size="initial" _builder_version="3.0.51" custom_margin="-100px|||"] Google Docs gives you a variety ways you can share your document. Here we'll look at: Downloading a document Emailing a document Emailing to collaborators Emailing as an attachment Sharing a document Downloading a document You can download a 'physical' copy
- [Google Docs (10) - Spelling, your personal dictionary & word count](https://bazroberts.com/2016/04/17/google-docs-spellcheck-personal-dictionary-word-count/) - [et_pb_section bb_built="1" admin_label="section"][et_pb_row admin_label="row" background_position="top_left" background_repeat="repeat" background_size="initial"][et_pb_column type="4_4"][et_pb_text admin_label="Text" background_layout="light" text_orientation="left" border_style="solid" background_position="top_left" background_repeat="repeat" background_size="initial" _builder_version="3.0.51" custom_margin="-100px|||"] Here let's look at two useful tools in Docs, spelling and word count. As you write your text if you misspell any words, they will automatically be highlighted with a little red line underneath the word. So you
- [Google Docs (9) - Inserting links, drawings & lines](https://bazroberts.com/2016/04/17/google-docs-inserting-links-drawings-lines/) - [et_pb_section bb_built="1" admin_label="section"][et_pb_row admin_label="row" background_position="top_left" background_repeat="repeat" background_size="initial"][et_pb_column type="4_4"][et_pb_text admin_label="Text" background_layout="light" text_orientation="left" border_style="solid" background_position="top_left" background_repeat="repeat" background_size="initial" _builder_version="3.0.51" custom_margin="-100px|||"] Here let's look at how to insert links to webpages, documents on your Google Drive, and within your Google Doc. Plus, how to add drawings from Google Drawing, and adding a simple but effective horizontal line to organise
- [Google Docs (8) - Inserting headers, footers & page numbers](https://bazroberts.com/2016/04/17/google-docs-inserting-headers-footers-page-numbers-etc/) - [et_pb_section bb_built="1" admin_label="section"][et_pb_row admin_label="row" background_position="top_left" background_repeat="repeat" background_size="initial"][et_pb_column type="4_4"][et_pb_text admin_label="Text" background_layout="light" text_orientation="left" border_style="solid" background_position="top_left" background_repeat="repeat" background_size="initial" _builder_version="3.0.51" custom_margin="-100px|||"] In a previous post we looked at inserting images, but what else can you add to your documents? Here let's look at inserting things at the top or bottom of the page: Headers and footers Page numbers and page
- [Google Docs (7) - Printing](https://bazroberts.com/2016/04/17/google-docs-printing/) - [et_pb_section bb_built="1" admin_label="section"][et_pb_row admin_label="row" background_position="top_left" background_repeat="repeat" background_size="initial"][et_pb_column type="4_4"][et_pb_text admin_label="Text" background_layout="light" text_orientation="left" border_style="solid" background_position="top_left" background_repeat="repeat" background_size="initial" _builder_version="3.0.51" custom_margin="-100px|||"] Once you've made a stunning document, you may want to print it out. Let's go through the options Docs gives you. To print, click on the printer icon (or use the keyboard shortcut Ctrl + P (Mac: Cmd
- [Pimp up your Sheet - Programmatically!](https://bazroberts.com/2017/02/20/pimp-up-your-sheet-programmatically/) - [et_pb_section bb_built="1" admin_label="section"][et_pb_row admin_label="row" background_position="top_left" background_repeat="repeat" background_size="initial"][et_pb_column type="4_4"][et_pb_text admin_label="Text" background_layout="light" text_orientation="left" border_style="solid" background_position="top_left" background_repeat="repeat" background_size="initial" _builder_version="3.0.51" custom_margin="-100px|||"] When working with spreadsheets we can spend quite a long time making them look good and if we have to make the same sheets over and over again, that's a lot of wasted time. Here we'll look at
- [Apps Script Basics (2) - First Docs and Forms Scripts](https://bazroberts.com/2017/03/22/apps-script-first-docs-and-forms-scripts/) - [et_pb_section bb_built="1" admin_label="section"][et_pb_row admin_label="row" background_position="top_left" background_repeat="repeat" background_size="initial"][et_pb_column type="4_4"][et_pb_text admin_label="Text" background_layout="light" text_orientation="left" border_style="solid" background_position="top_left" background_repeat="repeat" background_size="initial" _builder_version="3.0.50" custom_margin="-100px|||"] Following on from my last post on creating your first script, here we're going to edit a Google Doc and also a Google Form. This will show you how you can access Docs and Forms, not just Sheets with

## Pages

- [Home](https://bazroberts.com/) - A collection of step-by-step tutorials to help you quickly learn Google Workspace and Google Apps Script, the code that can automate all of these.
- [Google Workspace and Apps Script Books and Videos](https://bazroberts.com/books/) - Google Workspace and Apps Script Books and Videos - Details of the books available on Amazon by author Barrie "Baz" Roberts and the videos available on Udemy
- [Google SLIDES Tutorials](https://bazroberts.com/slides/) - Step-by-step tutorials on how to use Google Slides. Plus, the latest news and improvements to Google Slides.
- [Google MEET Tutorials](https://bazroberts.com/meet/) - Learn Google Meet with my step-by-step tutorials. Plus, the latest news and improvements.
- [Google DRIVE Tutorials](https://bazroberts.com/drive/) - Grasp Google Drive with my step-by-step tutorials on how to use it. Plus, the latest news and improvements to Google Drive.
- [Google FORMS Tutorials](https://bazroberts.com/forms/) - Fully grasp Google Forms with my step-by-step tutorials on how to use them. Plus, the latest news and improvements to fantastic Google Forms.
- [Google SHEETS Tutorials](https://bazroberts.com/sheets/) - Excel in Google Sheets with in-depth step-by-step tutorials. Master the art of using Google Sheets effectively.
- [Google DOCS Tutorials](https://bazroberts.com/docs/) - Master Google Docs with my detailed step-by-step tutorials, along with the latest updates and enhancements to boost your productivity.
- [Boost Your Google Workspace skills with QUICK VIDEO Tips](https://bazroberts.com/how-to-videos/) - Master Google Workspace effortlessly with quick tips & tricks! Lots of 30 second videos to improve your Workspace skills quickly.
- [About bazroberts](https://bazroberts.com/about/) - Some background info about bazroberts.com and what to expect on it. Plus, how to contact me.
- [List of really useful Apps Script Resources](https://bazroberts.com/apps-script-resources/) - A list of some of Apps Script resources and some of the key people along with links to their sites. Plus, a list of recommended books and videos to check out.
- [Learn Google APPS SCRIPT](https://bazroberts.com/apps-script/) - Learn Google Apps Script with my comprehensive step-by-step tutorials, guiding you in writing and utilizing code effectively within Google Workspace.
- [Master Google SHEETS FUNCTIONS](https://bazroberts.com/sheet-functions/) - Master Google Sheets Functions with step-by-step tutorials & loads of practical examples for effortless Learning.
- [Mixes by BazR](https://bazroberts.com/mixes/) - A selection of mixes by BazR.
- [Privacy Policy](https://bazroberts.com/privacy-policy/) - Privacy policy information
- [Donor Dashboard](https://bazroberts.com/donor-dashboard/)
- [zBaz Roberts Apps](https://bazroberts.com/baz-roberts-apps/) - Privacy Policy General This page is used to inform users of apps created by Barrie Roberts at clic-International House, regarding our policies with the collection, use, and disclosure of personal information. If you choose to use our service, then you agree to the collection and use of information in relation with this policy. The personal

## Categories

- [Drive](https://bazroberts.com/category/drive/)
- [Docs](https://bazroberts.com/category/docs/)
- [Forms](https://bazroberts.com/category/forms/)
- [Sheets](https://bazroberts.com/category/sheets/)
- [Slides](https://bazroberts.com/category/slides/)
- [Apps Script](https://bazroberts.com/category/apps-script/)
- [Sheet Functions](https://bazroberts.com/category/sheet-functions/)
- [Books](https://bazroberts.com/category/books/)
- [News](https://bazroberts.com/category/news/)
- [Posts](https://bazroberts.com/category/posts/)
- [Meet](https://bazroberts.com/category/meet/)
- [Sites](https://bazroberts.com/category/sites/)
- [Gmail](https://bazroberts.com/category/gmail/)
- [Keep](https://bazroberts.com/category/keep/)
- [Docs News](https://bazroberts.com/category/docsnews/)
- [Drive News](https://bazroberts.com/category/drivenews/)
- [Forms News](https://bazroberts.com/category/formsnews/)
- [Meet News](https://bazroberts.com/category/meetnews/)
- [Sites News](https://bazroberts.com/category/sitesnews/)
- [Sheets News](https://bazroberts.com/category/sheetsnews/)
- [Slides News](https://bazroberts.com/category/slidesnews/)
- [Keep News](https://bazroberts.com/category/keepnews/)
- [Gmail News](https://bazroberts.com/category/gmailnews/)
- [Apps Script News](https://bazroberts.com/category/appsscriptnews/)
- [Docs Posts](https://bazroberts.com/category/docsposts/)
- [Drive Posts](https://bazroberts.com/category/driveposts/)
- [Forms Posts](https://bazroberts.com/category/formsposts/)
- [Meet Posts](https://bazroberts.com/category/meetposts/)
- [Sheets Posts](https://bazroberts.com/category/sheetsposts/)
- [Slides Posts](https://bazroberts.com/category/slidesposts/)
- [Apps Script Posts](https://bazroberts.com/category/appsscriptposts/)
- [Sites Posts](https://bazroberts.com/category/sitesposts/)
- [Sheet Functions Posts](https://bazroberts.com/category/sheetfunctionsposts/)
- [Gemini](https://bazroberts.com/category/gemini/)

## Tags

- [Sites](https://bazroberts.com/tag/sites/)
- [Drive](https://bazroberts.com/tag/drive/)
- [Calendar](https://bazroberts.com/tag/calendar/)
- [Docs](https://bazroberts.com/tag/docs/)
- [Sheets](https://bazroberts.com/tag/sheets/)
- [Slides](https://bazroberts.com/tag/slides/)
- [Hangouts](https://bazroberts.com/tag/hangouts/)
- [Gmail](https://bazroberts.com/tag/gmail/)
- [Forms](https://bazroberts.com/tag/forms/)
- [Classroom](https://bazroberts.com/tag/classroom/)
- [Apps script](https://bazroberts.com/tag/apps-script/)
- [meet](https://bazroberts.com/tag/meet/)
- [Tables](https://bazroberts.com/tag/tables/)
- [Google Meet](https://bazroberts.com/tag/google-meet/)
- [google calendar](https://bazroberts.com/tag/google-calendar/)
- [sheets functions](https://bazroberts.com/tag/sheets-functions/)
- [functions](https://bazroberts.com/tag/functions/)
- [xlookup](https://bazroberts.com/tag/xlookup/)
- [vlookup](https://bazroberts.com/tag/vlookup/)