Explore Excel on Experts Exchange

Expert Solutions for Your Tech Problems

ExcelMicrosoft Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user int...

Read more
  • 144K Content
  • 12K Contributors

Expert Spotlight
Visio MVP, Consultant, Trainer, Author, and Developer

Visio enthusiast, teacher, and MVP. Co-inventor of TaskMap: process mapping for the rest of us. Avid cyclist. Father of two daughters.

Troubleshooting Solution

Excel Zone Expert Discussion, Number 33

353
This thread is for general discussion about all things related to the Excel zone and its experts. …
Article

How to quickly and accurately populate Word documents with Excel data, charts, and images (including Automated Bookmark generation)

33
How to quickly and accurately populate Word documents with Excel data, charts and images
Video
Post

The Course of the Month for May: Comp TIA A+!  Prepare for …

The Course of the Month for May: Comp TIA A+!
Prepare for the 220-901 & 220-902 exams in the month…
Advice Solution

Mathematically determine the length and width of board required to make a box

27

I am looking for a way to mathematically determine the outer length and width of board required to

Article

Getting your EE Ranking statistics in Excel

byQlemo
90
The code described here does no longer work. Please see replacement Article:
Article

Six Reasons Why Your VLOOKUP or HLOOKUP Formula Does Not Work

21
by Patrick G. Matthews


Introduction

VLOOKUP is a tremendously useful function …
Troubleshooting Solution

Macro to segregate space tab separated fields - meeting specific text condition

60

Dear experts,

 

[For the purpose of this explanation, let me say when I open the file with file type

Article
Generate a flowchart from Excel data

Generate Visio flowcharts and swimlane diagrams from data

The Data Visualizer (DV) add-in for Excel provides a powerful, fast way to build flowcharts and swimlane diagrams from data. And you don’t even need a Visio license to make this magic happen!
Article
Org data and org chart in Excel

Generate and update Org Charts automatically in Visio

For decades, the Visio org chart wizard has generated diagrams from data automatically. But all subsequent changes were manual and required recreating the diagram. The Visio Data Visualizer changes the game -- you can either change the data or the diagram and then update the other with one click.
Article
Oh no

A Guide to Writing Understandable and Maintainable VBA Code

14
This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
Post

Once upon a time at a core conference this …

1
Once upon a time at a core conference this
Troubleshooting Solution

Excel VBA

23

I have a spreadsheet with a number of columns and rows as an exported set of values

I need to carry

Troubleshooting Solution

Amendment of MAcro to include the filename from where the records has been copied and pasted

31

Dear experts,


Below is a macro which was put together to perform the operation of putting all files

Article

Creating a custom Welcome form in Excel

Not too long ago I wrote this article on doing the same thing in MS Access (https://www.experts-exchange.com/articles/38421/Making-your-Database-More-User-Friendly.html). I found that a similar "Welcome" screen makes Excel worksheets "friendlier" as well.
Post

New member today got a solution today.  After searching …

New member today got a solution today.

After searching the net for help it became apparent
Article

Collating worksheets from one or more workbooks into a summary file

byDave
29
IntroductionOne of the more common requests in the online VBA forums is for code that …
Video
Post

Helen Feddema is one of our resident Microsoft Access …

Helen Feddema is one of our resident Microsoft Access experts.  She just published two new articles …
Video

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more