Excel Mastery covers everything from intermediate to advanced. You will learn: VLOOKUP, XLOOKUP, INDEX/MATCH, nested IF statements, SUMIFS/COUNTIFS, pivot tables (including calculated fields), conditional formatting, data validation, Power Query (get…
Word Professional transforms how you create documents. You will learn: styles and formatting (the RIGHT way), template creation, headers/footers/page numbering, table of contents (automatic), mail merge (letters, labels, emails), track changes and co…
Google Docs Suite covers the entire Google Workspace for documents. You will learn: Google Docs (advanced formatting, voice typing, suggesting mode, table of contents, add-ons), Google Slides (master slides, animations, presenter tools, audience Q&A)…
Google Sheets Analytics focuses on the features unique to Google Sheets that make it powerful for analytics and automation. You will learn: QUERY function (SQL-like syntax), ArrayFormula, ImportRange (cross-spreadsheet references), IMPORTHTML/IMPORTX…
PowerPoint & Slides teaches you to create presentations that look professional and actually persuade. You will learn: slide design principles (less is more), colour theory for slides, typography for presentations, slide masters and layouts, SmartArt …