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
John TsioumprisSoftware & Systems Engineer

I am passionate software developer and also a competent Systems administrator.I enjoy learning new things and challenges...

Video
Medical Info my app made with Microsoft Powerapps

Medical Info my app made with Microsoft Powerapps

Wanting to help people keep track of which doctors/specialists they need to see, upcoming visits, …
Video
ArticlesVideosEE: Download statistics on Experts Exchange Articles and Videos - Demo of Enhancements

ArticlesVideosEE: Download statistics on Experts Exchange Articles and Videos - Demo of Enhancements

2019-06-132
My 100th publication here at Experts Exchange is an article that presents a program called
Video
How to download number of Views, Endorsements, Points for Experts Exchange Articles and Videos--Demo

How to download number of Views, Endorsements, Points for Experts Exchange Articles and Videos--Demo

2019-06-073
My 100th publication here at Experts Exchange is an article that presents a program called
Video
Shuffle - 4 - Append Query

Shuffle - 4 - Append Query

We have a Totals query, and change it to an Append Query, so we can use it to add records. Create an…
Video
Shuffle - 3 - Table Design

Shuffle - 3 - Table Design

We are going on a deep dive to the foundation of data structure -- what is in the  design view of a …
Video
Shuffle - 2 - Totals Query

Shuffle - 2 - Totals Query

Data was imported into Access from Excel. In part 1, we examined it, and learned how to do a few …
Video
Shuffle - 1 - Examine Data in Access that was imported from Excel

Shuffle - 1 - Examine Data in Access that was imported from Excel

Examine data that was imported from Excel. Filter data in Access just like you do in Excel, for just…
Video
import an Excel spreadsheet into an Access database

import an Excel spreadsheet into an Access database

Learn how to Import data from Excel into a Microsoft Access database using the wizard. Change data …
Video
How to replace or substitute data in Excel

How to replace or substitute data in Excel

2019-04-12
Functions for replacing and substituting data in Microsoft Excel.
Video
How to move data between Excel and Airtable

How to move data between Excel and Airtable

2019-04-12
Airtable is an online database application that's great for small and medium-sized companies. This …
Video
Create Dropdown menus in Excel 2016

Create Dropdown menus in Excel 2016

2019-03-14
This video takes you through the steps to create dropdown validation menus in an excel spreadsheet. …
Video
Wrapper-2, VBA.  Show result of Excel Worksheet Function in Access Query

Wrapper-2, VBA.  Show result of Excel Worksheet Function in Access Query

A query can call a function, and a function can call Excel, even though we are in Access. This is …
Video
How To Insert Foreign and Special Characters when in Windows Applications

How To Insert Foreign and Special Characters when in Windows Applications

Enter Foreign and Special Characters

Enter characters you can't find on a keyboard using …
Video
How to Add a "Save As" icon to the Quick Access Toolbar

How to Add a "Save As" icon to the Quick Access Toolbar

How can you see what you are working on when you want to see it while you to save a copy?

Add a …
Video
Enumerating Prime Numbers in Excel / VBA

Enumerating Prime Numbers in Excel / VBA

2017-02-20
Finds all prime numbers in a range requested and places them in a public primes() array. I've …
Video
Binomial Distribution

Binomial Distribution

2017-02-16
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution …
Video
How to use the IF function in Excel

How to use the IF function in Excel

2017-01-181
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns …
Video
Using, Creating and Modifying Styles in Microsoft Excel

Using, Creating and Modifying Styles in Microsoft Excel

2016-09-011
Excel styles will make formatting consistent and let you apply and change formatting faster. In this…
Video
How to tell Microsoft Office that a word is NOT spelled correctly

How to tell Microsoft Office that a word is NOT spelled correctly

2016-01-064
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT
Video
Excel Error Handling Part 3 -- Run and Fix Bugs

Excel Error Handling Part 3 -- Run and Fix Bugs

This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written …

Do more with Experts Exchange.


Get Answers

Take a Class

Collaborate

Monitor your Site

Explore solutions and more