Getting VBA Installed
Setting up VBA does not require any special software installation. The VBA development software is included with each package of the Microsoft Office suite of programs, including Excel.
Writing Your First Macro
We will write and run our first simple Macro, just to have a feel of how it looks like. What our first macro will do is simple. It will ask for your name, put the name in one of the Cells and change t...
Drop Down Lists – Select Custom Inputs
Drop Down lists are nice to use if you want to force a user to select data from fixed data items and prevent that user from entering custom data. How to add drop down list for any cell in Excel is sho...
Finding and Removing Duplicates in Excel
Sometimes it`s only after you`ve got all your data entered that you realize – you don`t need so many duplicates. Or during proofreading, perhaps you made the same error over and over again. Here`s how...
Make a Random Number Generator in Excel
There are a few different ways to turn an Excel spreadsheet into a random number generator using simple functions and VBA.
How to Export Emails from Outlook to Excel
Simple way to export emails from Microsoft Outlook into an Excel spreadsheet.
Managing Projects with MS Project and Microsoft Excel
Are you a project manager? If so, learning how to use Microsoft`s Excel and MS Project can be pivotal to your success.
Excel Gantt Chart
This Excel tutorial showcases how to create a Gantt chart.
Excel Countif and Sumif
Great Excel function tutorial covering Count, CountIf, Sum, SumIf, and SumProduct.
Excel has a clever and handy tool called solver that helps you find optimal solutions for many decision-based problems in your spreadsheets.