Welcome to Excel Tip.com!
Excel Tip.com has been developed to help both professionals and students to learn and develop their MS-excel skills.
We at Excel Tip assist you in creating interactive spreadsheets for making calculations, performing reconciliations and maintaining employee reports, creating "pivot tables" for data management, auto-filter to sort records, V and H-Lookups for data sorting and much more.
At Excel Tip you can get in touch with the best Excel consultants who are experts in providing personalised solutions for all your business applications.Keep coming back for "Tip of the Hour" or submit a favourite tip that you think will be of help to other users!
- Using Loops in VBA in Microsoft Excel (2242914 views)
- Create User Forms in Microsoft Excel (1685661 views)
- The Best Shortcut Keys in Microsoft Excel (1347945 views)
- Writing Your First VBA Function in Excel (1210616 views)
- Formulas to calculate Loan payments in Microsoft Excel (910439 views)
- Array variables using VBA in Microsoft Excel (854117 views)
- Converting Time to Decimal Values (561368 views)
- Add Combo Box to a Sheet in Microsoft Excel (527244 views)
- Calculate Years, Months, Days elapsed from a certain date in Microsoft Excel (489706 views)
- Square root and cube root in Microsoft Excel
(475625 views)
- Use messageboxes using VBA in Microsoft Excel (462894 views)
- Calculating Number of Days, Weeks, Months and Years between Dates (421787 views)
- Delete rows and columns using VBA in Microsoft Excel
(403852 views)
- Deleting Empty Rows (399451 views)
- Working Out a Person's Age in Microsoft Excel (383306 views)
- Compare two worksheets using VBA in Microsoft Excel (374925 views)
- Close a workbook using VBA in Microsoft Excel (372819 views)
- Import data from Access to Excel (ADO) using VBA in Microsoft Excel (370492 views)
- PivotTable report - Adding a Calculated Field (354125 views)
- Create an Amortization Schedule in Microsoft Excel (353829 views)
- Combine the VLookup and Match formulas in Microsoft Excel (342674 views)
- Combining Text from Different Cells (306075 views)
- Delete sheets without confirmation prompts using VBA in Microsoft Excel (279830 views)
- Find duplicates items in combine columns in Microsoft Excel (270454 views)
- Vlookup Formula – Organizing the Data Table (264019 views)
Advanced Tip Finder
Tips
Excel Keyboard Shortcuts |
Excel Customizing |
Excel Tools |
Excel Worksheet, Workbook | Excel Range Name |
Excel Information |
Excel Security - Protection | Excel Printing |
Excel Chart |
Excel 2003 |
Excel Style |
Working with Formulas |
Links between Worksheet and Workbooks | Summing |
Counting |
Excel Array Formulas |
Excel Financial Formulas | Excel Date & Time Formulas |
Lookup Formulas |
Database Formulas |
Excel Text Formulas |
Logical Formulas |
Information Formulas |
Other Q&A Formulas |
Excel Importing Text Files | Excel Sorting |
Excel Filter |
Excel Subtotals |
Excel Grouping and Outlining | Excel Consolidating |
Excel Pivot Tables |
Table - Excel 2007 |
General Topics in VBA |
Files, Workbook, and Worksheets in VBA |
Cells, Ranges, Rows, and Columns in VBA |
Menus, Toolbars, Status bar in VBA |
User Forms, Input boxes in VBA |
Events in VBA |
Formating in VBA |
Date & Time in VBA |
Printing in VBA |
Mail - Send and Receive in VBA | Custom Functions in VBA | Import and Export in VBA |
Database in VBA |
Protecting in VBA |
Links in VBA | Applications - Word, Outlook in VBA |
Add-In in VBA |
Modules, Class Modules in VBA |
Using Loops
Tips by Categories
Excel General|
Excel Text,
Editing and
Format|
Excel Date and
Time |
Excel Formula and
Function|
Excel Data|
Excel Macros and VBA
VBA Tips
Keyboard & Other Shortcuts in VBA |
General Topics in VBA |
Files, Workbook, and Worksheets in VBA |
Cells, Ranges, Rows, and Columns in VBA |
Menus, Toolbars, Status bar in VBA |
User Forms, Input boxes in VBA |
Events in VBA |
Formating in VBA |
Date & Time in VBA |
Printing in VBA |
Mail - Send and Receive in VBA |
Custom Functions in VBA | Import and Export in VBA |
Database in VBA |
Protecting in VBA |
Links in VBA |
Applications - Word, Outlook in VBA | Add-In in VBA |
Modules, Class Modules in VBA |
Using Loops
iYogi Solution