Learn Advance Microsoft Excel With AI Mentor M

Welcome to Interactive Excel Lessons

This application brings advanced Excel concepts to life. Select a lesson from the navigation to begin your journey. You'll find interactive examples and visualizations that help make complex topics easier to understand. The goal is to move beyond static text and learn by doing.

Lesson 1: Advanced Formulas

This section explores powerful formula combinations that provide more flexibility than common functions like VLOOKUP. The star of the show is the INDEX and MATCH combination, which allows for dynamic, two-way lookups that are less prone to errors when your worksheet structure changes.

Interactive: INDEX & MATCH

Here we have a table of product data. We want to find the price of the "Monitor". Unlike VLOOKUP, INDEX/MATCH doesn't care which column the lookup value is in. Click the button to see the formula in action.

Product ID	Product Name	Category	Price
P001	Laptop	Electronics	1200
P002	Mouse	Electronics	25
P003	Keyboard	Electronics	75
P004	Monitor	Electronics	300

Formula:

=INDEX(D2:D5, MATCH("Monitor", B2:B5, 0))

Array Formulas (CSE Formulas)

Array formulas perform calculations on ranges of cells, returning either a single result or multiple results. They are special because you must enter them by pressing `Ctrl + Shift + Enter` in Excel, which tells Excel to treat them as an array formula. Excel then automatically adds curly braces `{}` around the formula.

Here's a common use case: summing values based on multiple criteria without needing helper columns. This is incredibly efficient for complex filtering and aggregation.

Region	Product	Sales Amount
East	Laptop	500
West	Mouse	20
East	Monitor	300
South	Laptop	450
East	Laptop	700

Example: Summing Sales for "East" Region and "Laptop" Product

=SUM(IF((B2:B6="East")*(C2:C6="Laptop"), D2:D6))

When you enter this with `Ctrl + Shift + Enter`, it will calculate `500 + 700 = 1200`.

Lesson 2: Data Tools

This lesson focuses on two critical data management features: **Data Validation** for maintaining data integrity and **Conditional Formatting** for visual data insights. These tools empower you to control input and highlight important information without manual effort, streamlining your Excel workflows and ensuring data quality.

Interactive: Conditional Formatting

Below is a project status table. We want to quickly identify any projects that are "At Risk". Click the button to apply a formatting rule that highlights the entire row for any at-risk project. This mimics how Excel uses a formula (`=$B2="At Risk"`) to determine which rows to format, automatically applying a visual cue to draw your attention.

Project ID	Status	Due Date
P101	In Progress	2025-07-15
P102	Completed	2025-06-01
P103	At Risk	2025-06-30
P104	On Hold	2025-08-01

Data Validation: Unique Entries

Beyond simple lists, Data Validation can use custom formulas to enforce complex rules. A common requirement is to ensure unique entries in a column, such as Employee IDs or Invoice Numbers. This prevents duplicate data and maintains data integrity.

Employee ID	Employee Name
EMP001	Alice Johnson
EMP002	Bob Williams
EMP001	Duplicate Entry!

Data Validation Formula (Applied to B2 and copied down):

=COUNTIF($B:$B,B2)=1

This formula checks if the count of the value in the current cell (`B2`) within the entire column (`$B:$B`) is exactly 1. If it's greater than 1, meaning a duplicate exists, Excel will prevent the entry (or show a warning, depending on settings).

Lesson 3: PivotTables

PivotTables are an indispensable tool in Excel for summarizing, analyzing, exploring, and presenting large datasets. They allow you to quickly transform raw data into meaningful insights. This lesson introduces advanced PivotTable techniques, focusing on how Slicers provide intuitive filtering, making your data exploration dynamic and user-friendly.

Interactive: Slicers

Imagine the table below is a PivotTable summarizing sales data. Slicers allow you to filter data interactively. Use the slicer buttons to filter the summary by region and see how the descriptive text changes, mimicking a real Excel Slicer experience.

Date	Region	Product Category	Revenue ($)
2025-01-05	East	Electronics	2400
2025-01-07	West	Apparel	150
2025-01-08	East	Electronics	125
2025-01-10	South	Apparel	180
2025-01-12	West	Electronics	75

Summary:

Total revenue across all regions is $2,930. The Electronics category contributed $2,600 and Apparel contributed $330.

Calculated Fields in PivotTables

Calculated Fields allow you to create new values within your PivotTable that aren't directly present in your source data. For example, if you have 'Revenue' and 'Cost' columns, you can create a 'Profit' calculated field. This capability is incredibly useful for expanding your analysis without modifying the original dataset.

Example: Defining a 'Profit' Calculated Field

Profit = 'Revenue ($)' - 'Cost ($)'

This formula, defined within the PivotTable's calculated field settings, will compute the profit for each row or aggregated group based on the underlying data. It acts just like a regular field, allowing you to drag and drop it into rows, columns, or values areas of your PivotTable.

Lesson 4: What-If Analysis

Excel's What-If Analysis tools help you explore various scenarios by changing input values to see how they affect outcomes. This is crucial for planning, forecasting, and decision-making. Key tools include Goal Seek, Scenario Manager, and Data Tables, each offering a unique way to model different possibilities.

Goal Seek: Finding the Right Input

Goal Seek allows you to find the input value needed to achieve a specific target result for a formula. Instead of trial-and-error, Excel calculates the exact input required. It's like working backward from a desired outcome.

Parameter	Value
Loan Amount	$100,000
Interest Rate	5%
Loan Term (Years)	10
Monthly Payment (Calculated)	$1,060.66
Desired Monthly Payment	$1,000.00

Goal Seek Configuration:

**Set cell:** Cell containing "$1,060.66" (Monthly Payment)
**To value:** "$1,000.00"
**By changing cell:** Cell containing "$100,000" (Loan Amount)

When you run Goal Seek, Excel will adjust the Loan Amount until the Monthly Payment reaches exactly $1,000.00, telling you the maximum loan you can afford for that payment.

Scenario Manager: Comparing Multiple Outcomes

The Scenario Manager lets you store and switch between different sets of input values (scenarios) for a model. This is perfect for comparing "Best Case," "Worst Case," and "Most Likely" scenarios for budgets, sales forecasts, or project costs.

Expense Item	Best Case	Most Likely	Worst Case
Salaries	$45,000	$50,000	$55,000
Materials	$18,000	$20,000	$25,000
Marketing	$8,000	$10,000	$15,000
Total Expenses	$71,000	$80,000	$95,000

With Scenario Manager, you can easily switch between these predefined scenarios to see the impact on your total expenses without manually changing each input value.

Lesson 5: Introduction to Macros & VBA

Visual Basic for Applications (VBA) allows you to automate almost any repetitive task in Excel. By writing scripts called "macros," you can perform a series of actions—like formatting a report, cleaning data, or generating summaries—with a single click. This saves time and ensures consistency. This lesson gives you a glimpse into the power of VBA, showing a practical example of automating formatting.

Example: Automated Formatting Macro

The VBA code below is a simple macro that takes a raw data range, applies bold formatting to the headers, sets a background color, adds borders, and autofits the columns. This is a common task when preparing a report for presentation. Use the button to copy the code for your own use directly from this page.

Region	Product	Sales Rep	Sales Amount
East	Laptop	John	1200
West	Mouse	Sarah	30
North	Keyboard	David	75
South	Monitor	Emily	300
East	Tablet	John	600

Sub FormatSalesData()
    ' This macro formats a specific range of cells.
    ' Selects the range A1:D10 relative to the active sheet
    With ActiveSheet.Range("A1:D10")
        ' Applies bold formatting to the font
        .Font.Bold = True
        ' Sets the interior fill color to a light blue shade
        .Interior.Color = RGB(220, 240, 250)
        ' Autofits the columns within the selected range to fit content
        .Columns.AutoFit
        ' Adds continuous, thin black borders to all cells in the range
        With .Borders
            .LineStyle = xlContinuous
            .Weight = xlThin
            .Color = RGB(0, 0, 0)
        End With
    End With
    ' Displays a message box to confirm the action
    MsgBox "Sales data formatted successfully!", vbInformation
End Sub

After copying, you can paste this code into a VBA module in your Excel workbook (`Alt + F11` to open the VBA Editor, then `Insert > Module`). You can then run this macro whenever you need to apply this specific formatting.

Lesson 6: Power Query (Get & Transform Data)

Power Query, also known as Get & Transform Data, is Excel's powerful ETL (Extract, Transform, Load) tool. It allows you to connect to, clean, transform, and combine data from virtually any source. This eliminates the need for manual data manipulation, ensuring your analysis is based on clean, consistent data.

Key Capabilities and Common Transformations

Power Query's strength lies in its intuitive user interface (the Power Query Editor) where you apply transformations, and it automatically records the steps. This makes your data preparation repeatable and auditable.

1. Connecting to Data Sources:

You can import data from Excel files, CSVs, databases (SQL, Access), web pages, SharePoint, and many more. Power Query ensures a robust connection that can be refreshed as source data updates.

2. Appending Queries:

This combines rows from multiple tables into a single, larger table. This is incredibly useful when you have data split across several files or sheets, such as monthly sales reports.

Table: Sales_Q1

Product	Sales (Jan)
A	100
B	150

Table: Sales_Q2

Product	Sales (Apr)
A	120
C	80

After appending, you would get a consolidated table with all rows from both quarters.

3. Merging Queries:

This combines columns from two tables based on a common key, similar to a database JOIN. Useful for enriching your main dataset with lookup information (e.g., adding product details to a sales transaction table).

Table: Orders

OrderID	ProductID	Quantity
1	P001	5
2	P002	3

Table: Product_Info

ProductID	Price
P001	10
P002	20

Merging these two tables on `ProductID` would add the `Price` column to your `Orders` table, allowing you to calculate `Total Price = Quantity * Price`.

4. Other Common Transformations:

**Changing Data Types:** Ensuring numbers are numbers, dates are dates.
**Splitting/Merging Columns:** Separating "First Name, Last Name" or combining "City, State."
**Pivoting/Unpivoting:** Reshaping data from wide to long formats, or vice-versa, essential for different types of analysis.
**Adding Custom Columns:** Creating new columns using a simple formula language (M-language).

Lesson 7: Power Pivot & DAX

Power Pivot is an Excel add-in that allows you to perform powerful data analysis and create sophisticated data models, especially with large datasets (millions of rows). It enables you to define relationships between tables, much like a relational database. DAX (Data Analysis Expressions) is the formula language used within Power Pivot to create advanced calculations (measures and calculated columns).

Building a Data Model: Relationships

Instead of a single flat table, Power Pivot lets you build a 'star schema' or similar data model by linking multiple tables. This is efficient for large datasets and complex reporting. Below are examples of a 'Fact Table' (transactions) and a 'Dimension Table' (lookup data) that you would connect.

Table: Sales (Fact Table)

SaleID	ProductID	Revenue
101	P001	500
102	P002	200
103	P001	750

Table: Products (Dimension Table)

ProductID	ProductName	Category
P001	Laptop	Electronics
P002	Keyboard	Electronics

In Power Pivot, you would create a **relationship** between `Sales[ProductID]` and `Products[ProductID]`. This link allows you to analyze Sales data by Product Category, even though the Category is only in the Products table.

DAX: Calculated Columns vs. Measures

DAX formulas are used to extend your data model with custom calculations.

1. Calculated Columns:

These are new columns added to a table in your data model, calculated row by row. They consume memory and can be used directly in PivotTables, but are best for static, pre-calculated values.

Sales[Profit] = Sales[Revenue] - RELATED(Products[Cost])

This formula calculates profit for each sales row by pulling `Cost` from the `Products` table using the `RELATED` function based on the established relationship.

2. Measures:

Measures are dynamic calculations that aggregate data based on the current filter context in a PivotTable. They do not store values in the data model, making them very efficient for complex aggregations and KPIs.

Total Revenue := SUM(Sales[Revenue])

This measure sums the `Revenue` column. When dragged into a PivotTable, it automatically calculates the total revenue for the specific products, regions, or dates you've filtered or grouped by.

Lesson 8: Advanced Charting

Making your data speak effectively through visualizations is a cornerstone of advanced Excel. This lesson focuses on custom and dynamic charting techniques that go beyond basic representations, ensuring your data stories are compelling and interactive. The goal is to move from static charts to engaging, explorable data presentations.

Interactive: Dynamic Combo Chart

The chart below displays monthly sales revenue (bars) and the sales target (line). This "Combo Chart" is excellent for comparing two different types of data on the same visual. Use the checkboxes to dynamically show or hide each data series. This interaction highlights how users can explore different aspects of your data directly within the chart, mimicking dynamic dashboard elements in Excel.

Show Sales Revenue Show Sales Target

Sparklines: Charts in a Cell

Sparklines are tiny charts placed within a single worksheet cell, providing a quick, at-a-glance visual representation of data trends, such as seasonal increases or decreases, without consuming much space. They are perfect for dashboards where you need many quick insights.

Department	Q1	Q2	Q3	Q4	Trend
Sales	120	130	150	140	📈
Marketing	80	85	90	75	📉
Operations	100	105	102	110	📈

In Excel, the "Trend" column would contain actual sparklines generated from the quarterly data. The emojis here are placeholders to demonstrate the concept.

Lesson 9: Power BI Introduction for Excel Users

For serious business intelligence, Power BI Desktop (a free application from Microsoft) takes the capabilities of Excel's Power Pivot, Power Query, and Power View to the next level. It's designed for creating comprehensive, interactive dashboards and reports that can be shared across an organization. Understanding Power BI helps you leverage your Excel data modeling skills for broader impact.

Bridging from Excel to Power BI

Many of the concepts learned in Power Query and Power Pivot are directly transferable to Power BI. Think of Power BI as an evolution, offering more robust data connections, advanced visualization options, and easier sharing/collaboration.

Excel Feature	Power BI Equivalent/Extension
Power Query	Get Data & Transform Data (Query Editor)
Power Pivot	Data Model & Relationships View
PivotTables	Matrix & Table Visuals
DAX	DAX (same language, broader application)
Charts	Vast array of Visualizations
Slicers	Slicers (more interactive options)

Power BI integrates these features into a dedicated environment, allowing for more complex data orchestration and a richer dashboard experience.

Lesson 10: Advanced Data Cleaning Techniques

Clean data is the foundation of accurate analysis. While Power Query handles many basic transformations, advanced scenarios require specific techniques to deal with inconsistencies, missing values, and structural issues. This lesson focuses on methods to truly sanitize your datasets for reliable reporting.

Handling Common Data Messes

Beyond simple 'remove blank rows,' robust data cleaning involves addressing duplicate entries, inconsistent text formatting, numerical values stored as text, and unpivotting complex layouts.

Example: Inconsistent Text Data

Original Region Data	Cleaned Region Data
EAST	East
East	East
east	East
WEST	West
West (CA)	West

Techniques like 'Capitalize Each Word', 'Clean', 'Trim' in Power Query, or using `PROPER`, `TRIM` formulas in Excel can standardize text. For "West (CA)", a 'Replace Values' transformation in Power Query can simplify it to "West".

Example: Dealing with Missing Values (Nulls)

Product Name	Sales Amount
Laptop	1200
Mouse
Keyboard	75
Monitor

Missing values (represented as blanks or 'null' in Power Query) can skew aggregations. You can choose to:

**Remove Rows:** If missing data makes the row unusable.
**Replace with Zero:** For numerical fields where 'no sales' means zero sales.
**Fill Down/Up:** For lookup fields where the value applies to subsequent rows.
**Impute:** Use statistical methods (e.g., average, median) for more sophisticated replacement (often in Power BI or specialized tools).

Lesson 11: Dynamic Reporting with Form Controls

Beyond PivotTable slicers, Excel's Form Controls (like dropdowns, checkboxes, scroll bars, and spin buttons) offer a powerful way to create highly interactive and dynamic reports directly on your worksheets. By linking these controls to cells, you can instantly change data inputs, filter data, or update charts without writing complex VBA.

Creating Interactive Input Fields

Form Controls from the Developer Tab (Insert > Form Controls) provide simple UI elements that link to a specific cell. Changes in the control update the linked cell, and formulas or charts referencing that cell will react dynamically.

Example: Using a Dropdown (Combo Box) for Dynamic Filtering

Imagine you have a sales data table and want users to select a Region to view its specific sales. You would insert a Combo Box control.

Control Property	Setting
Input Range	A list of regions (e.g., East, West, North, South)
Cell Link	A specific cell (e.g., Z1)

When a user selects "East" from the dropdown, cell Z1 would output '1' (its position in the list). You can then use an `INDEX` function or a filter based on Z1 to show data only for "East".

=IF(INDEX(RegionList,Z1)="East", "Show", "Hide")

This can be used in conjunction with conditional formatting to hide/show rows dynamically, or to drive chart data ranges.

Lesson 12: Data Modeling Best Practices

Effective data modeling is crucial for robust and scalable analysis in Power Pivot and Power BI. It involves organizing data into logical structures that enable powerful calculations and efficient querying. This lesson delves into best practices, particularly the 'Star Schema' design, which optimizes performance and simplifies complex analysis.

Understanding Star Schema Design

The Star Schema is the most common and recommended data model design for analytical purposes. It consists of a central **Fact Table** surrounded by multiple **Dimension Tables**, like points of a star.

Key Components:

**Fact Table:** Contains quantitative data (measures) and foreign keys to dimension tables. It's typically long and narrow (many rows, few columns).
**Dimension Tables:** Contain descriptive attributes (text, dates, categories) related to the fact table. They are typically short and wide (fewer rows, many columns).

Example: Sales Data in a Star Schema

Fact Table: Sales

OrderID	DateID	ProdID	CustID	Quantity	Revenue
1	D001	P001	C001	2	2400
2	D002	P002	C002	5	125

Dimension Table: DimDate

DateID	Date	Year	MonthName
D001	2024-01-10	2024	January
D002	2024-01-11	2024	January

Dimension Table: DimProduct

ProdID	ProductName	Category
P001	Laptop	Electronics
P002	Mouse	Electronics

Relationships are created between the Fact table's foreign keys and the Dimension tables' primary keys (e.g., `Sales[DateID]` to `DimDate[DateID]`). This structure allows filtering and analysis by any attribute in the dimension tables, while keeping the main sales data efficient.

Lesson 13: Introduction to Power Automate (Flow) for Excel

Power Automate (formerly Microsoft Flow) is a cloud-based service that helps you create automated workflows between your favorite apps and services to synchronize files, get notifications, collect data, and more. For Excel users, it's a game-changer for automating tasks that might otherwise require manual intervention or complex VBA across different platforms.

Automating Excel Workflows

While VBA automates tasks *within* Excel, Power Automate automates tasks *around* Excel. This means connecting Excel to emails, SharePoint, Microsoft Forms, databases, and other cloud services. It's low-code, often requiring no programming knowledge.

Example: Automating a Report Generation and Distribution

Imagine you need to: 1) Get new data from a SharePoint folder, 2) Refresh an Excel workbook, 3) Convert it to PDF, and 4) Email it to a distribution list every Monday morning. Power Automate can do this for you.

Step in Power Automate	Description
Trigger: Recurrence	Set to run every Monday at 8 AM.
Action: Get file content from SharePoint	Retrieves the latest data file.
Action: Run script (Excel Online)	Refreshes data in a linked Excel file (requires Excel Online Business).
Action: Convert file (OneDrive/SharePoint)	Converts the refreshed Excel file to PDF.
Action: Send an email (Outlook)	Attaches the PDF and sends it to recipients.

This flow dramatically reduces manual effort and ensures timely, consistent report distribution without you having to open Excel.

Lesson 14: Advanced Charting: Conditional Charts & Infographics

Taking charting to the next level involves creating visuals that adapt to your data's story or integrate infographic elements for a more engaging impact. This lesson explores techniques to build charts that dynamically highlight important thresholds or use visual metaphors to convey meaning more intuitively.

Conditional Charts: Highlighting Performance

A conditional chart changes its appearance (e.g., color) based on certain criteria. For example, a bar chart where bars turn green if they meet a target and red if they don't. This uses helper columns and careful data structuring to achieve dynamic coloring.

Example: Sales vs. Target (Bars with Conditional Coloring)

Month	Sales	Target	Sales (Achieved)	Sales (Missed)
Jan	90	100		90
Feb	110	100	110
Mar	95	100		95

In Excel, you would create two 'Sales' series: one for `Sales (Achieved)` (`=IF(Sales>=Target,Sales,NA())`) and one for `Sales (Missed)` (`=IF(Sales

Infographic Elements in Charts

Infographic charts integrate visual icons or shapes to represent data, making them more visually appealing and easier to interpret quickly. While complex infographic charts might require specialized tools, Excel allows for simple versions using careful formatting.

Example: Progress Bar in a Cell

Task	Progress %	Visual Progress
Project Alpha	70%	███████░░░
Project Beta	30%	███░░░░░░░

This can be created using a formula like `=REPT("█", A2/10) & REPT("░", 10 - (A2/10))` combined with a monospace font. More advanced versions use conditional formatting data bars and clever alignment to fill shapes.

Lesson 15: Excel Security and Sharing Best Practices

Ensuring the security and integrity of your Excel workbooks is paramount, especially when sharing sensitive data or complex models. This lesson covers essential best practices for protecting your worksheets, workbook structure, and VBA code, as well as considerations for sharing files effectively and securely.

Protecting Your Workbook and Data

Excel offers various levels of protection to prevent unauthorized changes, accidental deletions, or viewing of hidden information.

Key Protection Methods:

**Protect Sheet:** Restricts users from making changes to locked cells, inserting/deleting rows/columns, or using filters. You can specify which actions users are allowed to perform.
- **Example:** Allow users to sort and use AutoFilter, but not edit cells.
**Protect Workbook Structure:** Prevents users from adding, deleting, moving, or renaming worksheets within the workbook. Essential for maintaining the integrity of multi-sheet reports.
**Encrypt with Password:** Encrypts the entire workbook, requiring a password to open it. This is the strongest form of protection against unauthorized access to the file itself.
**Protect VBA Project:** Prevents others from viewing or modifying your VBA code in the Visual Basic Editor. Crucial for proprietary macros.

Sharing Best Practices

When sharing Excel files, consider both security and usability.

**Share Read-Only:** For users who only need to view data, saving as 'Read-Only Recommended' or sharing via cloud services with 'view only' permissions.
**Remove Personal Information:** Before sharing, inspect the workbook for hidden rows/columns, sheets, personal information, or unused formulas using the Document Inspector (`File > Info > Check for Issues > Inspect Document`).
**Use Excel for the web/Cloud Services:** Share via OneDrive or SharePoint for version control, collaborative editing, and granular permission settings, reducing the need to email attachments.
**Provide Instructions:** Clearly explain what users can and cannot do in the workbook.

Lesson 16: Performance Optimization in Excel

Large and complex Excel workbooks can become slow and unresponsive. Optimizing performance is crucial for maintaining productivity and a smooth user experience. This lesson covers key strategies, from formula design to data management, to speed up your Excel files.

Formula Efficiency

Inefficient formulas are a primary cause of slow workbooks. Optimizing them can lead to significant improvements.

**Avoid Volatile Functions:** Functions like `NOW()`, `TODAY()`, `OFFSET()`, `INDIRECT()`, `RAND()` recalculate every time any change is made in the workbook, causing performance bottlenecks. Use them sparingly.
**Alternative for `OFFSET`/`INDIRECT`:** Use `INDEX`/`MATCH` or structured references. These are non-volatile.
**Limit Array Formulas:** While powerful, large array formulas can be very resource-intensive. Convert them to helper columns, Power Query, or Power Pivot measures when possible.
**Use Table References:** Referencing entire columns (`A:A`) is inefficient. Convert your data into Excel Tables (`Ctrl + T`) and use structured references (e.g., `Table1[Sales]`) which only refer to the actual data range.
**Reduce `COUNTIF`/`SUMIF`/`AVERAGEIF` ranges:** Use smaller, specific ranges instead of entire columns if possible.
**Prefer `SUMIFS` over nested `IF` with `SUM`:** `SUMIFS` is highly optimized for multiple criteria.

Data Management and Structure

How your data is organized and managed impacts workbook speed.

**Use Excel Tables:** As mentioned, they improve formula efficiency and make data management easier.
**Convert Unused Formulas to Values:** If a section of your workbook is finalized and doesn't need to dynamically update, copy its formulas and paste them as values.
**Remove Unused Rows/Columns:** Excess formatting or data outside your working range can bloat file size. Delete truly empty rows/columns to the very end of your data (`Ctrl + End` to find last used cell).
**Leverage Power Query & Power Pivot:** For very large datasets or complex transformations, offload them to Power Query (for data cleaning/preparation) and Power Pivot (for data modeling and calculations). These engines are designed for big data and are far more efficient than worksheet formulas.
**Disable Automatic Calculation (Temporarily):** For very large changes, set calculation to manual (`Formulas > Calculation Options > Manual`), make your changes, then force a recalculation (`F9`).

By applying these optimization techniques, you can significantly improve the responsiveness and usability of your advanced Excel workbooks.