Master Excel, AI & Google: Skills Training for All Levels

Create a Google account to access Google My Maps, Gmail, Drive, and Forms; learn choosing personal or business, free options, and basic setup steps like password, recovery, and privacy.

Explore the Google account panel, mailbox, and left navigation to access Google Maps and Google My Maps, Drive shortcut, Translator shortcut, Chrome, Google Documents, Google Sheets, and Google Forms.

Use the Google Forms panel to create a form with the plus button or choose ready-to-use forms. Add questions like name, email, phone, and comments, then share the form.

Create a Google Form from scratch, set the title and description, insert links and images, and use diverse question types like short answer, paragraph, multiple choice, and date.

Master Google Forms question functionality with response validation, number and text rules, email and website validation, length limits, regex, section-based navigation, shuffled options, media, and import questions.

Learn to import questions quickly from other forms in Google Forms, select all or specific questions like email short answer, and paste city lists from external files.

Apply Google Forms regular expression validation to enforce a postcode format, using response validation with a regex for two letters A to Z followed by four digits.

Learn to send a Google form using the top-right send button, choose email or link options, shorten and copy the link, or grab embed code for your website.

Explore how to collect email addresses in Google Forms by enabling the collect emails option, adding an email validation, and previewing how the logged-in Gmail address appears in responses.

Explore Google forms responses and connect them to a Google Sheets spreadsheet, creating a new sheet or selecting an existing one for each question to become a column.

Learn to review Google Forms using the question tab to check answers, track who is available and when, and use the individual tab to view a responder's profile.

Configure Google Forms settings to require questions by default, collect emails, and allow responders to edit; customize confirmation messages and enable progress bars or shuffled questions.

Customize Google Forms appearance by adjusting theme, fonts, and text styles, add a header image, and upload your own or use Google-provided images to tailor colors and background.

Apply the Google Forms functionality you just learned. Launch the first practical example now to begin applying your knowledge.

Create an employee order form connected to a registration form while exploring Google Forms and discussing Google My Maps.

Open Google Forms and send responses to a new Google Sheet, then build a spreadsheet with timestamp, fullname, profession, city, and phone number; hide unused columns and apply colors.

Explore prepared templates in the Template Gallery to quickly create a monthly budget with automatic calculations, a to-do list, an invoice system, and a weekly timesheet.

Create a new spreadsheet in Google Sheets by opening the nine dots menu in your Google account and selecting plus and blank spreadsheet for standalone sheet or with Google forms.

Explore how to input and use functions in Google Sheets. Sum numbers with the equal sign and work with ranges like A1 to A29.

Explore a curated list of Google Sheets functions, including date, logical, and text functions, and learn to access them via insert > function for practical invoice examples.

Learn to copy and paste with shortcuts in Google Sheets and freeze the top row and columns via the view menu.

Master the Google Sheets data filter to quickly narrow down your candidate database by job title and language, making large lists searchable with just a few clicks.

Hide and unhide columns in Google Sheets by selecting adjacent columns and using the right-click unhide option. Group columns via view, and apply color highlighting to emphasize the profession column.

Learn to add extra rows in Google Sheets by right-clicking a row and inserting above or below, selecting multiple rows, and changing the height for all selected rows.

Master Google Sheets customization by applying borders with color and thickness, merging cells, changing backgrounds, and formatting font color, bold or not, and center alignment for clean layouts.

Learn how to use Google Sheets VLOOKUP to perform vertical lookups by defining the search key, range, and column index, and specifying sorted options to retrieve data.

Master Google Sheets absolute references with the dollar sign, fix copied formulas, and use F4 to toggle references while copying with Ctrl+C and Ctrl+V.

Learn the Google Sheets if function with a simple example using A1 and A3, showing how to return yes or a text value when A1 equals zero, using quotes.

Learn how to use the isblank function in Google Sheets to check if a cell is empty, returning true for empty and false otherwise, to help fix errors.

Learn how to combine functions in Google Sheets, fix common errors with empty cells, and use is blank and vertical lookup to return results or nothing.

Learn to compile candidate profiles from gathered data in Google Sheets, then quickly copy and send them to our client, and switch between candidates as needed.

Demonstrate how to send the candidate profile to a client using the free Windows snipping tool and paste it into email or WhatsApp.

Learn how to use Google My Maps, a Google Maps tool linked with Google Sheets, and create a map via Google Drive or google.com/maps.

Import data into Google My Maps using the import button on an untitled layer, pulling Excel or Google Sheets from Drive, map city columns to placemarks, and add layers.

Separate job offers from candidates on Google My Maps by applying a uniform style to map layers, enabling instant color differentiation and clearer visual insights.

Learn to customize Google My Maps profile data by editing the view, hiding unnecessary fields, and renaming labels such as contact and company name for a cleaner display.

Explore how to apply labels to map points in Google My Maps using a uniform style, showing distance to the project and other details for candidates and job offers.

Learn how to customize Google My Maps icons by opening the icon style panel, changing colors, and adding extra icons to represent items like candidates or job offers.

Adjust the Google My Maps map view by using the base map option, selecting from several styles to improve visibility.

Learn to create routes with Google My Maps, add start and destination, view step-by-step directions, measure distance, and share routes via WhatsApp or email, noting limitations compared to Google Maps.

Explore the profile view in Google Maps, connect destinations, and quickly generate a route to a job offer by copying a candidate's city and pasting it into Google Maps.

Use Google My Maps to visually filter data on a map by experience, spotlight carpenters with color codes for experience levels and customizable icons.

Learn to share Google My Maps links with view-only access, hide contact details like phone numbers, and copy the link to send profiles to your client.

Explore practical Excel examples and learn to create your own invoice system, while comparing Excel to Google Sheets and noting available free tools like OpenOffice Calc.

Learn to create a new Excel file and invoice template, copy a Google Sheets template with Ctrl+C/Ctrl+V, and format cells with merge, font size, bold, color, alignment, and borders.

Increase the indentation of selected cells, including multiple cells, using the indent command, then insert a logo from my device and adjust its size on the worksheet.

Learn how to automatically insert the current date in Excel using TODAY() and =TODAY(), so invoices update daily.

Learn how to add text to an automatically generated date in Excel by building a formula that includes quoted text and referenced cells, creating a dynamic date label.

Learn how to use the text() function to convert dates to text in a chosen day month year format, applying format strings and copying the result across cells.

Explore how to use the CHAR() function in Excel to return characters from a code, including examples like code 65 for uppercase A, and how to look up additional codes.

Learn to automate date entry in Excel with the Today function, display the actual date and week numbers for invoices, and insert a new row while preserving date formats.

Create a new client sheet and table, then use data validation with a list to select a client name that auto-fills related fields as new clients are added.

Automate client addresses with VLOOKUP in spreadsheets. Pull city, state, and zip from a table using equal sign and column arguments to streamline data entry in Excel and Google Sheets.

Learn to use the vertical lookup (VLOOKUP) function to auto populate an extra column with each client’s payment term and adjust the payment date using today plus 60 days.

Automate invoice numbers in Excel using the max function to find the current maximum in the invoice list table and add one for the next number.

Master Excel cell formatting with a custom format to automatically prefix numbers with a date component, using the year function via right-click format cells and entering a custom code.

Learn to move cells in Excel with select, Ctrl C, Ctrl V, and Ctrl Z, while applying dollar signs for formulas, then unmerge/merge cells and adjust spacing for days.

Learn to enhance an invoice in Excel by inserting icons, selecting from built-in options, and adjusting size, color, and indentation for a polished top section.

Explore Excel sheet copy and data validation to automate invoicing, create separate invoices for recruitment and construction, and calculate wages and totals from activity tariffs.

Add a VAT column in Excel by inserting a column to the left, and add rows on the top side as needed, then enter VAT information while watching tax rules.

Multiply hours by wage to get net amount, add vat (21%) to obtain gross amount, and use the sum function with absolute references in Google Sheets.

Master handling empty cell references in Excel using the na and if functions, with a practical invoice example that assigns hours to a worker.

Learn to export invoices as pdf from excel by using file export, choosing save location, and adjusting page breaks to fit one page before publishing to client.

Master Excel invoice workflows by exporting the file, creating a PDF, and sending invoices to clients; use AI to automate invoice numbers, client emails, and sending steps for faster delivery.

Apply a formula-based conditional formatting rule in Excel to highlight invoices that should be paid by coloring them orange when the cell value is earlier than today.

Discover how long it takes to prepare an invoice in Excel for the same client and send it immediately.

Copy data from Google Sheets to Excel to build a schedule; select the latest entries, copy, and paste, then prepare the data for clearer scheduling and future work.

Learn how to enable the Developer tab in Excel by right-clicking the ribbon, selecting customize the ribbon, and adding the Developer option, then insert a button and explore other controls.

Learn how to attach a macro to an Excel button to automatically fill data in a row, by right-clicking the button, choosing assign macro, and creating or editing macros.

Add a logo as a button to export the file to PDF under a chosen name, hiding the name in the PDF, and assign the macro via AI chat.

Create a 31-day calendar in Excel to track when workers start and finish, using imported data and filter options to move staff to other work; next lesson covers conditional formatting.

Apply the if function to compare dates, returning zero or one, and fix references with dollar signs while dragging. Use conditional formatting to highlight ones in orange.

Learn how the and function in Excel works by evaluating multiple conditions, returning true when all conditions are met, and use it to drive steps in your workflow.

Learn to finish a schedule in Excel by building an if with and function to handle started and finished cases, convert booleans with double minus, and apply conditional formatting.

Master MS Excel schedule use with two practical examples: filtering candidates and marking invoiced periods for clients, helping you avoid missing information and accelerate your workflow through innovation.

Create visual job offers in excel by inserting a background image, adding shapes and text, and saving as a png, with notes on artificial intelligence imagery and using Canva.

Apply picture styles in Excel by double-clicking an image, select a style, add shadows, and adjust its size to enhance visuals for job offers.

Explore advanced MS Excel image tools, including color changes, transparency, borders, effects, artistic styles, and background removal, along with other available picture options.

Learn to create a ChatGPT account without coding, compare GPT-3.5 and GPT-4 options, and explore AI tools like creating buttons in Excel and Gemini, while navigating openai.com signup and email verification.

explore chatgpt 3.5 by asking any question in any language, with direct translation and quick, direct answers; image creation is in the upgrade plan, with faster responses than chatgpt 4.

Demonstrates creating a job offer with ChatGPT 3.5 by supplying a complete command, generating a fast draft, and refining missing company name and contact details.

Explore using ChatGPT 3.5 to fill missed details, request corrections, and copy and send, with tips for formatting a Facebook post, to be covered in the next lesson.

Tune up your job offer to post on Facebook by adding icons to improve its appearance and make it look notably better.

Publish your job offer on Facebook or your website by following seo rules to boost search engine visibility.

Discover how to generate a candidate profile in Excel by selecting a database row, copying and pasting it, and using ChatGPT 3.5 to interpret job details for a tailored offer.

Refine a description style for ChatGPT 3.5 by expanding text, replacing passages, and adopting a more encouraging, clearer writing tone that enhances overall clarity.

Develop email messaging skills with AI, using ChatGPT 3.5 to craft a candidate profile email, including subject lines, introductions, conclusions, and client communications.

Learn to use Google My Maps and ChatGPT 3.5 to assess candidate feasibility for Berlin projects, evaluating travel distance up to 90 km, and generate client-ready emails in seconds.

Discover practical ChatGPT 3.5 options to organize topics, rename, delete, share, archive, and copy messages quickly. Regenerate responses, compare options for quality, and view details to improve ChatGPT performance.

Explore how chatgpt 3.5 translates and recognizes languages beyond English and instantly generates multilingual offers, such as Dutch sales copy, with accurate language-aware results.

Discover fast ai chatgpt 3.5 use cases—from creating advertisements to planning Excel button implementations—and follow a complete plan to build an Excel button.

Automate invoicing in Excel with a macro-enabled workbook and a button, using ChatGPT to generate the macro that transfers payment list data to the invoice sheet.

Create a button-triggered macro in Excel that exports the active sheet as a pdf, naming the file from the invoice number and cells G13 and A13 with ChatGPT 3.5 guidance.

A single macro button automates sending an Outlook email with a PDF attachment from Excel, retrieves the client email from merged B13/C13, and opens the payment list to finalize invoice.

Use ChatGPT 4.0 to create and refine AI-generated images, including a construction job offer picture, by removing objects and adjusting descriptions. Explore AI tools for realistic image creation and downloads.

Explore ChatGPT 4.0 capabilities to attach documents, read and convert to text, and generate a PDF CV from short data via Google My Maps, with bold headers and downloadable output.

Explore substitutes to GPT-4, like Gemini and Bing Copilot. Compare ChatGPT with Gemini for SEO article creation and use Canva or Video Victoria AI to craft images and videos.

Discover how attaching or pasting any file into ChatGPT, including a PNG CV, lets you extract text, translate it to English, and save time.

Analyze attached CVs against a job offer to evaluate candidates, highlighting fit for marketing, German language skills, and recruitment planning experience.

Learn to generate ai-driven videos from simple text prompts, creating a 15-second job advertisement for Amsterdam carpenters and delivering it to YouTube.

Explore Google Sheets for database and profile management within a comprehensive Excel, AI, and Google skills training course.