Excel VBA - Learn from real case studies and projects

Enable the developer ribbon in Excel, access VBA and the Visual Basic Editor, and customize the ribbon for macro development. Save as an Excel macro-enabled workbook to start VBA projects.

Learn how to use Excel with Visual Basic for Applications and navigate the VBE editor, the project window, and the workbook object to organize and run code.

Explore accessing worksheet properties in Excel VBA, including the name property and sheets count, using the application, workbook, and the worksheet objects to inspect and rename sheets.

Learn to manipulate excel with vba by treating cells and ranges as objects, using the active workbook and sheet, and assigning values such as hello to a range.

Explore the VBA project structure in Excel, learn how workbooks and worksheets are organized as objects, and navigate the editor, project explorer, and properties window.

Explore how worksheet objects expose methods and events, such as selection change and value change, and see how code runs to display messages when values or selections modify a range.

Explore VBA modules as reusable components that hold variables, constants, and functions, enabling library sharing, exporting and importing, and controlling public versus private scope across workbooks.

Learn how Excel interacts with users using forms and how worksheets, workbook, and module objects form a reusable VBA library. Import and export modules to reuse code across sheets.

Explore basic VBA variable types such as integer, long, single, double, and string, and learn to use option explicit to require explicit declarations.

Demonstrate how Excel VBA summarizes product data by IBC and family for each month, using a dictionary and arrays to store totals.

Learn to compute the difference between two dates in Excel vba, determine the months between the start and end dates, and create the necessary worksheets to display the data.

Create and populate a dictionary in Excel VBA, forming keys from bc and date components (month and year), then sum and update amounts across rows.

Learn to build and populate a VBA dictionary with months as keys and arrays of values, add items, iterate over entries, print results, and prepare data for a monthly table.

Learn how to save report data into a dictionary in Excel VBA by creating and using public dictionaries, and manage multiple dictionaries through basic dictionary operations.

Build and populate a one dimensional family dictionary from a worksheet in Excel VBA, using a row loop to create keys, then print and assign the dictionary.

Parametrize and generalize a VBA function by creating and reusing a dictionary in Excel, calling it with different columns and items to build tables.

Learn how to print dictionary values and create per-worksheet tables in Excel using VBA, including dictionary setup, looping through rows and columns, and populating cells.

Learn to format tables in Excel VBA by recording macros, selecting and adjusting ranges, applying gray fills, auto fit columns, and automating report generation across sheets.

Format the headlines of a table by using a separate routine to copy data and include all rows and columns, delivering a more formal reporting style in Excel VBA.

Demonstrates inserting complex Excel formulas into ranges using native formulas, including sum, sumproduct, and array formulas with rc notation to extract July values from MHR data.

Learn to use the formulaArray property in Excel VBA to insert complex array formulas into ranges, looping through rows and columns to compute first and last day of month.

Build and automate a dashboard in excel using vba, with drop-down driven data, date-driven updates, and external data import from an access database to create tables, charts, and graphs.

Add a combobox to a worksheet in Excel VBA, populate it with country options from pre-generated lists, and display related projects on the sheet.

Prepare a metadata file containing the data to export to the new workbook using pre-generated country data and modules for projects in Excel VBA.

Develop a VBA routine to create and assign formulas to table columns, enabling automated date calculations and priority management.

Explore an Excel VBA routine to automatically apply borders and colors to a selected range, with practical steps for formatting and working with range selections.

Learn how to apply a background pattern to a range in Excel VBA, add borders, and trigger formatting with a button while using simple if-then checks to verify results.

Apply and test all our formatting routines to Excel table ranges, including bold styling and conditional formatting, using real case studies and projects.

Learn how to apply conditional formatting to ranges within an Excel table, including setting up rules and changing font color to highlight data.

Create and populate summary tables by generating Excel formulas, configure parameters, and manage date ranges to automate calculations in VBA projects.

Apply format information to the detail table, using borders, colors, and number formats, and perform a practical exercise to format the data.

Learn to generate and format a ticket table on a separate sheet using Excel VBA, with an exercise to turn given data into a table.

Create and run VBA macros to set up data selection fields in the calculation sheet, enabling customized data filtering with modules, constants, and parameterization for dynamic reports.

Generate a calendar in the ticket detail table using Excel VBA by manipulating ranges, worksheets, and formulas, with steps for selecting columns, copying formulas, and verifying dates.

Learn to generate Excel lookup formulas for table ranges using macros and recording techniques, set up ranges, handle max and integer calculations, and format results for reliable data retrieval.

Demonstrate applying conditional formatting to a table's calendar based on dates in Excel VBA, highlighting days within the start date and end date and leaving date outside the calendar uncolored.

Learn Excel VBA through real case studies by completing formulas for the ticket detail table, formatting the grid with borders and colors using macros, and managing ranges, rows, and columns.

Learn to prepare ticket summary tables in Excel using formulas, copy data across columns, define references, apply formatting, and test the resulting table.

Discover how to automatically create and populate Excel VBA tables from master data, detect tables and ranges with a macro, and prepare a dashboard-ready dataset.

Prepare the meta data for export by storing it in a VBA dictionary, organizing a table with columns for later use in the Excel VBA workflow.

Create multi series charts by referencing dynamic named ranges with VBA, building a dashboard, and using the offset function to define data ranges.

Learn how to generate and format charts in Excel VBA by building a reusable routine that sets titles, axes, and series formatting across dashboards.

Learn to assign or modify the chart type of an Excel chart with VBA, enabling dynamic data visualization in Excel.

Learn to format a chart with vba, including axes and titles, through real case studies and projects.