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
  • 139K Content
  • 12K Contributors

Expert Spotlight
Brian BEE Topic Advisor, Independent Technology Professional

From 1 man shop/outsourced IT to large multi-national. Manufacturing, non profit, development, consulting, I have been there for them all.

Article

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

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

Add Security Protections for Data Extraction

The Get & Transform Data Wizard in Excel is a powerful tool. It allows the users to extract the data from the connected sources. But by delegating the privilege to users to access the connected sources, how could we ensure there is at least some degree of security is in place?
Article

Getting your EE Ranking statistics in Excel

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

Truly Random Numbers in VBA

6
Pseudo random numbers are right at hand in VBA. Obtaining truly random numbers, however, requires an external source. One is the Swiss Quantis QRNG Chip. The output from one of these has been made public by ETH Zürich, and here we present a complete solution for retrieval of random numbers in VBA.
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

A matter of highlighting in Excel

1
I have seen some great articles online relating to how can we highlight a cell or range of cells based on certain criteria, whether it's using simple conditional formatting or with the help of macro scripts. In this article, I discuss some of these implementations.
Video
Troubleshooting Solution

How to edit 2 cell fields in multiple excel files in a folder/subfolders automatically using VBA based on starting name of file

45
How to edit 2 cell fields in multiple excel files in a folder/subfolders automatically using VBA …
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.
Troubleshooting Solution

Need to create multiple dependent drop-down lists in Excel based on selections and another sheet.

36
I have an Excel document where I need to create multiple dependent drop-down lists in Excel specific…
Troubleshooting Solution

Display Duplicate Data with RGB Colors

byCook09
52
I have a large amount of data, >800,000 rows, with duplicates in the combined data from both column …
Troubleshooting Solution

What is the VB code so that  I can declare a variable when I open a spreadsheet that can be used in any module and sub routine?

byf19l
19
Hello, I have multiple spreadsheets that I use each day and I would like to know how I declare a …
Troubleshooting Solution

How to make Code more efficient

byCook09
31
How is the best way to optimize the code below? It'll work but takes a very long time in doing so.
Troubleshooting Solution

Excel Zone Expert Discussion, Number 37

bybyundt
185
This thread is for general discussion about all things related to the Excel TA and its experts. Both…
Troubleshooting Solution

Fill Holiday column automatically. Approach, methods to use?

byNVIT
30
Hi Experts,

See images.

I need to automatically fill in holidays in a timesheet worksheet

Based …
Post

Once upon a time at a core conference this …

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

Extract measurements from product descriptions

26
Dear Experts,

I need to extract substrings (measurements) from thousands of product descriptions. …

Do more with Experts Exchange.


Get Answers

Take a Class

Collaborate

Monitor your Site

Explore solutions and more