Getting Started with Excel
Formulas and Functions
Charts and Graphs
Tips & Tricks
Programming with VBA
Date and Time Functions
Lookup and Reference Functions
Math and Trigonometry Functions
User Defined Functions
How to disable “There’s already data here. Do you want to replace it?” warning
When you drag any cell with data and drop it on any other cell with data, you will get the warning, "There's...
7 months ago
Excel VBA: How To Remove Document Inspector Warning Include Personal Information
You may get warning message about the Document Inspector when you want to save Excel file. Is there a script can remove...
9 months ago
The ‘Microsoft.Jet.OLEDB.4.0’ provider is not registered on the local machine
For example, you have a 32-bit application (VBA, web app...) that uses the Microsoft OLE DB Provider for Jet. If you migrate...
4 years ago
Microsoft Query Error: “This data source contains no visible tables.”
When you import data by using the Microsoft Query Wizard and choose Excel Files as data source, you may receive the following...
5 years ago
How To Correct Excel Formula Errors
This post teaches you how to correct Excel formula errors. Correct common errors in formulas Start every function with the equal sign...
6 years ago