Formulas 2 – Useful Functions - Nexgenlernrs

Comprehensive Digital Literacy & AI-Assisted Productivity Formulas 2 – Useful Functions

Comprehensive Digital Literacy & AI-Assisted Productivity

0% Completed

Foundations of digital literacy and search

What is digital literacy?

Web browsers and smart searching

Smart searching – evaluating sources

Note taking from the web

Online safety and digital well‑being

Online identity and footprints

Passwords, phishing, scams

Cyberbullying and respectful communication

Screen time and focus

Safety scenarios and contract

Docs and AI‑assisted writing

Getting started with Docs

Collaboration in Docs

Structure of good writing

AI in Docs – drafting and improving

Formal documents – Letters and Resumes

Templates and Styles

Checking language and clarity

Sheets and basic data skills with AI

Intro to Sheets

Formulas 1 – Basics

Formulas 2 – Useful Functions

Charts and visualisation

AI in Sheets – formulas and analysis

Data cleaning and organisation

Slides and visual storytelling with AI support

Basics of Slides

Design principles in presentations

Story structure in presentations

Using AI to draft slides content

Email, cloud storage, and workflow

Inbox organisation

AI in email – writing and replies

Cloud storage and Drive basics

Collaboration and file management

Workflow day – “From idea to presentation”

Capstone and freelancing angle

Announcements Reviews Course Info

Formulas 2 – Useful Functions

Topics: SUM, AVERAGE, MIN, MAX, COUNT, simple IF.