Microsoft Excel with AI & Google Tools

Current Status

Not Enrolled

Price

£97.00

Get Started

Take this Courseor

Course / Module Content

Section 1: As A Warm-UP

As a Warm-UP 2 Topics

Session Content

0% Complete 0/2 Steps

1.1. Google Account Creating

1.2. Google Account Panel

Section 2: Google Tools - Google Forms

Google Tools – Google Forms 13 Topics

Session Content

0% Complete 0/13 Steps

2.1. Google Forms Panel

2.2. Google Form – Create New & Question Types

2.3. Google Forms – Question Functionality

2.4. Google Forms – Fast Question & Data Import

2.5. Google Forms – Regular Expression Validation

2.6. Google Forms – How To Send

2.7. Google Forms – Email Collecting

2.8. Google Forms – Responses I (Google Sheets)

2.9. Google Forms – Responses II

2.10. Google Forms – Settings

2.11. Google Forms – Customisation

2.12. Google Forms – Practical Example

2.13. Google Forms – Practical Example II

SECTION 3: GOOGLE TOOLS - GOOGLE SHEETS

Google Tools – Google Sheets 17 Topics

Session Content

0% Complete 0/17 Steps

3.1. Google Sheets – Introduction

3.2. Google Sheets – Possibilities Examples (Templates)

3.3. Google Sheets – Create New

3.4. Google Sheets – First Function

3.5. Google Sheets – Functions List

3.6. Google Sheets – Freeze Option

3.7. Google Sheets – Data Filter

3.8. Google Sheets – Hide & Group Option

3.9. Google Sheets – Extra Rows & Height Change

3.10. Google Sheets – Customisation

3.11. Google Sheets – VLOOKUP Function

3.12. Google Sheets – Function Copy & Dollar Sign

3.13. Google Sheets – IF Function

3.14. Google Sheets – ISBLANK Function

3.15. Google Sheets – Functions Combining

3.16. Google Sheets – Profile View

3.17. Google Sheets – Copy Profile (Windows Snipping Tool)

SECTION 4: GOOGLE TOOLS - Google My Maps

Google Tools – Google My Maps 11 Topics

Session Content

0% Complete 0/11 Steps

4.1. Google My Maps – New Map

4.2. Google My Maps – Data Import

4.3. Google My Maps – Visual Layers Separation

4.4. Google My Maps – Profile Data Customisation

4.5. Google My Maps – Labels

4.6. Google My Maps – Icons

4.7. Google My Maps – Map View

4.8. Google My Maps – Route

4.9. Google My Maps – Profile View & Google Maps

4.10. Google My Maps – Visual Data Filtering

4.11. Google My Maps – Share (Excl. Contact Details)

section 5: MICROSOFT Excel

MS Excel 36 Topics

Session Content

0% Complete 0/36 Steps

5.1. MS Excel – Introduction

5.2. MS Excel – New File & Template Copy

5.3. MS Excel – Text Indent & Image Upload (Logo)

5.4. MS Excel – Function TODAY()

5.5. MS Excel – Text with Formula

5.6. MS Excel – TEXT() Function

5.7. MS Excel – CHAR() Function

5.8. MS Excel – Actual Date & Week

5.9. MS Excel – New Sheet & Data Validation (List)

5.10. MS Excel – Client Address Automation (VLOOKUP)

5.11. MS Excel – Payment Term (VLOOKUP)

5.12. MS Excel – MAX() Function & Invoice Number

5.13. MS Excel – Format Cells & YEAR()

5.14. MS Excel – Cells Moving

5.15. MS Excel – Icon

5.16. MS Excel – Sheet Copy & Validation Repeat

5.17. MS Excel – Column Addition (VAT)

5.18. MS Excel – VAT (Multiplication & Addition)

5.19. MS Excel – NA & IF() Solution

5.20. MS Excel – NA & IF() Solution

1 of 2

section 6: artificial inteligence

Artificial Inteligence 21 Topics

Session Content

0% Complete 0/21 Steps

6.1. AI – GPTChat Account Creating

6.2. AI – ChatGPT 3.5 1st Question

6.3. AI – ChatGPT 3.5 – Job Offer Creating

6.4. AI – ChatGPT 3.5 – Question Refilling

6.5. AI – ChatGPT 3.5 – Facebook Look

6.6. AI – ChatGPT 3.5 – Jobs & SEO

6.7. AI – ChatGPT 3.5 & Excel (Candidates Profile)

6.8. AI – ChatGPT 3.5 – Description Style

6.9. AI – ChatGPT 3.5 – Email Message Creating

6.10. AI – ChatGPT 3.5 – Google My Maps & Distance Question

6.11. AI – ChatGPT 3.5 – Options

6.12. AI – ChatGPT 3.5 – Language

6.13. AI – ChatGPT 3.5 – Other Fast Examples

6.14. AI – ChatGPT 3.5 & Excel (Button)

6.15. AI – ChatGPT 3.5 & Excel (Button PDF Export)

6.16. AI – ChatGPT 3.5 & Excel (Button Email)

6.17. AI – ChatGPT 4.0 Picture Creating

6.18. AI – ChatGPT 4.0 – PDF Creating

6.19. AI – ChatGPT 4.0 – Limit & Substitutes (Gemini, Bing-Copilot)

6.20. AI – ChatGPT 4.0 – Document & Text

1 of 2

EXTRA'S & SUMMARY

Extra’s & Summary 7 Topics

Session Content

0% Complete 0/7 Steps

Extra – Schedule & Invoice Button

Summary – Excel & GPT (Invoice & Buttons)

Summary – Excel (Invoice Without Buttons)

Summary – Excel (Schedule & Invoice)

Summary – Google Forms

Summary – Google My Maps

Summary – Google Sheets (Database & Profile)

AAT Bookkeeping

AAT Business Skills

How to study for free?

AAT Accounting

Free Trial Online Lessons

Bundle Discount Deals

Microsoft Excel with AI & Google Tools

Course / Module Content

Courses / Webinars

Sepera Board

AAT Quick Links

Business Oportunity

Join Our Newsletter