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

Expert Spotlight
Software Developer

A person who never made a mistake never tried anything new.
- Albert Einstein

FORTIS FORTUNA ADIUVAT
SI VIS PACEM PARA BELLUM

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
Tutorials
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
Save and Restore your Recent Documents Lists

Backup and Restore "Recent Documents" entries in Microsoft Office Apps

5
Depending on the things you do with Microsoft Office, you can sometimes inadvertently lose your recent document lists in apps such as Microsoft Word and Excel. This article shows you how to back up and restore those lists when necessary. Enjoy...
Troubleshooting Solution

4N Count  by week

97
4N wDD wGTWK
29217947c.xlsb

1- count Range by DAY INcrement by WEEk

  a-Begings in MON AM then add MON …
Article

Getting your EE Ranking statistics in Excel

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

4N R  Count increments  by DAY

89
4N KwP  add  R increments
29217266a.xlsb

as we did here but now for  this file
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

4N Count By each Section

72
4N by play (eachone)
29216539 (2)_4N_to_add_COunt_byPLAY.xlsm

1- Sheet "BYPLAY" will be the output

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

How to !SPILL a CSV string?

72
So I have a comma separated string like say a,b,c,d,e,f,g,h,1,2,3,4

Is there a way to make this …
Troubleshooting Solution

Find location 4N TOPWK

79
4N CAL LOCATION
4n_cal_location_full.xlsx

identify the location by Column
as shown

 
Post

Once upon a time at a core conference this …

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

Excel (Beta) 365 for Mac: How to repeat headings at each change of pivot table first field?

54
Repeat per new page is offered.What about repeat headers when the first pivot table field changes?

Troubleshooting Solution

Link excel field to find and open a PDF file with the field value in the filename.

34
I have an Excel table built with a data connection to a folder. Works great, updates as files are …
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

Ideas how to document complex Excel formulas?

26
Hi. I just lost a couple of weeks because one of my formulas was not documented and I forgot a basic …

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more