Microsoft Excel Fast Track: From Zero to Hero in 360 Minutes

Learn to set up and rename Excel sheets, and design a visionary electronics logo using fonts, colors, orientation, icons, and 3D models, with shapes and shadows.

learn to generate a months list with the fill function, apply a 50-unit monthly increase to units sold, and compute total, average, count, max, and min with formulas.

Explore cell basics and data analysis in Excel with task 2. Learn to locate cells and compute totals, averages, max, min, and counts above 500 using countif and if.

Convert a horizontal table to vertical format using transpose and paste special values. Name the range pay method, then sort by IDs and filter to pay 001 to pay 005.

Master data manipulation in Excel by transposing data, autofitting columns, converting ranges to tables, sorting and filtering by product IDs, and adding a form to the Quick Access toolbar.

Master data formatting and customization in Excel by converting ranges to tables, applying autofit, setting currency with no decimals, and using custom formatting for warranty and refresh rate.

Master relative, absolute, and mixed cell references in Excel, learn how dragging formulas changes them, and apply dollar signs to fix columns or rows.

Use vlookup to retrieve category data from a category sheet by linking with product IDs. Build the exact-match lookup with an absolute-reference table to ensure correct results when dragging down.

Organize data in Excel by resizing auto fit columns, importing external data, appending tables with identical structure, and creating, renaming, moving, coloring, and hiding sheets for a clean, consolidated workbook.

Apply advanced functions in Microsoft Excel, including if, isnumber, and search, with relative referencing and fill techniques, to validate scores and build a check email column on the customer sheet.

Task nine on customer feedback sheet: resize, convert to table, apply conditional formatting for ratings below three, use flash fill, and build dynamic reviews with choose function and absolute referencing.

Autofit column width, convert range to table, and set supplier data validation drop-downs in inventory sheet; use vlookup and ifs to fetch reorder points and apply conditional formatting for reorders.

Learn to calculate years of experience with yearfrac and datediff using today, test multiple conditions with and, and apply conditional formatting to flag promotion due and low job satisfaction.

Learn to clean data and extract date components by resizing columns, converting ranges to tables, and using advanced date functions to compute year and quarter, with trim for clean identifiers.

Learn to use index and match to pull product names and technology from the product sheet, combine with vlookup for country and buyer type, and freeze panes.

Master sumifs with ifs to calculate yearly revenue from 2020–2024 using data from the order sheet, then add sparklines and generate a forecast sheet with currency formatting.

Create pivot tables from the order sheet to analyze sales by year, quarter, and product type, plus net profit by year, with a linked table for a country map chart.

Add charts and a map to the dashboard, resize to fit rounded corners, and remove fill, borders, and axis lines. Apply style 3 and style 13.

Create a responsive Excel dashboard by adding a slicer for buyer type in three columns and a timeline filtered by quarters, linking all pivot charts via report connections.

Master advanced excel formulas by applying edate to shift dates by a year, compute monthly loan payments with pmt, and determine investment returns with xirr.

Learn to automate excel tasks with vba macros, generate random purchases using randbetween, format and copy data to a top customers sheet, and save as a macro-enabled workbook.

Explore Visual Basic for Excel by writing VBA code in the Visual Basic Editor, creating modules and sub procedures, and building a clear sheet macro using the cells.clearContents method.

Create a second VBA sub procedure that prompts for a name with an input box and displays a time-based greeting in a message box, using current hour logic.

Explore how AI and ChatGPT boost Excel productivity by generating task-specific formulas and prompts, including DATEDIF, email validation, and SUMIFS for product-region sales.

Demonstrates building a total cost calculator in Excel with VBA: generate a total cost function via ChatGPT, then implement a custom my total cost function using price, quantity, and discount.

Clean and transform data with Power Query Editor by removing bottom rows, cleaning symbols, adding a total medal count, sorting, and formatting to uppercase, then load into a new worksheet.

Remove duplicate country names from the Olympic 2024 sheet, then create three country-wise pivot tables for gold, silver, and bronze, and link the top seven countries for charts.

Learn to create funnel, treemap, and sunburst charts in Excel using the fast track approach, including chart formatting, titles, and data labels to display country medal tallies.

Create your own Excel dashboard for the Olympics project by building charts for gold, silver, and bronze, using a country slicer with pivot tables, and removing grand totals.

Learn to create data relationships across Excel sheets using a data model and a foreign key. Build a pivot table from orders and customers to analyze sales without vlookup.