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
Finance Analyst

30 years in Financial Services and Management Accounting. CIMA trained but prefer the technical or system aspects of accounting.

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…
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

Getting your EE Ranking statistics in Excel

byQlemo
90
The code described here does no longer work. Please see replacement Article:
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.
Article

Six Reasons Why Your VLOOKUP or HLOOKUP Formula Does Not Work

21
by Patrick G. Matthews


Introduction

VLOOKUP is a tremendously useful function …
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.
Video
Video
Video
Troubleshooting Solution

Display if item is new

bybfuchs
18

Hi Experts,

I have a list of items which contains many duplicates.

List consists of ASIN's and many

Post

Once upon a time at a core conference this …

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

WIn 11 - How to recover Documents folder that disappeared?

50

Yesterday, I was researching a question (

Article

Another Conditional Formatting Trick In Excel

Have you ever wanted to make your MS Excel spreadsheet more easy to follow? Here is one way to do just that.
Video
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

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more