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

Expert Spotlight
Engineer

I am a civil engineer by profession and working in the field of water resources engineering as a structural engineer.

I have used Microso

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

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

Not new but useful  Find the Last Occurrence of a Lookup …

Not new but useful

Find the Last Occurrence of a Lookup Value a List in Excel
Article

Revitalise colours in the VB editor

The colour setting for coding in the VB editor (VBE) of Microsoft Office is a left-over from a past century. Here is how - with a few steps - to bring new life to the ancient editor.
Article

Indian number formatting of Currency in Microsoft Access and Excel

The Indian number format for currency has groups of two and three digits. The native Format function of VBA cannot handle this if Windows is set for a Western localisation. Thus, a custom method must be applied. Here it will be shown how to use dynamic formatting to accomplish this.
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.
Article
Text list in Excel

How to generate a list of sample text using Excel

Do you ever need to generate a column of sample text? Do it in Excel pretty quickly.
Troubleshooting Solution

Find location 4N TOPWK

79
4N CAL LOCATION
4n_cal_location_full.xlsx

identify the location by Column
as shown

 
Article

Distribute Hours Evenly Between Two Dates

Recently I have answered a question on how to distribute hours evenly between two dates. I thought this isn't that difficult to do that in Excel with formula, but what I see from this question, it could be applied to other similar scenarios. So, let's try and see what could we do here.
Post

Once upon a time at a core conference this …

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

Need help converting  excel xlsm to xls

byMelbut
44
Experts,

I need help automatically converting my current xlsm workbook into a new xls workbook and …
Troubleshooting Solution

find location 3N TOP

54
topcal
identify the position as i enter the number
as a 3N number is enter

TOP_CAL_.xlsx

Troubleshooting Solution

excel cannot complete this task with available resources

bymcrmg
78
Hi,

I use Powershell to combine about 900 csv files then convert to an Excel file. It has been fine …

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more