Insert Data from Excel to SQL Server - Excel tutorial

Category: Excel tutorials > Macros - Difficulty:

A pivot table is a great reporting tool that sorts and sums independent of the original data layout in the spreadsheet and VBA (Visual Basic for Application) is a very powerful macro language...

The EOMONTH (end of month) function allows you to generate a month end date no matter what the original date (even taking into account leap years). Extremely useful when you want to report on standardized dates.

Although cell numbers are at the foundation of everything Excel does, it's much easier to remember names, such as Item Number and Quantity, than it is to remember cell numbers, such as A1:A100. Excel makes this easy by naming it to your desired name.

The watch window allows you to continuously view cells that interest you (no matter where they are on the spreadsheet) while making changes to inputs in the model.

Tutorial videos for self learning the vlookup function, whether using it for finding an exact match in a table, or a close match.