Modern Excel MasterClass and Google Sheets with AI ChatGPT

Master fundamentals of Excel and Google Sheets, navigate cells, enter data, format professionally, and apply formulas like vlookup, index match, and average if while creating charts and dashboards.

Discover the Microsoft Excel layout, including the ribbon, quick access toolbar, worksheet grid, name box, formula bar, and sheet tabs, and learn basic navigation and cell references.

Master the core structure of excel by navigating cells, rows, columns, and worksheets, learn to select ranges, rename and manage multiple sheets, and organize data for easy formatting.

Explore text, number, date, and currency data types in Excel, and learn how each type affects formulas, sorting, and calculations, and how wrong data types can cause errors.

Master copy, paste, and paste specials in Excel to manage data with precision, automate formulas with relative references, and reuse formatting and values, including transpose transformations.

Learn to move and resize rows and columns in Excel, use drag and autofit to fit long text, and rearrange columns with shift-drag for clean, professional worksheets.

Master core Excel cell formatting to make data clean and professional by styling text, numbers, alignment, colors, borders, and using cell styles for polished spreadsheets.

Format percentages, decimals, and currency in Excel to make growth, pricing, and revenue data clear. Use the home tab and format cells to set decimals and currency.

Apply simple filters, text filters, number filters, and date filters in Excel to extract specific data, using multiple conditions and or filtering, with practical examples of regions, category, and quantity.

Learn how relative references automatically update formulas when copied. Use absolute references with dollar signs to fix cells, and explore mixed references for columns or rows.

Explore basic arithmetic formulas in Excel, including addition, subtraction, multiplication, and division, with a step-by-step demo dataset to practice calculating totals, differences, and ratios.

Master the if statement in Excel by learning its syntax—logical test, value if true, and value if false—and apply it to scores for pass/fail and payment status.

Master nested if in Excel to test multiple conditions, return different results, and automate grade and category assignments across score ranges using a data set.

Master text join in excel to efficiently combine names, cities, and skills with delimiters, ignore empty cells, and create multiline outputs for bios, reports, or forms.

Explore excel date functions today and now to detect overdue items, calculate days remaining, and distinguish date only from date and time, using if and networkdays with holidays.

Master using EOMONTH for month end calculations and year month formats to build month based totals, month keys, and clean reports with sumifs and pivot tables in Excel.

Learn how to handle and hide Excel errors with Iferror and related functions to keep calculations stable when data is missing or invalid, demonstrated with practical datasets and totals.

Explore how lookups in Excel search data and pull values from tables using VLOOKUP, XLOOKUP, and horizontal lookups for exact matches, and learn to handle missing data with IFERROR.

Master the Vlookup function to search the first column and return related values from other columns, using exact-match lookups and absolute references with dollar signs in practical Excel scenarios.

Learn to use the index plus match lookup in Excel, a flexible alternative to vlookup that retrieves price or stock in any direction for large data sets.

Master Xlookup in Excel to replace Vlookup and Hlookup, enabling flexible left-to-right and right-to-left lookups for product IDs, names, and prices.

Master the unique function in Excel to clean data, remove duplicates, and extract distinct lists. Sort results alphabetically for a clean, ready-to-use dashboard and reports.

Learn how the sort and sort by functions in Excel organize data instantly without altering the underlying data, using ascending or descending orders and multi-column criteria.

Master Excel's sequence function to auto generate numbered lists and five rows by four columns, start values, and steps, enabling IDs, dates, and data patterns with dynamic arrays.

Use array formulas in Google Sheets to automate calculations across entire columns without dragging. Apply one array formula to generate totals, full names, sales categories, and discounts as data expands.

Identify and remove duplicates in Excel and Google Sheets using the remove duplicates tool and the unique formula to create a clean, accurate dataset without altering originals.

Learn to clean messy data in Excel and Google Sheets using trim, clean, and substitute to remove extra spaces, invisible characters, and incorrect text, including emails and product codes.

Split text to columns in Excel and Google Sheets to clean data. Split names into first and last, emails into user and domain, and phones into country code and number.

Normalize dates and text in Excel and Google Sheets to create clean, consistent data for analysis by converting text dates and standardizing case and spacing.

Master conditional formatting basics in Excel and Google Sheets with practical demos that highlight important numbers, flags, exceptions, and row colors, and build formula-based rules.

Learn to apply color scales and icon sets in Excel and Google Sheets using conditional formatting to create heat maps and clear growth indicators.

Create pivot charts in Excel and Google Sheets from pivot tables to visualize summarized data by regions and month, then customize with chart types, titles, colors, and labels.

Master pivot tables in Google Sheets to quickly summarize data, analyze patterns, and reveal top performing items by regions. Create pivot tables with drag-and-drop, totals, and filters to derive insights.

Create and customize column, line, bar, and pie charts in Excel and Google Sheets using monthly sales data sets to reveal trends and contributions for reports.

Explore advanced charts in Excel and Google Sheets, including combo charts, trend lines, and sparklines, to turn raw data into clear visuals. Perfect for dashboards and reports.

Design a clean, professional dashboard in Excel or Google Sheets to visualize sales data with KPIs like total sales, total quantity, and average unit price, plus charts and interactive filters.

Explore Visual Basic for Applications in Excel to automate repetitive tasks through simple scripts, using the VBA editor and modules to calculate totals and extend with loops.

Learn to share and protect workbooks in Excel and Google Sheets, set permissions, and collaborate in real time, using password protection and version history to track changes.

Boost productivity in Excel and Google Sheets by mastering essential keyboard shortcuts for navigation, formatting, and data editing on sample data sets.

Discover how to debug formulas in Excel and Google Sheets with ChatGPT, diagnose errors in plain English, and generate corrected formulas for faster spreadsheet troubleshooting.

Create dashboards, automate scripts, and generate reusable templates in Excel and Google Sheets using ChatGPT as a personal assistant. Build formulas, charts, pivot tables, and templates without coding.