Advanced Excel Guides
Deep-dive tutorials for users who want more than the basics, from complex formulas to higher-leverage spreadsheet workflows.
16 articles
The Karpathy Loop for Excel: How Autoresearch Changes the Way We Optimize Spreadsheets
Learn how Karpathy's autoresearch pattern — the AI experiment loop that ran 700 tests in two days — applies to Excel formula optimization, VBA macros, and AI-assisted spreadsheet workflows....
AI in Excel: Practical Guide to Copilot, ChatGPT, Claude, and Gemini
Learn how to use AI in Excel with Copilot, ChatGPT, Claude, and Gemini. Compare strengths, limitations, use cases, and how to verify AI-generated formulas, analysis, and automation....
Ready, Set, Scatter: How to Make a Scatter Plot in Excel
This article consists of all the basics of how to make a scatter plot in Excel. By using the guide, readers will be able to generate their own plots as well as format them and add design features....
How to Alphabetize in Excel: Fast & Simple
Using Excel we can properly organize data for our businesses or personal finances. Learn how to alphabetize in excel so it is easy to read and refer back to whenever necessary....
The Drop Down Basics: How to Make a Drop Down List in Excel
This article shows you how to make a drop down list in excel. It provides two ways for you to quickly and easily make dropdown lists in an Excel spreadsheet. You can follow the instructions to create a new dropdown list...
Check the Analysis ToolPak Add-In in Excel 2003 [VBA Code]
This VBA code checks to see if the Analysis TookPak Add-In is installed in Excel 2003 when the file is opened, and will notify the user if not....
Select a Column of Non-Sequential Data
This macro will select a column of non-sequential data when the active cell is located in the column heading....
Microsoft Query Incompatible with Mac OS X Lion [Updated]
Excel for Mac users should beware, Microsoft Query is an incompatible app in the upcoming Lion upgrade for Mac OS X....
International Short Date Formatting for the TEXT Function
A quick method to automatically give the TEXT function a short date format that matches the computers region settings by using some VBA code in Excel....
Select One Column of Data with VBA
Select one column of data in a table by using some simple VBA code and a Form button....
The Table Address and Structured Data in Excel
Structured data in Tables include #All, #Data, #Headers, #Totals, and @ which are available in formulas to reference different parts of the Table....
Speeding up VBA with the PrintCommunication Property in Excel 2010
Excel 2010's PrintCommunication property in VBA suspends communication with the printer while the code for PageSetup runs, making the code faster....
Automatically Expand a Named Range in Excel
Automatically expand the name reference of a data table when a user adds more data by using the sheet deactivate routine to call a simple subroutine....
Calculate the Xth Weekday of Any Month in Excel
A simple formula to calculate the Xth Day of any month using four inputs: Year, Month, Week, and Day. Data validation with custom formatting required....
Single-Cell Array Formula in Excel
The Evaluate Formula dialog box shows interim calculations for single-cell array formulas to reveal array values Excel holds in internal memory....
Hide or Show Names in Excel with VBA
Names can be hidden or shown in Excel with some simple VBA code....
About Excel Semi Pro
Since 2010, we have been helping people improve their Excel skills. Here, you will find beginner and intermediate tips on navigating spreadsheets to achieve results.
Read more about us