Excel Mastery | Become a Master At Excel From Start to End

Discover the anatomy of a spreadsheet in Excel, including a workbook with worksheets, the ribbon and tabs, and how to edit data in cells using the formula bar.

Learn Excel formulas using the equal sign and basic operators, copy formulas by dragging, use autosum for sum and average with range references, and freeze pane to keep headers visible.

Master essential Excel functions such as average, min, max, and count. Practice building formulas, formatting as currency, and using absolute and relative references with the fill handle.

Master basic formatting in Excel, including fonts, font sizes, cell styles, borders, wrap text, merge and center, and currency or accounting formats, plus format painter and conditional formatting.

Explore sorting and filtering data in Excel, create and customize tables with headers, and use quick sort and custom sort to organize grossing movie data by worldwide and domestic figures.

Create and customize charts in Excel by selecting data ranges and choosing a chart type from recommended options, then edit chart titles, axis titles, gridlines, and legends for clear visualization.

Master data analysis and manipulation in Excel with data validation, pivot tables, basic visualization, and formatting; import csv data, text to columns, and sorting and filtering to summarize sales.

Master data analysis with Excel pivot tables: arrange fields in rows or columns, filter and sort data, switch totals (sum, count, average), and create pivot charts for clear visual insights.

Learn to collaborate in Excel while protecting workbooks, worksheets, and cells, and master printing, exporting to pdf, and print settings for polished, shareable data.

Collaborate in Excel with real-time coauthoring, protect sheets and lock or unlock specific cells, use sheet view to edit without affecting others, and share via OneDrive or SharePoint.

Boost your productivity with essential Excel keyboard shortcuts for Mac and Windows. Learn to create tables, navigate data, format cells, perform quick sums, and master Flash Fill patterns.

Discover efficiency tricks in Excel, from flash fill and proper case to free add-ins like QR code, Wikipedia, Bing Maps, and date pickers for faster data entry.

Learn to link data across multiple sheets and apply advanced formulas like Vlookup, H lookup, and index match to pull data across workbooks.

Explore advanced Excel concepts by using vlookup with exact and approximate matches, named ranges, and table arrays; master match, index, and nested if for data lookup and decision making.

Learn to automate repetitive data formatting in Excel with macros, including enabling the developer tab, recording a macro, and applying it to format customer data.

Apply your Excel skills to build an employee payroll in a spreadsheet, computing pay with hours worked and hourly wages, using min, max, average, sum, and overtime formulas.

Develop a gradebook in Excel to compile scores from multiple tests, calculate percentages, and use conditional formatting and the or function to flag failing employees in the final module.

Explore advanced Excel functions like Vlookup, Hlookup, index, match, and if to perform cross-sheet lookups, exact versus approximate matching, and nested conditional logic for data analysis and automation.

Explore data validation and conditional formatting in Excel to prevent invalid entries, highlight trends, and enforce rules with examples like future dates, dependent values, numeric constraints, and length checks.

Explore pivot tables to quickly summarize and analyze large data sets, turning raw data into actionable insights with dynamic fields, filters, and pivot charts.

Master data filtering and sorting in Excel to extract key information and reveal trends. Use quick sort, custom sort, and multi-level filters to organize data by headers and numeric criteria.

Learn to sort Excel data by multiple criteria and apply basic, advanced filtering, including criteria ranges and copying results to another location, for targeted analysis.

Master dynamic and interactive charts in Excel by building a data-driven chart with a slider that updates years, data, and the chart title for a clear visual story.

Explore advanced charting in Excel to create trend lines, forecast data, and sparklines for dynamic, insightful visualizations.

Master advanced data visualization techniques in Excel, including data bars, heatmaps, color scales, and icon sets via conditional formatting, and create dynamic dashboards with pivot tables and charts.

Master advanced data visualization in Excel with pivot charts, slicers, and timelines to build interactive dashboards, refresh data, and apply conditional formatting, data bars, and heat maps.

Automate repetitive tasks in Excel using macros and VBA, recording macros, using the developer tab, and applying text to columns, conditional formatting, and macro-enabled workbooks.

Learn to automate tasks in Excel using macros and VBA, create efficient workflows, and master error handling and debugging with practical macro recording and input box examples.

Explore conditional logic and nested if statements in Excel, using if statements and logical functions to assign letter grades from exam scores.

Explore Excel's Analysis ToolPak for statistical analysis, installing the data analysis add-in to run descriptive statistics and regression analysis with flexible output options.

Explore what-if analysis and scenario planning in Excel using Scenario Manager and Goal Seek to model December sales, set targets, and compare optimistic, current, and worst-case scenarios.

Explore Power Query and Power Pivot in Excel to import, clean, transform, and load data from multiple sources, build robust data models, and perform advanced analysis.

Master advanced data visualization and analysis in Excel using Power Pivot, conditional formatting with data bars and heatmaps, and dynamic dashboards built from pivot tables and charts.

Master advanced data analysis with power pivot using DAX measures, distinct count, and related tables to compute amount owed and average GPA, build pivot tables and charts, and add slicers.

Learn to share and co-author Excel workbooks in real time with sheet view, comments, and changes tracking using OneDrive or SharePoint.

Protect Excel workbooks and worksheets with passwords and read-only modes, unlock specific cells, and safeguard data while printing to pdf.

Explore customizing Excel with add-ins and advanced settings to boost productivity, from QR generation and Wikipedia integration to Bing Maps, video playback, calendars, and colorization.

apply advanced Excel techniques to real-world business and financial problems by building a bike sales dashboard from scratch, cleaning data, creating age brackets, and using dynamic charts and filters.

Develop advanced reporting skills with pivot tables and pivot charts to build dynamic dashboards that visualize gender, income, commute distance, and age brackets.

Learn to plan, clean, analyze, and visualize data in Excel, then build a city-filtered dashboard and pivot table, and present findings for feedback.

Present your Excel analyses with a clear structure, consistent design, and effective communication using visuals and storytelling, and embrace feedback from instructors and peers.

Learn to use chatgpt to create excel formulas for sum and if, then apply vlookup, sumif, and countif to compute profits, salaries, and grade maximum checks.

Learn to use left, right, datediff, and networkdays functions in Excel with ChatGPT guidance, including extracting names, calculating ages, and computing working days.

Extract names from email addresses and apply vlookup in Excel to fill staff data. Generate formulas with ChatGPT to look up bonuses and managers for each employee.

Learn how to use sumif and countif in Excel with ChatGPT prompts to sum salaries by criteria, count occurrences, identify duplicates, and compute unique counts for clean data.

Explore using ChatGPT to generate and apply Excel formulas for real-world data, including sum, count, countif, sumif, and sumifs across departments like digital skills and months like June.

Explore advanced Excel techniques with ChatGPT, including creating a word-count formula using substitute, trim, and Len, and apply data validation and conditional formatting for range A1:C100.

Learn to build complex excel formulas with nested ifs and and/or logic using ChatGPT, applying ceiling and visibility rules to classify VFR and IFR. Also automate PDF reports with VBA.

Bring AI into Excel by embedding ChatGPT queries in a cell and retrieving answers on a results worksheet, then apply it to generate itineraries, sample data, and balance sheet analysis.