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.

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

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.
Article
spreadsheet with rules

Creating An On/Off Switch For Conditional Formatting In Excel

Often times what you may consider better indicators of various items, others do not. It is always a good idea to have a way to turn off conditional formatting in whatever program is displaying it. The most obvious I will use here - MS Excel.
Article

The Power Query Editor

A while back I wrote an article about the Power Query Editor and PowerBI (https://www.experts-exchange.com/articles/37938/PowerBI-and-the-Query-Editor-Save-time.html). I have realized that my coworkers primarily use Excel and So have changed the article to include excel. The result is below and is
Article

Easy Ways to do Hard Things

1
When adding new VBA features to a workbook, some parts may be difficult but you struggle through it because it's important to you or to someone you're helping. During that struggle you may say to yourself that "I wish I could find an easier way". Hopefully this article will help you do that.
Article

Modern Active Directory part 2/2

This document presents the Modern Active Directory project, which aims to bring a more modern view on your Active Directory, whether to view key indicators or to perform advanced searches in a simple way. With this PowerShell module that accesses your Active Directory in read-only mode, ...
Article

Excel formula name translator: Spanish - English and English - Spanish

Excel formula name translator: Spanish - English and English - Spanish and work in both languages
Article

Microsoft Power FX

Microsoft Power FX new low code language based in Excel formulas
Article

Curious Excel Facts List

On the official Microsoft website we can find out curious data about Excel. In this post, I will tell you about the ones that have caught my attention the most.
Article

Encryption in VBA using the Microsoft NG Cryptography (CNG) API

This article series will show you how to utilise the Next Generation Cryptography (CNG) API from Microsoft for modern hashing and encrypting/decrypting in VBA. In this part: Encryption.
Article

Hashing in VBA using the Microsoft NG Cryptography (CNG) API

This article series will show you how to utilise the Next Generation Cryptography (CNG) API from Microsoft for modern hashing and encrypting/decrypting in VBA. In this part: Hashing.
Article

Storing encrypted data in Microsoft Access

This article series will show you how to utilise the Next Generation Cryptography (CNG) API from Microsoft for modern hashing and encrypting/decrypting in VBA. In this part: Storing hashed or encrypted data.
Article

Storing passwords in VBA using the Microsoft NG Cryptography (CNG) API

This article series will show you how to utilise the Next Generation Cryptography (CNG) API from Microsoft for modern hashing and encrypting/decrypting in VBA. In this part: Handling passwords.
Article

Utilise Microsoft's Next Generation Cryptography (CNG) API in VBA

2
This article series will show you how to utilise the Next Generation Cryptography (CNG) API from Microsoft for modern hashing and encrypting/decrypting in VBA. In this part: Compatible with other environments.
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...
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

Handle Archive Files and Folders With VBA the Windows Explorer Way

Windows Explorer lets you open archive (tar and tgz) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating archive files takes a little more - and that you'll find here.
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.
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.

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more