Excel + ChatGPT : The Complete AI- Powered Excel Course-2026

Open and launch Excel, search in the bar to access Excel, create a new workbook or apply a template, and save or rename files with autosave.

Learn five practical ways to save an Excel workbook, including save icon, file save, save as, workbook name shortcuts, and ctrl+s, with desktop path examples.

Discover the difference between save and save as in Excel. Learn when to use each option and how save as creates a new file without disturbing the current one.

Discover how to enable autosave in MS Excel, automatically saving new data to OneDrive and recover unsaved work by configuring the Quick Access Toolbar and turning autosave on.

Rename an Excel workbook by right-clicking and selecting rename, or by single-clicking the file name. Use the F2 shortcut to rename, for example from autosave to a student list.

Explain the structure of Microsoft Excel, including the grid with 1,048,576 rows and 16,384 columns, and the interface components like the quick access toolbar, workbook, worksheet, ribbon, and tabs.

learn to hide and restore excel tabs, the formula bar, and the quick access toolbar using file options, customize ribbon, and view settings.

Master copy paste, cut, and format painter in the Excel clipboard under the home tab, learning how to paste without altering originals and how to copy formatting to other cells.

Learn font management in Excel by using the home tab's font group to adjust font size, apply bold, italic, underline, borders, and fill colors for a sales report.

Learn how to use Excel's alignment tools to top, middle, and bottom align text, left/center/right alignment, indent controls, merge and unmerge cells, rotate text, and wrap text for proper formatting.

Master number formats in Excel, applying currency, decimal, date, time, and percentage formats using the number control, including custom formats and currency symbol changes.

Apply conditional formatting in Excel to highlight cells with rules like greater than, between, equal to, text that contains, and date occurring, using color fills and clear rules.

Learn to apply conditional formatting in Excel, highlighting top/bottom values with top/bottom and percentage rules, flagging above or below average, and exploring data bars, color scales, icons, and rule management.

Explore conditional formatting in Excel by applying data bars (gradient and solid), color scales for temperature data, and icon sets to visualize trends in student marks and weather data.

Master advanced conditional formatting in Excel by creating formula-based rules that highlight cells matching product names such as t shirt, shoes, and sweater.

Master advanced conditional formatting by using a formula to highlight the entire row when a product code matches, applying a green fill to the total row.

Master advanced conditional formatting in Excel by highlighting the total row and column based on city and product parameters, using a formula to determine formatting.

Present data in table format in Excel by using format as table, choosing a color style, and applying filters to show customers by city such as Bhubaneswar.

Apply cell styles in Excel to color-code student results by division, using good, neutral, and bad colors via the sales tile, with filter steps to view each division.

Learn to insert cells, rows, columns, and sheets in MS Excel using the insert menu, with shift options right or down, and insert entire row, column, or sheet.

Learn how to delete cells, rows, columns, and sheets in MS Excel, including shifting cells, deleting entire rows or columns, and undoing changes with Ctrl+Z.

Adjust row height in Excel by using format row height and autofit row height to increase, decrease, or restore to the default 14.5.

Learn to adjust column width in Excel by setting a default width, resizing with format options or drag, and using autofit to restore the original size.

Master hiding and unhiding rows, columns, and sheets in Excel using the Format menu, with examples like rows 6 and 10, column B, and sheets 3 and 4.

Learn shortcuts to move or copy sheets, create duplicates, and rename sheets. Apply tab colors like red, green, and blue to organize your workbook.

Learn four ways to protect an Excel sheet and workbook, including right-click protect, home format protect, review protect, and allow insert or delete rows or columns.

Protect the sheet with a password while unlocking ten cells for editing. Unprotect the sheet and unlock only the growth and degrowth cells.

Master pivot tables in Excel to summarize, group, filter, and sort large data sets. Learn step-by-step setup, field placement, formatting, and common pitfalls to build flexible, report-ready analyses.

Learn to build and format a pivot table from a retail sales dataset, arranging state and sales executive, total sales amount, remove subtotals, set tabular layout, and apply INR currency.

Build a pivot table from data to analyze region and state counts, and compute maximum, minimum, and average sales values with customized design and grand totals removal.

Explore how to use Excel's recommended pivot tables to visualize data quickly, selecting data, choosing templates, and reviewing fields like state, product, sales amount, and quantity.

Learn how to insert a normal table in Excel, select fields, apply a design, and use filters to display data like Anil Singh, city, state, product, quantity, and sales amount.

Learn how to create a pivot table from a table range and group date data by year, quarter, month, or day to analyze sales quantities and amounts.

Master custom grouping in pivot tables by categorizing cities into East, West, South, and North regions. Learn data selection, pivot creation, and renaming regions for regional sales analysis.

Learn how to create pivot tables, switch to the classic layout, and arrange date, quarter, and month fields across rows and columns with grouping options.

Discover how to manage Excel pivot table options and layout, including merge and center behavior, display of report filters, handling errors and empty cells, and auto fit and preserve formatting.

Configure pivot table totals and filters, show or hide grand totals for rows and columns, apply multiple filters, and use a to z, z to a, or custom sorting.

Learn how to adjust pivot table display settings, including showing the expand/collapse button, contextual tooltips, and field captions, switch to classic layout, and sort data from a to z.

Learn to configure pivot table printing in Excel, including set print title, repeat row level on each page, and print expand and collapse buttons, with classic pivot table layout.

Explore pivot table data settings, including save source data with file, refresh data when opening, and enable show details for bifurcate reports.

Master pivot table options and settings, including alt text with title and description, and learn how to insert, configure, and document filters, totals, and notes for future memory.

Learn to display the percentage of grand total in a pivot table by using show value as percentage of grand total on the order value field for each sales executive.

Learn to display data in a pivot table as percentage of column total and percentage of row total using sales data, executives, states, and products.

Learn to show value as percentage of a selected state in a pivot table, using Telangana as 100% reference to compare other states' contributions.

Learn to show sales as a percentage of the parent row or column total using pivot tables in Excel, with state and city examples.

Master pivot table techniques to show difference from and percentage difference from, comparing state sales such as Telangana versus Tamil Nadu, Odisha, and West Bengal.

Master how to show value as a running total in a pivot table and view the running total percentage using a cricket score example to illustrate accumulation over overs.

Discover how to rank data in a pivot table without formulas, using show value as rank from smallest to largest or largest to smallest based on sales turnover.

Learn how to use a calculated field in a pivot table to compute a 2% incentive based on sales amounts, and apply a 5% incentive when sales exceed 70 lakhs.

Learn to use calculated items in pivot tables to compute the cancel percentage and total sales (sold plus cancel), with calculations applied at row or column item levels.

Explore pivot table mastery with solve order and list of formulas, learning how calculated items and fields interact to produce accurate percentage of cancel and total sales for food items.

Learn to create and manage sets based on row and column items in an Excel pivot table, including editing, deleting, and adding to the data model to display selective values.

Master using slicers in Excel pivot tables to replace filters, enabling multi-select by state and city for dynamic, user-friendly sales reports.

Insert a timeline in a pivot table to act as an interactive date filter, enabling month, day, quarter, and year views with multi-day selection for sales reports.

Insert an image in Microsoft Excel using the insert tab and illustration options—choose from device, stock images, or online pictures, then resize and place it. The next session covers autoshapes.

Insert and customize shapes in Excel to highlight data, format fill and line colors, adjust arrows, and use shape categories like lines and callouts for clear visuals.

Discover how to insert icons, cutout people, stickers, illustrations, and cartoon people in Microsoft Excel, using insert illustrations icons, then resize and place visuals to enhance charts.

Insert 3D models in Microsoft Excel using the insert 3D model option, and explore stock animated options such as dog, space image, aeroplane, and bicycle.

Master SmartArt in Excel to summarize data and visualize it with layouts, colors, and social media themed examples like Facebook, Instagram, and YouTube.

Learn to insert screenshots quickly into a spreadsheet by using the insert tab, illustration, and screenshot tools, selecting the desired screen or screen clipping to paste and save time.

Learn to create and customize pivot charts in Excel from pivot tables, display state, city, product sales, and switch chart types with legends.

Learn to create a pivot chart from a fashion sales dataset, place product on axis and sales amount as value, then convert to a pie chart and adjust options.

Learn to present quarterly sales turnover with a 3D pie chart in a pivot chart, including exploding slices and centering percentage labels.

Demonstrates using slicers in pivot charts to filter data by state and city, replacing not user friendly filters, and configuring multiple slicers for state, city, and product for interactive insights.

Learn to insert a timeline in a pivot chart to analyze sales by day, month, quarter, or year, configure timeline controls, and troubleshoot date formats.

Insert sparklines in Excel to visualize data in a cell with line, column, and win-loss formats; customize colors and markers for high, low, first, and last points, and edit ranges.